P_HouseBankAccount

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_HouseBankAccount.
-- 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: PHOUSEBANKACCT

CREATE VIEW P_HouseBankAccount AS
SELECT
  hba.mandt AS mandt,
  distinct_hba.CompanyCode AS bukrs,
  distinct_hba.HouseBank AS hbkid,
  distinct_hba.HouseBankAccount AS hktid,
  hba.bankn AS bankn,
  acc.control_key AS bkont,
  acc.waers AS waers,
  hba.refzl AS refzl,
  hba.dtaai AS dtaai,
  hba.bnkn2 AS bnkn2,
  hba.fdgrp AS fdgrp,
  hba.abwae AS abwae,
  hba.hkont AS hkont,
  hba.wekon AS wekon,
  hba.mindt AS mindt,
  hba.hbid1 AS hbid1,
  hba.hkid1 AS hkid1,
  hba.hbid2 AS hbid2,
  hba.hkid2 AS hkid2,
  hba.wkkon AS wkkon,
  hba.wikon AS wikon,
  hba.acc_id AS acc_id,
  acc.acc_num AS acc_num
FROM I_BankAccountValidLinkage AS distinct_hba
INNER JOIN fclm_bam_aclink2 AS hba ON /* join condition not captured in parsed metadata */
INNER JOIN fclm_bam_amd AS acc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t012k ON /* join condition not captured in parsed metadata */
;