SE11 ABAP Dictionary SE11 MKPF

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

MKPF

Header: Material Document

SAP MM Transparent Table 33 Fields

Primary Key:

MANDT MBLNR MJAHR

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	MBLNR	KEY	Mat. Doc.	CHAR	10	-	-	Number of Material Document
3	MJAHR	KEY	Mat. Year	NUMC	4	-	-	Material Document Year
4	VGART	-	Tr/Ev.Type	CHAR	2	-	-	Transaction/Event Type
5	BLART	-	Type	CHAR	2	-	-	Document Type
6	BLAUM	-	DocTypeRev	CHAR	2	-	-	Document type of revaluation document
7	BLDAT	-	Doc. Date	DATS	8	-	-	Document Date in Document
8	BUDAT	-	Pstng Date	DATS	8	-	-	Posting Date in the Document
9	CPUDT	-	Entered	DATS	8	-	-	Day On Which Accounting Document Was Entered
10	CPUTM	-	Time	TIMS	6	-	-	Time of Entry
11	AEDAT	-	Chngd	DATS	8	-	-	Changed On
12	USNAM	-	User	CHAR	12	-	-	User Name
13	TCODE	-	Not More Closely Defined Area, Possibly Used for Patchlevels	CHAR	4	-	-	Not More Closely Defined Area, Possibly Used for Patchlevels
14	XBLNR	-	Reference	CHAR	16	-	-	Reference Document Number
15	BKTXT	-	HeaderText	CHAR	25	-	-	Document Header Text
16	FRATH	-	Un.del.cts	CURR	13	2	-	Unplanned delivery costs
17	FRBNR	-	B/Lading	CHAR	16	-	-	Number of Bill of Lading at Time of Goods Receipt
18	WEVER	-	Version	CHAR	1	-	-	Version for Printing GR/GI Slip
19	XABLN	-	GR/GI Slip	CHAR	10	-	-	Goods Receipt/Issue Slip Number
20	AWSYS	-	Log.System	CHAR	10	-	-	Logical System
21	BLA2D	-	DocType AD	CHAR	2	-	-	Doc. type for additional doc. in purchase account management
22	TCODE2	-	TCode	CHAR	20	-	-	Transaction Code
23	BFWMS	-	Ext. WMS	CHAR	1	-	-	Control posting for external WMS
24	EXNUM	-	FT no.	CHAR	10	-	-	Number of foreign trade data in MM and SD documents
25	SPE_BUDAT_UHR	-	GI Time	TIMS	6	-	-	Time of Goods Issue (Local, Relating to a Plant)
26	SPE_BUDAT_ZONE	-	Time Zone	CHAR	6	-	-	Time Zone
27	LE_VBELN	-	Delivery	CHAR	10	-	-	Delivery
28	SPE_LOGSYS	-	LogSystem	CHAR	10	-	-	Logical System of EWM Material Document
29	SPE_MDNUM_EWM	-	MatDocEWM	CHAR	16	-	-	Number of Material Document in EWM
30	GTS_CUSREF_NO	-	CustRefNo.	CHAR	35	-	-	Customs Reference Number for Scrapping
31	FLS_RSTO	-	Enh.StRet.	CHAR	1	-	-	Store Return with Inbound and Outbound Delivery
32	MSR_ACTIVE	-	AdvRets	CHAR	1	-	-	Advanced Returns Management Active
33	KNUMV	-	Doc.cond.	CHAR	10	-	-	Number of the document condition

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk MKPF.

Interactive ERD Diagrams

SAP MM - Goods Receipt Relation →

Standard T-Codes

MIGO MB03 MB51

Related Tables

MSEG EKBE MVER S031 S011 S013

ANSI SQL Query

SELECT a.MBLNR,
       a.MJAHR,
       a.VGART,
       a.BLART,
       a.BLAUM,
       a.BLDAT,
       a.BUDAT
FROM MKPF AS a
WHERE a.MBLNR = '0001'
  AND a.MJAHR = '0001';

ABAP OpenSQL (7.40+)

SELECT a~mblnr,
       a~mjahr,
       a~vgart,
       a~blart,
       a~blaum,
       a~bldat,
       a~budat
  FROM mkpf AS a
  WHERE a~mblnr = '0001'
  and a~mjahr = '0001'
  INTO TABLE @DATA(lt_mkpf)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 MKPF

MKPF

Dictionary Fields Fields

Related References & SQL