OIU_PR_MP

Transparent Table Application Table
20 Fields 3 CDS Views

PRA Measurement Points

OIU_PR_MP is an SAP database table in S/4HANA. PRA Measurement Points. It contains 20 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 (20)

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
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp

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]
    OIU_CRUSER,     -- Created By [ERNAM]
    OIU_TIMESTAMP,  -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, MP_NO)
);

Learn More