SAP ABAP Table BIW_MARA_S (Provider Structure for Material Master Data from MARA)
Hierarchy
☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ MDX (Package) Master Data Extractors
Basic Data
Table Category INTTAB    Structure 
Structure BIW_MARA_S   Table Relationship Diagram
Short Description Provider Structure for Material Master Data from MARA    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client *
2 MATNR MATNR MATNR CHAR 18   0   Material Number *
3 ERSDA ERSDA DATUM DATS 8   0   Created On  
4 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
5 LAEDA LAEDA DATUM DATS 8   0   Date of Last Change  
6 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
7 VPSTA VPSTA PSTAT CHAR 15   0   Maintenance status of complete material  
8 PSTAT PSTAT_D PSTAT CHAR 15   0   Maintenance status  
9 LVORM LVOMA XFELD CHAR 1   0   Flag Material for Deletion at Client Level  
10 MTART MTART MTART CHAR 4   0   Material type *
11 MBRSH MBRSH MBRSH CHAR 1   0   Industry sector *
12 MATKL MATKL MATKL CHAR 9   0   Material Group *
13 BISMT BISMT BISMT CHAR 18   0   Old material number  
14 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
15 BSTME BSTME MEINS UNIT 3   0   Order unit *
16 ZEINR DZEINR CHAR22 CHAR 22   0   Document number (without document management system)  
17 ZEIAR DZEIAR ZEIAR CHAR 3   0   Document type (without Document Management system)  
18 ZEIVR DZEIVR VERSI CHAR 2   0   Document version (without Document Management system)  
19 ZEIFO DZEIFO DINFO CHAR 4   0   Page format of document (without Document Management system)  
20 AESZN AESZN AENUM CHAR 6   0   Document change number (without document management system)  
21 BLATT BLATT BLATT CHAR 3   0   Page number of document (without Document Management system)  
22 BLANZ BLANZ NUM3 NUMC 3   0   Number of sheets (without Document Management system)  
23 FERTH FERTH FERTH CHAR 18   0   Production/inspection memo  
24 FORMT FORMT DINFO CHAR 4   0   Page Format of Production Memo  
25 GROES GROES CHAR32 CHAR 32   0   Size/dimensions  
26 WRKST WRKST WRKST CHAR 48   0   Basic Material *
27 NORMT NORMT NORMT CHAR 18   0   Industry Standard Description (such as ANSI or ISO)  
28 LABOR LABOR LABOR CHAR 3   0   Laboratory/design office *
29 EKWSL EKWSL EKWSL CHAR 4   0   Purchasing Value Key *
30 BRGEW BRGEW MENG13 QUAN 13   3   Gross weight  
31 NTGEW NTGEW MENG13 QUAN 13   3   Net weight  
32 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit *
33 VOLUM VOLUM MENG13 QUAN 13   3   Volume  
34 VOLEH VOLEH MEINS UNIT 3   0   Volume unit *
35 BEHVO BEHVO BEHVO CHAR 2   0   Container requirements *
36 RAUBE RAUBE RAUBE CHAR 2   0   Storage conditions *
37 TEMPB TEMPB TEMPB CHAR 2   0   Temperature conditions indicator *
38 DISST DISST DISST CHAR 3   0   Low-level code  
39 TRAGR TRAGR TRAGR CHAR 4   0   Transportation Group *
40 STOFF STOFF STOFF CHAR 18   0   Hazardous material number *
41 SPART SPART SPART CHAR 2   0   Division *
42 KUNNR WETTB KUNNR CHAR 10   0   Competitor *
43 EANNR EANNR CHAR13 CHAR 13   0   European Article Number (EAN) - obsolete!!!!!  
44 WESCH WESCH MENG13 QUAN 13   3   Quantity: Number of GR/GI slips to be printed  
45 BWVOR BWVOR BWVOR CHAR 1   0   Procurement rule *
46 BWSCL BWSCL BQSCL CHAR 1   0   Source of Supply *
47 SAISO SAISO SAISO CHAR 4   0   Season Category *
48 ETIAR ETIAR ETIAR CHAR 2   0   Label type *
49 ETIFO ETIFO ETIFO CHAR 2   0   Label form *
50 ENTAR ENTAR ENTAR CHAR 1   0   Disposal type *
51 EAN11 EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
52 NUMTP NUMTP NUMTP CHAR 2   0   Category of International Article Number (EAN) *
53 LAENG LAENG MENG13 QUAN 13   3   Length  
54 BREIT BREIT MENG13 QUAN 13   3   Width  
55 HOEHE HOEHE MENG13 QUAN 13   3   Height  
56 MEABM MEABM MEINS UNIT 3   0   Unit of Dimension for Length/Width/Height *
57 PRDHA PRODH_D PRODH CHAR 18   0   Product Hierarchy *
58 AEKLK CK_AEKLK XFELD CHAR 1   0   Stock transfer net change costing  
59 CADKZ CADKZ XFELD CHAR 1   0   CAD Indicator  
60 QMPUR QMPUR XFELD CHAR 1   0   QM in procurement is active  
61 ERGEW ERGEW MENG13 QUAN 13   3   Allowed packaging weight  
62 ERGEI ERGEI MEINS UNIT 3   0   Unit of weight (allowed packaging weight) *
63 ERVOL ERVOL MENG13 QUAN 13   3   Allowed packaging volume  
64 ERVOE ERVOE MEINS UNIT 3   0   Volume unit (allowed packaging volume) *
65 GEWTO GEWTO PRZ21 DEC 3   1   Excess weight tolerance for shipping unit  
66 VOLTO VOLTO PRZ21 DEC 3   1   Excess volume tolerance limit during packing  
67 VABME VABME VABME CHAR 1   0   Variable Purchase Order Unit Active  
68 KZREV KZREV XFELD CHAR 1   0   Indicator: revision level has been assigned to the material  
69 KZKFG KZKFG XFELD CHAR 1   0   Configurable Material  
70 XCHPF XCHPF XFELD CHAR 1   0   Batch management requirement indicator  
71 VHART VHIART TRATY CHAR 4   0   Shipping material type *
72 FUELG FUELG DEC3 DEC 3   0   Filling level (by volume)  
73 STFAK STFAK INT2 INT2 5   0   Stacking factor  
74 MAGRV MAGRV MAGRV CHAR 4   0   Material Group: Packaging Materials *
75 BEGRU BEGRU BEGRU CHAR 4   0   Authorization Group  
76 DATAB DATAB DATUM DATS 8   0   Valid-From Date  
77 LIQDT LIQDT DATUM DATS 8   0   Deletion date  
78 SAISJ SAISJ CJAHR CHAR 4   0   Season Year  
79 PLGTP PLGTP PLGTP CHAR 2   0   Price band category *
80 MLGUT W_MITLEERG FLAG CHAR 1   0   Empties Bill of Material  
81 EXTWG EXTWG EXTWG CHAR 18   0   External material group *
82 SATNR SATNR MATNR CHAR 18   0   Cross-Plant Configurable Material *
83 ATTYP ATTYP ATTYP CHAR 2   0   Material Category  
84 KZKUP KZKUPMAT FLAG CHAR 1   0   Indicator: Material can be co-product  
85 KZNFM KZNFM XFELD CHAR 1   0   Indicator: The material has a follow-up material  
86 PMATA PMATN MATNR CHAR 18   0   Pricing Reference Material *
87 MSTAE MSTAE MMSTA CHAR 2   0   Cross-Plant Material Status *
88 MSTAV MSTAV VMSTA CHAR 2   0   Cross-distribution-chain material status *
89 MSTDE MSTDE DATUM DATS 8   0   Date from which the cross-plant material status is valid  
90 MSTDV MSTDV DATUM DATS 8   0   Date from which the X-distr.-chain material status is valid  
91 TAKLV TAKLV TAXKM CHAR 1   0   Tax Classification of Material *
92 RBNRM RBNR RBNR CHAR 9   0   Report layout *
93 MHDRZ MHDRZ DEC4 DEC 4   0   Minimum Remaining Shelf Life  
94 MHDHB MHDHB DEC4 DEC 4   0   Total shelf life  
95 MHDLP MHDLP DEC3 DEC 3   0   Storage percentage  
96 INHME INHME MEINS UNIT 3   0   Content unit *
97 INHAL INHAL MENG13 QUAN 13   3   Net contents  
98 VPREH VPREH PACK3 DEC 5   0   Comparison price unit  
99 ETIAG ETIAG ETIAG CHAR 18   0   IS-R Labeling: material grouping (deactivated in 4.0) *
100 INHBR INHBR MENG13 QUAN 13   3   Gross contents  
101 CMETH OIB_CMETH OIB_CMETH CHAR 1   0   Quantity Conversion Method  
102 CUOBF CUOBM CUOBJ NUMC 18   0   Internal object number  
103 KZUMW KZUMW XFELD CHAR 1   0   Indicator: Environmentally relevant  
104 KOSCH KOSCH KOSCH CHAR 18   0   Product allocation determination procedure *
105 SPROF SPROF SPROF CHAR 1   0   Pricing profile for variants  
106 NRFHG NRFHG NRFHG CHAR 1   0   Material qualifies for discount in kind  
107 MFRPN MFRPN CHAR40 CHAR 40   0   Manufacturer Part Number  
108 MFRNR MFRNR LIFNR CHAR 10   0   Manufacturer number *
109 BMATN MPMAT MATNR CHAR 18   0   Number of firm's own (internal) inventory-managed material *
110 MPROF MPROF MPROF CHAR 4   0   Mfr part profile *
111 KZWSM KZWSO KZWSO CHAR 1   0   Units of measure usage  
112 SAITY SAITY SAITY CHAR 2   0   Categories of seasonal materials *
113 PROFL ADGE_PROFL ADGD_PROFL CHAR 3   0   Dangerous goods indicator profile *
114 IHIVI ADGE_IHIVI X CHAR 1   0   Indicator: Highly viscous  
115 ILOOS ADGE_ILOOS X CHAR 1   0   Indicator: In bulk/liquid  
116 SERLV SERLV SERLV CHAR 1   0   Level of Explicitness for Serial Number  
117 KZGVH KZGVH XFELD CHAR 1   0   Shipping material is closed packaging  
118 XGCHP XGCHP XFELD CHAR 1   0   Indicator: Approved batch record required  
119 KZEFF CC_MTEFF XFELD CHAR 1   0   Assign effectivity parameter values/ override change numbers  
120 COMPL CSCP_COMP_LVL CSCP_COMP_LVL NUMC 2   0   Material completion level *
121 IPRKZ DATTP DATTP CHAR 1   0   Period Indicator for Shelf Life Expiration Date  
122 RDMHD RDMHD RDMHD CHAR 1   0   Rounding rule for calculation of SLED  
123 PRZUS PRZUS XFELD CHAR 1   0   Indicator: Product composition printed on packaging  
124 MTPOS_MARA MTPOS_MARA MTPOS CHAR 4   0   General item category group *
125 BFLME BFLME BFLME CHAR 1   0   Generic Material with Logistical Variants  
126 .INCLU--AP       0   0   Append MARA-NSNID  
127 NSNID DFPS_NSNID DFPS_NSNID CHAR 9   0   NATO Stock Number  
128 .INCLU--AP       0   0   Vendor Structure Enhancement: Fashion Fields for Mat. Master  
129 .INCLUDE       0   0   MARA Extension with New Fields: Seasonal Procurement  
130 COLOR_ATINN WRF_COLOR_ATINN ATINN NUMC 10   0   Internal Charactieristic Number for Color Characteristics *
131 SIZE1_ATINN WRF_SIZE1_ATINN ATINN NUMC 10   0   Internal Char. Number for Characteristics for Main Sizes *
132 SIZE2_ATINN WRF_SIZE2_ATINN ATINN NUMC 10   0   Internal Char. Number for Characteristics for Second Sizes *
133 COLOR WRF_COLOR WRF_ATWRT CHAR 18   0   Characteristic Value for Colors of Variants  
134 SIZE1 WRF_SIZE1 WRF_ATWRT CHAR 18   0   Characteristic Value for Main Sizes of Variants  
135 SIZE2 WRF_SIZE2 WRF_ATWRT CHAR 18   0   Characteristic Value for Second Size for Variants  
136 FREE_CHAR WRF_FREE_CHAR WRF_ATWRT CHAR 18   0   Characteristic Value for Evaluation Purposes  
137 CARE_CODE WRF_CARE_CODE WRF_CARE_CODE CHAR 16   0   Care Codes (such as Washing Code, Ironing Code, etc.)  
138 BRAND_ID WRF_BRAND_ID WRF_BRAND_ID CHAR 4   0   Brand WRF_BRANDS
139 FIBER_CODE1 WRF_FIBER_CODE_1 WRF_FIBER_CODE CHAR 3   0   Fiber Code for Textiles (Component 1) WRF_FIBER_CODES
140 FIBER_PART1 WRF_FIBER_PART_1 WRF_FIBER_PART NUMC 3   0   Percentage Share of Fiber (Component 1)  
141 FIBER_CODE2 WRF_FIBER_CODE_2 WRF_FIBER_CODE CHAR 3   0   Fiber Code for Textiles (Component 2) WRF_FIBER_CODES
142 FIBER_PART2 WRF_FIBER_PART_2 WRF_FIBER_PART NUMC 3   0   Percentage Share of Fiber (Component 2)  
143 FIBER_CODE3 WRF_FIBER_CODE_3 WRF_FIBER_CODE CHAR 3   0   Fiber Code for Textiles (Component 3) WRF_FIBER_CODES
144 FIBER_PART3 WRF_FIBER_PART_3 WRF_FIBER_PART NUMC 3   0   Percentage Share of Fiber (Component 3)  
145 FIBER_CODE4 WRF_FIBER_CODE_4 WRF_FIBER_CODE CHAR 3   0   Fiber Code for Textiles (Component 4) WRF_FIBER_CODES
146 FIBER_PART4 WRF_FIBER_PART_4 WRF_FIBER_PART NUMC 3   0   Percentage Share of Fiber (Component 4)  
147 FIBER_CODE5 WRF_FIBER_CODE_5 WRF_FIBER_CODE CHAR 3   0   Fiber Code for Textiles (Component 5) WRF_FIBER_CODES
148 FIBER_PART5 WRF_FIBER_PART_5 WRF_FIBER_PART NUMC 3   0   Percentage Share of Fiber (Component 5)  
149 .INCLU--AP       0   0   Degree of Fashion Extension  
150 FASHGRD FASHGRD FASHGRD CHAR 4   0   Fashion Grade  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 BIW_MARA_S BRAND_ID WRF_BRANDS BRAND_ID    
2 BIW_MARA_S FIBER_CODE1 WRF_FIBER_CODES FIBER_CODE KEY 1 CN
3 BIW_MARA_S FIBER_CODE2 WRF_FIBER_CODES FIBER_CODE KEY 1 CN
4 BIW_MARA_S FIBER_CODE3 WRF_FIBER_CODES FIBER_CODE KEY 1 CN
5 BIW_MARA_S FIBER_CODE4 WRF_FIBER_CODES FIBER_CODE KEY 1 CN
6 BIW_MARA_S FIBER_CODE5 WRF_FIBER_CODES FIBER_CODE KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in