P_GLAccountBalance_F0707A_FL

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_GLAccountBalance_F0707A_FL.
-- 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_GLAccountBalance_F0707A_FL AS
SELECT
  I_GLAccountLineItemRawData.SourceLedger AS SourceLedger,
  I_GLAccountLineItemRawData.CompanyCode AS CompanyCode,
  I_GLAccountLineItemRawData.FiscalYear AS FiscalYear,
  I_GLAccountLineItemRawData.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItemRawData.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAccountLineItemRawData.SourceLedger AS Ledger,
  cast( I_GLAccountLineItemRawData.GLRecordType as fis_rrcty_act ) AS GLRecordType,
  I_GLAccountLineItemRawData.FiscalYearVariant AS FiscalYearVariant,
  I_GLAccountLineItemRawData.LedgerFiscalYear AS LedgerFiscalYear,
  I_GLAccountLineItemRawData.FiscalYearPeriod AS FiscalYearPeriod,
  I_GLAccountLineItemRawData.FiscalPeriod AS FiscalPeriod,
  I_GLAccountLineItemRawData.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountLineItemRawData.GLAccount AS GLAccount,
  I_GLAccountLineItemRawData.ControllingArea AS ControllingArea,
  I_GLAccountLineItemRawData.ProfitCenter AS ProfitCenter,
  I_GLAccountLineItemRawData.Segment AS Segment,
  I_GLAccountLineItemRawData.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItemRawData.BusinessArea AS BusinessArea,
  I_GLAccountLineItemRawData.DebitCreditCode AS DebitCreditCode,
  I_GLAccountLineItemRawData.FinancialAccountType AS FinancialAccountType,
  I_GLAccountLineItemRawData.Supplier AS Supplier,
  I_GLAccountLineItemRawData.Customer AS Customer,
  I_GLAccountLineItemRawData.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItemRawData.CostCenter AS CostCenter,
  I_GLAccountLineItemRawData.SalesDocument AS SalesDocument,
  I_GLAccountLineItemRawData.SalesOrganization AS SalesOrganization,
  I_GLAccountLineItemRawData.DistributionChannel AS DistributionChannel,
  I_GLAccountLineItemRawData.OrganizationDivision AS OrganizationDivision,
  I_GLAccountLineItemRawData.Plant AS Plant,
  I_GLAccountLineItemRawData.ValuationArea AS ValuationArea,
  I_GLAccountLineItemRawData.MasterFixedAsset AS MasterFixedAsset,
  I_GLAccountLineItemRawData.FixedAsset AS FixedAsset,
  I_GLAccountLineItemRawData.OrderID AS OrderID,
  I_GLAccountLineItemRawData.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( AmountInCompanyCodeCurrency as fis_bal_hsl preserving type ) AS BalAmtInCompanyCodeCrcy,
  cast( cast( '0' as abap.curr( 23,2)) as fis_end_bal_hsl_ui ) AS EndingBalanceAmtInCoCodeCrcy,
  I_GLAccountLineItemRawData.GlobalCurrency AS GlobalCurrency,
  cast( AmountInGlobalCurrency as fis_bal_ksl preserving type ) AS BalanceAmountInGlobalCrcy,
  cast( cast( '0' as abap.curr( 23,2)) as fis_end_bal_ksl_ui ) AS EndingBalanceAmtInGlobalCrcy,
  I_GLAccountLineItemRawData.FunctionalCurrency AS FunctionalCurrency,
  cast( AmountInFunctionalCurrency as fis_bal_fcsl preserving type ) AS BalanceAmountInFunctionalCrcy,
  cast( cast( '0' as abap.curr( 23,2)) as fis_end_bal_fcsl_ui ) AS EndingBalanceAmtInFuncnlCrcy,
  I_GLAccountLineItemRawData.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  cast( AmountInFreeDefinedCurrency1 as fis_bal_osl preserving type ) AS BalanceAmountInFreeDfndCrcy1,
  cast( cast( '0' as abap.curr( 23,2)) as fis_end_bal_osl_ui ) AS EndingBalAmtInFreeDfndCrcy1,
  I_GLAccountLineItemRawData.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  cast( AmountInFreeDefinedCurrency2 as fis_bal_vsl preserving type ) AS BalanceAmountInFreeDfndCrcy2,
  cast( cast( '0' as abap.curr( 23,2)) as fis_end_bal_vsl_ui ) AS EndingBalAmtInFreeDfndCrcy2,
  I_GLAccountLineItemRawData.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  cast( AmountInFreeDefinedCurrency3 as fis_bal_bsl preserving type ) AS BalanceAmountInFreeDfndCrcy3,
  cast( cast( '0' as abap.curr( 23,2)) as fis_end_bal_bsl_ui ) AS EndingBalAmtInFreeDfndCrcy3,
  I_GLAccountLineItemRawData.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  cast( AmountInFreeDefinedCurrency4 as fis_bal_csl preserving type ) AS BalanceAmountInFreeDfndCrcy4,
  cast( cast( '0' as abap.curr( 23,2)) as fis_end_bal_csl_ui ) AS EndingBalAmtInFreeDfndCrcy4,
  I_GLAccountLineItemRawData.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  cast( AmountInFreeDefinedCurrency5 as fis_bal_dsl preserving type ) AS BalanceAmountInFreeDfndCrcy5,
  cast( cast( '0' as abap.curr( 23,2)) as fis_end_bal_dsl_ui ) AS EndingBalAmtInFreeDfndCrcy5,
  I_GLAccountLineItemRawData.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  cast( AmountInFreeDefinedCurrency6 as fis_bal_esl preserving type ) AS BalanceAmountInFreeDfndCrcy6,
  cast( cast( '0' as abap.curr( 23,2)) as fis_end_bal_esl_ui ) AS EndingBalAmtInFreeDfndCrcy6,
  I_GLAccountLineItemRawData.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  cast( AmountInFreeDefinedCurrency7 as fis_bal_fsl preserving type ) AS BalanceAmountInFreeDfndCrcy7,
  cast( cast( '0' as abap.curr( 23,2)) as fis_end_bal_fsl_ui ) AS EndingBalAmtInFreeDfndCrcy7,
  I_GLAccountLineItemRawData.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  cast( AmountInFreeDefinedCurrency8 as fis_bal_gsl preserving type ) AS BalanceAmountInFreeDfndCrcy8,
  cast( cast( '0' as abap.curr( 23,2)) as fis_end_bal_gsl_ui ) AS EndingBalAmtInFreeDfndCrcy8,
  cast( cast( ' ' as abap.char(1)) as fis_xnotpostedto ) AS IsNotPostedTo,
  I_GLAccountLineItemRawData._CompanyCode AS _CompanyCode,
  I_GLAccountLineItemRawData._FiscalYear AS _FiscalYear,
  I_GLAccountLineItemRawData._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  I_GLAccountLineItemRawData._FiscalYearVariant AS _FiscalYearVariant,
  I_GLAccountLineItemRawData._JournalEntry AS _JournalEntry,
  I_GLAccountLineItemRawData._Segment AS _Segment,
  I_GLAccountLineItemRawData._ProfitCenter AS _ProfitCenter,
  I_GLAccountLineItemRawData._CostCenter AS _CostCenter,
  I_GLAccountLineItemRawData._BusinessArea AS _BusinessArea,
  I_GLAccountLineItemRawData._FunctionalArea AS _FunctionalArea,
  I_GLAccountLineItemRawData._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  I_GLAccountLineItemRawData._ChartOfAccounts AS _ChartOfAccounts,
  I_GLAccountLineItemRawData._DebitCreditCode AS _DebitCreditCode,
  I_GLAccountLineItemRawData._CompanyCodeCurrency AS _CompanyCodeCurrency,
  I_GLAccountLineItemRawData._GlobalCurrency AS _GlobalCurrency,
  I_GLAccountLineItemRawData._FunctionalCurrency AS _FunctionalCurrency,
  I_GLAccountLineItemRawData._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  I_GLAccountLineItemRawData._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  I_GLAccountLineItemRawData._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  I_GLAccountLineItemRawData._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  I_GLAccountLineItemRawData._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  I_GLAccountLineItemRawData._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  I_GLAccountLineItemRawData._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  I_GLAccountLineItemRawData._FreeDefinedCurrency8 AS _FreeDefinedCurrency8
FROM I_GLAccountLineItemRawData
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _SourceLedger ON SourceLedger = _SourceLedger.Ledger  -- association [1..1]
;