SAP Table MKPF
Header: Material Document
MKPF (Header: Material Document) 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 MKPF to other SAP tables.
Table MKPF contains all material document headers. A material document is created whenever a material movement occurs within the organisation. A material document contains a header and one or more line items. Header data is stored in table MKPF. Line items are stored in table MSEG. The link between MKPF and MSEG is made on fields MBLNR and MJAHR
MKPF table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
MBLNR
Number of Material Document
|
MBLNR |
CHAR
|
10 | 0 | ||||||||||
|
MJAHR
Material Document Year
|
MJAHR |
NUMC
|
4 | 0 | ||||||||||
|
VGART
Transaction/Event Type
|
VGART | T158V |
CHAR
|
2 | 0 | |||||||||
|
BLART
Document Type
|
BLART | T003 |
CHAR
|
2 | 0 | |||||||||
|
BLAUM
Document type of revaluation document
|
BLAUM | T003 |
CHAR
|
2 | 0 | |||||||||
|
BLDAT
Document Date in Document
|
BLDAT |
DATS
|
8 | 0 | ||||||||||
|
BUDAT
Posting Date in the Document
|
BUDAT |
DATS
|
8 | 0 | ||||||||||
|
CPUDT
Day On Which Accounting Document Was Entered
|
CPUDT |
DATS
|
8 | 0 | ||||||||||
|
CPUTM
Time of Entry
|
CPUTM |
TIMS
|
6 | 0 | ||||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||
|
USNAM
User name
|
USNAM |
CHAR
|
12 | 0 | ||||||||||
|
TCODE
Not More Closely Defined Area, Possibly Used for Patchlevels
|
CHAR4 |
CHAR
|
4 | 0 | ||||||||||
|
XBLNR
Reference Document Number
|
XBLNR1 |
CHAR
|
16 | 0 | ||||||||||
|
BKTXT
Document Header Text
|
BKTXT |
CHAR
|
25 | 0 | ||||||||||
|
FRATH
Unplanned delivery costs
|
FRATH |
CURR
|
13 | 2 | ||||||||||
|
FRBNR
Number of Bill of Lading at Time of Goods Receipt
|
FRBNR1 |
CHAR
|
16 | 0 | ||||||||||
|
WEVER
Version for Printing GR/GI Slip
|
WEVER |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XABLN
Goods Receipt/Issue Slip Number
|
XABLN |
CHAR
|
10 | 0 | ||||||||||
|
AWSYS
Logical System
|
LOGSYSTEM |
CHAR
|
10 | 0 | ||||||||||
|
BLA2D
Doc. type for additional doc. in purchase account management
|
BLA2D |
CHAR
|
2 | 0 | ||||||||||
|
TCODE2
Transaction Code
|
TCODE |
CHAR
|
20 | 0 | ||||||||||
|
BFWMS
Control posting for external WMS
|
BFWMS |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
EXNUM
Number of foreign trade data in MM and SD documents
|
EXNUM |
CHAR
|
10 | 0 | ||||||||||
|
SPE_BUDAT_UHR
Time of Goods Issue (Local, Relating to a Plant)
|
WAUHR |
TIMS
|
6 | 0 | ||||||||||
|
SPE_BUDAT_ZONE
Time Zone
|
TZNZONE |
CHAR
|
6 | 0 | ||||||||||
|
LE_VBELN
Delivery
|
VBELN_VL |
CHAR
|
10 | 0 | ||||||||||
|
SPE_LOGSYS
Logical System of EWM Material Document
|
/SPE/_LOGSYS_MD |
CHAR
|
10 | 0 | ||||||||||
|
SPE_MDNUM_EWM
Number of Material Document in EWM
|
/SPE/MDNUM_EWM |
CHAR
|
16 | 0 | ||||||||||
|
GTS_CUSREF_NO
Customs Reference Number for Scrapping
|
/SAPSLL/SCREF_SPI |
CHAR
|
35 | 0 | ||||||||||
|
FLS_RSTO
Store Return with Inbound and Outbound Delivery
|
FLS_RSTO |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
MSR_ACTIVE
Advanced Returns Management Active
|
MSR_ACTIVE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
KNUMV
Number of the document condition
|
KNUMV |
CHAR
|
10 | 0 | ||||||||||
|
LFSNR
Number of External Delivery Note
|
LFSNR1 |
CHAR
|
16 | 0 | ||||||||||
|
OIB_BLTIME
Posting time in the document
|
OIB_BLTIME |
TIMS
|
6 | 0 | ||||||||||
MKPF foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| MKPF | BLART | MKPF | MANDT |
T003
Document Types
|
MANDT |
| MKPF | BLART | MKPF | BLART |
T003
Document Types
|
BLART |
| MKPF | BLAUM | MKPF | MANDT |
T003
Document Types
|
MANDT |
| MKPF | BLAUM | MKPF | BLAUM |
T003
Document Types
|
BLART |
| MKPF | MANDT | MKPF | MANDT |
T000
Clients
|
MANDT |
| MKPF | VGART | MKPF | VGART |
T158V
Inv. Mngmt - General: Transaction/Event Types Allowed
|
VGART |