Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to merge FI & MM data

Hi all

may be similiar threads are also present in sdn, but my question is very specific ,hence i hv posted it again

my requirement is to merge the data from MM & its corresponding FI data into a single record to display in the report.

eg.

FI doc PO CC CO PC MAT MG AMT INV

510000000 45000000 0030 4000 40001 # # 10000

510000000 45000000 # # # 100 200 10000

but i want to see this as

FI doc PO CC CO PC MAT MG AMT INV

510000000 45000000 0030 4000 40001 100 200 10000 100000

that is in a one single record & avoid the # .I did a lot of r&d , & tried a lot of stuffs , but none gave results yet.

i tried using an infoset over the 2 DSO's using join over FI doc no , FY & CC . here it was not picking up the few values, where my FI doc is not present (some rare cases ).

I tried infoset with outer join - here the results are same as above

I tried an DSO over this infoset , with FI doc, Inv no, PO , item no all in key fields. still results are same.

With multiprovider also , same results.

Is there any better way to do this. ?

or if change my key fields or the join conditions , do u think it can achieved ? (can u pls be specific with some eg fields)

Thanks

Ramesh

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question