Better approach to do Delta for MARC Table - Material Plant

dataservices sap-erp-bw
1

Hi

We are having hard time doing a Delta load for the MARC table. There is not really a Delta column in MARC (Material Plant) by itself, rather it is actually available in MARA (Material Master)

So we join MARC with MARA based on MATNR (Material Number) with delta columns of ERSDA (Created On) and LAEDA (Date of Last Change)

With our MARA almost a Million records now, the ABAP Program is running in time ranges all over the board! Like from few minutes to sometime more than an hour and it takes that amount of time for a Delta of few hundreds only… :crazy_face:

Is there any smart way to handle this?

EDIT: Is there any good way to have fix on ECC side that will make this ABAP perform better?

NOTE: I also confirm that 99% of time is taken to run and complete that ABAP Program and not the DS job

ganeshxp :us: (BOB member since 2008-07-17)

2

It depends… :mrgreen:

How long does a full load take? Sometimes a full load from SAP is faster! Especially for master data tables.

Are there SAP indexes on create and change date? Is there a possiblity to have those placed?

Investigate joing against SAP change table CDHDR with OBJECTCLASS = ‘MATERIAL’.

By the way, about how many plants is this? I heard last week about a customer with 19.000 plants, imagine multiplying that by the amount of materials…

Johannes Vink :netherlands: (BOB member since 2012-03-20)