I_BankChainBankDetail

DDL: I_BANKCHAINBANKDETAIL Type: view_entity BASIC Package: ODATA_MANAGE_BANK_CHAINS

Supplier and Customer Bank Detail

I_BankChainBankDetail (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_BankChainBankDetail is a Basic CDS View that provides data about "Supplier and Customer Bank Detail" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerBank) and exposes 28 fields with key fields BkChnBP, BankIdentification. Part of development package ODATA_MANAGE_BANK_CHAINS.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessFinancial Operations
Application ComponentFI-BL-MD-2CL
CapabilitiesData Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageFinancial Operations for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerBank I_BusinessPartnerBank from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Supplier and Customer Bank Detail view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY BkChnBP BusinessPartner Business Partner Number
KEY BankIdentification BankIdentification Bank Details ID
BusinessPartner BusinessPartner Business Partner Number
BkChnBankAccountWithReference Account Number at Recipient Bank
BankCountryKey BankCountryKey Bank Country/Region Key
BankName BankName Name of Financial Institution
BankNumber BankNumber Bank Key
SWIFTCode SWIFTCode SWIFT/BIC for International Payments
BankControlKey BankControlKey Bank Control Key
BankAccountHolderName BankAccountHolderName Account Holder Name
BankAccountName BankAccountName Name of Bank Account
ValidityStartDate ValidityStartDate Validity Start of Business Partner Bank Details
ValidityEndDate ValidityEndDate Validity End of Business Partner Bank Details
IBAN IBAN IBAN (International Bank Account Number)
IBANValidityStartDate IBANValidityStartDate Validity Start of IBAN
BankAccount BankAccount Bank Account Number
BkChnAcctNumberAtRecipientBank Account Number at Recipient Bank
BankAccountReferenceText BankAccountReferenceText Reference Details for Bank Details
CollectionAuthInd CollectionAuthInd Indicator: Collection Authorization
BusinessPartnerExternalBankID BusinessPartnerExternalBankID Bank details ID in external system
BPBankDetailsChangeDate BPBankDetailsChangeDate Date of Change to Bank Details (BP)
BPBankDetailsChangeTargetID BPBankDetailsChangeTargetID ID of Target Details for Change of Bank Details (BP)
BPBankIsProtected BPBankIsProtected BP: Sensitivity Indicator
CityName CityName Name
AuthorizationGroup AuthorizationGroup Authorization Group
_Bank _Bank
_BusinessPartner _BusinessPartner
_IBAN _IBAN

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_BankChainBankDetail.
-- 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.

CREATE VIEW I_BankChainBankDetail AS
SELECT
  BusinessPartner AS BkChnBP,
  BankIdentification,
  BusinessPartner,
  cast( '' as fap_banknrec ) AS BkChnBankAccountWithReference,
  BankCountryKey,
  BankName,
  BankNumber,
  SWIFTCode,
  BankControlKey,
  BankAccountHolderName,
  BankAccountName,
  ValidityStartDate,
  ValidityEndDate,
  IBAN,
  IBANValidityStartDate,
  BankAccount,
  cast( BankAccount as fap_banknrec ) AS BkChnAcctNumberAtRecipientBank,
  BankAccountReferenceText,
  CollectionAuthInd,
  BusinessPartnerExternalBankID,
  BPBankDetailsChangeDate,
  BPBankDetailsChangeTargetID,
  BPBankIsProtected,
  CityName,
  AuthorizationGroup
FROM I_BusinessPartnerBank
;