ASSETBALANCE

29 Fields

ASSETBALANCE is an SAP database table in S/4HANA. It contains 29 fields.

Fields (29)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 3
KEY AssetAccountingKeyFigure AssetAccountingKeyFigure 2
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet 2
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn 2
KEY AssetDepreciationArea AssetDepreciationArea 2
KEY CompanyCode CompanyCode 3
KEY CurrencyRole CurrencyRole 2
KEY DebitCreditCode DebitCreditCode 2
KEY FiscalPeriod FiscalPeriod 2
KEY FiscalYear FiscalYear 3
KEY FixedAsset FixedAsset 2
KEY Ledger Ledger 2
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY MasterFixedAsset MasterFixedAsset 2
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 2
KEY TransactionSubitem TransactionSubitem 2
AmountInDisplayCurrency AmountInDisplayCurrency 2
AssetAccountingSortedKeyFigure AssetAccountingSortedKeyFigure 2
AssetAmountInReportingCurrency AssetAmountInReportingCurrency 1
ChartOfAccounts ChartOfAccounts 1
DepreciationFiscalPeriod DepreciationFiscalPeriod 2
DisplayCurrency DisplayCurrency 2
FiscalYearPeriod FiscalYearPeriod 2
FiscalYearVariant FiscalYearVariant 2
GLAccount GLAccount 1
IntngblAstAmtznAmtInRptgCrcy IntngblAstAmtznAmtInRptgCrcy 1
LedgerFiscalYear LedgerFiscalYear 2
LedgerGroup LedgerGroup 2
PostingDate PostingDate 2

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 ASSETBALANCE (
    ACCOUNTINGDOCUMENT,
    ASSETACCOUNTINGKEYFIGURE,
    ASSETACCOUNTINGKEYFIGURESET,
    ASSETACCTTRANSCLASSFCTN,
    ASSETDEPRECIATIONAREA,
    COMPANYCODE,
    CURRENCYROLE,
    DEBITCREDITCODE,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDASSET,
    LEDGER,
    LEDGERGLLINEITEM,
    MASTERFIXEDASSET,
    SUBLEDGERACCTLINEITEMTYPE,
    TRANSACTIONSUBITEM,
    AMOUNTINDISPLAYCURRENCY,
    ASSETACCOUNTINGSORTEDKEYFIGURE,
    ASSETAMOUNTINREPORTINGCURRENCY,
    CHARTOFACCOUNTS,
    DEPRECIATIONFISCALPERIOD,
    DISPLAYCURRENCY,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    GLACCOUNT,
    INTNGBLASTAMTZNAMTINRPTGCRCY,
    LEDGERFISCALYEAR,
    LEDGERGROUP,
    POSTINGDATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ASSETACCOUNTINGKEYFIGURE, ASSETACCOUNTINGKEYFIGURESET, ASSETACCTTRANSCLASSFCTN, ASSETDEPRECIATIONAREA, COMPANYCODE, CURRENCYROLE, DEBITCREDITCODE, FISCALPERIOD, FISCALYEAR, FIXEDASSET, LEDGER, LEDGERGLLINEITEM, MASTERFIXEDASSET, SUBLEDGERACCTLINEITEMTYPE, TRANSACTIONSUBITEM)
);

Learn More