_BANKACCOUNT

26 Fields

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

Fields (26)

KeyField CDS FieldsUsed in Views
KEY Bank Bank,BankInternalID,BankKey 18
KEY BankAccountNumber acc_num,BankAccount,BankAccountNumber,HouseBankAccountNumber 35
KEY BankAccountType BankAccountType 20
KEY BankCountry BankCountry 16
KEY CompanyCode CompanyCode,PayeeCompanyCode 12
KEY Country CompanyCodeCountry 1
BankAccountContractType BankAccountContractType 4
BankAccountCurrency BankAccountCurrency 14
BankAccountDescription BankAccountDescription 2
BankAccountHolderName AccountHolder,BankAccountHolderName,beneficial 5
BankAccountInternalID BankAccountInternalID 1
BankAccountInternalType BankAccountInternalType 1
BankAccountStatus BankAccountStatus 5
BankControlKey BankControlKey 3
BankGroupName BankGroupName 1
BankName BankName 1
BusinessArea BusinessArea 3
ClosedDate ClosedDate 1
CompanyCodeCountry CompanyCodeCountry 1
CompanyCodeName CompanyCodeName 4
ControllingArea ControllingArea 1
IBAN IBAN 5
OpenedDate OpenedDate 1
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,
    COMPANYCODE,
    COUNTRY,
    BANKACCOUNTCONTRACTTYPE,
    BANKACCOUNTCURRENCY,
    BANKACCOUNTDESCRIPTION,
    BANKACCOUNTHOLDERNAME,
    BANKACCOUNTINTERNALID,
    BANKACCOUNTINTERNALTYPE,
    BANKACCOUNTSTATUS,
    BANKCONTROLKEY,
    BANKGROUPNAME,
    BANKNAME,
    BUSINESSAREA,
    CLOSEDDATE,
    COMPANYCODECOUNTRY,
    COMPANYCODENAME,
    CONTROLLINGAREA,
    IBAN,
    OPENEDDATE,
    PAYMENTTRANSACTIONTYPEGROUP,
    PROFITCENTER,
    SEGMENT,
    PRIMARY KEY (BANK, BANKACCOUNTNUMBER, BANKACCOUNTTYPE, BANKCOUNTRY, COMPANYCODE, COUNTRY)
);

Learn More