SAP ABAP Table ROIU_PR_MP (Maintenance Structure: OIU_PR_MP)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
     ⤷ OIU (Package) PRA Production and Revenue Accounting (Upstream Business)

Basic Data

Table Category	INTTAB	Structure
Structure	ROIU_PR_MP	Table Relationship Diagram
Short Description	Maintenance Structure: OIU_PR_MP

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	REF_MP_NO	☐	OIU_MP_NO_REF	OIU_MP_NO	CHAR	20	0	Reference measurement point number	OIU_PR_MP
2	REF_MP_DE	☐	OIU_MP_DE	OIU_TEXT35	CHAR	35	0	Measurement point description
3	REF_MP_SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
4	MP_TYPE_DE	☐	OIU_TYPE_DE	OIU_TEXT50	CHAR	50	0	MP Type description
5	CNTRY_DE	☐	LANDX	TEXT15	CHAR	15	0	Country Name
6	PRI_GEO_DE	☐	OIU_PRI_GEO_DESC	CHAR30	CHAR	30	0	Primary geographical location description
7	SEC_GEO_DE	☐	OIU_SEC_GEO_DESC	CHAR30	CHAR	30	0	Secondary Geographical Location Description
8	UOMGR_DESCR	☐	OIU_ME_UOMGR_TX	TEXT40	CHAR	40	0	Description of the unit of measure group
9	MTR_CL_DE	☐	OIU_MTR_CL_DE	OIU_TEXT50	CHAR	50	0	Meter class description
10	MPET	☐	OIU_MP_SET	CHAR15	CHAR	15	0	Measurement point hierarchy group
11	XXDBACTION	☐	OIU_DBACTION	CHAR1	CHAR	1	0	Database Action Flag
12	REF_DOCNR	☐	OIUPR_MP_DOCNR	OIU_DOCNR	CHAR	10	0	MP document number
13	REF_DOCYR	☐	OIU_DOC_YEAR	GJAHR	NUMC	4	0	Document year
14	.INCLUDE	☐				0	0	PRA Measurement Points
15	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
16	MP_NO	☐	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	*
17	MP_DE	☐	OIU_MP_DE_CONV	OIU_TEXT35_CONV	CHAR	35	0	Measurement point description
18	SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
19	TYPE_CD	☐	OIU_MP_TYPE_CD	OIU_MP_TYPE_CD	CHAR	2	0	Measurement point type code	OIU_PR_MPTYP
20	UOM_GRP	☐	OIU_ME_UOMGR	OIU_ME_UOMGR	CHAR	3	0	unit of measure group	OIU_ME_UOM_GR
21	MTR_CL_CD	☐	OIU_MTR_CL_CD	OIU_MTR_CL_CD	CHAR	1	0	Meter class	OIU_PR_MTRCLS
22	CNTRY_CD	☐	OIU_COUNTRY	LAND1	CHAR	3	0	Country	T005
23	PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	OIU_CM_LXPGL
24	SEC_GEO_LOC	☐	OIU_SEC_GEO_LOC	OIU_SEC_GEO_LOC	CHAR	3	0	Secondary geographic location	OIU_CM_LXSGL
25	LAT_NO	☐	OIU_LAT_NO	OIU_LATIT_NO	DEC	8	6	Latitude number
26	LAT_DIR_CD	☐	OIU_LAT_DIR_CD	OIU_LATIT_DIR_CD	CHAR	1	0	Latitude direction code
27	LNG_NO	☐	OIU_LNG_NO	OIU_LONG_NO	DEC	9	6	Longitude
28	LNG_DIR_CD	☐	OIU_LNG_DIR_CD	OIU_LONG_DIR_CD	CHAR	1	0	Longitude Direction Code
29	MP_GRP	☐	OIU_MP_GRP	OIU_MP_GRP	CHAR	4	0	Measurement point number range group	OIU_PR_MP_GRP
30	MP_SET	☐	OIU_MP_SET	CHAR15	CHAR	15	0	Measurement point hierarchy group
31	DOCNR	☐	OIUPR_MP_DOCNR	OIU_DOCNR	CHAR	10	0	MP document number
32	DOCYR	☐	OIU_DOC_YEAR	GJAHR	NUMC	4	0	Document year
33	.INCLUDE	☐				0	0	Creator and date/time created
34	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
35	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIU_PR_MP	CNTRY_CD	T005	LAND1		1	CN
2	ROIU_PR_MP	MP_GRP	OIU_PR_MP_GRP	MP_GRP		1	CN
3	ROIU_PR_MP	MTR_CL_CD	OIU_PR_MTRCLS	MTR_CL_CD		1	CN
4	ROIU_PR_MP	PRI_GEO_LOC	OIU_CM_LXPGL	PRI_GEO_LOC		1	CN
5	ROIU_PR_MP	REF_MP_NO	OIU_PR_MP	MP_NO	KEY	1	CN
6	ROIU_PR_MP	SEC_GEO_LOC	OIU_CM_LXSGL	SEC_GEO_LOC		1	CN
7	ROIU_PR_MP	TYPE_CD	OIU_PR_MPTYP	MP_TYPE_CD		1	CN
8	ROIU_PR_MP	UOM_GRP	OIU_ME_UOM_GR	UOMGR		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in