_BANKACCOUNT

17 Fields

_BANKACCOUNT is an SAP database table in S/4HANA. It contains 17 fields.

Fields (17)

KeyField CDS FieldsUsed in Views
KEY Bank Bank 13
KEY BankAccountNumber acc_num,BankAccount,BankAccountNumber,HouseBankAccountNumber 29
KEY BankAccountType BankAccountType 13
KEY BankCountry BankCountry 9
KEY Country CompanyCodeCountry 1
BankAccountContractType BankAccountContractType 1
BankAccountCurrency BankAccountCurrency 11
BankAccountHolderName AccountHolder,BankAccountHolderName,beneficial 4
BankAccountInternalID BankAccountInternalID 1
BankAccountStatus BankAccountStatus 3
BusinessArea BusinessArea 3
CompanyCode CompanyCode 6
ControllingArea ControllingArea 1
IBAN IBAN 5
PaymentTransactionTypeGroup PaymentTransactionTypeGroup 1
ProfitCenter ProfitCenter 2
Segment Segment 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _BANKACCOUNT (
    BANK,
    BANKACCOUNTNUMBER,
    BANKACCOUNTTYPE,
    BANKCOUNTRY,
    COUNTRY,
    BANKACCOUNTCONTRACTTYPE,
    BANKACCOUNTCURRENCY,
    BANKACCOUNTHOLDERNAME,
    BANKACCOUNTINTERNALID,
    BANKACCOUNTSTATUS,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    IBAN,
    PAYMENTTRANSACTIONTYPEGROUP,
    PROFITCENTER,
    SEGMENT,
    PRIMARY KEY (BANK, BANKACCOUNTNUMBER, BANKACCOUNTTYPE, BANKCOUNTRY, COUNTRY)
);

Learn More