C_GLAccountBalance_F0707A

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 C_GLAccountBalance_F0707A.
-- 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 C_GLAccountBalance_F0707A AS
SELECT
  SourceLedger,
  Ledger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  GLRecordType,
  cast( _CompanyCode.CompanyCodeName as fis_butxt preserving type ) AS CompanyCodeName,
  FiscalYearVariant,
  LedgerFiscalYear,
  FiscalYearPeriod,
  FiscalPeriod,
  ChartOfAccounts,
  GLAccount,
  cast( _GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountLongName as fis_txt50_skat preserving type ) AS GLAccountLongName,
  ControllingArea,
  cast( _ControllingArea.ControllingAreaName as fis_kokrs_name preserving type ) AS ControllingAreaName,
  ProfitCenter,
  Segment,
  FunctionalArea,
  BusinessArea,
  DebitCreditCode,
  FinancialAccountType,
  Supplier,
  Customer,
  AccountingDocumentType,
  CostCenter,
  SalesDocument,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  Plant,
  ValuationArea,
  MasterFixedAsset,
  FixedAsset,
  OrderID,
  CompanyCodeCurrency,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  BalAmtInCompanyCodeCrcy,
  EndingBalanceAmtInCoCodeCrcy,
  GlobalCurrency,
  DebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy,
  BalanceAmountInGlobalCrcy,
  EndingBalanceAmtInGlobalCrcy,
  FunctionalCurrency,
  DebitAmountInFunctionalCrcy,
  CreditAmountInFunctionalCrcy,
  BalanceAmountInFunctionalCrcy,
  EndingBalanceAmtInFuncnlCrcy,
  FreeDefinedCurrency1,
  DebitAmountInFreeDfndCrcy1,
  CreditAmountInFreeDfndCrcy1,
  BalanceAmountInFreeDfndCrcy1,
  EndingBalAmtInFreeDfndCrcy1,
  FreeDefinedCurrency2,
  DebitAmountInFreeDfndCrcy2,
  CreditAmountInFreeDfndCrcy2,
  BalanceAmountInFreeDfndCrcy2,
  EndingBalAmtInFreeDfndCrcy2,
  FreeDefinedCurrency3,
  DebitAmountInFreeDfndCrcy3,
  CreditAmountInFreeDfndCrcy3,
  BalanceAmountInFreeDfndCrcy3,
  EndingBalAmtInFreeDfndCrcy3,
  FreeDefinedCurrency4,
  DebitAmountInFreeDfndCrcy4,
  CreditAmountInFreeDfndCrcy4,
  BalanceAmountInFreeDfndCrcy4,
  EndingBalAmtInFreeDfndCrcy4,
  FreeDefinedCurrency5,
  DebitAmountInFreeDfndCrcy5,
  CreditAmountInFreeDfndCrcy5,
  BalanceAmountInFreeDfndCrcy5,
  EndingBalAmtInFreeDfndCrcy5,
  FreeDefinedCurrency6,
  DebitAmountInFreeDfndCrcy6,
  CreditAmountInFreeDfndCrcy6,
  BalanceAmountInFreeDfndCrcy6,
  EndingBalAmtInFreeDfndCrcy6,
  FreeDefinedCurrency7,
  DebitAmountInFreeDfndCrcy7,
  CreditAmountInFreeDfndCrcy7,
  BalanceAmountInFreeDfndCrcy7,
  EndingBalAmtInFreeDfndCrcy7,
  FreeDefinedCurrency8,
  DebitAmountInFreeDfndCrcy8,
  CreditAmountInFreeDfndCrcy8,
  BalanceAmountInFreeDfndCrcy8,
  EndingBalAmtInFreeDfndCrcy8,
  IsNotPostedTo
FROM P_GLAccountBalance_F0707A
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAcctInChartOfAccountsText ON ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAccountsText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON Segment = _SegmentText.Segment  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
;