I_BUSINESSPARTNERBANK_2

CDS View

Core View: Business Partner Bank

I_BUSINESSPARTNERBANK_2 is a CDS View in S/4HANA. Core View: Business Partner Bank. It contains 12 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_BusinessPartnerBankGov view union_all COMPOSITE Business Partner Bank (Governance)
I_BusinessPartnerBankTP_2 view_entity from TRANSACTIONAL Transactional View for BP bank details with RAP
I_CAContractPartnerBank view_entity from COMPOSITE Contract Account Partner Bank
I_CAContractPartnerBankIdnVH view_entity from COMPOSITE Search help Bank Identification
R_WorkAssignmentBankAccountTP view_entity from TRANSACTIONAL TP View for Bank Accounts for Workforce Person
R_WrkAssignmentBankAccountTP_2 view_entity from TRANSACTIONAL TP View for Bank Accounts for Workforce Person

Fields (12)

KeyField CDS FieldsUsed in Views
KEY BankIdentification BankIdentification 2
KEY BusinessPartner BusinessPartner,WorkAssignmentBusinessPartner 2
BankAccount BankAccount 2
BankAccountHolderName BankAccountHolderName 2
BankAccountName BankAccountName 2
BankControlKey BankControlKey 2
BankCountryKey BankCountryKey 2
BankName BankName 2
BankNumber Bank 2
BPBankIsProtected BPBankIsProtected 2
IBAN IBAN 2
SWIFTCode SWIFTCode 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.

-- Core View: Business Partner Bank
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNERBANK_2 (
    BANKIDENTIFICATION,
    BUSINESSPARTNER,
    BANKACCOUNT,
    BANKACCOUNTHOLDERNAME,
    BANKACCOUNTNAME,
    BANKCONTROLKEY,
    BANKCOUNTRYKEY,
    BANKNAME,
    BANKNUMBER,
    BPBANKISPROTECTED,
    IBAN,
    SWIFTCODE,
    PRIMARY KEY (BANKIDENTIFICATION, BUSINESSPARTNER)
);