P_ActualPlanGLAcctBalance2

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 P_ActualPlanGLAcctBalance2.
-- 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.

CREATE VIEW P_ActualPlanGLAcctBalance2 AS
SELECT
  I_GLAccountLineItem.SourceLedger AS SourceLedger,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  I_GLAccountLineItem.FiscalYear AS FiscalYear,
  I_GLAccountLineItem.AccountingDocument AS AccountingDocument,
  cast(cast( '00000000000000000000000' as abap.numc (23)) as fis_fp_request_tsn ) AS FinancialPlanningReqTransSqnc,
  cast(cast( '000000' as abap.numc (6)) as fis_fp_data_packet ) AS FinancialPlanningDataPacket,
  cast( I_GLAccountLineItem.LedgerGLLineItem as fis_act_pln_docln) AS ActualPlanJournalEntryItem,
  I_GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  cast(cast( 0 as abap.int4 ) as fis_fp_entry_item ) AS FinancialPlanningEntryItem,
  I_GLAccountLineItem.Ledger AS Ledger,
  I_GLAccountLineItem.LedgerFiscalYear AS LedgerFiscalYear,
  cast(cast( 'A' as abap.char (1)) as fis_actual_plan_code) AS ActualPlanCode,
  cast( 'ACT01 ' as fcom_category preserving type ) AS PlanningCategory,
  I_GLAccountLineItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountLineItem.ControllingArea AS ControllingArea,
  I_GLAccountLineItem.GLAccount AS GLAccount,
  I_GLAccountLineItem.CostCenter AS CostCenter,
  I_GLAccountLineItem.ProfitCenter AS ProfitCenter,
  I_GLAccountLineItem.BusinessArea AS BusinessArea,
  I_GLAccountLineItem.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItem.Segment AS Segment,
  I_GLAccountLineItem.Product AS Product,
  I_GLAccountLineItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  I_GLAccountLineItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  I_GLAccountLineItem.TransactionCurrency AS TransactionCurrency,
  I_GLAccountLineItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_GLAccountLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountLineItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAccountLineItem.GlobalCurrency AS GlobalCurrency,
  I_GLAccountLineItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAccountLineItem.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  I_GLAccountLineItem.CostSourceUnit AS CostSourceUnit,
  I_GLAccountLineItem.ValuationQuantity AS ValuationQuantity,
  cast( ' ' as fis_glaccount_flow_type preserving type ) AS GLAccountFlowType,
  cast( ' ' as fis_glacct_type_flow_type preserving type ) AS GLAccountTypeFlowType,
  I_GLAccountLineItem._GLAccountInChartOfAccounts.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  I_GLAccountLineItem.DebitCreditCode AS DebitCreditCode,
  case when I_GLAccountLineItem.FiscalPeriod > I_FiscalCalendarDate.FiscalPeriod then I_FiscalCalendarDate.FiscalPeriod else I_GLAccountLineItem.FiscalPeriod end as FiscalPeriod AS FiscalPeriodendasFiscalPeriod,
  I_GLAccountLineItem.FiscalYearVariant AS FiscalYearVariant,
  case when I_GLAccountLineItem.FiscalYearPeriod > I_FiscalCalendarDate.FiscalYearPeriod then I_FiscalCalendarDate.FiscalYearPeriod else I_GLAccountLineItem.FiscalYearPeriod end as FiscalYearPeriod AS FiscalYearPeriodendasFiscalYearPeriod,
  I_GLAccountLineItem.PostingDate AS PostingDate,
  I_GLAccountLineItem.GLAccountType AS GLAccountType,
  I_GLAccountLineItem.Supplier AS Supplier,
  I_GLAccountLineItem.Customer AS Customer,
  I_GLAccountLineItem.CalendarYear AS CalendarYear,
  I_GLAccountLineItem.CalendarQuarter AS CalendarQuarter,
  I_GLAccountLineItem.CalendarYearQuarter AS CalendarYearQuarter,
  I_GLAccountLineItem.CalendarMonth AS CalendarMonth,
  I_GLAccountLineItem.CalendarYearMonth AS CalendarYearMonth,
  I_GLAccountLineItem.CalendarWeek AS CalendarWeek,
  I_GLAccountLineItem.CalendarYearWeek AS CalendarYearWeek,
  I_GLAccountLineItem._FiscalCalendarDate.CalendarDate AS CalendarDate,
  I_GLAccountLineItem._FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  I_GLAccountLineItem._FiscalCalendarDate.FiscalWeek AS FiscalWeek,
  I_GLAccountLineItem._FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  I_GLAccountLineItem._FiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  I_GLAccountLineItem.FinancialManagementArea AS FinancialManagementArea,
  I_GLAccountLineItem.Fund AS Fund,
  I_GLAccountLineItem.GrantID AS GrantID,
  I_GLAccountLineItem.BudgetPeriod AS BudgetPeriod,
  I_GLAccountLineItem.OrderType AS OrderType,
  I_GLAccountLineItem.AssetClass AS AssetClass,
  I_GLAccountLineItem.FinancialAccountType AS FinancialAccountType,
  I_GLAccountLineItem.SalesOrganization AS SalesOrganization,
  I_GLAccountLineItem.DistributionChannel AS DistributionChannel,
  I_GLAccountLineItem.OrganizationDivision AS OrganizationDivision,
  I_GLAccountLineItem.ServiceDocumentType AS ServiceDocumentType,
  I_GLAccountLineItem.Plant AS Plant,
  I_GLAccountLineItem.ValuationArea AS ValuationArea,
  I_GLAccountLineItem.ServiceDocument AS ServiceDocument,
  I_GLAccountLineItem.ServiceDocumentItem AS ServiceDocumentItem,
  I_GLAccountLineItem.SalesDocument AS SalesDocument,
  I_GLAccountLineItem.MasterFixedAsset AS MasterFixedAsset,
  I_GLAccountLineItem.FixedAsset AS FixedAsset,
  I_GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItem.OrderID AS OrderID,
  I_GLAccountLineItem._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  I_GLAccountLineItem._BusinessArea AS _BusinessArea,
  I_GLAccountLineItem._ChartOfAccounts AS _ChartOfAccounts,
  I_GLAccountLineItem._CompanyCode AS _CompanyCode,
  I_GLAccountLineItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  I_GLAccountLineItem._ControllingArea AS _ControllingArea,
  I_GLAccountLineItem._CostCenter AS _CostCenter,
  I_GLAccountLineItem._CostSourceUnit AS _CostSourceUnit,
  I_GLAccountLineItem._CurrentCostCenter AS _CurrentCostCenter,
  I_GLAccountLineItem._CurrentProfitCenter AS _CurrentProfitCenter,
  I_GLAccountLineItem._DebitCreditCode AS _DebitCreditCode,
  I_GLAccountLineItem._FiscalCalendarDate AS _FiscalCalendarDate,
  I_GLAccountLineItem._FiscalYear AS _FiscalYear,
  I_GLAccountLineItem._FiscalYearVariant AS _FiscalYearVariant,
  I_GLAccountLineItem._FunctionalArea AS _FunctionalArea,
  I_GLAccountLineItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_GLAccountLineItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  I_GLAccountLineItem._GLAccountType AS _GLAccountType,
  I_GLAccountLineItem._GlobalCurrency AS _GlobalCurrency,
  I_GLAccountLineItem._JournalEntry AS _JournalEntry,
  I_GLAccountLineItem._Ledger AS _Ledger,
  I_GLAccountLineItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  I_GLAccountLineItem._ProfitCenter AS _ProfitCenter,
  I_GLAccountLineItem._Segment AS _Segment,
  I_GLAccountLineItem._SourceLedger AS _SourceLedger,
  I_GLAccountLineItem._TransactionCurrency AS Ledgerasfins_ledger_persasSourceLedger,
  I_FinancialPlanningEntryItem._TransactionCurrency AS _TransactionCurrency
FROM I_GLAccountLineItem
LEFT OUTER JOIN I_FiscalCalendarDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountFlowType AS _GLAccountFlowType ON GLAccountFlowType = _GLAccountFlowType.GLAccountFlowType  -- association [0..1]
LEFT OUTER JOIN I_GLAccountFlowTypeText AS _GLAccountFlowTypeText ON GLAccountFlowType = _GLAccountFlowTypeText.GLAccountFlowType  -- association [0..*]
LEFT OUTER JOIN I_GLAccountTypeFlowType AS _GLAccountTypeFlowType ON GLAccountTypeFlowType = _GLAccountTypeFlowType.GLAccountTypeFlowType  -- association [0..1]
LEFT OUTER JOIN I_GLAccountTypeFlowTypeTxt AS _GLAccountTypeFlowTypeTxt ON GLAccountTypeFlowType = _GLAccountTypeFlowTypeTxt.GLAccountTypeFlowType  -- association [0..*]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _BalanceTransactionCurrency ON BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _SourceLedger ON SourceLedger = _SourceLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_GLAccountType AS _GLAccountType ON GLAccountType = _GLAccountType.GLAccountType  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [0..1]
-- UNION ALL with additional select branch(es): I_FinancialPlanningEntryItem
;