I_ProductionModelComponent

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_ProductionModelComponent.
-- 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_ProductionModelComponent AS
SELECT
  Header.ProductionModelUUID AS ProductionModelUUID,
  Version.BillOfOperationsVersion AS BillOfOperationsVersion,
  BOMItem.ProductionModelComponentUUID AS ProductionModelComponentUUID,
  BOMItem.BillOfMaterialCategory AS BillOfMaterialCategory,
  cast( BOMItem.BillOfMaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  Header.Material AS Material,
  Header.Plant AS Plant,
  Header.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  Header.BillOfMaterialVariant AS BillOfMaterialVariant,
  Version.BillOfMaterialVersion AS BillOfMaterialVersion,
  Header.BillOfOperationsGroup AS BillOfOperationsGroup,
  Header.BillOfOperationsType AS BillOfOperationsType,
  Header.BillOfOperationsVariant AS BillOfOperationsVariant,
  BOMItem.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  BOMItem.ValidityStartDate AS ValidityStartDate,
  BOMItem.ValidityEndDate AS ValidityEndDate,
  BOMItem.EngineeringChangeDocument AS EngineeringChangeDocument,
  BOMItem.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  BOMItem.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  BOMItem.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  BOMItem.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  BOMItem.BillOfMaterialComponent AS BillOfMaterialComponent,
  BOMItem.ComponentDescription AS ComponentDescription,
  BOMItem.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  cast( BOMItem.BillOfMaterialItemNumber as cs_sposn preserving type ) AS BillOfMaterialItemNumber,
  BOMItem.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  BOMItem.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  BOMItem.IsAssembly AS IsAssembly,
  BOMItem.IsSubItem AS IsSubItem,
  BOMItem.IsDeleted AS IsDeleted,
  BOMItem.IdentifierBOMItem AS IdentifierBOMItem,
  BOMItem.BOMItemSorter AS BOMItemSorter,
  BOMItem.BOMItemHasFixedQuantity AS BOMItemHasFixedQuantity,
  BOMItem.ComponentScrapInPercent AS ComponentScrapInPercent,
  BOMItem.OperationScrapInPercent AS OperationScrapInPercent,
  BOMItem.IsNetScrap AS IsNetScrap,
  BOMItem.IsBulkMaterial AS IsBulkMaterial,
  _MaterialPlant.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  _MaterialPlant.EffectiveOutDate AS EffectiveOutDate,
  cast( _MaterialPlant.FollowUpProduct as mpe_follow_up_material ) AS FollowUpProduct,
  BOMItem.IsMaterialProvision AS MaterialProvisionType,
  BOMItem.BOMItemIsSparePart AS MatlComponentSparePartType,
  BOMItem.BOMItemIsSalesRelevant AS BOMItemSalesRelevancy,
  BOMItem.IsEngineeringRelevant AS IsEngineeringRelevant,
  BOMItem.BOMItemIsPlantMaintRelevant AS BOMItemIsPlantMaintRelevant,
  BOMItem.IsProductionRelevant AS IsProductionRelevant,
  BOMItem.BOMItemIsCostingRelevant AS MaterialCompCostingRelevancy,
  BOMItem.BOMIsRecursive AS BOMIsRecursive,
  BOMItem.IsBOMRecursiveAllowed AS IsBOMRecursiveAllowed,
  BOMItem.FollowUpGroup AS FollowUpGroup,
  BOMItem.AlternativeItemGroup AS AlternativeItemGroup,
  BOMItem.MaterialIsCoProduct AS MaterialIsCoProduct,
  BOMItem.AlternativeItemPriority AS AlternativeItemPriority,
  BOMItem.AlternativeItemStrategy AS AlternativeItemStrategy,
  BOMItem.IsALE AS IsALE,
  BOMItem.UsageProbabilityPercent AS UsageProbabilityPercent,
  BOMItem.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  BOMItem.DependencyObjectNumber AS DependencyObjectNumber,
  BOMItem.DiscontinuationGroup AS DiscontinuationGroup,
  BOMItem.LeadTimeOffset AS LeadTimeOffset,
  BOMItem.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  BOMItem.OpsLeadTimeOffsetUnit AS OpsLeadTimeOffsetUnit,
  BOMItem.DistrKeyCompConsumption AS DistrKeyCompConsumption,
  BOMItem.IsPhantomItem AS IsPhantomItem,
  BOMItem.PurchasingGroup AS PurchasingGroup,
  BOMItem.DeliveryDurationInDays AS DeliveryDurationInDays,
  BOMItem.Creditor AS Creditor,
  BOMItem.MaterialComponentPrice AS MaterialComponentPrice,
  BOMItem.Currency AS Currency,
  BOMItem.CostElement AS CostElement,
  BOMItem.MaterialGroup AS MaterialGroup,
  BOMItem.GoodsReceiptDuration AS GoodsReceiptDuration,
  BOMItem.PurchasingOrganization AS PurchasingOrganization,
  BOMItem.Size1 AS Size1,
  BOMItem.Size2 AS Size2,
  BOMItem.Size3 AS Size3,
  BOMItem.UnitOfMeasureForSize1To3 AS UnitOfMeasureForSize1To3,
  BOMItem.QuantityVariableSizeItem AS QuantityVariableSizeItem,
  cast(BOMItem.NumberOfVariableSizeItem as pph_roanz preserving type) AS VariableSizeItemQuantity,
  BOMItem.UnitOfMeasureForVarSizeItem AS VariableSizeItemUnit,
  BOMItem.FormulaKey AS FormulaKey,
  BOMItem.VariableSizeCompUnitOfMeasure AS VariableSizeCompUnitOfMeasure,
  BOMItem.BOMItemDescription AS BOMItemDescription,
  BOMItem.BOMItemText2 AS BOMItemText2,
  BOMItem.DocumentType AS DocumentType,
  BOMItem.DocNumber AS DocNumber,
  BOMItem.DocumentVersion AS DocumentVersion,
  BOMItem.DocumentPart AS DocumentPart,
  BOMItem.ProdOrderIssueLocation AS ProdOrderIssueLocation,
  BOMItem.ProductionSupplyArea AS ProductionSupplyArea,
  BOMItem.ExplosionType AS ExplosionType,
  BOMItem.SpecialProcurementType AS SpecialProcurementType,
  BOMItem.ReferencePoint AS ReferencePoint,
  BOMItem.PreliminaryMaterial AS PreliminaryMaterial,
  BOMItem.IsPMAssemblyRelevant AS IsPMAssemblyRelevant,
  BOMItem.BillOfMaterialItemObjectType AS BillOfMaterialItemObjectType,
  BOMItem.BOMItemRecordCreationDate AS BOMItemRecordCreationDate,
  BOMItem.BOMItemCreatedByUser AS BOMItemCreatedByUser,
  BOMItem.BOMItemLastChangeDate AS BOMItemLastChangeDate,
  BOMItem.BOMItemLastChangedByUser AS BOMItemLastChangedByUser,
  BOMItem.BOMItemIsAlternativeItem AS BOMItemIsAlternativeItem
FROM I_ProductionModelBasic AS Header
INNER JOIN I_BOOVersionBOMAssignment AS Version ON /* join condition not captured in parsed metadata */
INNER JOIN P_ProductionModelBOMItem AS BOMItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON _MaterialText.Material = BOMItem.BillOfMaterialComponent AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BomItemCategoryText AS _BOMItemCategoryText ON BillOfMaterialItemCategory = _BOMItemCategoryText.BillOfMaterialItemCategory AND _BOMItemCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MRPQuantityDistrKeyText AS _DistrKeyText ON Plant = _DistrKeyText.Plant AND DistrKeyCompConsumption = _DistrKeyText.QuantityDistributionKey AND _DistrKeyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ExplosionTypeVH AS _ExplosionTypeText ON ExplosionType = _ExplosionTypeText.ExplosionType  -- association [0..1]
LEFT OUTER JOIN I_SpecialProcurementType AS _SpecialProcTypeText ON Plant = _SpecialProcTypeText.Plant AND SpecialProcurementType = _SpecialProcTypeText.SpecialProcurementType  -- association [0..1]
LEFT OUTER JOIN I_AltItemStrategyVH AS _AltItemStrategyText ON AlternativeItemStrategy = _AltItemStrategyText.AlternativeItemStrategy AND _AltItemStrategyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ReferencePointVH AS _ReferencePointText ON ReferencePoint = _ReferencePointText.ReferencePoint  -- association [0..1]
LEFT OUTER JOIN I_BOMItemCostingRelevant AS _CostingRelevantText ON MaterialCompCostingRelevancy = _CostingRelevantText.BOMItemIsCostingRelevant  -- association [0..1]
LEFT OUTER JOIN I_MatProvisionIndicatorVH AS _MatProvisionIndText ON MaterialProvisionType = _MatProvisionIndText.IsMaterialProvision  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _IssueLocationText ON Plant = _IssueLocationText.Plant AND ProdOrderIssueLocation = _IssueLocationText.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyAreaText AS _ProdSupplyAreaText ON Plant = _ProdSupplyAreaText.Plant AND ProductionSupplyArea = _ProdSupplyAreaText.ProductionSupplyArea AND _ProdSupplyAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BOMItemSparePart AS _SparePartText ON MatlComponentSparePartType = _SparePartText.BOMItemIsSparePart  -- association [0..1]
LEFT OUTER JOIN I_BOMItemSalesRelevant AS _SalesRelevantText ON BOMItemSalesRelevancy = _SalesRelevantText.BOMItemIsSalesRelevant  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrgText ON PurchasingOrganization = _PurchasingOrgText.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroupText ON PurchasingGroup = _PurchasingGroupText.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup AND _MaterialGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Creditor = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CostElementText AS _CostElementText ON CostElement = _CostElementText.CostElement AND _CostElementText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductSupplyPlanning AS _MaterialPlant ON BillOfMaterialComponent = _MaterialPlant.Product AND Plant = _MaterialPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductionModel AS _ProductionModel ON ProductionModelUUID = _ProductionModel.ProductionModelUUID AND BillOfOperationsVersion = _ProductionModel.BillOfOperationsVersion  -- association [0..1]
LEFT OUTER JOIN I_ProdnModelComponentInstance AS _HeaderComponentInstance ON ProductionModelUUID = _HeaderComponentInstance.ProductionModelUUID AND ProductionModelComponentUUID = _HeaderComponentInstance.ProductionModelComponentUUID AND BillOfOperationsVersion = _HeaderComponentInstance.BillOfOperationsVersion  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _FollowUpProductText ON _FollowUpProductText.Material = FollowUpProduct AND _FollowUpProductText.Language = $session.system_language  -- association [0..1]
;