SAP table ENOTE (Allocation of Object to Note for Field Service)

SAP table ENOTE has 5 primary key fields being MANDT,SPRAS,OBJKEY,OBJTYPE,LFDNR.

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
SPRAS Character Field of Length 1 CHAR 1 0 CHAR01
OBJKEY 30 Characters CHAR 30 0 CHAR30
OBJTYPE Object Types Exist for Note NUMC 1 0 EENF_OBJTYPE
1 Installation
2 Connection Object
3 Device location
4 Device
LFDNR Sequential Number CHAR 2 0 LFDNR2
NOTE Static note to field service CHAR 2 0 TE582 E_NOTE
ADDTXT1 Additional text for notes CHAR 50 0 NOTE_ADDTXT
ADDTXT2 Additional text for notes CHAR 50 0 NOTE_ADDTXT
ADDTXT3 Additional text for notes CHAR 50 0 NOTE_ADDTXT
ADDTXT4 Additional text for notes CHAR 50 0 NOTE_ADDTXT
ADDTXT5 Additional text for notes CHAR 50 0 NOTE_ADDTXT
PRIO Priority of note to field service NUMC 1 0 NOTE_PRIO
ADDR No longer used: Addressee of note to field service CHAR 4 0 NOTE_ADDR
FORMGROUP Form group of note to field service CHAR 8 0 TE584 FORMGROUP
PARTNER Business partner number in field service note CHAR 10 0 BUT000 NOTE_PARTNER

ENOTE foreign key relationships

Table Field Check Table Check Field
0 ENOTE FORMGROUP TE584 Form Group of Note to Field Service MANDT
1 ENOTE MANDT T000 Clients MANDT
0 ENOTE NOTE TE582 Static Notes to Field Service MANDT
0 ENOTE NOTE TE582 Static Notes to Field Service NOTE
1 ENOTE PARTNER BUT000 BP: General data I PARTNER