I_ProdnModOperationActivity

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_ProdnModOperationActivity.
-- 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_ProdnModOperationActivity AS
SELECT
  ProductionModel.ProductionModelUUID AS ProductionModelUUID,
  BOOVersion.BillOfOperationsVersion AS BillOfOperationsVersion,
  Operation.BOOOperationInternalID AS BOOOperationInternalID,
  OperationActivity.OperationActivity AS OperationActivity,
  OperationActivity.OperationActyVersionCounter AS OperationActyVersionCounter,
  Operation.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  ProductionModel.BillOfMaterial AS BillOfMaterial,
  ProductionModel.BillOfMaterialVariant AS BillOfMaterialVariant,
  ProductionModel.BillOfMaterialCategory AS BillOfMaterialCategory,
  ProductionModel.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ProductionModel.Plant AS Plant,
  ProductionModel.BillOfOperationsGroup AS BillOfOperationsGroup,
  ProductionModel.BillOfOperationsType AS BillOfOperationsType,
  ProductionModel.BillOfOperationsVariant AS BillOfOperationsVariant,
  OpactivityNetworkElement.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  OperationActivity._Text[1:Language = $session.system_language ].OperationActivityName AS OperationActivityName,
  Operation.OperationExternalID AS OperationExternalID,
  Operation.Operation_2 AS Operation,
  Operation.OperationText AS OperationText,
  Operation.LongTextLanguageCode AS LongTextLanguageCode,
  OpactivityNetworkElement._OperationActivityNetwork.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  Operation.OperationControlProfile AS OperationControlProfile,
  OperationActivity.OperationActStsAndActnSchema AS OperationActStsAndActnSchema,
  OperationActivity.SFIStatusAndActionSchema AS SFIStatusAndActionSchema,
  OperationActivity.AssemblySqncCheckIsRequired AS AssemblySqncCheckIsRequired,
  OperationActivity.IsReleased AS IsReleased,
  OperationActivity.OpActyInspectionRelevance AS OpActyInspectionRelevance,
  OperationActivity.OriginalChgAlertCount AS OriginalChgAlertCount,
  BOOOpActyGrp.OpActyNtwkGroupExternalID AS OpActyNtwkGroupExternalID,
  OpactivityNetworkElement.OANElementDisplaySqncNumber AS OANElementDisplaySqncNumber,
  OpactivityNetworkElement.OpActyNtwkElement AS OpActyNtwkElement,
  BOOOpActyGrp.OperationActivityNetworkGroup AS OperationActivityNetworkGroup,
  BOOOpActyGrp.OpActyNtwkGroupVersionCounter AS OpActyNtwkGroupVersionCounter,
  BOOOpActyGrp.OpActyNtwkGroupType AS OpActyNtwkGroupType,
  BOOOpActyGrp.OpActyNtwkGroupParentElement AS OpActyNtwkGroupParentElement,
  BOORoutingTemplate.ShopFloorRoutingTemplateType AS ShopFloorRoutingTemplateType,
  OperationActivity.ShopFloorRtgTemplateGroup AS ShopFloorRtgTemplateGroup,
  OperationActivity.ShopFloorRtgTemplateGrpVariant AS ShopFloorRtgTemplateGrpVariant,
  OperationActivity.ShopFloorRtgTemplateVersion AS ShopFloorRtgTemplateVersion,
  OperationActivity.CreatedByUser AS CreatedByUser,
  OperationActivity.CreationDateTime AS CreationDateTime,
  OperationActivity.ChangedBy AS ChangedBy,
  OperationActivity.LastChangeDateTime AS LastChangeDateTime
FROM I_OperationActivity AS OperationActivity
INNER JOIN I_OpActyNtwkElement AS OpactivityNetworkElement ON /* join condition not captured in parsed metadata */
INNER JOIN I_BOOOperationChgStOANBasic 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_ProductionModelOperation AS _Operation ON ProductionModelUUID = _Operation.ProductionModelUUID AND BillOfMaterial = _Operation.BillOfMaterial AND BillOfMaterialVariant = _Operation.BillOfMaterialVariant AND BillOfMaterialCategory = _Operation.BillOfMaterialCategory AND Plant = _Operation.Plant AND BillOfOperationsType = _Operation.BillOfOperationsType AND BillOfOperationsGroup = _Operation.BillOfOperationsGroup AND BillOfOperationsVariant = _Operation.BillOfOperationsVariant AND BillOfOperationsVersion = _Operation.BillOfOperationsVersion AND BOOOperationInternalID = _Operation.BOOOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProdnModOpActyComponent AS _OperationActivityComponent ON ProductionModelUUID = _OperationActivityComponent.ProductionModelUUID AND BillOfOperationsVersion = _OperationActivityComponent.BillOfOperationsVersion AND BOOOperationInternalID = _OperationActivityComponent.BOOOperationInternalID AND OperationActivity = _OperationActivityComponent.OperationActivity AND OperationActyVersionCounter = _OperationActivityComponent.OperationActyVersionCounter  -- association [0..*]
LEFT OUTER JOIN I_ProductionModel AS _ProductionModel ON ProductionModelUUID = _ProductionModel.ProductionModelUUID AND BillOfOperationsVersion = _ProductionModel.BillOfOperationsVersion  -- 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_SASSchemaText AS _SASSchemaText ON OperationActStsAndActnSchema = _SASSchemaText.StatusAndActionSchema AND _SASSchemaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SASSchemaText AS _SFISchemaText ON SFIStatusAndActionSchema = _SFISchemaText.StatusAndActionSchema AND _SFISchemaText.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]
LEFT OUTER JOIN I_OpActyNtwkGroupText AS _GroupText ON OperationActivityNetworkGroup = _GroupText.OperationActivityNetworkGroup AND OpActyNtwkGroupVersionCounter = _GroupText.OpActyNtwkGroupVersionCounter AND _GroupText.Language = $session.system_language  -- association [0..1]
;