1 Reply Latest reply: May 17, 2012 2:50 PM by Anton Kuznetsov RSS

does it create any problem if i change aggregation type of kyf in dso???

Sap Bi devolper
Currently Being Moderated

Dear experts,

 

 

  in my support project we are loading  2lis_02_scl data to 0pur_c01 .for stagging purpose there is a custom dso .for most of the datafeilds(for kyf alone ) aggregation type "summation " been used . because this when i rerun full infopackage(from setup table ) to bring back missed po docu ,these records adding to existing docu insted of overwritting .

 

 

can you please tell me why they have used summation property ??

if there is no specific purpose can you please tell me what are precations supposed to take before change aggregation type in transformations???

 

DSO :

 

key fileds                    data fields (with summation alone )

po doc no                    po order val

line item no                  po qty

sched line no               gr qty & val

schedul date                 ir qty & val

                                   no of schedule line in po

 

ex:

po doc no      lineitem no schedu line no schedule date po-val   po-qty gr qty ir qty

45001111          10            1                     10.01.2011     1000    10      0       0

45001111          10            1                     12.01.2011      0          0      5        5

45001111           10           1                      16.01.2011      0         0      3         0

45001111          10            1                     23.01.2011       0          0     2         5

 

 

 

thanks in advance

harry

  • Re: does it create any problem if i change aggregation type of kyf in dso???
    Anton Kuznetsov
    Currently Being Moderated

    Hi.

     

    I think summation is used here because extractor push delta records. If you use overwrite - new delta will overwrite old data.

     

    Example: you have

    po doc no      lineitem no schedu line no schedule date po-val   po-qty gr qty ir qty

    45001111          10            1                     10.01.2011     1000    10      0       0

     

    If po-qty changes from 10 to 15 in source system, new record arrive

    po doc no      lineitem no schedu line no schedule date po-val   po-qty gr qty ir qty

    45001111          10            1                     10.01.2011     1000    5      0       0

     

    If you use overwrite, you get wrong data. Check this first. I'm not fully sure.

     

    And during full load you must first delete data from DSO. If you load all data - delete completely. If you load part - you can use selective delete.