I_PubSecCtrlObjBudgetCube

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_PubSecCtrlObjBudgetCube.
-- 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: IPSMS4CCOBJBDANC

CREATE VIEW I_PubSecCtrlObjBudgetCube AS
SELECT
  AcItemP.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  AcItemP.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  AcItemP.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  AcItemP.CompanyCode AS CompanyCode,
  AcItemP.FinancialManagementArea AS FinancialManagementArea,
  AcItemP.ControllingArea AS ControllingArea,
  AcItemP.FiscalYear AS FiscalYear,
  AcItemP.Ledger AS Ledger,
  AcItemP.Fund AS Fund,
  AcItemP.FunctionalArea AS FunctionalArea,
  AcItemP.BudgetPeriod AS BudgetPeriod,
  AcItemP.CostCenter AS CostCenter,
  AcItemP.WBSElementExternalID AS WBSElementExternalID,
  AcItemP.WBSElementInternalID AS WBSElementInternalID,
  AcItemP.PubSecBudgetAccount AS PubSecBudgetAccount,
  AcItemP.GlobalCurrency AS GlobalCurrency,
  AcItemP.GrantID AS GrantID,
  AcItemP.SponsoredClass AS SponsoredClass,
  AcItemP.SponsoredProgram AS SponsoredProgram,
  AcItemP.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  AcItemP.ReferenceDocument AS ReferenceDocument,
  AcItemP.ReferenceDocumentContext AS ReferenceDocumentContext,
  AcItemP.ReferenceDocumentType AS ReferenceDocumentType,
  AcItemP.FundType AS FundType,
  AcItemP.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  AcItemP.BudgetingType AS BudgetingType,
  AcItemP.BudgetProcess AS BudgetProcess,
  _CtrlObjProfile.AvailabilityControlProfile AS AvailabilityControlProfile,
  AcItemP.PubSecExpnBdgtAmtInGlobalCrcy AS PubSecExpnBdgtAmtInGlobalCrcy,
  AcItemP.PubSecRevnBdgtAmtInGlobalCrcy AS PubSecRevnBdgtAmtInGlobalCrcy,
  AcItemP.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  AcItemP.GLAccount AS GLAccount,
  AcItemP.BusinessArea AS BusinessArea,
  AcItemP.Segment AS Segment,
  AcItemP.Customer AS Customer,
  AcItemP.ProfitCenter AS ProfitCenter
FROM I_PubSecBdgtLineItemCube AS AcItemP
INNER JOIN I_PubSecPlanningCategory AS _PlanningCategory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PubSecCtrlObjFundMap AS _CtrlObjFundMap ON CompanyCode = _CtrlObjFundMap.CompanyCode AND Fund = _CtrlObjFundMap.Fund AND _CtrlObjFundMap.AvailabilityControlProfile = _CtrlObjProfile.AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjFund AS _CtrlObjFund ON CtrlObjForFund = _CtrlObjFund.CtrlObjForFund AND HierarchyIDForFund = _CtrlObjFund.HierarchyIDForFund  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjFuncAreaMap AS _CtrlObjFuncAreaMap ON CompanyCode = _CtrlObjFuncAreaMap.CompanyCode AND FunctionalArea = _CtrlObjFuncAreaMap.FunctionalArea AND _CtrlObjFuncAreaMap.AvailabilityControlProfile = _CtrlObjProfile.AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjFuncArea AS _CtrlObjFuncArea ON CtrlObjForFunctionalArea = _CtrlObjFuncArea.CtrlObjForFunctionalArea AND HierarchyIDForFunctionalArea = _CtrlObjFuncArea.HierarchyIDForFunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjBdgtPeriodMap AS _CtrlObjBdgtPeriodMap ON CompanyCode = _CtrlObjBdgtPeriodMap.CompanyCode AND BudgetPeriod = _CtrlObjBdgtPeriodMap.BudgetPeriod AND _CtrlObjBdgtPeriodMap.AvailabilityControlProfile = _CtrlObjProfile.AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjBdgtPeriod AS _CtrlObjBdgtPeriod ON CtrlObjForBudgetPeriod = _CtrlObjBdgtPeriod.CtrlObjForBudgetPeriod AND HierarchyIDForBudgetPeriod = _CtrlObjBdgtPeriod.HierarchyIDForBudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjCostCenterMap AS _CtrlObjCostCenterMap ON CompanyCode = _CtrlObjCostCenterMap.CompanyCode AND CostCenter = _CtrlObjCostCenterMap.CostCenter AND _CtrlObjCostCenterMap.AvailabilityControlProfile = _CtrlObjProfile.AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjCostCenter AS _CtrlObjCostCenter ON CtrlObjForCostCenter = _CtrlObjCostCenter.CtrlObjForCostCenter AND HierarchyIDForCostCenter = _CtrlObjCostCenter.HierarchyIDForCostCenter  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjWBSElementMap AS _CtrlObjWBSElementMap ON CompanyCode = _CtrlObjWBSElementMap.CompanyCode AND WBSElementExternalID = _CtrlObjWBSElementMap.WBSElement AND _CtrlObjWBSElementMap.AvailabilityControlProfile = _CtrlObjProfile.AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjWBSElement AS _CtrlObjWBSElement ON CtrlObjForWBSElement = _CtrlObjWBSElement.CtrlObjForWBSElement AND HierarchyIDForWBSElement = _CtrlObjWBSElement.HierarchyIDForWBSElement  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjBdgtAccountMap AS _CtrlObjBdgtAccountMap ON CompanyCode = _CtrlObjBdgtAccountMap.CompanyCode AND PubSecBudgetAccount = _CtrlObjBdgtAccountMap.PubSecBudgetAccount AND _CtrlObjBdgtAccountMap.AvailabilityControlProfile = _CtrlObjProfile.AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjBdgtAccount AS _CtrlObjBdgtAccount ON CtrlObjForBudgetAccount = _CtrlObjBdgtAccount.CtrlObjForBudgetAccount AND HierarchyIDForBudgetAccount = _CtrlObjBdgtAccount.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_PubSecCtrlObjGrantMap AS _CtrlObjGrantMap ON CompanyCode = _CtrlObjGrantMap.CompanyCode AND GrantID = _CtrlObjGrantMap.GrantID AND _CtrlObjGrantMap.AvailabilityControlProfile = _CtrlObjProfile.AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjGrant AS _CtrlObjGrant ON CtrlObjForGrant = _CtrlObjGrant.CtrlObjForGrant AND GrantHierarchy = _CtrlObjGrant.GrantHierarchy  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjSpnsrdClassMap AS _CtrlObjSpnsrdClassMap ON CompanyCode = _CtrlObjSpnsrdClassMap.CompanyCode AND SponsoredClass = _CtrlObjSpnsrdClassMap.SponsoredClass AND _CtrlObjSpnsrdClassMap.AvailabilityControlProfile = _CtrlObjProfile.AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjSpnsrdClass AS _CtrlObjSpnsrdClass ON CtrlObjForSponsoredClass = _CtrlObjSpnsrdClass.CtrlObjForSponsoredClass AND SponsoredClassHierarchy = _CtrlObjSpnsrdClass.SponsoredClassHierarchy  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjSpnsrdProgMap AS _CtrlObjSpnsrdProgMap ON CompanyCode = _CtrlObjSpnsrdProgMap.CompanyCode AND SponsoredProgram = _CtrlObjSpnsrdProgMap.SponsoredProgram AND _CtrlObjSpnsrdProgMap.AvailabilityControlProfile = _CtrlObjProfile.AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjSpnsrdProg AS _CtrlObjSpnsrdProg ON CtrlObjForSponsoredProgram = _CtrlObjSpnsrdProg.CtrlObjForSponsoredProgram AND SponsoredProgramHierarchy = _CtrlObjSpnsrdProg.SponsoredProgramHierarchy  -- 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 _PubSecBudgetPeriodHier ON HierarchyIDForBudgetPeriod = _PubSecBudgetPeriodHier.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]
LEFT OUTER JOIN I_PubSecHierarchy AS _PubSecGrantHier ON GrantHierarchy = _PubSecGrantHier.HierarchyID  -- association [0..1]
LEFT OUTER JOIN I_PubSecHierarchy AS _PubSecSpnsrdClassHier ON SponsoredClassHierarchy = _PubSecSpnsrdClassHier.HierarchyID  -- association [0..1]
LEFT OUTER JOIN I_PubSecHierarchy AS _PubSecSpnsrdProgHier ON SponsoredProgramHierarchy = _PubSecSpnsrdProgHier.HierarchyID  -- association [0..1]
LEFT OUTER JOIN I_PubSecAvailyCtrlProfile AS _PubSecAvailyCtrlProfile ON AvailabilityControlProfile = _PubSecAvailyCtrlProfile.AvailabilityControlProfile  -- association [0..1]
;