cancel
Showing results for 
Search instead for 
Did you mean: 

Change logs for primary key's in DSO

venkat_korivi
Participant
0 Kudos
159

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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?

venkat_korivi
Participant
0 Kudos

Hi Jyothi,

We do not have any field like that... all fields are key fields.

Thanks

Former Member
0 Kudos

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.

venkat_korivi
Participant
0 Kudos

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

Former Member
0 Kudos

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

Answers (0)