fac_cds_ve_results_header

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 fac_cds_ve_results_header.
-- 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: FACVERSTHD

CREATE VIEW fac_cds_ve_results_header AS
SELECT
  result.drruuid AS Drruuid,
  result.scen_id AS scen_id,
  result.ryear AS Ryear,
  result.poper AS Poper,
  result.periv AS Periv,
  result.fiscyearper AS Fiscyearper,
  result.ledger AS Ledger,
  result.lastrun AS Lastrun,
  result.starttime AS StartTime,
  result.endtime AS EndTime,
  result.scheduledby AS ScheduledBy,
  result.jobname AS Jobname,
  result.jobcount AS Jobcount,
  result.parent_jobcount AS ParentJobcount,
  result.parent_jobname AS ParentJobname,
  result.lognumber AS Lognumber,
  result.hier_catg AS hier_catg,
  result.hier_sid AS hier_hid,
  result.ver_id AS ver_id,
  result.runtype AS Runtype,
  result.runcatg AS Runcatg,
  result.customfield1 AS Customfield1,
  result.customfield2 AS Customfield2,
  result.customfield3 AS Customfield3,
  result.customfield4 AS Customfield4,
  result.customfield5 AS Customfield5,
  result.customfield6 AS Customfield6,
  result.customfield7 AS Customfield7,
  result.customfield8 AS Customfield8,
  result.customfield9 AS Customfield9,
  result.customfield10 AS Customfield10,
  result.curtype AS Curtype,
  result.rcomp AS Rcomp,
  result.bukrs AS Bukrs,
  result.kokrs AS Kokrs,
  result.rcntr AS Rcntr,
  result.prctr AS Prctr,
  result.segment AS Segment,
  result.rbusa AS Rbusa,
  result.dimen AS Dimen,
  result.rvers AS Rvers,
  result.rldnr AS Rldnr,
  result.rbunit AS Rbunit,
  result.rcongr AS Rcongr,
  result.ritclg AS Ritclg,
  result.tasktype AS Tasktype,
  result.taskid AS TaskID,
  result.cmp_rvers AS cmp_rvers,
  result.lastsucrunuuid AS LastsucRunuuid,
  comment_count AS CommentCount,
  _Text.description AS DESCRIPTION,
  _LedgerText.LedgerName AS LedgerDesc,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeDesc,
  _ControllingArea.ControllingAreaName AS ControllingAreaDesc,
  _CostCenterText.CostCenterDescription AS CostCenterDesc,
  _ProfitCenterText.ProfitCenterName AS ProfitCenterDesc,
  _SegmentText.SegmentName AS SegmentDesc,
  _BusinessAreaText.BusinessAreaName AS BusinessAreaDesc,
  _CnsldtnDimensionT.ConsolidationDimensionText AS ConsolidationDimensionDesc,
  _CnsldtnVersionT.ConsolidationVersionText AS ConsolidationVersionDesc,
  _CnsldtnLedgerT.ConsolidationLedgerName AS ConsolidationLedgerDesc,
  _CnsldtnUnit_CombinedText.ConsolidationUnitText AS ConsolidationUnitDesc,
  _CnsldtnChartOfAccountsT.ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsDesc,
  _CnsldtnGroupT.ConsolidationGroupText AS ConsolidationGroupDesc,
  '' AS CurrencyTypeDesc,
  _rulecount[ drruuid = drruuid and rule_result = 'S' ].StateCount AS SuccessCount,
  _rulecount[ drruuid = drruuid and rule_result = 'E' ].StateCount AS FailedCount,
  _rulecount[ drruuid = drruuid and rule_result = 'W' ].StateCount AS WarningCount,
  _rulecount[ drruuid = drruuid and rule_result = 'I' ].StateCount AS InfoCount
FROM vec_rst_header AS result
LEFT OUTER JOIN vec_rst_headert AS _Text ON _Text.drruuid = Drruuid AND _Text.lang = $session.system_language  -- association [0..1]
LEFT OUTER JOIN FAC_CDS_VE_RESULT_ITEM AS _items ON _items.drruuid = Drruuid  -- association [1..*]
LEFT OUTER JOIN FAC_CDS_VE_COMMENT AS _to_grpcomment ON _to_grpcomment.drruuid = Drruuid AND _to_grpcomment.node_type = 'R'  -- association [0..*]
LEFT OUTER JOIN FAC_CDS_VE_COMMENT_RULE AS _to_commentrules ON _to_commentrules.drruuid = Drruuid  -- association [0..*]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger AND _LedgerText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON Bukrs = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON Kokrs = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON Kokrs = _CostCenterText.ControllingArea AND Rcntr = _CostCenterText.CostCenter AND _CostCenterText.Language = $session.system_language AND _CostCenterText.ValidityStartDate <= $session.system_date AND _CostCenterText.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON Kokrs = _ProfitCenterText.ControllingArea AND Prctr = _ProfitCenterText.ProfitCenter AND _ProfitCenterText.Language = $session.system_language AND _ProfitCenterText.ValidityStartDate <= $session.system_date AND _ProfitCenterText.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON Segment = _SegmentText.Segment AND _SegmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON Rbusa = _BusinessAreaText.BusinessArea AND _BusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccountsT AS _CnsldtnChartOfAccountsT ON Ritclg = _CnsldtnChartOfAccountsT.ConsolidationChartOfAccounts AND _CnsldtnChartOfAccountsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDimensionT AS _CnsldtnDimensionT ON Dimen = _CnsldtnDimensionT.ConsolidationDimension AND _CnsldtnDimensionT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnVersionT AS _CnsldtnVersionT ON Rvers = _CnsldtnVersionT.ConsolidationVersion AND _CnsldtnVersionT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnLedgerT AS _CnsldtnLedgerT ON Rldnr = _CnsldtnLedgerT.ConsolidationLedger AND _CnsldtnLedgerT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_CnsldtnUnit_CombinedText AS _CnsldtnUnit_CombinedText ON Rbunit = _CnsldtnUnit_CombinedText.ConsolidationUnit AND _CnsldtnUnit_CombinedText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGroupT AS _CnsldtnGroupT ON Dimen = _CnsldtnGroupT.ConsolidationDimension AND Rcongr = _CnsldtnGroupT.ConsolidationGroup AND _CnsldtnGroupT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN FAC_CDS_VE_RULE_STATE_COUNT AS _rulecount ON Drruuid = _rulecount.drruuid  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _ScheduledByUserContactCard ON ScheduledBy = _ScheduledByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN vec_rst_headert AS _Text_e ON _Text_e.drruuid = Drruuid AND _Text_e.lang = 'E'  -- association [0..1]
-- UNION ALL with additional select branch(es): vec_rst_header
;