SAP table T365 (Initial values for PM notification transactions)
SAP table T365 has 2 primary key fields being MANDT,TCODE.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
T000
MANDT
TCODE
Transaction Code
CHAR
20
0
TSTC
TCODE
AGIDV
ABAP Program Name
CHAR
40
0
TRDIR
PROGNAME
AKTYP
Activity Category in Transaction (Add/Change/Display)
CHAR
1
0
AKTTYP
Possible values
BLDGR
Screen group
CHAR
2
0
BLDGR
PANEL
Name of the current screen display
CHAR
4
0
PANEL
QMART
Default Notification Type
CHAR
2
0
TQ80
QARTV
EBPRZ
Process Initial Screen
CHAR
1
0
EBPRZ
EFSET
Set Initial Function Code
CHAR
4
0
EFSET
Possible values
AFDT
Malfunction, breakdown
ANLV
System availability
EMEL
Notification header, simple
ILOA
Location data
MALT
Task overview
MELD
Notification Header
MFLT
Activity overview
PSLT
Item overview
TERM
Scheduling overview
WFMS
Task detail
KOPGR
Screen sequence group in doc. header
CHAR
4
0
KOPGR
QMTYP
Notification Category
CHAR
2
0
TQ8T
QMTYP
T365 foreign key relationships
Table
Field
Check Table
Check Field
0 T365
AGIDV
TRDIR
Generated Table for View
NAME
1 T365
MANDT
T000
Clients
MANDT
0 T365
QMART
TQ80
Notification Types
MANDT
0 T365
QMART
TQ80
Notification Types
QMART
1 T365
QMTYP
TQ8T
Notification category
MANDT
1 T365
QMTYP
TQ8T
Notification category
QMTYP
0 T365
TCODE
TSTC
SAP Transaction Codes
TCODE