The Main SAP Invoice Table for Accounting Document and Material Document

SAP VIM Overview- Processing Invoice - SAP invoice Table e1478970452701

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.

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 GRDESCRIPTION
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 IRDESCRIPTION
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 TABLEDESCRIPTION
RBKPDocument header: incoming invoice and
RSEGDocument item: incoming invoice
BSIMSecondary index: documents for material
MYMFTFIFO results table
MYMLLIFO material layer
MYMLMLIFO material layer (monthly)
MYMPLIFO period stocks: single material
MYMP1Receipt data LIFO/FIFO valuation
MYPLLIFO pool layer
MYPLMLIFO pool layer (monthly)
RBCODocument item: incoming invoice account assignment
RBDIFFKOInvoice Verification: conditions
RBDIFFMEInvoice Verification: quantity differences
RBDRSEGInvoice Verification batch: invoice document items
RBKPDocument header: incoming invoice
RBKPBInvoice document header (batch invoice verification)
RBTXTaxes:incoming invoice
RBVDInvoice document: summarization data
RBVDMATInvoice Verification: summarization data & material
RBWTWithholding tax:incoming invoice
RKWAConsignment withdrawals
RSEGDocument item & incoming invoice

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