SE11 ABAP Dictionary SE11 EQUI

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

EQUI

Equipment master data
SAP SAP Transparent Table 90 Fields
Primary Key:
MANDT EQUNR

Dictionary Fields Fields

(90 dari 90 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
ERDAT
- On DATS 8 - - Date on Which Record Was Created
4
ERNAM
- Created CHAR 12 - - Name of Person who Created the Object
5
EQASP
- Language LANG 1 - - Language in Which the Piece of Equipment was Entered
6
AEDAT
- Chngd DATS 8 - - Changed On
7
AENAM
- By CHAR 12 - - Name of Person Who Changed Object
8
BEGRU
- AuthGrp CHAR 4 - - Technical object authorization group
9
EQTYP
- Category CHAR 1 - - Equipment category
10
EQART
- ObjectType CHAR 10 - - Type of Technical Object
11
LVORM
- SAP Development Reserve: Format CHAR, Length 1 CHAR 1 - - SAP Development Reserve: Format CHAR, Length 1
12
INVNR
- InvNo. CHAR 25 - - Inventory number
13
GROES
- Size CHAR 18 - - Size/dimension
14
BRGEW
- Weight QUAN 13 3 - Weight of object
15
GEWEI
- Unit UNIT 3 - - Unit of weight
16
ANSDT
- AcqDate DATS 8 - - Acquisition date
17
ANSWT
- Acq.value CURR 13 2 - Acquisition Value
18
WAERS
- Currency CUKY 5 - TCURC Currency Key
19
ELIEF
- Vendor CHAR 10 - - Vendor number
20
GWLEN
- WtyEnd DATS 8 - - Date on which the warranty ends
21
GWLDT
- Beg.guaran DATS 8 - - Guarantee date
22
WDBWT
- ReplVal. CURR 13 2 - Equipment replacement value
23
HERST
- Mfr CHAR 30 - - Manufacturer of asset
24
HERLD
- ManCtry CHAR 3 - - Country of manufacture
25
HZEIN
- Drawing CHAR 30 - - Manufacturer drawing number
26
SERGE
- SerNo. CHAR 30 - - Manufacturer serial number
27
TYPBZ
- Model no. CHAR 20 - - Manufacturer model number
28
BAUJJ
- ConstYr CHAR 4 - - Year of construction
29
BAUMM
- ConstMth CHAR 2 - - Month of construction
30
APLKZ
- Task list CHAR 1 - - Indicator: Task List Exists
31
AULDT
- DelDate DATS 8 - - First delivery date of the equipment
32
INBDT
- Start from DATS 8 - - Start-up Date of the Technical Object
33
GERNR
- Serial no. CHAR 18 - - Serial number
34
EQLFN
- ConsecNo. NUMC 3 - - Consecutive numbering of EquipUsagePeriods on same day
35
GWLDV
- Warranty DATS 8 - - Warranty date for Sales and Distribution
36
EQDAT
- Date DATS 8 - - Date, intended for SAP internal use
37
EQBER
- Note CHAR 30 - - Technical information, intended for SAP internal use
38
EQNUM
- Field NUMC 9 - - Numerical field, intended for SAP internal use
39
OBJNR
- Obj. no. CHAR 22 - - Object number
40
EQSNR
- Number CHAR 18 - - EQSE Number
41
CUOBJ
- Int.obj.no NUMC 18 - - Configuration (internal object number)
42
KRFKZ
- Reference CHAR 1 - - Referenced Configuration
43
KMATN
- ConfigMat CHAR 18 - - Configurable Material
44
MATNR
- Material CHAR 18 - MARA Material Number
45
SERNR
- Serial no. CHAR 18 - - Serial number
46
WERK
- Plant CHAR 4 - - Plant
47
LAGER
- Stor. Loc. CHAR 4 - - Storage Location
48
CHARGE
- Batch CHAR 10 - - Batch Number
49
KUNDE
- Customer CHAR 10 - - Customer to Whom Serial Number was Delivered
50
WARPL
- MntPlan CHAR 12 - - Maintenance Plan
51
IMRC_POINT
- MeasPoint CHAR 12 - - Measuring Point
52
REVLV
- Rev. Level CHAR 2 - - Revision Level
53
MGANR
- MasterWarr CHAR 20 - - Master warranty number
54
BEGRUI
- Origin CHAR 1 - - Data origin for authorization group field
55
S_EQUI
- Equi. Data CHAR 1 - - Equipment data exists
56
S_SERIAL
- SerialData CHAR 1 - - Serial data when maintaining equipment
57
S_KONFI
- Conf. CHAR 1 - - Configuration supported
58
S_SALE
- Sales CHAR 1 - - Sales equipment
59
S_FHM
- PRT CHAR 1 - - Equip. category relevant to production resources and tools
60
S_ELSE
- Other CHAR 1 - - Indicator: Other Data Active
61
S_ISU
- IS-U CHAR 1 - - IS-U data
62
S_EQBS
- SI exists CHAR 1 - - EQSI Exists
63
S_FLEET
- FleetObj. CHAR 1 - - Indicator: Fleet object active
64
BSTVP
- StockCheck CHAR 1 - - Stock Check for Serial Numbers
65
SPARTE
- Division CHAR 2 - - Division
66
HANDLE
- Handle CHAR 22 - - SAP Development Reserve: Integration of Date Segment (Key)
67
TSEGTP
- Template CHAR 10 - - SAP Development Reserve: Integration Date Segment (Tempate)
68
EMATN
- MPN Mat. CHAR 18 - - Material Number Corresponding to Manufacturer Part Number
69
ACT_CHANGE_AA
- Chng equip CHAR 1 - - Change Equipment Master when Changing Asset
70
S_CC
- CC CHAR 1 - - Configuration Control Data
71
DATLWB
- LstGdsMvt DATS 8 - - Date of Last Goods Movement
72
UII
- UII CHAR 72 - - Unique Item Identifier
73
IUID_TYPE
- IUID Type CHAR 10 - - Structure Type of UII
74
UII_PLANT
- Plant UII CHAR 4 - - Plant Responsible for UII
75
/GEP/PASSENGER
- Passengers NUMC 2 - - Number of Passengers
76
/GEP/AUTOM
- Automatic CHAR 1 - - Vehicle Equipment: Automatic Transmission
77
/GEP/KLIMA
- Air Cond. CHAR 1 - - Vehicle Equipment: Air Conditioning
78
/GEP/DACHG
- Roof Rack CHAR 1 - - Vehicle Equipment: Roof Rack
79
/GEP/SCHNEEK
- Snow Chain CHAR 1 - - Vehicle Equipment: Snow Chains
80
/GEP/WINTERR
- Snow Tyres CHAR 1 - - Vehicle Equipment: Snow Tyres
81
/GEP/VHCAT
- Veh. Type CHAR 2 - - Vehicle Type
82
/MRSS/ID_PROFILE
- Indicator CHAR 1 - - Requirements profile was changed manually
83
/MRSS/PROF_GUID
- GUID RAW 16 - - Profile GUID
84
/MRSS/PROF_KEY
- Profile CHAR 10 - - Profile key
85
/MRSS/DATACHANGE
- Changed: CHAR 1 - - Data was changed in the controls on the user screen
86
EQEXT_ACTIVE
- DFPS CHAR 1 - - Backpack Table /isdfps/lmeqext Active
87
EQUI_SRTYPE
- Type CHAR 10 - - Shift Report Type
88
EQUI_SNTYPE
- Note Type CHAR 2 - - Shift Note Type
89
EQLB_DUTY
- Logbk Duty CHAR 1 - - Logbook Duty
90
EQLB_HIDE
- Hide Logbk CHAR 1 - - Hide Logbook Display

Related References & SQL

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

ANSI SQL Query 
SELECT a.EQUNR,
       a.ERDAT,
       a.ERNAM,
       a.EQASP,
       a.AEDAT,
       a.AENAM
FROM EQUI AS a
WHERE a.EQUNR = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~equnr,
       a~erdat,
       a~ernam,
       a~eqasp,
       a~aedat,
       a~aenam
  FROM equi AS a
  WHERE a~equnr = '0001'
  INTO TABLE @DATA(lt_equi)
  UP TO 100 ROWS.
Mencari di seluruh SAP Knowledge Hub...
Tidak ditemukan hasil untuk ""
Cek "" langsung di Kamus SE11