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