I_TECHNICALOBJECT

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.

-- Technical Object
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TECHNICALOBJECT (
    EQUIPMENT,
    TECHNICALOBJECT,
    TECHNICALOBJECTLABEL,
    TECHOBJISEQUIPORFUNCNLLOC,
    _CREATEDBYUSER,
    _CURRENCY,
    _EQUIPMENT,
    _FUNCTIONALLOCATION,
    _FUNCTIONALLOCATIONLABEL,
    _ISDELETED,
    _LASTCHANGEDBYUSER,
    _LOCATIONACCOUNTASSIGNMENT,
    _MAINTENANCEPLANNERGROUP,
    _MAINTENANCEPLANNINGPLANT,
    _MANUFACTURERCOUNTRY,
    _STATUSOBJECTACTIVESTATUS,
    _TECHNICALOBJECTCATEGORY,
    _TECHNICALOBJECTCODECATALOG,
    _TECHNICALOBJECTHIERARCHY,
    _TECHNICALOBJECTTEXT,
    _TECHNICALOBJECTTYPE,
    _TECHOBJISEQUIPORFUNCNLLOC,
    _WORKCENTER,
    _WORKCENTERTYPE,
    ACQUISITIONDATE,
    ACQUISITIONVALUE,
    ASSETMANUFACTURERNAME,
    AUTHORIZATIONGROUP,
    CATALOGPROFILE,
    CONSTRUCTIONMONTH,
    CONSTRUCTIONYEAR,
    CREATEDBYUSER,
    CREATIONDATE,
    CURRENCY,
    FUNCTIONALLOCATION,
    GROSSWEIGHT,
    GROSSWEIGHTUNIT,
    INVENTORYNUMBER,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTOBJECTINTERNALID,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    MANUFACTURERCOUNTRY,
    MANUFACTURERPARTNMBR,
    MANUFACTURERPARTTYPENAME,
    MANUFACTURERSERIALNUMBER,
    SIZEORDIMENSIONTEXT,
    SUPERIOROBJISEQUIPORFUNCNLLOC,
    SUPERIORTECHNICALOBJECT,
    SUPERIORTECHNICALOBJECTLABEL,
    SUPERIORTECHNICALOBJECTNAME,
    TECHNICALOBJECTCATEGORY,
    TECHNICALOBJECTDESCRIPTION,
    TECHNICALOBJECTHASLONGTEXT,
    TECHNICALOBJECTSORTCODE,
    TECHNICALOBJECTTYPE,
    TECHOBJECTSORTCODESEARCHABLE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (EQUIPMENT, TECHNICALOBJECT, TECHNICALOBJECTLABEL, TECHOBJISEQUIPORFUNCNLLOC)
);