FIXEDASSETTRANSACTION

FIXEDASSETTRANSACTION is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 3
KEY AssetDepreciationArea AssetDepreciationArea 4
KEY CompanyCode CompanyCode 4
KEY FiscalYear FiscalYear 4
KEY FixedAsset FixedAsset 4
KEY Ledger Ledger 4
KEY MasterFixedAsset MasterFixedAsset 4
AssetAccountDetermination AssetAccountDetermination 2
AssetCapitalizationDate AssetCapitalizationDate 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 FIXEDASSETTRANSACTION (
    ACCOUNTINGDOCUMENT,
    ASSETDEPRECIATIONAREA,
    COMPANYCODE,
    FISCALYEAR,
    FIXEDASSET,
    LEDGER,
    MASTERFIXEDASSET,
    ASSETACCOUNTDETERMINATION,
    ASSETCAPITALIZATIONDATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ASSETDEPRECIATIONAREA, COMPANYCODE, FISCALYEAR, FIXEDASSET, LEDGER, MASTERFIXEDASSET)
);