BR

BR is an SAP database table in S/4HANA. It contains 22 fields.

Fields (22)

KeyField CDS FieldsUsed in Views
KEY BankReconciliationDate BankReconciliationDate 1
KEY CompanyCode CompanyCode 1
KEY HouseBank HouseBank 1
KEY HouseBankAccount HouseBankAccount 1
AdjustedBkAcctBalanceAmt AdjustedBkAcctBalanceAmt 1
AdjustedGLAcctBalanceAmt AdjustedGLAcctBalanceAmt 1
BankAccount BankAccount 1
BankAccountReferenceText BankAccountReferenceText 1
BankAcctBalanceAmt BankAcctBalanceAmt 1
BankName BankName 1
BankReconciliationStatus BankReconciliationStatus 1
CreationUserName CreationUserName 1
GLAccount GLAccount 1
GLAcctBalanceAmt GLAcctBalanceAmt 1
HouseBankCurrency HouseBankCurrency 1
LastBankReconciliationDate LastBankReconciliationDate 1
LastChangeDateTime LastChangeDateTime 1
Ledger Ledger 1
UnmatchedIncgBkStmntPayt UnmatchedIncgBkStmntPayt 1
UnmatchedIncgJrnlEntrPayt UnmatchedIncgJrnlEntrPayt 1
UnmatchedOutgBkStmntPayt UnmatchedOutgBkStmntPayt 1
UnmatchedOutgJrnlEntrPayt UnmatchedOutgJrnlEntrPayt 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BR (
    BANKRECONCILIATIONDATE,
    COMPANYCODE,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    ADJUSTEDBKACCTBALANCEAMT,
    ADJUSTEDGLACCTBALANCEAMT,
    BANKACCOUNT,
    BANKACCOUNTREFERENCETEXT,
    BANKACCTBALANCEAMT,
    BANKNAME,
    BANKRECONCILIATIONSTATUS,
    CREATIONUSERNAME,
    GLACCOUNT,
    GLACCTBALANCEAMT,
    HOUSEBANKCURRENCY,
    LASTBANKRECONCILIATIONDATE,
    LASTCHANGEDATETIME,
    LEDGER,
    UNMATCHEDINCGBKSTMNTPAYT,
    UNMATCHEDINCGJRNLENTRPAYT,
    UNMATCHEDOUTGBKSTMNTPAYT,
    UNMATCHEDOUTGJRNLENTRPAYT,
    PRIMARY KEY (BANKRECONCILIATIONDATE, COMPANYCODE, HOUSEBANK, HOUSEBANKACCOUNT)
);