SAP ABAP Table CRFHD (Structure of the production resources/tools master)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CF (Package) R/3 Appl. development: PPS production resources/tools

Basic Data

Table Category	INTTAB	Structure
Structure	CRFHD	Table Relationship Diagram
Short Description	Structure of the production resources/tools master

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
3	OBJID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
4	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
5	FHMAR	☐	FHMAR	FHMAR	CHAR	1	0	Production resources/tools category	TCF02
6	OBJTY_V	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
7	OBJID_V	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
8	LOEKZ	☐	CF_LOEKZ	XFLAG	CHAR	1	0	Deletion indicator for production resources/tools master
9	DATUV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
10	DATUB	☐	DATUB	DATUM	DATS	8	0	Valid-to date
11	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
12	ANNAM	☐	ANNAM	USNAM	CHAR	12	0	User Who Created Record
13	ANDAT	☐	ANDAT	DATUM	DATS	8	0	Date Record Created on
14	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
16	BRGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	TBRG
17	STATUS	☐	CF_CRFHST	CF_CRFHST	CHAR	2	0	Production resources/tools master: Status	TCF04
18	KZKBL	☐	KZKBL	XFELD	CHAR	1	0	Indicator: Create load records for prod. resources/tools
19	STOWK	☐	CF_STOWK	WERKS	CHAR	4	0	Plant location of the production resource/tool	T001W
20	STORT	☐	CF_STORT	AP_STAND	CHAR	10	0	Location of a production resource or tool	T499S
21	BASEH	☐	CF_BASEH	MEINS	UNIT	3	0	Base unit of measure for production resources/tools	T006
22	STEUF	☐	STEUF	STEUF	CHAR	4	0	Control key for management of production resources/tools	TCF10
23	STEUF_REF	☐	CF_STKZR	XFELD	CHAR	1	0	Control key cannot be changed
24	FGRU1	☐	FGRUA	FGRUA	CHAR	4	0	Grouping key 1 for production resources/tools	TCF12
25	FGRU2	☐	FGRUB	FGRUA	CHAR	4	0	Grouping key 2 for production resources/tools	TCF12
26	PLANV	☐	FH_PLANV	AP_PLANV	CHAR	3	0	Production resource/tool usage	TC23
27	KTSCH	☐	CF_KTSCH	KTSCH	CHAR	7	0	Standard text key for production resources/tools	T435
28	KTSCH_REF	☐	CF_KTKZR	XFELD	CHAR	1	0	Reference Key Cannot be Changed
29	BZOFFB	☐	BZOFFB	CP_BZOFF	CHAR	2	0	Reference date to start of production resource/tool usage	TCA54
30	BZOFFB_REF	☐	CF_BBKZR	XFELD	CHAR	1	0	Start reference date cannot be changed
31	OFFSTB	☐	OFFSTB	VNZTV	QUAN	5	0	Offset to start of production resource/tool usage
32	EHOFFB	☐	EHOFFB	MEINS	UNIT	3	0	Offset unit for start of prod. resource/tool usage	T006
33	OFFSTB_REF	☐	CF_OBKZR	XFELD	CHAR	1	0	Offset to start cannot be changed
34	BZOFFE	☐	BZOFFE	CP_BZOFF	CHAR	2	0	Reference date for end of production resource/tool usage	TCA54
35	BZOFFE_REF	☐	CF_BEKZR	XFELD	CHAR	1	0	End reference date cannot be changed
36	OFFSTE	☐	OFFSTE	VNZTV	QUAN	5	0	Offset to finish of production resource/tool usage
37	EHOFFE	☐	EHOFFE	MEINS	UNIT	3	0	Offset unit for end of production resource/tool usage	T006
38	OFFSTE_REF	☐	CF_OEKZR	XFELD	CHAR	1	0	Offset to end cannot be changed
39	MGFORM	☐	CF_MGFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total quantity of PRT	TC25
40	MGFORM_REF	☐	CF_MFKZR	XFELD	CHAR	1	0	Formula for calculating the total quantity cannot be changed
41	EWFORM	☐	CF_EWFORM	AP_FORMEL	CHAR	6	0	Formula for calculating the total usage value of PRT	TC25
42	EWFORM_REF	☐	CF_EFKZR	XFELD	CHAR	1	0	Formula to calculate entire usage value cannot be changed
43	PAR01	☐	CF_PAR01	PARAMID	CHAR	6	0	First parameter (for formulas)	TC20
44	PAR02	☐	CF_PAR02	PARAMID	CHAR	6	0	Second parameter (for formulas)	TC20
45	PAR03	☐	CF_PAR03	PARAMID	CHAR	6	0	Third parameter (for formulas)	TC20
46	PAR04	☐	CF_PAR04	PARAMID	CHAR	6	0	Fourth parameter (for formulas)	TC20
47	PAR05	☐	CF_PAR05	PARAMID	CHAR	6	0	Fifth parameter (for formulas)	TC20
48	PAR06	☐	CF_PAR06	PARAMID	CHAR	6	0	Sixth parameter (for formulas)	TC20
49	PARU1	☐	CF_PARUNIT	MEINS	UNIT	3	0	Parameter unit	T006
50	PARU2	☐	CF_PARUNIT	MEINS	UNIT	3	0	Parameter unit	T006
51	PARU3	☐	CF_PARUNIT	MEINS	UNIT	3	0	Parameter unit	T006
52	PARU4	☐	CF_PARUNIT	MEINS	UNIT	3	0	Parameter unit	T006
53	PARU5	☐	CF_PARUNIT	MEINS	UNIT	3	0	Parameter unit	T006
54	PARU6	☐	CF_PARUNIT	MEINS	UNIT	3	0	Parameter unit	T006
55	PARV1	☐	CF_PARVAL	VGWRT	QUAN	9	3	Parameter value
56	PARV2	☐	CF_PARVAL	VGWRT	QUAN	9	3	Parameter value
57	PARV3	☐	CF_PARVAL	VGWRT	QUAN	9	3	Parameter value
58	PARV4	☐	CF_PARVAL	VGWRT	QUAN	9	3	Parameter value
59	PARV5	☐	CF_PARVAL	VGWRT	QUAN	9	3	Parameter value
60	PARV6	☐	CF_PARVAL	VGWRT	QUAN	9	3	Parameter value
61	FHWRK	☐	FHWRK	WERKS	CHAR	4	0	Production resources/tools in plant	T001W
62	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
63	SFHNR	☐	SFHNR	SFHNR	CHAR	18	0	Production resources and tools
64	DOKAR	☐	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
65	DOKNR	☐	DOKNR	DOKNR	CHAR	25	0	Document number	DRAW
66	DOKVR	☐	DOKVR	DOKVR	CHAR	2	0	Document version
67	DOKTL	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
68	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
69	FHKTX	☐	FHKTX	TEXT40	CHAR	40	0	Description of the production resource/tool
70	MMSTA	☐	MMSTA	MMSTA	CHAR	2	0	Plant-Specific Material Status	T141
71	DOKST	☐	DOKST	DOKST	CHAR	2	0	Document Status	TDWS
72	DOKAS	☐	DAENR	AENNR	CHAR	12	0	Change Number	AENR
73	DOKGV	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
74	EQSTO	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
75	EQTYP	☐	EQTYP	EQTYP	CHAR	1	0	Equipment Category	T370T
76	EQWPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
77	EQWTX	☐	WPTXT	TEXT40	CHAR	40	0	Maintenance Plan Text
78	EQPNT	☐	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point	IMPTT
79	EQPTX	☐	IMRC_PTTXT	TEXT40	CHAR	40	0	Description of Measuring Point
80	ATNAM	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
81	ATVOR	☐	IMRC_INEGV	X	CHAR	1	0	Indicator: Negative Values Allowed
82	MSEHI	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	T006
83	ATDIM	☐	ATDIM	EXP10	INT2	5	0	Exponent display
84	ANZDZ	☐	ANZDZ	ANZDZ	INT2	5	0	Number of Decimal Places
85	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
86	MODKZ	☐	CF_MODKZ	CF_MODKZ	CHAR	1	0	Modification indicator (new, changed, to be deleted ...)
87	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	*
88	INACT	☐	IMRC_INACT	X	CHAR	1	0	Indicator: Measuring Point Inactive

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRFHD	AENNR	AENR	AENNR
2	CRFHD	BASEH	T006	MSEHI
3	CRFHD	BRGRU	TBRG	BRGRU
4	CRFHD	BZOFFB	TCA54	BZOFF
5	CRFHD	BZOFFE	TCA54	BZOFF
6	CRFHD	DOKAR	TDWA	DOKAR
7	CRFHD	DOKAS	AENR	AENNR
8	CRFHD	DOKNR	DRAW	DOKNR
9	CRFHD	DOKST	TDWS	DOKST
10	CRFHD	EHOFFB	T006	MSEHI
11	CRFHD	EHOFFE	T006	MSEHI
12	CRFHD	EQPNT	IMPTT	POINT
13	CRFHD	EQSTO	ONR00	OBJNR
14	CRFHD	EQTYP	T370T	EQTYP
15	CRFHD	EQUNR	EQUI	EQUNR
16	CRFHD	EQWPL	MPLA	WARPL
17	CRFHD	EWFORM	TC25	IDENT
18	CRFHD	FGRU1	TCF12	FGRUA
19	CRFHD	FGRU2	TCF12	FGRUA
20	CRFHD	FHMAR	TCF02	FHMAR
21	CRFHD	FHWRK	T001W	WERKS
22	CRFHD	KTSCH	T435	VLSCH
23	CRFHD	MANDT	T000	MANDT
24	CRFHD	MATNR	MARA	MATNR
25	CRFHD	MEINS	T006	MSEHI
26	CRFHD	MGFORM	TC25	IDENT
27	CRFHD	MMSTA	T141	MMSTA
28	CRFHD	MSEHI	T006	MSEHI
29	CRFHD	OBJID	CRID	OBJID
30	CRFHD	OBJID_V	CRID	OBJID
31	CRFHD	PAR01	TC20	PARID
32	CRFHD	PAR02	TC20	PARID
33	CRFHD	PAR03	TC20	PARID
34	CRFHD	PAR04	TC20	PARID
35	CRFHD	PAR05	TC20	PARID
36	CRFHD	PAR06	TC20	PARID
37	CRFHD	PARU1	T006	MSEHI
38	CRFHD	PARU2	T006	MSEHI
39	CRFHD	PARU3	T006	MSEHI
40	CRFHD	PARU4	T006	MSEHI
41	CRFHD	PARU5	T006	MSEHI
42	CRFHD	PARU6	T006	MSEHI
43	CRFHD	PLANV	TC23	PLANV
44	CRFHD	STATUS	TCF04	STATUS
45	CRFHD	STEUF	TCF10	STEUF
46	CRFHD	STORT	T499S	STAND
47	CRFHD	STOWK	T001W	WERKS

History

Last changed by/on	SAP	20100310
SAP Release Created in	470