P_HouseBankAccountDesc

DDL: P_HOUSEBANKACCOUNTDESC SQL: PHBACDESC Type: view BASIC

P_HouseBankAccountDesc is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (fclm_bam_amd, fclm_bam_amd_t, fclm_bam_aclink2) and exposes 6 fields.

Data Sources (3)

SourceAliasJoin Type
fclm_bam_amd acc inner
fclm_bam_amd_t acctxt inner
fclm_bam_aclink2 hba from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PHBACDESC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
mandt fclm_bam_aclink2 mandt Editing Client
spras fclm_bam_amd_t langu Primary lang.
bukrs fclm_bam_aclink2 bukrs Value
hbkid fclm_bam_aclink2 hbkid House Bank
hktid fclm_bam_aclink2 hktid House Bank Account
text1 fclm_bam_amd_t description Well Code Des.

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_HouseBankAccountDesc.
-- 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: PHBACDESC

CREATE VIEW P_HouseBankAccountDesc AS
SELECT
  hba.mandt AS mandt,
  acctxt.langu AS spras,
  hba.bukrs AS bukrs,
  hba.hbkid AS hbkid,
  hba.hktid AS hktid,
  acctxt.description AS text1
FROM fclm_bam_aclink2 AS hba
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 */
;