I_DFS_EQUIPMENTBASICDEX

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.

-- Defense Equipment Extractor
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DFS_EQUIPMENTBASICDEX (
    EQUIPMENT,
    ACQUISITIONDATE,
    ACQUISITIONVALUE,
    BATCH,
    CREATIONDATE,
    CURRENCY,
    DFSMAINTACTUALCONFIGURATION,
    DFSMAINTAREADESCRIPTION,
    DFSMAINTAREAID,
    DFSMAINTEQUIPMENTTYPE,
    DFSMAINTEQUIPOPLOBJNMBR,
    DFSMAINTEQUIPOPLSTATUSPROFILE,
    DFSMAINTEQUIPTECHSTATUSPROFILE,
    DFSMAINTEQUIPTECHSTSPRFLNAME,
    DFSMAINTISFOREIGNEQUIPMENT,
    DFSMAINTISMASTEREQUIPMENT,
    DFSMAINTMASTEREQUIPTECHOBJNMBR,
    DFSMAINTMEASURINGPOINT,
    DFSMAINTMODELDESCRIPTION,
    DFSMAINTMODELIDENTIFICATION,
    DFSMAINTPRIORITIZATIONCATEGORY,
    DFSMAINTREMARKTEXT,
    DFSMAINTSITEDESCRIPTION,
    DFSMAINTSITEID,
    DFSMAINTTAILNUMBER,
    DFSMAINTTECHSTSAGGRGNISSTPPD,
    DFSMAINTUSAGEPREFPRIORITY,
    EQUIPMENTCATEGORY,
    FORCEELEMENTORGID,
    INVENTORYNUMBER,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    MAINTOBJECTINTERNALID,
    MATERIAL,
    OPERATIONSTARTDATE,
    PLANT,
    STORAGELOCATION,
    TECHNICALOBJECTTYPE,
    PRIMARY KEY (EQUIPMENT)
);