I_BankAcctWithDesc

DDL: I_BANKACCTWITHDESC SQL: IBANKACCDESC Type: view BASIC

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.

2 data source(s) 12 fields

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
BankAccountNumber fclm_bam_amd acc_num
BankAccountDescription fclm_bam_amd_t description
Bank fclm_bam_amd bankl
BankCountry fclm_bam_amd banks
BankAccountCurrency fclm_bam_amd waers
CompanyCode fclm_bam_amd bukrs
BankAccountType fclm_bam_amd acc_type_id
BusinessArea fclm_bam_amd gsber
Segment fclm_bam_amd segment
ProfitCenter fclm_bam_amd prctr
CompanyCodeName _CompanyCode CompanyCodeName 
@AbapCatalog.sqlViewName: 'IBANKACCDESC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Bank Account with description'
define view I_BankAcctWithDesc
  as select from    fclm_bam_amd     as amd
//    left outer join fclm_bam_amd_cur as cur  on  amd.acc_id   = cur.acc_id

//                                             and amd.revision = cur.revision

    left outer join fclm_bam_amd_t   as desc on  amd.acc_id   = desc.acc_id
                                             and amd.revision = desc.revision
                                             and desc.langu   = $session.system_language
  association [0..1] to I_CompanyCode        as _CompanyCode  on  $projection.CompanyCode = _CompanyCode.CompanyCode 
{
  amd.acc_id       as BankAccountInternalID,
  amd.acc_num      as BankAccountNumber,
  desc.description as BankAccountDescription,
  amd.bankl        as Bank,
  amd.banks        as BankCountry,
//  cur.waers        as BankAccountCurrency,

  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
}
where
      amd.revision     =  '0000'
//  and cur.deleted_flag <> 'X'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"FCLM_BAM_AMD",
"FCLM_BAM_AMD_T"
],
"ASSOCIATED":
[
"I_COMPANYCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More