BAPIE1MARCRT SAP (Retail Data Transfer: Material Data at Plant Level) Structure details
Description: Retail Data Transfer: Material Data at Plant Level
Structure field list including key, data, relationships and ABAP select examples
BAPIE1MARCRT 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 Plant 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_BAPIE1MARCRT TYPE BAPIE1MARCRT.
The BAPIE1MARCRT table consists of various fields, each holding specific information or linking keys about Retail Data Transfer: Material Data at Plant Level data available in SAP. These include MATERIAL (Material Number), PLANT (Plant), DEL_FLAG (Flag Material for Deletion at Plant Level), ABC_ID (ABC Indicator).. 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 BAPIE1MARCRT 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 |
PLANT | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
DEL_FLAG | Flag Material for Deletion at Plant Level | LVOWK | CHAR | 1 | XFELD | ||||
ABC_ID | ABC Indicator | MAABC | CHAR | 1 | TMABC | MAABC | |||
CRIT_PART | Indicator: Critical part | KZKRI | CHAR | 1 | XFELD | ||||
PUR_GROUP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
ISSUE_UNIT | Unit of issue | AUSME | UNIT | 3 | T006 | CUNIT | MEINS | ||
ISSUE_UNIT_ISO | Unit of issue in ISO code | AUSME_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
MRPPROFILE | Material: MRP profile | DISPR | CHAR | 4 | MDIP | DISPR | DPR | ||
MRP_TYPE | MRP Type | DISMM | CHAR | 2 | T438A | DISMM | |||
MRP_CTRLER | MRP Controller (Materials Planner) | DISPO | CHAR | 3 | T024D | DISPO | DGR | HS_T024D | |
PLND_DELRY | Planned Delivery Time in Days | PLIFZ | DEC | 3 | DEC3 | ||||
GR_PR_TIME | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
PERIOD_IND | Period Indicator | PERKZ | CHAR | 1 | PERKZ | PKZ | |||
ASSY_SCRAP | Assembly scrap in percent | AUSSS | DEC | 5(2) | DEC3_2 | ||||
LOTSIZEKEY | Lot size (materials planning) | DISLS | CHAR | 2 | T439A | DISLS | |||
PROC_TYPE | Procurement Type | BESKZ | CHAR | 1 | BESKZ | MBS | |||
SPPROCTYPE | Special procurement type | SOBSL | CHAR | 2 | T460A | SOBSL | |||
REORDER_PT | Reorder Point | MINBE | QUAN | 13(3) | MENG13 | ||||
SAFETY_STK | Safety Stock | EISBE | QUAN | 13(3) | MENG13 | ||||
MINLOTSIZE | Minimum Lot Size | BSTMI | QUAN | 13(3) | MENG13 | ||||
MAXLOTSIZE | Maximum Lot Size | BSTMA | QUAN | 13(3) | MENG13 | ||||
FIXED_LOT | Fixed lot size | BSTFE | QUAN | 13(3) | MENG13 | ||||
ROUND_VAL | Rounding value for purchase order quantity | BSTRF | QUAN | 13(3) | MENG13 | ||||
MAX_STOCK | Maximum stock level | MABST | QUAN | 13(3) | MENG13 | ||||
ORD_COSTS | Ordering costs (BAPI interfaces) | LOSFX_BAPI | DEC | 23(4) | BAPICURR | ||||
DEP_REQ_ID | Dependent requirements ind. for individual and coll. reqmts | SBDKZ | CHAR | 1 | SBDKZ | ||||
STOR_COSTS | Storage costs indicator | LAGPR | CHAR | 1 | T439L | LAGPR | |||
ALT_BOM_ID | Method for Selecting Alternative Bills of Material | ALTSL | CHAR | 1 | ALTSL | ||||
DISCONTINU | Discontinuation indicator | KZAUS | CHAR | 1 | KZAUS | ||||
EFF_O_DAY | Effective-Out Date | AUSDT | DATS | 8 | DATUM | ||||
FOLLOW_UP | Follow-Up Material | NFMAT | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
GRP_REQMTS | Indicator for Requirements Grouping | KZBED | CHAR | 1 | KZBED | ||||
MIXED_MRP | Mixed MRP indicator | MISKZ | CHAR | 1 | MISKZ | ||||
SM_KEY | Scheduling Margin Key for Floats | FHORI | CHAR | 3 | T436A | FHORI | |||
BACKFLUSH | Indicator: Backflush | RGEKM | CHAR | 1 | RGEKM | ||||
INHSEPRODT | In-house production time | DZEIT | DEC | 3 | DEC3 | ||||
STGEPERIOD | Maximum Storage Period | MAXLZ | DEC | 5 | DEC5 | ||||
STGE_PD_UN | Unit for maximum storage period | LZEIH | UNIT | 3 | T006 | CUNIT | MEINS | ||
STGE_PD_UN_ISO | Unit for the maximum storage period in ISO code | LZEIH_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
REPLENTIME | Total replenishment lead time (in workdays) | WZEIT | DEC | 3 | DEC3 | ||||
REPLACE_PT | Replacement part | ATPKZ | CHAR | 1 | ATPKZ | ||||
QUAL_INSP | Post to Inspection Stock | INSMK_MAT | CHAR | 1 | QKZ | ||||
CTRL_KEY | Control Key for Quality Management in Procurement | QSSPUR | CHAR | 8 | TQ08 | QSSPUR | |||
DOC_REQD | Documentation required indicator | KZDKZ | CHAR | 1 | XFELD | ||||
LOADINGGRP | Loading Group | LADGR | CHAR | 4 | TLGR | LADGR | |||
BATCH_MGMT | Batch management requirement indicator | XCHPF | CHAR | 1 | XFELD | ||||
QUOTAUSAGE | Quota arrangement usage | USEQU | CHAR | 1 | TMQ2 | USEQU | |||
SERV_LEVEL | Service level | LGRAD | DEC | 3(1) | DEC2_1 | ||||
SPLIT_IND | Splitting Indicator | AUFTL | CHAR | 1 | T439P | AUFTL | |||
AVAILCHECK | Checking Group for Availability Check | MTVFP | CHAR | 2 | TMVF | MTVFP | |||
FY_VARIANT | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
CORR_FACT | Indicator: take correction factors into account | KZKFK | CHAR | 1 | XFELD | ||||
SETUP_TIME | Shipping setup time | VRVEZ | DEC | 5(2) | DEC3_2 | ||||
BASE_QTY | Base quantity for capacity planning in shipping | VBAMG | QUAN | 13(3) | MENG13 | ||||
PROC_TIME | Shipping processing time | VBEAZ | DEC | 5(2) | DEC3_2 | ||||
SUP_SOURCE | Source of Supply | BWSCL | CHAR | 1 | TMBW1 | BQSCL | |||
AUTO_P_ORD | Indicator: 'automatic purchase order allowed' | KAUTB | CHAR | 1 | FLAG | ||||
SOURCELIST | Indicator: Source list requirement | KORDB | CHAR | 1 | XFELD | ||||
COMM_CODE | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | T604 | STAWN | |||
COUNTRYORI | Country of origin of the material | HERKL | CHAR | 3 | T005 | LAND1 | LND | ||
COUNTRYORI_ISO | Material's country of origin in ISO code | HERKL_ISO | CHAR | 2 | INTCA | ||||
REGIONORIG | Region of origin of material (non-preferential origin) | HERKR | CHAR | 3 | T005S | REGIO | |||
EXPIMPGRP | Export/import material group | MTVER | CHAR | 4 | TVFM | MTVER | |||
PROFIT_CTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PPC_PL_CAL | PPC planning calendar | MRPPP | CHAR | 3 | T439G | MRPPP | |||
REP_MANUF | Ind.: Repetitive mfg allowed | SA_SAUFT | CHAR | 1 | XFELD | ||||
PL_TI_FNCE | Planning time fence | FXHOR | NUMC | 3 | FXHOR | ||||
CONSUMMODE | Consumption mode | VRMOD | CHAR | 1 | VRMOD | ||||
BWD_CONS | Consumption period: backward | VINT1 | NUMC | 3 | VRINT | ||||
FWD_CONS | Consumption period: forward | VINT2 | NUMC | 3 | VRINT | ||||
ISS_ST_LOC | Issue Storage Location | LGPRO | CHAR | 4 | T001L | LGORT | |||
MRP_GROUP | MRP Group | DISGR | CHAR | 4 | T438M | DISGR | |||
COMP_SCRAP | Component scrap in percent | KAUSF | DEC | 5(2) | DEC3_2 | ||||
CERT_TYPE | Certificate Type | QZGTYP | CHAR | 4 | TQ05 | QZGTYP | QCT | ||
CYCLE_TIME | Takt time | TAKZT | DEC | 3 | DEC3 | ||||
COVPROFILE | Range of coverage profile | RWPRO | CHAR | 3 | T438R | RWPRO | |||
CO_PA_FLD | Local field name for CO/PA link to SOP | COPAM | CHAR | 10 | OLD_FDNAME | DFD | |||
CC_PH_INV | Physical inventory indicator for cycle counting | ABCIN | CHAR | 1 | T159C | ABCIN | |||
SERNO_PROF | Serial Number Profile | SERAIL | CHAR | 4 | T377P | SERAIL | |||
REPMANPROF | Repetitive manufacturing profile | SFEPR | CHAR | 4 | T437S | SFEPR | |||
NEG_STOCKS | Negative stocks allowed in plant | XMCNG | CHAR | 1 | XFELD | ||||
QM_RGMTS | Required QM System for Vendor | QSSYS_SOLL | CHAR | 4 | TQ02 | QSSYS | |||
PLNG_CYCLE | Planning cycle | LFRHY | CHAR | 3 | T439G | MRPPP | |||
ROUND_PROF | Rounding Profile | RDPRF | CHAR | 4 | RDPR | RDPRF | |||
REFMATCONS | Reference material for consumption | VRBMT | CHAR | 18 | MARA | MATN1 | MATNR | ||
REFPLTCONS | Reference plant for consumption | VRBWK | CHAR | 4 | T001W | WERKS | |||
D_TO_REF_M | To date of the material to be copied for consumption | VRBDT | DATS | 8 | DATUM | ||||
MULT_REF_M | Multiplier for reference material for consumption | VRBFK | DEC | 4(2) | DEC2_2 | ||||
AUTO_RESET | Reset Forecast Model Automatically | AUTRU | CHAR | 1 | XFELD | ||||
EX_CERT_ID | Exemption certificate: Indicator for legal control | PRENC | CHAR | 1 | PRENC | ||||
EX_CERT_NO | Number of exemption certificate in export/import | PRENO | NUMC | 8 | PRENO | ||||
EX_CERT_DT | Exemption certificate: Issue date of exemption certificate | PREND | DATS | 8 | PREND | ||||
MILIT_ID | Indicator: Military goods | ITARK | CHAR | 1 | XFELD | ||||
INSP_INT | Interval until next recurring inspection | PRFRQ | DEC | 5 | DEC5 | ||||
CO_PRODUCT | Indicator: Material can be co-product | KZKUPMAT | CHAR | 1 | FLAG | ||||
PLAN_STRGP | Planning strategy group | STRGR | CHAR | 2 | T461P | STRGR | |||
SLOC_EXPRC | Default storage location for external procurement | LGFSB | CHAR | 4 | T001L | LGORT | |||
BULK_MAT | Indicator: Bulk Material | SCHGT | CHAR | 1 | XFELD | ||||
CC_FIXED | CC indicator is fixed | CCFIX | CHAR | 1 | XFELD | ||||
DETERM_GRP | Stock determination group | BF_GROUP | CHAR | 4 | T434G | BF_GROUP | |||
QM_AUTHGRP | Material Authorization Group for Activities in QM | QMATAUTH | CHAR | 6 | TQ01B | QMATAUTH | |||
PUR_STATUS | Plant-Specific Material Status | MMSTA | CHAR | 2 | T141 | MMSTA | |||
SAFTY_T_ID | Safety time indicator (with or without safety time) | SHFLG | CHAR | 1 | SHFLG | ||||
SAFETYTIME | Safety time (in workdays) | SHZET | NUMC | 2 | NUMC2 | ||||
PLORD_CTRL | Action control: planned order processing | MDACH | CHAR | 2 | T46AC | MDACH | |||
BATCHENTRY | Determination of batch entry in the production/process order | KZECH | CHAR | 1 | KZECH | ||||
PROMSMOOTH | Indicator: smooth promotion consumption | KZAGL | CHAR | 1 | KZAGL | ||||
UNIT_GROUP | Unit of Measure Group | MEGRU | CHAR | 4 | TWMEG | MEGRU | |||
PVALIDFROM | Date from which the plant-specific material status is valid | MMSTD | DATS | 8 | DATUM | ||||
SERV_LEV_R | IS-R service level | W_SERVGRD | CHAR | 1 | TWSG | W_SERVGRD | |||
MATFRGTGRP | Material freight group | MFRGR | CHAR | 8 | TMFG | MFRGR | |||
HANDLG_GRP | Logistics handling group for workload calculation | LOGGR | CHAR | 4 | TLOG | LOGGR | |||
CFOP_CAT | Material CFOP category | J_1BINDUS3 | CHAR | 2 | ALPHA | J_1BINDUS3 | |||
EU_LIST_NO | CAP: Number of CAP products list | MOWNR | CHAR | 12 | T618M | MOWNR | |||
EU_MAT_GRP | Common Agricultural Policy: CAP products group-Foreign Trade | MOGRU | CHAR | 6 | T618G | MOGRU | |||
CAS_NO | CAS number for pharmaceutical products in foreign trade | CASNR | CHAR | 15 | T610C | CASNR | |||
CTRL_CODE | Control code for consumption taxes in foreign trade | STEUC | CHAR | 16 | T604F | STEUC | |||
JIT_RELVT | Indicator: Item Relevant to JIT Delivery Schedules | FABKZ | CHAR | 1 | FABKZ | ||||
DISTR_PROF | Distribution profile of material in plant | FPRFM | CHAR | 3 | TMFPF | MPPRF | |||
PERIOD_PROFILE_SAFETY_TIME | Period Profile for Safety Time | SHPRO | CHAR | 3 | T438V | SHPRO | |||
MRP_RELEVANCY_DEP_REQUIREMENTS | MRP relevancy for dependent requirements | AHDIS | CHAR | 1 | AHDIS | ||||
AVAIL_CHECK_ALL_PROJ_SEGMENTS | Indicator for cross-project material | KZPSP | CHAR | 1 | KZPSP | ||||
EX_CERT_NO_NEW | Exemption certificate number for legal control | PRENN | CHAR | 8 | PRENN | ||||
PRODUCTION_SCHEDULER | Production Supervisor | FEVOR | CHAR | 3 | Assigned to domain | FEVOR | CFV | ||
PROD_PROF | Production Scheduling Profile | CO_PRODPRF | CHAR | 6 | Assigned to domain | CO_PRODPRF | |||
MAT_GRP_TRANS | Group of Materials for Transition Matrix | MATNRGROUP | CHAR | 20 | CHAR20 | ||||
OVERALL_PROF | Overall profile for order change management | OCM_GPROFILE | CHAR | 6 | CHAR6 | ||||
UNDER_TOL | Underdelivery tolerance limit | UNETO | DEC | 3(1) | DEC2_1 | ||||
OVER_TOL | Overdelivery tolerance limit | UEETO | DEC | 3(1) | DEC2_1 | ||||
UNLIMITED | Indicator: Unlimited Overdelivery Allowed | UEETK | CHAR | 1 | XFELD | ||||
SETUP_TIME_PROC | Setup and teardown time | RUEZT | DEC | 5(2) | DEC3_2 | ||||
PROCESSING_TIME | Processing time | BEARZ | DEC | 5(2) | DEC3_2 | ||||
BASE_QTY_PROC | Base quantity | BASMG | QUAN | 13(3) | MENG13 | ||||
INTEROP_TIME | Interoperation time | TRANZ | DEC | 5(2) | DEC3_2 | ||||
PROD_UNIT | Production unit | FRTME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PROD_UNIT_ISO | Production Unit in ISO Code | FRTME_ISO | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
VARIANCE_KEY | Variance Key | AWSLS | CHAR | 6 | Assigned to domain | AWSLS | |||
ALTERNATIVE_BOM | Alternative BOM | STALT | CHAR | 2 | ALPHA | ALTNR | |||
BOM_USAGE | BOM Usage | STLAN | CHAR | 1 | Assigned to domain | STLAN | CSV | ||
TASK_LIST_GRP_NO | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
GROUP_COUNTER | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
TASK_LIST_TYPE | Task List Type | PLNTY | CHAR | 1 | Assigned to domain | PLNTY | PTY | H_TCA01 | |
SPEC_PROC_TYPE | Special Procurement Type for Costing | CK_SOBSL | CHAR | 2 | Assigned to domain | SOBSL | |||
LOT_SIZE | Lot Size for Product Costing | CK_LOSGR | QUAN | 13(3) | MENG13 | ||||
MIN_SAFETY_STK | Minimum Safety Stock | EISLO | QUAN | 13(3) | MENG13 | ||||
NO_COSTING | Do Not Cost | CK_NO_COSTING | CHAR | 1 | CK_NO_COSTING | ||||
FOLLOW_UP_EXTERNAL | Long Material Number for field FOLLOW_UP | MGV_FOLLOW_UP_EXTERNAL | CHAR | 40 | MATNR_EXT | ||||
FOLLOW_UP_GUID | External GUID for FOLLOW_UP Field | MGV_FOLLOW_UP_GUID | CHAR | 32 | MATNR_EGUID | ||||
FOLLOW_UP_VERSION | Version Number for FOLLOW_UP Field | MGV_FOLLOW_UP_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 | |||
REFMATCONS_EXTERNAL | Long Material Number for REFMATCONS Field | MGV_REFMATCONS_EXTERNAL | CHAR | 40 | MATNR_EXT | ||||
REFMATCONS_GUID | External GUID for REFMATCONS Field | MGV_REFMATCONS_GUID | CHAR | 32 | MATNR_EGUID | ||||
REFMATCONS_VERSION | Version Number for REFMATCONS Field | MGV_REFMATCONS_VERSION | CHAR | 10 | MATNW | MATNR_VERS | |||
PROPSUPPLYAREA | Proposed Supply Area in Material Master Record | VSPVB | CHAR | 10 | Assigned to domain | PRVBE | |||
CONSIGNMENT_CONTROL | Consignment Control | WRF_CONS_PROCG | CHAR | 1 | Assigned to domain | WRF_CONS_PROCG | |||
GI_PR_TIME | Goods Issue Processing Time in Days | WRF_PSCD_WABAZ | DEC | 3 | DEC3 | ||||
PURCH_ACROSS_PUR_GROUP | Purchasing Across Purchasing Group | WRF_POHF_OTHER_EKGRP_ALLOW | CHAR | 1 | CHAR1_X | ||||
REF_DETERM_SCHEMA | Reference Determination Schema | WRF_REF_SCHEMA | CHAR | 2 | Assigned to domain | WRF_REF_SCHEMA | |||
MIN_TROC | Minimum Target Range of Coverage | WRF_FRE_TROC_MIN | NUMC | 3 | WRF_FRE_TROC | ||||
MAX_TROC | Maximum Target Range of Coverage | WRF_FRE_TROC_MAX | NUMC | 3 | WRF_FRE_TROC | ||||
TARGET_STOCK | Target Stock | WRF_FRE_TARGET_STOCK | QUAN | 13(3) | MENG13 |
Key field | Non-key field |
How do I retrieve data from SAP structure BAPIE1MARCRT using ABAP code?
As BAPIE1MARCRT 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 BAPIE1MARCRT as there is no data to select.How to access SAP table BAPIE1MARCRT
Within an ECC or HANA version of SAP you can also view further information about BAPIE1MARCRT 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