I_ProdnModOpActivityGroup

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_ProdnModOpActivityGroup.
-- 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_ProdnModOpActivityGroup AS
SELECT
  ProductionModel.ProductionModelUUID AS ProductionModelUUID,
  BOOVersion.BillOfOperationsVersion AS BillOfOperationsVersion,
  Operation.BOOOperationInternalID AS BOOOperationInternalID,
  OperationActivityGroup.OperationActivityNetworkGroup AS OperationActivityNetworkGroup,
  OperationActivityGroup.OpActyNtwkGroupVersionCounter AS OpActyNtwkGroupVersionCounter,
  Operation.BillOfOperationsSequence AS BillOfOperationsSequence,
  OperationActivityGroup.OpActyNtwkGroupType AS OpActyNtwkGroupType,
  OpActyNtwkElementGrp.OpActyNtwkElementExternalID AS OpActyNtwkGroupExternalID,
  OpActyNtwkElementGrp._OperationActivityNetwork.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  OpActyNtwkElementGrp.OANElementDisplaySqncNumber AS OANElementDisplaySqncNumber,
  OpActyNtwkElementGrp.OpActyNtwkElement AS OpActyNtwkElement,
  ProductionModel.BillOfMaterialVariant AS BillOfMaterialVariant,
  ProductionModel.BillOfMaterialCategory AS BillOfMaterialCategory,
  ProductionModel.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ProductionModel.Material AS Material,
  ProductionModel.Plant AS Plant,
  ProductionModel.BillOfOperationsGroup AS BillOfOperationsGroup,
  ProductionModel.BillOfOperationsType AS BillOfOperationsType,
  ProductionModel.BillOfOperationsVariant AS BillOfOperationsVariant
FROM I_OpActyNtwkGroup AS OperationActivityGroup
INNER JOIN I_OpActyNtwkElement AS OpActyNtwkElementGrp ON /* join condition not captured in parsed metadata */
INNER JOIN P_BillOfOpsOpActyNtwkElmnt AS BOOOperationDetails ON /* join condition not captured in parsed metadata */
INNER JOIN P_ProdnModBOOOperation AS Operation ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProdnModBOOVersBOMAssgmt AS BOOVersion ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProductionModelBasic AS ProductionModel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OpActyNtwkGroupText AS _OperationActivityGroupText ON _OperationActivityGroupText.OperationActivityNetworkGroup = OperationActivityGroup.OperationActivityNetworkGroup AND _OperationActivityGroupText.OpActyNtwkGroupVersionCounter = OperationActivityGroup.OpActyNtwkGroupVersionCounter AND _OperationActivityGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OANSegmentTypeText AS _OpActyNtwkSegmentTypeText ON opactyntwksegmenttype = _OpActyNtwkSegmentTypeText.OpActyNtwkSegmentType AND _OpActyNtwkSegmentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BOOOpActyGroupTypeText AS _BOOOpActyGrpTypeText ON OpActyNtwkGroupType = _BOOOpActyGrpTypeText.OpActyNtwkGroupType AND _BOOOpActyGrpTypeText.Language = $session.system_language  -- association [0..1]
;