Skip to Content
author's profile photo Former Member
Former Member

Update ODS from 2LIS_02_SCL - Deletion flag


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.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 25, 2009 at 02:49 PM


    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.


    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.