OIUGR_ROYSTG - Gen Rep - Royalty Transaction (Staging)
Gen Rep - Royalty Transaction (Staging) information is stored in SAP table OIUGR_ROYSTG.
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".
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_ROYSTG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| ROYTXN_GUID | 16-byte UID in 32 chars (hexadecimal) | X | SYSUUID_C32 | CHAR | 64 | |
| .INCLUDE | ROIUGR_ROYTXN_KEY | ROIUGR_ROYTXN_KEY | 0 | |||
| .INCLUDE | ROIUGR_REVTXN_KEY | ROIUGR_REVTXN_KEY | 0 | |||
| PROC_ID | Proc 2.0 - Process ID | OIUE2_PROCESS_ID | CHAR | 20 | OIUGR_PROC_ID | |
| BUKRS | Company Code | BUKRS | CHAR | 8 | OIU_CM_COMPC | |
| SALES_DT | Sales Date / Month | OIU_SALE_DT | DATS | 16 | ||
| PDCD | Full three char. product code (Major and Detail Products) | OIU_FULL_PD_CD | CHAR | 6 | OIUX3_PDCD | |
| WL_NO | Well ID number | OIU_WL_NO | CHAR | 30 | OIU_PR_WELL | |
| WC_NO | Well Completion Number | OIU_WC_NO | CHAR | 10 | OIU_PR_WC | |
| MP_NO | Measurement point number | OIU_MP_NO | CHAR | 40 | OIU_PR_MP | |
| VNAME | Joint venture | JV_NAME | CHAR | 12 | OIU_DO_JV | |
| DOI_NO | Division of interest (DOI) | OIU_DOI_NO | CHAR | 10 | OIU_DO_DI | |
| DN_NO | Delivery network number | OIU_DN_NO | CHAR | 40 | OIU_PR_DN | |
| CT_NO | Contract Number | OIU_CT_NO | CHAR | 20 | OIU_RV_CT | |
| VL_TYPE_CD | Volume type code | OIU_VT_CD | CHAR | 4 | OIU_PR_VLTYP | |
| OWN_NO | PRA owner | OIU_OWN_NO | CHAR | 20 | LFA1 | |
| OWN_INT_TYPE_CD | Participant Interest Type | OIU_PART_INT_TYPE | CHAR | 4 | OIU_CM_PINTTY | |
| OWN_ISQ_NO | Owner Interest Sequence Number | OIU_OWN_ISQ_NO | CHAR | 4 | ||
| KOSTL | Cost Center | KOSTL | CHAR | 20 | * | |
| REV_BOOK_ADJ_IND | Reversal/Booking/Adjustment | OIUX3_REVERSE_BOOKING_ADJ_IND | CHAR | 2 | ||
| .INCLUDE | ROIUGR_ROYTXN_NONKEY | ROIUGR_ROYTXN_NONKEY | 0 | |||
| UNIT_VNAME | Unit venture | /PRA/UNIT_JV | CHAR | 12 | OIU_DO_JV | |
| OPERATED_FL | Operated flag | OIU_OPERATOR_FL | CHAR | 2 | ||
| LAND1 | Country/Region Key | LAND1 | CHAR | 6 | T005 | |
| REGIO | Region (State, Province, County) | REGIO | CHAR | 6 | T005S | |
| PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | OIU_PRI_GEO_LOC | CHAR | 4 | OIU_CM_LXPGL | |
| COUNC | County Code | COUNC | CHAR | 6 | T005E | |
| SAKNR | G/L Account Number | SAKNR | CHAR | 20 | SKB1 | |
| ENTY_CD | Entity Code | OIU_ENTY_CD | CHAR | 4 | ||
| PAY_CD | Pay Code | OIU_PAY_CD | CHAR | 4 | ||
| WAERS | Currency Key | WAERS | CUKY | 10 | TCURC | |
| VOL_UOM | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| ENERGY_UOM | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| HEAT_VAL_UOM | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| PRES_UOM | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| HEAT_VAL | Heating value | OIU_HEAT_VAL | QUAN | 7 | ||
| PS_BASE_QY | Pressure Base | OIU_PS_BASE | QUAN | 7 | ||
| GRAVITY | Gen Rep - Oil/gas density at standard/base conditions | OIUGR_GRAVITY | FLTP | 8 | ||
| DISB_DECIMAL | Disbursement Decimal | /PRA/DISB_DECM | DEC | 5 | ||
| NRI_DECIMAL | Net Revenue Interest Percent | OIU_NRI_PC | DEC | 5 | ||
| DOC_NO | Val. document number | OIURV_DOCNR | CHAR | 40 | * | |
| DOC_YEAR | Document year | OIU_DOC_YEAR | NUMC | 8 | ||
| OPTION1 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
| OPTION2 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
| OPTION3 | Single-Character Flag | CHAR1 | CHAR | 2 | ||
| INTERFACE_FL | General Flag | FLAG | CHAR | 2 | ||
| OOS_FL | General Flag | FLAG | CHAR | 2 | ||
| .INCLUDE | ROIUGR_ROYTXN_NONKEY_NUMERIC | ROIUGR_ROYTXN_NONKEY_NUMERIC | 0 | |||
| GROSS_VOL | Total Gross Volume | /PRA/GROSS_VOL | QUAN | 7 | ||
| GROSS_ENERGY | Gross Energy | /PRA/GROSS_ENERGY | QUAN | 7 | ||
| GROSS_PVR | Gross PVR | /PRA/GROSS_PVR | QUAN | 7 | ||
| GROSS_PTR | Gross PTR | /PRA/GROSS_PTR | QUAN | 7 | ||
| NET_VOL | Owner Net Volume | /PRA/NET_VOL | QUAN | 7 | ||
| OWNER_ENERGY | Owner Energy | /PRA/OWNER_ENERGY | QUAN | 7 | ||
| OWN_PVR | Owner PVR | /PRA/OWN_PVR | QUAN | 7 | ||
| OWN_PTR | Owner PTR | /PRA/OWN_PTR | QUAN | 7 | ||
| GROSS_VAL | Gross value | /PRA/GROSS_VAL | CURR | 7 | ||
| NET_VAL | Owner Net Value | /PRA/NET_VAL | CURR | 7 | ||
| OWNER_GROSS_VAL | Owner Gross Value | /PRA/OWN_GROSS_VAL | CURR | 7 | ||
| .INCLUDE | ROIUGR_ROYTXN_NONKEY_DERIVED | ROIUGR_ROYTXN_NONKEY_DERIVED | 0 | |||
| PROF_LINK_GUID | 16-byte UID in 32 chars (hexadecimal) | SYSUUID_C32 | CHAR | 64 | ||
| ADDRNUMBER | Address Number | AD_ADDRNUM | CHAR | 20 | * | |
| MASTER_LEVEL | Texas Master Data Level | OIUX3_TX_MASTER_LEVEL | CHAR | 2 | ||
| MASTER_LINK_GUID | 16-byte UID in 32 chars (hexadecimal) | SYSUUID_C32 | CHAR | 64 | ||
| PRODUCT_CODE | Gen Rep - Agency Product Code | OIUGR_PRODUCT_CODE | CHAR | 10 | ||
| REFERENCE_RUN_ID | Proc 2.0 - Run ID | OIUE2_RUN_ID | NUMC | 20 | ||
| .INCLUDE | ROIUGR_ROYTXN_NONKEY_CALC | ROIUGR_ROYTXN_NONKEY_CALC | 0 | |||
| TOT_GROSS_MKT_AM | Gen Rep - Total Gross Marketing | OIUGR_TOTAL_GROSS_MKT_AM | CURR | 8 | ||
| TOT_GROSS_RMB_AM | Gen Rep - Total Gross Marketing Reimbursement | OIUGR_TOTAL_GROSS_RMB_AM | CURR | 8 | ||
| TOT_GROSS_TAX_AM | Gen Rep - Total Gross Tax | OIUGR_TOTAL_GROSS_TAX_AM | CURR | 8 | ||
| TOT_GROSS_TX_RMB | Gen Rep - Total Gross Tax Reimbursement | OIUGR_TOTAL_GROSS_TX_RMB | CURR | 8 | ||
| TOT_OWNER_MKT_AM | Gen Rep - Total Owner Marketing | OIUGR_TOTAL_OWNER_MKT_AM | CURR | 8 | ||
| TOT_OWNER_RMB_AM | Gen Rep - Total Owner Marketing Reimbursement | OIUGR_TOTAL_OWNER_RMB_AM | CURR | 8 | ||
| TOT_OWNER_TAX_AM | Gen Rep - Total Owner Tax | OIUGR_TOTAL_OWNER_TAX_AM | CURR | 8 | ||
| TOT_OWNER_TX_RMB | Gen Rep - Total Owner Tax Reimbursement | OIUGR_TOTAL_OWNER_TX_RMB | CURR | 8 | ||
| TOT_OTHER_DED_AM | Gen Rep - Total Other Deduct | OIUGR_TOTAL_OTHER_DED_AM | CURR | 8 | ||
| .INCLUDE | ROIUGR_REJECT_SUSPEND | ROIUGR_REJECT_SUSPEND | 0 | |||
| REJ_SUSP_IND | Rejection-Suspension Status | OIUX3_REJECT_SUSPEND_IND | CHAR | 2 | ||
| REJ_CD | Gen Rep - Reject Code | OIUGR_REJECT_CODE | CHAR | 4 | OIUGR_REJ_CD | |
| .INCLUDE | /PRA/LAST_CHANGED | /PRA/LAST_CHANGED | 0 | |||
| CHANGE_USER | Last Changed By | OIUX3_LAST_CHANGED_USER | CHAR | 24 | ||
| CHANGE_TIMESTAMP | Last Changed Timestamp | /PRA/LAST_CHANGED_TZNTSTMPS | DEC | 8 |