R_ProductionModelTP

DDL: R_PRODUCTIONMODELTP Type: view_entity TRANSACTIONAL
34 Fields 1 Data Sources 2 Associations

Production Model Header

R_ProductionModelTP is a Transactional CDS View that provides data about "Production Model Header" in SAP S/4HANA. It reads from 1 data source (I_ProductionModel) and exposes 34 fields with key fields ProductionModelUUID, BillOfOperationsVersion. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProductionModel I_ProductionModel from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_ProductionModelComponentTP _HeaderComponent
[0..*] R_ProductionModelOperationTP _Operation

Annotations (8)

NameValueLevelField
ObjectModel.sapObjectNodeType.name ProductionModel view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Production Model Header view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID ProductionModelUUID Prodn Model UUID
KEY BillOfOperationsVersion BillOfOperationsVersion Routing Version
ProductionModelProcessType ProductionModelProcessType
ProdnModComplexAssemblyType ProdnModComplexAssemblyType
Material Material Vehicle Model
BillOfMaterial BillOfMaterial BOM
BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
BillOfMaterialCategory BillOfMaterialCategory BOM category
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
BillOfMaterialVersion BillOfMaterialVersion BOM Version
BOMVersionStatus BOMVersionStatus BOM Version Status
Plant Plant Valuation Area
BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsVariant BillOfOperationsVariant Group Counter
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
BillOfOperationsVersionStatus BillOfOperationsVersionStatus
ProdnModelVersionIsLatest ProdnModelVersionIsLatest
ProdnModelVersionIsActive ProdnModelVersionIsActive
IsLatestBOOVersion IsLatestBOOVersion
ProdnModelCreationDateTime ProdnModelCreationDateTime
ProductionModelCreatedByUser ProductionModelCreatedByUser
ProdnModelChangedDateTime ProdnModelChangedDateTime
ProductionModelChangedByUser ProductionModelChangedByUser
_HeaderComponent _HeaderComponent
_Operation _Operation
_Plant _Plant
_MaterialText _MaterialText
_BOOVersionStatusText _BOOVersionStatusText
_BOMVersStatusText _BOMVersStatusText
_BOMUsageText _BOMUsageText
_BOOTypeText _BOOTypeText
_SalesDocumentItemText _SalesDocumentItemText

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 R_ProductionModelTP.
-- 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 R_ProductionModelTP AS
SELECT
  ProductionModelUUID,
  BillOfOperationsVersion,
  ProductionModelProcessType,
  ProdnModComplexAssemblyType,
  Material,
  BillOfMaterial,
  BillOfMaterialVariant,
  BillOfMaterialCategory,
  BillOfMaterialVariantUsage,
  BillOfMaterialVersion,
  BOMVersionStatus,
  Plant,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  SalesOrder,
  SalesOrderItem,
  BillOfOperationsVersionStatus,
  ProdnModelVersionIsLatest,
  ProdnModelVersionIsActive,
  IsLatestBOOVersion,
  ProdnModelCreationDateTime,
  ProductionModelCreatedByUser,
  ProdnModelChangedDateTime,
  ProductionModelChangedByUser
FROM I_ProductionModel
LEFT OUTER JOIN R_ProductionModelComponentTP AS _HeaderComponent ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ProductionModelOperationTP AS _Operation ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More