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).

Table of Contents

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:

SAP Invoice Table Doc. Segment MSEG

MSEG : Document Segment: Material

The key for each line in Document Segment Material are:

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

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

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:

SAP Segment of financial document Table BSEG

BSEG Segment of financial document

The keys of BSEG document Table are:

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

Related Posts

SAP Payment Terms Table

The Most Important SAP Payment Terms Tables (ZTERM, Text…)

October 21, 2018 March 24, 2021

SAP Batch Management 1

SAP Batch Management: User-exits and BAdIs

June 17, 2017 January 21, 2022

SAP Batch Management 1

SAP Batch Management Tcodes, Tables and Customizing (SAP Batch Management)

June 16, 2017 January 21, 2022