ESH_N_HOUSEBANK_T012

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_N_HOUSEBANK_T012.
-- 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_L_HOUSE_T012

CREATE VIEW ESH_N_HOUSEBANK_T012 AS
SELECT
  bukrs,
  hbkid,
  banks,
  bankl,
  telf1,
  stcd1,
  name1,
  spras,
  bupla
FROM t012
LEFT OUTER JOIN t012d AS _TO_T012D ON bukrs = _TO_T012D.bukrs AND hbkid = _TO_T012D.hbkid  -- association [1..1]
LEFT OUTER JOIN ESH_N_LAND1_3_LAND1 AS _LAND1_2_T012 ON banks = _LAND1_2_T012.DOMVALUE_L  -- association [0..*]
LEFT OUTER JOIN ESH_N_BANK_BANK AS _T0122BANK ON banks = _T0122BANK.banks AND bankl = _T0122BANK.bankl  -- association [1..1]
LEFT OUTER JOIN ESH_N_COMPANY_CODE_OMPANY_CODE AS _T0122COMPANY_CODE ON bukrs = _T0122COMPANY_CODE.bukrs  -- association [1..1]
;