MKPF Header: Material Document
SAP table MKPF is a pivotal component in the SAP Material Management (MM) module, serving as the document header table for material documents. It primarily stores key information related to material movements, such as goods receipts, goods issues, and transfer postings. The data captured in MKPF includes the document number, document date, posting date, transaction type, user ID, and plant, among other essential fields. This table acts as the central repository for summarizing and managing the header information of material document transactions, facilitating efficient inventory management and seamless integration with other SAP modules.
SAP table MKPF has 3 primary key fields being MANDT,MBLNR,MJAHR.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
MKPF columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
| KeyMBLNR | Number of Material Document | CHAR | 10 | 0 | MBLNR | ||||||||
| KeyMJAHR | Material Document Year | NUMC | 4 | 0 | MJAHR | ||||||||
| VGART | Transaction/Event Type | CHAR | 2 | 0 | T158V | VGART | |||||||
| BLART | Document Type | CHAR | 2 | 0 | T003 | BLART | |||||||
| BLAUM | Document type of revaluation document | CHAR | 2 | 0 | T003 | BLAUM | |||||||
| BLDAT | Document Date in Document | DATS | 8 | 0 | BLDAT | ||||||||
| BUDAT | Posting Date in the Document | DATS | 8 | 0 | BUDAT | ||||||||
| CPUDT | Day On Which Accounting Document Was Entered | DATS | 8 | 0 | CPUDT | ||||||||
| CPUTM | Time of Entry | TIMS | 6 | 0 | CPUTM | ||||||||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||||||||
| USNAM | User Name | CHAR | 12 | 0 | USNAM | ||||||||
| TCODE | Undefined range (can be used for patch levels) | CHAR | 4 | 0 | CHAR4 | ||||||||
| XBLNR | Reference Document Number | CHAR | 16 | 0 | XBLNR1 | ||||||||
| BKTXT | Document Header Text | CHAR | 25 | 0 | BKTXT | ||||||||
| FRATH | Unplanned delivery costs | CURR | 13 | 2 | FRATH | ||||||||
| FRBNR | Number of Bill of Lading at Time of Goods Receipt | CHAR | 16 | 0 | FRBNR1 | ||||||||
| WEVER | Version for Printing GR/GI Slip | CHAR | 1 | 0 | WEVER | ||||||||
|
|||||||||||||
| XABLN | Goods Receipt/Issue Slip Number | CHAR | 10 | 0 | XABLN | ||||||||
| AWSYS | Logical System | CHAR | 10 | 0 | LOGSYSTEM | ||||||||
| BLA2D | Doc. type for additional doc. in purchase account management | CHAR | 2 | 0 | BLA2D | ||||||||
| TCODE2 | Transaction Code | CHAR | 20 | 0 | TCODE | ||||||||
| BFWMS | Control posting for external WMS | CHAR | 1 | 0 | BFWMS | ||||||||
|
|||||||||||||
| EXNUM | Number of foreign trade data in MM and SD documents | CHAR | 10 | 0 | EXNUM | ||||||||
| SPE_BUDAT_UHR | Time of Goods Issue (Local, Relating to a Plant) | TIMS | 6 | 0 | WAUHR | ||||||||
| SPE_BUDAT_ZONE | Time Zone | CHAR | 6 | 0 | TZNZONE | ||||||||
| LE_VBELN | Delivery | CHAR | 10 | 0 | VBELN_VL | ||||||||
| SPE_LOGSYS | Logical System of EWM Material Document | CHAR | 10 | 0 | /SPE/_LOGSYS_MD | ||||||||
| SPE_MDNUM_EWM | Number of Material Document in EWM | CHAR | 16 | 0 | /SPE/MDNUM_EWM | ||||||||
| GTS_CUSREF_NO | Customs Reference Number for Scrapping | CHAR | 35 | 0 | /SAPSLL/SCREF_SPI | ||||||||
| FLS_RSTO | Store Return with Inbound and Outbound Delivery | CHAR | 1 | 0 | FLS_RSTO | ||||||||
| MSR_ACTIVE | Advanced Returns Management Active | CHAR | 1 | 0 | MSR_ACTIVE | ||||||||
|
|||||||||||||
| KNUMV | Number of the Document Condition | CHAR | 10 | 0 | KNUMV | ||||||||
| XCOMPL | Material document can only be canceled in full | CHAR | 1 | 0 | MILL_CANCEL_COMPLETE | ||||||||