SAP ABAP Table /ISDFPS/PRUPS_CRFH (DFPS: PRT Header - UPS Distribution (CRFHD))

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-PDR (Application Component) Master Data Distribution
     ⤷ /ISDFPS/UPS_EXTENSIONS_ASSET (Package) Asset Objects in UPS

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/PRUPS_CRFH	Table Relationship Diagram
Short Description	DFPS: PRT Header - UPS Distribution (CRFHD)

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

History

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