EQUZ

Transparent Table Application Table
59 Fields 3 CDS Views

Equipment time segment

EQUZ is an SAP database table in S/4HANA. Equipment time segment. It contains 59 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_DfsLocationAddress view from BASIC Location and Account Assignment
I_DfsLocationCost view inner BASIC Location and Account Assignment
I_EquipmentTimeSeg view from BASIC Equipment Time Segment

Fields (59)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY equnr EQUNR Equipment
KEY datbi DATBI Valid To
KEY eqlfn EQLFN ConsecNumber
equzn EQNNR NxtUsgePeriod
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
timbi TIMBI Time
estai RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
estae RESERVE_CHAR_004 SAP Development reserve: Format CHAR, length 4
stnam RESERVE_CHAR_012 SAP Development Reserve: Format CHAR, Length 12
lvorm RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
datab DATAB Valid From
iwerk IWERK Planning Plant
iwerki INHER Data origin
submt SUBMT ConstType
mapar MAPAR ManufPartNo.
hequi HEQUI Superord.Equip.
heqnr HEQNR Position
ingrp INGRP Planner Group
ingrpi INHER Data origin
pm_objty PM_OBJTY Object Type
gewrk LGWID Work Center
gewrki INHER Data origin
tidnr TIDNR TechIdentNo.
tidnri INHER Data origin
iloan ILOAN Loc/AccAssmt
kund1 KUND1 Customer
kund2 KUND2 End customer
kund3 KUND3 Operator
liznr LIZNR License no.
rbnr RBNR Catalog Profile
ezdat EQDAT Date
ezber EQBER Note
eznum EQNUM Field
rbnr_i INHER Data origin
iblnr IBLNR Phys. Inv. Doc.
bldat BLDAT Document Date
pvs_focus PVS_GUID_CCC GUID
ppeguid PVS_GUID_CCC GUID
techs TECHS StandardVariant
funcid CCC_FUNCID Function ID
frcfit CCC_FRCFIT Force I
frcrmv CCC_FRCRMV Force Dismant.
segchangeddatetime TZNTSTMPS Time Stamp
ref_designator MPE_RTGV_BOM_REF_DESIGNATOR Ref. Designator
pvs_node PVS_PNGUID Internal Number
pvs_otype PVS_OTYPE Object Type
pvs_applobj_type PVS_APPLOBJ_TYPE Applic. Object Type
top_equi EQUNR Equipment
top_equi_flag XFELD Checkbox
logiknr_wa LOGIKNR Log. dev. no.
j_3geigner J_3GEIGNER Owner
j_3gverwal J_3GVERWAL Administrator
j_3gpmaufe J_3GPMAUFE PM order owner
j_3gpmaufv J_3GPMAUFV PM order admin.
j_3gpacht J_3GPACHT Leasing type

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 time segment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EQUZ (
    MANDT,               -- Client [MANDT]
    EQUNR,               -- Equipment [EQUNR]
    DATBI,               -- Valid To [DATBI]
    EQLFN,               -- ConsecNumber [EQLFN]
    EQUZN,               -- NxtUsgePeriod [EQNNR]
    ERDAT,               -- Created On [ERDAT]
    ERNAM,               -- Created By [ERNAM]
    AEDAT,               -- Changed On [AEDAT]
    AENAM,               -- Changed By [AENAM]
    TIMBI,               -- Time [TIMBI]
    ESTAI,               -- SAP Development Reserve: Format CHAR, Length 1 [RESERVE_CHAR_001]
    ESTAE,               -- SAP Development reserve: Format CHAR, length 4 [RESERVE_CHAR_004]
    STNAM,               -- SAP Development Reserve: Format CHAR, Length 12 [RESERVE_CHAR_012]
    LVORM,               -- SAP Development Reserve: Format CHAR, Length 1 [RESERVE_CHAR_001]
    DATAB,               -- Valid From [DATAB]
    IWERK,               -- Planning Plant [IWERK]
    IWERKI,              -- Data origin [INHER]
    SUBMT,               -- ConstType [SUBMT]
    MAPAR,               -- ManufPartNo. [MAPAR]
    HEQUI,               -- Superord.Equip. [HEQUI]
    HEQNR,               -- Position [HEQNR]
    INGRP,               -- Planner Group [INGRP]
    INGRPI,              -- Data origin [INHER]
    PM_OBJTY,            -- Object Type [PM_OBJTY]
    GEWRK,               -- Work Center [LGWID]
    GEWRKI,              -- Data origin [INHER]
    TIDNR,               -- TechIdentNo. [TIDNR]
    TIDNRI,              -- Data origin [INHER]
    ILOAN,               -- Loc/AccAssmt [ILOAN]
    KUND1,               -- Customer [KUND1]
    KUND2,               -- End customer [KUND2]
    KUND3,               -- Operator [KUND3]
    LIZNR,               -- License no. [LIZNR]
    RBNR,                -- Catalog Profile [RBNR]
    EZDAT,               -- Date [EQDAT]
    EZBER,               -- Note [EQBER]
    EZNUM,               -- Field [EQNUM]
    RBNR_I,              -- Data origin [INHER]
    IBLNR,               -- Phys. Inv. Doc. [IBLNR]
    BLDAT,               -- Document Date [BLDAT]
    PVS_FOCUS,           -- GUID [PVS_GUID_CCC]
    PPEGUID,             -- GUID [PVS_GUID_CCC]
    TECHS,               -- StandardVariant [TECHS]
    FUNCID,              -- Function ID [CCC_FUNCID]
    FRCFIT,              -- Force I [CCC_FRCFIT]
    FRCRMV,              -- Force Dismant. [CCC_FRCRMV]
    SEGCHANGEDDATETIME,  -- Time Stamp [TZNTSTMPS]
    REF_DESIGNATOR,      -- Ref. Designator [MPE_RTGV_BOM_REF_DESIGNATOR]
    PVS_NODE,            -- Internal Number [PVS_PNGUID]
    PVS_OTYPE,           -- Object Type [PVS_OTYPE]
    PVS_APPLOBJ_TYPE,    -- Applic. Object Type [PVS_APPLOBJ_TYPE]
    TOP_EQUI,            -- Equipment [EQUNR]
    TOP_EQUI_FLAG,       -- Checkbox [XFELD]
    LOGIKNR_WA,          -- Log. dev. no. [LOGIKNR]
    J_3GEIGNER,          -- Owner [J_3GEIGNER]
    J_3GVERWAL,          -- Administrator [J_3GVERWAL]
    J_3GPMAUFE,          -- PM order owner [J_3GPMAUFE]
    J_3GPMAUFV,          -- PM order admin. [J_3GPMAUFV]
    J_3GPACHT,           -- Leasing type [J_3GPACHT]
    PRIMARY KEY (MANDT, EQUNR, DATBI, EQLFN)
);

Learn More