+7Hi, we have a requirement to restrict extraction of purchase orders to last 2 years.
We are planning to go ahead with ERDAT from EKKO table. But what about other tables like T*, CDHDR and the rest. How can we restrict data extraction in those tables? Also, How can we make EKKO as a parent table to consider the extraction of the rest of the tables based on the data from parent table like EKBE-EBELN = EKKO-EBELN?
Best answer by guillermo.gost12
Not exactly with SAP tables, but we had a similar problem.
You can restrict the main tables using a date filter, then use join's for the rest of the tables, so you will only update those records related to the main tables.
HTH
Not exactly with SAP tables, but we had a similar problem.
You can restrict the main tables using a date filter, then use join's for the rest of the tables, so you will only update those records related to the main tables.
HTH
+1Hello @deepti.gandh , I would recommend to complete the enablement / training from Celonis especially https://academy.celonis.com/pages/category-it-data-engineering and https://academy.celonis.com/pages/category-asset-building. Both course will help you understand Celonis better.
Then with your question, if you can identify the date filter, you can set them link with variable at data pool parameters.
+7Not exactly with SAP tables, but we had a similar problem.
You can restrict the main tables using a date filter, then use join's for the rest of the tables, so you will only update those records related to the main tables.
HTH
Ya got it. .thank you
+7Hello @deepti.gandh , I would recommend to complete the enablement / training from Celonis especially https://academy.celonis.com/pages/category-it-data-engineering and https://academy.celonis.com/pages/category-asset-building. Both course will help you understand Celonis better.
Then with your question, if you can identify the date filter, you can set them link with variable at data pool parameters.
Will definitely considering going through them. .Thank You..
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
