ABAP routine to populate key figures from another ODS

35 Views

HI all,

I have GL ODS and Purchasing ODS . our requirement is

GL Account doc Number , Amount, PO , PO Line ,PO Amount in one report. I have created infoset with GL and PO data tagets but I am getting

PO PO LIne POAMT ACCT DOC AMOUNT

1234 10 4000 33333 1000

- 10 4000 44444 2000

- 10 4000 55555 1000

actully we want the report folowing format

PO PO LIne POAMT ACCT DOC AMOUNT

1234 10 4000 33333 1000

- - - 44444 2000

- - - 55555 1000

I tried almost all methods in query designer to eliminate reating values but no luck.

PO Line item has multiple invoices thats why infoset repeating po amount at each invoice level . so I am planning to write abap routine in GL ods update rule to read po ods net price.

but I don"t know how to write abap program if po line item has multiple invoices.

I have PO and Line item in GL ods .

Appriciate your response

Thanks

Rohan