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
⤷ 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
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |