OIUREP_VOL_DATA

Reported Volume Data by Reporting Entities | #transactional | Component: Royalty Reporting
Column Name Description
MANDT FK Client
YEAR_MONTH Reporting Year and Month
ORG_LEVEL1_NO FK Company Code
AGENCY FK Agency for Reporting
OIL_GAS_IND Oil and Gas Indicator Show values
YEAR_MONTH_AMND Year and Month for Amended Reports
PROPERTY_NO FK Joint venture
DOI_NO FK Division of interest (DOI)
WL_NO FK Well ID number
WC_NO FK Well Completion Number
MP_NO FK Measurement point number
AGENCY_PROD_CODE FK Agency defined product code
AGENCY_VOL_TYPE FK Agency defined Volume type
Column Name Description
💲 Currency (CURRENCY):
VALUE Generic value for Reporting
Column Name Description
📏 Standard volume unit (STD_VOL_U):
STD_VOL Standard volume
📏 Energy quantity unit (ENERGY_U):
ENERGY Energy quantity
Column Name Description
Column Name Description
OIL_GAS_IND Oil and Gas Indicator Show values
Column Name Description Domain name
UNIT_PROPERTY_NO Joint venture JV_NAME
UPLOAD_FLAG Single-Character Flag CHAR1
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
Agency for Reporting OIUREP_VOL_DATA.AGENCY == OIUREP_ROY_AGY.AGENCY
Agency defined product code
  • Agency for Reporting
  • Agency defined product code
Agency defined Volume type
  • Agency for Reporting
  • Agency defined Volume type
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
  • OIUREP_VOL_DATA.MANDT == OIU_DO_DI.MANDT
  • OIUREP_VOL_DATA.PROPERTY_NO == OIU_DO_DI.VNAME
  • OIUREP_VOL_DATA.DOI_NO == OIU_DO_DI.DOI_NO
  • OIUREP_VOL_DATA.ORG_LEVEL1_NO == OIU_DO_DI.BUKRS
Client OIUREP_VOL_DATA.MANDT == T000.MANDT
Measurement point number
Company Code
  • OIUREP_VOL_DATA.MANDT == T001.MANDT
  • OIUREP_VOL_DATA.ORG_LEVEL1_NO == T001.BUKRS
Joint venture
  • Joint venture
  • Company Code
  • OIUREP_VOL_DATA.MANDT == OIU_DO_JV.MANDT
  • OIUREP_VOL_DATA.PROPERTY_NO == OIU_DO_JV.VNAME
  • OIUREP_VOL_DATA.ORG_LEVEL1_NO == OIU_DO_JV.BUKRS
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number