The Main SAP Invoice Table for Accounting Document and Material Document

I will keep this post so short. It lists the most importat SAP invoice Table for IR and GR

SAP invoice Table for GR

GR stands Good Receipt in SAP MM.
The main tables for Good Receipt in SAP are:

  • MKPF : Header: Material Document
    • The keys for each Material Document are:
      • MBLNR: Number of Material Document
      • MJAHR: Material Document Year
  • 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)
Check also   SAP Info Record Table, Info Recort Tcodes and SAP Info Record Report

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

BKPF  Accounting Document Header

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

BSEG Segment of financial document

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

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 result is:

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
Check also   EDI 846 : Inventory Inquiry/Advice in SAP

 

Sab125

Hi. I have been working as SAP Technical and functional for a decade. Through this blog, I am trying to share with you my experience. Hopefull, it makes your ways easier path ... Sab

Leave a Reply

Your email address will not be published. Required fields are marked *