SAP ABAP Table CRFH (CIM production resource/tool master data)

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	TRANSP	Transparent table
Transparent table	CRFH	Table Relationship Diagram
Short Description	CIM production resource/tool master data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRFH	AENNR	AENR	AENNR	REF	C	CN
2	CRFH	BASEH	T006	MSEHI	REF	C	CN
3	CRFH	BRGRU	TBRG	BRGRU
4	CRFH	BZOFFB	TCA54	BZOFF	REF	C	CN
5	CRFH	BZOFFE	TCA54	BZOFF	REF	C	CN
6	CRFH	EHOFFB	T006	MSEHI	REF	C	CN
7	CRFH	EHOFFE	T006	MSEHI	REF	C	CN
8	CRFH	EWFORM	TC25	IDENT	REF	C	CN
9	CRFH	FGRU1	TCF12	FGRUA	REF	C	CN
10	CRFH	FGRU2	TCF12	FGRUA	REF	C	CN
11	CRFH	FHMAR	TCF02	FHMAR	REF	1	CN
12	CRFH	KTSCH	T435	VLSCH	REF	C	CN
13	CRFH	MANDT	T000	MANDT	KEY	1	CN
14	CRFH	MGFORM	TC25	IDENT	REF	C	CN
15	CRFH	OBJID	CRID	OBJID	KEY	1	C
16	CRFH	OBJID_V	CRID	OBJID	REF	1	CN
17	CRFH	PAR01	TC20	PARID	REF	C	CN
18	CRFH	PAR02	TC20	PARID	REF	C	CN
19	CRFH	PAR03	TC20	PARID	REF	C	CN
20	CRFH	PAR04	TC20	PARID	REF	C	CN
21	CRFH	PAR05	TC20	PARID	REF	C	CN
22	CRFH	PAR06	TC20	PARID	REF	C	CN
23	CRFH	PARU1	T006	MSEHI	REF	C	CN
24	CRFH	PARU2	T006	MSEHI	REF	C	CN
25	CRFH	PARU3	T006	MSEHI	REF	C	CN
26	CRFH	PARU4	T006	MSEHI	REF	C	CN
27	CRFH	PARU5	T006	MSEHI	REF	C	CN
28	CRFH	PARU6	T006	MSEHI	REF	C	CN
29	CRFH	PLANV	TC23	PLANV	REF	1	CN
30	CRFH	STATUS	TCF04	STATUS	REF	1	CN
31	CRFH	STEUF	TCF10	STEUF	REF	C	CN
32	CRFH	STORT	T499S	STAND	REF	C	CN
33	CRFH	STOWK	T001W	WERKS	REF	C	CN

History

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