SAP Table OIU_PR_MP
PRA Measurement Points
OIU_PR_MP (PRA Measurement Points) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link OIU_PR_MP to other SAP tables.
OIU_PR_MP table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||
MP_NO | Measurement point number | OIU_MP_NO | CHAR | 20 | 0 | |||||||||
MP_DE | Measurement point description | OIU_MP_DE_CONV | CHAR | 35 | 0 | |||||||||
SHTXT | Description | OIU_SHTXT | CHAR | 35 | 0 | |||||||||
TYPE_CD | Measurement point type code | OIU_MP_TYPE_CD | OIU_PR_MPTYP | CHAR | 2 | 0 | ||||||||
UOM_GRP | unit of measure group | OIU_ME_UOMGR | OIU_ME_UOM_GR | CHAR | 3 | 0 | ||||||||
MTR_CL_CD | Meter class | OIU_MTR_CL_CD | OIU_PR_MTRCLS | CHAR | 1 | 0 | ||||||||
CNTRY_CD | Country | OIU_COUNTRY | T005 | CHAR | 3 | 0 | ||||||||
PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | OIU_PRI_GEO_LOC | OIU_CM_LXPGL | CHAR | 2 | 0 | ||||||||
SEC_GEO_LOC | Secondary geographic location | OIU_SEC_GEO_LOC | OIU_CM_LXSGL | CHAR | 3 | 0 | ||||||||
LAT_NO | Latitude number | OIU_LAT_NO | DEC | 8 | 6 |
Possible values
|
||||||||
LAT_DIR_CD | Latitude direction code | OIU_LAT_DIR_CD | CHAR | 1 | 0 |
Possible values
|
||||||||
LNG_NO | Longitude | OIU_LNG_NO | DEC | 9 | 6 |
Possible values
|
||||||||
LNG_DIR_CD | Longitude Direction Code | OIU_LNG_DIR_CD | CHAR | 1 | 0 |
Possible values
|
||||||||
MP_GRP | Measurement point number range group | OIU_MP_GRP | OIU_PR_MP_GRP | CHAR | 4 | 0 | ||||||||
MP_SET | Measurement point hierarchy group | OIU_MP_SET | CHAR | 15 | 0 | |||||||||
DOCNR | MP document number | OIUPR_MP_DOCNR | CHAR | 10 | 0 | |||||||||
DOCYR | Document year | OIU_DOC_YEAR | NUMC | 4 | 0 | |||||||||
OIU_CRUSER | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||
OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15 | 0 |
OIU_PR_MP foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
OIU_PR_MP | CNTRY_CD | OIU_PR_MP | CNTRY_CD | T005 | Countries | LAND1 |
OIU_PR_MP | CNTRY_CD | OIU_PR_MP | MANDT | T005 | Countries | MANDT |
OIU_PR_MP | MP_GRP | OIU_PR_MP | MANDT | OIU_PR_MP_GRP | PRA MP Group Codes | MANDT |
OIU_PR_MP | MP_GRP | OIU_PR_MP | MP_GRP | OIU_PR_MP_GRP | PRA MP Group Codes | MP_GRP |
OIU_PR_MP | MTR_CL_CD | MANDT | MANDT | OIU_PR_MTRCLS | Meter Class - TBLPR061 | MANDT |
OIU_PR_MP | MTR_CL_CD | OIU_PR_MP | MTR_CL_CD | OIU_PR_MTRCLS | Meter Class - TBLPR061 | MTR_CL_CD |
OIU_PR_MP | PRI_GEO_LOC | OIU_PR_MP | MANDT | OIU_CM_LXPGL | Country and Primary Geo. Location Xref | MANDT |
OIU_PR_MP | PRI_GEO_LOC | OIU_PR_MP | CNTRY_CD | OIU_CM_LXPGL | Country and Primary Geo. Location Xref | LAND1 |
OIU_PR_MP | PRI_GEO_LOC | OIU_PR_MP | PRI_GEO_LOC | OIU_CM_LXPGL | Country and Primary Geo. Location Xref | PRI_GEO_LOC |
OIU_PR_MP | SEC_GEO_LOC | OIU_PR_MP | CNTRY_CD | OIU_CM_LXSGL | Cross Reference Between Country and Secondary Geo. Locatio | LAND1 |
OIU_PR_MP | SEC_GEO_LOC | OIU_PR_MP | PRI_GEO_LOC | OIU_CM_LXSGL | Cross Reference Between Country and Secondary Geo. Locatio | PRI_GEO_LOC |
OIU_PR_MP | SEC_GEO_LOC | OIU_PR_MP | SEC_GEO_LOC | OIU_CM_LXSGL | Cross Reference Between Country and Secondary Geo. Locatio | SEC_GEO_LOC |
OIU_PR_MP | SEC_GEO_LOC | OIU_PR_MP | MANDT | OIU_CM_LXSGL | Cross Reference Between Country and Secondary Geo. Locatio | MANDT |
OIU_PR_MP | TYPE_CD | OIU_PR_MP | TYPE_CD | OIU_PR_MPTYP | Measurement Point Types - Tblpr002 | MP_TYPE_CD |
OIU_PR_MP | UOM_GRP | OIU_PR_MP | MANDT | OIU_ME_UOM_GR | PRA Measurement: Unit of Measurement Groups | MANDT |
OIU_PR_MP | UOM_GRP | OIU_PR_MP | UOM_GRP | OIU_ME_UOM_GR | PRA Measurement: Unit of Measurement Groups | UOMGR |