SAP ABAP View GHO_V_MRH_RULES (View for retrieving MRH rules)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-PN-ALN (Application Component) Production Allocation
     ⤷ APPL_GHO_ALLOC_BE (Package) Backend Logic for Allocation

Basic Data

View Type	D	Database View
Database View	GHO_V_MRH_RULES
Short Description	View for retrieving MRH rules
Root table	GHO_MRH_RULE_H	Measurement Retrieval Hierarchy Rules Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	GHO_MRH_RULE_H	GHO_MRH_RULE_H
2	GHO_MRH_RULE_I
3	GHO_ALLOCRES_H
4	GHO_IMRG_STD_H
5	GHO_IMPTT_EXT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	GHO_MRH_RULE_H	MRH_RULE_ID	JL	EQ				0	0
2	GHO_MRH_RULE_I	MRH_RULE_ID	JR	EQ			AND	0	0
3	GHO_ALLOCRES_H	NETID	JL	EQ				0	0
4	GHO_MRH_RULE_H	NET_ID	JR	EQ			AND	0	0
5	GHO_IMRG_STD_H	NETID	JL	EQ				0	0
6	GHO_MRH_RULE_H	NET_ID	JR	EQ			AND	0	0
7	GHO_IMRG_STD_H	NETOBJ	JL	EQ				0	0
8	GHO_MRH_RULE_H	NODE_ID	JR	EQ			AND	0	0
9	GHO_ALLOCRES_H	CLIENT	JL	EQ				0	0
10	GHO_MRH_RULE_H	CLIENT	JR	EQ			AND	0	0
11	GHO_MRH_RULE_H	CLIENT	JL	EQ				0	0
12	GHO_MRH_RULE_I	CLIENT	JR	EQ			AND	0	0
13	GHO_IMRG_STD_H	MANDT	JL	EQ				0	0
14	GHO_MRH_RULE_H	CLIENT	JR	EQ			AND	0	0
15	GHO_ALLOCRES_H	ALLOC_TYPE	JL	EQ				0	0
16	GHO_IMRG_STD_H	ALLOC_TYPE	JR	EQ			AND	0	0
17	GHO_ALLOCRES_H	FREQUENCY	JL	EQ				0	0
18	GHO_IMRG_STD_H	FREQUENCY	JR	EQ			AND	0	0
19	GHO_IMPTT_EXT	MEASMNT_POINT	JL	EQ				0	0
20	GHO_MRH_RULE_I	MEASMNT_POINT	JR	EQ			AND	0	0
21	GHO_IMPTT_EXT	MANDT	JL	EQ				0	0
22	GHO_MRH_RULE_I	CLIENT	JR	EQ			AND	0	0
23	GHO_IMRG_STD_H	MRH_SUB_FLAG		EQ	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	GHO_MRH_RULE_H	CLIENT		☐	MANDT	☐	Client
2	NET_ID	GHO_MRH_RULE_H	NET_ID		☐	GHO_NETOBJ_ID	☐	Network Object ID
3	MRH_RULE_ID	GHO_MRH_RULE_H	MRH_RULE_ID		☐	GHO_MRH_RULE_ID	☐	MRH Rule ID
4	SEQ_NO	GHO_MRH_RULE_I	SEQ_NO		☐	GHO_MRH_SEQ_NO	☐	MRH Sequence Number
5	SOURCE_TYPE	GHO_MRH_RULE_I	SOURCE_TYPE		☐	GHO_RULE_SOURCE_TYPE	☐	Source Type for MRH Rules
6	BRF_FORMULA_ID	GHO_MRH_RULE_I	BRF_FORMULA_ID		☐	FDT_UUID	☐	FDT: Universal Unique Identifier
7	MEDIUM	GHO_ALLOCRES_H	MEDIUM		☐	GHO_PRODUCT	☐	Product on which Allocation is Performed (Oil, Gas, Water)
8	FREQUENCY	GHO_ALLOCRES_H	FREQUENCY		☐	GHO_ALLOC_FREQUENCY	☐	Allocation Frequency
9	ALLOC_TYPE	GHO_ALLOCRES_H	ALLOC_TYPE		☐	GHO_ALLOC_TYPE	☐	Allocation Type
10	MATERIAL	GHO_IMRG_STD_H	ALLOC_MATERIAL		☐	GHO_ALLOC_MATERIAL	☐	Material relevant for allocation
11	ALLOC_RUN_ID	GHO_ALLOCRES_H	ALLOC_RUN_ID		☐	GHO_ALLOC_RUN_ID	☐	Identifier for an Instance of the Allocation Engine Run
12	PROD_TIMESTAMP	GHO_IMRG_STD_H	PROD_TIMESTAMP		☐	TZNTSTMPS	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
13	QUANTITY_TYPE	GHO_IMRG_STD_H	QUANTITY_TYPE		☐	GHO_QTY_TYPE	☐	Quantity Type
14	SOURCE_MEAS_PNT	GHO_MRH_RULE_H	MEASMNT_POINT		☐	IMRC_POINT	☐	Measuring Point
15	TARGET_MEAS_PNT	GHO_MRH_RULE_I	MEASMNT_POINT		☐	IMRC_POINT	☐	Measuring Point
16	SOURCE_NODE_ID	GHO_MRH_RULE_H	NODE_ID		☐	GHO_NETOBJ_ID	☐	Network Object ID
17	TARGET_NODE_ID	GHO_IMPTT_EXT	TPLNR		☐	TPLNR	☐	Functional Location
18	PROD_DATE	GHO_ALLOCRES_H	PROD_DATE		☐	GHO_START_DATE_ALLOC	☐	Production Start Date
19	PROD_TIME	GHO_ALLOCRES_H	PROD_TIME		☐	GHO_START_TIME_ALLOC	☐	Production Start Time

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20140121
SAP Release Created in	606