Update ODS from 2LIS_02_SCL - Deletion flag

[Former Member]

Hello,

We face some problems when updating an ODS from 2LIS_02_SCL.

The deletion flag seems not to be set correctly.

Our goal is to keep the deleted items in the ODS.

But how to set 0RECORDMODE and STORNO correcty in order to update the ODS in the good way.

Sometimes after an update we receive 2 records, one with STORNO=X and a other with STORNO=SPACE.

I know that this field is used as before or after image in some case.But i need more help to clear the process.

Thanks

Christophe

[Former Member · Accepted solution]

Hi,

if an PO item gets deleted the ROCANCEL field is set to R. If this is mapped to 0RECORDMODE, the line will be deleted from the ODS. If you change this value from 'R' to ' ' in the start routine, the record will stay. You can map ROCANCEL also to 0STORNO (without removing the R) as you can then use this to indentify those records.

Hope it helps.

Stefan

[Former Member · Accepted solution]

Yes but we receive 2 records the old one and the new one, how to process in order to just set the annulation flag ? In fact keep the record containing STORNO = X

THE RECORD CONTAINING STORNO = X ALWAYS ARRIVE BEFORE THE RECORD HAVING STORNO= SPACE

Our ODS is in overwrite mode, so must we delete some records ?

Christophe

Edited by: Christophe COURBOT on May 25, 2009 5:24 PM

[Former Member · Accepted solution]

Hi,

If data loading into and ODS in overwrite mode, instead of mapping ROCANCEL to 0RECORDMODE, Just write a simple code at start routine to clear keyfigure values/qty if ROCANCEL is "R" or"X".

This way you can keep deleted records from source, with keyfigure values as Zero's.

Datasource - 2LIS_02_SCL delta: ABR u2013 Complete delta update with deletion indicator using delta queue (Cube-compatible).

ROCANCEL u2013 Cancellation of Data Record

This field can contain the following values:

· u2018blanku2018 u2013 New data record

· u2018Xu2019 u2013 Cancellation of data record

· u2018Ru2019 u2013 Deletion of data record

For more information, see SAP Note 578471: Deleted Items in BW and Statistics

Check: Purchasing Data (Schedule Line Level)

Srini

[Former Member · Accepted solution]

Thanks but a topics stay not clear :

In witch case the system send a X or R in ROCANCEL?

X is used when a record is updated ? can you confirm it please ?

For R the behaviour of the system is not very clear.

If a PO item has LOEKZ set to L or S what is the behaviour of the extractor ?

The record will be deleted in the target DSO or not ?

Thank you very much

[mansi_dandavate · Accepted solution]

Hi,

X stands for Before image. and R for reverse image.

If your extractor's delta is of ABR type then whenever a record is deleted in the source then it will send a reverse image i.e. R.

The record with Reverse image will have all the key figures as negative. SO it wont delete the record from DSO but it will nullify all the key figures to 0.

Edited by: mansi dandavate on May 27, 2009 10:22 AM