Follow us on LinkedIn for your next SAP project

SAP Table OI0_MATDOC_KEY

RKWA: Key Fields

OI0_MATDOC_KEY (RKWA: Key Fields) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OI0_MATDOC_KEY to other SAP tables.

OI0_MATDOC_KEY table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT
CLNT
3 0
MBLNR
Number of Material Document
MBLNR MKPF
CHAR
10 0
MJAHR
Material Document Year
MJAHR MKPF
NUMC
4 0
ZEILE
Item in Material Document
MBLPO MSEG
NUMC
4 0
IBLNR
Physical Inventory Document
IBLNR
CHAR
10 0
GJAHR
Fiscal Year
GJAHR
NUMC
4 0
ZEILI
Line Number
DZEILE
NUMC
3 0

OI0_MATDOC_KEY foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OI0_MATDOC_KEY MBLNR OI0_MATDOC_KEY MANDT MKPF
Header: Material Document
MANDT
OI0_MATDOC_KEY MBLNR OI0_MATDOC_KEY MBLNR MKPF
Header: Material Document
MBLNR
OI0_MATDOC_KEY MBLNR OI0_MATDOC_KEY MJAHR MKPF
Header: Material Document
MJAHR
OI0_MATDOC_KEY MJAHR OI0_MATDOC_KEY MANDT MKPF
Header: Material Document
MANDT
OI0_MATDOC_KEY MJAHR OI0_MATDOC_KEY MBLNR MKPF
Header: Material Document
MBLNR
OI0_MATDOC_KEY MJAHR OI0_MATDOC_KEY MJAHR MKPF
Header: Material Document
MJAHR
OI0_MATDOC_KEY ZEILE OI0_MATDOC_KEY MANDT MSEG
Document Segment: Material
MANDT
OI0_MATDOC_KEY ZEILE OI0_MATDOC_KEY MBLNR MSEG
Document Segment: Material
MBLNR
OI0_MATDOC_KEY ZEILE OI0_MATDOC_KEY MJAHR MSEG
Document Segment: Material
MJAHR
OI0_MATDOC_KEY ZEILE OI0_MATDOC_KEY ZEILE MSEG
Document Segment: Material
ZEILE