Material document and CO / accounting documents

[Former Member]

Dear Experts,

I am looking for a direct link between material document and financial documents (accounting and CO documents that are shown upon pressing FI documents button in MIGO).

The table name will be most useful.

Regards,

Aroop

[Former Member · Accepted solution]

i think u looking the link between MIGO material doc and accounting doc of same migo

you will get material document header in MKPF say its 5000012051and year 2010

now go in table BKPF and put 50000120512010 adding doc number and year and put it in Reference Key BKPF-AWKEY

you will get Accounting document number

as u have material doc header and Acc doc header u can find details of item leve in MSEG and BSEG

hope this helps

[Former Member · Accepted solution]

Thanks for the info. You are right, I am looking for this link. However, I am more interested in the link between material doc and CO document. Any inputs on this?

Regards,

Aroop

[Former Member · Accepted solution]

COBK id table u can find the link

put the Material doc number in Ref Document Number COBK-REFBN

hope this helps

[Former Member]

Thanks Umakant for your inputs.

[Former Member]

Hi,

There is no direct table for material and fi documents. Use BKPF table and take the doc.no and go to BSEG give the doc.no and get the debit/credit amount

[Former Member]

Hi,

Check MKPF and MSEG for material document related

Check BKPF and BSEG for Account document related.

Hope this helps.

Raj

Edited by: Raj on May 3, 2010 3:08 PM

[Former Member]

Hi

Check Table BSEG