I_RIBBudgetItemCube

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_RIBBudgetItemCube.
-- 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_RIBBudgetItemCube AS
SELECT
  PlanAccountItem.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  PlanAccountItem.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  PlanAccountItem.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  PlanAccountItem.CompanyCode AS CompanyCode,
  PlanAccountItem.FinancialManagementArea AS FinancialManagementArea,
  PlanAccountItem.ControllingArea AS ControllingArea,
  PlanAccountItem.FiscalYear AS FiscalYear,
  PlanAccountItem.Ledger AS Ledger,
  PlanAccountItem.Fund AS Fund,
  PlanAccountItem.FunctionalArea AS FunctionalArea,
  PlanAccountItem.BudgetPeriod AS BudgetPeriod,
  PlanAccountItem.CostCenter AS CostCenter,
  PlanAccountItem.WBSElementExternalID AS WBSElementExternalID,
  PlanAccountItem.WBSElementInternalID AS WBSElementInternalID,
  PlanAccountItem.PubSecBudgetAccount AS PubSecBudgetAccount,
  PlanAccountItem.GlobalCurrency AS GlobalCurrency,
  _RIBProfileAssignment.RIBProfile AS RIBProfile,
  PlanAccountItem.ReferenceDocument AS ReferenceDocument,
  PlanAccountItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  PlanAccountItem.ReferenceDocumentType AS ReferenceDocumentType,
  PlanAccountItem.FundType AS FundType,
  PlanAccountItem.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  PlanAccountItem.BudgetingType AS BudgetingType,
  PlanAccountItem.BudgetProcess AS BudgetProcess,
  PlanAccountItem.PlanningCategory AS PlanningCategory,
  PlanAccountItem.PubSecExpnBdgtAmtInGlobalCrcy AS RIBExpnBdgtAmtInGCrcy,
  PlanAccountItem.PubSecRevnBdgtAmtInGlobalCrcy AS RIBRevnBdgtAmtInGCrcy,
  PlanAccountItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  PlanAccountItem.GLAccount AS GLAccount,
  PlanAccountItem._CompanyCode AS _CompanyCode,
  PlanAccountItem._ControllingArea AS _ControllingArea,
  PlanAccountItem._FinancialManagementArea AS _FinancialManagementArea,
  PlanAccountItem._FiscalYear AS _FiscalYear,
  PlanAccountItem._Ledger AS _Ledger,
  PlanAccountItem._Fund AS _Fund,
  PlanAccountItem._FundType AS _FundType,
  PlanAccountItem._FunctionalArea AS _FunctionalArea,
  PlanAccountItem._BudgetPeriod AS _BudgetPeriod,
  PlanAccountItem._CostCenter AS _CostCenter,
  PlanAccountItem._ReferenceDocumentType AS _ReferenceDocumentType,
  PlanAccountItem._WBSElementBasicData AS _WBSElementBasicData,
  PlanAccountItem._WBSElementExternalID AS _WBSElementExternalID,
  PlanAccountItem._PubSecBdgtAcctRevnExpnCode AS _PubSecBdgtAcctRevnExpnCode,
  PlanAccountItem._BudgetingType AS _BudgetingType,
  PlanAccountItem._BudgetProcess AS _BudgetProcess,
  PlanAccountItem._GlobalCurrency AS _GlobalCurrency,
  PlanAccountItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  PlanAccountItem._PlanningCategory AS _PlanningCategory,
  PlanAccountItem._CurrentCostCenter AS _CurrentCostCenter
FROM I_PubSecBdgtLineItemCube AS PlanAccountItem
INNER JOIN I_PubSecPlanningCategory AS _PlanningCategory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RIBProfile AS _RIBProfile ON RIBProfile = _RIBProfile.RIBProfile  -- association [0..1]
LEFT OUTER JOIN I_RIBCtrlObjFundMap AS _CtrlObjFundMap ON CompanyCode = _CtrlObjFundMap.CompanyCode AND Fund = _CtrlObjFundMap.Fund AND RIBProfile = _CtrlObjFundMap.RIBProfile  -- association [0..1]
LEFT OUTER JOIN I_RIBCtrlObjFund AS _CtrlObjFund ON CtrlObjForFund = _CtrlObjFund.CtrlObjForFund AND HierarchyIDForFund = _CtrlObjFund.HierarchyIDForFund  -- association [0..1]
LEFT OUTER JOIN I_RIBCtrlObjFuncAreaMap AS _CtrlObjFuncAreaMap ON CompanyCode = _CtrlObjFuncAreaMap.CompanyCode AND FunctionalArea = _CtrlObjFuncAreaMap.FunctionalArea AND RIBProfile = _CtrlObjFuncAreaMap.RIBProfile  -- association [0..1]
LEFT OUTER JOIN I_RIBCtrlObjFuncArea AS _CtrlObjFuncArea ON CtrlObjForFunctionalArea = _CtrlObjFuncArea.CtrlObjForFunctionalArea AND HierarchyIDForFunctionalArea = _CtrlObjFuncArea.HierarchyIDForFunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_RIBCtrlObjCostCtrMap AS _CtrlObjCostCtrMap ON CompanyCode = _CtrlObjCostCtrMap.CompanyCode AND CostCenter = _CtrlObjCostCtrMap.CostCenter AND RIBProfile = _CtrlObjCostCtrMap.RIBProfile  -- association [0..1]
LEFT OUTER JOIN I_RIBCtrlObjCostCtr AS _CtrlObjCostCtr ON CtrlObjForCostCenter = _CtrlObjCostCtr.CtrlObjForCostCenter AND HierarchyIDForCostCenter = _CtrlObjCostCtr.HierarchyIDForCostCenter  -- association [0..1]
LEFT OUTER JOIN I_RIBCtrlObjWBSElmntMap AS _CtrlObjWBSElmntMap ON CompanyCode = _CtrlObjWBSElmntMap.CompanyCode AND WBSElementExternalID = _CtrlObjWBSElmntMap.WBSElement AND RIBProfile = _CtrlObjWBSElmntMap.RIBProfile  -- association [0..1]
LEFT OUTER JOIN I_RIBCtrlObjWBSElement AS _CtrlObjWBSElement ON CtrlObjForWBSElement = _CtrlObjWBSElement.CtrlObjForWBSElement AND HierarchyIDForWBSElement = _CtrlObjWBSElement.HierarchyIDForWBSElement  -- association [0..1]
LEFT OUTER JOIN I_RIBCtrlObjBdgtAcctMap AS _CtrlObjBdgtAcctMap ON CompanyCode = _CtrlObjBdgtAcctMap.CompanyCode AND PubSecBudgetAccount = _CtrlObjBdgtAcctMap.PubSecBudgetAccount AND RIBProfile = _CtrlObjBdgtAcctMap.RIBProfile  -- association [0..1]
LEFT OUTER JOIN I_RIBCtrlObjBdgtAcct AS _CtrlObjBdgtAcct ON CtrlObjForBudgetAccount = _CtrlObjBdgtAcct.CtrlObjForBudgetAccount AND HierarchyIDForBudgetAccount = _CtrlObjBdgtAcct.HierarchyIDForBudgetAccount  -- association [0..1]
LEFT OUTER JOIN I_PubSecBudgetAccount AS _PubSecBudgetAccount ON CompanyCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode AND PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount  -- association [0..1]
LEFT OUTER JOIN I_PubSecHierarchy AS _PubSecFundHier ON HierarchyIDForFund = _PubSecFundHier.HierarchyID  -- association [0..1]
LEFT OUTER JOIN I_PubSecHierarchy AS _PubSecFunctionalAreaHier ON HierarchyIDForFunctionalArea = _PubSecFunctionalAreaHier.HierarchyID  -- association [0..1]
LEFT OUTER JOIN I_PubSecHierarchy AS _PubSecCostCenterHier ON HierarchyIDForCostCenter = _PubSecCostCenterHier.HierarchyID  -- association [0..1]
LEFT OUTER JOIN I_PubSecHierarchy AS _PubSecWBSElementHier ON HierarchyIDForWBSElement = _PubSecWBSElementHier.HierarchyID  -- association [0..1]
LEFT OUTER JOIN I_PubSecHierarchy AS _PubSecBudgetAccountHier ON HierarchyIDForBudgetAccount = _PubSecBudgetAccountHier.HierarchyID  -- association [0..1]
;