C_ABOPRun

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_ABOPRun.
-- 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.
-- SQL view name: CABOPRUN

CREATE VIEW C_ABOPRun AS
SELECT
  ABOPRunUUID,
  TransactionCode,
  ABOPVariantUUID,
  ABOPVariantName,
  StartedByUser,
  _TriggeredByUser.UserDescription AS StartedByUserDescription,
  ABOPRunStartUTCDateTime,
  ABOPRunEndUTCDateTime,
  ABOPRunStatus,
  ABOPExecutionMode,
  ATPCheckHasOnlyHeader,
  ApplicationLogHandle,
  ABOPRunSummaryUUID,
  ABOPRunExecutionOrder,
  ABOPRunIsSummary,
  ABOPRunCustomExecutionName,
  ABOPRunApplicationType,
  _ApplicationTypeText.ABOPRunApplicationTypeText AS ABOPRunApplicationTypeText
FROM I_ABOPRun
LEFT OUTER JOIN C_ABOPRunPartAllResultFigures AS _ResultFiguresForAllRqmts ON ABOPRunUUID = _ResultFiguresForAllRqmts.ABOPRunPartUUID  -- association [1..1]
LEFT OUTER JOIN C_ABOPRunPartResultFigures AS _ResultFiguresForProcdRqmts ON ABOPRunUUID = _ResultFiguresForProcdRqmts.ABOPRunPartUUID  -- association [1..1]
LEFT OUTER JOIN C_ABOPRunFallback AS _Fallbacks ON ABOPRunUUID = _Fallbacks.ABOPRunSummaryUUID  -- association [0..*]
LEFT OUTER JOIN C_ABOPRunMaterialPlant AS _MaterialPlants ON ABOPRunUUID = _MaterialPlants.ABOPRunUUID  -- association [0..*]
LEFT OUTER JOIN C_ABOPRunStrategy AS _Strategies ON ABOPRunUUID = _Strategies.ABOPRunUUID  -- association [0..*]
LEFT OUTER JOIN C_ABOPRunSoldToParty AS _SoldToParties ON ABOPRunUUID = _SoldToParties.ABOPRunUUID  -- association [0..*]
LEFT OUTER JOIN I_ABOPVariantText AS _VariantText ON ABOPVariantUUID = _VariantText.ABOPVariantUUID  -- association [0..*]
LEFT OUTER JOIN I_ABOPRunApplicationTypeText AS _ApplicationTypeText ON ABOPRunApplicationType = _ApplicationTypeText.ABOPRunApplicationType AND _ApplicationTypeText.Language = $session.system_language  -- association [0..1]
;