SE11 ABAP Dictionary SE11 YSIC_LOG02

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

YSIC_LOG02

Log SIC

SAP SAP Transparent Table 15 Fields

Primary Key:

MANDT UNAME UNAME2 DATUM UZEIT

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	UNAME	KEY	User	CHAR	12	-	-	User Name
3	UNAME2	KEY	User	CHAR	12	-	-	User Name
4	DATUM	KEY	Date	DATS	8	-	-	Date
5	UZEIT	KEY	Time	TIMS	6	-	-	Time
6	LOCKSTATUS	-	Lock	INT1	3	-	-	User Lock Status
7	TYPE	-	Msg type	CHAR	1	-	-	Message type: S Success, E Error, W Warning, I Info, A Abort
8	ID	-	Message ID	CHAR	20	-	-	Message Class
9	MESSAGE	-	Message	CHAR	220	-	-	Message Text
10	LOG_NO	-	Log no.	CHAR	20	-	-	Application log: log number
11	LOG_MSG_NO	-	Msg. no.	NUMC	6	-	-	Application log: Internal message serial number
12	MESSAGE_V1	-	Msg. Var.	CHAR	50	-	-	Message Variable
13	MESSAGE_V2	-	Msg. Var.	CHAR	50	-	-	Message Variable
14	MESSAGE_V3	-	Msg. Var.	CHAR	50	-	-	Message Variable
15	MESSAGE_V4	-	Msg. Var.	CHAR	50	-	-	Message Variable

Related References & SQL

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

Interactive ERD Diagrams

Belum terpasang pada pin diagram ERD.

Standard T-Codes

SE11 SE16

Related Tables

Tidak ada relasi langsung terdeteksi.

ANSI SQL Query

SELECT a.UNAME,
       a.UNAME2,
       a.DATUM,
       a.UZEIT,
       a.LOCKSTATUS,
       a.TYPE,
       a.ID
FROM YSIC_LOG02 AS a
WHERE a.UNAME = '0001'
  AND a.UNAME2 = '0001';

ABAP OpenSQL (7.40+)

SELECT a~uname,
       a~uname2,
       a~datum,
       a~uzeit,
       a~lockstatus,
       a~type,
       a~id
  FROM ysic_log02 AS a
  WHERE a~uname = '0001'
  and a~uname2 = '0001'
  INTO TABLE @DATA(lt_ysic_log02)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 YSIC_LOG02

YSIC_LOG02

Dictionary Fields Fields

Related References & SQL