Iniaitlize Delta when there are invalid records

[yasemin_kilinc]

Hi everybody,

I have a problem while initializing the delta for 0MATERIAL characteristic. The data comes to the PSA. But some of the records are marked as incorrect in the PSA due to invalid characters at 0MATERIAL characteristic. So the status is red and delta is not initialized. I corrected the data in the PSA, and loaded it again, even if the status turned to green, at RSA7 transaction of R3 I see 0MAterial on the list but new created materials are not added to the queue. These incorrect materials are selected to be deleted at R3. But the system still sees them. Does anyone have any idea about how I can handle this situation.

[Former Member]

Hi,

Regarding to invalid character issue you can write a routine below in the general tab of the 0material infoobject.This code should fix your problem.

TRANSLATE RESULT TO UPPER CASE.

RETURNCODE = 0.

Also Did you try to load delta second times after new materials have been created.What is coming to BW side ?

Check the links and OSS notes below for delta queue in BI.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8bde9690-0201-0010-ed8e-8787eae2...

873694 - Consulting: Delta repeat and status in monitor/data target

771894 - No data during delta upload: Selection on Z* fields

723935 - Adding the TID display to the DeltaQueue monitor

691721 - Restoring lost data from a delta request

576896 - Checks when PSA contains incorrect data for delta requests

574601 - BW-SAPI: Endless loop when confirming qRFC LUWs

417307 - Extractor package size: Collective note for applications

417189 - BW/SAPLEINS - Online update of delta queue

405943 - Calling an InfoPackage in BW causes short dump

377732 - Collective SAP note SAP BW BCT 2.1C for EBP 2.0 and 3.0

505700 -Delta Extraction

Regards.

[Former Member]

materials are not deleted from MARA table completely, since in past they could have been used in data.

only deletion flag is set. ( LVORM).