BALANCE

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 BALANCE (
    BANKACCOUNTID,
    BANKACCOUNTINTERNALID,
    BUSINESSPARTNER,
    CASHBALANCETYPE,
    CASHPLANNINGGROUP,
    CHARTOFACCOUNTS,
    COMPANYCODE,
    CUSTOMER,
    FISCALYEAR,
    GLACCOUNT,
    LEDGER,
    LIQUIDITYITEM,
    PLANNINGLEVEL,
    SOURCELEDGER,
    SUPPLIER,
    TRANSACTIONDATE,
    ACTIVECHARTOFACCOUNTS,
    ACTIVEGLACCOUNT,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BALANCECURRENCY,
    BANKSTATEMENTSHORTID,
    BPCUSTOMERNAME,
    BPSUPPLIERNAME,
    BUSINESSPARTNERNAME,
    CASHBALANCEAMOUNT,
    CASHBALANCEAMOUNTINDSPCURRENCY,
    CASHBALANCECHANNEL,
    CASHBALANCECREATEDATDATETIME,
    CASHBALANCECURRENCY,
    CASHBALANCEDATE,
    CASHBALANCEKEY,
    CASHFLOWDIRECTION,
    CERTAINTYLEVEL,
    COMPANYCODECURRENCY,
    COUNTRYCHARTOFACCOUNTS,
    CREATEDBYUSER,
    CUSTBALALTVGLACCOUNTINFO,
    CUSTOMERACCOUNTGROUP,
    CUSTOMERCITYNAME,
    CUSTOMERCOUNTRY,
    CUSTOMERNAME,
    CUSTOMERREGION,
    CUSTOMERSEARCHTERM,
    CUSTOMERVATREGISTRATION,
    DISPLAYCURRENCY,
    FISCALPERIOD,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    ORIGINDOCUMENT,
    REPORTINGCURRENCY,
    SUPPLIERACCOUNTGROUP,
    SUPPLIERCITYNAME,
    SUPPLIERCOUNTRY,
    SUPPLIERNAME,
    SUPPLIERREGION,
    SUPPLIERSEARCHTERM,
    SUPPLIERVATREGISTRATION,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (BANKACCOUNTID, BANKACCOUNTINTERNALID, BUSINESSPARTNER, CASHBALANCETYPE, CASHPLANNINGGROUP, CHARTOFACCOUNTS, COMPANYCODE, CUSTOMER, FISCALYEAR, GLACCOUNT, LEDGER, LIQUIDITYITEM, PLANNINGLEVEL, SOURCELEDGER, SUPPLIER, TRANSACTIONDATE)
);