P_ActualPlanGLAcctBalance

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_ActualPlanGLAcctBalance.
-- 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: PFIACTPLNGLBAL

CREATE VIEW P_ActualPlanGLAcctBalance AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  LedgerFiscalYear,
  ActualPlanCode,
  P_ActualPlanGLAcctBalance2.ChartOfAccounts AS ChartOfAccounts,
  ControllingArea,
  P_ActualPlanGLAcctBalance2.GLAccount AS GLAccount,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  Product,
  PlanningCategory,
  GLAccountFlowType,
  GLAccountTypeFlowType,
  IsBalanceSheetAccount,
  GLAccountType,
  DebitCreditCode,
  AccountingDocumentCategory,
  OrderType,
  AssetClass,
  FinancialAccountType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  ServiceDocumentType,
  Plant,
  ValuationArea,
  ServiceDocument,
  SalesDocument,
  MasterFixedAsset,
  FixedAsset,
  AccountingDocumentType,
  Customer,
  Supplier,
  OrderID,
  GLAccountHierarchy,
  HierarchyNode,
  SemanticTag,
  ValidityEndDate,
  ValidityStartDate,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  cast (0 as fis_hsl) AS HslwoBCF,
  cast (0 as fis_hsl) AS HslonlyBCF,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FixedAmountInGlobalCrcy,
  CostSourceUnit,
  ValuationQuantity,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  CalendarYear,
  CalendarQuarter,
  CalendarYearQuarter,
  CalendarMonth,
  CalendarYearMonth,
  CalendarWeek,
  CalendarYearWeek,
  CalendarDate,
  FiscalQuarter,
  FiscalWeek,
  FiscalYearQuarter,
  FiscalYearWeek,
  P_ActualPlanGLAcctBalance2._ChartOfAccounts AS _ChartOfAccounts,
  P_ActualPlanGLAcctBalance2._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts
FROM P_ActualPlanGLAcctBalance2
INNER JOIN I_SemTagGLAccount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalPeriod ON LedgerFiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod AND CompanyCode = _FiscalPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriodForVariant ON LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear AND FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod AND FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalYearPeriodForCoCode AS _FiscalYearPeriod ON FiscalYearPeriod = _FiscalYearPeriod.FiscalYearPeriod AND CompanyCode = _FiscalYearPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant ON FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod AND FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceDocument ON ServiceDocumentType = _ServiceDocument.ServiceDocumentType AND ServiceDocument = _ServiceDocument.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_PlanningCategory AS _PlanningCategory ON PlanningCategory = _PlanningCategory.PlanningCategory  -- association [0..1]
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;