OIUGR_ROYHSTA - Gen Rep - Royalty Transaction History (Allocated)

Gen Rep - Royalty Transaction History (Allocated) information is stored in SAP table OIUGR_ROYHSTA.
It is part of development package OIU_GR in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Generic Royalty SLA".

Fields for table OIUGR_ROYHSTA

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
ROYTXN_GUID16-byte UID in 32 chars (hexadecimal)XSYSUUID_C32CHAR64
ENTITY_IDGen Rep - Agency Entity IDXOIUGR_ENTITY_IDCHAR40OIUGR_ENTITY
.INCLUDEROIUGR_ROYTXN_KEYROIUGR_ROYTXN_KEY0
.INCLUDEROIUGR_REVTXN_KEYROIUGR_REVTXN_KEY0
PROC_IDProc 2.0 - Process IDOIUE2_PROCESS_IDCHAR20OIUGR_PROC_ID
BUKRSCompany CodeBUKRSCHAR8OIU_CM_COMPC
SALES_DTSales Date / MonthOIU_SALE_DTDATS16
PDCDFull three char. product code (Major and Detail Products)OIU_FULL_PD_CDCHAR6OIUX3_PDCD
WL_NOWell ID numberOIU_WL_NOCHAR30OIU_PR_WELL
WC_NOWell Completion NumberOIU_WC_NOCHAR10OIU_PR_WC
MP_NOMeasurement point numberOIU_MP_NOCHAR40OIU_PR_MP
VNAMEJoint ventureJV_NAMECHAR12OIU_DO_JV
DOI_NODivision of interest (DOI)OIU_DOI_NOCHAR10OIU_DO_DI
DN_NODelivery network numberOIU_DN_NOCHAR40OIU_PR_DN
CT_NOContract NumberOIU_CT_NOCHAR20OIU_RV_CT
VL_TYPE_CDVolume type codeOIU_VT_CDCHAR4OIU_PR_VLTYP
OWN_NOPRA ownerOIU_OWN_NOCHAR20LFA1
OWN_INT_TYPE_CDParticipant Interest TypeOIU_PART_INT_TYPECHAR4OIU_CM_PINTTY
OWN_ISQ_NOOwner Interest Sequence NumberOIU_OWN_ISQ_NOCHAR4
KOSTLCost CenterKOSTLCHAR20*
REV_BOOK_ADJ_INDReversal/Booking/AdjustmentOIUX3_REVERSE_BOOKING_ADJ_INDCHAR2
.INCLUDEROIUGR_ROYTXNA_NONKEYROIUGR_ROYTXNA_NONKEY0
ALLOC_PERCENTGen Rep - Allocation PercentageOIUGR_ALLOCATION_PERCENTAGEDEC5
ENTITY_LINK_GUID16-byte UID in 32 chars (hexadecimal)SYSUUID_C32CHAR64
.INCLUDEROIUGR_ROYTXN_NONKEYROIUGR_ROYTXN_NONKEY0
UNIT_VNAMEUnit venture/PRA/UNIT_JVCHAR12OIU_DO_JV
OPERATED_FLOperated flagOIU_OPERATOR_FLCHAR2
LAND1Country/Region KeyLAND1CHAR6T005
REGIORegion (State, Province, County)REGIOCHAR6T005S
PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)OIU_PRI_GEO_LOCCHAR4OIU_CM_LXPGL
COUNCCounty CodeCOUNCCHAR6T005E
SAKNRG/L Account NumberSAKNRCHAR20SKB1
ENTY_CDEntity CodeOIU_ENTY_CDCHAR4
PAY_CDPay CodeOIU_PAY_CDCHAR4
WAERSCurrency KeyWAERSCUKY10TCURC
VOL_UOMBase Unit of MeasureMEINSUNIT6T006
ENERGY_UOMBase Unit of MeasureMEINSUNIT6T006
HEAT_VAL_UOMBase Unit of MeasureMEINSUNIT6T006
PRES_UOMBase Unit of MeasureMEINSUNIT6T006
HEAT_VALHeating valueOIU_HEAT_VALQUAN7
PS_BASE_QYPressure BaseOIU_PS_BASEQUAN7
GRAVITYGen Rep - Oil/gas density at standard/base conditionsOIUGR_GRAVITYFLTP8
DISB_DECIMALDisbursement Decimal/PRA/DISB_DECMDEC5
NRI_DECIMALNet Revenue Interest PercentOIU_NRI_PCDEC5
DOC_NOVal. document numberOIURV_DOCNRCHAR40*
DOC_YEARDocument yearOIU_DOC_YEARNUMC8
OPTION1Single-Character FlagCHAR1CHAR2
OPTION2Single-Character FlagCHAR1CHAR2
OPTION3Single-Character FlagCHAR1CHAR2
INTERFACE_FLGeneral FlagFLAGCHAR2
OOS_FLGeneral FlagFLAGCHAR2
.INCLUDEROIUGR_ROYTXN_NONKEY_NUMERICROIUGR_ROYTXN_NONKEY_NUMERIC0
GROSS_VOLTotal Gross Volume/PRA/GROSS_VOLQUAN7
GROSS_ENERGYGross Energy/PRA/GROSS_ENERGYQUAN7
GROSS_PVRGross PVR/PRA/GROSS_PVRQUAN7
GROSS_PTRGross PTR/PRA/GROSS_PTRQUAN7
NET_VOLOwner Net Volume/PRA/NET_VOLQUAN7
OWNER_ENERGYOwner Energy/PRA/OWNER_ENERGYQUAN7
OWN_PVROwner PVR/PRA/OWN_PVRQUAN7
OWN_PTROwner PTR/PRA/OWN_PTRQUAN7
GROSS_VALGross value/PRA/GROSS_VALCURR7
NET_VALOwner Net Value/PRA/NET_VALCURR7
OWNER_GROSS_VALOwner Gross Value/PRA/OWN_GROSS_VALCURR7
.INCLUDEROIUGR_ROYTXN_NONKEY_DERIVEDROIUGR_ROYTXN_NONKEY_DERIVED0
PROF_LINK_GUID16-byte UID in 32 chars (hexadecimal)SYSUUID_C32CHAR64
ADDRNUMBERAddress NumberAD_ADDRNUMCHAR20*
MASTER_LEVELTexas Master Data LevelOIUX3_TX_MASTER_LEVELCHAR2
MASTER_LINK_GUID16-byte UID in 32 chars (hexadecimal)SYSUUID_C32CHAR64
PRODUCT_CODEGen Rep - Agency Product CodeOIUGR_PRODUCT_CODECHAR10
REFERENCE_RUN_IDProc 2.0 - Run IDOIUE2_RUN_IDNUMC20
.INCLUDEROIUGR_ROYTXN_NONKEY_CALCROIUGR_ROYTXN_NONKEY_CALC0
TOT_GROSS_MKT_AMGen Rep - Total Gross MarketingOIUGR_TOTAL_GROSS_MKT_AMCURR8
TOT_GROSS_RMB_AMGen Rep - Total Gross Marketing ReimbursementOIUGR_TOTAL_GROSS_RMB_AMCURR8
TOT_GROSS_TAX_AMGen Rep - Total Gross TaxOIUGR_TOTAL_GROSS_TAX_AMCURR8
TOT_GROSS_TX_RMBGen Rep - Total Gross Tax ReimbursementOIUGR_TOTAL_GROSS_TX_RMBCURR8
TOT_OWNER_MKT_AMGen Rep - Total Owner MarketingOIUGR_TOTAL_OWNER_MKT_AMCURR8
TOT_OWNER_RMB_AMGen Rep - Total Owner Marketing ReimbursementOIUGR_TOTAL_OWNER_RMB_AMCURR8
TOT_OWNER_TAX_AMGen Rep - Total Owner TaxOIUGR_TOTAL_OWNER_TAX_AMCURR8
TOT_OWNER_TX_RMBGen Rep - Total Owner Tax ReimbursementOIUGR_TOTAL_OWNER_TX_RMBCURR8
TOT_OTHER_DED_AMGen Rep - Total Other DeductOIUGR_TOTAL_OTHER_DED_AMCURR8
.INCLUDE/PRA/LAST_CHANGED/PRA/LAST_CHANGED0
CHANGE_USERLast Changed ByOIUX3_LAST_CHANGED_USERCHAR24
CHANGE_TIMESTAMPLast Changed Timestamp/PRA/LAST_CHANGED_TZNTSTMPSDEC8
Privacy Policy