BAL

12 Fields

BAL is an SAP database table in S/4HANA. It contains 12 fields.

Fields (12)

KeyField CDS FieldsUsed in Views
KEY Customer Customer 1
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY Supplier Supplier 1
Bank Bank 2
BankAccount BankAccount 1
BankAccountCurrency Currency 3
BankCountry BankCountry 3
CompanyCode CompanyCode 3
GLAccount GLAccount 1
TotalVltdStockQuantity TotalVltdStockQuantity 1
TransactionDate TransactionDate 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 BAL (
    CUSTOMER,
    FISCALYEAR,
    LEDGER,
    SUPPLIER,
    BANK,
    BANKACCOUNT,
    BANKACCOUNTCURRENCY,
    BANKCOUNTRY,
    COMPANYCODE,
    GLACCOUNT,
    TOTALVLTDSTOCKQUANTITY,
    TRANSACTIONDATE,
    PRIMARY KEY (CUSTOMER, FISCALYEAR, LEDGER, SUPPLIER)
);

Learn More