SAP table CRTX (Text for the Work Center or Production Resource/Tool)

SAP table CRTX has 4 primary key fields being MANDT,OBJTY,OBJID,SPRAS.

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
OBJTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
OBJID Object ID of the resource NUMC 8 0 CRID CR_OBJID
SPRAS Language Key LANG 1 0 T002 SPRAS
AEDAT_TEXT Changed on DATS 8 0 AEDTM
AENAM_TEXT User Name CHAR 12 0 USRNAME
KTEXT Short description CHAR 40 0 CR_KTEXT
KTEXT_UP Short description in capitals CHAR 40 0 CR_KTEXTUP

CRTX foreign key relationships

Table Field Check Table Check Field
0 CRTX MANDT T000 Clients MANDT
1 CRTX OBJID CRID CIM Resource - Entities MANDT
1 CRTX OBJID CRID CIM Resource - Entities OBJID
0 CRTX SPRAS T002 Language Keys (Component BC-I18) SPRAS