P_CONSACCINCOA

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_CONSACCINCOA.
-- 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: PCONSACCINCOA

CREATE VIEW P_CONSACCINCOA AS
SELECT
  ska1.mandt AS mandt,
  ska1.ktopl AS ChartOfAccounts,
  ska1.saknr AS GLAccount,
  ska1.xbilk AS IsBalanceSheetAccount,
  ska1.ktoks AS GLAccountGroup,
  ska1.gvtyp AS ProfitLossAccountType,
  ska1.mustr AS SampleGLAccount,
  ska1.vbund AS PartnerCompany,
  ska1.func_area AS FunctionalArea,
  ska1.glaccount_type AS GLAccountType,
  ska1.sakan AS GLAccountExternal,
  case when ska1.xbilk = 'X' then ' ' else 'X' end as IsProfitLossAccount AS xbilkXthenelseXendasIsProfitLossAccount,
  _BPCExtension.elimacct AS EliminationAccount,
  _BPCExtension.enjnr AS EnableJournal,
  _BPCExtension.tyelm AS EliminationType,
  _BPCExtension.rkrst AS ExchangeRateType,
  _BPCExtension.acctype AS BPCAccountType
FROM ska1
LEFT OUTER JOIN rtc_ext_ska1 AS _BPCExtension ON /* join condition not captured in parsed metadata */
;