ESH_S_GL_ACCOUNT

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 ESH_S_GL_ACCOUNT.
-- 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: ESH_U_GL_ACCOUNT
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_GL_ACCOUNT AS
SELECT
  ktopl,
  saknr,
  xbilk,
  erdat,
  ernam,
  ktoks,
  vbund,
  func_area,
  _TO_SKAT[ 1: spras = $parameters.P_Language ].txt20 AS txt20,
  _GL_ACCOUNT_MASTER2KTOPL[ 1: DOMALANGU = $parameters.P_Language ].VALUE_TEXT AS VALUE_TEXT,
  _GL_ACCOUNT_MASTER2XFELD[ 1: DOMALANGU = $parameters.P_Language ].VALUE_TEXT AS VALUE_TEXT1,
  _GL_ACCOUNT_MASTER2T077Z[ 1: spras = $parameters.P_Language ].txt30 AS TXT301,
  _GL_ACCOUNT_MASTER2COMPANY.name1 AS name1,
  _TO_SKAT[ 1: spras = $parameters.P_Language ].txt50 AS txt50,
  _GL_ACCOUNT_MASTER2USER._TO_USER_NAME.name_text AS name_text,
  _SKB12GL_ACCOUNT_MASTER._SKB12COMPANY_CODE.butxt AS butxt,
  _SKB12GL_ACCOUNT_MASTER._MITKZ_2_SKB1[ 1: DOMALANGU = $parameters.P_Language ].VALUE_TEXT AS DDTEXT,
  _SKB12GL_ACCOUNT_MASTER.togru AS togru,
  _SKB12GL_ACCOUNT_MASTER._SKB12TOGRU_T[ 1: spras = $parameters.P_Language ].txt30 AS txt30,
  _SKB12GL_ACCOUNT_MASTER.bukrs AS bukrs,
  _SKB12GL_ACCOUNT_MASTER.waers AS waers,
  _SKB12GL_ACCOUNT_MASTER.mwskz AS mwskz,
  _SKB12GL_ACCOUNT_MASTER.altkt AS altkt,
  _SKB12GL_ACCOUNT_MASTER._XFELD_2_SKB1[ 1: DOMALANGU = $parameters.P_Language ].VALUE_TEXT AS VALUE_TEXT2
FROM ESH_N_GL_ACCOUNT_CCOUNT_MASTER
;