ABAP routine - Transfer rules Start routine

[Former Member]

hello everyone,

i need some help in writin an ABAP code. Well the logic is say i have a table which sends data to BW. the data comes like :-

Order Q1

101 50

101 20

102 10

101 60

But i want to store only 1 value for each order , i.e summarize the value so in when the data package comes , i want to check all records for one order and add the qty value for each order and store it in the ODS.

so ODS for above eg should look like

Order qty

101 130

102 10

Thanks,

Will assign points to all helpful answers.

Laura.

[udayabhanupattabhiram_cha]

Hi:

If you add Order as the only Key FIELD in ODS and set the Key-figure Q1 to Aggregation, it will solve your problem. You don;t need additional code.

NOTE: If this is not the case, its not easy to write this in ABAP. because, you don't know whether all Orders (e.g., Order #101) will come in the same DATA PACKAGE. They might be split into two different DATA PACKAGES and your Start Routine will Execute ONLT ONE DATAPACKAGE at a time.

Chamarthy

Message was edited by:

Chamarthy

[Former Member]

If not the start routine as it access datapackage, you can as well go with transfer routine as it accesses data record by record. That way it doesnt matter if the same order doesnt fall into the same data package.