SAP ABAP Table BAPIE1MARCRT (Retail Data Transfer: Material Data at Plant 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 | BAPIE1MARCRT | Table Relationship Diagram |
Short Description | Retail Data Transfer: Material Data at Plant 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 | PLANT | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
4 | DEL_FLAG | LVOWK | XFELD | CHAR | 1 | 0 | Flag Material for Deletion at Plant Level | ||
5 | ABC_ID | MAABC | MAABC | CHAR | 1 | 0 | ABC indicator | TMABC | |
6 | CRIT_PART | KZKRI | XFELD | CHAR | 1 | 0 | Indicator: Critical part | ||
7 | PUR_GROUP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | T024 | |
8 | ISSUE_UNIT | AUSME | MEINS | UNIT | 3 | 0 | Unit of issue | T006 | |
9 | ISSUE_UNIT_ISO | AUSME_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit of issue in ISO code | T006I | |
10 | MRPPROFILE | DISPR | DISPR | CHAR | 4 | 0 | Material: MRP profile | MDIP | |
11 | MRP_TYPE | DISMM | DISMM | CHAR | 2 | 0 | MRP Type | T438A | |
12 | MRP_CTRLER | DISPO | DISPO | CHAR | 3 | 0 | MRP controller | T024D | |
13 | PLND_DELRY | PLIFZ | DEC3 | DEC | 3 | 0 | Planned delivery time in days | ||
14 | GR_PR_TIME | WEBAZ | DEC3 | DEC | 3 | 0 | Goods receipt processing time in days | ||
15 | PERIOD_IND | PERKZ | PERKZ | CHAR | 1 | 0 | Period indicator | ||
16 | ASSY_SCRAP | AUSSS | DEC3_2 | DEC | 5 | 2 | Assembly scrap in percent | ||
17 | LOTSIZEKEY | DISLS | DISLS | CHAR | 2 | 0 | Lot size (materials planning) | T439A | |
18 | PROC_TYPE | BESKZ | BESKZ | CHAR | 1 | 0 | Procurement Type | ||
19 | SPPROCTYPE | SOBSL | SOBSL | CHAR | 2 | 0 | Special procurement type | T460A | |
20 | REORDER_PT | MINBE | MENG13 | QUAN | 13 | 3 | Reorder point | ||
21 | SAFETY_STK | EISBE | MENG13 | QUAN | 13 | 3 | Safety stock | ||
22 | MINLOTSIZE | BSTMI | MENG13 | QUAN | 13 | 3 | Minimum lot size | ||
23 | MAXLOTSIZE | BSTMA | MENG13 | QUAN | 13 | 3 | Maximum lot size | ||
24 | FIXED_LOT | BSTFE | MENG13 | QUAN | 13 | 3 | Fixed lot size | ||
25 | ROUND_VAL | BSTRF | MENG13 | QUAN | 13 | 3 | Rounding value for purchase order quantity | ||
26 | MAX_STOCK | MABST | MENG13 | QUAN | 13 | 3 | Maximum stock level | ||
27 | ORD_COSTS | LOSFX_BAPI | BAPICURR | DEC | 23 | 4 | Ordering costs (BAPI interfaces) | ||
28 | DEP_REQ_ID | SBDKZ | SBDKZ | CHAR | 1 | 0 | Dependent requirements ind. for individual and coll. reqmts | ||
29 | STOR_COSTS | LAGPR | LAGPR | CHAR | 1 | 0 | Storage costs indicator | T439L | |
30 | ALT_BOM_ID | ALTSL | ALTSL | CHAR | 1 | 0 | Method for Selecting Alternative Bills of Material | ||
31 | DISCONTINU | KZAUS | KZAUS | CHAR | 1 | 0 | Discontinuation indicator | ||
32 | EFF_O_DAY | AUSDT | DATUM | DATS | 8 | 0 | Effective-out date | ||
33 | FOLLOW_UP | NFMAT | MATNR | CHAR | 18 | 0 | Follow-up material | MARA | |
34 | GRP_REQMTS | KZBED | KZBED | CHAR | 1 | 0 | Indicator for Requirements Grouping | ||
35 | MIXED_MRP | MISKZ | MISKZ | CHAR | 1 | 0 | Mixed MRP indicator | ||
36 | SM_KEY | FHORI | FHORI | CHAR | 3 | 0 | Scheduling Margin Key for Floats | T436A | |
37 | BACKFLUSH | RGEKM | RGEKM | CHAR | 1 | 0 | Indicator: Backflush | ||
38 | INHSEPRODT | DZEIT | DEC3 | DEC | 3 | 0 | In-house production time | ||
39 | STGEPERIOD | MAXLZ | DEC5 | DEC | 5 | 0 | Maximum storage period | ||
40 | STGE_PD_UN | LZEIH | MEINS | UNIT | 3 | 0 | Unit for maximum storage period | T006 | |
41 | STGE_PD_UN_ISO | LZEIH_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit for the maximum storage period in ISO code | T006I | |
42 | REPLENTIME | WZEIT | DEC3 | DEC | 3 | 0 | Total replenishment lead time (in workdays) | ||
43 | REPLACE_PT | ATPKZ | ATPKZ | CHAR | 1 | 0 | Replacement part | ||
44 | QUAL_INSP | INSMK_MAT | QKZ | CHAR | 1 | 0 | Post to Inspection Stock | ||
45 | CTRL_KEY | QSSPUR | QSSPUR | CHAR | 8 | 0 | Control Key for Quality Management in Procurement | TQ08 | |
46 | DOC_REQD | KZDKZ | XFELD | CHAR | 1 | 0 | Documentation required indicator | ||
47 | LOADINGGRP | LADGR | LADGR | CHAR | 4 | 0 | Loading Group | TLGR | |
48 | BATCH_MGMT | XCHPF | XFELD | CHAR | 1 | 0 | Batch management requirement indicator | ||
49 | QUOTAUSAGE | USEQU | USEQU | CHAR | 1 | 0 | Quota arrangement usage | TMQ2 | |
50 | SERV_LEVEL | LGRAD | DEC2_1 | DEC | 3 | 1 | Service level | ||
51 | SPLIT_IND | AUFTL | AUFTL | CHAR | 1 | 0 | Splitting Indicator | T439P | |
52 | AVAILCHECK | MTVFP | MTVFP | CHAR | 2 | 0 | Checking Group for Availability Check | TMVF | |
53 | FY_VARIANT | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | T009 | |
54 | CORR_FACT | KZKFK | XFELD | CHAR | 1 | 0 | Indicator: take correction factors into account | ||
55 | SETUP_TIME | VRVEZ | DEC3_2 | DEC | 5 | 2 | Shipping setup time | ||
56 | BASE_QTY | VBAMG | MENG13 | QUAN | 13 | 3 | Base quantity for capacity planning in shipping | ||
57 | PROC_TIME | VBEAZ | DEC3_2 | DEC | 5 | 2 | Shipping processing time | ||
58 | SUP_SOURCE | BWSCL | BQSCL | CHAR | 1 | 0 | Source of Supply | TMBW1 | |
59 | AUTO_P_ORD | KAUTB | FLAG | CHAR | 1 | 0 | Indicator: "automatic purchase order allowed" | ||
60 | SOURCELIST | KORDB | XFELD | CHAR | 1 | 0 | Indicator: Source list requirement | ||
61 | COMM_CODE | STAWN | STAWN | CHAR | 17 | 0 | Commodity Code/Import Code Number for Foreign Trade | T604 | |
62 | COUNTRYORI | HERKL | LAND1 | CHAR | 3 | 0 | Country of origin of the material | T005 | |
63 | COUNTRYORI_ISO | HERKL_ISO | INTCA | CHAR | 2 | 0 | Material's country of origin in ISO code | ||
64 | REGIONORIG | HERKR | REGIO | CHAR | 3 | 0 | Region of origin of material (non-preferential origin) | T005S | |
65 | EXPIMPGRP | MTVER | MTVER | CHAR | 4 | 0 | Export/import material group | TVFM | |
66 | PROFIT_CTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
67 | PPC_PL_CAL | MRPPP | MRPPP | CHAR | 3 | 0 | PPC planning calendar | T439G | |
68 | REP_MANUF | SA_SAUFT | XFELD | CHAR | 1 | 0 | Ind.: Repetitive mfg allowed | ||
69 | PL_TI_FNCE | FXHOR | FXHOR | NUMC | 3 | 0 | Planning time fence | ||
70 | CONSUMMODE | VRMOD | VRMOD | CHAR | 1 | 0 | Consumption mode | ||
71 | BWD_CONS | VINT1 | VRINT | NUMC | 3 | 0 | Consumption period: backward | ||
72 | FWD_CONS | VINT2 | VRINT | NUMC | 3 | 0 | Consumption period: forward | ||
73 | ISS_ST_LOC | LGPRO | LGORT | CHAR | 4 | 0 | Issue storage location | T001L | |
74 | MRP_GROUP | DISGR | DISGR | CHAR | 4 | 0 | MRP Group | T438M | |
75 | COMP_SCRAP | KAUSF | DEC3_2 | DEC | 5 | 2 | Component scrap in percent | ||
76 | CERT_TYPE | QZGTYP | QZGTYP | CHAR | 4 | 0 | Certificate Type | TQ05 | |
77 | CYCLE_TIME | TAKZT | DEC3 | DEC | 3 | 0 | Takt time | ||
78 | COVPROFILE | RWPRO | RWPRO | CHAR | 3 | 0 | Range of coverage profile | T438R | |
79 | CO_PA_FLD | COPAM | OLD_FDNAME | CHAR | 10 | 0 | Local field name for CO/PA link to SOP | ||
80 | CC_PH_INV | ABCIN | ABCIN | CHAR | 1 | 0 | Physical inventory indicator for cycle counting | T159C | |
81 | SERNO_PROF | SERAIL | SERAIL | CHAR | 4 | 0 | Serial Number Profile | T377P | |
82 | REPMANPROF | SFEPR | SFEPR | CHAR | 4 | 0 | Repetitive manufacturing profile | T437S | |
83 | NEG_STOCKS | XMCNG | XFELD | CHAR | 1 | 0 | Negative stocks allowed in plant | ||
84 | QM_RGMTS | QSSYS_SOLL | QSSYS | CHAR | 4 | 0 | Required QM system for vendor | TQ02 | |
85 | PLNG_CYCLE | LFRHY | MRPPP | CHAR | 3 | 0 | Planning cycle | T439G | |
86 | ROUND_PROF | RDPRF | RDPRF | CHAR | 4 | 0 | Rounding Profile | RDPR | |
87 | REFMATCONS | VRBMT | MATNR | CHAR | 18 | 0 | Reference material for consumption | MARA | |
88 | REFPLTCONS | VRBWK | WERKS | CHAR | 4 | 0 | Reference plant for consumption | T001W | |
89 | D_TO_REF_M | VRBDT | DATUM | DATS | 8 | 0 | To date of the material to be copied for consumption | ||
90 | MULT_REF_M | VRBFK | DEC2_2 | DEC | 4 | 2 | Multiplier for reference material for consumption | ||
91 | AUTO_RESET | AUTRU | XFELD | CHAR | 1 | 0 | Reset forecast model automatically | ||
92 | EX_CERT_ID | PRENC | PRENC | CHAR | 1 | 0 | Exemption certificate: Indicator for legal control | ||
93 | EX_CERT_NO | PRENO | PRENO | NUMC | 8 | 0 | Number of exemption certificate in export/import | ||
94 | EX_CERT_DT | PREND | PREND | DATS | 8 | 0 | Exemption certificate: Issue date of exemption certificate | ||
95 | MILIT_ID | ITARK | XFELD | CHAR | 1 | 0 | Indicator: Military goods | ||
96 | INSP_INT | PRFRQ | DEC5 | DEC | 5 | 0 | Interval until next recurring inspection | ||
97 | CO_PRODUCT | KZKUPMAT | FLAG | CHAR | 1 | 0 | Indicator: Material can be co-product | ||
98 | PLAN_STRGP | STRGR | STRGR | CHAR | 2 | 0 | Planning strategy group | T461P | |
99 | SLOC_EXPRC | LGFSB | LGORT | CHAR | 4 | 0 | Default storage location for external procurement | T001L | |
100 | BULK_MAT | SCHGT | XFELD | CHAR | 1 | 0 | Indicator: bulk material | ||
101 | CC_FIXED | CCFIX | XFELD | CHAR | 1 | 0 | CC indicator is fixed | ||
102 | DETERM_GRP | BF_GROUP | BF_GROUP | CHAR | 4 | 0 | Stock determination group | T434G | |
103 | QM_AUTHGRP | QMATAUTH | QMATAUTH | CHAR | 6 | 0 | Material authorization group for activities in QM | TQ01B | |
104 | PUR_STATUS | MMSTA | MMSTA | CHAR | 2 | 0 | Plant-Specific Material Status | T141 | |
105 | SAFTY_T_ID | SHFLG | SHFLG | CHAR | 1 | 0 | Safety time indicator (with or without safety time) | ||
106 | SAFETYTIME | SHZET | NUMC2 | NUMC | 2 | 0 | Safety time (in workdays) | ||
107 | PLORD_CTRL | MDACH | MDACH | CHAR | 2 | 0 | Action control: planned order processing | T46AC | |
108 | BATCHENTRY | KZECH | KZECH | CHAR | 1 | 0 | Determination of batch entry in the production/process order | ||
109 | PROMSMOOTH | KZAGL | KZAGL | CHAR | 1 | 0 | Indicator: smooth promotion consumption | ||
110 | UNIT_GROUP | MEGRU | MEGRU | CHAR | 4 | 0 | Unit of Measure Group | TWMEG | |
111 | PVALIDFROM | MMSTD | DATUM | DATS | 8 | 0 | Date from which the plant-specific material status is valid | ||
112 | SERV_LEV_R | W_SERVGRD | W_SERVGRD | CHAR | 1 | 0 | IS-R service level | TWSG | |
113 | MATFRGTGRP | MFRGR | MFRGR | CHAR | 8 | 0 | Material freight group | TMFG | |
114 | HANDLG_GRP | LOGGR | LOGGR | CHAR | 4 | 0 | Logistics handling group for workload calculation | TLOG | |
115 | CFOP_CAT | J_1BINDUS3 | J_1BINDUS3 | CHAR | 2 | 0 | Material CFOP category | ||
116 | EU_LIST_NO | MOWNR | MOWNR | CHAR | 12 | 0 | CAP: Number of CAP products list | T618M | |
117 | EU_MAT_GRP | MOGRU | MOGRU | CHAR | 6 | 0 | Common Agricultural Policy: CAP products group-Foreign Trade | T618G | |
118 | CAS_NO | CASNR | CASNR | CHAR | 15 | 0 | CAS number for pharmaceutical products in foreign trade | T610C | |
119 | CTRL_CODE | STEUC | STEUC | CHAR | 16 | 0 | Control code for consumption taxes in foreign trade | T604F | |
120 | JIT_RELVT | FABKZ | FABKZ | CHAR | 1 | 0 | Indicator: Item Relevant to JIT Delivery Schedules | ||
121 | DISTR_PROF | FPRFM | MPPRF | CHAR | 3 | 0 | Distribution profile of material in plant | TMFPF | |
122 | PERIOD_PROFILE_SAFETY_TIME | SHPRO | SHPRO | CHAR | 3 | 0 | Period profile for safety time | T438V | |
123 | MRP_RELEVANCY_DEP_REQUIREMENTS | AHDIS | AHDIS | CHAR | 1 | 0 | MRP relevancy for dependent requirements | ||
124 | AVAIL_CHECK_ALL_PROJ_SEGMENTS | KZPSP | KZPSP | CHAR | 1 | 0 | Indicator for cross-project material | ||
125 | EX_CERT_NO_NEW | PRENN | PRENN | CHAR | 8 | 0 | Exemption certificate number for legal control | ||
126 | PRODUCTION_SCHEDULER | FEVOR | FEVOR | CHAR | 3 | 0 | Production Supervisor | * | |
127 | PROD_PROF | CO_PRODPRF | CO_PRODPRF | CHAR | 6 | 0 | Production Scheduling Profile | * | |
128 | MAT_GRP_TRANS | MATNRGROUP | CHAR20 | CHAR | 20 | 0 | Group of materials for transition matrix | ||
129 | OVERALL_PROF | OCM_GPROFILE | CHAR6 | CHAR | 6 | 0 | Overall profile for order change management | ||
130 | UNDER_TOL | UNETO | DEC2_1 | DEC | 3 | 1 | Underdelivery tolerance limit | ||
131 | OVER_TOL | UEETO | DEC2_1 | DEC | 3 | 1 | Overdelivery tolerance limit | ||
132 | UNLIMITED | UEETK | XFELD | CHAR | 1 | 0 | Indicator: Unlimited overdelivery allowed | ||
133 | SETUP_TIME_PROC | RUEZT | DEC3_2 | DEC | 5 | 2 | Setup and teardown time | ||
134 | PROCESSING_TIME | BEARZ | DEC3_2 | DEC | 5 | 2 | Processing time | ||
135 | BASE_QTY_PROC | BASMG | MENG13 | QUAN | 13 | 3 | Base quantity | ||
136 | INTEROP_TIME | TRANZ | DEC3_2 | DEC | 5 | 2 | Interoperation time | ||
137 | PROD_UNIT | FRTME | MEINS | UNIT | 3 | 0 | Production unit | * | |
138 | PROD_UNIT_ISO | FRTME_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Production Unit in ISO Code | * | |
139 | VARIANCE_KEY | AWSLS | AWSLS | CHAR | 6 | 0 | Variance Key | * | |
140 | ALTERNATIVE_BOM | STALT | ALTNR | CHAR | 2 | 0 | Alternative BOM | ||
141 | BOM_USAGE | STLAN | STLAN | CHAR | 1 | 0 | BOM Usage | * | |
142 | TASK_LIST_GRP_NO | PLNNR | PLNNR | CHAR | 8 | 0 | Key for Task List Group | ||
143 | GROUP_COUNTER | PLNAL | ALTNR | CHAR | 2 | 0 | Group Counter | ||
144 | TASK_LIST_TYPE | PLNTY | PLNTY | CHAR | 1 | 0 | Task List Type | * | |
145 | SPEC_PROC_TYPE | CK_SOBSL | SOBSL | CHAR | 2 | 0 | Special Procurement Type for Costing | * | |
146 | LOT_SIZE | CK_LOSGR | MENG13 | QUAN | 13 | 3 | Costing lot size | ||
147 | MIN_SAFETY_STK | EISLO | MENG13 | QUAN | 13 | 3 | Minimum Safety Stock | ||
148 | NO_COSTING | CK_NO_COSTING | CK_NO_COSTING | CHAR | 1 | 0 | Do Not Cost | ||
149 | FOLLOW_UP_EXTERNAL | MGV_FOLLOW_UP_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Long Material Number for field FOLLOW_UP | ||
150 | FOLLOW_UP_GUID | MGV_FOLLOW_UP_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for FOLLOW_UP Field | ||
151 | FOLLOW_UP_VERSION | MGV_FOLLOW_UP_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number for FOLLOW_UP Field | ||
152 | MATERIAL_EXTERNAL | MGV_MATERIAL_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Long Material Number for MATERIAL Field | ||
153 | MATERIAL_GUID | MGV_MATERIAL_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for MATERIAL Field | ||
154 | MATERIAL_VERSION | MGV_MATERIAL_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number for MATERIAL Field | ||
155 | REFMATCONS_EXTERNAL | MGV_REFMATCONS_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Long Material Number for REFMATCONS Field | ||
156 | REFMATCONS_GUID | MGV_REFMATCONS_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for REFMATCONS Field | ||
157 | REFMATCONS_VERSION | MGV_REFMATCONS_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number for REFMATCONS Field | ||
158 | PROPSUPPLYAREA | VSPVB | PRVBE | CHAR | 10 | 0 | Proposed Supply Area in Material Master Record | * | |
159 | CONSIGNMENT_CONTROL | WRF_CONS_PROCG | WRF_CONS_PROCG | CHAR | 1 | 0 | Consignment Control | * | |
160 | GI_PR_TIME | WRF_PSCD_WABAZ | DEC3 | DEC | 3 | 0 | Goods Issue Processing Time in Days | ||
161 | PURCH_ACROSS_PUR_GROUP | WRF_POHF_OTHER_EKGRP_ALLOW | CHAR1_X | CHAR | 1 | 0 | Purchasing Across Purchasing Group | ||
162 | REF_DETERM_SCHEMA | WRF_REF_SCHEMA | WRF_REF_SCHEMA | CHAR | 2 | 0 | Reference Determination Schema | * | |
163 | MIN_TROC | WRF_FRE_TROC_MIN | WRF_FRE_TROC | NUMC | 3 | 0 | Minimum Target Range of Coverage | ||
164 | MAX_TROC | WRF_FRE_TROC_MAX | WRF_FRE_TROC | NUMC | 3 | 0 | Maximum Target Range of Coverage | ||
165 | TARGET_STOCK | WRF_FRE_TARGET_STOCK | MENG13 | QUAN | 13 | 3 | Target Stock |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |