OIUGR_ROYHST_CA

Gen Rep - Royalty History CA Data | #transactional | Component: Royalty Reporting
Column Name Description
MANDT FK Client
ROYTXN_CA_GUID 16-byte UID in 32 chars (hexadecimal)
MATNR FK Material Number
CT_NO FK Contract Number
OWN_NO FK PRA owner
OWN_INT_TYPE_CD FK Participant Interest Type
OWN_ISQ_NO Owner Interest Sequence Number
ORIG_MP_NO FK Original measurement point number
TRNSP_NO FK Transporter number
FREQ_CD Frequency Show values
Column Name Description
Column Name Description
📏 Actual Volume Units (ACTL_VOL_U):
ACTL_VOL Actual Volume
📏 Heating Value Unit (HEAT_VAL_U):
HEAT_VAL Heating value
📏 Actual Energy Unit (ACTL_ENERGY_U):
ACTL_ENERGY Actual Energy
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
FREQ_CD Frequency Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Contract Number
Well Completion Number
  • Well ID number
  • Well Completion Number
  • OIUGR_ROYHST_CA.MANDT == OIU_PR_WC.MANDT
  • OIUGR_ROYHST_CA.DERIVED_WL_NO == OIU_PR_WC.WL_NO
  • OIUGR_ROYHST_CA.DERIVED_WC_NO == OIU_PR_WC.WC_NO
Well ID number
Client OIUGR_ROYHST_CA.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • OIUGR_ROYHST_CA.MATNR == MARA.MATNR
  • OIUGR_ROYHST_CA.MANDT == MARA.MANDT
Original measurement point number
Participant Interest Type OIUGR_ROYHST_CA.OWN_INT_TYPE_CD == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • OIUGR_ROYHST_CA.MANDT == LFA1.MANDT
  • OIUGR_ROYHST_CA.OWN_NO == LFA1.LIFNR
Transporter number
  • OIUGR_ROYHST_CA.MANDT == KNA1.MANDT
  • OIUGR_ROYHST_CA.TRNSP_NO == KNA1.KUNNR
Other Relations | to Master Data Relations ↑ Join Conditions
Proc 2.0 - Process ID
  • Proc 2.0 - Process ID
  • Client