How to get the Accounting document against Material document in SAP?

Requirement: Business has the requirement to get the list of Accounting documents against respective Material document(s). As we aware that whenever a Goods movement happens, a material document and accounting document will be generated automatically.

Solution:

In this document, I have explained the process of getting Accounting documents from Material documents with screen shots.

Important Table and Fields which are used in this document

Table – BKPF – Accounting Document Header

Input Screen:

Input Fields – AWTYP– Reference Transaction. As we are giving Material document as input, reference transaction has to be given as MKPF (This field is an optional. You can pass only AWKEY to get the output because AWTYP will vary among the transactions)

AWKEY – Reference Key. Reference key has to be given the combination of Material document+Material document Year ( MBLNR+MJAHR). While givin the material document, you have to give the total number length (here it is 10)

Output screen:

Important Output field: BELNR- Accounting Document Number

Thanks for reading. I hope this document is helpful for you. Share the Blog with your friends in social network.

Like this:

Related

Published by ganeshsapmmwm

I did Post Graduation in Organic Chemistry. I have more than 7 years of SAP consulting experience in SAP MM, WM and SRM modules. I did 5 End to End Implementations, 4 Roll outs and 2 Support projects.
View all posts by ganeshsapmmwm

11 thoughts on “How to get the Accounting document against Material document in SAP?”

Woah! I’m really loving the template/theme of this blog.
It’s simple, yet effective. A lot of times it’s difficult to get
that “perfect balance” between usability and visual appeal.
I must say that you’ve done a amazing job with this.
Also, the blog loads super quick for me on Chrome.
Superb Blog!