The Main SAP Invoice Table for Accounting Document and Material Document

The Main SAP Invoice Table for Accounting Document and Material Document.

It lists the most importat SAP invoice Table for IR (Invoice Receipt) and GR (Good Receipt) 

Difference between GR and IR in SAP

What SAP GR in SAP ?

With the goods receipt (GR) you post the physical inward movement of goods from an external vendor or from production and then complete a goods movement, which leads to an increase in the warehouse stock.

You have the option of planning goods receipts and in so doing of monitoring stock of ordered or in-house produced materials.

  • As long as you create goods receipts with reference to purchase orders (MM) or production orders (PP), they already stage all the information necessary for planning. In the stock overview and plant stock availability, purchase order quantities at SKU level are identified as on-order stock, and quantities in production orders as total open order quantity.
  • If you create goods receipts without reference to a purchase order or a production order, you can enter reservations to manually plan goods receipts. Reserved quantities are displayed as planned receipts in the stock overview and plant stock availability. (source)

What IR in SAP ?

An invoice is a list of goods sent or services provided, with a statement of the sum due for these; a.k.k a bill. Impacting your A/R (Account Receivables)

SAP Invoice Table for GR

GR stands Good Receipt in SAP MM.

The main tables for Good Receipt in SAP are:

SAP Invoice Table GR Description
MKPFHeader: Material Document
MSEGDocument Segment: Material

SAP Invoice Table Header MKPF

MKPF : Header: Material Document

The keys for each Material Document are:

  • MBLNR: Number of Material Document
  • MJAHR: Material Document Year

SAP Invoice Table Doc. Segment MSEG

MSEG : Document Segment: Material

The key for each line in Document Segment Material are:

  • MBLNR: Number of Material Document
  • MJAHR: Material Document Year
  • ZEILE: Item in Material Document

In the header level MKPF, you will find the type of Material Document:

  • VGART : Transaction/Event Type ( The referecen table is T158V )
  • BLART : Document Type ( SAP Reference Table for Document Type T003)

And in The item Level, MSEG, you will find the Mouvement Type ( MSEG-BWART ).

Check the list of possible value for Movement type in SAP MM

SAP Invoice Table for IR ( Accounting Document )

IR stands for Invoice Receipt. The main tables for SAP Invoice Table for Accounting Document are

SAP Invoice Table IR Description
BKPFAccounting Document Header
BSEGSegment of financial document

SAP Accounting Document Header Table BKPF

BKPF  Accounting Document Header

The main key Fields for BKPF are:

  • BUKRS: Company Code
  • BELNR: Accounting Document Number
  • GJAHR: Fiscal Year

SAP Segment of financial document Table BSEG

BSEG Segment of financial document

The keys of BSEG document Table are:

  • BUKRS: Company Code
  • BELNR: Accounting Document Number
  • GJAHR: Fiscal Year
  • BUZEI : Number of Line Item Within Accounting Document

All Related SAP Invoice Tables List

I tried to compile a longer list of Invoice Tables in SAP adding the SAP Tables above with related invoicing tables.

The main SAP Invoice Table for Both IR & GR:

SAP Invoice Table Description
RBKP Document header: incoming invoice and
RSEG Document item: incoming invoice
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
RBWT Withholding tax:incoming invoice
RKWA Consignment withdrawals
RSEG Document item & incoming invoice

Read also List of Important SAP FI Tables (SAP Finance Tables)

 

SAP and SAP logo are registered trademarks of SAP AG. Sap4tech.net is not associated with SAP AG.

We have made every effort to make sure provide relevant search results, use the content on this site at your own risk.

We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.