MPE_PMDL_CA_D

Transparent Table Application Table
95 Fields 2 CDS Views

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 95 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_ProductionModelComponentDrft view_entity from EXTENSION Prodn Mod Component - Extension
R_ProdnModComponentDraft view_entity from BASIC Production Model: Component draft

Fields (95)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY productionmodeluuid mpe_pmdl_uuid Prodn Model UUID
KEY billofoperationsversion plnversn Routing Version
KEY productionmodelcomponentuuid cs_guid Guid
billofmaterialcategory stlty BOM category
material matnr40 Material
plant werks_d Plant
billofmaterialvariantusage stlan Usage
billofmaterial cs_stlnr BOM
billofoperationstype abap.char
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 maktx Description
billofmaterialitemcategory postp Item Category
billofmaterialitemnumber cs_sposn Item
billofmaterialitemunit kmpme Component UoM
billofmaterialitemquantity abap.quan
isassembly xfeld Checkbox
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 xfeld Checkbox
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 abap.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
billofmaterialitemobjecttype objty Object Type
bomitemrecordcreationdate andat Created On
bomitemcreatedbyuser annam Created by
bomitemlastchangedate aedat Changed On
bomitemlastchangedbyuser aenam Changed By

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]
    BILLOFOPERATIONSVERSION,        -- Routing Version [plnversn]
    PRODUCTIONMODELCOMPONENTUUID,   -- Guid [cs_guid]
    BILLOFMATERIALCATEGORY,         -- BOM category [stlty]
    MATERIAL,                       -- Material [matnr40]
    PLANT,                          -- Plant [werks_d]
    BILLOFMATERIALVARIANTUSAGE,     -- Usage [stlan]
    BILLOFMATERIAL,                 -- BOM [cs_stlnr]
    BILLOFOPERATIONSTYPE,           -- abap.char
    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 [maktx]
    BILLOFMATERIALITEMCATEGORY,     -- Item Category [postp]
    BILLOFMATERIALITEMNUMBER,       -- Item [cs_sposn]
    BILLOFMATERIALITEMUNIT,         -- Component UoM [kmpme]
    BILLOFMATERIALITEMQUANTITY,     -- abap.quan
    ISASSEMBLY,                     -- Checkbox [xfeld]
    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,                  -- Checkbox [xfeld]
    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,  -- abap.unit
    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]
    BILLOFMATERIALITEMOBJECTTYPE,   -- Object Type [objty]
    BOMITEMRECORDCREATIONDATE,      -- Created On [andat]
    BOMITEMCREATEDBYUSER,           -- Created by [annam]
    BOMITEMLASTCHANGEDATE,          -- Changed On [aedat]
    BOMITEMLASTCHANGEDBYUSER,       -- Changed By [aenam]
    PRIMARY KEY (MANDT, PRODUCTIONMODELUUID, BILLOFOPERATIONSVERSION, PRODUCTIONMODELCOMPONENTUUID)
);

Learn More