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
0 Degrees
LAT_DIR_CD Latitude direction code OIU_LAT_DIR_CD CHAR 1 0
N North
S South
U Undefined
LNG_NO Longitude OIU_LNG_NO DEC 9 6
0 Degrees
LNG_DIR_CD Longitude Direction Code OIU_LNG_DIR_CD CHAR 1 0
W West
E East
U Undefined
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