I_OffsettingAccount

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_OffsettingAccount.
-- 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 I_OffsettingAccount AS
SELECT
  P_OffsettingAccount.ChartOfAccounts AS ChartOfAccounts,
  P_OffsettingAccount.OffsettingAccountType AS OffsettingAccountType,
  P_OffsettingAccount.OffsettingAccount AS OffsettingAccount,
  P_OffsettingAccount.OffsettingAccountName AS OffsettingAccountName,
  P_OffsettingAccount.OffsettingAccountShortName AS OffsettingAccountShortName
FROM P_OffsettingAccount
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccount ON OffsettingAccount = _GLAccount.ChartOfAccounts AND OffsettingAccount = _GLAccount.GLAccount AND ( OffsettingAccountType = 'S' OR OffsettingAccountType = 'M' OR OffsettingAccountType = 'A' )  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND OffsettingAccount = _GLAccountInChartOfAccounts.GLAccount AND ( OffsettingAccountType = 'S' OR OffsettingAccountType = 'M' OR OffsettingAccountType = 'A' )  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _OffsettingAccountType ON OffsettingAccountType = _OffsettingAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON OffsettingAccount = _Customer.Customer AND OffsettingAccountType = 'D'  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON OffsettingAccount = _Supplier.Supplier AND OffsettingAccountType = 'K'  -- association [0..1]
;