FIXEDASSETVAL

34 Fields

FIXEDASSETVAL is an SAP database table in S/4HANA. It contains 34 fields.

Fields (34)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 3
KEY AssetAccountingKeyFigure AssetAccountingKeyFigure 1
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet 3
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn 1
KEY AssetDepreciationArea AssetDepreciationArea 1
KEY CompanyCode CompanyCode 3
KEY DebitCreditCode DebitCreditCode 1
KEY FiscalYear FiscalYear 3
KEY FixedAsset FixedAsset 3
KEY Ledger Ledger 2
KEY MasterFixedAsset MasterFixedAsset 3
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 1
_AssetAcctTransClassfctn _AssetAcctTransClassfctn 1
_AssetKeyFigure _AssetKeyFigure 1
_AssetKeyFigureSet _AssetKeyFigureSet 1
_AssetTransactionType _AssetTransactionType 1
_CompanyCode _CompanyCode 1
_ControllingArea _ControllingArea 1
_Country _Country 1
_DepreciationArea _DepreciationArea 1
_FiscalYear _FiscalYear 2
_FixedAsset _FixedAsset 1
_JournalEntry _JournalEntry 1
_Ledger _Ledger 2
_MasterFixedAsset _MasterFixedAsset 1
_SubLedgerAccLineItemType _SubLedgerAccLineItemType 1
AssetClass AssetClass 1
AssetSerialNumber AssetSerialNumber 1
AssetTransactionType AssetTransactionType 1
ControllingArea ControllingArea 1
Country Country 2
FiscalYearVariant FiscalYearVariant 1
Inventory Inventory 1
LedgerFiscalYear LedgerFiscalYear 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 FIXEDASSETVAL (
    ACCOUNTINGDOCUMENT,
    ASSETACCOUNTINGKEYFIGURE,
    ASSETACCOUNTINGKEYFIGURESET,
    ASSETACCTTRANSCLASSFCTN,
    ASSETDEPRECIATIONAREA,
    COMPANYCODE,
    DEBITCREDITCODE,
    FISCALYEAR,
    FIXEDASSET,
    LEDGER,
    MASTERFIXEDASSET,
    SUBLEDGERACCTLINEITEMTYPE,
    _ASSETACCTTRANSCLASSFCTN,
    _ASSETKEYFIGURE,
    _ASSETKEYFIGURESET,
    _ASSETTRANSACTIONTYPE,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COUNTRY,
    _DEPRECIATIONAREA,
    _FISCALYEAR,
    _FIXEDASSET,
    _JOURNALENTRY,
    _LEDGER,
    _MASTERFIXEDASSET,
    _SUBLEDGERACCLINEITEMTYPE,
    ASSETCLASS,
    ASSETSERIALNUMBER,
    ASSETTRANSACTIONTYPE,
    CONTROLLINGAREA,
    COUNTRY,
    FISCALYEARVARIANT,
    INVENTORY,
    LEDGERFISCALYEAR,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ASSETACCOUNTINGKEYFIGURE, ASSETACCOUNTINGKEYFIGURESET, ASSETACCTTRANSCLASSFCTN, ASSETDEPRECIATIONAREA, COMPANYCODE, DEBITCREDITCODE, FISCALYEAR, FIXEDASSET, LEDGER, MASTERFIXEDASSET, SUBLEDGERACCTLINEITEMTYPE)
);

Learn More