_FIXEDASSET

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 _FIXEDASSET (
    _ASSETACCOUNTDETERMINATION,
    _ASSETCLASS,
    _ASSETCOUNTRYOFORIGIN,
    _FIXEDASSETGROUP,
    _GROUP1ASSETEVALUATIONKEY,
    _GROUP2ASSETEVALUATIONKEY,
    _GROUP3ASSETEVALUATIONKEY,
    _GROUP4ASSETEVALUATIONKEY,
    _GROUP5ASSETEVALUATIONKEY,
    _INVESTMENTORDER,
    _PARTNERCOMPANY,
    _SUPPLIER,
    ACCOUNTISBLOCKEDFORPOSTING,
    ACCOUNTISMARKEDFORDELETION,
    ASSETACCOUNTDETERMINATION,
    ASSETADDITIONALDESCRIPTION,
    ASSETAUTHORIZATIONCONTEXT,
    ASSETCLASS,
    ASSETCOUNTRYOFORIGIN,
    ASSETMANUFACTURERNAME,
    ASSETSCREENLAYOUT,
    ASSETSERIALNUMBER,
    ASSETSUPPLIERNAME,
    ASSETUNDERCONSTISINVMTMSR,
    BASEUNIT,
    CREATEDBYUSER,
    CREATIONDATE,
    FIXEDASSETDESCRIPTION,
    FIXEDASSETEXTERNALID,
    FIXEDASSETGROUP,
    GROUP1ASSETEVALUATIONKEY,
    GROUP2ASSETEVALUATIONKEY,
    GROUP3ASSETEVALUATIONKEY,
    GROUP4ASSETEVALUATIONKEY,
    GROUP5ASSETEVALUATIONKEY,
    INVENTORY,
    INVENTORYISCOUNTED,
    INVESTMENTORDER,
    INVESTMENTPROJECTWBSELEMENT,
    INVESTMENTREASON,
    ISLINEITEMSETTLED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTINVENTORYDATE,
    LASTRETIREMENTVALUEDATE,
    ORIGINALACQUISITIONFISCALYEAR,
    PARTNERCOMPANY,
    SUPPLIER
);