I_ProductionModel

DDL: I_PRODUCTIONMODEL Type: view_entity COMPOSITE
39 Fields 4 Data Sources 10 Associations

Production Model Header

I_ProductionModel is a Composite CDS View that provides data about "Production Model Header" in SAP S/4HANA. It reads from 4 data sources (I_BillOfOperationsChangeState, I_BillOfOperations, I_ProdnModBOOVersBOMAssgmt, I_ProductionModelBasic) and exposes 39 fields with key fields ProductionModelUUID, BillOfOperationsVersion. It has 10 associations to related views.

Data Sources (4)

SourceAliasJoin Type
I_BillOfOperationsChangeState BooChangeState inner
I_BillOfOperations BooMainHeader inner
I_ProdnModBOOVersBOMAssgmt BooVersionBOMAssgmt inner
I_ProductionModelBasic ProductionModel from

Associations (10)

CardinalityTargetAliasCondition
[0..*] I_ProductionModelComponent _HeaderComponent $projection.ProductionModelUUID = _HeaderComponent.ProductionModelUUID and $projection.BillOfOperationsVersion = _HeaderComponent.BillOfOperationsVersion
[0..*] I_ProductionModelOperation _Operation $projection.ProductionModelUUID = _Operation.ProductionModelUUID and $projection.BillOfOperationsVersion = _Operation.BillOfOperationsVersion
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant and _Plant.Language = $session.system_language
[0..1] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language
[0..1] I_VersionStatus _BOMVersStatusText $projection.BOMVersionStatus = _BOMVersStatusText.BOMVersionStatus and _BOMVersStatusText.Language = $session.system_language
[0..1] I_BOOVersionStatusText _BOOVersionStatusText $projection.BillOfOperationsVersionStatus = _BOOVersionStatusText.BillOfOperationsVersionStatus and _BOOVersionStatusText.Language = $session.system_language
[0..1] I_BillOfMaterialUsage _BOMUsageText $projection.BillOfMaterialVariantUsage = _BOMUsageText.BillOfMaterialVariantUsage and _BOMUsageText.Language = $session.system_language
[0..1] I_BillOfOperationsTypeText _BOOTypeText $projection.BillOfOperationsType = _BOOTypeText.BillOfOperationsType and _BOOTypeText.Language = $session.system_language
[0..1] I_SalesDocumentItem _SalesDocumentItemText $projection.SalesOrder = _SalesDocumentItemText.SalesDocument and $projection.SalesOrderItem = _SalesDocumentItemText.SalesDocumentItem
[0..1] I_BOOBusinessProcessText _BOOBusinessProcessText $projection.BillOfOpsBusinessProcess = _BOOBusinessProcessText.BillOfOpsBusinessProcess and _BOOBusinessProcessText.Language = $session.system_language

Annotations (7)

NameValueLevelField
EndUserText.label Production Model Header view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID I_ProductionModelBasic ProductionModelUUID Prodn Model UUID
KEY BillOfOperationsVersion I_ProdnModBOOVersBOMAssgmt BillOfOperationsVersion Routing Version
ProductionModelProcessType I_ProductionModelBasic ProductionModelProcessType Type of Data
ProdnModComplexAssemblyType I_ProductionModelBasic ProdnModComplexAssemblyType Prod. Model Type
Material I_ProductionModelBasic Material Vehicle Model
BillOfMaterial I_ProductionModelBasic BillOfMaterial BOM
BillOfMaterialVariant I_ProductionModelBasic BillOfMaterialVariant AlternativeBOM
BillOfMaterialCategory I_ProductionModelBasic BillOfMaterialCategory BOM category
BillOfMaterialVariantUsage I_ProductionModelBasic BillOfMaterialVariantUsage Usage
BillOfMaterialVersion I_ProdnModBOOVersBOMAssgmt BillOfMaterialVersion BOM Version
BOMVersionStatus I_ProdnModBOOVersBOMAssgmt BOMVersionStatus BOM Version Status
Plant I_ProductionModelBasic Plant Valuation Area
BillOfOperationsType I_ProductionModelBasic BillOfOperationsType Task List Type
BillOfOperationsGroup I_ProductionModelBasic BillOfOperationsGroup Group
BillOfOperationsVariant I_ProductionModelBasic BillOfOperationsVariant Group Counter
SalesOrder I_ProductionModelBasic SalesOrder SD Document
SalesOrderItem I_ProductionModelBasic SalesOrderItem Sales Order Item
BillOfOperationsVersionStatus I_ProdnModBOOVersBOMAssgmt BillOfOperationsVersionStatus Workflow Status
IsLatestBOOVersion I_ProdnModBOOVersBOMAssgmt IsLatestBOOVersion Last Rel. Vers.
ProdnModelCreationDateTime I_ProductionModelBasic ProdnModelCreationDateTime Variant created on
ProductionModelCreatedByUser I_ProductionModelBasic ProductionModelCreatedByUser Version Created By
ProdnModelChangedDateTime I_ProductionModelBasic ProdnModelChangedDateTime Variant Changed on
ProductionModelChangedByUser I_ProductionModelBasic ProductionModelChangedByUser User Name
ChangeNumber I_ProdnModBOOVersBOMAssgmt ChangeNumber Change Number
BOOVersionChangeNumber I_ProdnModBOOVersBOMAssgmt BOOVersionChangeNumber Change Number
RoutingIsReworkRouting I_BillOfOperations RoutingIsReworkRouting Rework Routing
ProdnProcgIsFlexible I_BillOfOperations ProdnProcgIsFlexible Flexible
BillOfOperationIsExecutedInMES I_BillOfOperations BillOfOperationIsExecutedInMES SAP ME
BOMIsConfigurable I_ProdnModBOOVersBOMAssgmt BOMIsConfigurable ConfigurableBOM
_HeaderComponent _HeaderComponent
_Operation _Operation
_Plant _Plant
_MaterialText _MaterialText
_BOOVersionStatusText _BOOVersionStatusText
_BOMVersStatusText _BOMVersStatusText
_BOMUsageText _BOMUsageText
_BOOTypeText _BOOTypeText
_SalesDocumentItemText _SalesDocumentItemText
_BOOBusinessProcessText _BOOBusinessProcessText

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_ProductionModel.
-- 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_ProductionModel AS
SELECT
  ProductionModel.ProductionModelUUID AS ProductionModelUUID,
  BooVersionBOMAssgmt.BillOfOperationsVersion AS BillOfOperationsVersion,
  ProductionModel.ProductionModelProcessType AS ProductionModelProcessType,
  ProductionModel.ProdnModComplexAssemblyType AS ProdnModComplexAssemblyType,
  ProductionModel.Material AS Material,
  ProductionModel.BillOfMaterial AS BillOfMaterial,
  ProductionModel.BillOfMaterialVariant AS BillOfMaterialVariant,
  ProductionModel.BillOfMaterialCategory AS BillOfMaterialCategory,
  ProductionModel.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  BooVersionBOMAssgmt.BillOfMaterialVersion AS BillOfMaterialVersion,
  BooVersionBOMAssgmt.BOMVersionStatus AS BOMVersionStatus,
  ProductionModel.Plant AS Plant,
  ProductionModel.BillOfOperationsType AS BillOfOperationsType,
  ProductionModel.BillOfOperationsGroup AS BillOfOperationsGroup,
  ProductionModel.BillOfOperationsVariant AS BillOfOperationsVariant,
  ProductionModel.SalesOrder AS SalesOrder,
  ProductionModel.SalesOrderItem AS SalesOrderItem,
  BooVersionBOMAssgmt.BillOfOperationsVersionStatus AS BillOfOperationsVersionStatus,
  BooVersionBOMAssgmt.IsLatestBOOVersion AS IsLatestBOOVersion,
  ProductionModel.ProdnModelCreationDateTime AS ProdnModelCreationDateTime,
  ProductionModel.ProductionModelCreatedByUser AS ProductionModelCreatedByUser,
  ProductionModel.ProdnModelChangedDateTime AS ProdnModelChangedDateTime,
  ProductionModel.ProductionModelChangedByUser AS ProductionModelChangedByUser,
  BooVersionBOMAssgmt.ChangeNumber AS ChangeNumber,
  BooVersionBOMAssgmt.BOOVersionChangeNumber AS BOOVersionChangeNumber,
  BooMainHeader.RoutingIsReworkRouting AS RoutingIsReworkRouting,
  BooMainHeader.ProdnProcgIsFlexible AS ProdnProcgIsFlexible,
  BooMainHeader.BillOfOperationIsExecutedInMES AS BillOfOperationIsExecutedInMES,
  BooVersionBOMAssgmt.BOMIsConfigurable AS BOMIsConfigurable
FROM I_ProductionModelBasic AS ProductionModel
INNER JOIN I_ProdnModBOOVersBOMAssgmt AS BooVersionBOMAssgmt ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillOfOperations AS BooMainHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillOfOperationsChangeState AS BooChangeState ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductionModelComponent AS _HeaderComponent ON ProductionModelUUID = _HeaderComponent.ProductionModelUUID AND BillOfOperationsVersion = _HeaderComponent.BillOfOperationsVersion  -- association [0..*]
LEFT OUTER JOIN I_ProductionModelOperation AS _Operation ON ProductionModelUUID = _Operation.ProductionModelUUID AND BillOfOperationsVersion = _Operation.BillOfOperationsVersion  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant AND _Plant.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_VersionStatus AS _BOMVersStatusText ON BOMVersionStatus = _BOMVersStatusText.BOMVersionStatus AND _BOMVersStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BOOVersionStatusText AS _BOOVersionStatusText ON BillOfOperationsVersionStatus = _BOOVersionStatusText.BillOfOperationsVersionStatus AND _BOOVersionStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsage AS _BOMUsageText ON BillOfMaterialVariantUsage = _BOMUsageText.BillOfMaterialVariantUsage AND _BOMUsageText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsTypeText AS _BOOTypeText ON BillOfOperationsType = _BOOTypeText.BillOfOperationsType AND _BOOTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItemText ON SalesOrder = _SalesDocumentItemText.SalesDocument AND SalesOrderItem = _SalesDocumentItemText.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_BOOBusinessProcessText AS _BOOBusinessProcessText ON BillOfOpsBusinessProcess = _BOOBusinessProcessText.BillOfOpsBusinessProcess AND _BOOBusinessProcessText.Language = $session.system_language  -- association [0..1]
;

Learn More