SE11 ABAP Dictionary SE11 EQST

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

EQST

Equipment to BOM Link
SAP SAP Transparent Table 10 Fields
Primary Key:
MANDT EQUNR WERKS STLAN STLNR STLAL

Dictionary Fields Fields

(10 dari 10 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
WERKS
KEY Plant CHAR 4 - T001W Plant
4
STLAN
KEY BOM Usage CHAR 1 - - BOM Usage
5
STLNR
KEY BOM CHAR 8 - - Bill of material
6
STLAL
KEY Alt. BOM CHAR 2 - - Alternative BOM
7
ANDAT
- Created on DATS 8 - - Date record created on
8
ANNAM
- By CHAR 12 - - User who created record
9
AEDAT
- Chngd DATS 8 - - Changed On
10
AENAM
- By CHAR 12 - - Name of Person Who Changed Object

Related References & SQL

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

Interactive ERD Diagrams
SAP PM & SD - Plant Maintenance Main Tables Relation →
Standard T-Codes
SE11 SE16
Related Tables
T001W EQUI EQKT EQUZ IFLOT IFLOTX ILOA IHPA
ANSI SQL Query 
SELECT a.EQUNR,
       a.WERKS,
       a.STLAN,
       a.STLNR,
       a.STLAL,
       a.ANDAT,
       a.ANNAM
FROM EQST AS a
WHERE a.EQUNR = '0001'
  AND a.WERKS = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~equnr,
       a~werks,
       a~stlan,
       a~stlnr,
       a~stlal,
       a~andat,
       a~annam
  FROM eqst AS a
  WHERE a~equnr = '0001'
  and a~werks = '0001'
  INTO TABLE @DATA(lt_eqst)
  UP TO 100 ROWS.