OIU_PR_MP

Transparent Table Application Table
18 Fields 3 CDS Views

PRA Measurement Points

OIU_PR_MP is an SAP database table in S/4HANA. PRA Measurement Points. It contains 18 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MeasurementPoint view from BASIC Measurement Point
UPOV_PR_MP_PRA view from Measurement Point(PRA)
UPOV_TRIM_MP_PRA view from Trimmed Measurement Point Value of PRA

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY mp_no oiu_mp_no Measurement Pt
mp_de oiu_mp_de_conv MP descr.
shtxt oiu_shtxt Description
type_cd oiu_mp_type_cd MP Type
uom_grp oiu_me_uomgr UoM group
mtr_cl_cd oiu_mtr_cl_cd Meter Class
cntry_cd oiu_country Country/Reg.
pri_geo_loc oiu_pri_geo_loc Primary geo.loc
sec_geo_loc oiu_sec_geo_loc Secndry geo.loc
lat_no oiu_lat_no Latitude
lat_dir_cd oiu_lat_dir_cd Latitude DC
lng_no oiu_lng_no Longitude
lng_dir_cd oiu_lng_dir_cd Longitude DC
mp_grp oiu_mp_grp MP Group
mp_set oiu_mp_set MP hier.node
docnr oiupr_mp_docnr Doc. no.
docyr oiu_doc_year Document year

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- PRA Measurement Points
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_MP (
    MANDT,        -- Client [mandt]
    MP_NO,        -- Measurement Pt [oiu_mp_no]
    MP_DE,        -- MP descr. [oiu_mp_de_conv]
    SHTXT,        -- Description [oiu_shtxt]
    TYPE_CD,      -- MP Type [oiu_mp_type_cd]
    UOM_GRP,      -- UoM group [oiu_me_uomgr]
    MTR_CL_CD,    -- Meter Class [oiu_mtr_cl_cd]
    CNTRY_CD,     -- Country/Reg. [oiu_country]
    PRI_GEO_LOC,  -- Primary geo.loc [oiu_pri_geo_loc]
    SEC_GEO_LOC,  -- Secndry geo.loc [oiu_sec_geo_loc]
    LAT_NO,       -- Latitude [oiu_lat_no]
    LAT_DIR_CD,   -- Latitude DC [oiu_lat_dir_cd]
    LNG_NO,       -- Longitude [oiu_lng_no]
    LNG_DIR_CD,   -- Longitude DC [oiu_lng_dir_cd]
    MP_GRP,       -- MP Group [oiu_mp_grp]
    MP_SET,       -- MP hier.node [oiu_mp_set]
    DOCNR,        -- Doc. no. [oiupr_mp_docnr]
    DOCYR,        -- Document year [oiu_doc_year]
    PRIMARY KEY (MANDT, MP_NO)
);

Learn More