I_CUSTOMERBANKDETAILS

CDS View

Customer Bank Details Core

I_CUSTOMERBANKDETAILS is a CDS View in S/4HANA. Customer Bank Details Core. It contains 13 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_CustomerBankDetailsOP view from CONSUMPTION
C_NO_SAFTGenLedgerCustBankAcct view from CONSUMPTION SAF-T Norway GL Customer Bank Accounts
C_PaymentRequestCustomerVH view_entity inner CONSUMPTION Customer Value Help for Payment Request
C_PaytReqCustomerBankDetailVH view_entity from CONSUMPTION Customer Bnk Details for Payt Request VH
C_RO_SAFTCustomerBankAccount view from CONSUMPTION RO SAFT Customer Bank Account Details
FAC_Audit_Z3_Customer_Bank view left_outer Customer Bank Data
FI_F4_BVTYP_KNBK view from Only for usage in function module FI_F4_BVTYP
I_CustomerBankDetailsVH view from COMPOSITE Customer bank details
I_RO_SAFTBankAccountDetails view from COMPOSITE RO SAFT Bank Account Details
I_SAFTBankAccountDetails view from COMPOSITE SAFT Bank Account Details
P_CN_GoldenTaxCustomerBank view from COMPOSITE
P_CN_GoldenTaxCustomerBankAgg view from COMPOSITE
P_CustomerSupplierBankDetail view_entity from COMPOSITE Bank Detail for Customer and Supplier

Fields (13)

KeyField CDS FieldsUsed in Views
KEY Bank Bank 9
KEY BankAccount BankAccount 9
KEY BankCountry BankCountry 8
KEY BPBankAccountInternalID BPBankAccountInternalID 2
KEY BusinessPartner BusinessPartner 2
KEY Customer BusinessPartnerNumber,Customer,CustomerNum 6
_BankAccount _BankAccount 1
_Country _Country 1
_Customer _Customer 2
BankAccountHolderName BankAccountHolderName 6
BankControlKey BankControlKey 5
BankDetailReference BankDetailReference 4
BPBankUUID BPBankUUID 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.

-- Customer Bank Details Core
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CUSTOMERBANKDETAILS (
    BANK,
    BANKACCOUNT,
    BANKCOUNTRY,
    BPBANKACCOUNTINTERNALID,
    BUSINESSPARTNER,
    CUSTOMER,
    _BANKACCOUNT,
    _COUNTRY,
    _CUSTOMER,
    BANKACCOUNTHOLDERNAME,
    BANKCONTROLKEY,
    BANKDETAILREFERENCE,
    BPBANKUUID,
    PRIMARY KEY (BANK, BANKACCOUNT, BANKCOUNTRY, BPBANKACCOUNTINTERNALID, BUSINESSPARTNER, CUSTOMER)
);