R_BANKACCOUNT

CDS View
14 Fields 2 CDS Views

Bank Accounts

R_BANKACCOUNT is a CDS View in S/4HANA. Bank Accounts. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BkAcctForCndnWthBkGrp view_entity from COMPOSITE Bank Account with Bank Group
R_NonTechnicalBankAccount view_entity from COMPOSITE Bank Accounts Technical Account Excluded

Fields (14)

KeyField CDS FieldsUsed in Views
KEY BankAccountInternalID BankAccountInternalID 1
BankAccountCharacteristic BankAccountCharacteristic 1
BankAccountContractType BankAccountContractType 1
BankAccountCurrency BankAccountCurrency 1
BankAccountInternalType BankAccountInternalType 1
BankAccountNumber BankAccountNumber 1
BankAccountRevision BankAccountRevision 1
BankAccountStatus BankAccountStatus 1
BankControlKey BankControlKey 1
BankCountry BankCountry 1
BankInternalID BankInternalID 1
CompanyCode CompanyCode 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Bank Accounts
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_BANKACCOUNT (
    BANKACCOUNTINTERNALID,
    BANKACCOUNTCHARACTERISTIC,
    BANKACCOUNTCONTRACTTYPE,
    BANKACCOUNTCURRENCY,
    BANKACCOUNTINTERNALTYPE,
    BANKACCOUNTNUMBER,
    BANKACCOUNTREVISION,
    BANKACCOUNTSTATUS,
    BANKCONTROLKEY,
    BANKCOUNTRY,
    BANKINTERNALID,
    COMPANYCODE,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BANKACCOUNTINTERNALID)
);

Learn More