SAP ABAP Table BAPIE1MARART (Retail Data Transfer: Material Data at Client level)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       MGW (Package) Application development R/3 material master Retail
Basic Data
Table Category INTTAB    Structure 
Structure BAPIE1MARART   Table Relationship Diagram
Short Description Retail Data Transfer: Material Data at Client level    
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 FUNCTION MSGFN MSGFN CHAR 3   0   Function  
2 MATERIAL MATNR MATNR CHAR 18   0   Material Number MARA
3 CREATED_ON ERSDA DATUM DATS 8   0   Created On  
4 CREATED_BY ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
5 LAST_CHNGE LAEDA DATUM DATS 8   0   Date of Last Change  
6 CHANGED_BY AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
7 DEL_FLAG LVOMA XFELD CHAR 1   0   Flag Material for Deletion at Client Level  
8 OLD_MAT_NO BISMT BISMT CHAR 18   0   Old material number  
9 BASE_UOM MEINS MEINS UNIT 3   0   Base Unit of Measure T006
10 BASE_UOM_ISO MEINS_ISO ISOCD_UNIT CHAR 3   0   Base unit of measure in ISO code T006I
11 PO_UNIT BSTME MEINS UNIT 3   0   Order unit T006
12 PO_UNIT_ISO BSTME_ISO ISOCD_UNIT CHAR 3   0   Order unit in ISO code T006I
13 DOCUMENT DZEINR CHAR22 CHAR 22   0   Document number (without document management system)  
14 DOC_TYPE DZEIAR ZEIAR CHAR 3   0   Document type (without Document Management system)  
15 DOC_VERS DZEIVR VERSI CHAR 2   0   Document version (without Document Management system)  
16 DOC_FORMAT DZEIFO DINFO CHAR 4   0   Page format of document (without Document Management system)  
17 DOC_CHG_NO AESZN AENUM CHAR 6   0   Document change number (without document management system)  
18 PAGE_NO BLATT BLATT CHAR 3   0   Page number of document (without Document Management system)  
19 NO_SHEETS BLANZ NUM3 NUMC 3   0   Number of sheets (without Document Management system)  
20 PROD_MEMO FERTH FERTH CHAR 18   0   Production/inspection memo  
21 PAGEFORMAT FORMT DINFO CHAR 4   0   Page Format of Production Memo  
22 SIZE_DIM GROES CHAR32 CHAR 32   0   Size/dimensions  
23 BASIC_MATL WRKST_OLD WRKST_OLD CHAR 14   0   Basic material (basic constituent of a material) - obsolete *
24 STD_DESCR NORMT NORMT CHAR 18   0   Industry Standard Description (such as ANSI or ISO)  
25 LAB_DESIGN LABOR LABOR CHAR 3   0   Laboratory/design office T024L
26 PUR_VALKEY EKWSL EKWSL CHAR 4   0   Purchasing Value Key T405
27 NET_WEIGHT NTGEW MENG13 QUAN 13   3   Net weight  
28 CONTAINER BEHVO BEHVO CHAR 2   0   Container requirements T144
29 STOR_CONDS RAUBE RAUBE CHAR 2   0   Storage conditions T142
30 TEMP_CONDS TEMPB TEMPB CHAR 2   0   Temperature conditions indicator T143
31 TRANS_GRP TRAGR TRAGR CHAR 4   0   Transportation Group TTGR
32 HAZ_MAT_NO STOFF STOFF CHAR 18   0   Hazardous material number MGEF
33 DIVISION SPART SPART CHAR 2   0   Division TSPA
34 COMPETITOR WETTB KUNNR CHAR 10   0   Competitor KNA1
35 QTY_GR_GI WESCH MENG13 QUAN 13   3   Quantity: Number of GR/GI slips to be printed  
36 PROC_RULE BWVOR BWVOR CHAR 1   0   Procurement rule T6WP1
37 SUP_SOURCE BWSCL BQSCL CHAR 1   0   Source of Supply TMBW1
38 SEASON SAISO SAISO CHAR 4   0   Season Category T6WSP
39 LABEL_TYPE ETIAR ETIAR CHAR 2   0   Label type T6WP3
40 LABEL_FORM ETIFO ETIFO CHAR 2   0   Label form T6WP4
41 PROD_HIER PRODH_D PRODH CHAR 18   0   Product Hierarchy T179
42 CAD_ID CADKZ XFELD CHAR 1   0   CAD Indicator  
43 ALLOWED_WT ERGEW MENG13 QUAN 13   3   Allowed packaging weight  
44 PACK_WT_UN ERGEI MEINS UNIT 3   0   Unit of weight (allowed packaging weight) T006
45 PACK_WT_UN_ISO ERGEI_ISO ISOCD_UNIT CHAR 3   0   Unit of weight (allowed packaging weight) in ISO code T006I
46 ALLWD_VOL ERVOL MENG13 QUAN 13   3   Allowed packaging volume  
47 PACK_VO_UN ERVOE MEINS UNIT 3   0   Volume unit (allowed packaging volume) T006
48 PACK_VO_UN_ISO ERVOE_ISO ISOCD_UNIT CHAR 3   0   Volume unit (allowed packaging volume) in ISO code T006I
49 WT_TOL_LT GEWTO PRZ21 DEC 3   1   Excess weight tolerance for shipping unit  
50 VOL_TOL_LT VOLTO PRZ21 DEC 3   1   Excess volume tolerance limit during packing  
51 VAR_ORD_UN VABME VABME CHAR 1   0   Variable Purchase Order Unit Active  
52 BATCH_MGMT XCHPF XFELD CHAR 1   0   Batch management requirement indicator  
53 SH_MAT_TYP VHIART TRATY CHAR 4   0   Shipping material type TVTY
54 FILL_LEVEL FUELG DEC3 DEC 3   0   Filling level (by volume)  
55 STACK_FACT STFAK INT2 INT2 5   0   Stacking factor  
56 MAT_GRP_SM MAGRV MAGRV CHAR 4   0   Material Group: Packaging Materials TVEGR
57 AUTH_GROUP BEGRU BEGRU CHAR 4   0   Authorization Group  
58 QM_PROCMNT QMPUR XFELD CHAR 1   0   QM in procurement is active  
59 CATPROFILE RBNR RBNR CHAR 9   0   Report layout T352B
60 MINREMLIFE MHDRZ DEC4 DEC 4   0   Minimum Remaining Shelf Life  
61 SHELF_LIFE MHDHB DEC4 DEC 4   0   Total shelf life  
62 STOR_PCT MHDLP DEC3 DEC 3   0   Storage percentage  
63 VALID_FROM DATAB DATUM DATS 8   0   Valid-From Date  
64 DELN_DATE LIQDT DATUM DATS 8   0   Deletion date  
65 SAESON_YR SAISJ CJAHR CHAR 4   0   Season Year  
66 PRICE_BAND PLGTP PLGTP CHAR 2   0   Price band category TWPT
67 EMPTIESBOM W_MITLEERG FLAG CHAR 1   0   Empties Bill of Material  
68 EXTMATLGRP EXTWG EXTWG CHAR 18   0   External material group TWEW
69 CONF_MATL SATNR MATNR CHAR 18   0   Cross-Plant Configurable Material MARA
70 PR_REF_MAT PMATN MATNR CHAR 18   0   Pricing Reference Material MARA
71 PUR_STATUS MSTAE MMSTA CHAR 2   0   Cross-Plant Material Status T141
72 SAL_STATUS MSTAV VMSTA CHAR 2   0   Cross-distribution-chain material status TVMS
73 PVALIDFROM MSTDE DATUM DATS 8   0   Date from which the cross-plant material status is valid  
74 SVALIDFROM MSTDV DATUM DATS 8   0   Date from which the X-distr.-chain material status is valid  
75 TAX_CLASS TAKLV TAXKM CHAR 1   0   Tax Classification of Material TSKM
76 CONT_UNIT INHME MEINS UNIT 3   0   Content unit T006
77 CONT_UNIT_ISO INHME_ISO ISOCD_UNIT CHAR 3   0   Content unit in ISO code T006I
78 NET_CONT INHAL MENG13 QUAN 13   3   Net contents  
79 COMPPRUNIT VPREH PACK3 DEC 5   0   Comparison price unit  
80 GROSS_CONT INHBR MENG13 QUAN 13   3   Gross contents  
81 PRPROFVAR SPROF SPROF CHAR 1   0   Pricing profile for variants  
82 QUAL_DIK NRFHG NRFHG CHAR 1   0   Material qualifies for discount in kind  
83 ENVT_RLVT KZUMW XFELD CHAR 1   0   Indicator: Environmentally relevant  
84 PROD_ALLOC KOSCH KOSCH CHAR 18   0   Product allocation determination procedure T190S
85 SEASMATCAT SAITY SAITY CHAR 2   0   Categories of seasonal materials T6WSA
86 HAZMATPROF ADGE_PROFL ADGD_PROFL CHAR 3   0   Dangerous goods indicator profile TDG41
87 HIGH_VISC ADGE_IHIVI X CHAR 1   0   Indicator: Highly viscous  
88 LOOSEORLIQ ADGE_ILOOS X CHAR 1   0   Indicator: In bulk/liquid  
89 CLOSED_BOX KZGVH XFELD CHAR 1   0   Shipping material is closed packaging  
90 APPD_B_REC XGCHP XFELD CHAR 1   0   Indicator: Approved batch record required  
91 PERIOD_IND_EXPIRATION_DATE DATTP DATTP CHAR 1   0   Period Indicator for Shelf Life Expiration Date  
92 ROUND_UP_RULE_EXPIRATION_DATE RDMHD RDMHD CHAR 1   0   Rounding rule for calculation of SLED  
93 PROD_COMPOSITION_ON_PACKAGING PRZUS XFELD CHAR 1   0   Indicator: Product composition printed on packaging  
94 ITEM_CAT MTPOS_MARA MTPOS CHAR 4   0   General item category group TPTM
95 BASIC_MATL_NEW WRKST WRKST CHAR 48   0   Basic Material TWSPR
96 CONF_MATL_EXTERNAL MGV_CONF_MATL_EXTERNAL MATNR_EXT CHAR 40   0   Long Material Number for CONF_MATL field  
97 CONF_MATL_GUID MGV_CONF_MATL_GUID MATNR_EGUID CHAR 32   0   External GUID for CONF_MATL Field  
98 CONF_MATL_VERSION MGV_CONF_MATL_VERSION MATNR_VERS CHAR 10   0   Version Number for Field CONF_MATL  
99 HAZ_MAT_NO_EXTERNAL MGV_HAZ_MAT_NO_EXTERNAL MATNR_EXT CHAR 40   0   Long Material Number for HAZ_MAT_NO Field  
100 HAZ_MAT_NO_GUID MGV_HAZ_MAT_NO_GUID MATNR_EGUID CHAR 32   0   External GUID for HAZ_MAT_NO Field  
101 HAZ_MAT_NO_VERSION MGV_HAZ_MAT_NO_VERSION MATNR_VERS CHAR 10   0   Version Number for HAZ_MAT_NO Field  
102 MATERIAL_EXTERNAL MGV_MATERIAL_EXTERNAL MATNR_EXT CHAR 40   0   Long Material Number for MATERIAL Field  
103 MATERIAL_GUID MGV_MATERIAL_GUID MATNR_EGUID CHAR 32   0   External GUID for MATERIAL Field  
104 MATERIAL_VERSION MGV_MATERIAL_VERSION MATNR_VERS CHAR 10   0   Version Number for MATERIAL Field  
105 PR_REF_MAT_EXTERNAL MGV_PR_REF_MAT_EXTERNAL MATNR_EXT CHAR 40   0   Long Material Number for PR_REF_MAT Field  
106 PR_REF_MAT_GUID MGV_PR_REF_MAT_GUID MATNR_EGUID CHAR 32   0   External GUID for PR_REF_MAT Field  
107 PR_REF_MAT_VERSION MGV_PR_REF_MAT_VERSION MATNR_VERS CHAR 10   0   Version Number for PR_REF_MAT Field  
108 PREPACK_GENERIC_MATL WSTR_SATNR_PP MATNR CHAR 18   0   Material Number of the Generic Material in Prepack Materials *
109 CREATION_STATUS WRFBSTAT WRFBSTAT CHAR 2   0   Creation Status - Seasonal Procurement *
110 FREE_CHAR_VALUE WRF_FREE_CHAR WRF_ATWRT CHAR 18   0   Characteristic Value for Evaluation Purposes  
111 CARE_CODE WRF_CARE_CODE WRF_CARE_CODE CHAR 16   0   Care Codes (such as Washing Code, Ironing Code, etc.)  
112 BRAND_ID WRF_BRAND_ID WRF_BRAND_ID CHAR 4   0   Brand *
113 FIBER_CODE_1 WRF_FIBER_CODE_1 WRF_FIBER_CODE CHAR 3   0   Fiber Code for Textiles (Component 1) *
114 FIBER_PART_1 WRF_FIBER_PART_1 WRF_FIBER_PART NUMC 3   0   Percentage Share of Fiber (Component 1)  
115 FIBER_CODE_2 WRF_FIBER_CODE_2 WRF_FIBER_CODE CHAR 3   0   Fiber Code for Textiles (Component 2) *
116 FIBER_PART_2 WRF_FIBER_PART_2 WRF_FIBER_PART NUMC 3   0   Percentage Share of Fiber (Component 2)  
117 FIBER_CODE_3 WRF_FIBER_CODE_3 WRF_FIBER_CODE CHAR 3   0   Fiber Code for Textiles (Component 3) *
118 FIBER_PART_3 WRF_FIBER_PART_3 WRF_FIBER_PART NUMC 3   0   Percentage Share of Fiber (Component 3)  
119 FIBER_CODE_4 WRF_FIBER_CODE_4 WRF_FIBER_CODE CHAR 3   0   Fiber Code for Textiles (Component 4) *
120 FIBER_PART_4 WRF_FIBER_PART_4 WRF_FIBER_PART NUMC 3   0   Percentage Share of Fiber (Component 4)  
121 FIBER_CODE_5 WRF_FIBER_CODE_5 WRF_FIBER_CODE CHAR 3   0   Fiber Code for Textiles (Component 5) *
122 FIBER_PART_5 WRF_FIBER_PART_5 WRF_FIBER_PART NUMC 3   0   Percentage Share of Fiber (Component 5)  
123 FASHION_GRADE FASHGRD_BAPI FASHGRD_BAPI CHAR 4   0   Fashion Grade  
124 PACKING_REF_MATL PL_RMATP MATNR CHAR 18   0   Reference material for materials packed in same way *
125 PREPACK_GENERIC_MATL_EXTERNAL PREPACK_GENERIC_MATL_EXTERNAL MATNR_EXT CHAR 40   0   Long Material Number (Future Development) for PREPA Field  
126 PREPACK_GENERIC_MATL_VERSION PREPACK_GENERIC_MATL_VERSION MATNR_VERS CHAR 10   0   Version Number (Future Development) for PREPACK_GEN Field  
127 PREPACK_GENERIC_MATL_GUID MGV_PREPACK_GENERIC_MATL_GUID MATNR_EGUID CHAR 32   0   External GUID (Future Development) for PREPACK_GENER Field  
128 PACKING_REF_MATL_EXTERNAL MGV_PACKING_REF_MATL_EXTERNAL MATNR_EXT CHAR 40   0   Long Material Number (Future Development) for PACKI Field  
129 PACKING_REF_MATL_GUID MGV_PACKING_REF_MATL_GUID MATNR_EGUID CHAR 32   0   External GUID (Future Development) for PACKING_REF_M Field  
130 PACKING_REF_MATL_VERSION MGV_PACKING_REF_MATL_VERSION MATNR_VERS CHAR 10   0   Version Number (Future Development) for PACKING_REF Field  
131 STD_HU_TYPE CIFHUTYPDF CHAR4 CHAR 4   0   Standard HU Type  
132 PILFERABLE CIFPILFRBL XFELD CHAR 1   0   Pilferable  
133 WHSE_STORAGE_CONDITION CIFWHSTC CHAR2 CHAR 2   0   Warehouse Storage Condition  
134 WHSE_MATERIAL_GROUP CIFWHMATGR CHAR4 CHAR 4   0   Warehouse Material Group  
135 HANDLING_INDICATOR CIFHDLCODE CHAR4 CHAR 4   0   Handling Indicator  
136 HAZ_MAT_RELEVANT CIFHAZMAT XFELD CHAR 1   0   Relevant for Hazardous Substances  
137 HU_TYPE CIFHUTYP CHAR4 CHAR 4   0   Handling Unit Type  
138 VARIABLE_TARE_WEIGHT CIFTAREVAR XFELD CHAR 1   0   Variable Tare Weight  
139 MAX_ALLOWED_CAPACITY CIFMAXC DECV15_3 DEC 15   3   Maximum Allowed Capacity of Packaging Material  
140 OVERCAPACITY_TOLERANCE CIFMAXCTOL DEC2_1 DEC 3   1   Overcapacity Tolerance of the Handling Unit  
141 MAX_ALLOWED_LENGTH CIFMAXL CIFQUAN15 QUAN 15   3   Maximum Packing Length of Packaging Material  
142 MAX_ALLOWED_WIDTH CIFMAXB CIFQUAN15 QUAN 15   3   Maximum Packing Width of Packaging Material  
143 MAX_ALLOWED_HEIGTH CIFMAXH CIFQUAN15 QUAN 15   3   Maximum Packing Height of Packaging Material  
144 MAX_DIMENSION_UN CIFMAXDUOM MEINS UNIT 3   0   Unit of Measure for Maximum Packing Length/Width/Height *
145 MAX_DIMENSION_UN_ISO CIFMAXDUOM_ISO ISOCD_UNIT CHAR 3   0   Unit for Maximum Packing Length/Width/Height in ISO Code *
146 COUNTRYORI HERKL LAND1 CHAR 3   0   Country of origin of the material *
147 COUNTRYORI_ISO HERKL_ISO INTCA CHAR 2   0   Material's country of origin in ISO code  
148 MATFRGTGRP MFRGR MFRGR CHAR 8   0   Material freight group *
149 QUARANTINE_PERIOD CIFQQTIME   QUAN 3   0   Quarantine Period  
150 QUARANTINE_PERIOD_UN CIFQQTIMEUOM MEINS UNIT 3   0   Time Unit for Quarantine Period *
151 QUARANTINE_PERIOD_UN_ISO CIFQQTIMEUOM_ISO ISOCD_UNIT CHAR 3   0   Time Unit for Quarantine Time in ISO Code *
152 QUALITY_INSP_GRP CIFQGRP CIFQGRP CHAR 4   0   Quality Inspection Group  
153 SERIAL_NUMBER_PROFILE CIFSERIAL CIFSERIAL CHAR 4   0   Serial Number Profile  
154 EWM_CW_TOLERANCE_GROUP CIFCWQTOLGR CIFCWQTOLGR CHAR 9   0   EWM-CW: Catch Weight Tolerance Group for EWM *
155 EWM_CW_INPUT_CONTROL CIFCWQPROC CIFCWQPROC CHAR 2   0   EWM CW: Catch Weight Profile for Entering CW Quantity *
156 PCKGING_SMARTFORM CIFPSSFNAME TDSFNAME CHAR 30   0   Form Name *
157 ADJUST_PROFILE CIFADPROF CIFADPROF CHAR 3   0   Adjustment Profile *
158 ALLOW_PMAT_IGNO WPM_ALLOW_PMAT_IGNO_MAT XFELD CHAR 1   0   Variant Price Allowed (for Material Master)  
159 ANIMAL_ORIGIN_FLAG WRF_ANIMAL_ORIGIN_FLAG WRF_ANIMAL_ORIGIN_FLAG CHAR 1   0   Indicator: Contains Non-Textile Parts of Animal Origin  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 BAPIE1MARART BASE_UOM T006 MSEHI    
2 BAPIE1MARART BASE_UOM_ISO T006I ISOCODE    
3 BAPIE1MARART BASIC_MATL_NEW TWSPR WRKST    
4 BAPIE1MARART CATPROFILE T352B RBNR    
5 BAPIE1MARART COMPETITOR KNA1 KUNNR    
6 BAPIE1MARART CONF_MATL MARA MATNR    
7 BAPIE1MARART CONTAINER T144 BEHVO    
8 BAPIE1MARART CONT_UNIT T006 MSEHI    
9 BAPIE1MARART CONT_UNIT_ISO T006I ISOCODE    
10 BAPIE1MARART DIVISION TSPA SPART    
11 BAPIE1MARART EXTMATLGRP TWEW EXTWG    
12 BAPIE1MARART HAZMATPROF TDG41 PROFL    
13 BAPIE1MARART HAZ_MAT_NO MGEF STOFF    
14 BAPIE1MARART ITEM_CAT TPTM MTPOS    
15 BAPIE1MARART LABEL_FORM T6WP4 ETIFO    
16 BAPIE1MARART LABEL_TYPE T6WP3 ETIAR    
17 BAPIE1MARART LAB_DESIGN T024L LABOR    
18 BAPIE1MARART MATERIAL MARA MATNR    
19 BAPIE1MARART MAT_GRP_SM TVEGR MAGRV    
20 BAPIE1MARART PACK_VO_UN T006 MSEHI    
21 BAPIE1MARART PACK_VO_UN_ISO T006I ISOCODE    
22 BAPIE1MARART PACK_WT_UN T006 MSEHI    
23 BAPIE1MARART PACK_WT_UN_ISO T006I ISOCODE    
24 BAPIE1MARART PO_UNIT T006 MSEHI    
25 BAPIE1MARART PO_UNIT_ISO T006I ISOCODE    
26 BAPIE1MARART PRICE_BAND TWPT PLGTP    
27 BAPIE1MARART PROC_RULE T6WP1 BWVOR    
28 BAPIE1MARART PROD_ALLOC T190S KOSCH    
29 BAPIE1MARART PROD_HIER T179 PRODH    
30 BAPIE1MARART PR_REF_MAT MARA MATNR    
31 BAPIE1MARART PUR_STATUS T141 MMSTA    
32 BAPIE1MARART PUR_VALKEY T405 EKWSL    
33 BAPIE1MARART SAL_STATUS TVMS VMSTA    
34 BAPIE1MARART SEASMATCAT T6WSA SAITY    
35 BAPIE1MARART SEASON T6WSP SAISO    
36 BAPIE1MARART SH_MAT_TYP TVTY TRATY    
37 BAPIE1MARART STOR_CONDS T142 RAUBE    
38 BAPIE1MARART SUP_SOURCE TMBW1 BWSCL    
39 BAPIE1MARART TAX_CLASS TSKM TAXKM    
40 BAPIE1MARART TEMP_CONDS T143 TEMPB    
41 BAPIE1MARART TRANS_GRP TTGR TRAGR    
History
Last changed by/on SAP  20130529 
SAP Release Created in