SE11 ABAP Dictionary SE11 MARA

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

MARA

General Material Data
SAP MM Transparent Table 210 Fields
Primary Key:
MANDT MATNR

Dictionary Fields Fields

(210 dari 210 kolom)
# 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
ERSDA
- Created DATS 8 - - Created On
4
ERNAM
- Created CHAR 12 - - Name of Person who Created the Object
5
LAEDA
- Last Chg. DATS 8 - - Date of Last Change
6
AENAM
- By CHAR 12 - - Name of Person Who Changed Object
7
VPSTA
- Maint.stat CHAR 15 - - Maintenance status of complete material
8
PSTAT
- Status CHAR 15 - - Maintenance status
9
LVORM
- Client lvl CHAR 1 - - Flag Material for Deletion at Client Level
10
MTART
- Matl Type CHAR 4 - - Material Type
11
MBRSH
- Industry CHAR 1 - - Industry sector
12
MATKL
- Matl Group CHAR 9 - - Material Group
13
BISMT
- Matl no. CHAR 18 - - Old material number
14
MEINS
- Unit UNIT 3 - - Base Unit of Measure
15
BSTME
- Order Unit UNIT 3 - - Purchase Order Unit of Measure
16
ZEINR
- Document CHAR 22 - - Document number (without document management system)
17
ZEIAR
- Doc.type CHAR 3 - - Document type (without Document Management system)
18
ZEIVR
- Doc.vers. CHAR 2 - - Document version (without Document Management system)
19
ZEIFO
- Format CHAR 4 - - Page format of document (without Document Management system)
20
AESZN
- Doc.ch.no. CHAR 6 - - Document change number (without document management system)
21
BLATT
- Page no. CHAR 3 - - Page number of document (without Document Management system)
22
BLANZ
- No. sheets NUMC 3 - - Number of sheets (without Document Management system)
23
FERTH
- Prod. memo CHAR 18 - - Production/inspection memo
24
FORMT
- Format CHAR 4 - - Page Format of Production Memo
25
GROES
- Size/dim. CHAR 32 - - Size/dimensions
26
WRKST
- Basic matl CHAR 48 - - Basic Material
27
NORMT
- IStd Desc CHAR 18 - - Industry Standard Description (such as ANSI or ISO)
28
LABOR
- Laboratory CHAR 3 - - Laboratory/design office
29
EKWSL
- PV key CHAR 4 - - Purchasing Value Key
30
BRGEW
- Gross QUAN 13 3 - Gross Weight
31
NTGEW
- Net QUAN 13 3 - Net Weight
32
GEWEI
- WeightUnit UNIT 3 - - Weight Unit
33
VOLUM
- Volume QUAN 13 3 - Volume
34
VOLEH
- VolumeUnit UNIT 3 - - Volume unit
35
BEHVO
- Container CHAR 2 - - Container requirements
36
RAUBE
- Stor.cond. CHAR 2 - - Storage conditions
37
TEMPB
- Temp.conds CHAR 2 - - Temperature conditions indicator
38
DISST
- L-L code CHAR 3 - - Low-Level Code
39
TRAGR
- Trans. Grp CHAR 4 - - Transportation Group
40
STOFF
- Haz. CHAR 18 - - Hazardous material number
41
SPART
- Division CHAR 2 - - Division
42
KUNNR
- Competitor CHAR 10 - KNA1 Competitor
43
EANNR
- EAN no. CHAR 13 - - European Article Number (EAN) - obsolete!!!!!
44
WESCH
- Quantity QUAN 13 3 - Quantity: Number of GR/GI slips to be printed
45
BWVOR
- Proc. rule CHAR 1 - - Procurement rule
46
BWSCL
- Source CHAR 1 - - Source of Supply
47
SAISO
- Season CHAR 4 - - Season Category
48
ETIAR
- Label type CHAR 2 - - Label type
49
ETIFO
- Label form CHAR 2 - - Label form
50
ENTAR
- Deact. CHAR 1 - - Deactivated
51
EAN11
- EAN/UPC CHAR 18 - - International Article Number (EAN/UPC)
52
NUMTP
- EAN Cat. CHAR 2 - - Category of International Article Number (EAN)
53
LAENG
- Length QUAN 13 3 - Length
54
BREIT
- Width QUAN 13 3 - Width
55
HOEHE
- Height QUAN 13 3 - Height
56
MEABM
- Unit UNIT 3 - - Unit of Dimension for Length/Width/Height
57
PRDHA
- Prod.hier. CHAR 18 - - Product hierarchy
58
AEKLK
- Net Change CHAR 1 - - Stock Transfer Net Change Costing
59
CADKZ
- CAD Ind. CHAR 1 - - CAD Indicator
60
QMPUR
- QM-procmnt CHAR 1 - - QM in Procurement is Active
61
ERGEW
- Allowed wt QUAN 13 3 - Allowed packaging weight
62
ERGEI
- Unit UNIT 3 - - Unit of weight (allowed packaging weight)
63
ERVOL
- Allwd vol. QUAN 13 3 - Allowed packaging volume
64
ERVOE
- VolumeUnit UNIT 3 - - Volume unit (allowed packaging volume)
65
GEWTO
- ExWghtTol. DEC 3 1 - Excess Weight Tolerance for Handling unit
66
VOLTO
- Ex.vol.tol DEC 3 1 - Excess Volume Tolerance of the Handling Unit
67
VABME
- Var. OUn CHAR 1 - - Variable Purchase Order Unit Active
68
KZREV
- Rev. Level CHAR 1 - - Revision Level Has Been Assigned to the Material
69
KZKFG
- Configur. CHAR 1 - - Configurable Material
70
XCHPF
- Batch mgmt CHAR 1 - - Batch management requirement indicator
71
VHART
- PkgMtlType CHAR 4 - - Packaging Material Type
72
FUELG
- Max.level DEC 3 - - Maximum level (by volume)
73
STFAK
- Stack fctr INT2 5 - - Stacking factor
74
MAGRV
- Mat.Grp PM CHAR 4 - - Material Group: Packaging Materials
75
BEGRU
- AuthGrp CHAR 4 - - Authorization Group
76
DATAB
- Valid From DATS 8 - - Valid-From Date
77
LIQDT
- Valid to DATS 8 - - Deletion date
78
SAISJ
- Season Yr CHAR 4 - - Season Year
79
PLGTP
- Price band CHAR 2 - - Price Band Category
80
MLGUT
- EmptiesBOM CHAR 1 - - Empties Bill of Material
81
EXTWG
- ExtMatlGrp CHAR 18 - - External Material Group
82
SATNR
- Conf. matl CHAR 18 - - Cross-Plant Configurable Material
83
ATTYP
- Matl Cat. CHAR 2 - - Material Category
84
KZKUP
- Co-product CHAR 1 - - Indicator: Material can be co-product
85
KZNFM
- Follow-up CHAR 1 - - Indicator: The material has a follow-up material
86
PMATA
- Pr.RefMatl CHAR 18 - - Pricing Reference Material
87
MSTAE
- MatlStatus CHAR 2 - - Cross-Plant Material Status
88
MSTAV
- Status CHAR 2 - - Cross-distribution-chain material status
89
MSTDE
- Valid from DATS 8 - - Date from which the cross-plant material status is valid
90
MSTDV
- Valid from DATS 8 - - Date from which the X-distr.-chain material status is valid
91
TAKLV
- Tax class. CHAR 1 - - Tax classification of the material
92
RBNRM
- Cat. Prof. CHAR 9 - - Catalog Profile
93
MHDRZ
- Rem. Life DEC 4 - - Minimum Remaining Shelf Life
94
MHDHB
- Shelf life DEC 4 - - Total shelf life
95
MHDLP
- Storage % DEC 3 - - Storage percentage
96
INHME
- Cont. unit UNIT 3 - - Content unit
97
INHAL
- Net cnts QUAN 13 3 - Net contents
98
VPREH
- / DEC 5 - - Comparison price unit
99
ETIAG
- LaMatGrpg CHAR 18 - - IS-R Labeling: material grouping (deactivated in 4.0)
100
INHBR
- Gross cnts QUAN 13 3 - Gross contents
101
CMETH
- Conv. Meth CHAR 1 - - Quantity Conversion Method
102
CUOBF
- Int.obj.no NUMC 18 - - Internal object number
103
KZUMW
- Envt. rlvt CHAR 1 - - Environmentally Relevant
104
KOSCH
- Prod.all. CHAR 18 - - Product allocation determination procedure
105
SPROF
- Pr.profile CHAR 1 - - Pricing profile for variants
106
NRFHG
- DiK CHAR 1 - - Material qualifies for discount in kind
107
MFRPN
- MPN CHAR 40 - - Manufacturer Part Number
108
MFRNR
- Manufact. CHAR 10 - - Number of a Manufacturer
109
BMATN
- Int. no. CHAR 18 - - Number of firm's own (internal) inventory-managed material
110
MPROF
- MPP CHAR 4 - - Manufacturer Part Profile
111
KZWSM
- Usage UoM CHAR 1 - - Units of measure usage
112
SAITY
- Rollout CHAR 2 - - Rollout in a Season
113
PROFL
- DGProfile CHAR 3 - - Dangerous Goods Indicator Profile
114
IHIVI
- HighlyVisc CHAR 1 - - Indicator: Highly Viscous
115
ILOOS
- BulkLiquid CHAR 1 - - Indicator: In Bulk/Liquid
116
SERLV
- SerLevel CHAR 1 - - Level of Explicitness for Serial Number
117
KZGVH
- Closed CHAR 1 - - Packaging Material is Closed Packaging
118
XGCHP
- Batch rec. CHAR 1 - - Indicator: Approved batch record required
119
KZEFF
- Eff.values CHAR 1 - - Assign effectivity parameter values/ override change numbers
120
COMPL
- CompLvl NUMC 2 - - Material completion level
121
IPRKZ
- Per. Ind. CHAR 1 - - Period Indicator for Shelf Life Expiration Date
122
RDMHD
- Round.rule CHAR 1 - - Rounding rule for calculation of SLED
123
PRZUS
- Prod.Comp. CHAR 1 - - Indicator: Product composition printed on packaging
124
MTPOS_MARA
- GenItCatGr CHAR 4 - - General item category group
125
BFLME
- Log. vars CHAR 1 - - Generic Material with Logistical Variants
126
MATFI
- Locked CHAR 1 - - Material Is Locked
127
CMREL
- CM rel. CHAR 1 - - Relevant for Configuration Management
128
BBTYP
- AListType CHAR 1 - - Assortment List Type
129
SLED_BBD
- Expir.Date CHAR 1 - - Expiration Date
130
GTIN_VARIANT
- EAN Var. CHAR 2 - - Global Trade Item Number Variant
131
GENNR
- Gen. Mat. CHAR 18 - - Material Number of the Generic Material in Prepack Materials
132
RMATP
- RefMatPack CHAR 18 - - Reference material for materials packed in same way
133
GDS_RELEVANT
- GDS-Rel. CHAR 1 - - Indicator: Global Data Synchronization-Relevant
134
WEORA
- Orig. Acc. CHAR 1 - - Acceptance At Origin
135
HUTYP_DFLT
- StHUTyp CHAR 4 - - Standard HU Type
136
PILFERABLE
- Pilferable CHAR 1 - - Pilferable
137
WHSTC
- WHStCond CHAR 2 - - Warehouse Storage Condition
138
WHMATGR
- WHMatGrp CHAR 4 - - Warehouse Material Group
139
HNDLCODE
- Hand.Ind. CHAR 4 - - Handling Indicator
140
HAZMAT
- Haz. Sub. CHAR 1 - - Relevant for Hazardous Substances
141
HUTYP
- HUTyp CHAR 4 - - Handling Unit Type
142
TARE_VAR
- Var.TW CHAR 1 - - Variable Tare Weight
143
MAXC
- Max.Cap DEC 15 3 - Maximum Allowed Capacity of Packaging Material
144
MAXC_TOL
- Ovrcap.Tol DEC 3 1 - Overcapacity Tolerance of the Handling Unit
145
MAXL
- Max. Leng. QUAN 15 3 - Maximum Packing Length of Packaging Material
146
MAXB
- Max. Width QUAN 15 3 - Maximum Packing Width of Packaging Material
147
MAXH
- Max.Height QUAN 15 3 - Maximum Packing Height of Packaging Material
148
MAXDIM_UOM
- UoM UNIT 3 - - Unit of Measure for Maximum Packing Length/Width/Height
149
HERKL
- Origin CHAR 3 - - Country of origin of the material
150
MFRGR
- MatlFrtGrp CHAR 8 - - Material freight group
151
QQTIME
- QPer. QUAN 3 - - Quarantine Period
152
QQTIMEUOM
- Time Unit UNIT 3 - - Time Unit for Quarantine Period
153
QGRP
- QualInsGrp CHAR 4 - - Quality Inspection Group
154
SERIAL
- SN Prof. CHAR 4 - - Serial Number Profile
155
PS_SMARTFORM
- Name CHAR 30 - - Form Name
156
LOGUNIT
- Log. UoM UNIT 3 - - EWM CW: Logistics Unit of Measure
157
CWQREL
- CW-Relev. CHAR 1 - - EWM CW: Material Is a Catch Weight Material
158
CWQPROC
- CW Profile CHAR 2 - - EWM CW: Catch Weight Profile for Entering CW Quantity
159
CWQTOLGR
- Tol. Group CHAR 9 - - EWM-CW: Catch Weight Tolerance Group for EWM
160
ADPROF
- Profile CHAR 3 - - Adjustment Profile
161
/BEV1/LULEINH
- LU NUMC 8 - - Loading Units
162
/BEV1/LULDEGRP
- LU Group CHAR 3 - - Loading Unit Group: IS Beverage
163
/BEV1/NESTRUCCAT
- Category CHAR 1 - - Structure Category for Material Relationship
164
/DSD/SL_TOLTYP
- TolTypeID CHAR 4 - - Tolerance Type ID
165
/DSD/SV_CNT_GRP
- CountGrp. CHAR 10 - - Counting Group
166
/DSD/VC_GROUP
- DSD Group. CHAR 6 - - DSD Grouping
167
/VSO/R_TILT_IND
- Tilting CHAR 1 - - Material may be Tilted (Vehicle Space Optimization)
168
/VSO/R_STACK_IND
- No Stack. CHAR 1 - - Stacking not Allowed (VSO)
169
/VSO/R_BOT_IND
- Bott.Layer CHAR 1 - - Bottom Layer (Vehicle Space Optimization)
170
/VSO/R_TOP_IND
- Top Layer CHAR 1 - - Top Layer (VSO)
171
/VSO/R_STACK_NO
- StckFactor NUMC 3 - - Stacking Factor (Vehicle Space Optimization)
172
/VSO/R_PAL_IND
- w/o PKM CHAR 1 - - Load without Packaging Material (VSO)
173
/VSO/R_PAL_OVR_D
- OverhDepth QUAN 13 3 - Permissible Overhang (Depth) of Packaging Material (VSO)
174
/VSO/R_PAL_OVR_W
- OverhWidth QUAN 13 3 - Permissible Overhang (Width) of Shipping Material (VSO)
175
/VSO/R_PAL_B_HT
- Max.StackH QUAN 13 3 - Maximum Stacking Height of the Packaging Material (VSO)
176
/VSO/R_PAL_MIN_H
- Min.StackH QUAN 13 3 - Minimum Stacking Height of the Packaging Material (VSO)
177
/VSO/R_TOL_B_HT
- Stack.Tol. QUAN 13 3 - Tolerance to Exceed the Max. Stacking Height (VSO)
178
/VSO/R_NO_P_GVH
- Mat / PKM NUMC 2 - - Number of Materials for each Closed PKM (VSO)
179
/VSO/R_QUAN_UNIT
- UoM VSO UNIT 3 - - Unit of Measure Vehicle Space Optimization
180
/VSO/R_KZGVH_IND
- Closed PKM CHAR 1 - - Closed Packaging Material Required (VSO)
181
PACKCODE
- PackCode CHAR 10 - - Packaging Code
182
DG_PACK_STATUS
- DGPckg.Sts CHAR 10 - - Dangerous Goods Packaging Status
183
MCOND
- Matl Cond. CHAR 1 - - Material Condition Management
184
RETDELC
- Rt. Cd CHAR 1 - - Return Code
185
LOGLEV_RETO
- To LogLvl CHAR 1 - - Return to Logistics Level
186
NSNID
- NSN CHAR 9 - - NATO Stock Number
187
ADSPC_SPC
- SPC NUMC 1 - - Spare Part Class Code
188
IMATN
- FFF class CHAR 18 - - FFF class
189
PICNUM
- Chain no CHAR 18 - - Supersession chain number
190
BSTAT
- Status CHAR 2 - - Creation Status - Seasonal Procurement
191
COLOR_ATINN
- Int. Char. NUMC 10 - - Internal Charactieristic Number for Color Characteristics
192
SIZE1_ATINN
- Int. Char. NUMC 10 - - Internal Char. Number for Characteristics for Main Sizes
193
SIZE2_ATINN
- Int. Char. NUMC 10 - - Internal Char. Number for Characteristics for Second Sizes
194
COLOR
- Color CHAR 18 - - Characteristic Value for Colors of Variants
195
SIZE1
- Size 1 CHAR 18 - - Characteristic Value for Main Sizes of Variants
196
SIZE2
- Size 2 CHAR 18 - - Characteristic Value for Second Size for Variants
197
FREE_CHAR
- Value CHAR 18 - - Characteristic Value for Evaluation Purposes
198
CARE_CODE
- Care Code CHAR 16 - - Care Codes (such as Washing Code, Ironing Code, etc.)
199
BRAND_ID
- Brand CHAR 4 - - Brand
200
FIBER_CODE1
- Component1 CHAR 3 - - Fiber Code for Textiles (Component 1)
201
FIBER_PART1
- % Share 1 NUMC 3 - - Percentage Share of Fiber (Component 1)
202
FIBER_CODE2
- Component2 CHAR 3 - - Fiber Code for Textiles (Component 2)
203
FIBER_PART2
- % Share 2 NUMC 3 - - Percentage Share of Fiber (Component 2)
204
FIBER_CODE3
- Component3 CHAR 3 - - Fiber Code for Textiles (Component 3)
205
FIBER_PART3
- % Share 3 NUMC 3 - - Percentage Share of Fiber (Component 3)
206
FIBER_CODE4
- Component4 CHAR 3 - - Fiber Code for Textiles (Component 4)
207
FIBER_PART4
- % Share 4 NUMC 3 - - Percentage Share of Fiber (Component 4)
208
FIBER_CODE5
- Component5 CHAR 3 - - Fiber Code for Textiles (Component 5)
209
FIBER_PART5
- % Share 5 NUMC 3 - - Percentage Share of Fiber (Component 5)
210
FASHGRD
- FG CHAR 4 - - Fashion Grade

Related References & SQL

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

ANSI SQL Query 
SELECT a.MATNR,
       a.ERSDA,
       a.ERNAM,
       a.LAEDA,
       a.AENAM,
       a.VPSTA
FROM MARA AS a
WHERE a.MATNR = 'FG-100';
ABAP OpenSQL (7.40+) 
SELECT a~matnr,
       a~ersda,
       a~ernam,
       a~laeda,
       a~aenam,
       a~vpsta
  FROM mara AS a
  WHERE a~matnr = 'fg-100'
  INTO TABLE @DATA(lt_mara)
  UP TO 100 ROWS.
Mencari di seluruh SAP Knowledge Hub...
Tidak ditemukan hasil untuk ""
Cek "" langsung di Kamus SE11