I_PubSecBdgtActlItemCube

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_PubSecBdgtActlItemCube.
-- 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: IPSMS4CBDACTANC

CREATE VIEW I_PubSecBdgtActlItemCube AS
SELECT
  PartnerOrder,
  PartnerOrder_2,
  cast( AcItem.CostCenter as fis_cctr_hryid_42) AS CostCenterHierarchy,
  cast(AcItem._Fund.Fund as fmis_hryid_fund ) AS FundHierarchy,
  cast (AcItem.GrantID as gm_hrynid_grant) AS GrantHierarchyNode,
  cast( AcItem.FunctionalArea as fis_hryid_functionalarea_42) AS FunctionalAreaHierarchy,
  cast (PubSecBudgetAccount as psm_hryid_budgetaccount ) AS BudgetAccountHierarchy,
  AcItem._Grant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  AcItem._PubSecBdgtCnsmpnType.PubSecBudgetCnsmpnTypeGroup AS PubSecBudgetCnsmpnTypeGroup,
  AcItem._Fund.FundType AS FundType,
  AcItem._Fund._FundType.GranteeMgmtFundType AS GranteeMgmtFundType,
  AcItem._PubSecBdgtCnsmpnType._PubSecBudgetCnsmpnTypeGroup AS _PubSecBudgetCnsmpnTypeGroup,
  AcItem._Grant._Sponsor AS _Sponsor,
  AcItem.SourceLedger AS SourceLedger,
  AcItem.Ledger AS Ledger,
  AcItem.CompanyCode AS CompanyCode,
  AcItem.FiscalYear AS FiscalYear,
  AcItem.AccountingDocument AS AccountingDocument,
  AcItem.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  AcItem.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  AcItem.ActualPlanJournalEntryItem AS ActualPlanJournalEntryItem,
  AcItem.LedgerGLLineItem AS LedgerGLLineItem,
  AcItem.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  AcItem.LedgerFiscalYear AS LedgerFiscalYear,
  AcItem.ControllingArea AS ControllingArea,
  AcItem.GLAccount AS GLAccount,
  AcItem.ChartOfAccounts AS ChartOfAccounts,
  AcItem.ActualPlanCode AS ActualPlanCode,
  AcItem.BusinessArea AS BusinessArea,
  AcItem.ProfitCenter AS ProfitCenter,
  AcItem.CostCenter AS CostCenter,
  AcItem.ProjectInternalID AS ProjectInternalID,
  AcItem.ProjectExternalID AS ProjectExternalID,
  AcItem.PartnerProjectInternalID AS PartnerProjectInternalID,
  AcItem.PartnerProjectExternalID AS PartnerProjectExternalID,
  AcItem.WBSElementInternalID AS WBSElementInternalID,
  AcItem.WBSElementExternalID AS WBSElementExternalID,
  AcItem.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  AcItem.PartnerWBSElementExternalID AS PartnerWBSElementExternalID,
  AcItem.FunctionalArea AS FunctionalArea,
  AcItem.Segment AS Segment,
  AcItem.CostCtrActivityType AS CostCtrActivityType,
  AcItem.CostAnalysisResource AS CostAnalysisResource,
  AcItem.OrderID AS OrderID,
  AcItem.WorkPackage AS WorkPackage,
  AcItem.WorkItem AS WorkItem,
  AcItem.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  AcItem.PartnerCompanyCode AS PartnerCompanyCode,
  AcItem.PartnerBusinessArea AS PartnerBusinessArea,
  AcItem.PartnerProfitCenter AS PartnerProfitCenter,
  AcItem.PartnerCostCenter AS PartnerCostCenter,
  AcItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  AcItem.PartnerSegment AS PartnerSegment,
  AcItem.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  AcItem.PartnerCompany AS PartnerCompany,
  AcItem.OriginProfitCenter AS OriginProfitCenter,
  AcItem.OriginCostCenter AS OriginCostCenter,
  AcItem.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  AcItem.ReferenceDocumentType AS ReferenceDocumentType,
  AcItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  AcItem.ReferenceDocument AS ReferenceDocument,
  AcItem.BusinessTransactionType AS BusinessTransactionType,
  AcItem.FinancialTransactionType AS FinancialTransactionType,
  AcItem.AccountingDocumentType AS AccountingDocumentType,
  AcItem.FinancialAccountType AS FinancialAccountType,
  AcItem.PostingDate AS PostingDate,
  AcItem.FiscalPeriod AS FiscalPeriod,
  AcItem.FiscalYearPeriod AS FiscalYearPeriod,
  AcItem.FiscalYearVariant AS FiscalYearVariant,
  AcItem.PlanningCategory AS PlanningCategory,
  AcItem.ServicesRenderedDate AS ServicesRenderedDate,
  AcItem.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  AcItem.AccountAssignmentType AS AccountAssignmentType,
  AcItem.PersonnelNumber AS PersonnelNumber,
  AcItem.ValuationArea AS ValuationArea,
  AcItem.Plant AS Plant,
  AcItem.Product AS Product,
  AcItem.Customer AS Customer,
  AcItem.Supplier AS Supplier,
  AcItem.SalesDocument AS SalesDocument,
  AcItem.SalesDocumentItem AS SalesDocumentItem,
  AcItem.ServiceDocument AS ServiceDocument,
  AcItem.ServiceDocumentType AS ServiceDocumentType,
  AcItem.ServiceDocumentItem AS ServiceDocumentItem,
  AcItem.ServiceContractType AS ServiceContractType,
  AcItem.ServiceContract AS ServiceContract,
  AcItem.ServiceContractItem AS ServiceContractItem,
  AcItem.BillingDocumentType AS BillingDocumentType,
  AcItem.SalesOrganization AS SalesOrganization,
  AcItem.DistributionChannel AS DistributionChannel,
  AcItem.OrganizationDivision AS OrganizationDivision,
  AcItem.SoldProduct AS SoldProduct,
  AcItem.CustomerGroup AS CustomerGroup,
  AcItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  AcItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  AcItem.SalesDistrict AS SalesDistrict,
  AcItem.BillToParty AS BillToParty,
  AcItem.ShipToParty AS ShipToParty,
  AcItem.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  AcItem.IsStatisticalOrder AS IsStatisticalOrder,
  AcItem.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  AcItem.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
  AcItem.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  AcItem.WorkCenterInternalID AS WorkCenterInternalID,
  AcItem.OrderOperation AS OrderOperation,
  AcItem.OrderItem AS OrderItem,
  AcItem.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  AcItem.SourceLogicalSystem AS SourceLogicalSystem,
  AcItem.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  AcItem.SourceReferenceDocument AS SourceReferenceDocument,
  AcItem.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  AcItem.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  AcItem.IsCommitment AS IsCommitment,
  AcItem.FinancialManagementArea AS FinancialManagementArea,
  AcItem.Fund AS Fund,
  AcItem.PartnerFund AS PartnerFund,
  AcItem.GrantID AS GrantID,
  AcItem.SponsoredClass AS SponsoredClass,
  AcItem.SponsoredProgram AS SponsoredProgram,
  AcItem.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  AcItem.PartnerGrant AS PartnerGrant,
  AcItem.BudgetPeriod AS BudgetPeriod,
  AcItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  AcItem.CashLedgerAccount AS CashLedgerAccount,
  AcItem.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  AcItem.PubSecBudgetAccount AS PubSecBudgetAccount,
  AcItem.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  AcItem.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  AcItem.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  AcItem.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  AcItem.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  AcItem.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  AcItem.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  AcItem.BudgetProcess AS BudgetProcess,
  AcItem.BudgetingType AS BudgetingType,
  AcItem.BudgetDocWorkFlowStatus AS BudgetDocWorkFlowStatus,
  AcItem.TransactionCurrency AS TransactionCurrency,
  AcItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  AcItem.GlobalCurrency AS GlobalCurrency,
  AcItem.CostSourceUnit AS CostSourceUnit,
  AcItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  AcItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  AcItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  AcItem.ValuationQuantity AS ValuationQuantity,
  AcItem.ActualAmountInTransactionCrcy AS ActualAmountInTransactionCrcy,
  AcItem.ActualAmountInCompanyCodeCrcy AS ActualAmountInCompanyCodeCrcy,
  AcItem.ActualAmountInGlobalCurrency AS ActualAmountInGlobalCurrency,
  AcItem.ActualValuationQuantity AS ActualValuationQuantity,
  AcItem.PlanAmountInTransactionCrcy AS PlanAmountInTransactionCrcy,
  AcItem.PlanAmountInCompanyCodeCrcy AS PlanAmountInCompanyCodeCrcy,
  AcItem.PlanAmountInGlobalCurrency AS PlanAmountInGlobalCurrency,
  AcItem.PlanValuationQuantity AS PlanValuationQuantity,
  AcItem.PlanPriceInCompanyCodeCurrency AS PlanPriceInCompanyCodeCurrency,
  AcItem.PlanPriceInTransactionCurrency AS PlanPriceInTransactionCurrency,
  AcItem.PlanPriceInGlobalCurrency AS PlanPriceInGlobalCurrency,
  AcItem.ActlPlnDiffAmtInTransCrcy AS ActlPlnDiffAmtInTransCrcy,
  AcItem.ActlPlnDiffAmtInCoCodeCrcy AS ActlPlnDiffAmtInCoCodeCrcy,
  AcItem.ActlPlnDiffAmtInGlobalCrcy AS ActlPlnDiffAmtInGlobalCrcy,
  AcItem.ActlPanDiffValuationQuantity AS ActlPanDiffValuationQuantity,
  AcItem.GLAccountAuthorizationGroup AS GLAccountAuthorizationGroup,
  AcItem.SupplierBasicAuthorizationGrp AS SupplierBasicAuthorizationGrp,
  AcItem.CustomerBasicAuthorizationGrp AS CustomerBasicAuthorizationGrp,
  AcItem.AcctgDocTypeAuthorizationGroup AS AcctgDocTypeAuthorizationGroup,
  AcItem.OrderType AS OrderType,
  AcItem.SalesOrderType AS SalesOrderType,
  AcItem.AssetClass AS AssetClass,
  AcItem._CashLedgerAccount AS _CashLedgerAccount,
  AcItem._CashLedgerCompanyCode AS _CashLedgerCompanyCode,
  AcItem._PubSecBdgtCnsmpnType AS _PubSecBdgtCnsmpnType,
  AcItem._PubSecBdgtCnsmpnAmtType AS _PubSecBdgtCnsmpnAmtType,
  AcItem._AccountingDocumentType AS _AccountingDocumentType,
  AcItem._BillingDocumentType AS _BillingDocumentType,
  AcItem._BillToParty AS _BillToParty,
  AcItem._BudgetingType AS _BudgetingType,
  AcItem._BudgetPeriod AS _BudgetPeriod,
  AcItem._BudgetProcess AS _BudgetProcess,
  AcItem._BusinessArea AS _BusinessArea,
  AcItem._BusinessTransactionType AS _BusinessTransactionType,
  AcItem._CalendarDate AS _CalendarDate,
  AcItem._ChartOfAccounts AS _ChartOfAccounts,
  AcItem._CompanyCode AS _CompanyCode,
  AcItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  AcItem._ControllingArea AS _ControllingArea,
  AcItem._ControllingDebitCreditCode AS _ControllingDebitCreditCode,
  AcItem._CostAnalysisResource AS _CostAnalysisResource,
  AcItem._CostCenter AS _CostCenter,
  AcItem._CostCtrActivityType AS _CostCtrActivityType,
  AcItem._CostSourceUnit AS _CostSourceUnit,
  AcItem._CurrentCostCenter AS _CurrentCostCenter,
  AcItem._CurrentProfitCenter AS _CurrentProfitCenter,
  AcItem._Customer AS _Customer,
  AcItem._CustomerGroup AS _CustomerGroup,
  AcItem._CustomerSupplierCountry AS _CustomerSupplierCountry,
  AcItem._CustomerSupplierIndustryText AS _CustomerSupplierIndustryText,
  AcItem._DistributionChannel AS _DistributionChannel,
  AcItem._Employment AS _Employment,
  AcItem._FinancialAccountType AS _FinancialAccountType,
  AcItem._FinancialManagementArea AS _FinancialManagementArea,
  AcItem._FinancialTransactionType AS _FinancialTransactionType,
  AcItem._FiscalCalendarDate AS _FiscalCalendarDate,
  AcItem._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  AcItem._FiscalYear AS _FiscalYear,
  AcItem._FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant,
  AcItem._FiscalYearVariant AS _FiscalYearVariant,
  AcItem._FunctionalArea AS _FunctionalArea,
  AcItem._Fund AS _Fund,
  AcItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  AcItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  AcItem._GlobalCurrency AS _GlobalCurrency,
  AcItem._Grant AS _Grant,
  AcItem._InternalOrder AS _InternalOrder,
  AcItem._JournalEntry AS _JournalEntry,
  AcItem._Ledger AS _Ledger,
  AcItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  AcItem._Order AS _Order,
  AcItem._OrganizationDivision AS _OrganizationDivision,
  AcItem._OriginCostCenter AS _OriginCostCenter,
  AcItem._OriginCostCtrActivityType AS _OriginCostCtrActivityType,
  AcItem._OriginProfitCenter AS _OriginProfitCenter,
  AcItem._PartnerBudgetPeriod AS _PartnerBudgetPeriod,
  AcItem._PartnerFund AS _PartnerFund,
  AcItem._PartnerBusinessArea AS _PartnerBusinessArea,
  AcItem._PartnerCompany AS _PartnerCompany,
  AcItem._PartnerCompanyCode AS _PartnerCompanyCode,
  AcItem._PartnerCostCenter AS _PartnerCostCenter,
  AcItem._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType,
  AcItem._PartnerFunctionalArea AS _PartnerFunctionalArea,
  AcItem._PartnerGrant AS _PartnerGrant,
  AcItem._PartnerOrder AS _PartnerOrder,
  AcItem._PartnerOrder_2 AS _PartnerOrder_2,
  AcItem._PartnerProfitCenter AS _PartnerProfitCenter,
  AcItem._PartnerProjectBasicData AS _PartnerProjectBasicData,
  AcItem._PartnerProjectExternalID AS _PartnerProjectExternalID,
  AcItem._PartnerSegment AS _PartnerSegment,
  AcItem._PartnerWBSElementBasicData AS _PartnerWBSElementBasicData,
  AcItem._PartnerWBSElementExternalID AS _PartnerWBSElementExternalID,
  AcItem._PlanningCategory AS _PlanningCategory,
  AcItem._Plant AS _Plant,
  AcItem._Product AS _Product,
  AcItem._ProfitCenter AS _ProfitCenter,
  AcItem._ProjectBasicData AS _ProjectBasicData,
  AcItem._ProjectExternalID AS _ProjectExternalID,
  AcItem._ProjectExternalIDText AS _ProjectExternalIDText,
  AcItem._SalesDistrict AS _SalesDistrict,
  AcItem._SalesDocument AS _SalesDocument,
  AcItem._SalesDocumentItem AS _SalesDocumentItem,
  AcItem._ServiceDocument AS _ServiceDocument,
  AcItem._ServiceDocumentType AS _ServiceDocumentType,
  AcItem._ServiceDocumentItem AS _ServiceDocumentItem,
  AcItem._ServiceContractType AS _ServiceContractType,
  AcItem._ServiceContract AS _ServiceContract,
  AcItem._ServiceContractItem AS _ServiceContractItem,
  AcItem._SalesOrganization AS _SalesOrganization,
  AcItem._Segment AS _Segment,
  AcItem._SemTagGLAccount AS _SemTagGLAccount,
  AcItem._ShipToParty AS _ShipToParty,
  AcItem._SoldProduct AS _SoldProduct,
  AcItem._SourceLedger AS _SourceLedger,
  AcItem._Supplier AS _Supplier,
  AcItem._TransactionCurrency AS _TransactionCurrency,
  AcItem._WBSElementBasicData AS _WBSElementBasicData,
  AcItem._WBSElementExternalID AS _WBSElementExternalID,
  AcItem._WorkCenter AS _WorkCenter,
  AcItem._WorkPackage AS _WorkPackage,
  AcItem._WorkPackageWorkItem AS _WorkPackageWorkItem,
  _CtrlObjProfile.AvailabilityControlProfile AS AvailabilityControlProfile,
  _PubSecBudgetAccount.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode
FROM I_PubSecBdgtActlItemBasic AS AcItem
LEFT OUTER JOIN I_PubSecBudgetAccount AS _PubSecBudgetAccount ON PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode AND PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PubSecBudgetAccountCoCode ON PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscCalendarDateForCompCode AS _PubSecBudgetCnsmpnDate ON PubSecBudgetCnsmpnDate = _PubSecBudgetCnsmpnDate.CalendarDate AND PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnDate.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForVariant AS _PubSecBdgtCnsmpnFsclYear ON PubSecBudgetCnsmpnFsclYear = _PubSecBdgtCnsmpnFsclYear.FiscalYear AND FiscalYearVariant = _PubSecBdgtCnsmpnFsclYear.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _PubSecBdgtCnsmpnFsclPeriod ON PubSecBudgetCnsmpnFsclYear = _PubSecBdgtCnsmpnFsclPeriod.FiscalYear AND PubSecBudgetCnsmpnFsclPeriod = _PubSecBdgtCnsmpnFsclPeriod.FiscalPeriod AND FiscalYearVariant = _PubSecBdgtCnsmpnFsclPeriod.FiscalYearVariant  -- association [0..1]
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_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_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_PubSecBdgtAcctRevnExpnCode AS _PubSecBdgtAcctRevnExpnCode ON PubSecBdgtAcctRevnExpnCode = _PubSecBdgtAcctRevnExpnCode.PubSecBdgtAcctRevnExpnCode  -- association [0..1]
LEFT OUTER JOIN I_FundType AS _FundType ON FinancialManagementArea = _FundType.FinancialManagementArea AND FundType = _FundType.FundType  -- association [0..1]
LEFT OUTER JOIN I_BudgetAccountInChtAccts AS _BudgetAccountInChtAccts ON ChartOfAccounts = _BudgetAccountInChtAccts.ChartOfAccounts AND PubSecBudgetAccount = _BudgetAccountInChtAccts.PubSecBudgetAccount  -- association [0..1]
LEFT OUTER JOIN I_PubSecAvailyCtrlProfile AS _PubSecAvailyCtrlProfile ON AvailabilityControlProfile = _PubSecAvailyCtrlProfile.AvailabilityControlProfile  -- association [0..1]
LEFT OUTER JOIN I_GranteeMgmtFundType AS _GranteeMgmtFundType ON GranteeMgmtFundType = _GranteeMgmtFundType.GranteeMgmtFundType association[0..1] to I_Fund as _FundHierarchy on FinancialManagementArea = _FundHierarchy.FinancialManagementArea AND FundHierarchy = _FundHierarchy.Fund  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _GrantHierarchy ON GrantHierarchyNode = _GrantHierarchy.GrantID  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenterHierarchy ON ControllingArea = _CostCenterHierarchy.ControllingArea AND CostCenterHierarchy = _CostCenterHierarchy.CostCenter association[0..1] to I_BudgetAccountInChtAccts as _BudgetAccountInChtAcctsHier on ChartOfAccounts = _BudgetAccountInChtAcctsHier.ChartOfAccounts AND BudgetAccountHierarchy = _BudgetAccountInChtAcctsHier.PubSecBudgetAccount  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalAreaHierarchy ON FunctionalAreaHierarchy = _FunctionalAreaHierarchy.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_BudgetDocWorkFlowStatus AS _BudgetDocWorkFlowStatus ON BudgetDocWorkFlowStatus = _BudgetDocWorkFlowStatus.BudgetDocWorkFlowStatus  -- association [0..1]
;