C_PubSecCtrlObjBudget

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_PubSecCtrlObjBudget.
-- 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: CPSMS4CCOBJBDANL

CREATE VIEW C_PubSecCtrlObjBudget AS
SELECT
  Main.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  Main.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  Main.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  Main.CompanyCode AS CompanyCode,
  Main.FinancialManagementArea AS FinancialManagementArea,
  Main.ControllingArea AS ControllingArea,
  Main.FiscalYear AS FiscalYear,
  Main.Ledger AS Ledger,
  Main.Fund AS Fund,
  Main.FundType AS FundType,
  Main.FunctionalArea AS FunctionalArea,
  Main.BudgetPeriod AS BudgetPeriod,
  Main.CostCenter AS CostCenter,
  cast( coalesce( Main.WBSElementExternalID, '' ) as fis_wbsext_no_conv preserving type ) AS WBSElementExternalID,
  Main.PubSecBudgetAccount AS PubSecBudgetAccount,
  Main.GrantID AS GrantID,
  Main.SponsoredClass AS SponsoredClass,
  Main.SponsoredProgram AS SponsoredProgram,
  Main.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  Main._Grant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  Main.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  Main.AvailabilityControlProfile AS AvailabilityControlProfile,
  Main.CtrlObjForFund AS CtrlObjForFund,
  Main.HierarchyIDForFund AS HierarchyIDForFund,
  Main.CtrlObjForFunctionalArea AS CtrlObjForFunctionalArea,
  Main.HierarchyIDForFunctionalArea AS HierarchyIDForFunctionalArea,
  Main.CtrlObjForBudgetPeriod AS CtrlObjForBudgetPeriod,
  Main.HierarchyIDForBudgetPeriod AS HierarchyIDForBudgetPeriod,
  Main.CtrlObjForCostCenter AS CtrlObjForCostCenter,
  Main.HierarchyIDForCostCenter AS HierarchyIDForCostCenter,
  Main.CtrlObjForWBSElement AS CtrlObjForWBSElement,
  Main.HierarchyIDForWBSElement AS HierarchyIDForWBSElement,
  Main.CtrlObjForBudgetAccount AS CtrlObjForBudgetAccount,
  Main.HierarchyIDForBudgetAccount AS HierarchyIDForBudgetAccount,
  cast( ltrim(Main.CtrlObjForGrant,'0') as psm_s4c_fm_avc_ctrl_obj_gr preserving type ) AS CtrlObjForGrant,
  Main.GrantHierarchy AS GrantHierarchy,
  Main.CtrlObjForSponsoredClass AS CtrlObjForSponsoredClass,
  Main.SponsoredClassHierarchy AS SponsoredClassHierarchy,
  Main.CtrlObjForSponsoredProgram AS CtrlObjForSponsoredProgram,
  Main.SponsoredProgramHierarchy AS SponsoredProgramHierarchy,
  Main.CtrlObjForBdgtValidityNmbr AS CtrlObjForBdgtValidityNmbr,
  Main.BudgetDocument AS BudgetDocument,
  Main.ReferenceDocument AS ReferenceDocument,
  Main.ReferenceDocumentContext AS ReferenceDocumentContext,
  Main.ReferenceDocumentType AS ReferenceDocumentType,
  Main.BudgetingType AS BudgetingType,
  Main._BudgetingType._Text[1:Language = $session.system_language].BudgetingTypeText AS BudgetingTypeText,
  Main.BudgetProcess AS BudgetProcess,
  Main._BudgetProcess._Text[1:Language = $session.system_language].BudgetProcessText AS BudgetProcessText,
  Main.GlobalCurrency AS GlobalCurrency,
  cast( Main.AmountInGlobalCurrency as psm_amt_expn_bdgt_grp_curr ) AS PubSecExpnBdgtAmtInGlobalCrcy,
  Main._CtrlObjFund.CtrlObjNameForFund AS CtrlObjNameForFund,
  Main._CtrlObjBdgtPeriod.CtrlObjNameForBudgetPeriod AS CtrlObjNameForBudgetPeriod,
  Main._CtrlObjCostCenter.CtrlObjNameForCostCenter AS CtrlObjNameForCostCenter,
  Main._CtrlObjFuncArea.CtrlObjNameForFunctionalArea AS CtrlObjNameForFunctionalArea,
  Main._CtrlObjWBSElement.CtrlObjNameForWBSElement AS CtrlObjNameForWBSElement,
  Main._CtrlObjBdgtAccount.CtrlObjNameForBudgetAccount AS CtrlObjNameForBudgetAccount,
  Main._CtrlObjGrant.CtrlObjForGrantName AS CtrlObjForGrantName,
  Main._CtrlObjSpnsrdClass.CtrlObjForSponsoredClassName AS CtrlObjForSponsoredClassName,
  Main._CtrlObjSpnsrdProg.CtrlObjForSponsoredProgramName AS CtrlObjForSponsoredProgramName,
  Main._Fund._Text[1:Language = $session.system_language].FundDescription AS FundDescription,
  Main._FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  Main._BudgetPeriod._Text[1:Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
  Main._CurrentCostCenter._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  Main._WBSElementExternalID.WBSDescription AS WBSDescription,
  Main._PubSecBudgetAccount._BudgetAccountText[1:Language = $session.system_language].BudgetAccountName AS BudgetAccountName,
  Main._Grant._Text[1:Language = $session.system_language].GrantName AS GrantName,
  Main._Grant._Sponsor.BusinessPartnerName AS BusinessPartnerName,
  Main._SponsoredClass._Text[1:Language = $session.system_language].SponsoredClassName AS SponsoredClassName,
  Main._SponsoredProgram._Text[1:Language = $session.system_language].SponsoredProgramName AS SponsoredProgramName,
  Main._FundType._Text[1:Language = $session.system_language].FundTypeDescription AS FundTypeDescription,
  Main._PubSecBdgtAcctRevnExpnCode._Text[1:Language = $session.system_language].PubSecBdgtAcctRevnExpnCodeText AS PubSecBdgtAcctRevnExpnCodeText,
  Main._PubSecAvailyCtrlProfile._Text[1:Language = $session.system_language].AvailabilityControlProfileName AS AvailabilityControlProfileName,
  Main._ReferenceDocumentType._Text[1:Language = $session.system_language].ReferenceDocumentTypeName AS ReferenceDocumentTypeName,
  Main._CompanyCode.CompanyCodeName AS CompanyCodeName,
  Main._GlobalCurrency._Text[1:Language = $session.system_language].CurrencyName AS CurrencyName,
  Main.BusinessArea AS BusinessArea,
  Main.Segment AS Segment,
  Main.GLAccount AS GLAccount,
  Main.Customer AS Customer,
  Main.ProfitCenter AS ProfitCenter,
  Main._CompanyCode AS _CompanyCode,
  Main._ControllingArea AS _ControllingArea,
  Main._FinancialManagementArea AS _FinancialManagementArea,
  Main._Fund AS _Fund,
  Main._Grant AS _Grant,
  Main._SponsoredProgram AS _SponsoredProgram,
  Main._SponsoredClass AS _SponsoredClass,
  Main._CostCenter AS _CostCenter,
  Main._CurrentCostCenter AS _CurrentCostCenter,
  Main._PubSecBdgtAcctRevnExpnCode AS _PubSecBdgtAcctRevnExpnCode,
  Main._PubSecAvailyCtrlProfile AS _PubSecAvailyCtrlProfile,
  Main._BusinessArea AS _BusinessArea,
  Main._Segment AS _Segment,
  Main._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  Main._Customer AS _Customer,
  Main._ProfitCenter AS _ProfitCenter,
  Main._CurrentProfitCenter AS _CurrentProfitCenter
FROM I_PubSecCtrlObjBudgetCube AS Main
;