Extract / Invoice Reader Normalize Masterdata - TPF
Question / Problem:
In the Extract and IR TPF for Transferring the Masterdata from SAP Cache to RefDB, the step Normalize Masterdata, can take up a lot of time. Especially with a lot of rows in EKKO and EKPO. SWE had this problem recently, the step took over 1 hour and 40 minutes to complete
Answer / Solution:
The culprit was the Delete statement for EKPO rows with no matching EKKO entry. I changed the three Delete Statements at the end of the step as follows:
DELETE FROM LFA1 WHERE SPERR <>'' OR LOEVM <> ''
DELETE FROM LFB1 WHERE SPERR <>'' OR LOEVM <> ''
DELETE FROM LFB1 WHERE FRGRP <>'MFL1'
UPDATE LFA1 SET LIFNR = RIGHT(N'0000000000'+LIFNR,10)
UPDATE LFB1 SET LIFNR = RIGHT(N'0000000000'+LIFNR,10)
UPDATE LFBK SET LIFNR = RIGHT(N'0000000000'+LIFNR,10)
UPDATE EKKO SET LIFNR = RIGHT(N'0000000000'+LIFNR,10)
DELETE
FROM LFA1
WHERE NOT Exists (
SELECT 1
FROM LFB1
WHERE LFB1.LIFNR = LFA1.LIFNR
)
DELETE
FROM LFBK
WHERE NOT Exists (
SELECT 1
FROM LFA1
WHERE LFA1.LIFNR = LFBK.LIFNR
)
DELETE
FROM EKPO
WHERE NOT Exists (
SELECT 1
FROM EKKO
WHERE EKKO.EBELN = EKPO.EBELN
)
Now this step runs through in seconds.
Thanks to Ulrike Wingerath for this useful information.
Enter How to here:
- How to Step 1
- How to Step 2
- How to Step 3
Applies to:
Product | Version |
---|---|
eFlow | 5.x |