on 2016 Aug 25 11:17 AM
Dear Experts
We have requirement like we need to load the data from KNVP table for only primary keys in the same table. We have around 6 fields.and i have maintained all these fields in key fields tab in standard DSO.. When i ran delta changes are not overwritten. RECORD MODE showing as "N" for all records (full + delta). But we have to overwrite the change/inserted fields. Kindly please let me know how to achieve this scenario
Thanks in Advance.
Hi,
We have requirement like we need to load the data from KNVP table for only primary keys in the same table.
when you just load only primary keys, how should data get overwritten ? I mean apart from the 6 key fields in DSO, does it has any data field?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
DSO works like this : when key fields are same, data fields gets overwritten.
you are just updating keyfields to DSO, then all of them gets updates as new records.
ex: prodcut variant ref prodcut qty
P1 V1 abc 10 - New record in DSO
P1 V1 def 15 - overwriteen record in dso
Note: P! and V1 are key fields.
so design you dso accordingly.
Yes you are right
But in my case we are designed DSO as per KNVP table..
we have requirement like
customer number sales org division distrchannel partner function cust.num of business partner
A1 B 10 20 AA A1
A1 B 10 20 AA B1
1.In the above example if we maintained all fields as key then every record will be a new records.
2. if we add "Customer num of business partner (KUNN2 is not a key in KNVP table) " in data fields tab in DSO then we will get only one record from above example.due duplicate of remaining 5 key fields.
Pl suggest us.
Thanks
if both records are fetched in one delta, then both treated as new records (because your data field is of type char), instead if you have numeric filed, it gets aggregated
cnumber sorg division distChannel partner function numeric
A1 B 10 20 AA 15
A1 B 10 20 AA 10
then it will be like this
cnumber sorg division distChannel partner function numeric
A1 B 10 20 AA 25
but if both records are from different DTP's, then it will be like this
cnumber sorg division distChannel partner function numeric
A1 B 10 20 AA 10
User | Count |
---|---|
71 | |
9 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.