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]
    DUMMY_EQUI_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    EQEXT_ACTIVE,            -- Append DFPS [/ISDFPS/DE_LM_DB_EQEXT_ACTIVE]
    CERT_DATE,               -- Certification date [/SAPCE/IURU_CERT_DATE]
    NXT_REPL_DATE,           -- Next repl. date [/SAPCE/IURU_NXTREPL_DATE]
    PER_REPL_DATE,           -- Per replacement date [/SAPCE/IURU_PER_REPL_DATE]
    EQUI_SRTYPE,             -- Report Type [COCF_SR_SRTYPE]
    EQUI_SNTYPE,             -- Shift Note Type [COCF_SN_SNTYPE]
    EQLB_DUTY,               -- Logbk Duty [DIACL_DUTY]
    EQLB_HIDE,               -- Hide Logbook [DIACL_HIDE]
    J_3GDISPO,               -- Plan. ind. [J_3GDISPO]
    J_3GZDEQUI,              -- C/D equipment [J_3GZDEQUI]
    J_3GEQART,               -- Procrmnt type [J_3GEQART]
    J_3GKZMENG,              -- Item/multipart [J_3GKZMENG]
    J_3GKONDE,               -- Mat. Price Grp [KONDM]
    J_3GFIKTIV,              -- Fictitious [J_3GFIKTIV]
    J_3GBELTYP,              -- Doc. cat. allow [J_3GBELTYP]
    MEINS,                   -- Base Unit [MEINS]
    J_3GKZLADG,              -- Load. costs [J_3GKZLADG]
    J_3GKZBERG,              -- Provision fee [J_3GKZBERG]
    J_3GEIFR,                -- Own/external [J_3GEIFR]
    J_3GVERMEIN,             -- Un/meas settl. [J_3GVERMEIN]
    J_3GZULNR,               -- Lic. plate no. [J_3GLICENCE_NUM]
    PRIMARY KEY (MANDT, EQUNR)
);