I_ProdnModelComponentInstance

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_ProdnModelComponentInstance.
-- 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_ProdnModelComponentInstance AS
SELECT
  BOMItem.ProductionModelUUID AS ProductionModelUUID,
  BOMItem.BillOfOperationsVersion AS BillOfOperationsVersion,
  BOMItem.ProductionModelComponentUUID AS ProductionModelComponentUUID,
  DigitalMockUpCharcs.DgtlMockUpCharcsUUID AS DgtlMockUpCharcsUUID,
  DigitalMockUpCharcs.DgtlMockUpTrnsfmtnMatrixCount AS DgtlMockUpTrnsfmtnMatrixCount,
  DigitalMockUpCharcs.DgtlMockUpInstceCount AS DgtlMockUpInstceCount,
  DigitalMockUpCharcs.DgtlMockUpCharcsValue AS DgtlMockUpCharcsValue,
  DigitalMockUpCharcs.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  DigitalMockUpCharcs.DgtlMockUpCharcsVislEntInstce AS DgtlMockUpCharcsVislEntInstce,
  DigitalMockUpCharcs.DgtlMockUpCharcsCADInstce AS DgtlMockUpCharcsCADInstce,
  BOMItem.BillOfMaterialCategory AS BillOfMaterialCategory,
  BOMItem.Plant AS Plant,
  BOMItem.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  BOMItem.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  BOMItem.BillOfOperationsType AS BillOfOperationsType,
  BOMItem.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  BOMItem.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  BOMItem.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  BOMItem.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  cast('1.000' as kmpmg ) AS BillOfMaterialItemQuantity
FROM P_ProductionModelComponent AS BOMItem
INNER JOIN P_ProdnModCompDgtlMockUpCharcs AS DigitalMockUpCharcs ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductionModel AS _ProductionModel ON ProductionModelUUID = _ProductionModel.ProductionModelUUID AND BillOfOperationsVersion = _ProductionModel.BillOfOperationsVersion  -- association [1..1]
LEFT OUTER JOIN I_ProductionModelComponent AS _HeaderComponent ON ProductionModelUUID = _HeaderComponent.ProductionModelUUID AND BillOfOperationsVersion = _HeaderComponent.BillOfOperationsVersion AND ProductionModelComponentUUID = _HeaderComponent.ProductionModelComponentUUID  -- association [1..1]
;