I_SpnsrdPgmRIB

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_SpnsrdPgmRIB.
-- 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_SpnsrdPgmRIB AS
SELECT
  cast ('5RIB' as psm_s4c_gm_spdpgm_wu_objtypevh) AS SpnsrdPgmWhereUsedObjType,
  RevnIncrBdgtUUID,
  RevenueBudgetAddrSpnsrdPgm AS SponsoredProgram,
  cast ( '' as psm_s4c_rib_rule_key) AS RevnIncrBdgtRuleCtrlObj,
  cast ('Header Sponsored Progam' as psm_s4c_gm_spdpgm_wu_rib_role ) AS RIBSponsoredPgmRole,
  RevenueBudgetAddrGrant AS GrantID,
  CtrlObjForFund,
  CtrlObjForGrant,
  CtrlObjForSponsoredProgramName,
  CtrlObjForSponsoredClassName,
  RevnIncrBdgtRuleValidFromYear,
  RevnIncrBdgtRuleCompanyCode,
  RevnIncrBdgtRuleDescription,
  RevnIncrBdgtRuleActivationSts,
  RevnIncrBdgtRuleCreatedBy AS CreatedByUser,
  tstmp_to_dats( RevnIncrBdgtRuleCrtedAtDteTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as RevnIncrBdgtRuleCreationDate AS clientNULLasRevnIncrBdgtRuleCreationDate,
  _ActivationStatus._Text[ Language = $session.system_language ].RevnIncrBdgtRuleActvtnStsTxt AS RevnIncrBdgtRuleActvtnStsTxt,
  _SponsoredProgram.SponsoredProgramAuthznGrp AS SponsoredProgramAuthznGrp
FROM I_RevenueIncrBudgetRule
INNER JOIN I_RevenueIncrBudgetRule AS _header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SponsoredProgram AS _SponsoredProgram ON SponsoredProgram = _SponsoredProgram.SponsoredProgram  -- association [1..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [1..1]
LEFT OUTER JOIN I_RevnIncrBdgtRuleActvtnSts AS _ActivationStatus ON RevnIncrBdgtRuleActivationSts = _ActivationStatus.RevnIncrBdgtRuleActivationSts  -- association [1..1]
-- UNION with additional select branch(es): I_RevenueIncrBudgetRule, I_RevenueIncrBudgetRuleItem
;