C_MaterialProductionModelTP

DDL: C_MATERIALPRODUCTIONMODELTP Type: view_entity CONSUMPTION
34 Fields 1 Data Sources 2 Associations 1 OData Services

Material Production Model

C_MaterialProductionModelTP is a Consumption CDS View that provides data about "Material Production Model" in SAP S/4HANA. It reads from 1 data source (R_ProductionModelTP) and exposes 34 fields with key fields ProductionModelUUID, BillOfOperationsVersion. It has 2 associations to related views. It is exposed through 1 OData service (UI_MATL_PRODNMODEL_MANAGE).

Data Sources (1)

SourceAliasJoin Type
R_ProductionModelTP R_ProductionModelTP projection

Associations (2)

CardinalityTargetAliasCondition
[1..*] C_ProdnModRefChangeRecord _ReferenceChangeRecord $projection.ProductionModelUUID = _ReferenceChangeRecord.ProductionModelUUID and $projection.BillOfOperationsVersion = _ReferenceChangeRecord.BillOfOperationsVersion
[0..*] C_ProdnModInstcAggrgd _ProdnModInstcAggrgd $projection.ProductionModelUUID = _ProdnModInstcAggrgd.ProductionModelUUID and $projection.BillOfOperationsVersion = _ProdnModInstcAggrgd.BillOfOperationsVersion

Annotations (15)

NameValueLevelField
EndUserText.label Material Production Model view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
Search.searchable true view
UI.createHidden true view
UI.deleteHidden true view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.typeName Material Production Model view
UI.headerInfo.typeNamePlural Material Production Models view
UI.headerInfo.title.value MaterialName view

OData Services (1)

ServiceBindingVersionContractRelease
UI_MATL_PRODNMODEL_MANAGE UI_MATL_PRODNMODEL_MANAGE V4 C1 NOT_RELEASED

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID ProductionModelUUID Prodn Model UUID
KEY BillOfOperationsVersion BillOfOperationsVersion Routing Version
ProductionModelProcessType ProductionModelProcessType
ProdnModComplexAssemblyType ProdnModComplexAssemblyType
Material Material Vehicle Model
MaterialName _MaterialText MaterialName Material Description
BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
BillOfMaterialCategory BillOfMaterialCategory BOM category
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
BillOfMaterialVersion BillOfMaterialVersion BOM Version
BOMVersionStatus BOMVersionStatus BOM Version Status
BOMVersionStatusDescription _BOMVersStatusText BOMVersionStatusDescription Short Description
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsVariant BillOfOperationsVariant Group Counter
BillOfOperationsVersionStatus BillOfOperationsVersionStatus
ProdnModelVersionIsLatest ProdnModelVersionIsLatest
ProdnModelVersionIsActive ProdnModelVersionIsActive
IsLatestBOOVersion IsLatestBOOVersion
BOOVersionStatusText _BOOVersionStatusText BOOVersionStatusText
ProdnModelCreationDateTime ProdnModelCreationDateTime
ProductionModelCreatedByUser ProductionModelCreatedByUser
ProdnModelChangedDateTime ProdnModelChangedDateTime
ProductionModelChangedByUser ProductionModelChangedByUser
BillOfMaterial BillOfMaterial BOM
BillOfMaterialVariantUsageDesc _BOMUsageText BillOfMaterialVariantUsageDesc
BillOfOperationsTypeName _BOOTypeText BillOfOperationsTypeName
virtualPhysicalDocumentsdok_phid
char60
virtualChangeRecordplmbcr_id
_ProdnModInstcAggrgd _ProdnModInstcAggrgd
_ReferenceChangeRecord _ReferenceChangeRecord

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 C_MaterialProductionModelTP.
-- 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 C_MaterialProductionModelTP AS
SELECT
  ProductionModelUUID,
  BillOfOperationsVersion,
  ProductionModelProcessType,
  ProdnModComplexAssemblyType,
  Material,
  _MaterialText.MaterialName AS MaterialName,
  BillOfMaterialVariant,
  BillOfMaterialCategory,
  BillOfMaterialVariantUsage,
  BillOfMaterialVersion,
  BOMVersionStatus,
  _BOMVersStatusText.BOMVersionStatusDescription AS BOMVersionStatusDescription,
  Plant,
  _Plant.PlantName AS PlantName,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsVersionStatus,
  ProdnModelVersionIsLatest,
  ProdnModelVersionIsActive,
  IsLatestBOOVersion,
  _BOOVersionStatusText.BOOVersionStatusText AS BOOVersionStatusText,
  ProdnModelCreationDateTime,
  ProductionModelCreatedByUser,
  ProdnModelChangedDateTime,
  ProductionModelChangedByUser,
  BillOfMaterial,
  _BOMUsageText.BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  _BOOTypeText.BillOfOperationsTypeName AS BillOfOperationsTypeName,
  virtual PhysicalDocument : sdok_phid AS virtualPhysicalDocumentsdok_phid,
  virtual ProdnModProcessingStateName : abap.char( 60 ) AS char60,
  virtual ChangeRecord : /plmb/cr_id AS virtualChangeRecordplmbcr_id
FROM R_ProductionModelTP
LEFT OUTER JOIN C_ProdnModRefChangeRecord AS _ReferenceChangeRecord ON ProductionModelUUID = _ReferenceChangeRecord.ProductionModelUUID AND BillOfOperationsVersion = _ReferenceChangeRecord.BillOfOperationsVersion  -- association [1..*]
LEFT OUTER JOIN C_ProdnModInstcAggrgd AS _ProdnModInstcAggrgd ON ProductionModelUUID = _ProdnModInstcAggrgd.ProductionModelUUID AND BillOfOperationsVersion = _ProdnModInstcAggrgd.BillOfOperationsVersion  -- association [0..*]
;

Learn More