C_ProcgExecOpActySFIGroup

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 C_ProcgExecOpActySFIGroup.
-- 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 C_ProcgExecOpActySFIGroup AS
SELECT
  OpActySFIGroup.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  OpActySFIGroup.OpActySFIGroupName AS OpActySFIGroupName,
  OpActySFIGroup.ProductionPlant AS ProductionPlant,
  OpActySFIGroup.WorkCenterInternalID AS WorkCenterInternalID,
  OpActySFIGroup.WorkCenter AS WorkCenter,
  OpActySFIGroup.StatusAndActionSchema AS StatusAndActionSchema,
  OpActySFIGroup.StatusAndActionSchemaStatus AS StatusAndActionSchemaStatus,
  OpActySFIGroup._SASStatusText[1: Language=$session.system_language].SASStatusName AS SASStatusName,
  OpActySFIGroup.SASStatusCategory AS SASStatusCategory,
  OpActySFIGroup.RepresentativeShopFloorItem AS RepresentativeShopFloorItem,
  OpActySFIGroup.RprstvOpActyNtwkInstance AS RprstvOpActyNtwkInstance,
  OpActySFIGroup.RprstvOpActyNtwkElement AS RprstvOpActyNtwkElement,
  OpActySFIGroup.RprstvManufacturingOrder AS RprstvManufacturingOrder,
  OpActySFIGroup.RepresentativeInspectionLot AS RepresentativeInspectionLot,
  OpActySFIGroup.RprstvManufacturingOrderItem AS RprstvManufacturingOrderItem,
  OpActySFIGroup.RprstvMfgOrderInternalID AS RprstvMfgOrderInternalID,
  OpActySFIGroup.RprstvMfgOrderOpInternalID AS RprstvMfgOrderOpInternalID,
  OpActySFIGroup.RprstvOpActyNtwkElmntExtID AS RprstvOpActyNtwkElmntExtID,
  OpActySFIGroup.RprstvMfgOrderOperation AS RprstvMfgOrderOperation,
  OpActySFIGroup.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  OpActySFIGroup.CreatedByUser AS CreatedByUser,
  OpActySFIGroup.CreationDateTime AS CreationDateTime,
  OpActySFIGroup.LastChangedByUser AS LastChangedByUser,
  OpActySFIGroup.LastChangeDateTime AS LastChangeDateTime,
  OpActySFIGroup.NumberOfGroupedShopFloorItems AS NumberOfGroupedShopFloorItems,
  OpActySFIGroup.SFIIsInactiveAtOpActy AS SFIIsInactiveAtOpActy,
  OpActySFIGroup._WorkCenterByInternalID._Text[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  OpActySFIGroup._RprstvOperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  OpActySFIGroup.WorkInstructionVersionCounter AS WorkInstructionVersionCounter,
  OpActySFIGroup.MfgWorkInstructionMode AS MfgWorkInstructionMode,
  OpActySFIGroup.LaborTrackingIsRequired AS LaborTrackingIsRequired,
  OpActySFIGroup.MfgBuyOffCycleIsExisting AS MfgBuyOffCycleIsExisting,
  OpActySFIGroup.OpActyInspectionRelevance AS OpActyInspectionRelevance,
  OpActySFIGroup._ProductionPlant AS _ProductionPlant,
  OpActySFIGroup._SASSchema AS _SASSchema,
  OpActySFIGroup._SASStatus AS _SASStatus,
  OpActySFIGroup._SASStatusText AS _SASStatusText,
  OpActySFIGroup._SASStatusCategory AS _SASStatusCategory,
  OpActySFIGroup._RprstvOpActyNtwkInstance AS _RprstvOpActyNtwkInstance,
  OpActySFIGroup._RprstvOpActyInstance AS _RprstvOpActyInstance,
  OpActySFIGroup._WorkCenterByInternalID AS _WorkCenterByInternalID,
  OpActySFIGroup._ShopFloorItemStatus AS _ShopFloorItemStatus,
  OpActySFIGroup._OpActyInstceNtwkElmntBasic AS _OpActyInstceNtwkElmntBasic
FROM I_OpActySFIGroupTP
LEFT OUTER JOIN C_SASAction AS _SASAction ON StatusAndActionSchema = _SASAction.StatusAndActionSchema AND StatusAndActionSchemaStatus = _SASAction.SASActionStartStatus AND ProductionPlant = _SASAction.Plant  -- association [0..*]
LEFT OUTER JOIN C_ManufacturingActionSetting AS _ManufacturingActionSetting ON ProductionPlant = _ManufacturingActionSetting.Plant AND _ManufacturingActionSetting.MfgObjectType = '004'  -- association [0..*]
LEFT OUTER JOIN C_ProcgExecOpActySFIGroupComp AS _ProcgExecOpActySFIGroupComp ON OperationActivitySFIGroup = _ProcgExecOpActySFIGroupComp.OperationActivitySFIGroup  -- association [0..*]
LEFT OUTER JOIN C_ProcgExecOpActySFIGroupPRT AS _ProcgExecOpActySFIGroupPRT ON OperationActivitySFIGroup = _ProcgExecOpActySFIGroupPRT.OperationActivitySFIGroup  -- association [0..*]
LEFT OUTER JOIN C_ShopFloorItemAtOpActyVH AS _OpActySFIGroupMember ON OperationActivitySFIGroup = _OpActySFIGroupMember.OperationActivitySFIGroup  -- association [0..*]
;