Skip to Content
0
Dec 17, 2018 at 06:17 AM

Semantic key for data load to advanced dso

235 Views Last edit Dec 15, 2018 at 08:35 AM 2 rev

Hi Experts,

would like to know how semantic key from DTP will works while delta processing load to ADSO (as a standard DSO).

I have Keyfileds Sales Document, Item, Schedule line, Delivery Number and Delivery Item. and the keyfigures Req_qty, conf_qty and Dlv_qty are aggregation type as Summation in transformation.

The Transformation code it has written to sort based on above five fileds.

but the data source that is passing values based Sales Document, Item and schedule line via extractor 2LIS_11_V_SSL.

semantic key we used as Sales order, Item and schedule lines observing the data from odqmon even though the data for a sales order shows in one request, but when extracting data to BW in delta data loads working like as full and each delta status field is getting changed (even the staus showing in S4 as completed) with keyfigure values are getting cumulating and showing too much of values and not able to reconcile with S4

understand that keyfigure overwrite property in transformation can help to fix the issue for keyfigure values, but is it also fixes the status filed in the ADSO? please help in this.