SAP table CRHH (Hierarchy Header Data)
SAP table CRHH has 3 primary key fields being MANDT,OBJTY,OBJID.
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
Client
CLNT
3
0
T000
MANDT
Object types of the CIM resource
CHAR
2
0
CR_OBJTY
Possible values
A
Work Center
AA
Work center alias
FH
Production resources/tools
G
Group
H
Hierarchy
Object ID of the resource
NUMC
8
0
CRID
CR_OBJID
NAME
Name of Hierarchy
CHAR
10
0
CR_HNAME
WERKS
Plant
CHAR
4
0
T001W
WERKS_D
GRPTYPE
Work Center Group Type
CHAR
10
0
CR_WRKCTRGRPTYP
VERAN
Person Responsible for the Work Center
CHAR
3
0
TC24
AP_VERAN
SROOT
Hierarchy with one root
CHAR
1
0
CR_SROOT
SWERK
Hierarchy objects in different plants
CHAR
1
0
CR_SWERK
NETWK
Indicator: Resource structure
CHAR
1
0
CR_NETWK
LOEKZ
Checkbox
CHAR
1
0
XFELD
Possible values
SRTYPE
Shift Report Type
CHAR
10
0
COCF_CU_SRTYPE
COCF_SR_SRTYPE
SNTYPE
Shift Note Type
CHAR
2
0
TQ80
COCF_SN_SNTYPE
ANDAT
Date Record Created On
DATS
8
0
ANDAT
ANNAM
User who created record
CHAR
12
0
ANNAM
AEDAT
Last Changed On
DATS
8
0
AEDAT
AENAM
Name of Person Who Changed Object
CHAR
12
0
AENAM
CHANGEDDATETIME
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
DEC
15
0
TZNTSTMPS
CRHH foreign key relationships
Table
Field
Check Table
Check Field
0 CRHH
MANDT
T000 Clients
MANDT
1 CRHH
OBJID
CRID CIM Resource - Entities
MANDT
1 CRHH
OBJID
CRID CIM Resource - Entities
OBJID
0 CRHH
SNTYPE
TQ80 Notification Types
MANDT
0 CRHH
SNTYPE
TQ80 Notification Types
QMART
1 CRHH
SRTYPE
COCF_CU_SRTYPE Shift Report Type - Definition
SRTYPE
0 CRHH
VERAN
TC24 Person responsible for the work center
MANDT
0 CRHH
VERAN
TC24 Person responsible for the work center
WERKS
1 CRHH
WERKS
T001W Plants/Branches
MANDT
1 CRHH
WERKS
T001W Plants/Branches
WERKS