SE11 ABAP Dictionary SE11 MARC

Popular:

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

MARC

Plant Data for Material

SAP MM Transparent Table 223 Fields

Primary Key:

MANDT MATNR WERKS

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	MATNR	KEY	Material	CHAR	18	-	MARA	Material Number
3	WERKS	KEY	Plant	CHAR	4	-	T001W	Plant
4	PSTAT	-	Status	CHAR	15	-	-	Maintenance status
5	LVORM	-	PlantLevel	CHAR	1	-	-	Flag Material for Deletion at Plant Level
6	BWTTY	-	Val. Cat.	CHAR	1	-	-	Valuation Category
7	XCHAR	-	Batches	CHAR	1	-	-	Batch management indicator (internal)
8	MMSTA	-	MatlStatus	CHAR	2	-	-	Plant-Specific Material Status
9	MMSTD	-	Valid from	DATS	8	-	-	Date from which the plant-specific material status is valid
10	MAABC	-	ABC	CHAR	1	-	-	ABC Indicator
11	KZKRI	-	Critical	CHAR	1	-	-	Indicator: Critical part
12	EKGRP	-	Purch. Grp	CHAR	3	-	-	Purchasing Group
13	AUSME	-	Unit issue	UNIT	3	-	-	Unit of issue
14	DISPR	-	MRP prof.	CHAR	4	-	-	Material: MRP profile
15	DISMM	-	MRP Type	CHAR	2	-	-	MRP Type
16	DISPO	-	MRP Cont.	CHAR	3	-	-	MRP Controller (Materials Planner)
17	KZDIE	-	MRPC=buyer	CHAR	1	-	-	Indicator: MRP controller is buyer (deactivated)
18	PLIFZ	-	Plnd Dely	DEC	3	-	-	Planned Delivery Time in Days
19	WEBAZ	-	GR ProcTme	DEC	3	-	-	Goods Receipt Processing Time in Days
20	PERKZ	-	Period Ind	CHAR	1	-	-	Period Indicator
21	AUSSS	-	Assy scrap	DEC	5	2	-	Assembly scrap in percent
22	DISLS	-	Lot size	CHAR	2	-	-	Lot size (materials planning)
23	BESKZ	-	Proc. type	CHAR	1	-	-	Procurement Type
24	SOBSL	-	SP type	CHAR	2	-	-	Special procurement type
25	MINBE	-	Reorder Pt	QUAN	13	3	-	Reorder Point
26	EISBE	-	Safety Stk	QUAN	13	3	-	Safety Stock
27	BSTMI	-	MinLotSize	QUAN	13	3	-	Minimum Lot Size
28	BSTMA	-	MaxLotSize	QUAN	13	3	-	Maximum Lot Size
29	BSTFE	-	Fixed lot	QUAN	13	3	-	Fixed lot size
30	BSTRF	-	Round val.	QUAN	13	3	-	Rounding value for purchase order quantity
31	MABST	-	Max. level	QUAN	13	3	-	Maximum stock level
32	LOSFX	-	Ord. costs	CURR	11	2	-	Ordering costs
33	SBDKZ	-	Ind./coll.	CHAR	1	-	-	Dependent requirements ind. for individual and coll. reqmts
34	LAGPR	-	Stor.costs	CHAR	1	-	-	Storage costs indicator
35	ALTSL	-	Sel.method	CHAR	1	-	-	Method for Selecting Alternative Bills of Material
36	KZAUS	-	Discontin.	CHAR	1	-	-	Discontinuation indicator
37	AUSDT	-	Ef.-o.date	DATS	8	-	-	Effective-Out Date
38	NFMAT	-	Fol-UpMatl	CHAR	18	-	-	Follow-Up Material
39	KZBED	-	Reqmts grp	CHAR	1	-	-	Indicator for Requirements Grouping
40	MISKZ	-	Mixed MRP	CHAR	1	-	-	Mixed MRP indicator
41	FHORI	-	SM key	CHAR	3	-	-	Scheduling Margin Key for Floats
42	PFREI	-	Autom. fix	CHAR	1	-	-	Indicator: automatic fixing of planned orders
43	FFREI	-	Release	CHAR	1	-	-	Release indicator for production orders
44	RGEKZ	-	Backflush	CHAR	1	-	-	Indicator: Backflush
45	FEVOR	-	Pr.Superv.	CHAR	3	-	-	Production Supervisor
46	BEARZ	-	Proc. time	DEC	5	2	-	Processing time
47	RUEZT	-	SetupTime	DEC	5	2	-	Setup and teardown time
48	TRANZ	-	Interop.	DEC	5	2	-	Interoperation time
49	BASMG	-	Base qty.	QUAN	13	3	-	Base quantity
50	DZEIT	-	InhseProdT	DEC	3	-	-	In-house production time
51	MAXLZ	-	Stor. per.	DEC	5	-	-	Maximum storage period
52	LZEIH	-	Unit	UNIT	3	-	-	Unit for maximum storage period
53	KZPRO	-	Withd.p.bn	CHAR	1	-	-	Indicator: withdrawal of stock from production bin
54	GPMKZ	-	Rough Plng	CHAR	1	-	-	Indicator: Material Included in Rough-Cut Planning
55	UEETO	-	Over. tol.	DEC	3	1	-	Overdelivery tolerance limit
56	UEETK	-	Unlimited	CHAR	1	-	-	Indicator: Unlimited Overdelivery Allowed
57	UNETO	-	Under.tol.	DEC	3	1	-	Underdelivery tolerance limit
58	WZEIT	-	Total RLT	DEC	3	-	-	Total replenishment lead time (in workdays)
59	ATPKZ	-	Replacemt	CHAR	1	-	-	Replacement part
60	VZUSL	-	Surcharge	DEC	5	2	-	Surcharge factor for cost in percent
61	HERBL	-	State	CHAR	2	-	-	State of manufacture
62	INSMK	-	Insp.stock	CHAR	1	-	-	Post to Inspection Stock
63	SPROZ	-	Sample	DEC	3	1	-	Sample for quality inspection (in %) (deactivated)
64	QUAZT	-	Quarantine	DEC	3	-	-	Quarantine period (deactivated)
65	SSQSS	-	QM ContKey	CHAR	8	-	-	Control Key for Quality Management in Procurement
66	MPDAU	-	Mean insp.	DEC	5	-	-	Mean inspection duration (deactivated)
67	KZPPV	-	Insp. plan	CHAR	1	-	-	Indicator for inspection plan (deactivated)
68	KZDKZ	-	Doc. reqd	CHAR	1	-	-	Documentation required indicator
69	WSTGH	-	Act.subst.	DEC	9	-	-	Active substance content (deactivated)
70	PRFRQ	-	Insp. int.	DEC	5	-	-	Interval until next recurring inspection
71	NKMPR	-	Next insp.	DATS	8	-	-	Date according to check sampling inspection (deactivated)
72	UMLMC	-	In Trans.	QUAN	13	3	-	Stock in Transfer (Plant to Plant)
73	LADGR	-	LoadingGrp	CHAR	4	-	-	Loading Group
74	XCHPF	-	Batch mgmt	CHAR	1	-	-	Batch management requirement indicator
75	USEQU	-	QuotaUsage	CHAR	1	-	-	Quota arrangement usage
76	LGRAD	-	Serv.level	DEC	3	1	-	Service level
77	AUFTL	-	Split ind.	CHAR	1	-	-	Splitting Indicator
78	PLVAR	-	Plan Vers.	CHAR	2	-	-	Plan Version
79	OTYPE	-	Obj.Type	CHAR	2	-	-	Object Type
80	OBJID	-	Object ID	NUMC	8	-	-	Object ID
81	MTVFP	-	AvailCheck	CHAR	2	-	-	Checking Group for Availability Check
82	PERIV	-	FY Variant	CHAR	2	-	-	Fiscal Year Variant
83	KZKFK	-	CorrFact.	CHAR	1	-	-	Indicator: take correction factors into account
84	VRVEZ	-	Setup time	DEC	5	2	-	Shipping setup time
85	VBAMG	-	Base qty	QUAN	13	3	-	Base quantity for capacity planning in shipping
86	VBEAZ	-	Proc. time	DEC	5	2	-	Shipping processing time
87	LIZYK	-	Deactivated	CHAR	4	-	-	Deactivated
88	BWSCL	-	Source	CHAR	1	-	-	Source of Supply
89	KAUTB	-	Auto PO	CHAR	1	-	-	Indicator: "automatic purchase order allowed"
90	KORDB	-	Srce.list	CHAR	1	-	-	Indicator: Source list requirement
91	STAWN	-	Comm. code	CHAR	17	-	-	Commodity Code/Import Code Number for Foreign Trade
92	HERKL	-	Origin	CHAR	3	-	-	Country of origin of the material
93	HERKR	-	Reg.origin	CHAR	3	-	-	Region of origin of material (non-preferential origin)
94	EXPME	-	CommCoUnit	UNIT	3	-	-	Unit of measure for commodity code (foreign trade)
95	MTVER	-	Exp/ImpGrp	CHAR	4	-	-	Export/import material group
96	PRCTR	-	Profit Ctr	CHAR	10	-	-	Profit Center
97	TRAME	-	Transit	QUAN	13	3	-	Stock in Transit
98	MRPPP	-	Calendar	CHAR	3	-	-	PPC planning calendar
99	SAUFT	-	Repet. mfg	CHAR	1	-	-	Ind.: Repetitive mfg allowed
100	FXHOR	-	PlTmFnce	NUMC	3	-	-	Planning time fence
101	VRMOD	-	ConsumMode	CHAR	1	-	-	Consumption mode
102	VINT1	-	Bwd cons.	NUMC	3	-	-	Consumption period: backward
103	VINT2	-	Fwd cons.	NUMC	3	-	-	Consumption period: forward
104	VERKZ	-	Version	CHAR	1	-	-	Version Indicator
105	STLAL	-	Alt. BOM	CHAR	2	-	-	Alternative BOM
106	STLAN	-	BOM Usage	CHAR	1	-	-	BOM Usage
107	PLNNR	-	Group	CHAR	8	-	-	Key for Task List Group
108	APLAL	-	Grp.Countr	CHAR	2	-	-	Group Counter
109	LOSGR	-	Lot Size	QUAN	13	3	-	Lot Size for Product Costing
110	SOBSK	-	SpProcType	CHAR	2	-	-	Special Procurement Type for Costing
111	FRTME	-	Prod. unit	UNIT	3	-	-	Production unit
112	LGPRO	-	Prod.SLoc.	CHAR	4	-	-	Issue Storage Location
113	DISGR	-	MRP group	CHAR	4	-	-	MRP Group
114	KAUSF	-	Comp.scrap	DEC	5	2	-	Component scrap in percent
115	QZGTP	-	Cert. type	CHAR	4	-	-	Certificate Type
116	QMATV	-	Insp.setup	CHAR	1	-	-	Inspection Setup Exists for Material/Plant
117	TAKZT	-	Takt time	DEC	3	-	-	Takt time
118	RWPRO	-	Cvge prof.	CHAR	3	-	-	Range of coverage profile
119	COPAM	-	Field name	CHAR	10	-	-	Local field name for CO/PA link to SOP
120	ABCIN	-	CC ph.inv.	CHAR	1	-	-	Physical inventory indicator for cycle counting
121	AWSLS	-	Var. key	CHAR	6	-	-	Variance Key
122	SERNP	-	Profile	CHAR	4	-	-	Serial Number Profile
123	CUOBJ	-	Int.obj.no	NUMC	18	-	-	Internal object number
124	STDPD	-	Conf. matl	CHAR	18	-	-	Configurable material
125	SFEPR	-	RM profile	CHAR	4	-	-	Repetitive manufacturing profile
126	XMCNG	-	Neg.stocks	CHAR	1	-	-	Negative stocks allowed in plant
127	QSSYS	-	Tgt QM sys	CHAR	4	-	-	Required QM System for Vendor
128	LFRHY	-	Plng cycle	CHAR	3	-	-	Planning cycle
129	RDPRF	-	R. Profile	CHAR	4	-	-	Rounding Profile
130	VRBMT	-	RefMatCons	CHAR	18	-	-	Reference material for consumption
131	VRBWK	-	RPlantCons	CHAR	4	-	-	Reference plant for consumption
132	VRBDT	-	Date to	DATS	8	-	-	To date of the material to be copied for consumption
133	VRBFK	-	Multiplier	DEC	4	2	-	Multiplier for reference material for consumption
134	AUTRU	-	Auto.Reset	CHAR	1	-	-	Reset Forecast Model Automatically
135	PREFE	-	Preference	CHAR	1	-	-	Preference indicator in export/import
136	PRENC	-	ExemptCert	CHAR	1	-	-	Exemption certificate: Indicator for legal control
137	PRENO	-	ExCertNo.	CHAR	8	-	-	Exemption certificate number for legal control
138	PREND	-	IssDateCrt	DATS	8	-	-	Exemption certificate: Issue date of exemption certificate
139	PRENE	-	Vdr decl.	CHAR	1	-	-	Indicator: Vendor declaration exists
140	PRENG	-	VrDeclDate	DATS	8	-	-	Validity date of vendor declaration
141	ITARK	-	Mil. goods	CHAR	1	-	-	Indicator: Military goods
142	SERVG	-	Serv. lev.	CHAR	1	-	-	IS-R service level
143	KZKUP	-	Co-product	CHAR	1	-	-	Indicator: Material can be co-product
144	STRGR	-	Strtgy grp	CHAR	2	-	-	Planning strategy group
145	CUOBV	-	Int.obj.no	NUMC	18	-	-	Internal object number of configurable material for planning
146	LGFSB	-	SLoc EP	CHAR	4	-	-	Default storage location for external procurement
147	SCHGT	-	Bulk Matl	CHAR	1	-	-	Indicator: Bulk Material
148	CCFIX	-	CC fixed	CHAR	1	-	-	CC indicator is fixed
149	EPRIO	-	SDG	CHAR	4	-	-	Stock determination group
150	QMATA	-	Mat. auth.	CHAR	6	-	-	Material Authorization Group for Activities in QM
151	RESVP	-	Adj.period	DEC	3	-	-	Period of adjustment for planned independent requirements
152	PLNTY	-	Type	CHAR	1	-	-	Task List Type
153	UOMGR	-	UoM Group	CHAR	3	-	-	Unit of Mearsure Group (Oil, Natural Gas,...)
154	UMRSL	-	Conv.Group	CHAR	4	-	-	Conversion Group (Oil, Natural Gas,..)
155	ABFAC	-	AB Factor	DEC	2	1	-	Air Bouyancy Factor
156	SFCPF	-	ProdProf	CHAR	6	-	-	Production Scheduling Profile
157	SHFLG	-	SafetyTime	CHAR	1	-	-	Safety time indicator (with or without safety time)
158	SHZET	-	SafetyTime	NUMC	2	-	-	Safety time (in workdays)
159	MDACH	-	ActionCtrl	CHAR	2	-	-	Action control: planned order processing
160	KZECH	-	EnterBatch	CHAR	1	-	-	Determination of batch entry in the production/process order
161	MEGRU	-	UoM Group	CHAR	4	-	-	Unit of Measure Group
162	MFRGR	-	MatlFrtGrp	CHAR	8	-	-	Material freight group
163	VKUMC	-	Stk tr. SV	CURR	13	2	-	Stock transfer sales value (plant to plant) for VO material
164	VKTRW	-	Transit/SP	CURR	13	2	-	Transit value at sales price for value-only material
165	KZAGL	-	SmthPrmCon	CHAR	1	-	-	Indicator: smooth promotion consumption
166	FVIDK	-	Version	CHAR	4	-	-	Production Version To Be Costed
167	FXPRU	-	Fxd Price	CHAR	1	-	-	Fixed-Price Co-Product
168	LOGGR	-	Log. group	CHAR	4	-	-	Logistics handling group for workload calculation
169	FPRFM	-	DistProf	CHAR	3	-	-	Distribution profile of material in plant
170	GLGMG	-	Tied Empt.	QUAN	13	3	-	Tied Empties Stock
171	VKGLG	-	SlsValEmpt	CURR	13	2	-	Sales value of tied empties stock
172	INDUS	-	Mat. cat.	CHAR	2	-	-	Material CFOP category
173	MOWNR	-	EUList no.	CHAR	12	-	-	CAP: Number of CAP products list
174	MOGRU	-	CAP group	CHAR	6	-	-	Common Agricultural Policy: CAP products group-Foreign Trade
175	CASNR	-	CAS no.	CHAR	15	-	-	CAS number for pharmaceutical products in foreign trade
176	GPNUM	-	PRODCOM no	CHAR	9	-	-	Production statistics: PRODCOM number for foreign trade
177	STEUC	-	Ctrl code	CHAR	16	-	-	Control code for consumption taxes in foreign trade
178	FABKZ	-	JIT Indic.	CHAR	1	-	-	Indicator: Item Relevant to JIT Delivery Schedules
179	MATGR	-	Mat.Grping	CHAR	20	-	-	Group of Materials for Transition Matrix
180	VSPVB	-	Propos.SA	CHAR	10	-	-	Proposed Supply Area in Material Master Record
181	DPLFS	-	Fair share	CHAR	2	-	-	Fair share rule
182	DPLPU	-	Push	CHAR	1	-	-	Indicator: push distribution
183	DPLHO	-	Depl. hrzn	DEC	3	-	-	Deployment horizon in days
184	MINLS	-	MinLotsize	QUAN	13	3	-	Minimum lot size for Supply Demand Match
185	MAXLS	-	MaxLotsize	QUAN	13	3	-	Maximum lot size for Supply Demand Match
186	FIXLS	-	FixLotsize	QUAN	13	3	-	Fixed lot size for Supply Demand Match
187	LTINC	-	LotsizeInc	QUAN	13	3	-	Lot size increment for Supply Demand Match
188	COMPL	-	This field is no longer used	NUMC	2	-	-	This field is no longer used
189	CONVT	-	ConvType	CHAR	2	-	-	Conversion types for production figures
190	SHPRO	-	ST PerProf	CHAR	3	-	-	Period Profile for Safety Time
191	AHDIS	-	MRP DepReq	CHAR	1	-	-	MRP relevancy for dependent requirements
192	DIBER	-	MRPa exist	CHAR	1	-	-	Indicator: MRP area exists
193	KZPSP	-	Cross-proj	CHAR	1	-	-	Indicator for cross-project material
194	OCMPF	-	OverallPrf	CHAR	6	-	-	Overall profile for order change management
195	APOKZ	-	APO relev.	CHAR	1	-	-	Indicator: Is material relevant for APO
196	MCRUE	-	MARDH rec. already exists for per. before last of MARD per.	CHAR	1	-	-	MARDH rec. already exists for per. before last of MARD per.
197	LFMON	-	Period	NUMC	2	-	-	Current period (posting period)
198	LFGJA	-	Year	NUMC	4	-	-	Fiscal Year of Current Period
199	EISLO	-	MinSafStck	QUAN	13	3	-	Minimum Safety Stock
200	NCOST	-	DoNotCost	CHAR	1	-	-	Do Not Cost
201	ROTATION_DATE	-	Put/StkRmv	CHAR	1	-	-	Strategy for Putaway and Stock Removal
202	UCHKZ	-	OBManagmnt	CHAR	1	-	-	Indicator for Original Batch Management
203	UCMAT	-	OB Ref.Mat	CHAR	18	-	-	Reference Material for Original Batches
204	BWESB	-	Val. GR BS	QUAN	13	3	-	Valuated Goods Receipt Blocked Stock
205	/MRSS/PROF_GUID	-	GUID 16	CHAR	32	-	-	GUID in 'CHAR' Format in Uppercase
206	/MRSS/PROF_KEY	-	Profile	CHAR	10	-	-	Profile key
207	/MRSS/DATACHANGE	-	Changed:	CHAR	1	-	-	Data was changed in the controls on the user screen
208	/SAPMP/TOLPRPL	-	% Tol Plus	DEC	3	1	-	Percentage Tolerance Plus
209	/SAPMP/TOLPRMI	-	% Tol Min	DEC	3	1	-	Percentage Tolerance Minus
210	/VSO/R_PKGRP	-	Pack.Group	CHAR	18	-	-	Packing Group of the Material (VSO)
211	/VSO/R_LANE_NUM	-	Pick. Line	CHAR	3	-	-	Line within the Automatic Picking Zone (VSO)
212	/VSO/R_PAL_VEND	-	PKM Vendor	CHAR	18	-	-	Material No. of the Packaging Material of the Vendor (VSO)
213	/VSO/R_FORK_DIR	-	PKM Length	CHAR	1	-	-	Pick Packaging Materials only Lengthwise (VSO)
214	IUID_RELEVANT	-	IUID-Rel.	CHAR	1	-	-	IUID-Relevant
215	IUID_TYPE	-	IUID Type	CHAR	10	-	-	Structure Type of UII
216	UID_IEA	-	Ext. Allo.	CHAR	1	-	-	External Allocation of UII
217	CONS_PROCG	-	Consi.Ctrl	CHAR	1	-	-	Consignment Control
218	GI_PR_TIME	-	GIP-T	DEC	3	-	-	Goods Issue Processing Time in Days
219	MULTIPLE_EKGRP	-	PurGr	CHAR	1	-	-	Purchasing Across Purchasing Group
220	REF_SCHEMA	-	Det.Schema	CHAR	2	-	-	Reference Determination Schema
221	MIN_TROC	-	MinTRange	NUMC	3	-	-	Minimum Target Range of Coverage
222	MAX_TROC	-	MaxTRange	NUMC	3	-	-	Maximum Target Range of Coverage
223	TARGET_STOCK	-	T. Stock	QUAN	13	3	-	Target Stock

Related References & SQL

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

Interactive ERD Diagrams

SAP MM - Master Data Relation → SAP SD - Links to MM Tables →

Standard T-Codes

MM03 MD04 MMBE

Related Tables

MARA T001W MAKT MARM MLAN MBEW MVKE T179

ANSI SQL Query

SELECT a.MATNR,
       a.WERKS,
       a.PSTAT,
       a.LVORM,
       a.BWTTY,
       a.XCHAR,
       a.MMSTA
FROM MARC AS a
WHERE a.MATNR = 'FG-100'
  AND a.WERKS = '0001';

ABAP OpenSQL (7.40+)

SELECT a~matnr,
       a~werks,
       a~pstat,
       a~lvorm,
       a~bwtty,
       a~xchar,
       a~mmsta
  FROM marc AS a
  WHERE a~matnr = 'fg-100'
  and a~werks = '0001'
  INTO TABLE @DATA(lt_marc)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 MARC

MARC

Dictionary Fields Fields

Related References & SQL