on 02-23-2007 2:27 PM
Hi
We have to use 2LIS_11_V_SSL & 2LIS_11_VASCL data sources for an ODS in BW. The quantity fields are inverted in R/3. 0RECORDMODE is mapped with ROCANCEL in transfer structure.
Can anyone please help me with the key figure updation mode , should it be addition or overwritten and why ?
Thanks & Regards,
Monika
Hi,
When we are using the DS 2LIS_11_V_SSL, A data record is uniquely determined via the five key fields Order Number, Item Number, Schedule Line Number, Delivery Number and Delivery Item Number.
But this type of issue is mot there with 2LIS_11_VASCL .So We have to remeber this thing when we are using both of the Ds to upload to a single ODS.
And Have you cross checked with PSA data to Identify the Place of problem?
And have you mapped those KFs in both Update rules of ODS?
With rgds,
Anil Kumar Sharma .P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It should be Addition.Because LO extractor gives the 2 records for a Modification for alredy uploaded document. One is - ve value with old value and + value with new value.So that it nullify the old value already there in the data target.
And these records may come in any order when we are uploading. So if we take overwrite as update method ,there is a chance of after image record is overwrriten by before image record.
With rgds,
Anil Kumar Sharma .P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
9 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.