OIUY3_TX_REVSTG

Royalty 2.0 - TX GLO - Royalty Reversals (Staging) | #transactional | Component: Royalty Reporting
Column Name Description
MANDT FK Client
BUKRS FK Company Code
SALES_DT Sales Date / Month
PDCD FK Full three char. product code (Major and Detail Products)
WL_NO FK Well ID number
WC_NO FK Well Completion Number
MP_NO FK Measurement point number
VNAME FK Joint venture
DOI_NO FK Division of interest (DOI)
DN_NO FK Delivery network number
CT_NO FK Contract Number
Column Name Description
Column Name Description
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
INTERFACE_FL Royalty 2.0 - TX GLO - Interface Flag Show values
Column Name Description Domain name
DOC_NO Val. document number OIU_MP_NO
DOC_YEAR Document year GJAHR
OPTION1 null
OPTION2 null
OPTION3 null
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
Company Code
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Client OIUY3_TX_REVSTG.MANDT == T000.MANDT
Measurement point number
Full three char. product code (Major and Detail Products) OIUY3_TX_REVSTG.PDCD == OIUX3_PDCD.PDCD
Joint venture
  • Joint venture
  • Company Code
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number