EQUI

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.

-- Equipment master data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EQUI (
    MANDT,            -- Client [mandt]
    EQUNR,            -- Equipment [equnr]
    ERDAT,            -- Created On [erdat]
    ERNAM,            -- Created By [ernam]
    EQASP,            -- Primary lang. [eqasp]
    AEDAT,            -- Changed On [aedat]
    AENAM,            -- Changed By [aenam]
    BEGRU,            -- AuthorizGroup [iautg]
    EQTYP,            -- EquipCategory [eqtyp]
    EQART,            -- Object Type [eqart]
    LVORM,            -- SAP Development Reserve: Format CHAR, Length 1 [reserve_char_001]
    INVNR,            -- Inventory No. [invnr]
    GROES,            -- Size/dimens. [gross]
    BRGEW,            -- Weight [obj_weight]
    GEWEI,            -- Unit of weight [weight_unit]
    ANSDT,            -- Acquistion date [andti]
    ANSWT,            -- AcquistnValue [answt]
    WAERS,            -- Currency [waers]
    ELIEF,            -- Vendor [elief]
    GWLEN,            -- Warranty end [gwlen]
    GWLDT,            -- Warranty Start [gwldt]
    WDBWT,            -- ReplValue [wdbwt]
    HERST,            -- Manufacturer [herst]
    HERLD,            -- Mfr Ctry/Reg [herld]
    HZEIN,            -- Drawing no. [hzein]
    SERGE,            -- Manuf. SerialNr [serge]
    TYPBZ,            -- Model number [typbz]
    BAUJJ,            -- ConstructYear [baujj]
    BAUMM,            -- ConstructMth [baumm]
    APLKZ,            -- Task list [aplkz]
    AULDT,            -- Delivery date [auldt]
    INBDT,            -- Start-up date [ilom_datab]
    GERNR,            -- Serial Number [gernr]
    EQLFN,            -- ConsecNumber [eqlfn]
    GWLDV,            -- Warranty date [gwldv]
    EQDAT,            -- Date [eqdat]
    EQBER,            -- Note [eqber]
    EQNUM,            -- Field [eqnum]
    OBJNR,            -- Object number [j_objnr]
    EQSNR,            -- Number [eqsnr]
    CUOBJ,            -- Int. object no. [cuobj]
    KRFKZ,            -- Referenced [krfkz]
    KMATN,            -- Config.material [kmatn]
    MATNR,            -- Material [matnr]
    SERNR,            -- Serial Number [gernr]
    WERK,             -- Plant [werks_d]
    LAGER,            -- Location [lgort_d]
    CHARGE,           -- Batch [charg_d]
    KUNDE,            -- CurCustomer [kundse]
    WARPL,            -- MaintenancePlan [warpl]
    IMRC_POINT,       -- Measuring point [imrc_point]
    REVLV,            -- Revision Level [revlv]
    MGANR,            -- Master warranty [mganr]
    BEGRUI,           -- AuthGrp orig. [inh_begrui]
    S_EQUI,           -- Equipment data [equip_knz]
    S_SERIAL,         -- Serial [kzksd]
    S_KONFI,          -- Configuration [konfknz]
    S_SALE,           -- Sales [sdknz]
    S_FHM,            -- ProdRes/Tools [fhmkz]
    S_ELSE,           -- Other data [else_knz]
    S_ISU,            -- IS-U [isu_knz]
    S_EQBS,           -- EQSI exists [kzeqbs]
    S_FLEET,          -- FleetObjectData [fleet_knz]
    BSTVP,            -- Stock check [bstvp]
    SPARTE,           -- Division [sparte]
    HANDLE,           -- Handle [itobtmp_tsegguid]
    TSEGTP,           -- Template [itobtmp_tsegtempla]
    EMATN,            -- MPN: Material [ematn]
    ACT_CHANGE_AA,    -- Change equipment [aapm_act_change_aa]
    S_CC,             -- CC [ccc_knz]
    DATLWB,           -- Date L.GoodsMvt [datlwb]
    UII,              -- UII [uii_char72]
    IUID_TYPE,        -- IUID Type [iuid_type]
    UII_PLANT,        -- Resp. Plant UII [uii_plant]
    CHANGEDDATETIME,  -- Time Stamp [tzntstmps]
    ENDOFUSE,         -- End-of-Use Date [endofuse_date]
    EQUIPMENTOID,     -- Equip Obj Instce ID [equipment_oid]
    PRIMARY KEY (MANDT, EQUNR)
);