P_HouseBankAccountText

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_HouseBankAccountText.
-- 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: PHOUSEBANKACCTT

CREATE VIEW P_HouseBankAccountText AS
SELECT
  hba.mandt AS mandt,
  acctxt.langu AS spras,
  distinct_hba.CompanyCode AS bukrs,
  distinct_hba.HouseBank AS hbkid,
  distinct_hba.HouseBankAccount AS hktid,
  cast(substring (acctxt.description, 1, 50) as fclm_bam_description ) AS text1
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_t AS acctxt ON /* join condition not captured in parsed metadata */
INNER JOIN fclm_bam_amd AS acc ON /* join condition not captured in parsed metadata */
;