I_PubSecCtrlObjCmtmtActlCube

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_PubSecCtrlObjCmtmtActlCube.
-- 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: IPSMS4CCOBJCAANC

CREATE VIEW I_PubSecCtrlObjCmtmtActlCube AS
SELECT
  AcItemA.Ledger AS Ledger,
  AcItemA.SourceLedger AS SourceLedger,
  AcItemA.CompanyCode AS CompanyCode,
  AcItemA.FiscalYear AS FiscalYear,
  AcItemA.AccountingDocument AS AccountingDocument,
  AcItemA.LedgerGLLineItem AS LedgerGLLineItem,
  AcItemA.FinancialManagementArea AS FinancialManagementArea,
  AcItemA.ControllingArea AS ControllingArea,
  AcItemA.Fund AS Fund,
  AcItemA.FunctionalArea AS FunctionalArea,
  AcItemA.BudgetPeriod AS BudgetPeriod,
  AcItemA.CostCenter AS CostCenter,
  AcItemA.WBSElementExternalID AS WBSElementExternalID,
  AcItemA.WBSElementInternalID AS WBSElementInternalID,
  AcItemA.PubSecBudgetAccount AS PubSecBudgetAccount,
  AcItemA.GrantID AS GrantID,
  AcItemA.SponsoredClass AS SponsoredClass,
  AcItemA.SponsoredProgram AS SponsoredProgram,
  AcItemA.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  AcItemA.PurchasingDocument AS PurchasingDocument,
  AcItemA.PurchasingDocumentItem AS PurchasingDocumentItem,
  AcItemA.AccountAssignmentNumber AS AccountAssignmentNumber,
  AcItemA.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  AcItemA.SourceLogicalSystem AS SourceLogicalSystem,
  AcItemA.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  AcItemA.SourceReferenceDocument AS SourceReferenceDocument,
  AcItemA.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  AcItemA.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  AcItemA.IsCommitment AS IsCommitment,
  AcItemA.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  AcItemA.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  AcItemA.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  AcItemA.FundType AS FundType,
  AcItemA.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  _CtrlObjProfile.AvailabilityControlProfile AS AvailabilityControlProfile,
  AcItemA.PurchaseOrder AS PurchaseOrder,
  AcItemA.PurchaseRequisition AS PurchaseRequisition,
  AcItemA.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  AcItemA.GlobalCurrency AS GlobalCurrency,
  AcItemA.PubSecExpnCmtmtAmtInGlobalCrcy AS PubSecExpnCmtmtAmtInGlobalCrcy,
  AcItemA.PubSecExpnActlAmtInGlobalCrcy AS PubSecExpnActlAmtInGlobalCrcy,
  AcItemA.PubSecRevnCmtmtAmtInGlobalCrcy AS PubSecRevnCmtmtAmtInGlobalCrcy,
  AcItemA.PubSecRevnActlAmtInGlobalCrcy AS PubSecRevnActlAmtInGlobalCrcy,
  AcItemA.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  AcItemA.FinancialAccountType AS FinancialAccountType,
  AcItemA.GLAccount AS GLAccount,
  AcItemA.BusinessArea AS BusinessArea,
  AcItemA.Segment AS Segment,
  AcItemA.Supplier AS Supplier,
  AcItemA.Customer AS Customer,
  AcItemA.AccountingDocumentType AS AccountingDocumentType,
  AcItemA.ProfitCenter AS ProfitCenter,
  AcItemA._BudgetPeriod AS _BudgetPeriod,
  AcItemA._CompanyCode AS _CompanyCode,
  AcItemA._ControllingArea AS _ControllingArea,
  AcItemA._CostCenter AS _CostCenter,
  AcItemA._CurrentCostCenter AS _CurrentCostCenter,
  AcItemA._FinancialAccountType AS _FinancialAccountType,
  AcItemA._FundType AS _FundType,
  AcItemA._BusinessArea AS _BusinessArea,
  AcItemA._Segment AS _Segment,
  AcItemA._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  AcItemA._Supplier AS _Supplier,
  AcItemA._Customer AS _Customer,
  AcItemA._AccountingDocumentType AS _AccountingDocumentType,
  AcItemA._ProfitCenter AS _ProfitCenter,
  AcItemA._CurrentProfitCenter AS _CurrentProfitCenter,
  AcItemA._FinancialManagementArea AS _FinancialManagementArea,
  AcItemA._Fund AS _Fund,
  AcItemA._FunctionalArea AS _FunctionalArea,
  AcItemA._GlobalCurrency AS _GlobalCurrency,
  AcItemA._JournalEntry AS _JournalEntry,
  AcItemA._Ledger AS _Ledger,
  AcItemA._PubSecBdgtAcctRevnExpnCode AS _PubSecBdgtAcctRevnExpnCode,
  AcItemA._PubSecBdgtCnsmpnType AS _PubSecBdgtCnsmpnType,
  AcItemA._PubSecBdgtCnsmpnAmtType AS _PubSecBdgtCnsmpnAmtType,
  AcItemA._SourceReferenceDocumentType AS _SourceReferenceDocumentType,
  AcItemA._SourceLedger AS _SourceLedger,
  AcItemA._WBSElementExternalID AS _WBSElementExternalID,
  AcItemA._FiscalYear AS _FiscalYear,
  AcItemA._Grant AS _Grant,
  AcItemA._SponsoredClass AS _SponsoredClass,
  AcItemA._SponsoredProgram AS _SponsoredProgram
FROM I_PubSecCmtmtActlItemCube AS AcItemA
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_PubSecCtrlObjGrant AS _CtrlObjGrant ON CtrlObjForGrant = _CtrlObjGrant.CtrlObjForGrant AND GrantHierarchy = _CtrlObjGrant.GrantHierarchy  -- 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_PubSecCtrlObjSpnsrdClass AS _CtrlObjSpnsrdClass ON CtrlObjForSponsoredClass = _CtrlObjSpnsrdClass.CtrlObjForSponsoredClass AND SponsoredClassHierarchy = _CtrlObjSpnsrdClass.SponsoredClassHierarchy  -- 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_PubSecCtrlObjSpnsrdProg AS _CtrlObjSpnsrdProg ON CtrlObjForSponsoredProgram = _CtrlObjSpnsrdProg.CtrlObjForSponsoredProgram AND SponsoredProgramHierarchy = _CtrlObjSpnsrdProg.SponsoredProgramHierarchy  -- 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_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_FiscCalendarDateForCompCode AS _PubSecBudgetCnsmpnDate ON PubSecBudgetCnsmpnDate = _PubSecBudgetCnsmpnDate.CalendarDate AND CompanyCode = _PubSecBudgetCnsmpnDate.CompanyCode  -- 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]
;