Material Document and Accounting Document Tables Link

[mihaita123]

Hi there,

I need some help with a nissue.

I have a huge list of material documents and I want to retrieve the BELNR FI/CO field for each of them.

I cannot find a link between material document and accounting document.

Thank you.

[TammyPowlas · Accepted solution]

I recommend searching. Please see this thread: https://archive.sap.com/discussions/thread/737389

[mihaita123 · Accepted solution]

Hello,

I saw that post but I still cannot match lines of BSEG and MSEG.

It shows me no result.

Thank you.

[TammyPowlas · Accepted solution]

Maybe share some examples/screen shots? Are the MM documents goods receipt documents or invoice documents?

[mihaita123 · Accepted solution]

Hello Tammy,

I finally find a link between them.

The field AWKEY it`s the answer(I need to concatenate the material document number and the year).

After that I could find the accounting documents.

Thank you again.

[iklovski]

Hi,

Well, the link can be established in the way described in the thread (amongst many others), suggested by Tammy. When you say that you cannot match, can you be a bit more specific? Don't you see the values in BKPF/MKPF tables, which would allow to match between the documents?

Regards,

Eli

[mihaita123]

Hello Eli,

I found the answer(AWKEY).

It was a little tricky but I`ve found the link between them.

Regards,

Mihaita

[iklovski]

Good! Please, make sure to browse for an answer first, in the future. There is plenty of useful information already published on SAP community forums, just waiting to be picked 🙂