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
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)
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)
GR stands Good Receipt in SAP MM.
The main tables for Good Receipt in SAP are:
| SAP INVOICE TABLE GR | DESCRIPTION |
|---|---|
| MKPF | Header: Material Document |
| MSEG | Document Segment: Material |
MKPF : Header: Material Document
The keys for each Material Document are:
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 ).
IR stands for Invoice Receipt. The main tables for SAP Invoice Table for Accounting Document are
| SAP INVOICE TABLE IR | DESCRIPTION |
|---|---|
| BKPF | Accounting Document Header |
| BSEG | Segment of financial document |
BKPF Accounting Document Header
The main key Fields for BKPF are:
BSEG Segment of financial document
The keys of BSEG document Table are:
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 |
October 21, 2018 March 24, 2021
June 17, 2017 January 21, 2022
June 16, 2017 January 21, 2022
