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
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
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 BAPIE1MARCRT ABC_ID TMABC MAABC    
2 BAPIE1MARCRT AVAILCHECK TMVF MTVFP    
3 BAPIE1MARCRT CAS_NO T610C CASNR    
4 BAPIE1MARCRT CC_PH_INV T159C ABCIN    
5 BAPIE1MARCRT CERT_TYPE TQ05 ZGTYP    
6 BAPIE1MARCRT COMM_CODE T604 STAWN    
7 BAPIE1MARCRT COUNTRYORI T005 LAND1    
8 BAPIE1MARCRT COVPROFILE T438R RWPRO    
9 BAPIE1MARCRT CTRL_CODE T604F STEUC    
10 BAPIE1MARCRT CTRL_KEY TQ08 QM_PUR    
11 BAPIE1MARCRT DETERM_GRP T434G EPRIO    
12 BAPIE1MARCRT DISTR_PROF TMFPF FPRFM    
13 BAPIE1MARCRT EU_LIST_NO T618M MOWNR    
14 BAPIE1MARCRT EU_MAT_GRP T618G MOGRU    
15 BAPIE1MARCRT EXPIMPGRP TVFM MTVER    
16 BAPIE1MARCRT FOLLOW_UP MARA MATNR    
17 BAPIE1MARCRT FY_VARIANT T009 PERIV    
18 BAPIE1MARCRT HANDLG_GRP TLOG LOGGR    
19 BAPIE1MARCRT ISSUE_UNIT T006 MSEHI    
20 BAPIE1MARCRT ISSUE_UNIT_ISO T006I ISOCODE    
21 BAPIE1MARCRT ISS_ST_LOC T001L LGORT    
22 BAPIE1MARCRT LOADINGGRP TLGR LADGR    
23 BAPIE1MARCRT LOTSIZEKEY T439A DISLS    
24 BAPIE1MARCRT MATERIAL MARA MATNR    
25 BAPIE1MARCRT MATFRGTGRP TMFG MFRGR    
26 BAPIE1MARCRT MRPPROFILE MDIP DISPR    
27 BAPIE1MARCRT MRP_CTRLER T024D DISPO    
28 BAPIE1MARCRT MRP_GROUP T438M MTART    
29 BAPIE1MARCRT MRP_TYPE T438A DISMM    
30 BAPIE1MARCRT PERIOD_PROFILE_SAFETY_TIME T438V SHPRO    
31 BAPIE1MARCRT PLANT T001W WERKS    
32 BAPIE1MARCRT PLAN_STRGP T461P STRGR    
33 BAPIE1MARCRT PLNG_CYCLE T439G MRPPP    
34 BAPIE1MARCRT PLORD_CTRL T46AC MDACH    
35 BAPIE1MARCRT PPC_PL_CAL T439G MRPPP    
36 BAPIE1MARCRT PROFIT_CTR CEPC PRCTR REF    
37 BAPIE1MARCRT PUR_GROUP T024 EKGRP    
38 BAPIE1MARCRT PUR_STATUS T141 MMSTA    
39 BAPIE1MARCRT QM_AUTHGRP TQ01B QMATAUTH    
40 BAPIE1MARCRT QM_RGMTS TQ02 QSSYS    
41 BAPIE1MARCRT QUOTAUSAGE TMQ2 USEQU    
42 BAPIE1MARCRT REFMATCONS MARA MATNR    
43 BAPIE1MARCRT REFPLTCONS T001W WERKS    
44 BAPIE1MARCRT REGIONORIG T005S BLAND    
45 BAPIE1MARCRT REPMANPROF T437S SFPRO    
46 BAPIE1MARCRT ROUND_PROF RDPR RDPRF    
47 BAPIE1MARCRT SERNO_PROF T377P SERAIL    
48 BAPIE1MARCRT SERV_LEV_R TWSG SERVG    
49 BAPIE1MARCRT SLOC_EXPRC T001L LGORT    
50 BAPIE1MARCRT SM_KEY T436A FHORI    
51 BAPIE1MARCRT SPLIT_IND T439P AUFTL    
52 BAPIE1MARCRT SPPROCTYPE T460A SOBSL    
53 BAPIE1MARCRT STGE_PD_UN T006 MSEHI    
54 BAPIE1MARCRT STGE_PD_UN_ISO T006I ISOCODE    
55 BAPIE1MARCRT STOR_COSTS T439L LAGPR    
56 BAPIE1MARCRT SUP_SOURCE TMBW1 BWSCL    
57 BAPIE1MARCRT UNIT_GROUP TWMEG MEGRU    
History
Last changed by/on SAP  20130529 
SAP Release Created in