Aggregation DSO

[aditya_bakshi]

Data in PSA

PO	Condition Type	Cond.Cate.	Value	Quan
480000000	ABC	B	20,000.00	500
480000000	ABC	B

Feeding this data in Stand.DSO.

Need to aggregate same condition type data.Cant make Key Figure as Summation as other data will be affected.

Final data should like this.

480000000

ABC

B

20,000.00

500

Please advice.

[Former Member · Accepted solution]

• My opinion:

  1. Use "Overwrite" instead of "Summation".

  2. Map the ROCANCEL field.

  3. Make sure your DSO Key Fields are defined correctly

  4. In case you have ABAP code on DataSource enhancements or Start/End/Transformations/etc Routines, make sure the After/Before/Reverse images arrive in the correct order (when using the SORT command the original sequence can be affected).

  5. Delete the contents of the PSA/DSO.

  6. Reload the PSA, and afterwards reload the DSO.

  Regards,

[KodandaPani_KV]

HI,

create the another KF Value and make it summation.

put the PO,condition type, condition category in key fields place.

load the data into DSO -> check the out put of the DSO values.

in DSO based on the key fields it will overwrite or summation will work.

Thanks,

Phani.

[Former Member]

Make PO+Cond type+Cond Cat as key of the DSO. Then you need to put Valaue and Qant in summation mode,(I suspect there could be any other way).

Rgds..

Shambhu

[Former Member]

Hi Aditya,

Please be clear on your Question.

will PO number dependent on condition type?

Thanks,

raja

[aditya_bakshi]

Yes.PO number is dependant on Condition Type.