I_CUSTOMERBANKDETAILS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA