MPE_PMDL_CA_D
Draft table for entity R_PRODUCTIONMODELCOMPONENTTP
MPE_PMDL_CA_D is an SAP database table in S/4HANA. Draft table for entity R_PRODUCTIONMODELCOMPONENTTP. It contains 101 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_ProductionModelComponentDrft | view_entity | from | EXTENSION | Prodn Mod Component - Extension |
| R_ProdnModComponentDraft | view_entity | from | BASIC | Production Model: Component draft |
Fields (101)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | productionmodeluuid | MPE_PMDL_UUID | Prodn Model UUID | |||
| KEY | productionmodelcomponentuuid | CS_GUID | Guid | |||
| billofmaterialcategory | STLTY | BOM category | ||||
| material | MATNR | Material | ||||
| plant | WERKS_D | Plant | ||||
| billofmaterialvariantusage | STLAN | Usage | ||||
| billofmaterial | CS_STLNR | BOM | ||||
| billofoperationstype | PLNTY | Task List Type | ||||
| billofmaterialitemnodenumber | STLKN | Item node | ||||
| validitystartdate | DATUV | Valid From | ||||
| validityenddate | DATUB | to | ||||
| engineeringchangedocument | AENNR | Change Number | ||||
| chgtoengineeringchgdocument | AENRA | Change No. To | ||||
| inheritednodenumberforbomitem | STVKN | Item node | ||||
| inheritednodenumberversionbom | STVKN | Item node | ||||
| bomiteminternalchangecount | CIM_COUNT | Counter | ||||
| billofmaterialcomponent | IDNRK | Component | ||||
| componentdescription | OJTXP | Description | ||||
| billofmaterialitemcategory | POSTP | Item Category | ||||
| billofmaterialitemnumber | CS_SPOSN | Item | ||||
| billofmaterialitemunit | KMPME | Component UoM | ||||
| billofmaterialitemquantity | KMPMG | Quantity | ||||
| isassembly | STLKZ | Assembly | ||||
| issubitem | UPSKZ | Sub-item ID | ||||
| isdeleted | LKENZ | Deletion Ind. | ||||
| identifierbomitem | CS_ITMID | Item ID | ||||
| bomitemsorter | SORTP | Sort String | ||||
| bomitemhasfixedquantity | FMNGE | Fixed Quantity | ||||
| componentscrapinpercent | KAUSF | Component Scrap | ||||
| operationscrapinpercent | AVOAU | Operation Scrap | ||||
| isnetscrap | NETAU | Net Indicator | ||||
| isbulkmaterial | SCHGT | Bulk material | ||||
| isbulkmaterialcomponent | SCHGT | Bulk material | ||||
| materialprovisiontype | BEIKZ | Mat. Prov. Ind. | ||||
| matlcomponentspareparttype | ERSKZ | Spare Part ID | ||||
| bomitemsalesrelevancy | RVREL | Sales | ||||
| isengineeringrelevant | SANKO | Engineering | ||||
| bomitemisplantmaintrelevant | SANIN | Plant maint. | ||||
| isproductionrelevant | SANFE | Production | ||||
| materialcompcostingrelevancy | CS_SANKA | CostingRelevncy | ||||
| bomisrecursive | REKRI | Recursive | ||||
| isbomrecursiveallowed | REKRS | Rec. allowed | ||||
| followupgroup | CS_NFGRP | Follow-up group | ||||
| alternativeitemgroup | CS_ALPGR | AltItemGroup | ||||
| materialiscoproduct | KZKUP | Co-product | ||||
| alternativeitempriority | CS_ALPRF | Priority | ||||
| alternativeitemstrategy | CS_ALPST | Strategy | ||||
| isale | CS_ALEKZ | ALE indicator | ||||
| usageprobabilitypercent | EWAHR | Usage Prob. | ||||
| ispmassemblyrelevant | STKKZ | PM assembly | ||||
| documentiscreatedbycad | CADPO | CAD Indicator | ||||
| dependencyobjectnumber | KNOBJ | Assgmt no. | ||||
| discontinuationgroup | CS_NFEAG | Discont. group | ||||
| leadtimeoffset | NLFZT | Lead-tm offset | ||||
| operationleadtimeoffset | CS_NLFZV | Oper. LT offset | ||||
| opsleadtimeoffsetunit | CS_NLFMV | Oper. LTO unit | ||||
| distrkeycompconsumption | SA_VERTI | Distribution | ||||
| isphantomitem | DUMPS | Phantom item | ||||
| purchasinggroup | EKGRP | Purch. Group | ||||
| deliverydurationindays | LIFZT | Del time (days) | ||||
| creditor | LIFNR | Supplier | ||||
| materialcomponentprice | CPREI | Price | ||||
| currency | WAERS | Currency | ||||
| costelement | SAKTO | Cost element | ||||
| materialgroup | MATKL | Material Group | ||||
| goodsreceiptduration | WEBAZ | GR proc. time | ||||
| purchasingorganization | EKORG | Purchasing Org. | ||||
| preliminarymaterial | MAKTX | Description | ||||
| size1 | ROMS1 | Size 1 | ||||
| size2 | ROMS2 | Size 2 | ||||
| size3 | ROMS3 | Size 3 | ||||
| unitofmeasureforsize1to3 | ROMEI | Size unit | ||||
| quantityvariablesizeitem | ROMEN | VSI Quantity | ||||
| variablesizeitemquantity | PPH_ROANZ | Number of Variable-Size Components | ||||
| variablesizeitemunit | ROAME | VSI unit | ||||
| variablesizecompunitofmeasure | ROAME | VSI unit | ||||
| formulakey | RFORM | VSI Formula | ||||
| bomitemdescription | POTX1 | Item Text | ||||
| bomitemtext2 | POTX2 | Item Text | ||||
| documenttype | DOKAR | Document Type | ||||
| docnumber | DOKNR | Document | ||||
| documentversion | DOKVR | Doc. Version | ||||
| documentpart | DOKTL_D | Document Part | ||||
| prodorderissuelocation | CSLGO | StorageLocation | ||||
| productionsupplyarea | PRVBE | Supply Area | ||||
| explosiontype | CS_DISPO | Explosion type | ||||
| specialprocurementtype | CS_SOBSL | SpecProcurement | ||||
| referencepoint | CN_RFPNT | Reference point | ||||
| bomitemrecordcreationdate | ANDAT | Created On | ||||
| bomitemcreatedbyuser | ANNAM | Created by | ||||
| bomitemlastchangedate | AEDAT | Changed On | ||||
| bomitemlastchangedbyuser | AENAM | Changed By | ||||
| dgtlmockupcharcsvalue | META_VALUE | Value | ||||
| dummy_stpo_incl_eew_ps | STPO_INCL_EEW | Ext. Include | ||||
| draftentitycreationdatetime | SYCH_BDL_DRAFT_CREATED_AT | Created | ||||
| draftentitylastchangedatetime | SYCH_BDL_DRAFT_LAST_CHANGED_AT | Changed | ||||
| draftadministrativedatauuid | SYCH_BDL_DRAFT_ADMIN_UUID | UUID | ||||
| draftentityoperationcode | SYCH_BDL_DRAFT_OPERATION_CODE | Draft - Operation Code | ||||
| hasactiveentity | SYCH_BDL_DRAFT_HASACTIVE | Has active | ||||
| draftfieldchanges | SYCH_BDL_DRAFT_FIELD_CHANGES | Field Changes |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Draft table for entity R_PRODUCTIONMODELCOMPONENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_PMDL_CA_D (
MANDT, -- Client [MANDT]
PRODUCTIONMODELUUID, -- Prodn Model UUID [MPE_PMDL_UUID]
PRODUCTIONMODELCOMPONENTUUID, -- Guid [CS_GUID]
BILLOFMATERIALCATEGORY, -- BOM category [STLTY]
MATERIAL, -- Material [MATNR]
PLANT, -- Plant [WERKS_D]
BILLOFMATERIALVARIANTUSAGE, -- Usage [STLAN]
BILLOFMATERIAL, -- BOM [CS_STLNR]
BILLOFOPERATIONSTYPE, -- Task List Type [PLNTY]
BILLOFMATERIALITEMNODENUMBER, -- Item node [STLKN]
VALIDITYSTARTDATE, -- Valid From [DATUV]
VALIDITYENDDATE, -- to [DATUB]
ENGINEERINGCHANGEDOCUMENT, -- Change Number [AENNR]
CHGTOENGINEERINGCHGDOCUMENT, -- Change No. To [AENRA]
INHERITEDNODENUMBERFORBOMITEM, -- Item node [STVKN]
INHERITEDNODENUMBERVERSIONBOM, -- Item node [STVKN]
BOMITEMINTERNALCHANGECOUNT, -- Counter [CIM_COUNT]
BILLOFMATERIALCOMPONENT, -- Component [IDNRK]
COMPONENTDESCRIPTION, -- Description [OJTXP]
BILLOFMATERIALITEMCATEGORY, -- Item Category [POSTP]
BILLOFMATERIALITEMNUMBER, -- Item [CS_SPOSN]
BILLOFMATERIALITEMUNIT, -- Component UoM [KMPME]
BILLOFMATERIALITEMQUANTITY, -- Quantity [KMPMG]
ISASSEMBLY, -- Assembly [STLKZ]
ISSUBITEM, -- Sub-item ID [UPSKZ]
ISDELETED, -- Deletion Ind. [LKENZ]
IDENTIFIERBOMITEM, -- Item ID [CS_ITMID]
BOMITEMSORTER, -- Sort String [SORTP]
BOMITEMHASFIXEDQUANTITY, -- Fixed Quantity [FMNGE]
COMPONENTSCRAPINPERCENT, -- Component Scrap [KAUSF]
OPERATIONSCRAPINPERCENT, -- Operation Scrap [AVOAU]
ISNETSCRAP, -- Net Indicator [NETAU]
ISBULKMATERIAL, -- Bulk material [SCHGT]
ISBULKMATERIALCOMPONENT, -- Bulk material [SCHGT]
MATERIALPROVISIONTYPE, -- Mat. Prov. Ind. [BEIKZ]
MATLCOMPONENTSPAREPARTTYPE, -- Spare Part ID [ERSKZ]
BOMITEMSALESRELEVANCY, -- Sales [RVREL]
ISENGINEERINGRELEVANT, -- Engineering [SANKO]
BOMITEMISPLANTMAINTRELEVANT, -- Plant maint. [SANIN]
ISPRODUCTIONRELEVANT, -- Production [SANFE]
MATERIALCOMPCOSTINGRELEVANCY, -- CostingRelevncy [CS_SANKA]
BOMISRECURSIVE, -- Recursive [REKRI]
ISBOMRECURSIVEALLOWED, -- Rec. allowed [REKRS]
FOLLOWUPGROUP, -- Follow-up group [CS_NFGRP]
ALTERNATIVEITEMGROUP, -- AltItemGroup [CS_ALPGR]
MATERIALISCOPRODUCT, -- Co-product [KZKUP]
ALTERNATIVEITEMPRIORITY, -- Priority [CS_ALPRF]
ALTERNATIVEITEMSTRATEGY, -- Strategy [CS_ALPST]
ISALE, -- ALE indicator [CS_ALEKZ]
USAGEPROBABILITYPERCENT, -- Usage Prob. [EWAHR]
ISPMASSEMBLYRELEVANT, -- PM assembly [STKKZ]
DOCUMENTISCREATEDBYCAD, -- CAD Indicator [CADPO]
DEPENDENCYOBJECTNUMBER, -- Assgmt no. [KNOBJ]
DISCONTINUATIONGROUP, -- Discont. group [CS_NFEAG]
LEADTIMEOFFSET, -- Lead-tm offset [NLFZT]
OPERATIONLEADTIMEOFFSET, -- Oper. LT offset [CS_NLFZV]
OPSLEADTIMEOFFSETUNIT, -- Oper. LTO unit [CS_NLFMV]
DISTRKEYCOMPCONSUMPTION, -- Distribution [SA_VERTI]
ISPHANTOMITEM, -- Phantom item [DUMPS]
PURCHASINGGROUP, -- Purch. Group [EKGRP]
DELIVERYDURATIONINDAYS, -- Del time (days) [LIFZT]
CREDITOR, -- Supplier [LIFNR]
MATERIALCOMPONENTPRICE, -- Price [CPREI]
CURRENCY, -- Currency [WAERS]
COSTELEMENT, -- Cost element [SAKTO]
MATERIALGROUP, -- Material Group [MATKL]
GOODSRECEIPTDURATION, -- GR proc. time [WEBAZ]
PURCHASINGORGANIZATION, -- Purchasing Org. [EKORG]
PRELIMINARYMATERIAL, -- Description [MAKTX]
SIZE1, -- Size 1 [ROMS1]
SIZE2, -- Size 2 [ROMS2]
SIZE3, -- Size 3 [ROMS3]
UNITOFMEASUREFORSIZE1TO3, -- Size unit [ROMEI]
QUANTITYVARIABLESIZEITEM, -- VSI Quantity [ROMEN]
VARIABLESIZEITEMQUANTITY, -- Number of Variable-Size Components [PPH_ROANZ]
VARIABLESIZEITEMUNIT, -- VSI unit [ROAME]
VARIABLESIZECOMPUNITOFMEASURE, -- VSI unit [ROAME]
FORMULAKEY, -- VSI Formula [RFORM]
BOMITEMDESCRIPTION, -- Item Text [POTX1]
BOMITEMTEXT2, -- Item Text [POTX2]
DOCUMENTTYPE, -- Document Type [DOKAR]
DOCNUMBER, -- Document [DOKNR]
DOCUMENTVERSION, -- Doc. Version [DOKVR]
DOCUMENTPART, -- Document Part [DOKTL_D]
PRODORDERISSUELOCATION, -- StorageLocation [CSLGO]
PRODUCTIONSUPPLYAREA, -- Supply Area [PRVBE]
EXPLOSIONTYPE, -- Explosion type [CS_DISPO]
SPECIALPROCUREMENTTYPE, -- SpecProcurement [CS_SOBSL]
REFERENCEPOINT, -- Reference point [CN_RFPNT]
BOMITEMRECORDCREATIONDATE, -- Created On [ANDAT]
BOMITEMCREATEDBYUSER, -- Created by [ANNAM]
BOMITEMLASTCHANGEDATE, -- Changed On [AEDAT]
BOMITEMLASTCHANGEDBYUSER, -- Changed By [AENAM]
DGTLMOCKUPCHARCSVALUE, -- Value [META_VALUE]
DUMMY_STPO_INCL_EEW_PS, -- Ext. Include [STPO_INCL_EEW]
DRAFTENTITYCREATIONDATETIME, -- Created [SYCH_BDL_DRAFT_CREATED_AT]
DRAFTENTITYLASTCHANGEDATETIME, -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
DRAFTADMINISTRATIVEDATAUUID, -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
DRAFTENTITYOPERATIONCODE, -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
HASACTIVEENTITY, -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
DRAFTFIELDCHANGES, -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
PRIMARY KEY (MANDT, PRODUCTIONMODELUUID, PRODUCTIONMODELCOMPONENTUUID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA