Data loading from Schedule Line DSO to Order Item DSO issue

[abhimanyu_sharma]

Hi Team,

I have an issue in data loading to DSO - DSD_SO. The DSO - DSD_SO is getting data from 2 Sources - 2LIS_11_VAITM and DSD_SCL (2LIS_11_SCL- Schedule Line).

Now, as we know users can delete the schedule line in ECC, hence the deleted records are getting deleted from DSD_SCL but the records are still present in DSD_SO.

For Example : DSD_SO

Doc_Number Doc_Item Quantity Schedule Date

100 10 100 01/01/2017

100 20 50 02/01/2017

100 30 50 03/01/2017

Document 100 and Item 30 gets deleted from 2LIS_11_SCL and hence it gets deleted from DSO DSD_SCL (due to record mode) but the records 100 with item 30 still remains in DSD_SO DSO.

Could you please let me know how can we delete the schedule line records from DSD_SO DSO ?

Thanks,

Abhimanyu Sharma.

[former_member186445]

you should not combine the two datasources in the same dso. there are some options. you can have seperate flows for both sources and combine in a multiprovider. or, which is done often, load both sources each in a seperate dso. in transformation of the schedule line dso, read the necessary fields from the sales order dso.