Skip to Content

creating a custom extractor instead of 2lis_11 datasources for ORDER INTAKE report?

Hi guys,

I'm wondering if you already tried to create a custom extractor for ORDER INTAKE reports instead of using the standard 2LIS_11 datasources? Because I think all the 2LIS_11 and 2LIS_13 datasources have DELTA problems so we are planning to just create a custom extractor. What tables did you use for this report? Did you create a VIEW for the tables needed? What delta field did you use?

Thank you.

Loed

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 6 days ago

    Hi Loed,

    To find information about the source tables, Google "sap sd tables".

    Re-creating a delta extractors for LIS is very difficult. If you research them, you will learn of the V3 update process which updates the underlying SD tables. There are Creation Date and Changed Date fields in the header and item tables , but they are not always updated by the V3 process. Status changes are not captured in the SD tables. The CDHDR and CDPOS do capture the data entry changes to SD documents, but can be very difficult to decompose.

    When faced with a similar problem to recreate 2LIS_11_VAITM Sales order a item, create a view using VBAP in a view as the central table, with two full, separate searches against the past seven days on both the Creation Date and the Change Date. This captured most changes. If the time frame is expanded to exceed the maximum processing time for a sales order, then the status changes can also be captured.

    I hope this helps,

    John Hawk

    Add comment
    10|10000 characters needed characters exceeded