OIU_RV_VLRVS

Valuation Reversal Notificaton | #masterdata | Component: Production and Revenue Accounting

🔑 Keys (12)
💰 Amounts
∑ Quantities
📅 Dates (1)
☰ Categorical (2)
Other (2)
🔗 Relations (8)

Column Name	Description
MANDT	Client
DN_NO FK	Delivery network number
PRD_DT	Production date
WL_NO FK	Well ID number
WC_NO FK	Well Completion Number
MP_NO FK	Measurement point number
MAJPD_CD	Major product code	Show values
BUKRS FK	Company Code
VNAME FK	Joint venture
DOI_NO FK	Division of interest (DOI)
CT_NO FK	Contract Number
FREQ_CD	Frequency	Show values

Column Name	Description

Column Name	Description

Column Name	Description
PRD_DT	Production date

Column Name	Description
MAJPD_CD	Major product code	Show values
FREQ_CD	Frequency	Show values

Column Name	Description	Domain name
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
Company	`OIU_RV_VLRVS.MANDT == T001.MANDT` `OIU_RV_VLRVS.BUKRS == T001.BUKRS`
Delivery Network	`OIU_RV_VLRVS.MANDT == OIU_PR_DN.MANDT` `OIU_RV_VLRVS.DN_NO == OIU_PR_DN.DN_NO`
Division of Interest Joint venture Division of interest (DOI) Company Code	`OIU_RV_VLRVS.MANDT == OIU_DO_DI.MANDT` `OIU_RV_VLRVS.VNAME == OIU_DO_DI.VNAME` `OIU_RV_VLRVS.DOI_NO == OIU_DO_DI.DOI_NO` `OIU_RV_VLRVS.BUKRS == OIU_DO_DI.BUKRS`
Measurement Point	`OIU_RV_VLRVS.MANDT == OIU_PR_MP.MANDT` `OIU_RV_VLRVS.MP_NO == OIU_PR_MP.MP_NO`
Prior Period Adjustment Reason	`OIU_RV_VLRVS.MANDT == OIU_CM_PPARSN.MANDT` `OIU_RV_VLRVS.PPA_RSN_CD == OIU_CM_PPARSN.PPA_RSN_CD`
E&P Venture Joint venture Company Code	`OIU_RV_VLRVS.MANDT == OIU_DO_JV.MANDT` `OIU_RV_VLRVS.VNAME == OIU_DO_JV.VNAME` `OIU_RV_VLRVS.BUKRS == OIU_DO_JV.BUKRS`
Well Completion Well ID number Well Completion Number	`OIU_RV_VLRVS.MANDT == OIU_PR_WC.MANDT` `OIU_RV_VLRVS.WL_NO == OIU_PR_WC.WL_NO` `OIU_RV_VLRVS.WC_NO == OIU_PR_WC.WC_NO`
Well	`OIU_RV_VLRVS.MANDT == OIU_PR_WELL.MANDT` `OIU_RV_VLRVS.WL_NO == OIU_PR_WELL.WL_NO`