SE11 ABAP Dictionary SE11 EQKT

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

EQKT

Equipment Short Texts
SAP SAP Transparent Table 7 Fields
Primary Key:
MANDT EQUNR SPRAS

Dictionary Fields Fields

(7 dari 7 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
SPRAS
KEY Language LANG 1 - T002 Language Key
4
EQKTX
- Descriptn CHAR 40 - - Description of technical object
5
KZLTX
- Long Text CHAR 1 - - Long Text Indicator
6
TXASP
- PriLang. CHAR 1 - - Primary language indicator for text segment
7
EQKTU
- Descriptn CHAR 40 - - Equipment description in capital letters

Related References & SQL

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

Interactive ERD Diagrams
SAP PM & SD - Plant Maintenance Main Tables Relation →
Standard T-Codes
SE11 SE16
Related Tables
T002 EQUI EQUZ EQST IFLOT IFLOTX ILOA IHPA
ANSI SQL Query 
SELECT a.EQUNR,
       a.SPRAS,
       a.EQKTX,
       a.KZLTX,
       a.TXASP,
       a.EQKTU
FROM EQKT AS a
WHERE a.EQUNR = '0001'
  AND a.SPRAS = 'E';
ABAP OpenSQL (7.40+) 
SELECT a~equnr,
       a~spras,
       a~eqktx,
       a~kzltx,
       a~txasp,
       a~eqktu
  FROM eqkt AS a
  WHERE a~equnr = '0001'
  and a~spras = 'e'
  INTO TABLE @DATA(lt_eqkt)
  UP TO 100 ROWS.