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
  ProductionModel.ProductionModelUUID AS ProductionModelUUID,
  BOMItem.BillOfMaterialItemUUID AS ProductionModelComponentUUID,
  BOMItem.BillOfMaterialCategory AS BillOfMaterialCategory,
  cast( BOMItem.BillOfMaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  BOMItem.BillOfMaterialVariant AS BillOfMaterialVariant,
  BOMItem.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  BOMItem.BillOfMaterialVersion AS BillOfMaterialVersion,
  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,
  _MaterialText.MaterialName AS MaterialName,
  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.BOMItemSorter AS BOMItemSorter,
  BOMItem.BOMItemHasFixedQuantity AS BOMItemHasFixedQuantity,
  BOMItem.ComponentScrapInPercent AS ComponentScrapInPercent,
  BOMItem.OperationScrapInPercent AS OperationScrapInPercent,
  BOMItem.IsNetScrap AS IsNetScrap,
  BOMItem.IsBulkMaterial AS IsBulkMaterial,
  BOMItem.IsMaterialProvision AS IsMaterialProvision,
  BOMItem.BOMItemIsSparePart AS BOMItemIsSparePart,
  BOMItem.BOMItemIsSalesRelevant AS BOMItemIsSalesRelevant,
  BOMItem.IsEngineeringRelevant AS IsEngineeringRelevant,
  BOMItem.BOMItemIsPlantMaintRelevant AS BOMItemIsPlantMaintRelevant,
  BOMItem.IsProductionRelevant AS IsProductionRelevant,
  BOMItem.BOMItemIsCostingRelevant AS BOMItemIsCostingRelevant,
  BOMItem.BOMIsRecursive AS BOMIsRecursive,
  BOMItem.IsBOMRecursiveAllowed AS IsBOMRecursiveAllowed,
  BOMItem.FollowUpGroup AS FollowUpGroup,
  BOMItem.AlternativeItemGroup AS AlternativeItemGroup,
  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.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,
  BOMItem.FormulaKey AS FormulaKey,
  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
FROM I_BillOfMaterialItem AS BOMItem
INNER JOIN I_ProductionModel AS ProductionModel 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]
;