OIUGR_RPDT

Gen Rep - Report Detail Transaction | #transactional | Component: Royalty Reporting
Column Name Description
MANDT FK Client
RUN_ID FK Proc 2.0 - Run ID
RPDT_GUID 16-byte UID in 32 chars (hexadecimal)
Column Name Description
GROSS_VAL Gross value
NET_VAL Owner Net Value
OWNER_GROSS_VAL Owner Gross Value
TOT_GROSS_MKT_AM Gen Rep - Total Gross Marketing
TOT_GROSS_RMB_AM Gen Rep - Total Gross Marketing Reimbursement
TOT_GROSS_TAX_AM Gen Rep - Total Gross Tax
TOT_GROSS_TX_RMB Gen Rep - Total Gross Tax Reimbursement
TOT_OWNER_MKT_AM Gen Rep - Total Owner Marketing
TOT_OWNER_RMB_AM Gen Rep - Total Owner Marketing Reimbursement
TOT_OWNER_TAX_AM Gen Rep - Total Owner Tax
TOT_OWNER_TX_RMB Gen Rep - Total Owner Tax Reimbursement
TOT_OTHER_DED_AM Gen Rep - Total Other Deduct
Column Name Description
📏 Base Unit of Measure (HEAT_VAL_UOM):
HEAT_VAL Heating value
📏 Base Unit of Measure (PRES_UOM):
PS_BASE_QY Pressure Base
GROSS_VOL Total Gross Volume
GROSS_ENERGY Gross Energy
GROSS_PVR Gross PVR
GROSS_PTR Gross PTR
NET_VOL Owner Net Volume
OWNER_ENERGY Owner Energy
OWN_PVR Owner PVR
OWN_PTR Owner PTR
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
REV_BOOK_ADJ_IND Reversal/Booking/Adjustment Show values
Column Name Description Domain name
ENTITY_ID Gen Rep - Agency Entity ID CHAR20
ENTITY_LINK_GUID 16-byte UID in 32 chars (hexadecimal) SYSUUID_C32
GRAVITY Gen Rep - Oil/gas density at standard/base conditions OIU_OIB_DICHT
CHANGE_USER Last Changed By USNAM
CHANGE_TIMESTAMP Last Changed Timestamp /PRA/TZNTSTMPS
Master Data Relations Join Conditions
Base Unit of Measure
  • OIUGR_RPDT.MANDT == T006.MANDT
  • OIUGR_RPDT.ENERGY_UOM == T006.MSEHI
Base Unit of Measure
  • OIUGR_RPDT.MANDT == T006.MANDT
  • OIUGR_RPDT.HEAT_VAL_UOM == T006.MSEHI
Client OIUGR_RPDT.MANDT == T000.MANDT
Base Unit of Measure
  • OIUGR_RPDT.MANDT == T006.MANDT
  • OIUGR_RPDT.PRES_UOM == T006.MSEHI
Gen Rep - Agency Product Code
  • ?
  • Gen Rep - Agency Product Code
  • OIUGR_RPDT.MANDT == OIUGR_PDC.MANDT
  • OIUGR_RPDT.[column in domain "OIUE2_PROCESS_ID"] == OIUGR_PDC.PROC_ID
  • OIUGR_RPDT.PRODUCT_CODE == OIUGR_PDC.PRODUCT_CODE
Base Unit of Measure
  • OIUGR_RPDT.MANDT == T006.MANDT
  • OIUGR_RPDT.VOL_UOM == T006.MSEHI
Currency Key
  • OIUGR_RPDT.MANDT == TCURC.MANDT
  • OIUGR_RPDT.WAERS == TCURC.WAERS