BANK

BANK is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed in Views
KEY Bank Bank 1
KEY BankCountry BankCountry 3
KEY BankIdentification BankIdentification 4
KEY BankInternalID BankInternalID 1
KEY BankKey BankKey 1
_BusinessPartner _BusinessPartner 3
_Country _Country 1
banka BankName 1
BankAccount BankAccount 5
BankAccountCurrency BankAccountCurrency 1
BankAccountHolderName BankAccountHolderName 4
BankAccountName BankAccountName 4
BankControlKey BankControlKey 4
BankCountryDesp BankCountryDesp 1
BankCountryKey BankCountryKey 4
BankName BankName 6
BankNetworkGrouping BankNetworkGrouping 1
BankNumber Bank,BankNumber 5
BPBankIsProtected BPBankIsProtected 3
BusinessPartner BusinessPartner 4
IBAN IBAN 4
InternalBankCategory InternalBankCategory 1
InternalBankCategoryDesc InternalBankCategoryDesc 1
swift SWIFTCode 1
SWIFTCode SWIFTCode 5

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BANK (
    BANK,
    BANKCOUNTRY,
    BANKIDENTIFICATION,
    BANKINTERNALID,
    BANKKEY,
    _BUSINESSPARTNER,
    _COUNTRY,
    BANKA,
    BANKACCOUNT,
    BANKACCOUNTCURRENCY,
    BANKACCOUNTHOLDERNAME,
    BANKACCOUNTNAME,
    BANKCONTROLKEY,
    BANKCOUNTRYDESP,
    BANKCOUNTRYKEY,
    BANKNAME,
    BANKNETWORKGROUPING,
    BANKNUMBER,
    BPBANKISPROTECTED,
    BUSINESSPARTNER,
    IBAN,
    INTERNALBANKCATEGORY,
    INTERNALBANKCATEGORYDESC,
    SWIFT,
    SWIFTCODE,
    PRIMARY KEY (BANK, BANKCOUNTRY, BANKIDENTIFICATION, BANKINTERNALID, BANKKEY)
);