BAL

26 Fields

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

Fields (26)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 2
KEY CAReconciliationAccount CAReconciliationAccount 1
KEY CompanyCode CompanyCode 2
KEY ContractAccount ContractAccount 1
KEY Customer Customer 1
KEY FiscalYear FiscalYear 1
KEY FiscalYearPeriod FiscalYearPeriod 1
KEY Ledger Ledger 1
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
KEY Supplier Supplier 1
Bank Bank 1
BankAccountCurrency Currency 1
BankCountry BankCountry 1
BusinessPartnerName BusinessPartnerName 1
ClosingBalanceCr CustBalYTDCrdtAmtInDspCrcy 1
ClosingBalanceDr CustBalYTDDebitAmtInDspCrcy 1
CompanyCodeCurrency CompanyCodeCurrency 1
CreditMonth CustBalCreditAmtInDspCrcy 1
DebitMonth CustBalDebitAmtInDspCrcy 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
TotalVltdStockQuantity TotalVltdStockQuantity 1
TotStkValAtSlsPrcInCoCodeCrcy TotStkValAtSlsPrcInCoCodeCrcy 1
TransactionDate TransactionDate 1
ValuationQuantity TotalVltdStockQuantity 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 (
    BUSINESSPARTNER,
    CARECONCILIATIONACCOUNT,
    COMPANYCODE,
    CONTRACTACCOUNT,
    CUSTOMER,
    FISCALYEAR,
    FISCALYEARPERIOD,
    LEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUPPLIER,
    BANK,
    BANKACCOUNTCURRENCY,
    BANKCOUNTRY,
    BUSINESSPARTNERNAME,
    CLOSINGBALANCECR,
    CLOSINGBALANCEDR,
    COMPANYCODECURRENCY,
    CREDITMONTH,
    DEBITMONTH,
    ISBUSINESSPURPOSECOMPLETED,
    TOTALVLTDSTOCKQUANTITY,
    TOTSTKVALATSLSPRCINCOCODECRCY,
    TRANSACTIONDATE,
    VALUATIONQUANTITY,
    PRIMARY KEY (BUSINESSPARTNER, CARECONCILIATIONACCOUNT, COMPANYCODE, CONTRACTACCOUNT, CUSTOMER, FISCALYEAR, FISCALYEARPERIOD, LEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, SUPPLIER)
);

Learn More