BAPIE1MARART SAP (Retail Data Transfer: Material Data at Client level) Structure details
Description: Retail Data Transfer: Material Data at Client level
Structure field list including key, data, relationships and ABAP select examples
BAPIE1MARART is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Retail Data Transfer: Material Data at Client level" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_BAPIE1MARART TYPE BAPIE1MARART.
The BAPIE1MARART table consists of various fields, each holding specific information or linking keys about Retail Data Transfer: Material Data at Client level data available in SAP. These include MATERIAL (Material Number), CREATED_ON (Created On), CREATED_BY (Name of Person who Created the Object), LAST_CHNGE (Date of Last Change).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP BAPIE1MARART structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
FUNCTION | Function | MSGFN | CHAR | 3 | MSGFN | ||||
MATERIAL | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
CREATED_ON | Created On | ERSDA | DATS | 8 | DATUM | ||||
CREATED_BY | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
LAST_CHNGE | Date of Last Change | LAEDA | DATS | 8 | DATUM | ||||
CHANGED_BY | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
DEL_FLAG | Flag Material for Deletion at Client Level | LVOMA | CHAR | 1 | XFELD | ||||
OLD_MAT_NO | Old material number | BISMT | CHAR | 18 | BISMT | ||||
BASE_UOM | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
BASE_UOM_ISO | Base unit of measure in ISO code | MEINS_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
PO_UNIT | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
PO_UNIT_ISO | Order unit in ISO code | BSTME_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
DOCUMENT | Document number (without document management system) | DZEINR | CHAR | 22 | CHAR22 | ||||
DOC_TYPE | Document type (without Document Management system) | DZEIAR | CHAR | 3 | ZEIAR | ||||
DOC_VERS | Document version (without Document Management system) | DZEIVR | CHAR | 2 | VERSI | ||||
DOC_FORMAT | Page format of document (without Document Management system) | DZEIFO | CHAR | 4 | DINFO | ||||
DOC_CHG_NO | Document change number (without document management system) | AESZN | CHAR | 6 | AENUM | ||||
PAGE_NO | Page number of document (without Document Management system) | BLATT | CHAR | 3 | BLATT | ||||
NO_SHEETS | Number of sheets (without Document Management system) | BLANZ | NUMC | 3 | NUM3 | ||||
PROD_MEMO | Production/inspection memo | FERTH | CHAR | 18 | FERTH | ||||
PAGEFORMAT | Page Format of Production Memo | FORMT | CHAR | 4 | DINFO | ||||
SIZE_DIM | Size/dimensions | GROES | CHAR | 32 | CHAR32 | ||||
BASIC_MATL | Basic material (basic constituent of a material) - obsolete | WRKST_OLD | CHAR | 14 | Assigned to domain | WRKST_OLD | |||
STD_DESCR | Industry Standard Description (such as ANSI or ISO) | NORMT | CHAR | 18 | NORMT | ||||
LAB_DESIGN | Laboratory/design office | LABOR | CHAR | 3 | T024L | LABOR | |||
PUR_VALKEY | Purchasing Value Key | EKWSL | CHAR | 4 | T405 | EKWSL | |||
NET_WEIGHT | Net Weight | NTGEW | QUAN | 13(3) | MENG13 | ||||
CONTAINER | Container requirements | BEHVO | CHAR | 2 | T144 | BEHVO | |||
STOR_CONDS | Storage conditions | RAUBE | CHAR | 2 | T142 | RAUBE | |||
TEMP_CONDS | Temperature conditions indicator | TEMPB | CHAR | 2 | T143 | TEMPB | |||
TRANS_GRP | Transportation Group | TRAGR | CHAR | 4 | TTGR | TRAGR | |||
HAZ_MAT_NO | Hazardous material number | STOFF | CHAR | 18 | MGEF | MATN1 | STOFF | STO | |
DIVISION | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
COMPETITOR | Competitor | WETTB | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
QTY_GR_GI | Quantity: Number of GR/GI slips to be printed | WESCH | QUAN | 13(3) | MENG13 | ||||
PROC_RULE | Procurement rule | BWVOR | CHAR | 1 | T6WP1 | BWVOR | |||
SUP_SOURCE | Source of Supply | BWSCL | CHAR | 1 | TMBW1 | BQSCL | |||
SEASON | Season Category | SAISO | CHAR | 4 | T6WSP | SAISO | SAISO | ||
LABEL_TYPE | Label type | ETIAR | CHAR | 2 | T6WP3 | ETIAR | |||
LABEL_FORM | Label form | ETIFO | CHAR | 2 | T6WP4 | ETIFO | |||
PROD_HIER | Product hierarchy | PRODH_D | CHAR | 18 | T179 | PRODH | VPR | ||
CAD_ID | CAD Indicator | CADKZ | CHAR | 1 | XFELD | ||||
ALLOWED_WT | Allowed packaging weight | ERGEW | QUAN | 13(3) | MENG13 | ||||
PACK_WT_UN | Unit of weight (allowed packaging weight) | ERGEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
PACK_WT_UN_ISO | Unit of weight (allowed packaging weight) in ISO code | ERGEI_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
ALLWD_VOL | Allowed packaging volume | ERVOL | QUAN | 13(3) | MENG13 | ||||
PACK_VO_UN | Volume unit (allowed packaging volume) | ERVOE | UNIT | 3 | T006 | CUNIT | MEINS | ||
PACK_VO_UN_ISO | Volume unit (allowed packaging volume) in ISO code | ERVOE_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
WT_TOL_LT | Excess Weight Tolerance for Handling unit | GEWTO | DEC | 3(1) | PRZ21 | ||||
VOL_TOL_LT | Excess Volume Tolerance of the Handling Unit | VOLTO | DEC | 3(1) | PRZ21 | ||||
VAR_ORD_UN | Variable Purchase Order Unit Active | VABME | CHAR | 1 | VABME | ||||
BATCH_MGMT | Batch management requirement indicator | XCHPF | CHAR | 1 | XFELD | ||||
SH_MAT_TYP | Packaging Material Type | VHIART | CHAR | 4 | TVTY | TRATY | |||
FILL_LEVEL | Maximum level (by volume) | FUELG | DEC | 3 | DEC3 | ||||
STACK_FACT | Stacking factor | STFAK | INT2 | 5 | INT2 | ||||
MAT_GRP_SM | Material Group: Packaging Materials | MAGRV | CHAR | 4 | TVEGR | MAGRV | |||
AUTH_GROUP | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
QM_PROCMNT | QM in Procurement is Active | QMPUR | CHAR | 1 | XFELD | ||||
CATPROFILE | Catalog Profile | RBNR | CHAR | 9 | T352B | RBNR | |||
MINREMLIFE | Minimum Remaining Shelf Life | MHDRZ | DEC | 4 | DEC4 | ||||
SHELF_LIFE | Total shelf life | MHDHB | DEC | 4 | DEC4 | ||||
STOR_PCT | Storage percentage | MHDLP | DEC | 3 | DEC3 | ||||
VALID_FROM | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
DELN_DATE | Deletion date | LIQDT | DATS | 8 | DATUM | ||||
SAESON_YR | Season Year | SAISJ | CHAR | 4 | GJAHR | CJAHR | WMSAISJ | ||
PRICE_BAND | Price Band Category | PLGTP | CHAR | 2 | TWPT | PLGTP | |||
EMPTIESBOM | Empties Bill of Material | W_MITLEERG | CHAR | 1 | FLAG | ||||
EXTMATLGRP | External Material Group | EXTWG | CHAR | 18 | TWEW | EXTWG | |||
CONF_MATL | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
PR_REF_MAT | Pricing Reference Material | PMATN | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
PUR_STATUS | Cross-Plant Material Status | MSTAE | CHAR | 2 | T141 | MMSTA | |||
SAL_STATUS | Cross-distribution-chain material status | MSTAV | CHAR | 2 | TVMS | VMSTA | |||
PVALIDFROM | Date from which the cross-plant material status is valid | MSTDE | DATS | 8 | DATUM | ||||
SVALIDFROM | Date from which the X-distr.-chain material status is valid | MSTDV | DATS | 8 | DATUM | ||||
TAX_CLASS | Tax classification of the material | TAKLV | CHAR | 1 | TSKM | TAXKM | |||
CONT_UNIT | Content unit | INHME | UNIT | 3 | T006 | CUNIT | MEINS | ||
CONT_UNIT_ISO | Content unit in ISO code | INHME_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
NET_CONT | Net contents | INHAL | QUAN | 13(3) | MENG13 | ||||
COMPPRUNIT | Comparison price unit | VPREH | DEC | 5 | PACK3 | ||||
GROSS_CONT | Gross contents | INHBR | QUAN | 13(3) | MENG13 | ||||
PRPROFVAR | Pricing profile for variants | SPROF | CHAR | 1 | SPROF | ||||
QUAL_DIK | Material qualifies for discount in kind | NRFHG | CHAR | 1 | NRFHG | ||||
ENVT_RLVT | Environmentally Relevant | KZUMW | CHAR | 1 | XFELD | ||||
PROD_ALLOC | Product allocation determination procedure | KOSCH | CHAR | 18 | T190S | KOSCH | |||
SEASMATCAT | Rollout in a Season | SAITY | CHAR | 2 | T6WSA | SAITY | WMSAITY | ||
HAZMATPROF | Dangerous Goods Indicator Profile | ADGE_PROFL | CHAR | 3 | TDG41 | ADGD_PROFL | |||
HIGH_VISC | Indicator: Highly Viscous | ADGE_IHIVI | CHAR | 1 | X | ||||
LOOSEORLIQ | Indicator: In Bulk/Liquid | ADGE_ILOOS | CHAR | 1 | X | ||||
CLOSED_BOX | Packaging Material is Closed Packaging | KZGVH | CHAR | 1 | XFELD | ||||
APPD_B_REC | Indicator: Approved batch record required | XGCHP | CHAR | 1 | XFELD | ||||
PERIOD_IND_EXPIRATION_DATE | Period Indicator for Shelf Life Expiration Date | DATTP | CHAR | 1 | PERKZ | DATTP | H_PERDKZ | ||
ROUND_UP_RULE_EXPIRATION_DATE | Rounding rule for calculation of SLED | RDMHD | CHAR | 1 | RDMHD | ||||
PROD_COMPOSITION_ON_PACKAGING | Indicator: Product composition printed on packaging | PRZUS | CHAR | 1 | XFELD | ||||
ITEM_CAT | General item category group | MTPOS_MARA | CHAR | 4 | TPTM | MTPOS | |||
BASIC_MATL_NEW | Basic Material | WRKST | CHAR | 48 | TWSPR | WRKST | |||
CONF_MATL_EXTERNAL | Long Material Number for CONF_MATL field | MGV_CONF_MATL_EXTERNAL | CHAR | 40 | MATNR_EXT | ||||
CONF_MATL_GUID | External GUID for CONF_MATL Field | MGV_CONF_MATL_GUID | CHAR | 32 | MATNR_EGUID | ||||
CONF_MATL_VERSION | Version Number for Field CONF_MATL | MGV_CONF_MATL_VERSION | CHAR | 10 | MATNW | MATNR_VERS | |||
HAZ_MAT_NO_EXTERNAL | Long Material Number for HAZ_MAT_NO Field | MGV_HAZ_MAT_NO_EXTERNAL | CHAR | 40 | MATNR_EXT | ||||
HAZ_MAT_NO_GUID | External GUID for HAZ_MAT_NO Field | MGV_HAZ_MAT_NO_GUID | CHAR | 32 | MATNR_EGUID | ||||
HAZ_MAT_NO_VERSION | Version Number for HAZ_MAT_NO Field | MGV_HAZ_MAT_NO_VERSION | CHAR | 10 | MATNW | MATNR_VERS | |||
MATERIAL_EXTERNAL | Long Material Number for MATERIAL Field | MGV_MATERIAL_EXTERNAL | CHAR | 40 | MATNR_EXT | ||||
MATERIAL_GUID | External GUID for MATERIAL Field | MGV_MATERIAL_GUID | CHAR | 32 | MATNR_EGUID | ||||
MATERIAL_VERSION | Version Number for MATERIAL Field | MGV_MATERIAL_VERSION | CHAR | 10 | MATNW | MATNR_VERS | |||
PR_REF_MAT_EXTERNAL | Long Material Number for PR_REF_MAT Field | MGV_PR_REF_MAT_EXTERNAL | CHAR | 40 | MATNR_EXT | ||||
PR_REF_MAT_GUID | External GUID for PR_REF_MAT Field | MGV_PR_REF_MAT_GUID | CHAR | 32 | MATNR_EGUID | ||||
PR_REF_MAT_VERSION | Version Number for PR_REF_MAT Field | MGV_PR_REF_MAT_VERSION | CHAR | 10 | MATNW | MATNR_VERS | |||
PREPACK_GENERIC_MATL | Material Number of the Generic Material in Prepack Materials | WSTR_SATNR_PP | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
CREATION_STATUS | Creation Status - Seasonal Procurement | WRFBSTAT | CHAR | 2 | Assigned to domain | WRFBSTAT | |||
FREE_CHAR_VALUE | Characteristic Value for Evaluation Purposes | WRF_FREE_CHAR | CHAR | 18 | WRF_ATWRT | ||||
CARE_CODE | Care Codes (such as Washing Code, Ironing Code, etc.) | WRF_CARE_CODE | CHAR | 16 | WRF_CARE_CODE | ||||
BRAND_ID | Brand | WRF_BRAND_ID | CHAR | 4 | Assigned to domain | WRF_BRAND_ID | |||
FIBER_CODE_1 | Fiber Code for Textiles (Component 1) | WRF_FIBER_CODE_1 | CHAR | 3 | Assigned to domain | FIBER | WRF_FIBER_CODE | ||
FIBER_PART_1 | Percentage Share of Fiber (Component 1) | WRF_FIBER_PART_1 | NUMC | 3 | WRF_FIBER_PART | ||||
FIBER_CODE_2 | Fiber Code for Textiles (Component 2) | WRF_FIBER_CODE_2 | CHAR | 3 | Assigned to domain | FIBER | WRF_FIBER_CODE | ||
FIBER_PART_2 | Percentage Share of Fiber (Component 2) | WRF_FIBER_PART_2 | NUMC | 3 | WRF_FIBER_PART | ||||
FIBER_CODE_3 | Fiber Code for Textiles (Component 3) | WRF_FIBER_CODE_3 | CHAR | 3 | Assigned to domain | FIBER | WRF_FIBER_CODE | ||
FIBER_PART_3 | Percentage Share of Fiber (Component 3) | WRF_FIBER_PART_3 | NUMC | 3 | WRF_FIBER_PART | ||||
FIBER_CODE_4 | Fiber Code for Textiles (Component 4) | WRF_FIBER_CODE_4 | CHAR | 3 | Assigned to domain | FIBER | WRF_FIBER_CODE | ||
FIBER_PART_4 | Percentage Share of Fiber (Component 4) | WRF_FIBER_PART_4 | NUMC | 3 | WRF_FIBER_PART | ||||
FIBER_CODE_5 | Fiber Code for Textiles (Component 5) | WRF_FIBER_CODE_5 | CHAR | 3 | Assigned to domain | FIBER | WRF_FIBER_CODE | ||
FIBER_PART_5 | Percentage Share of Fiber (Component 5) | WRF_FIBER_PART_5 | NUMC | 3 | WRF_FIBER_PART | ||||
FASHION_GRADE | Fashion Grade | FASHGRD_BAPI | CHAR | 4 | FASHGRD_BAPI | ||||
PACKING_REF_MATL | Reference material for materials packed in same way | PL_RMATP | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
PREPACK_GENERIC_MATL_EXTERNAL | Long Material Number (Future Development) for PREPA Field | PREPACK_GENERIC_MATL_EXTERNAL | CHAR | 40 | MATNL | MATNR_EXT | |||
PREPACK_GENERIC_MATL_VERSION | Version Number (Future Development) for PREPACK_GEN Field | PREPACK_GENERIC_MATL_VERSION | CHAR | 10 | MATNW | MATNR_VERS | |||
PREPACK_GENERIC_MATL_GUID | External GUID (Future Development) for PREPACK_GENER Field | MGV_PREPACK_GENERIC_MATL_GUID | CHAR | 32 | MATNR_EGUID | ||||
PACKING_REF_MATL_EXTERNAL | Long Material Number (Future Development) for PACKI Field | MGV_PACKING_REF_MATL_EXTERNAL | CHAR | 40 | MATNL | MATNR_EXT | |||
PACKING_REF_MATL_GUID | External GUID (Future Development) for PACKING_REF_M Field | MGV_PACKING_REF_MATL_GUID | CHAR | 32 | MATNR_EGUID | ||||
PACKING_REF_MATL_VERSION | Version Number (Future Development) for PACKING_REF Field | MGV_PACKING_REF_MATL_VERSION | CHAR | 10 | MATNW | MATNR_VERS | |||
STD_HU_TYPE | Standard HU Type | CIFHUTYPDF | CHAR | 4 | CHAR4 | ||||
PILFERABLE | Pilferable | CIFPILFRBL | CHAR | 1 | XFELD | ||||
WHSE_STORAGE_CONDITION | Warehouse Storage Condition | CIFWHSTC | CHAR | 2 | CHAR2 | ||||
WHSE_MATERIAL_GROUP | Warehouse Material Group | CIFWHMATGR | CHAR | 4 | CHAR4 | ||||
HANDLING_INDICATOR | Handling Indicator | CIFHDLCODE | CHAR | 4 | CHAR4 | ||||
HAZ_MAT_RELEVANT | Relevant for Hazardous Substances | CIFHAZMAT | CHAR | 1 | XFELD | ||||
HU_TYPE | Handling Unit Type | CIFHUTYP | CHAR | 4 | CHAR4 | ||||
VARIABLE_TARE_WEIGHT | Variable Tare Weight | CIFTAREVAR | CHAR | 1 | XFELD | ||||
MAX_ALLOWED_CAPACITY | Maximum Allowed Capacity of Packaging Material | CIFMAXC | DEC | 15(3) | DECV15_3 | ||||
OVERCAPACITY_TOLERANCE | Overcapacity Tolerance of the Handling Unit | CIFMAXCTOL | DEC | 3(1) | DEC2_1 | ||||
MAX_ALLOWED_LENGTH | Maximum Packing Length of Packaging Material | CIFMAXL | QUAN | 15(3) | CIFQUAN15 | ||||
MAX_ALLOWED_WIDTH | Maximum Packing Width of Packaging Material | CIFMAXB | QUAN | 15(3) | CIFQUAN15 | ||||
MAX_ALLOWED_HEIGTH | Maximum Packing Height of Packaging Material | CIFMAXH | QUAN | 15(3) | CIFQUAN15 | ||||
MAX_DIMENSION_UN | Unit of Measure for Maximum Packing Length/Width/Height | CIFMAXDUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MAX_DIMENSION_UN_ISO | Unit for Maximum Packing Length/Width/Height in ISO Code | CIFMAXDUOM_ISO | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
COUNTRYORI | Country of origin of the material | HERKL | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
COUNTRYORI_ISO | Material's country of origin in ISO code | HERKL_ISO | CHAR | 2 | INTCA | ||||
MATFRGTGRP | Material freight group | MFRGR | CHAR | 8 | Assigned to domain | MFRGR | |||
QUARANTINE_PERIOD | Quarantine Period | CIFQQTIME | QUAN | 3 | |||||
QUARANTINE_PERIOD_UN | Time Unit for Quarantine Period | CIFQQTIMEUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
QUARANTINE_PERIOD_UN_ISO | Time Unit for Quarantine Time in ISO Code | CIFQQTIMEUOM_ISO | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
QUALITY_INSP_GRP | Quality Inspection Group | CIFQGRP | CHAR | 4 | CIFQGRP | ||||
SERIAL_NUMBER_PROFILE | Serial Number Profile | CIFSERIAL | CHAR | 4 | CIFSERIAL | ||||
EWM_CW_TOLERANCE_GROUP | EWM-CW: Catch Weight Tolerance Group for EWM | CIFCWQTOLGR | CHAR | 9 | Assigned to domain | CIFCWQTOLGR | |||
EWM_CW_INPUT_CONTROL | EWM CW: Catch Weight Profile for Entering CW Quantity | CIFCWQPROC | CHAR | 2 | Assigned to domain | CIFCWQPROC | |||
PCKGING_SMARTFORM | Form Name | CIFPSSFNAME | CHAR | 30 | Assigned to domain | TDSFNAME | |||
ADJUST_PROFILE | Adjustment Profile | CIFADPROF | CHAR | 3 | Assigned to domain | CIFADPROF | |||
ALLOW_PMAT_IGNO | Variant Price Allowed (for Material Master) | WPM_ALLOW_PMAT_IGNO_MAT | CHAR | 1 | XFELD | ||||
ANIMAL_ORIGIN_FLAG | Indicator: Contains Non-Textile Parts of Animal Origin | WRF_ANIMAL_ORIGIN_FLAG | CHAR | 1 | WRF_ANIMAL_ORIGIN_FLAG |
Key field | Non-key field |
How do I retrieve data from SAP structure BAPIE1MARART using ABAP code?
As BAPIE1MARART is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BAPIE1MARART as there is no data to select.How to access SAP table BAPIE1MARART
Within an ECC or HANA version of SAP you can also view further information about BAPIE1MARART and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects