I_BankAcctWithDesc

DDL: I_BANKACCTWITHDESC SQL: IBANKACCDESC Type: view BASIC Package: FCLM_BAM
12 Fields 2 Data Sources 1 Associations

Bank Account with description

I_BankAcctWithDesc is a Basic CDS View that provides data about "Bank Account with description" in SAP S/4HANA. It reads from 2 data sources (fclm_bam_amd, fclm_bam_amd_t) and exposes 12 fields. It has 1 association to related views. Part of development package FCLM_BAM.

Data Sources (2)

SourceAliasJoin Type
fclm_bam_amd amd from
fclm_bam_amd_t desc left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IBANKACCDESC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Bank Account with description view

Fields (12)

KeyFieldSource TableSource FieldDescription
BankAccountInternalID fclm_bam_amd acc_id Technical ID
BankAccountNumber fclm_bam_amd acc_num Account Number
BankAccountDescription fclm_bam_amd_t description Well Code Des.
Bank fclm_bam_amd bankl House Bank
BankCountry fclm_bam_amd banks Bank Ctry/Rgn. Key
BankAccountCurrency fclm_bam_amd waers Transaction Currency
CompanyCode fclm_bam_amd bukrs Value
BankAccountType fclm_bam_amd acc_type_id Account Type
BusinessArea fclm_bam_amd gsber Business Area
Segment fclm_bam_amd segment Segment number
ProfitCenter fclm_bam_amd prctr Profit Centers
CompanyCodeName _CompanyCode CompanyCodeName Company Name

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 I_BankAcctWithDesc.
-- 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: IBANKACCDESC

CREATE VIEW I_BankAcctWithDesc AS
SELECT
  amd.acc_id AS BankAccountInternalID,
  amd.acc_num AS BankAccountNumber,
  desc.description AS BankAccountDescription,
  amd.bankl AS Bank,
  amd.banks AS BankCountry,
  amd.waers AS BankAccountCurrency,
  amd.bukrs AS CompanyCode,
  amd.acc_type_id AS BankAccountType,
  amd.gsber AS BusinessArea,
  amd.segment AS Segment,
  amd.prctr AS ProfitCenter,
  _CompanyCode.CompanyCodeName AS CompanyCodeName
FROM fclm_bam_amd AS amd
LEFT OUTER JOIN fclm_bam_amd_t AS desc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More