BALANCE

69 Fields

BALANCE is an SAP database table in S/4HANA. It contains 69 fields.

Fields (69)

KeyField CDS FieldsUsed in Views
KEY BankAccountCurrency BankAccountCurrency,OriginalTransactionCurrency,TransactionCurrency 6
KEY BankAccountId BankAccountId 3
KEY BankAccountInternalID BankAccountInternalID 7
KEY BusinessPartner BusinessPartner 3
KEY CalendarDate CalendarDate 2
KEY CashBalanceType CashBalanceType 2
KEY CashPlanningGroup CashPlanningGroup 2
KEY ChartOfAccounts ChartOfAccounts 9
KEY CompanyCode CompanyCode 27
KEY Currency Currency,OriginalTransactionCurrency,TransactionCurrency 3
KEY Customer CustBalCustomerInfo,Customer 7
KEY FiscalYear FiscalYear 10
KEY GLAccount GLAccount 16
KEY Ledger Ledger 14
KEY LiquidityItem LiquidityItem 4
KEY PlanningGroup PlanningGroup 2
KEY PlanningLevel PlanningLevel 6
KEY SourceLedger SourceLedger 12
KEY Supplier CustBalSupplierInfo,Supplier 7
KEY TransactionCurrency TransactionCurrency 3
KEY TransactionDate TransactionDate 7
KEY ValidFrom ValidFrom 1
KEY ValidTo ValidTo 1
ActiveChartOfAccounts ActiveChartOfAccounts 4
ActiveGLAccount ActiveGLAccount 4
AlternativeGLAccount AlternativeGLAccount 6
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 2
BalanceCurrency Currency 1
Bank Bank 6
BankAccount BankAccount 6
BankAccountStatus BankAccountStatus 1
BankAccountType BankAccountType 1
BankCountry BankCountry,Country 6
BankStatementShortID BankStatementShortID 1
BPCustomerName BPCustomerName 1
BPSupplierName BPSupplierName 1
BusinessPartnerName BusinessPartnerName 2
CashBalanceChannel CashBalanceChannel 1
CashBalanceCreatedAtDateTime CashBalanceCreatedAtDateTime 1
CashBalanceDate CashBalanceDate 1
CashFlowDirection CashFlowDirection 1
CertaintyLevel CertaintyLevel 1
CompanyCodeCurrency CompanyCodeCurrency 15
CountryChartOfAccounts CountryChartOfAccounts 4
CreatedByUser CreatedByUser 1
CustBalAltvGLAccountInfo CustBalAltvGLAccountInfo 2
CustomerAccountGroup CustomerAccountGroup 1
CustomerCityName CustomerCityName 1
CustomerCountry CustomerCountry 1
CustomerName CustomerName 1
CustomerRegion CustomerRegion 1
CustomerSearchTerm CustomerSearchTerm 1
CustomerVATRegistration CustomerVATRegistration 1
FiscalPeriod FiscalPeriod 2
FlowType FlowType 2
HouseBank HouseBank 2
HouseBankAccount HouseBankAccount 2
IBAN IBAN 2
OrganizationBPName1 OrganizationBPName1 2
OrganizationBPName2 OrganizationBPName2 2
OriginDocument OriginDocument 1
SupplierAccountGroup SupplierAccountGroup 1
SupplierCityName SupplierCityName 1
SupplierCountry SupplierCountry 1
SupplierName SupplierName 1
SupplierRegion SupplierRegion 1
SupplierSearchTerm SupplierSearchTerm 1
SupplierVATRegistration SupplierVATRegistration 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 BALANCE (
    BANKACCOUNTCURRENCY,
    BANKACCOUNTID,
    BANKACCOUNTINTERNALID,
    BUSINESSPARTNER,
    CALENDARDATE,
    CASHBALANCETYPE,
    CASHPLANNINGGROUP,
    CHARTOFACCOUNTS,
    COMPANYCODE,
    CURRENCY,
    CUSTOMER,
    FISCALYEAR,
    GLACCOUNT,
    LEDGER,
    LIQUIDITYITEM,
    PLANNINGGROUP,
    PLANNINGLEVEL,
    SOURCELEDGER,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    TRANSACTIONDATE,
    VALIDFROM,
    VALIDTO,
    ACTIVECHARTOFACCOUNTS,
    ACTIVEGLACCOUNT,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BALANCECURRENCY,
    BANK,
    BANKACCOUNT,
    BANKACCOUNTSTATUS,
    BANKACCOUNTTYPE,
    BANKCOUNTRY,
    BANKSTATEMENTSHORTID,
    BPCUSTOMERNAME,
    BPSUPPLIERNAME,
    BUSINESSPARTNERNAME,
    CASHBALANCECHANNEL,
    CASHBALANCECREATEDATDATETIME,
    CASHBALANCEDATE,
    CASHFLOWDIRECTION,
    CERTAINTYLEVEL,
    COMPANYCODECURRENCY,
    COUNTRYCHARTOFACCOUNTS,
    CREATEDBYUSER,
    CUSTBALALTVGLACCOUNTINFO,
    CUSTOMERACCOUNTGROUP,
    CUSTOMERCITYNAME,
    CUSTOMERCOUNTRY,
    CUSTOMERNAME,
    CUSTOMERREGION,
    CUSTOMERSEARCHTERM,
    CUSTOMERVATREGISTRATION,
    FISCALPERIOD,
    FLOWTYPE,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    IBAN,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    ORIGINDOCUMENT,
    SUPPLIERACCOUNTGROUP,
    SUPPLIERCITYNAME,
    SUPPLIERCOUNTRY,
    SUPPLIERNAME,
    SUPPLIERREGION,
    SUPPLIERSEARCHTERM,
    SUPPLIERVATREGISTRATION,
    PRIMARY KEY (BANKACCOUNTCURRENCY, BANKACCOUNTID, BANKACCOUNTINTERNALID, BUSINESSPARTNER, CALENDARDATE, CASHBALANCETYPE, CASHPLANNINGGROUP, CHARTOFACCOUNTS, COMPANYCODE, CURRENCY, CUSTOMER, FISCALYEAR, GLACCOUNT, LEDGER, LIQUIDITYITEM, PLANNINGGROUP, PLANNINGLEVEL, SOURCELEDGER, SUPPLIER, TRANSACTIONCURRENCY, TRANSACTIONDATE, VALIDFROM, VALIDTO)
);

Learn More