cancel
Showing results for 
Search instead for 
Did you mean: 

Accounting document during GR & Invoice

Former Member
0 Kudos

Hello SAP gurus

I want a report in which there should be purchase order no ,Accounting document which is created during GR & Invoice.

Please suggest me the T code if any or if i hav to write a query for that which tabled shuld i use?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You can check with the many reports like MB5B, MB51 , MB52...

Or for custom development

You can develop a report based on following table & fields.

MSEG-BWART-Movement type

MSEG-MBLNR -Material document

MSEG-BELNR -Accounting document

MSEG-DMBTR -Amount in lical currency

MSEG-MENGE -Qty

MM Table PDF Link http://www.sapcustomization.com/document/sap_tables.pdf

Former Member
0 Kudos

Thanks mohamed,

But still i m not getting the output

I have joined the tables EKBE & MSEG & BKPF

I want the document creation date,posting date,fiscal year,Doc type(RE for invoice doc type) as input

& In o/p parameter i want PO no.,PO item,Invoicing accounting document & Vendor if possible & other data

Please help me guys...

Answers (3)

Answers (3)

pardeep_malik
Active Contributor
0 Kudos

Dear Desai,

Tables in SAP MM for Purchasing Point of View

EKKO - Purchasing document header

EKPO - Purchasing Document: Item

EKET - Purchasing Document: Delivery Schedules

MDBS - Material View of Order Item/Schedule Line (good to find open PO's)

EKKN - Account assignment in purchasing document

EORD - Purchasing Source List

EIPA - Order price history record

EKAB - Release documentation

EKBE - Purchasing document history

EKBZ - Purchasing document history: delivery costs

MKPF - Material document: Header

MSEG - Material document: item

Invoice Verification

BSIM - Secondary index: documents for material

MYMFT - FIFO results table

MYML - LIFO material layer

MYMLM - LIFO material layer (monthly)

MYMP - LIFO period stocks, single material

MYMP1 - Receipt data LIFO/FIFO valuation

MYPL - LIFO pool layer

MYPLM - LIFO pool layer (monthly)

RBCO - Document item, incoming invoice account assignment

RBDIFFKO - Invoice Verification: conditions

RBDIFFME - Invoice Verification: quantity differences

RBDRSEG - Invoice Verification batch: invoice document items

RBKP - Document header: incoming invoice

RBKPB - Invoice document header (batch invoice verification)

RBTX - Taxes:incoming invoice

RBVD - Invoice document: summarization data

RBVDMAT - Invoice Verification: summarization data, material

this may help u !

Regards,

Pardeep Malik

Former Member
0 Kudos

MR51 will solve your problem.

AMIT

JL23
Active Contributor
0 Kudos

MR51