ASSETHISTORY

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 ASSETHISTORY (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGPRINCIPLE,
    ACQNPRODNCOSTGLACCOUNT,
    ALTERNATIVEGLACCOUNT,
    ASSETACCOUNTINGSORTEDKEYFIGURE,
    ASSETACCTTRANSCLASSFCTN,
    ASSETADDITIONALDESCRIPTION,
    ASSETBUDGETPERIOD,
    ASSETBUSINESSAREA,
    ASSETCAPITALIZATIONDATE,
    ASSETCLASS,
    ASSETCOSTCENTER,
    ASSETCOSTCTRACTIVITYTYPE,
    ASSETDEACTIVATIONDATE,
    ASSETDEPRECIATIONAREA,
    ASSETFUNCTIONALAREA,
    ASSETFUND,
    ASSETFUNDSCENTER,
    ASSETGRANT,
    ASSETLOCATION,
    ASSETPERSONNELNUMBER,
    ASSETPLANT,
    ASSETPROFITCENTER,
    ASSETREVALUATIONINDEX,
    ASSETSEGMENT,
    ASSETSERIALNUMBER,
    ASSETSUPPLIERNAME,
    ASSETTRANSACTIONTYPE,
    ASSETWBSELEMENTEXTERNALID,
    BASEUNIT,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSTRANSACTIONCATEGORY,
    BUSINESSTRANSACTIONTYPE,
    CHARTOFACCOUNTS,
    CHARTOFDEPRECIATION,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY,
    COUNTRYCHARTOFACCOUNTS,
    CREATIONTIME,
    DEPRECIATIONKEY,
    DEPRECIATIONSTARTDATE,
    DISPLAYCURRENCY,
    FINANCIALACCOUNTTYPE,
    FINANCIALCLOSINGSTEP,
    FINANCIALMANAGEMENTAREA,
    FINANCIALSTATEMENTVARIANT,
    FIRSTACQUISITIONFISCALPERIOD,
    FIRSTACQUISITIONFISCALYEAR,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARVARIANT,
    FIXEDASSET,
    FIXEDASSETGROUP,
    FIXEDASSETUSAGEOBJECT,
    FUNCTIONALAREA,
    FUND,
    FUNDSCENTER,
    GLACCOUNT,
    GRANTID,
    GROUP1ASSETEVALUATIONKEY,
    GROUP2ASSETEVALUATIONKEY,
    GROUP3ASSETEVALUATIONKEY,
    GROUP4ASSETEVALUATIONKEY,
    GROUP5ASSETEVALUATIONKEY,
    INVENTORY,
    INVENTORYISCOUNTED,
    INVESTMENTORDER,
    INVESTMENTSUPPORTMEASURE,
    JOINTVENTURECOSTRECOVERYCODE,
    JP_PRPTYTXRPTCITY,
    JP_PRPTYTXRPTCLASSFCTNKEY,
    LASTINVENTORYDATE,
    LEDGER,
    LEDGERGROUP,
    MASTERFIXEDASSET,
    NATIONALCLASSIFICATION,
    PARTNERCOMPANYCODE,
    PARTNERFIXEDASSET,
    PARTNERMASTERFIXEDASSET,
    PERSONNELNUMBER,
    PLANNEDUSEFULLIFEINPERIODS,
    PLANNEDUSEFULLIFEINYEARS,
    PROFITCENTER,
    QUANTITY,
    REALESTATEOBJECT,
    REINTERNALFINNUMBER,
    ROOM,
    RU_ASSETDEPRECIATIONGROUP,
    RU_ASSETOKOF,
    SEGMENT,
    SPECIALDEPRSTARTDATE,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPPLIER,
    TAXDEPRECIATIONGROUP,
    TAXJURISDICTION,
    VEHICLELICENSEPLATENUMBER,
    WBSELEMENTEXTERNALID
);