I_BUSINESSPARTNERBANKTP

CDS View
22 Fields 1 CDS Views

Association View for bank details

I_BUSINESSPARTNERBANKTP is a CDS View in S/4HANA. Association View for bank details. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BusinessPartnerBank view from CONSUMPTION BP Bank Consumption View

Fields (22)

KeyField CDS FieldsUsed in Views
KEY BankIdentification BankIdentification 1
KEY BusinessPartner BusinessPartner 1
AliasType AliasType 1
BankAccount BankAccount 1
BankAccountHolderName BankAccountHolderName 1
BankAccountName BankAccountName 1
BankAccountReferenceText BankAccountReferenceText 1
BankControlKey BankControlKey 1
BankCountryKey BankCountryKey 1
BankIdentificationForEdit BankIdentificationForEdit 1
BankName BankName 1
BankNumber BankNumber 1
BankValidityEndDate BankValidityEndDate 1
BankValidityStartDate BankValidityStartDate 1
BPBankAccountAliasName BPBankAccountAliasName 1
BPBankIsProtected BPBankIsProtected 1
BusinessPartnerForEdit BusinessPartnerForEdit 1
CollectionAuthInd CollectionAuthInd 1
IBAN IBAN 1
IBANValidityStartDate IBANValidityStartDate 1
PaymentSystem PaymentSystem 1
SWIFTCode SWIFTCode 1

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.

-- Association View for bank details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNERBANKTP (
    BANKIDENTIFICATION,
    BUSINESSPARTNER,
    ALIASTYPE,
    BANKACCOUNT,
    BANKACCOUNTHOLDERNAME,
    BANKACCOUNTNAME,
    BANKACCOUNTREFERENCETEXT,
    BANKCONTROLKEY,
    BANKCOUNTRYKEY,
    BANKIDENTIFICATIONFOREDIT,
    BANKNAME,
    BANKNUMBER,
    BANKVALIDITYENDDATE,
    BANKVALIDITYSTARTDATE,
    BPBANKACCOUNTALIASNAME,
    BPBANKISPROTECTED,
    BUSINESSPARTNERFOREDIT,
    COLLECTIONAUTHIND,
    IBAN,
    IBANVALIDITYSTARTDATE,
    PAYMENTSYSTEM,
    SWIFTCODE,
    PRIMARY KEY (BANKIDENTIFICATION, BUSINESSPARTNER)
);

Learn More