I_BUSINESSPARTNERBANK

CDS View
21 Fields 8 CDS Views

Business Partner Bank

I_BUSINESSPARTNERBANK is a CDS View in S/4HANA. Business Partner Bank. It contains 21 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
/PF1/I_BP_ACCOUNT view_entity from BP Account ID
A_BusinessPartnerBank view from BASIC Bank
C_InsurClmPaytBankVH view_entity from CONSUMPTION Value Help for Claim Payment Bank ID
C_NL_SAFTBusPartnerBankAcct view inner CONSUMPTION SAFT NL Business Partner Bank Accounts
I_BankChainBankDetail view_entity from BASIC Supplier and Customer Bank Detail
I_BusinessPartnerBankTP view from TRANSACTIONAL Association View for bank details
I_WorkForcePersonPayt view left_outer COMPOSITE Workforce Person Payment Details for Object Page
P_BusinessPartnerBank view from COMPOSITE

Fields (21)

KeyField CDS FieldsUsed in Views
KEY BankIdentification BankIdentification,BankIdentificationForEdit 4
KEY BusinessPartner BusinessPartner,BusinessPartnerForEdit 3
_BusinessPartner _BusinessPartner 1
BankAccount BankAccount 3
BankAccountHolderName BankAccountHolderName 3
BankAccountName BankAccountName 3
BankAccountReferenceText BankAccountReferenceText,BankReference 3
BankControlKey BankControlKey 3
BankCountryKey BankCountryKey 3
BankName BankName 2
BankNumber Bank,BankNumber 3
BPBankDetailsChangeDate BPBankDetailsChangeDate 1
BPBankDetailsChangeTargetID BPBankDetailsChangeTargetID 1
BPBankIsProtected BPBankIsProtected 3
BusinessPartnerExternalBankID BusinessPartnerExternalBankID 1
CollectionAuthInd CollectionAuthInd 2
IBAN IBAN 3
IBANValidityStartDate IBANValidityStartDate 1
SWIFTCode SWIFTCode 2
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Business Partner Bank
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNERBANK (
    BANKIDENTIFICATION,
    BUSINESSPARTNER,
    _BUSINESSPARTNER,
    BANKACCOUNT,
    BANKACCOUNTHOLDERNAME,
    BANKACCOUNTNAME,
    BANKACCOUNTREFERENCETEXT,
    BANKCONTROLKEY,
    BANKCOUNTRYKEY,
    BANKNAME,
    BANKNUMBER,
    BPBANKDETAILSCHANGEDATE,
    BPBANKDETAILSCHANGETARGETID,
    BPBANKISPROTECTED,
    BUSINESSPARTNEREXTERNALBANKID,
    COLLECTIONAUTHIND,
    IBAN,
    IBANVALIDITYSTARTDATE,
    SWIFTCODE,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BANKIDENTIFICATION, BUSINESSPARTNER)
);

Learn More