C_PubSecCtrlObjCmtmtActl

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_PubSecCtrlObjCmtmtActl.
-- 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: CPSMS4CCOBJCAANL

CREATE VIEW C_PubSecCtrlObjCmtmtActl AS
SELECT
  Main.Ledger AS Ledger,
  Main.SourceLedger AS SourceLedger,
  Main.CompanyCode AS CompanyCode,
  Main.FiscalYear AS FiscalYear,
  Main.AccountingDocument AS AccountingDocument,
  Main.LedgerGLLineItem AS LedgerGLLineItem,
  Main.FinancialManagementArea AS FinancialManagementArea,
  Main.ControllingArea AS ControllingArea,
  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.PurchaseOrder AS PurchaseOrder,
  Main.PurchaseRequisition AS PurchaseRequisition,
  Main.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  Main.IsCommitment AS IsCommitment,
  Main.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  Main.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  Main._PubSecBdgtCnsmpnType._Text[1:Language = $session.system_language].PubSecBudgetCnsmpnTypeText AS PubSecBudgetCnsmpnTypeText,
  Main.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  Main._PubSecBdgtCnsmpnAmtType._Text[1:Language = $session.system_language].PubSecBdgtCnsmpnAmtTypeText AS PubSecBdgtCnsmpnAmtTypeText,
  Main.GlobalCurrency AS GlobalCurrency,
  cast( Main.AmountInGlobalCurrency as psm_amt_expn_cmtact_grp_curr ) AS PubSecExpnCmtmtActlAmtInGCrcy,
  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._CompanyCode.CompanyCodeName AS CompanyCodeName,
  Main._GlobalCurrency._Text[1:Language = $session.system_language].CurrencyName AS CurrencyName,
  Main.FinancialAccountType AS FinancialAccountType,
  Main.BusinessArea AS BusinessArea,
  Main.Segment AS Segment,
  Main.GLAccount AS GLAccount,
  Main.Supplier AS Supplier,
  Main.Customer AS Customer,
  Main.AccountingDocumentType AS AccountingDocumentType,
  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._FinancialAccountType AS _FinancialAccountType,
  Main._BusinessArea AS _BusinessArea,
  Main._Segment AS _Segment,
  Main._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  Main._Supplier AS _Supplier,
  Main._Customer AS _Customer,
  Main._AccountingDocumentType AS _AccountingDocumentType,
  Main._ProfitCenter AS _ProfitCenter,
  Main._CurrentProfitCenter AS _CurrentProfitCenter
FROM I_PubSecCtrlObjCmtmtActlCube AS Main
;