ESH_S_ACCOUNTING_DOC

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_ACCOUNTING_DOC.
-- 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_ACCOUNTING
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_ACCOUNTING_DOC AS
SELECT
  bukrs,
  belnr,
  gjahr,
  blart,
  bldat,
  budat,
  monat,
  cpudt,
  upddt,
  usnam,
  xblnr,
  bktxt,
  waers,
  bstat,
  awtyp,
  awkey,
  rldnr,
  ldgrp,
  _BKPF2COMPANY_CODE.butxt AS butxt,
  _T003T2BKPF[ 1: spras = $parameters.P_Language ].ltext AS ltext,
  _BKPF2USER._TO_USER_NAME.name_text AS name_text,
  _BSEG_H2BKPF._BSEG_H2COMPANY.name1 AS name1,
  _BKPF2COMPANY_CODE.ktopl AS ktopl,
  _BSEG_H2BKPF.sgtxt AS sgtxt,
  _BSEG_H2BKPF.wrbtr AS wrbtr,
  _BSEG_H2BKPF.kokrs AS kokrs,
  _BSEG_H2BKPF.aufnr AS aufnr,
  _BSEG_H2BKPF.anln1 AS anln1,
  _BSEG_H2BKPF.anln2 AS anln2,
  _BSEG_H2BKPF.hkont AS hkont,
  _BSEG_H2BKPF.kunnr AS kunnr,
  _BSEG_H2BKPF._BSEG_H2KNB1_CUSTOMER._TO_KNB1_CUSTOMER.name1 AS CustomerName,
  _BSEG_H2BKPF.lifnr AS lifnr,
  _BSEG_H2BKPF._LFB1_CUSTOMER2BSEG_H._TO_LFB1_VENDOR.name1 AS SupplierName,
  _BSEG_H2BKPF.xref1 AS xref1,
  _BSEG_H2BKPF.xref2 AS xref2,
  _BSEG_H2BKPF.xref3 AS xref3,
  _BSEG_H2BKPF.branch_id AS branch_id,
  _BSEG_H2BKPF.ebeln AS ebeln,
  _BSEG_H2BKPF.zuonr AS zuonr,
  _BSEG_H2BKPF.kostl AS kostl,
  _BSEG_H2BKPF.prctr AS prctr,
  _BSEG_H2BKPF.vbel2 AS vbel2,
  _BSEG_H2BKPF.vbund AS vbund
FROM ESH_N_ACCOUNTING_DOC_BKPF
;