I_SUPPLIERBANKDETAILS

CDS View
16 Fields 16 CDS Views

SupplierBankDetails

I_SUPPLIERBANKDETAILS is a CDS View in S/4HANA. SupplierBankDetails. It contains 16 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
/CEECV/SHSM_ROFI_BVTY view from BASIC
C_BG_SAFTSupplierBankAccount view_entity from CONSUMPTION BG SAFT Supplier Bank Account Details
C_MngJrnlEntrCustSuplrBkDetVH view_entity union CONSUMPTION Customer and Supplier Bank Detail
C_NO_SAFTGenLedgerSuplrBkAcct view from CONSUMPTION SAF-T Norway GL Supplier Bank Accounts
C_PaytReqSupplierBankDetailVH view_entity from CONSUMPTION Supplier Bnk Details for Payt Request VH
C_RO_SAFTSupplierBankAccount view from CONSUMPTION RO SAFT Supplier Bank Account Details
C_Supplierbankdetails view from CONSUMPTION SupplierBankDetails
FAC_Audit_Z3_Vendor_Bank view left_outer Vendor Bank Data
FI_F4_BVTYP_LFBK view from Only for usage in function module FI_F4_BVTYP
I_RO_SAFTBankAccountDetails view union COMPOSITE RO SAFT Bank Account Details
I_SAFTBankAccountDetails view union COMPOSITE SAFT Bank Account Details
I_SupplierBankDetailsVH view from COMPOSITE Supplier bank details
P_AU_TPARSuplrFirstBankDetail view_entity from COMPOSITE
P_AU_TPARSupplierBankDetails view inner COMPOSITE
P_CustomerSupplierBankDetail view_entity union COMPOSITE Bank Detail for Customer and Supplier
P_SuplrWthSameBkAcctDta view_entity inner COMPOSITE

Fields (16)

KeyField CDS FieldsUsed in Views
KEY Bank Bank 10
KEY BankAccount BankAccount 8
KEY BankCountry BankCountry 9
KEY BPBankAccountInternalID BPBankAccountInternalID 3
KEY BusinessPartner BusinessPartner 2
KEY Supplier BusinessPartnerNumber,Creditor,Supplier,SupplierWithSameBank 5
_BankAccount _BankAccount 1
_BusinessPartnerBank _BusinessPartnerBank 1
_Country _Country 1
_Supplier _Supplier 3
AuthorizationGroup AuthorizationGroup 1
BankAccountHolderName BankAccountHolderName 5
BankControlKey BankControlKey 5
BankDetailReference BankDetailReference 3
BPBankUUID BPBankUUID 1
IBAN IBAN 3

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.

-- SupplierBankDetails
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPPLIERBANKDETAILS (
    BANK,
    BANKACCOUNT,
    BANKCOUNTRY,
    BPBANKACCOUNTINTERNALID,
    BUSINESSPARTNER,
    SUPPLIER,
    _BANKACCOUNT,
    _BUSINESSPARTNERBANK,
    _COUNTRY,
    _SUPPLIER,
    AUTHORIZATIONGROUP,
    BANKACCOUNTHOLDERNAME,
    BANKCONTROLKEY,
    BANKDETAILREFERENCE,
    BPBANKUUID,
    IBAN,
    PRIMARY KEY (BANK, BANKACCOUNT, BANKCOUNTRY, BPBANKACCOUNTINTERNALID, BUSINESSPARTNER, SUPPLIER)
);

Learn More