OIUP_PR_MPVL

PRA: Measurement Point Volumetric Data (PDM Shadow) | #transactional | Component: Production and Revenue Accounting

🔑 Keys (4)
💰 Amounts
∑ Quantities (4)
📅 Dates (4)
☰ Categorical (4)
Other (15)
🔗 Relations (15)

Column Name	Description
MANDT	Client
PDM_GUID	GUID in 'CHAR' Format in Uppercase
MPVL_NO	MP volume Number
MPVL_YEAR	Measurement point document year

Column Name	Description

Column Name	Description
📏 Standard volume unit (STD_VOL_U):
STD_VOL	Standard volume
📏 Energy quantity unit (ENERGY_U):
ENERGY	Energy quantity
📏 Unit of Measurement (T006.MSEHI):
MOL_VOLUME	Gas mol volume
📏 Heating Value Unit (HEAT_VAL_U):
HEAT_VAL	Heating value

Column Name	Description
PRD_DT	Production date
EFF_FROM_DT	Effective from date
EFF_TO_DT	Effective To Date
INVT_DT	Inventory date

Column Name	Description
VC_CD	Volume class code	Show values
FREQ_CD	Frequency	Show values
VL_CAT_CD	Volume Category Code	Show values
DENTYP	Density Type	Show values

Column Name	Description	Domain name
TRNSP_REF_NO	Transporter Reference Number	OIU_TEXT25
TRNSP_MTH_CD	Transportion method code	OIU_TRNSP_MTH_CD
TKT_NO	Ticket number	OIU_TKT_NO
TKT_TIMESTAMP	Ticket timestamp	TZNTSTMPS
ENT_TIMESTAMP	Entry timestamp	TZNTSTMPS
METER_START	Meter start time	TZNTSTMPS
METER_STOP	Meter stop time	TZNTSTMPS
TKBTRY_MP_NO	Tank battery measurement point number	OIU_MP_NO
BASE_DENSITY	Oil/gas density at standard/base conditions	OIU_DICHT
REC_TYPE_CD	Record type code	OIU_REC_TYPE_CD
EDI_STS_CD	EDI status code	OIU_EDI_STS_CD
ME_DOCNR	Meas. document number	BELNR
ME_DOCYR	Meas. document year	GJAHR
OIU_CRUSER	Name of Person Responsible for Creating the Object	USNAM
OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS

Master Data Relations	Join Conditions
Conversion group	`OIUP_PR_MPVL.MANDT == OIB01.MANDT` `OIUP_PR_MPVL.CONV_GRP == OIB01.UMRSL`
Delivery network number	`OIUP_PR_MPVL.MANDT == OIU_PR_DN.MANDT` `OIUP_PR_MPVL.DN_NO == OIU_PR_DN.DN_NO`
Energy quantity unit	`OIUP_PR_MPVL.MANDT == T006.MANDT` `OIUP_PR_MPVL.ENERGY_U == T006.MSEHI`
Standardized gas quantity unit	`OIUP_PR_MPVL.MANDT == T006.MANDT` `OIUP_PR_MPVL.HEAT_VAL_U == T006.MSEHI`
Load oil delivery network	`OIUP_PR_MPVL.MANDT == OIU_PR_DN.MANDT` `OIUP_PR_MPVL.LD_OIL_DN_NO == OIU_PR_DN.DN_NO`
Load oil measurement point	`OIUP_PR_MPVL.MANDT == OIU_PR_MP.MANDT` `OIUP_PR_MPVL.LD_OIL_MP_NO == OIU_PR_MP.MP_NO`
Load oil well completion Load oil well number Load oil well completion	`OIUP_PR_MPVL.MANDT == OIU_PR_WC.MANDT` `OIUP_PR_MPVL.LD_OIL_WL_NO == OIU_PR_WC.WL_NO` `OIUP_PR_MPVL.LD_OIL_WC_NO == OIU_PR_WC.WC_NO`
Load oil well number	`OIUP_PR_MPVL.MANDT == OIU_PR_WELL.MANDT` `OIUP_PR_MPVL.LD_OIL_WL_NO == OIU_PR_WELL.WL_NO`
Material Number	`OIUP_PR_MPVL.MANDT == OIU_CM_MAT_PRCD.MANDT` `OIUP_PR_MPVL.MATNR == OIU_CM_MAT_PRCD.MATNR`
Measurement point number	`OIUP_PR_MPVL.MANDT == OIU_PR_MP.MANDT` `OIUP_PR_MPVL.MP_NO == OIU_PR_MP.MP_NO`
Measurement Point ID	`OIUP_PR_MPVL.MANDT == OIU_PR_MP.MANDT` `OIUP_PR_MPVL.ORIG_MP_NO == OIU_PR_MP.MP_NO`
Standardized Volume Unit	`OIUP_PR_MPVL.MANDT == T006.MANDT` `OIUP_PR_MPVL.STD_VOL_U == T006.MSEHI`
Transporter number	`OIUP_PR_MPVL.MANDT == KNA1.MANDT` `OIUP_PR_MPVL.TRNSP_NO == KNA1.KUNNR`
Volume Source Code	`OIUP_PR_MPVL.MANDT == OIU_PR_VLSRC.MANDT` `OIUP_PR_MPVL.VS_CD == OIU_PR_VLSRC.VS_CD`
Volume Type Code	`OIUP_PR_MPVL.VT_CD == OIU_PR_VLTYP.VL_TYPE_CD`