I_PubSecBdgtActlItemBasic

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_PubSecBdgtActlItemBasic.
-- 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: IPSMS4CBDACTBSC

CREATE VIEW I_PubSecBdgtActlItemBasic AS
SELECT
  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.PlanningCategory AS PlanningCategory,
  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.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  AcItem.PartnerFund AS PartnerFund,
  AcItem.PartnerGrant AS PartnerGrant,
  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.PartnerOrder AS PartnerOrder,
  AcItem.PartnerOrder_2 AS PartnerOrder_2,
  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.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.GrantID AS GrantID,
  AcItem.SponsoredClass AS SponsoredClass,
  AcItem.SponsoredProgram AS SponsoredProgram,
  AcItem.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  AcItem.BudgetPeriod AS BudgetPeriod,
  _PubSecPlanningCategory.PlanningCategoryUsage AS PlanningCategoryUsage,
  AcItem.CashLedgerAccount AS CashLedgerAccount,
  AcItem.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  AcItem.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  AcItem.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  AcItem.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  AcItem.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  AcItem.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  cast( coalesce( AcItem.PubSecBudgetIsRelevant, ' ' ) as psm_bdgt_relevant preserving type ) 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._PubSecBudgetCnsmpnType AS _PubSecBdgtCnsmpnType,
  AcItem._PubSecBudgetCnsmpnAmtType 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._GlobalCurrency AS _GlobalCurrency,
  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._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._PartnerBusinessArea AS _PartnerBusinessArea,
  AcItem._PartnerCompany AS _PartnerCompany,
  AcItem._PartnerCompanyCode AS _PartnerCompanyCode,
  AcItem._PartnerCostCenter AS _PartnerCostCenter,
  AcItem._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType,
  AcItem._PartnerFunctionalArea AS _PartnerFunctionalArea,
  AcItem._PartnerFund AS _PartnerFund,
  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._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
FROM I_PubSecActlPlanJrnlEntryItm AS AcItem
LEFT OUTER JOIN I_PubSecPlanningCategory AS _PubSecPlanningCategory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PubSecBudgetAccount AS _PubSecBudgetAccountForBdgt ON CompanyCode = _PubSecBudgetAccountForBdgt.PubSecBudgetAccountCoCode AND GLAccount = _PubSecBudgetAccountForBdgt.PubSecBudgetAccount  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjProfileCurDate AS _CtrlObjProfileFm ON CompanyCode = _CtrlObjProfileFm.CompanyCode AND _CtrlObjProfileFm.BudgetScenario = ''  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjProfileCurDate AS _CtrlObjProfileGmi ON CompanyCode = _CtrlObjProfileGmi.CompanyCode AND _CtrlObjProfileGmi.BudgetScenario = 'GMI'  -- association [0..1]
LEFT OUTER JOIN I_PubSecCtrlObjProfileCurDate AS _CtrlObjProfileGme ON CompanyCode = _CtrlObjProfileGme.CompanyCode AND _CtrlObjProfileGme.BudgetScenario = 'GME'  -- association [0..1]
;