ASTBAL

47 Fields

ASTBAL is an SAP database table in S/4HANA. It contains 47 fields.

Fields (47)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY AssetAccountingKeyFigure AssetAccountingKeyFigure 2
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet 2
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn 2
KEY AssetDepreciationArea AssetDepreciationArea 2
KEY CompanyCode CompanyCode 3
KEY DebitCreditCode DebitCreditCode 1
KEY FiscalPeriod FiscalPeriod 2
KEY FiscalYear FiscalYear 2
KEY FixedAsset FixedAsset 2
KEY Ledger Ledger 2
KEY MasterFixedAsset MasterFixedAsset 2
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 2
KEY TransactionSubitem TransactionSubitem 1
_AccountingDocumentType _AccountingDocumentType 1
_AssetAcctTransClassfctn _AssetAcctTransClassfctn 1
_AssetClass _AssetClass 1
_AssetKeyFigure _AssetKeyFigure 1
_AssetKeyFigureSet _AssetKeyFigureSet 1
_AssetTransactionType _AssetTransactionType 1
_BusinessTransactionCategory _BusinessTransactionCategory 1
_BusinessTransactionType _BusinessTransactionType 1
_ChartOfDepreciation _ChartOfDepreciation 1
_CompanyCode _CompanyCode 1
_DepreciationArea _DepreciationArea 1
_FiscalYear _FiscalYear 1
_FixedAsset _FixedAsset 1
_JournalEntry _JournalEntry 1
_Ledger _Ledger 1
_MasterFixedAsset _MasterFixedAsset 1
_SelectedCurrencyBranch _SelectedCurrencyBranch 1
AccountingDocumentCreationDate AccountingDocumentCreationDate 1
AccountingDocumentType AccountingDocumentType 1
AcqnProdnCostGLAccount AcqnProdnCostGLAccount 1
AssetAccountDetermination AssetAccountDetermination 1
AssetClass AssetClass 1
AssetTransactionType AssetTransactionType 1
AssetValueDate AssetValueDate 1
BusinessTransactionCategory BusinessTransactionCategory 1
BusinessTransactionType BusinessTransactionType 1
ChartOfDepreciation ChartOfDepreciation 2
DisplayCurrency DisplayCurrency 1
DocumentDate DocumentDate 1
IsReversal IsReversal 1
IsReversed IsReversed 1
PostingDate PostingDate 1
SelectedCurrencyBranch SelectedCurrencyBranch 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 ASTBAL (
    ACCOUNTINGDOCUMENT,
    ASSETACCOUNTINGKEYFIGURE,
    ASSETACCOUNTINGKEYFIGURESET,
    ASSETACCTTRANSCLASSFCTN,
    ASSETDEPRECIATIONAREA,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDASSET,
    LEDGER,
    MASTERFIXEDASSET,
    SUBLEDGERACCTLINEITEMTYPE,
    TRANSACTIONSUBITEM,
    _ACCOUNTINGDOCUMENTTYPE,
    _ASSETACCTTRANSCLASSFCTN,
    _ASSETCLASS,
    _ASSETKEYFIGURE,
    _ASSETKEYFIGURESET,
    _ASSETTRANSACTIONTYPE,
    _BUSINESSTRANSACTIONCATEGORY,
    _BUSINESSTRANSACTIONTYPE,
    _CHARTOFDEPRECIATION,
    _COMPANYCODE,
    _DEPRECIATIONAREA,
    _FISCALYEAR,
    _FIXEDASSET,
    _JOURNALENTRY,
    _LEDGER,
    _MASTERFIXEDASSET,
    _SELECTEDCURRENCYBRANCH,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTTYPE,
    ACQNPRODNCOSTGLACCOUNT,
    ASSETACCOUNTDETERMINATION,
    ASSETCLASS,
    ASSETTRANSACTIONTYPE,
    ASSETVALUEDATE,
    BUSINESSTRANSACTIONCATEGORY,
    BUSINESSTRANSACTIONTYPE,
    CHARTOFDEPRECIATION,
    DISPLAYCURRENCY,
    DOCUMENTDATE,
    ISREVERSAL,
    ISREVERSED,
    POSTINGDATE,
    SELECTEDCURRENCYBRANCH,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ASSETACCOUNTINGKEYFIGURE, ASSETACCOUNTINGKEYFIGURESET, ASSETACCTTRANSCLASSFCTN, ASSETDEPRECIATIONAREA, COMPANYCODE, DEBITCREDITCODE, FISCALPERIOD, FISCALYEAR, FIXEDASSET, LEDGER, MASTERFIXEDASSET, SUBLEDGERACCTLINEITEMTYPE, TRANSACTIONSUBITEM)
);

Learn More