Accounting document against Material document

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

 

 

 

 

8 thoughts on “Accounting document against Material document

  1. 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!

    Like

      1. Dear sir
        I am a silent follower of your block and Videos. I love the way you explain and your voice.
        Can you Please make one video on CIN or Any detailed doc.
        Thanks in advance.

        Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s