OIUGR_ROYHST

Gen Rep - Royalty Transaction History | #transactional | Component: Royalty Reporting
Column Name Description
MANDT FK Client
ROYTXN_GUID 16-byte UID in 32 chars (hexadecimal)
Column Name Description
💲 Currency Key (WAERS):
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
📏 Base Unit of Measure (VOL_UOM):
GROSS_VOL Total Gross Volume
GROSS_PVR Gross PVR
NET_VOL Owner Net Volume
OWN_PVR Owner PVR
📏 Base Unit of Measure (ENERGY_UOM):
GROSS_ENERGY Gross Energy
GROSS_PTR Gross PTR
OWNER_ENERGY Owner Energy
OWN_PTR Owner PTR
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
REV_BOOK_ADJ_IND Reversal/Booking/Adjustment Show values
OPERATED_FL Operated flag Show values
ENTY_CD Entity Code Show values
PAY_CD Pay Code Show values
INTERFACE_FL General Flag Show values
OOS_FL General Flag Show values
MASTER_LEVEL Texas Master Data Level Show values
Column Name Description Domain name
OWN_ISQ_NO Owner Interest Sequence Number OIU_OWN_ISQ_NO
KOSTL Cost Center KOSTL
GRAVITY Gen Rep - Oil/gas density at standard/base conditions OIU_OIB_DICHT
DISB_DECIMAL Disbursement Decimal OIU_PERCENT98
NRI_DECIMAL Net Revenue Interest Percent OIU_PERCENT98
DOC_NO Val. document number OIU_MP_NO
DOC_YEAR Document year GJAHR
OPTION1 Single-Character Flag CHAR1
OPTION2 Single-Character Flag CHAR1
OPTION3 Single-Character Flag CHAR1
PROF_LINK_GUID 16-byte UID in 32 chars (hexadecimal) SYSUUID_C32
ADDRNUMBER Address Number AD_ADDRNUM
MASTER_LINK_GUID 16-byte UID in 32 chars (hexadecimal) SYSUUID_C32
PRODUCT_CODE Gen Rep - Agency Product Code CHAR5
REFERENCE_RUN_ID Proc 2.0 - Run ID
CHANGE_USER Last Changed By USNAM
CHANGE_TIMESTAMP Last Changed Timestamp /PRA/TZNTSTMPS
Master Data Relations Join Conditions
Company Code
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • OIUGR_ROYHST.MANDT == T005E.MANDT
  • OIUGR_ROYHST.COUNC == T005E.COUNC
  • OIUGR_ROYHST.LAND1 == T005E.LAND1
  • OIUGR_ROYHST.REGIO == T005E.REGIO
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Base Unit of Measure
  • OIUGR_ROYHST.MANDT == T006.MANDT
  • OIUGR_ROYHST.ENERGY_UOM == T006.MSEHI
Base Unit of Measure
  • OIUGR_ROYHST.MANDT == T006.MANDT
  • OIUGR_ROYHST.HEAT_VAL_UOM == T006.MSEHI
Country/Region Key
  • Country/Region Key
  • Client
  • OIUGR_ROYHST.LAND1 == T005.LAND1
  • OIUGR_ROYHST.MANDT == T005.MANDT
Client OIUGR_ROYHST.MANDT == T000.MANDT
Measurement point number
Participant Interest Type OIUGR_ROYHST.OWN_INT_TYPE_CD == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • OIUGR_ROYHST.MANDT == LFA1.MANDT
  • OIUGR_ROYHST.OWN_NO == LFA1.LIFNR
Full three char. product code (Major and Detail Products) OIUGR_ROYHST.PDCD == OIUX3_PDCD.PDCD
Base Unit of Measure
  • OIUGR_ROYHST.MANDT == T006.MANDT
  • OIUGR_ROYHST.PRES_UOM == T006.MSEHI
Primary geographical location (PRI geo. loc.)
  • Primary geographical location (PRI geo. loc.)
  • Country/Region Key
  • Client
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • OIUGR_ROYHST.MANDT == T005S.MANDT
  • OIUGR_ROYHST.LAND1 == T005S.LAND1
  • OIUGR_ROYHST.REGIO == T005S.BLAND
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • OIUGR_ROYHST.[column in domain "BUKRS"] == SKB1.BUKRS
  • OIUGR_ROYHST.MANDT == SKB1.MANDT
  • OIUGR_ROYHST.SAKNR == SKB1.SAKNR
Unit venture
  • Unit venture
  • Company Code
Volume type code OIUGR_ROYHST.VL_TYPE_CD == OIU_PR_VLTYP.VL_TYPE_CD
Joint venture
  • Joint venture
  • Company Code
Base Unit of Measure
  • OIUGR_ROYHST.MANDT == T006.MANDT
  • OIUGR_ROYHST.VOL_UOM == T006.MSEHI
Currency Key
  • OIUGR_ROYHST.MANDT == TCURC.MANDT
  • OIUGR_ROYHST.WAERS == TCURC.WAERS
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number
Other Relations | to Master Data Relations ↑ Join Conditions
Proc 2.0 - Process ID
  • Proc 2.0 - Process ID
  • Client