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 FieldsAWTYP– 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)

BKPF Input Screen

 

Output screen: 

Important Output field:  BELNR-  Accounting Document Number

BKPF Output

 

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

 

Regards,

Ganesh