I_ProductionModelBasic

DDL: I_PRODUCTIONMODELBASIC Type: view_entity BASIC
18 Fields 1 Data Sources

Production Model Header

I_ProductionModelBasic is a Basic CDS View that provides data about "Production Model Header" in SAP S/4HANA. It reads from 1 data source (mpe_pmdl_hdr) and exposes 18 fields with key field ProductionModelUUID.

Data Sources (1)

SourceAliasJoin Type
mpe_pmdl_hdr ProductionModel from

Annotations (7)

NameValueLevelField
EndUserText.label Production Model Header view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID mpe_pmdl_hdr prodn_model_uuid Prodn Model UUID
ProductionModelProcessType mpe_pmdl_hdr process_type Type of Data
ProdnModComplexAssemblyType mpe_pmdl_hdr prodn_model_type Prod. Model Type
Material mpe_pmdl_hdr material Vehicle Model
BillOfMaterial
BillOfMaterialVariant mpe_pmdl_hdr stlal AlternativeBOM
BillOfMaterialCategory mpe_pmdl_hdr stlty Single-Character Flag
BillOfMaterialVariantUsage mpe_pmdl_hdr stlan Usage
Plant mpe_pmdl_hdr werks Receiving Plant
BillOfOperationsType
BillOfOperationsGroup mpe_pmdl_hdr plnnr Task List Group
BillOfOperationsVariant mpe_pmdl_hdr plnal Referenced BOO Variant
SalesOrder mpe_pmdl_hdr salesorder SD Document
SalesOrderItem mpe_pmdl_hdr salesorder_item Item
ProdnModelCreationDateTime mpe_pmdl_hdr created_on Variant created on
ProductionModelCreatedByUser mpe_pmdl_hdr created_by Version Created By
ProdnModelChangedDateTime mpe_pmdl_hdr changed_on Variant Changed on
ProductionModelChangedByUser mpe_pmdl_hdr changed_by User Name

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ProductionModelBasic.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ProductionModelBasic AS
SELECT
  ProductionModel.prodn_model_uuid AS ProductionModelUUID,
  ProductionModel.process_type AS ProductionModelProcessType,
  ProductionModel.prodn_model_type AS ProdnModComplexAssemblyType,
  ProductionModel.material AS Material,
  cast( ProductionModel.stlnr as cs_stlnr ) AS BillOfMaterial,
  ProductionModel.stlal AS BillOfMaterialVariant,
  ProductionModel.stlty AS BillOfMaterialCategory,
  ProductionModel.stlan AS BillOfMaterialVariantUsage,
  ProductionModel.werks AS Plant,
  cast( ProductionModel.plnty as abap.char( 1 ) ) AS BillOfOperationsType,
  ProductionModel.plnnr AS BillOfOperationsGroup,
  ProductionModel.plnal AS BillOfOperationsVariant,
  ProductionModel.salesorder AS SalesOrder,
  ProductionModel.salesorder_item AS SalesOrderItem,
  ProductionModel.created_on AS ProdnModelCreationDateTime,
  ProductionModel.created_by AS ProductionModelCreatedByUser,
  ProductionModel.changed_on AS ProdnModelChangedDateTime,
  ProductionModel.changed_by AS ProductionModelChangedByUser
FROM mpe_pmdl_hdr AS ProductionModel
;

Learn More