OIUGR_ROYSTG_PR

Gen Rep - Royalty Transaction PR Data (Staging) | #transactional | Component: Royalty Reporting
Column Name Description
MANDT FK Client
ROYTXN_PR_GUID 16-byte UID in 32 chars (hexadecimal)
PRD_MATNR Production Material
MATNR FK Material Number
VT_CD FK Volume type code
VC_CD Volume class code Show values
Column Name Description
Column Name Description
📏 Standard volume unit (STD_VOL_U):
STD_VOL Standard volume
📏 Energy quantity unit (ENERGY_U):
ENERGY Energy quantity
📏 Heating Value Unit (HEAT_VAL_U):
HEAT_VAL Heating value
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
VC_CD Volume class code Show values
DAYS_PROD Days produced Show values
PRD_HRS Production hours Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Well Completion Number
  • Well ID number
  • Well Completion Number
  • OIUGR_ROYSTG_PR.MANDT == OIU_PR_WC.MANDT
  • OIUGR_ROYSTG_PR.DERIVED_WL_NO == OIU_PR_WC.WL_NO
  • OIUGR_ROYSTG_PR.DERIVED_WC_NO == OIU_PR_WC.WC_NO
Well ID number
Client OIUGR_ROYSTG_PR.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • OIUGR_ROYSTG_PR.MATNR == MARA.MATNR
  • OIUGR_ROYSTG_PR.MANDT == MARA.MANDT
Volume type code OIUGR_ROYSTG_PR.VT_CD == OIU_PR_VLTYP.VL_TYPE_CD
Other Relations | to Master Data Relations ↑ Join Conditions
Proc 2.0 - Process ID
  • Proc 2.0 - Process ID
  • Client