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