SAP table CRHD (Work Center Header)

SAP table CRHD 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
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
BEGDA Start Date DATS 8 0 BEGDATUM
ENDDA End Date DATS 8 0 ENDDATUM
AEDAT_GRND Changed on DATS 8 0 AEDTM
AENAM_GRND User Name CHAR 12 0 USRNAME
AEDAT_VORA Changed on DATS 8 0 AEDTM
AENAM_VORA User Name CHAR 12 0 USRNAME
AEDAT_TERM Changed on DATS 8 0 AEDTM
AENAM_TERM User Name CHAR 12 0 USRNAME
AEDAT_TECH Changed on DATS 8 0 AEDTM
AENAM_TECH User Name CHAR 12 0 USRNAME
ARBPL Work Center CHAR 8 0 ARBPL
WERKS Plant CHAR 4 0 T001W WERKS_D
VERWE Work Center Category CHAR 4 0 TC30 AP_VERWE
LVORM Deletion flag for work center CHAR 1 0 AP_LOEVORM
PAR01 First work center parameter (for formulas) CHAR 6 0 TC20 AP_PAR01
PAR02 Second work center parameter (for formulas) CHAR 6 0 TC20 AP_PAR02
PAR03 Third work center parameter (for formulas) CHAR 6 0 TC20 AP_PAR03
PAR04 Fourth work center parameter (for formulas) CHAR 6 0 TC20 AP_PAR04
PAR05 Fifth work center parameter (for formulas) CHAR 6 0 TC20 AP_PAR05
PAR06 Sixth work center parameter (for formulas) CHAR 6 0 TC20 AP_PAR06
PARU1 Parameter unit UNIT 3 0 T006 AP_PARUNIT
PARU2 Parameter unit UNIT 3 0 T006 AP_PARUNIT
PARU3 Parameter unit UNIT 3 0 T006 AP_PARUNIT
PARU4 Parameter unit UNIT 3 0 T006 AP_PARUNIT
PARU5 Parameter unit UNIT 3 0 T006 AP_PARUNIT
PARU6 Parameter unit UNIT 3 0 T006 AP_PARUNIT
PARV1 Parameter value QUAN 9 3 AP_PARVAL
PARV2 Parameter value QUAN 9 3 AP_PARVAL
PARV3 Parameter value QUAN 9 3 AP_PARVAL
PARV4 Parameter value QUAN 9 3 AP_PARVAL
PARV5 Parameter value QUAN 9 3 AP_PARVAL
PARV6 Parameter value QUAN 9 3 AP_PARVAL
PLANV Key for task list usage CHAR 3 0 TC23 AP_PLANV
STAND Work center location CHAR 10 0 T499S AP_STAND
VERAN Person Responsible for the Work Center CHAR 3 0 TC24 AP_VERAN
VGWTS Standard Value Key CHAR 4 0 TC21 VORGSCHL
VGM01 Rule for standard value maintenance CHAR 1 0 AP_VGW_MES
VGM02 Rule for standard value maintenance CHAR 1 0 AP_VGW_MES
VGM03 Rule for standard value maintenance CHAR 1 0 AP_VGW_MES
VGM04 Rule for standard value maintenance CHAR 1 0 AP_VGW_MES
VGM05 Rule for standard value maintenance CHAR 1 0 AP_VGW_MES
VGM06 Rule for standard value maintenance CHAR 1 0 AP_VGW_MES
XDEFA Indicator: Work center for default values CHAR 1 0 AP_DEFAULT
XKOST Indicator: Work center is maintained for costing CHAR 1 0 AP_XKOST
XSPRR Indicator: Work center is locked CHAR 1 0 AP_XSPRR
XTERM Indicator: Work center is maintained for scheduling CHAR 1 0 AP_XTERM
ZGR01 Key for performance efficiency rate CHAR 3 0 TC31 IDZEITGRAD
ZGR02 Key for performance efficiency rate CHAR 3 0 TC31 IDZEITGRAD
ZGR03 Key for performance efficiency rate CHAR 3 0 TC31 IDZEITGRAD
ZGR04 Key for performance efficiency rate CHAR 3 0 TC31 IDZEITGRAD
ZGR05 Key for performance efficiency rate CHAR 3 0 TC31 IDZEITGRAD
ZGR06 Key for performance efficiency rate CHAR 3 0 TC31 IDZEITGRAD
KTSCH Standard Text Key CHAR 7 0 T435 KTSCH
LOANZ Number of Time Tickets DEC 3 0 LOHNANZ
LOART Wage type CHAR 4 0 LOHNART
LOGRP Wage Group CHAR 3 0 T421 LOHNGRP
QUALF Suitability CHAR 2 0 T423 QUALF
RASCH Setup Type Key CHAR 2 0 T428 RUEARSCHLU
STEUS Control key CHAR 4 0 T430 STEUS
VGE01 Unit of Measurement of Standard Value UNIT 3 0 T006 VGWRTEH
VGE02 Unit of Measurement of Standard Value UNIT 3 0 T006 VGWRTEH
VGE03 Unit of Measurement of Standard Value UNIT 3 0 T006 VGWRTEH
VGE04 Unit of Measurement of Standard Value UNIT 3 0 T006 VGWRTEH
VGE05 Unit of Measurement of Standard Value UNIT 3 0 T006 VGWRTEH
VGE06 Unit of Measurement of Standard Value UNIT 3 0 T006 VGWRTEH
KTSCH_REF Indicator: Standard Text ID is Referenced CHAR 1 0 KTSCH_REF
LOART_REF Indicator: Wage Type is Referenced CHAR 1 0 LOART_REF
LOANZ_REF Indicator: Number of Time Tickets is Referenced CHAR 1 0 LOANZ_REF
LOGRP_REF Indicator: Wage Group is Referenced CHAR 1 0 LOGRP_REF
QUALF_REF Indicator: Suitability is Referenced CHAR 1 0 QUALF_REF
RASCH_REF Indicator: Setup Type Key is Referenced CHAR 1 0 RASCH_REF
STEUS_REF Indicator: Control Profile is Referenced CHAR 1 0 STEUS_REF
FORT1 Formula for setup time CHAR 6 0 TC25 AP_FORM_T1
FORT2 Formula for the duration of processing time CHAR 6 0 TC25 AP_FORM_T2
FORT3 Formula for teardown time CHAR 6 0 TC25 AP_FORM_T3
KAPID Capacity ID NUMC 8 0 KAKO KAPID
ORTGR Location Group CHAR 4 0 ORTSGRUPPE
ZEIWN Unit for the Standard Queue Time UNIT 3 0 T006 DZEIWN
ZWNOR Standard Queue Time QUAN 9 3 DZWNOR
ZEIWM Unit for the Minimum Queue Time UNIT 3 0 T006 DZEIWM
ZWMIN Minimum Queue Time QUAN 9 3 DZWMIN
FORMR Indicator: same formulas as in capacity CHAR 1 0 FLGFORMART
MATYP Machine Type CHAR 10 0 TMATY MATYP
CPLGR CAPP planner group CHAR 3 0 T024C CPLGR
SORTB Sort string CHAR 9 0 TSRTB SORTB
MTRVP Additional time percentage for setup DEC 3 1 MTRVP
0 Additional time percentage
MTMVP Additional time percentage for machines DEC 3 1 MTMVP
0 Additional time percentage
MTPVP Aditional time percentage for labor DEC 3 1 MTPVP
0 Additional time percentage
RSANZ Number of Confirmation Slips NUMC 3 0 CR_RS_ANZ
PDEST Printer for shop papers CHAR 4 0 TSP03 CR_PDEST
HROID Object ID NUMC 8 0 PLOGI HROBJID
FORTN Formula for the duration of other types of int. processing CHAR 6 0 TC25 AP_FORM_TN
ZGR01_REF Field is referenced CHAR 1 0 AP_KZREF
ZGR02_REF Field is referenced CHAR 1 0 AP_KZREF
ZGR03_REF Field is referenced CHAR 1 0 AP_KZREF
ZGR04_REF Field is referenced CHAR 1 0 AP_KZREF
ZGR05_REF Field is referenced CHAR 1 0 AP_KZREF
ZGR06_REF Field is referenced CHAR 1 0 AP_KZREF
STEUS_C Control key CHAR 4 0 T430 STEUS
STEUS_I Control key CHAR 4 0 T430 STEUS
STEUS_N Control key CHAR 4 0 T430 STEUS
STEUS_Q Control key CHAR 4 0 T430 STEUS
RUZUS Key: rounding and additional values CHAR 4 0 TCERS RUZUS
RSANZ_REF Indicator: Number of Confirmation Slips is Referenced CHAR 1 0 RSANZ_REF
HR Work center only resides in HR CHAR 1 0 AP_KZHR
PRVBE Production Supply Area CHAR 10 0 PVBE PRVBE
SUBSYS Subsystem Identifier for QM Subsystem Interface CHAR 6 0 QISUB QEIFSUBSYS
BDEGR Grouping for Binding to Subsystem CHAR 3 0 BDEGR
RGEKZ Indicator: Backflushing CHAR 1 0 RGEKZAP
HRTYP Object Type CHAR 2 0 T778O OTYPE
SLWID Key word ID for user-defined fields CHAR 7 0 TCN00 SLWID
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
SLWID_REF Field is referenced CHAR 1 0 AP_KZREF
LIFNR_REF Field is referenced CHAR 1 0 AP_KZREF
VGARB Unit of Measure of Work UNIT 3 0 T006 VGWRTAR
VGDIM Dimension of work CHAR 6 0 T006D VGDIMAR
HRPLVAR Plan Version CHAR 2 0 T778P PLVAR
VGDAU Normal duration/unit UNIT 3 0 DAUNORE
STOBJ Object number CHAR 22 0 J_OBJNR
RESGR Matrix identification CHAR 8 0 TCYMI MATRIX_ID
LGORT_RES Storage Location Storage Resource CHAR 4 0 T001L LGORT_RES
MIXMAT Indicator: mixing of material allowed CHAR 1 0 MIXMAT
ISTBED_KZ Calculation of actual capacity requirements CHAR 1 0 CY_ISTBEDKZ
No actual cap. reqs.
1 Act. Cap. Reqts from Work Center Formulas
2 Actual Cap. Requirements from Activities
LASTCHANGE_DATETIME Date and Time of Last Change DEC 21 7 CR_LASTCHANGE_DATETIME
EBELN_EXT Purchasing Document Number CHAR 10 0 * EBELN
EBELP_EXT Item Number of Purchasing Document NUMC 5 0 * EBELP
LIFNR_EXT Account Number of Supplier CHAR 10 0 * LIFNR
EKGRP_EXT Purchasing Group CHAR 3 0 * EKGRP
EKORG_EXT Purchasing organization CHAR 4 0 * EKORG
MGHNO_EXT Class number CHAR 18 0 KLASSE_D
MATKL_EXT Material Group CHAR 9 0 * MATKL
PPSKZ Indicator for Advanced Planning CHAR 1 0 PPSKZ
SRTYPE Shift Report Type CHAR 10 0 COCF_CU_SRTYPE COCF_SR_SRTYPE
SNTYPE Shift Note Type CHAR 2 0 TQ80 COCF_SN_SNTYPE
S_LABOR_TRACK Indicates Whether Labor Tracking is Required for Execution CHAR 1 0 MPE_LABOR_TRACK

CRHD foreign key relationships

Table Field Check Table Check Field
0 CRHD CPLGR T024C Planner Group for CAPP CPLGR
1 CRHD FORT1 TC25 Work center formulas MANDT
0 CRHD FORT2 TC25 Work center formulas MANDT
1 CRHD FORT3 TC25 Work center formulas MANDT
0 CRHD FORTN TC25 Work center formulas MANDT
1 CRHD HROID PLOGI Table Index HRP* MANDT
1 CRHD HROID PLOGI Table Index HRP* PLVAR
1 CRHD HROID PLOGI Table Index HRP* OTYPE
1 CRHD HROID PLOGI Table Index HRP* OBJID
0 CRHD HRPLVAR T778P Plan Versions MANDT
1 CRHD HRTYP T778O Object Types MANDT
1 CRHD HRTYP T778O Object Types OTYPE
0 CRHD KAPID KAKO Capacity Header Segment MANDT
1 CRHD KTSCH T435 Standard texts for routing/ref. op set items MANDT
0 CRHD LGORT_RES T001L Storage Locations MANDT
0 CRHD LGORT_RES T001L Storage Locations WERKS
1 CRHD LIFNR LFA1 Supplier Master (General Section) MANDT
1 CRHD LIFNR LFA1 Supplier Master (General Section) LIFNR
0 CRHD LOGRP T421 Wage groups MANDT
1 CRHD MANDT T000 Clients MANDT
0 CRHD MATYP TMATY Machine types MANDT
0 CRHD MATYP TMATY Machine types MATYP
1 CRHD OBJID CRID CIM Resource - Entities MANDT
1 CRHD OBJID CRID CIM Resource - Entities OBJID
0 CRHD PAR01 TC20 "Formula Parameters" MANDT
0 CRHD PAR01 TC20 "Formula Parameters" PARID
1 CRHD PAR02 TC20 "Formula Parameters" MANDT
1 CRHD PAR02 TC20 "Formula Parameters" PARID
0 CRHD PAR03 TC20 "Formula Parameters" MANDT
0 CRHD PAR03 TC20 "Formula Parameters" PARID
1 CRHD PAR04 TC20 "Formula Parameters" MANDT
1 CRHD PAR04 TC20 "Formula Parameters" PARID
0 CRHD PAR05 TC20 "Formula Parameters" MANDT
0 CRHD PAR05 TC20 "Formula Parameters" PARID
1 CRHD PAR06 TC20 "Formula Parameters" MANDT
1 CRHD PAR06 TC20 "Formula Parameters" PARID
0 CRHD PARU1 T006 Units of Measurement MANDT
0 CRHD PARU1 T006 Units of Measurement MSEHI
1 CRHD PARU2 T006 Units of Measurement MANDT
1 CRHD PARU2 T006 Units of Measurement MSEHI
0 CRHD PARU3 T006 Units of Measurement MANDT
0 CRHD PARU3 T006 Units of Measurement MSEHI
1 CRHD PARU4 T006 Units of Measurement MANDT
1 CRHD PARU4 T006 Units of Measurement MSEHI
0 CRHD PARU5 T006 Units of Measurement MANDT
0 CRHD PARU5 T006 Units of Measurement MSEHI
1 CRHD PARU6 T006 Units of Measurement MANDT
1 CRHD PARU6 T006 Units of Measurement MSEHI
0 CRHD PDEST TSP03 Spool: Printer declaration PADEST
1 CRHD PLANV TC23 Key for use of the work center in the task lists MANDT
0 CRHD PRVBE PVBE Production Supply Area MANDT
0 CRHD PRVBE PVBE Production Supply Area WERKS
0 CRHD PRVBE PVBE Production Supply Area PRVBE
1 CRHD QUALF T423 Wage group qualification MANDT
1 CRHD QUALF T423 Wage group qualification QUALF
0 CRHD RASCH T428 Setup Type Key MANDT
1 CRHD RESGR TCYMI Matrix identifications MANDT
1 CRHD RESGR TCYMI Matrix identifications WERKS
0 CRHD RUZUS TCERS Rounding & additional values keys MANDT
0 CRHD RUZUS TCERS Rounding & additional values keys RUZUS
1 CRHD SLWID TCN00 Key Word ID for PS User Fields MANDT
0 CRHD SNTYPE TQ80 Notification Types MANDT
0 CRHD SNTYPE TQ80 Notification Types QMART
1 CRHD SRTYPE COCF_CU_SRTYPE Shift Report Type - Definition SRTYPE
0 CRHD STAND T499S Location MANDT
0 CRHD STAND T499S Location WERKS
1 CRHD STEUS T430 Operation/Activity control key MANDT
1 CRHD STEUS T430 Operation/Activity control key PLNAW
1 CRHD STEUS T430 Operation/Activity control key STEUS
0 CRHD STEUS_C T430 Operation/Activity control key MANDT
0 CRHD STEUS_C T430 Operation/Activity control key PLNAW
0 CRHD STEUS_C T430 Operation/Activity control key STEUS
1 CRHD STEUS_I T430 Operation/Activity control key MANDT
1 CRHD STEUS_I T430 Operation/Activity control key PLNAW
1 CRHD STEUS_I T430 Operation/Activity control key STEUS
0 CRHD STEUS_N T430 Operation/Activity control key MANDT
0 CRHD STEUS_N T430 Operation/Activity control key PLNAW
0 CRHD STEUS_N T430 Operation/Activity control key STEUS
1 CRHD STEUS_Q T430 Operation/Activity control key MANDT
1 CRHD STEUS_Q T430 Operation/Activity control key PLNAW
1 CRHD STEUS_Q T430 Operation/Activity control key STEUS
0 CRHD SUBSYS QISUB Subsytems for recording measured value data in QM MANDANT
1 CRHD VERAN TC24 Person responsible for the work center MANDT
1 CRHD VERAN TC24 Person responsible for the work center WERKS
0 CRHD VERWE TC30 Work center category MANDT
1 CRHD VGARB T006 Units of Measurement MANDT
1 CRHD VGARB T006 Units of Measurement MSEHI
0 CRHD VGDIM T006D Dimensions DIMID
1 CRHD VGE01 T006 Units of Measurement MANDT
0 CRHD VGE02 T006 Units of Measurement MANDT
1 CRHD VGE03 T006 Units of Measurement MANDT
0 CRHD VGE04 T006 Units of Measurement MANDT
1 CRHD VGE05 T006 Units of Measurement MANDT
0 CRHD VGE06 T006 Units of Measurement MANDT
1 CRHD VGWTS TC21 Standard value key MANDT
1 CRHD VGWTS TC21 Standard value key VGWTS
0 CRHD WERKS T001W Plants/Branches MANDT
0 CRHD WERKS T001W Plants/Branches WERKS
1 CRHD ZEIWM T006 Units of Measurement MANDT
1 CRHD ZEIWM T006 Units of Measurement MSEHI
0 CRHD ZEIWN T006 Units of Measurement MANDT
1 CRHD ZGR01 TC31 Performance Efficiency Rate Key MANDT
1 CRHD ZGR01 TC31 Performance Efficiency Rate Key ID
0 CRHD ZGR02 TC31 Performance Efficiency Rate Key MANDT
0 CRHD ZGR02 TC31 Performance Efficiency Rate Key ID
1 CRHD ZGR03 TC31 Performance Efficiency Rate Key MANDT
1 CRHD ZGR03 TC31 Performance Efficiency Rate Key ID
0 CRHD ZGR04 TC31 Performance Efficiency Rate Key MANDT
0 CRHD ZGR04 TC31 Performance Efficiency Rate Key ID
1 CRHD ZGR05 TC31 Performance Efficiency Rate Key MANDT
1 CRHD ZGR05 TC31 Performance Efficiency Rate Key ID
0 CRHD ZGR06 TC31 Performance Efficiency Rate Key MANDT
0 CRHD ZGR06 TC31 Performance Efficiency Rate Key ID