I_PubSecBdgtLineItemCube

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_PubSecBdgtLineItemCube.
-- 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: IPSMS4CBDLNANC

CREATE VIEW I_PubSecBdgtLineItemCube AS
SELECT
  AcItem.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  AcItem.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  AcItem.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  AcItem.ControllingArea AS ControllingArea,
  AcItem.CompanyCode AS CompanyCode,
  AcItem.Ledger AS Ledger,
  AcItem.GLAccount AS GLAccount,
  AcItem.ChartOfAccounts AS ChartOfAccounts,
  AcItem.FiscalYear AS FiscalYear,
  AcItem.LedgerFiscalYear AS LedgerFiscalYear,
  AcItem.BusinessTransactionType AS BusinessTransactionType,
  AcItem.FinancialTransactionType AS FinancialTransactionType,
  AcItem.BusinessArea AS BusinessArea,
  AcItem.ProfitCenter AS ProfitCenter,
  AcItem.CostCenter AS CostCenter,
  AcItem.ProjectInternalID AS ProjectInternalID,
  cast( _ProjectBasicData.ProjectExternalID as fis_projectext_no_conv preserving type ) AS ProjectExternalID,
  AcItem.PartnerProjectInternalID AS PartnerProjectInternalID,
  cast( _PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv preserving type ) AS PartnerProjectExternalID,
  cast( AcItem.WBSElementInternalID as fis_wbsint_no_conv preserving type ) AS WBSElementInternalID,
  cast( _WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv preserving type ) AS WBSElementExternalID,
  AcItem.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  cast( _PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv preserving type ) AS PartnerWBSElementExternalID,
  AcItem.FunctionalArea AS FunctionalArea,
  AcItem.Segment AS Segment,
  AcItem.CostCtrActivityType AS CostCtrActivityType,
  AcItem.CostAnalysisResource AS CostAnalysisResource,
  AcItem.WorkPackage AS WorkPackage,
  AcItem.WorkItem AS WorkItem,
  AcItem.IsLotSizeIndependent AS IsLotSizeIndependent,
  AcItem.PartnerCompanyCode AS PartnerCompanyCode,
  AcItem.PartnerBusinessArea AS PartnerBusinessArea,
  AcItem.PartnerSegment AS PartnerSegment,
  AcItem.PartnerProfitCenter AS PartnerProfitCenter,
  AcItem.PartnerCostCenter AS PartnerCostCenter,
  AcItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  AcItem.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  AcItem.OrderID AS OrderID,
  PartnerOrder,
  PartnerOrder_2,
  AcItem.PartnerCompany AS PartnerCompany,
  AcItem.ReferenceDocumentType AS ReferenceDocumentType,
  AcItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  AcItem.ReferenceDocument AS ReferenceDocument,
  AcItem.TransactionCurrency AS TransactionCurrency,
  AcItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  AcItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  AcItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  AcItem.GlobalCurrency AS GlobalCurrency,
  AcItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  AcItem.ControllingObjectCurrency AS ControllingObjectCurrency,
  AcItem.AmountInObjectCurrency AS AmountInObjectCurrency,
  AcItem.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  AcItem.CostSourceUnit AS CostSourceUnit,
  AcItem.ValuationQuantity AS ValuationQuantity,
  cast( AcItem.CostCenter as fis_cctr_hryid_42) AS CostCenterHierarchy,
  cast( AcItem.Fund as fmis_hryid_fund ) AS FundHierarchy,
  cast( AcItem._Grant.GrantID as gm_hryid_grant) AS GrantHierarchy,
  cast( AcItem.FunctionalArea as fis_hryid_functionalarea_42) AS FunctionalAreaHierarchy,
  cast (PubSecBudgetAccount as psm_hryid_budgetaccount ) AS BudgetAccountHierarchy,
  _PubSecBudgetAccount.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  AcItem.FiscalYearVariant AS FiscalYearVariant,
  AcItem.FiscalPeriod AS FiscalPeriod,
  AcItem.FiscalYearPeriod AS FiscalYearPeriod,
  AcItem.PostingDate AS PostingDate,
  AcItem.SalesDocument AS SalesDocument,
  AcItem.SalesDocumentItem AS SalesDocumentItem,
  AcItem.Plant AS Plant,
  AcItem.Product AS Product,
  AcItem.Customer AS Customer,
  AcItem.PlanningCategory AS PlanningCategory,
  AcItem.AccountAssignmentType AS AccountAssignmentType,
  AcItem.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  AcItem.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  AcItem.PersonnelNumber AS PersonnelNumber,
  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.FinancialManagementArea AS FinancialManagementArea,
  AcItem.Fund AS Fund,
  AcItem.GrantID AS GrantID,
  AcItem._Grant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  AcItem.SponsoredClass AS SponsoredClass,
  AcItem.SponsoredProgram AS SponsoredProgram,
  AcItem.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  AcItem.PubSecBudgetAccount AS PubSecBudgetAccount,
  AcItem.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  AcItem.BudgetPeriod AS BudgetPeriod,
  _PubSecBudgetAccount.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  AcItem._Fund.FundType AS FundType,
  AcItem._Fund._FundType.GranteeMgmtFundType AS GranteeMgmtFundType,
  AcItem.BudgetProcess AS BudgetProcess,
  AcItem.BudgetingType AS BudgetingType,
  AcItem.BudgetDocWorkFlowStatus AS BudgetDocWorkFlowStatus,
  AcItem.PubSecIsConsumableBudget AS PubSecIsConsumableBudget,
  AcItem.WorkCenterInternalID AS WorkCenterInternalID,
  AcItem.OrderOperation AS OrderOperation,
  AcItem.OrderItem AS OrderItem,
  AcItem.PlanPriceInGlobalCurrency AS PlanPriceInGlobalCurrency,
  AcItem.PlanPriceInCompanyCodeCurrency AS PlanPriceInCompanyCodeCurrency,
  AcItem.PlanPriceInTransactionCurrency AS PlanPriceInTransactionCurrency,
  AcItem.GLAccountAuthorizationGroup AS GLAccountAuthorizationGroup,
  AcItem.CustomerBasicAuthorizationGrp AS CustomerBasicAuthorizationGrp,
  AcItem.OrderType AS OrderType,
  AcItem.SalesOrderType AS SalesOrderType,
  AcItem.AssetDepreciationArea AS AssetDepreciationArea,
  AcItem.MasterFixedAsset AS MasterFixedAsset,
  AcItem.FixedAsset AS FixedAsset,
  AcItem.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  AcItem.AssetClass AS AssetClass,
  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._ControllingObjectCurrency AS _ControllingObjectCurrency,
  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._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._FixedAsset AS _FixedAsset,
  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._Grant._Sponsor AS _Sponsor,
  AcItem._InternalOrder AS _InternalOrder,
  AcItem._Ledger AS _Ledger,
  AcItem._LedgerFiscalYear AS _LedgerFiscalYear,
  AcItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  AcItem._MasterFixedAsset AS _MasterFixedAsset,
  AcItem._Order AS _Order,
  AcItem._OrganizationDivision AS _OrganizationDivision,
  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._PartnerOrder AS _PartnerOrder,
  AcItem._PartnerOrder_2 AS _PartnerOrder_2,
  AcItem._PartnerProfitCenter AS _PartnerProfitCenter,
  AcItem._PartnerProjectBasicData AS _PartnerProjectBasicData,
  AcItem._PartnerSegment AS _PartnerSegment,
  AcItem._PlanningCategory AS _PlanningCategory,
  AcItem._Plant AS _Plant,
  AcItem._Product AS _Product,
  AcItem._ProfitCenter AS _ProfitCenter,
  AcItem._ProjectBasicData AS _ProjectBasicData,
  AcItem._SalesDistrict AS _SalesDistrict,
  AcItem._SalesDocument AS _SalesDocument,
  AcItem._SalesDocumentItem AS _SalesDocumentItem,
  AcItem._SalesOrganization AS _SalesOrganization,
  AcItem._Segment AS _Segment,
  AcItem._SemTagGLAccount AS _SemTagGLAccount,
  AcItem._ShipToParty AS _ShipToParty,
  AcItem._SoldProduct AS _SoldProduct,
  AcItem._SponsoredClass AS _SponsoredClass,
  AcItem._SponsoredProgram AS _SponsoredProgram,
  AcItem._TransactionCurrency AS _TransactionCurrency,
  AcItem._WorkPackage AS _WorkPackage,
  AcItem._WorkPackageWorkItem AS _WorkPackageWorkItem,
  AcItem._WBSElementBasicData AS _WBSElementBasicData,
  AcItem._PartnerWBSElementBasicData AS _PartnerWBSElementBasicData
FROM I_PubSecBdgtLineItemBasic AS AcItem
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalIDText ON WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExternalID ON PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalID ON PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalIDText ON ProjectExternalID = _ProjectExternalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PubSecBudgetAccountCoCode ON PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PubSecBudgetAccount AS _PubSecBudgetAccount ON PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode AND PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount  -- 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_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- 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 GrantHierarchy = _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]
LEFT OUTER JOIN I_PubSecIsConsumableBudget AS _PubSecIsConsumableBudget ON PubSecIsConsumableBudget = _PubSecIsConsumableBudget.PubSecIsConsumableBudget  -- association [0..1]
;