I_ProdnModOpActyCompInstance

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_ProdnModOpActyCompInstance.
-- 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_ProdnModOpActyCompInstance AS
SELECT
  Basic.ProductionModelUUID AS ProductionModelUUID,
  Basic.BillOfOperationsVersion AS BillOfOperationsVersion,
  Basic.BOOOperationInternalID AS BOOOperationInternalID,
  Basic.OperationActivity AS OperationActivity,
  Basic.OperationActyVersionCounter AS OperationActyVersionCounter,
  Basic.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  Basic.OriglDgtlMockUpCharcsUUID AS OriglDgtlMockUpCharcsUUID,
  Operation.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  DigitalMockUpCharcs.DgtlMockUpCharcsValue AS DgtlMockUpCharcsValue,
  DigitalMockUpCharcs.DgtlMockUpCharcsVislEntInstce AS DgtlMockUpCharcsVislEntInstce,
  DigitalMockUpCharcs.DgtlMockUpCharcsCADInstce AS DgtlMockUpCharcsCADInstce,
  DigitalMockUpCharcs.DgtlMockUpCharcsUUID AS DgtlMockUpCharcsUUID,
  DigitalMockUpCharcs.DgtlMockUpInstceCount AS DgtlMockUpInstceCount,
  DigitalMockUpCharcs.DgtlMockUpTrnsfmtnMatrixCount AS DgtlMockUpTrnsfmtnMatrixCount,
  Basic.ProductionModelComponentUUID AS ProductionModelComponentUUID,
  cast( Basic.BillOfMaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  Basic.BillOfMaterialVariant AS BillOfMaterialVariant,
  Basic.BillOfMaterialCategory AS BillOfMaterialCategory,
  Basic.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  Basic.Plant AS Plant,
  Basic.BillOfOperationsGroup AS BillOfOperationsGroup,
  Basic.BillOfOperationsType AS BillOfOperationsType,
  Basic.BillOfOperationsVariant AS BillOfOperationsVariant,
  Basic.Material AS Material,
  Basic.BillOfMaterialVersion AS BillOfMaterialVersion,
  Operation.Operation_2 AS Operation,
  Basic.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  DigitalMockUpCharcs.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  Basic.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  Basic.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  Basic.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  Basic.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  cast('1.000' as kmpmg ) AS BillOfMaterialItemQuantity,
  Basic.BillOfMaterialItemUnit AS BillOfMaterialItemUnit
FROM I_ProdnModOpActyCompInstceBsc AS Basic
INNER JOIN P_ProdnModCompDgtlMockUpCharcs AS DigitalMockUpCharcs ON /* join condition not captured in parsed metadata */
INNER JOIN P_ProdnModBOOOperation AS Operation ON /* join condition not captured in parsed metadata */
;