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
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
1 Individual Slip
2 Individual Slip with Inspection Text
3 Collective Slip
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
2 Execute stock change in ERP
1 Create delivery and transmit to WM
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
X Yes
NULL No
MSR_ACTIVE Advanced Returns Management Active MSR_ACTIVE CHAR 1 0
X Adv. Returns Is Active
NULL Adv. Returns Is Not Active
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