SE11 ABAP Dictionary SE11 EQUZ

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

EQUZ

Equipment time segment
SAP SAP Transparent Table 46 Fields
Primary Key:
MANDT EQUNR DATBI EQLFN

Dictionary Fields Fields

(46 dari 46 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
EQUNR
KEY Equipment CHAR 18 - - Equipment Number
3
DATBI
KEY to DATS 8 - - Valid To Date
4
EQLFN
KEY ConsecNo. NUMC 3 - - Consecutive numbering of EquipUsagePeriods on same day
5
EQUZN
- NxtUsePd NUMC 3 - - Number of next EquipUsagePeriod on same day
6
ERDAT
- On DATS 8 - - Date on Which Record Was Created
7
ERNAM
- Created CHAR 12 - - Name of Person who Created the Object
8
AEDAT
- Chngd DATS 8 - - Changed On
9
AENAM
- By CHAR 12 - - Name of Person Who Changed Object
10
TIMBI
- Time TIMS 6 - - Equipment usage period time stamp
11
ESTAI
- SAP Development Reserve: Format CHAR, Length 1 CHAR 1 - - SAP Development Reserve: Format CHAR, Length 1
12
ESTAE
- SAP Development reserve: Format CHAR, length 4 CHAR 4 - - SAP Development reserve: Format CHAR, length 4
13
STNAM
- SAP Development Reserve: Format CHAR, Length 12 CHAR 12 - - SAP Development Reserve: Format CHAR, Length 12
14
LVORM
- SAP Development Reserve: Format CHAR, Length 1 CHAR 1 - - SAP Development Reserve: Format CHAR, Length 1
15
DATAB
- Valid From DATS 8 - - Valid-From Date
16
IWERK
- Plng plant CHAR 4 - - Maintenance Planning Plant
17
IWERKI
- Origin CHAR 1 - - Data origin indicator
18
SUBMT
- ConstType CHAR 18 - - Construction type material of the object
19
MAPAR
- ManParNo CHAR 30 - - Manufacturer part number
20
HEQUI
- SuperEq. CHAR 18 - - Superordinate Equipment
21
HEQNR
- Position CHAR 4 - - Equipment position at InstallLoc (Superior Equip./FunctLoc)
22
INGRP
- PlannerGrp CHAR 3 - - Planner Group for Customer Service and Plant Maintenance
23
INGRPI
- Origin CHAR 1 - - Data origin indicator
24
PM_OBJTY
- Type CHAR 2 - - Object Type of CIM Resources for Work Center
25
GEWRK
- WorkCtr NUMC 8 - - Object ID of the Work Center
26
GEWRKI
- Origin CHAR 1 - - Data origin indicator
27
TIDNR
- TechID CHAR 25 - - Technical identification number
28
TIDNRI
- Origin CHAR 1 - - Data origin indicator
29
ILOAN
- Loc/Acc. CHAR 12 - - Location and account assignment for technical object
30
KUND1
- Customer CHAR 10 - - Customer number
31
KUND2
- End cus. CHAR 10 - - End customer number
32
KUND3
- Operator CHAR 10 - - Operator
33
LIZNR
- License CHAR 20 - - Equipment license number
34
RBNR
- Cat. Prof. CHAR 9 - - Catalog Profile
35
EZDAT
- Date DATS 8 - - Date, intended for SAP internal use
36
EZBER
- Note CHAR 30 - - Technical information, intended for SAP internal use
37
EZNUM
- Field NUMC 9 - - Numerical field, intended for SAP internal use
38
RBNR_I
- Origin CHAR 1 - - Data origin indicator
39
IBLNR
- PhysInvDoc CHAR 10 - - Physical Inventory Document
40
BLDAT
- Doc. Date DATS 8 - - Document Date in Document
41
PVS_FOCUS
- GUID RAW 16 - - Internal Identification for PVS Objects
42
PPEGUID
- GUID RAW 16 - - Internal Identification for PVS Objects
43
TECHS
- StdVariant CHAR 12 - - Parameter Variant/Standard Variant
44
FUNCID
- FID CHAR 40 - - FID (Function Identifier)
45
FRCFIT
- Force I CHAR 1 - - Indicator: Forced Installation/Dismantling
46
FRCRMV
- Force Remo CHAR 1 - - Force Dismantling Flag

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk EQUZ.

Interactive ERD Diagrams
SAP PM & SD - Plant Maintenance Main Tables Relation →
Standard T-Codes
SE11 SE16
Related Tables
EQUI EQKT EQST IFLOT IFLOTX ILOA IHPA AUFK
ANSI SQL Query 
SELECT a.EQUNR,
       a.DATBI,
       a.EQLFN,
       a.EQUZN,
       a.ERDAT,
       a.ERNAM,
       a.AEDAT
FROM EQUZ AS a
WHERE a.EQUNR = '0001'
  AND a.DATBI = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~equnr,
       a~datbi,
       a~eqlfn,
       a~equzn,
       a~erdat,
       a~ernam,
       a~aedat
  FROM equz AS a
  WHERE a~equnr = '0001'
  and a~datbi = '0001'
  INTO TABLE @DATA(lt_equz)
  UP TO 100 ROWS.