OIUP_PR_MPVL SAP (PRA: Measurement Point Volumetric Data (PDM Shadow)) Table details

Dictionary Type: Table
Description: PRA: Measurement Point Volumetric Data (PDM Shadow)




ABAP Code to SELECT data from OIUP_PR_MPVL
Related tables to OIUP_PR_MPVL
Access table OIUP_PR_MPVL




Table field list including key, data, relationships and ABAP select examples

OIUP_PR_MPVL is a standard SAP Table which is used to store PRA: Measurement Point Volumetric Data (PDM Shadow) data and is available within R/3 SAP systems depending on the version and release level.

The OIUP_PR_MPVL table consists of various fields, each holding specific information or linking keys about PRA: Measurement Point Volumetric Data (PDM Shadow) data available in SAP. These include PDM_GUID (GUID in 'CHAR' Format in Uppercase), MPVL_NO (MP volume Number), MPVL_YEAR (Measurement point document year), MP_NO (Measurement point number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIUP_PR_MPVL table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
PDM_GUIDGUID in 'CHAR' Format in Uppercase GUID_32CHAR32SYSUUID_C
MPVL_NOMP volume Number OIU_MPVL_NOCHAR10ALPHAOIU_DOCNROIU_MPVL_NO
MPVL_YEARMeasurement point document year OIU_MPVL_YEARNUMC4GJAHRGJAHROIU_MPVL_YEAR
MP_NOMeasurement point number OIU_MP_NOCHAR20OIU_PR_MPALPHAOIU_MP_NOOIU_MPH_OIU_PR_MP
VT_CDVolume Type Code OIU_VL_TYPE_CDCHAR2OIU_PR_VLTYPOIU_VL_TYPE_CDOIU_VL_TYPE
VC_CDVolume class code OIU_VC_CDCHAR1OIU_VC_CDOIU_VCCD
TRNSP_NOTransporter number OIU_TRNSP_NOCHAR10KNA1ALPHAKUNNROIU_TRNSP_NO
TRNSP_REF_NOTransporter Reference Number OIU_TRNSP_REF_NOCHAR25OIU_TEXT25OIU_TRNSP_R
MATNRMaterial Number MATNRCHAR18OIU_CM_MAT_PRCDMATN1MATNRMATS_MAT1
FREQ_CDFrequency OIU_FREQ_CDCHAR1OIU_FREQ_CDOIU_FRQ
DN_NODelivery network number OIU_DN_NOCHAR20OIU_PR_DNALPHAOIU_DN_NOOIU_DNH_OIU_PR_DN
TRNSP_MTH_CDTransportion method code OIU_TRNSP_MTH_CDCHAR1OIU_TRNSP_MTH_CD
CT_NOContract Number OIU_CT_NOCHAR10OIU_RV_CTALPHAOIUCM_CONTRACT_NUMBEROIU_CID
TKT_NOTicket number OIU_TKT_NOCHAR7OIU_TKT_NOOIU_TKT_NO
TKT_TIMESTAMPTicket timestamp OIU_TKT_TIMESTMPDEC15TZNTSTMPS
PRD_DTProduction date OIU_PRD_DTDATS8DATUMOIU_PRD_DATE
ENT_TIMESTAMPEntry timestamp OIU_ENT_TIMESTMPDEC15TZNTSTMPS
EFF_FROM_DTEffective from date OIU_EFF_FROM_DTDATS8DATUMOIU_EFD
EFF_TO_DTEffective To Date OIU_EFF_TO_DTDATS8DATUMOIU_ETD
METER_STARTMeter start time OIU_METER_STARTDEC15TZNTSTMPS
METER_STOPMeter stop time OIU_METER_STOPDEC15TZNTSTMPS
CONV_GRPConversion Group (Oil, Natural Gas,..) OIB_UMRSLCHAR4OIB01OIB_UMRSL
TKBTRY_MP_NOTank battery measurement point number OIU_TKBTRY_MP_NOCHAR20Assigned to domainALPHAOIU_MP_NO
VS_CDVolume Source Code OIU_VS_CDCHAR1OIU_PR_VLSRCOIU_VS_CDOIU_VS_CD
VL_CAT_CDVolume Category Code OIU_VL_CAT_CDCHAR1OIU_VL_CAT_CD
LD_OIL_DN_NOLoad oil delivery network OIU_LD_OIL_DN_NOCHAR20OIU_PR_DNALPHAOIU_DN_NOH_OIU_PR_DN
LD_OIL_WL_NOLoad oil well number OIU_LD_OIL_WL_NOCHAR15OIU_PR_WELLALPHAOIU_WL_NO
LD_OIL_WC_NOLoad oil well completion OIU_LD_OIL_WC_NOCHAR5OIU_PR_WCALPHAOIU_WC_NO
LD_OIL_MP_NOLoad oil measurement point OIU_LD_OIL_MP_NOCHAR20OIU_PR_MPALPHAOIU_MP_NOH_OIU_PR_MP
STD_VOLStandard volume OIU_STD_VOLQUAN13(3) MENGE
STD_VOL_UStandard volume unit OIU_STD_VOL_UUNIT3T006CUNITMEINS
ENERGYEnergy quantity OIU_ENERGYQUAN13(3) MENGE
ENERGY_UEnergy quantity unit OIU_ENERGY_UUNIT3T006CUNITMEINS
MOL_VOLUMEGas mol volume OIU_MOL_VOLUMEQUAN13(3) MENGE
HEAT_VALHeating value OIU_HEAT_VALQUAN13(3) MENGE
HEAT_VAL_UHeating Value Unit OIU_HEAT_VAL_UUNIT3T006CUNITMEINSOUMH
BASE_DENSITYOil/gas density at standard/base conditions OIB_BDICHFLTP16(16) OIB_DICHT
BASE_DENSITY_UUnit for densities at standard/base conditions OIB_BDNEHUNIT3Assigned to domainCUNITMEINS
DENTYPDensity Type OIB_DNTYPCHAR1OIB_DNTYP
REC_TYPE_CDRecord type code OIU_REC_TYPE_CDCHAR4OIU_REC_TYPE_CD
EDI_STS_CDEDI status code OIU_EDI_STS_CDCHAR1OIU_EDI_STS_CD
ME_DOCNRMeas. document number OIU_ME_DOCNRCHAR10ALPHABELNROIU_ME_DOCNR
ME_DOCYRMeas. document year OIU_ME_DOCYRNUMC4GJAHRGJAHROIU_ME_DOCYR
ORIG_MP_NOOriginal measurement point number OIU_ORIG_MP_NOCHAR20OIU_PR_MPALPHAOIU_MP_NOOIU_ORIG_MP_NO
INVT_DTInventory date OIU_INV_DTDATS8DATUM
OIU_CRUSERName of Person who Created the Object ERNAMCHAR12USNAM
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS

Key field Non-key field



How do I retrieve data from SAP table OIUP_PR_MPVL using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIUP_PR_MPVL to SELECT all data from the table
DATA: WA_OIUP_PR_MPVL TYPE OIUP_PR_MPVL.

SELECT SINGLE *
FROM OIUP_PR_MPVL
INTO CORRESPONDING FIELDS OF WA_OIUP_PR_MPVL
WHERE...

How to access SAP table OIUP_PR_MPVL

Within an ECC or HANA version of SAP you can also view further information about OIUP_PR_MPVL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!