ESH_S_HOUSEBANK

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

CREATE VIEW ESH_S_HOUSEBANK AS
SELECT
  bukrs,
  hbkid,
  banks,
  bankl,
  telf1,
  stcd1,
  name1,
  spras,
  bupla,
  _T0122COMPANY_CODE.butxt AS butxt,
  _TO_T012D.hbkid AS HBKID_TXT,
  _T0122BANK.banka AS banka,
  _LAND1_2_T012[ 1: DOMALANGU = $parameters.P_Language ].VALUE_TEXT AS VALUE_TEXT,
  _T0122BANK.provz AS provz,
  _T0122BANK.ort01 AS ort01,
  _T0122BANK.stras AS stras,
  _T0122BANK.brnch AS brnch,
  _T0122BANK.swift AS swift,
  _T0122BANK.bgrup AS bgrup,
  _T0122BANK.xpgro AS xpgro,
  _T0122BANK.bnklz AS bnklz,
  _TO_T012D.edipn AS edipn,
  _TO_T012D.edisn AS edisn,
  _TO_T012D.dtbid AS dtbid,
  _TO_T012D.dtelz AS dtelz,
  _TO_T012D.dtkid AS dtkid,
  _TO_T012D.dtfin AS dtfin,
  _TO_T012D.dtglz AS dtglz,
  _TO_T012D.dtgbk AS dtgbk,
  _TO_T012D.dtgis AS dtgis,
  _TO_T012D.dtvta AS dtvta
FROM ESH_N_HOUSEBANK_T012
;