SAP PPH_SDM_MAT_CTRL Table in S/4 HANA - Master data for MRP Live
PPH_SDM_MAT_CTRL is a standard SAP Table which is used to store Master data for MRP Live data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP PPH_SDM_MAT_CTRL table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Cannot Be Enhanced
Dictionary Type: Structure
Database Table: PPH_SDM_MAT_CTRL
PPH_SDM_MAT_CTRL table structure field list
Below is the full PPH_SDM_MAT_CTRL field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MATNR | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
WERKS | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
BERID | MRP Area | BERID | CHAR | 10(0) | BERID | BERID | ||||
SGT_CSGR | Segmentation Structure | SGT_CSGR | CHAR | 4(0) | SGT_CSGR | |||||
SGT_COVSA | Segmentation Strategy | SGT_COVSA | CHAR | 8(0) | SGT_COVS | SGT_E | SGT_COVS_SHLP1 | SGT_COVS | ||
SGT_STAT | Segmentation Status | SGT_STATC | CHAR | 1(0) | SGT_STAT | |||||
SGT_REL | Segmentation Relevant | SGT_REL | CHAR | 1(0) | CHAR1 | |||||
SGT_COVS | Segmentation Strategy | SGT_COVS | CHAR | 8(0) | SGT_COVS | SGT_E | SGT_COVS_SHLP | SGT_COVS | ||
SGT_STATC | Segmentation Status | SGT_STATC | CHAR | 1(0) | SGT_STAT | |||||
SGT_SCOPE | Segmentation Strategy Scope | SGT_SCOPE | CHAR | 1(0) | SGT_SCOPE | |||||
SGT_MRPSI | Sort Stock based on Segment | SGT_MRPSI | CHAR | 1(0) | SGT_ATPSI | |||||
SGT_PRCM | Consumption Priority | SGT_PRCM | CHAR | 1(0) | SGT_PRCM | |||||
SGT_CHINT | Discrete Batch Number | SGT_CHINT | CHAR | 1(0) | X | |||||
FSH_MG_ARUN_REQ | Supply Assignment (ARun) | FSH_MG_ARUN_REQ | CHAR | 1(0) | FSH_MG_ARUN_REQ | |||||
ARUN_FIX_BATCH | Assign Batches in Supply Assignment (ARun) | ARUN_FIX_BATCH | CHAR | 1(0) | ARUN_FIX_BATCH | |||||
FSH_VAR_GROUP | Variant Group | FSH_VAR_GROUP | CHAR | 2(0) | CHAR2 | |||||
FSH_CALENDAR_GROUP | Calendar Group | FSH_CALENDAR_GROUP | CHAR | 4(0) | FSH_CALENDAR_GROUP | FSH_CUT_CAL_GROUP | CAL_GROUP | |||
FSH_GROUP_PR | Activate Variant Grouping | FSH_GROUP_PR | CHAR | 1(0) | FSH_GROUP_PR | |||||
BERTY | Type of MRP Area | BERTY | NUMC | 2(0) | BERTY | |||||
MATKL | Material Group | MATKL | CHAR | 9(0) | MATKL | MKL | S_WBWG | MATKL | ||
LVORM_MARA | Deletion Indicator | LVORM | CHAR | 1(0) | XFELD | |||||
LVORM_MARC | Deletion Indicator | LVORM | CHAR | 1(0) | XFELD | |||||
SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 40(0) | MATN1 | MATNR | ||||
MSTAE | Cross-Plant Material Status | MSTAE | CHAR | 2(0) | MMSTA | H_T141 | MMSTA | |||
ATTYP | Material Category | ATTYP | CHAR | 2(0) | ATTYP | MTY | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3(0) | CUNIT | MEINS | ||||
DISST | Low-Level Code | DISST | CHAR | 3(0) | DISST | |||||
KZKFG | Configurable Material | KZKFG | CHAR | 1(0) | XFELD | |||||
CUOBF | Configuration (internal object number) | CUOBJ | NUMC | 18(0) | CUOBJ | CUX | ||||
MPROF | Mfr part profile | MPROF | CHAR | 4(0) | MPROF | |||||
MFRPN | Manufacturer Part Number | MFRPN | CHAR | 40(0) | CHAR40 | |||||
MFRNR | Manufacturer number | MFRNR | CHAR | 10(0) | ALPHA | LIFNR | ||||
MMSTA | Plant-Specific Material Status | MMSTA | CHAR | 2(0) | MMSTA | |||||
MAABC | ABC Indicator | MAABC | CHAR | 1(0) | MAABC | |||||
EKGRP | Purchasing Group | EKGRP | CHAR | 3(0) | EKGRP | EKG | ||||
ANDEC | DEC | 5(0) | ||||||||
BESKZ | Procurement Type | BESKZ | CHAR | 1(0) | BESKZ | MBS | ||||
SOBES | Special procurement type | SOBES | CHAR | 1(0) | SOBES | |||||
WRK02 | Planning/production plant | WRK02 | CHAR | 4(0) | WERKS | |||||
SBDKZ | Dependent requirements ind. for individual and coll. reqmts | SBDKZ | CHAR | 1(0) | SBDKZ | |||||
KZAUS | Discontinuation indicator | KZAUS | CHAR | 1(0) | KZAUS | |||||
AUSDT | System Date | SYDATUM | DATS | 8(0) | SYDATS | |||||
MTART | Material type | MTART | CHAR | 4(0) | MTART | MTA | ||||
DISGR | MRP Group | DISGR | CHAR | 4(0) | DISGR | |||||
DISPO | MRP Controller | DISPO | CHAR | 3(0) | DISPO | DGR | HS_T024D | DISPO | ||
MISKZ | Mixed MRP indicator | MISKZ | CHAR | 1(0) | MISKZ | |||||
RWPRO | Range of coverage profile | RWPRO | CHAR | 3(0) | RWPRO | |||||
FHORI | Scheduling Margin Key for Floats | FHORI | CHAR | 3(0) | FHORI | |||||
AHDIS | MRP relevancy for dependent requirements | AHDIS | CHAR | 1(0) | AHDIS | |||||
VRMOD | Consumption mode | VRMOD | CHAR | 1(0) | VRMOD | |||||
VINT1 | Consumption period: backward | VINT1 | NUMC | 3(0) | VRINT | |||||
VINT2 | Consumption period: forward | VINT2 | NUMC | 3(0) | VRINT | |||||
STDPD | Configurable material | STDPD | CHAR | 40(0) | MATN1 | MATNR | ||||
CUOBV | Configuration (internal object number) | CUOBJ | NUMC | 18(0) | CUOBJ | CUX | ||||
BEARZ | Processing time | BEARZ | DEC | 5(2) | DEC3_2 | |||||
RUEZT | Setup and teardown time | RUEZT | DEC | 5(2) | DEC3_2 | |||||
TRANZ | Interoperation time | TRANZ | DEC | 5(2) | DEC3_2 | |||||
WEBAZ | Goods receipt processing time in days | WEBAZ | DEC | 3(0) | DEC3 | |||||
PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3(0) | DEC3 | |||||
DZEIT | In-house production time | DZEIT | DEC | 3(0) | DEC3 | |||||
WZEIT | Total replenishment lead time (in workdays) | WZEIT | DEC | 3(0) | DEC3 | |||||
SHFLG | Safety time indicator (with or without safety time) | SHFLG | CHAR | 1(0) | SHFLG | |||||
SHZET | Safety time (in workdays) | SHZET | NUMC | 2(0) | NUMC2 | |||||
SHPRO | Period Profile for Safety Time | SHPRO | CHAR | 3(0) | SHPRO | |||||
QMATV | Inspection Setup Exists for Material/Plant | QMATV | CHAR | 1(0) | XFELD | |||||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18(0) | CUOBJ | CUX | ||||
RESVP | Period of adjustment for planned independent requirements | RESVP | DEC | 3(0) | RESVP | |||||
UMLMC | DEC | 13(3) | ||||||||
USEQU | Quota arrangement usage | USEQU | CHAR | 1(0) | USEQU | |||||
MINBE | Reorder Point | MINBE | QUAN | 13(3) | MENG13 | |||||
EISBE | Safety stock | EISBE | QUAN | 13(3) | MENG13 | |||||
DISLS | Lot Sizing Procedure within Materials Planning | DISLS | CHAR | 2(0) | DISLS | |||||
BSTMI | Minimum Lot Size | BSTMI | QUAN | 13(3) | MENG13 | |||||
BSTMA | Maximum Lot Size | BSTMA | QUAN | 13(3) | MENG13 | |||||
BSTFE | Fixed lot size | BSTFE | QUAN | 13(3) | MENG13 | |||||
MABST | Maximum Stock Level | MABST | QUAN | 13(3) | MENG13 | |||||
LOSFX | Lot-Size-Independent Costs | LOSFX | CURR | 11(2) | WERT11 | |||||
LAGPR | Storage Costs Percentage Code | LAGPR | CHAR | 1(0) | LAGPR | |||||
AUSSS | Assembly scrap in percent | AUSSS | DEC | 5(2) | DEC3_2 | |||||
TAKZT | Takt time | TAKZT | DEC | 3(0) | DEC3 | |||||
BSTRF | Rounding value for purchase order quantity | BSTRF | QUAN | 13(3) | MENG13 | |||||
RDPRF | Rounding Profile | RDPRF | CHAR | 4(0) | RDPRF | |||||
STRGR | Planning Strategy Group | STRGR | CHAR | 2(0) | STRGR | |||||
LGFSB | Default storage location for external procurement | LGFSB | CHAR | 4(0) | LGORT | |||||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2(0) | PERIV | |||||
MRPPP | PPC Planning Calendar | MRPPP | CHAR | 3(0) | MRPPP | |||||
SAUFT | Indicator: Repetitive Manufacturing Allowed | SA_SAUFT | CHAR | 1(0) | XFELD | |||||
SFEPR | Repetitive Manufacturing Profile | SFEPR | CHAR | 4(0) | SFEPR | |||||
FXHOR | Dec 3,0 data element | PPH_DEC_3_0 | DEC | 3(0) | ||||||
DISMM | MRP Type | DISMM | CHAR | 2(0) | DISMM | |||||
PERKZ | Period Indicator | PERKZ | CHAR | 1(0) | PERKZ | PKZ | ||||
SOBSL | Special procurement type | SOBSL | CHAR | 2(0) | SOBSL | |||||
FEVOR | Production Supervisor | FEVOR | CHAR | 3(0) | FEVOR | CFV | ||||
BASMG | Base quantity | BASMG | QUAN | 13(3) | MENG13 | |||||
LGPRO | Issue Storage Location | LGPRO | CHAR | 4(0) | LGORT | |||||
DISVF | MRP Procedure | DISVF | CHAR | 1(0) | DISVF | H_DISVF | DOMVALUE_L | |||
BBBED | Material staging reqmts (subcontr. reqmts) MRP element BB | BBBED | CHAR | 1(0) | XFELD | |||||
FXART | Firming Type of the Planning Result | FXART | CHAR | 1(0) | FXART | |||||
PROOS | MRP indicator of forecast | PROOS | CHAR | 1(0) | PROOS | |||||
PRRED | Reduce forecast requirements | PRRED | CHAR | 1(0) | PRPED | |||||
RYBED | Time-phased planning with requirements (MRP) | RYBED | CHAR | 1(0) | XFELD | |||||
KZREG | Indicator: plan material regularly | KZREG | CHAR | 1(0) | XFELD | |||||
CBPPT | Method by which a material is planned | CBP_PLANTYPE | CHAR | 1(0) | CBP_PLANTYPE | |||||
ICBED | Reorder point planning with external requirements | ICBED | CHAR | 1(0) | ICBED | |||||
U1BED | Release for stock transfer order | U1BED | CHAR | 1(0) | XFELD | |||||
U2BED | Delivery schedule for a stock transfer requisition | U2BED | CHAR | 1(0) | XFELD | |||||
U4BED | Delivery schedule for stock transport scheduling agreement | U4BED | CHAR | 1(0) | XFELD | |||||
A1BED | Dependent reservation - standard orders | A1BED | CHAR | 1(0) | XFELD | |||||
A2BED | Dependent reservation - plant maintenance orders and network | A2BED | CHAR | 1(0) | XFELD | |||||
GRREL | Relevant for requirements grouping for project stock | GRREL | CHAR | 1(0) | XFELD | |||||
RVPKZ | Adjustment of Planned Independent Requirements | RVPKZ | CHAR | 1(0) | RVPKZ | |||||
ANDIS | Number of Days After Which the Material Must Be Planned | ANDIS | INT2 | 5(0) | INT2 | |||||
BSART | Order Type (Purchasing) | BSART | CHAR | 4(0) | BSART | BSA | ||||
BARTL | CHAR | 4(0) | ||||||||
BARTU | CHAR | 4(0) | ||||||||
SBDIS | Dec 3,0 data element | PPH_DEC_3_0 | DEC | 3(0) | ||||||
SCFLG | CHAR | 1(0) | ||||||||
PSBAN | PSBAN | CHAR | 5(0) | |||||||
XFAN1 | Indicator: blocked stock available for planning | XFAN1 | CHAR | 1(0) | XFELD | |||||
GTERM | Scheduling according to purchasing info record or agreement | GTERM | CHAR | 1(0) | XFELD | |||||
REFWK | Reference plant | REFWK | CHAR | 4(0) | WERKS | |||||
VERTR | Start date of order proposals allowed in the past | VERTR | CHAR | 1(0) | XFELD | |||||
NFVBC | Respect restricted-use stock (only for batches) | NFVBC | CHAR | 1(0) | XFELD | |||||
KNTBU | Account assignment category: unknown account assignment | KNTBU | CHAR | 1(0) | KNTTP | |||||
KTDBU | Accnt asgnmt cat. for direct procuremt: unknown accnt asgnmt | KTDBU | CHAR | 1(0) | KNTTP | |||||
KZUMB | Indicator: stock in transfer available for planning | KZUMB | CHAR | 1(0) | XFLAG | |||||
BZTEK | Dec 3,0 data element | PPH_DEC_3_0 | DEC | 3(0) | ||||||
UMTHZ | Dec 3,0 data element | PPH_DEC_3_0 | DEC | 3(0) | ||||||
VWVOR | Dec 2,0 data element | PPH_DEC_2_0 | DEC | 2(0) | ||||||
VWVER | Dec 2,0 data element | PPH_DEC_2_0 | DEC | 2(0) | ||||||
PLAHZ | Dec 3,0 data element | PPH_DEC_3_0 | DEC | 3(0) | ||||||
KZDRB | Indicator: direct procurement/production MRP | KZDRB | CHAR | 1(0) | KZDRB | |||||
FIXPA | Indicator: take firmed planned orders into account | FIXPA | CHAR | 1(0) | XFELD | |||||
FIXFA | Indicator: take production orders into account | FIXFA | CHAR | 1(0) | XFELD | |||||
FIXBA | Indicator: take firmed purchase requisitions into account | FIXBA | CHAR | 1(0) | XFELD | |||||
FIXBE | Ind: take firmed order item/schedule line into account | FIXBE | CHAR | 1(0) | XFELD | |||||
FIXQM | Quality management inspection lot can be given priority | FIXQM | CHAR | 1(0) | XFELD | |||||
FIXLA | Indicator: take shipping notification into account | FIXLA | CHAR | 1(0) | XFELD | |||||
MXBST | Dec 3,0 data element | PPH_DEC_3_0 | DEC | 3(0) | ||||||
BESAL | Determine Explosion Date for BOM and Routing | BESAL | CHAR | 1(0) | BESAL | |||||
PSRES | Item number of the stock transfer reservation | PSRES | NUMC | 4(0) | RSPOS | |||||
CSLID | CIM selection indicator for alternatives | CSLID | CHAR | 2(0) | CSLID | |||||
KASTL | Procedure with sales order BOM/WBS BOM active | KASTL | CHAR | 1(0) | XFLAG | |||||
EXSGT | Do Not Explode Bulk Material Items | EXSGT | CHAR | 1(0) | XFLAG | |||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
FABKL | Factory calendar key | FABKL | CHAR | 2(0) | WFCID | |||||
KKOWK | Indicator: Conditions at plant level | KKOWK | CHAR | 1(0) | KKOWK | |||||
MENGU | Quantity Updating in Material Master Record | MENGU | CHAR | 1(0) | XFELD | |||||
WERTU | Value Updating in Material Master Record | WERTU | CHAR | 1(0) | XFELD | |||||
MFXDT | Field of type DATS | DATS | DATS | 8(0) | DATS | |||||
MFHKZ | Planning time fence set manually (MFXDT) | MFHKZ | CHAR | 1(0) | XFELD | |||||
DISFG | Activate MRP areas at client level | DISFG | CHAR | 1(0) | XFELD | |||||
XFAT1 | Firm Only Schedule Lines Transmitted to Vendor by Purchasing | XFAT1 | CHAR | 1(0) | XFELD | |||||
ALTSL | Method for Selecting Alternative Bills of Material | ALTSL | CHAR | 1(0) | ALTSL | |||||
PICNUM | Supersession chain number | PIC_PICNUM_SUS | CHAR | 40(0) | ALPHA | PIC_PICNUM | PIC_PICNUM | PICNUM | ||
IMATN | FFF class | IMATN | CHAR | 40(0) | MATN1 | MATNR | ||||
MTWZT | Material replenishment lead time | MTWZT | DEC | 3(0) | DEC3 |
Search for further information about these or an SAP related objects