SAP ABAP Table RCPS_IDL_MATERIAL_PLANTDATA (Material Data at Plant Level)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷
PLM-RM (Application Component) Recipe Management
⤷
RMSATLMSC (Package) RMS-ATL: Miscellaneous
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | RCPS_IDL_MATERIAL_PLANTDATA |
|
| Short Description | 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 | |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
| 2 | |
PSTAT_D | PSTAT | CHAR | 15 | 0 | Maintenance status | ||
| 3 | |
LVOWK | XFELD | CHAR | 1 | 0 | Flag Material for Deletion at Plant Level | ||
| 4 | |
MAABC | MAABC | CHAR | 1 | 0 | ABC indicator | TMABC | |
| 5 | |
KZKRI | XFELD | CHAR | 1 | 0 | Indicator: Critical part | ||
| 6 | |
EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | * | |
| 7 | |
AUSME | MEINS | UNIT | 3 | 0 | Unit of issue | * | |
| 8 | |
AUSME_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit of issue in ISO code | * | |
| 9 | |
DISPR | DISPR | CHAR | 4 | 0 | Material: MRP profile | * | |
| 10 | |
DISMM | DISMM | CHAR | 2 | 0 | MRP Type | * | |
| 11 | |
DISPO | DISPO | CHAR | 3 | 0 | MRP controller | * | |
| 12 | |
PLIFZ | DEC3 | DEC | 3 | 0 | Planned delivery time in days | ||
| 13 | |
WEBAZ | DEC3 | DEC | 3 | 0 | Goods receipt processing time in days | ||
| 14 | |
PERKZ | PERKZ | CHAR | 1 | 0 | Period indicator | ||
| 15 | |
AUSSS | DEC3_2 | DEC | 5 | 2 | Assembly scrap in percent | ||
| 16 | |
DISLS | DISLS | CHAR | 2 | 0 | Lot size (materials planning) | * | |
| 17 | |
BESKZ | BESKZ | CHAR | 1 | 0 | Procurement Type | ||
| 18 | |
SOBSL | SOBSL | CHAR | 2 | 0 | Special procurement type | * | |
| 19 | |
MINBE | MENG13 | QUAN | 13 | 3 | Reorder point | ||
| 20 | |
EISBE | MENG13 | QUAN | 13 | 3 | Safety stock | ||
| 21 | |
BSTMI | MENG13 | QUAN | 13 | 3 | Minimum lot size | ||
| 22 | |
BSTMA | MENG13 | QUAN | 13 | 3 | Maximum lot size | ||
| 23 | |
BSTFE | MENG13 | QUAN | 13 | 3 | Fixed lot size | ||
| 24 | |
BSTRF | MENG13 | QUAN | 13 | 3 | Rounding value for purchase order quantity | ||
| 25 | |
MABST | MENG13 | QUAN | 13 | 3 | Maximum stock level | ||
| 26 | |
LOSFX_BAPI | BAPICURR | DEC | 23 | 4 | Ordering costs (BAPI interfaces) | ||
| 27 | |
SBDKZ | SBDKZ | CHAR | 1 | 0 | Dependent requirements ind. for individual and coll. reqmts | ||
| 28 | |
LAGPR | LAGPR | CHAR | 1 | 0 | Storage costs indicator | * | |
| 29 | |
ALTSL | ALTSL | CHAR | 1 | 0 | Method for Selecting Alternative Bills of Material | ||
| 30 | |
KZAUS | KZAUS | CHAR | 1 | 0 | Discontinuation indicator | ||
| 31 | |
AUSDT | DATUM | DATS | 8 | 0 | Effective-out date | ||
| 32 | |
NFMAT | MATNR | CHAR | 18 | 0 | Follow-up material | * | |
| 33 | |
KZBED | KZBED | CHAR | 1 | 0 | Indicator for Requirements Grouping | ||
| 34 | |
MISKZ | MISKZ | CHAR | 1 | 0 | Mixed MRP indicator | ||
| 35 | |
FHORI | FHORI | CHAR | 3 | 0 | Scheduling Margin Key for Floats | * | |
| 36 | |
RGEKM | RGEKM | CHAR | 1 | 0 | Indicator: Backflush | ||
| 37 | |
FEVOR | FEVOR | CHAR | 3 | 0 | Production Supervisor | * | |
| 38 | |
BEARZ | DEC3_2 | DEC | 5 | 2 | Processing time | ||
| 39 | |
RUEZT | DEC3_2 | DEC | 5 | 2 | Setup and teardown time | ||
| 40 | |
TRANZ | DEC3_2 | DEC | 5 | 2 | Interoperation time | ||
| 41 | |
BASMG | MENG13 | QUAN | 13 | 3 | Base quantity | ||
| 42 | |
DZEIT | DEC3 | DEC | 3 | 0 | In-house production time | ||
| 43 | |
MAXLZ | DEC5 | DEC | 5 | 0 | Maximum storage period | ||
| 44 | |
LZEIH | MEINS | UNIT | 3 | 0 | Unit for maximum storage period | * | |
| 45 | |
LZEIH_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit for the maximum storage period in ISO code | * | |
| 46 | |
UEETO | DEC2_1 | DEC | 3 | 1 | Overdelivery tolerance limit | ||
| 47 | |
UEETK | XFELD | CHAR | 1 | 0 | Indicator: Unlimited overdelivery allowed | ||
| 48 | |
UNETO | DEC2_1 | DEC | 3 | 1 | Underdelivery tolerance limit | ||
| 49 | |
WZEIT | DEC3 | DEC | 3 | 0 | Total replenishment lead time (in workdays) | ||
| 50 | |
ATPKZ | ATPKZ | CHAR | 1 | 0 | Replacement part | ||
| 51 | |
INSMK_MAT | QKZ | CHAR | 1 | 0 | Post to Inspection Stock | ||
| 52 | |
QSSPUR | QSSPUR | CHAR | 8 | 0 | Control Key for Quality Management in Procurement | * | |
| 53 | |
KZDKZ | XFELD | CHAR | 1 | 0 | Documentation required indicator | ||
| 54 | |
LADGR | LADGR | CHAR | 4 | 0 | Loading Group | * | |
| 55 | |
XCHPF | XFELD | CHAR | 1 | 0 | Batch management requirement indicator | ||
| 56 | |
USEQU | USEQU | CHAR | 1 | 0 | Quota arrangement usage | * | |
| 57 | |
LGRAD | DEC2_1 | DEC | 3 | 1 | Service level | ||
| 58 | |
AUFTL | AUFTL | CHAR | 1 | 0 | Splitting Indicator | * | |
| 59 | |
MTVFP | MTVFP | CHAR | 2 | 0 | Checking Group for Availability Check | * | |
| 60 | |
PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
| 61 | |
KZKFK | XFELD | CHAR | 1 | 0 | Indicator: take correction factors into account | ||
| 62 | |
VRVEZ | DEC3_2 | DEC | 5 | 2 | Shipping setup time | ||
| 63 | |
VBAMG | MENG13 | QUAN | 13 | 3 | Base quantity for capacity planning in shipping | ||
| 64 | |
VBEAZ | DEC3_2 | DEC | 5 | 2 | Shipping processing time | ||
| 65 | |
BWSCL | BQSCL | CHAR | 1 | 0 | Source of Supply | * | |
| 66 | |
KAUTB | FLAG | CHAR | 1 | 0 | Indicator: "automatic purchase order allowed" | ||
| 67 | |
KORDB | XFELD | CHAR | 1 | 0 | Indicator: Source list requirement | ||
| 68 | |
STAWN | STAWN | CHAR | 17 | 0 | Commodity Code/Import Code Number for Foreign Trade | * | |
| 69 | |
HERKL | LAND1 | CHAR | 3 | 0 | Country of origin of the material | * | |
| 70 | |
HERKL_ISO | INTCA | CHAR | 2 | 0 | Material's country of origin in ISO code | ||
| 71 | |
HERKR | REGIO | CHAR | 3 | 0 | Region of origin of material (non-preferential origin) | * | |
| 72 | |
EXPME | MEINS | UNIT | 3 | 0 | Unit of measure for commodity code (foreign trade) | * | |
| 73 | |
EXPME_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit of measure for commodity code (for. trade) in ISO code | * | |
| 74 | |
MTVER | MTVER | CHAR | 4 | 0 | Export/import material group | * | |
| 75 | |
PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
| 76 | |
MRPPP | MRPPP | CHAR | 3 | 0 | PPC planning calendar | * | |
| 77 | |
SA_SAUFT | XFELD | CHAR | 1 | 0 | Ind.: Repetitive mfg allowed | ||
| 78 | |
FXHOR | FXHOR | NUMC | 3 | 0 | Planning time fence | ||
| 79 | |
VRMOD | VRMOD | CHAR | 1 | 0 | Consumption mode | ||
| 80 | |
VINT1 | VRINT | NUMC | 3 | 0 | Consumption period: backward | ||
| 81 | |
VINT2 | VRINT | NUMC | 3 | 0 | Consumption period: forward | ||
| 82 | |
CK_VERK1 | XFELD | CHAR | 1 | 0 | Version indicator | ||
| 83 | |
STLAL | ALTNR | CHAR | 2 | 0 | Alternative BOM | ||
| 84 | |
STLAN | STLAN | CHAR | 1 | 0 | BOM Usage | * | |
| 85 | |
PLNNR | PLNNR | CHAR | 8 | 0 | Key for Task List Group | ||
| 86 | |
PLNAL | ALTNR | CHAR | 2 | 0 | Group Counter | ||
| 87 | |
CK_LOSGR | MENG13 | QUAN | 13 | 3 | Costing lot size | ||
| 88 | |
CK_SOBSL | SOBSL | CHAR | 2 | 0 | Special Procurement Type for Costing | * | |
| 89 | |
FRTME | MEINS | UNIT | 3 | 0 | Production unit | * | |
| 90 | |
FRTME_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Production Unit in ISO Code | * | |
| 91 | |
LGPRO | LGORT | CHAR | 4 | 0 | Issue storage location | * | |
| 92 | |
DISGR | DISGR | CHAR | 4 | 0 | MRP Group | * | |
| 93 | |
KAUSF | DEC3_2 | DEC | 5 | 2 | Component scrap in percent | ||
| 94 | |
QZGTYP | QZGTYP | CHAR | 4 | 0 | Certificate Type | * | |
| 95 | |
TAKZT | DEC3 | DEC | 3 | 0 | Takt time | ||
| 96 | |
QMATV | XFELD | CHAR | 1 | 0 | Inspection Setup Exists for Material/Plant | ||
| 97 | |
RWPRO | RWPRO | CHAR | 3 | 0 | Range of coverage profile | * | |
| 98 | |
ABCIN | ABCIN | CHAR | 1 | 0 | Physical inventory indicator for cycle counting | * | |
| 99 | |
AWSLS | AWSLS | CHAR | 6 | 0 | Variance Key | * | |
| 100 | |
SERAIL | SERAIL | CHAR | 4 | 0 | Serial Number Profile | * | |
| 101 | |
STDPD | MATNR | CHAR | 18 | 0 | Configurable material | * | |
| 102 | |
SFEPR | SFEPR | CHAR | 4 | 0 | Repetitive manufacturing profile | * | |
| 103 | |
XMCNG | XFELD | CHAR | 1 | 0 | Negative stocks allowed in plant | ||
| 104 | |
QSSYS_SOLL | QSSYS | CHAR | 4 | 0 | Required QM system for vendor | * | |
| 105 | |
LFRHY | MRPPP | CHAR | 3 | 0 | Planning cycle | * | |
| 106 | |
RDPRF | RDPRF | CHAR | 4 | 0 | Rounding Profile | * | |
| 107 | |
VRBMT | MATNR | CHAR | 18 | 0 | Reference material for consumption | * | |
| 108 | |
VRBWK | WERKS | CHAR | 4 | 0 | Reference plant for consumption | * | |
| 109 | |
VRBDT | DATUM | DATS | 8 | 0 | To date of the material to be copied for consumption | ||
| 110 | |
VRBFK | DEC2_2 | DEC | 4 | 2 | Multiplier for reference material for consumption | ||
| 111 | |
AUTRU | XFELD | CHAR | 1 | 0 | Reset forecast model automatically | ||
| 112 | |
PREFE | PREFE | CHAR | 1 | 0 | Preference indicator in export/import | ||
| 113 | |
PRENC | PRENC | CHAR | 1 | 0 | Exemption certificate: Indicator for legal control | ||
| 114 | |
PRENN | PRENN | CHAR | 8 | 0 | Exemption certificate number for legal control | ||
| 115 | |
PREND | PREND | DATS | 8 | 0 | Exemption certificate: Issue date of exemption certificate | ||
| 116 | |
PRENE | PRENE | CHAR | 1 | 0 | Indicator: Vendor declaration exists | ||
| 117 | |
ITARK | XFELD | CHAR | 1 | 0 | Indicator: Military goods | ||
| 118 | |
PRFRQ | DEC5 | DEC | 5 | 0 | Interval until next recurring inspection | ||
| 119 | |
KZKUPMAT | FLAG | CHAR | 1 | 0 | Indicator: Material can be co-product | ||
| 120 | |
STRGR | STRGR | CHAR | 2 | 0 | Planning strategy group | * | |
| 121 | |
LGFSB | LGORT | CHAR | 4 | 0 | Default storage location for external procurement | * | |
| 122 | |
SCHGT | XFELD | CHAR | 1 | 0 | Indicator: bulk material | ||
| 123 | |
CCFIX | XFELD | CHAR | 1 | 0 | CC indicator is fixed | ||
| 124 | |
BF_GROUP | BF_GROUP | CHAR | 4 | 0 | Stock determination group | * | |
| 125 | |
QMATAUTH | QMATAUTH | CHAR | 6 | 0 | Material authorization group for activities in QM | * | |
| 126 | |
PLNTY | PLNTY | CHAR | 1 | 0 | Task List Type | * | |
| 127 | |
MMSTA | MMSTA | CHAR | 2 | 0 | Plant-Specific Material Status | * | |
| 128 | |
CO_PRODPRF | CO_PRODPRF | CHAR | 6 | 0 | Production Scheduling Profile | * | |
| 129 | |
SHFLG | SHFLG | CHAR | 1 | 0 | Safety time indicator (with or without safety time) | ||
| 130 | |
SHZET | NUMC2 | NUMC | 2 | 0 | Safety time (in workdays) | ||
| 131 | |
MDACH | MDACH | CHAR | 2 | 0 | Action control: planned order processing | * | |
| 132 | |
KZECH | KZECH | CHAR | 1 | 0 | Determination of batch entry in the production/process order | ||
| 133 | |
MMSTD | DATUM | DATS | 8 | 0 | Date from which the plant-specific material status is valid | ||
| 134 | |
MFRGR | MFRGR | CHAR | 8 | 0 | Material freight group | * | |
| 135 | |
CK_VERID | VERID | CHAR | 4 | 0 | Production version to be costed | * | |
| 136 | |
J_1BINDUS3 | J_1BINDUS3 | CHAR | 2 | 0 | Material CFOP category | ||
| 137 | |
MOWNR | MOWNR | CHAR | 12 | 0 | CAP: Number of CAP products list | * | |
| 138 | |
MOGRU | MOGRU | CHAR | 6 | 0 | Common Agricultural Policy: CAP products group-Foreign Trade | * | |
| 139 | |
CASNR | CASNR | CHAR | 15 | 0 | CAS number for pharmaceutical products in foreign trade | * | |
| 140 | |
GPNUM | GPNUM | CHAR | 9 | 0 | Production statistics: PRODCOM number for foreign trade | * | |
| 141 | |
STEUC | STEUC | CHAR | 16 | 0 | Control code for consumption taxes in foreign trade | * | |
| 142 | |
FABKZ | FABKZ | CHAR | 1 | 0 | Indicator: Item Relevant to JIT Delivery Schedules | ||
| 143 | |
MATNRGROUP | CHAR20 | CHAR | 20 | 0 | Group of materials for transition matrix | ||
| 144 | |
LOGGR | LOGGR | CHAR | 4 | 0 | Logistics handling group for workload calculation | * | |
| 145 | |
VSPVB | PRVBE | CHAR | 10 | 0 | Proposed Supply Area in Material Master Record | * | |
| 146 | |
DPLFS | DPLFS | CHAR | 2 | 0 | Fair share rule | ||
| 147 | |
DPLPU | DPLPU | CHAR | 1 | 0 | Indicator: push distribution | ||
| 148 | |
DPLHO | DEC3 | DEC | 3 | 0 | Deployment horizon in days | ||
| 149 | |
CSCP_MINLOTSIZE | MENG13 | QUAN | 13 | 3 | Minimum lot size for Supply Demand Match | ||
| 150 | |
CSCP_MAXLOTSIZE | MENG13 | QUAN | 13 | 3 | Maximum lot size for Supply Demand Match | ||
| 151 | |
CSCP_FIXLOTSIZE | MENG13 | QUAN | 13 | 3 | Fixed lot size for Supply Demand Match | ||
| 152 | |
CSCP_LOTINCREMENT | MENG13 | QUAN | 13 | 3 | Lot size increment for Supply Demand Match | ||
| 153 | |
CSCP_CONV_TYPE | CSCP_CONV_TYPE | CHAR | 2 | 0 | Conversion types for production figures | * | |
| 154 | |
FPRFM | MPPRF | CHAR | 3 | 0 | Distribution profile of material in plant | * | |
| 155 | |
SHPRO | SHPRO | CHAR | 3 | 0 | Period profile for safety time | * | |
| 156 | |
CK_FIXPRKU | XFELD | CHAR | 1 | 0 | Fixed-Price Co-Product | ||
| 157 | |
KZPSP | KZPSP | CHAR | 1 | 0 | Indicator for cross-project material | ||
| 158 | |
OCM_GPROFILE | CHAR6 | CHAR | 6 | 0 | Overall profile for order change management | ||
| 159 | |
AHDIS | AHDIS | CHAR | 1 | 0 | MRP relevancy for dependent requirements | ||
| 160 | |
DIBER | XFELD | CHAR | 1 | 0 | Indicator: MRP area exists | ||
| 161 | |
EISLO | MENG13 | QUAN | 13 | 3 | Minimum Safety Stock | ||
| 162 | |
CK_NO_COSTING | CK_NO_COSTING | CHAR | 1 | 0 | Do Not Cost | ||
| 163 | |
MEGRU | MEGRU | CHAR | 4 | 0 | Unit of Measure Group | * | |
| 164 | |
MGV_FOLLOW_UP_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Long Material Number for field FOLLOW_UP | ||
| 165 | |
MGV_FOLLOW_UP_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for FOLLOW_UP Field | ||
| 166 | |
MGV_FOLLOW_UP_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number for FOLLOW_UP Field | ||
| 167 | |
MGV_REFMATCONS_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Long Material Number for REFMATCONS Field | ||
| 168 | |
MGV_REFMATCONS_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID for REFMATCONS Field | ||
| 169 | |
MGV_REFMATCONS_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number for REFMATCONS Field | ||
| 170 | |
ROTATION_DATE | ROTATION_DATE | CHAR | 1 | 0 | Strategy for Putaway and Stock Removal | ||
| 171 | |
UCHKZ | UCHKZ | CHAR | 1 | 0 | Indicator for Original Batch Management | ||
| 172 | |
VBOB_OB_RFMAT | MATNR | CHAR | 18 | 0 | Reference Material for Original Batches | * | |
| 173 | |
MGV_PS_CONF_MAT_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Long Material Number (Future Development) for PS_CO Field | ||
| 174 | |
MGV_PS_CONF_MAT_GUID | MATNR_EGUID | CHAR | 32 | 0 | External GUID (Future Development) for PS_CONF_MAT Field | ||
| 175 | |
MGV_PS_CONF_MAT_VERSION | MATNR_VERS | CHAR | 10 | 0 | Version Number (Future Development) for PS_CONF_MAT Field | ||
| 176 | |
MGV_VBOB_OB_RFMAT_EXTERNAL | MATNR_EXT | CHAR | 40 | 0 | Reference Material for Original Batches | ||
| 177 | |
MGV_VBOB_OB_RFMAT_VERSION | MATNR_VERS | CHAR | 10 | 0 | Reference Material for Original Batches | ||
| 178 | |
MGV_VBOB_OB_RFMAT_GUID | MATNR_EGUID | CHAR | 32 | 0 | Reference Material for Original Batches | ||
| 179 | |
IUID_RELEVANT | UID_RELEVANT | CHAR | 1 | 0 | IUID-Relevant | ||
| 180 | |
IUID_TYPE | IUID_TYPE | CHAR | 10 | 0 | Structure Type of UII | * | |
| 181 | |
UID_IEA | UID_IEA | CHAR | 1 | 0 | External Allocation of UII |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | RCPS_IDL_MATERIAL_PLANTDATA | ABC_ID | |
|
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |