A_BankDetail

DDL: A_BANKDETAIL SQL: ABKDET Type: view BASIC

Bank Details

A_BankDetail is a Basic CDS View that provides data about "Bank Details" in SAP S/4HANA. It reads from 1 data source (bnka) and exposes 10 fields with key fields BankCountry, BankInternalID.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
bnka bnka from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ABKDET view
EndUserText.label Bank Details view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BankCountry banks
KEY BankInternalID bankl
BankName banka
SWIFTCode swift
BankGroup bgrup
BankNumber bnklz
Region provz
StreetName stras
CityName ort01
Branch brnch 
@AbapCatalog.sqlViewName: 'ABKDET'
@EndUserText.label: 'Bank Details'
@VDM:{
    viewType: #BASIC,
    lifecycle.contract.type:#PUBLIC_REMOTE_API
}

@AccessControl.authorizationCheck: #CHECK

@ObjectModel: {
  usageType: {
    serviceQuality: #B,
    sizeCategory:   #L,
    dataClass:      #MASTER
  }
}
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE 
@AbapCatalog.compiler.compareFilter: true
define view A_BankDetail as select from bnka {
  
  key banks as BankCountry,
  key bankl as BankInternalID,
      banka as BankName,
      swift as SWIFTCode,
      bgrup as BankGroup,
      bnklz as BankNumber,         
      provz as Region,      
      stras as StreetName,
      ort01 as CityName,
      brnch as Branch

//      xpgro as IsPostBankAccount,

//      loevm as IsMarkedForDeletion,

//      pskto as PostOfficeBankAccount,

//      chkme as CheckDigitCalculationMethod,

//      vers as BankDataFileFormat,

//      erdat as CreationDate ,

//      ernam as CreatedByUser,

//      adrnr as AddressID

}where loevm = '' or loevm = ' '; 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BNKA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More