OIUREP_XTRCT_ROY is a SAP table coming under IS module and IS-OIL component.View details, Fields & related tables of OIUREP_XTRCT_ROY in SAP.
- Table description : Extract Royaty Data for the current reporting period
- Module : IS-OIL-PRA-REP-ROY
- Parent Module : IS
- Package : OIU_REP
- Software Component : IS-OIL
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP OIUREP_XTRCT_ROY Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
YEAR_MONTH | Reporting Year and Month | OIUREP_RPT_YYYYMM | OIUREP_RPT_YYYYMM |
AGENCY | Agency for Reporting | OIUREP_ROY_AGENCY | CHAR3 |
OIL_GAS_IND | Oil and Gas Indicator | OIUREP_OIL_GAS_IND | OIUREP_OIL_GAS_IND |
GL_OR_LVL_1_NO | Company Code | BUKRS | BUKRS |
OPSL_GL_SYS_NO | OIUH_NUMC18 | OIUH_NUMC18 | OIUH_NUMC18 |
GL_ACCT_PERD_DT | Accounting Period Date | OIUREP_ACCT_PERD_DT | CHAR14 |
GL_ACCT_NO | GL Account No. | OIUREP_GL_ACCT_NO | CHAR10 |
BTCH_TYPE_CODE | Batch Type | OIUREP_BTCH_TYPE_CODE | CHAR2 |
GL_TRANS_AM | GL Transaction Amount | OIUREP_GL_TRANS_AM | OIUH_CURR11_2 |
GL_TRANS_QY | GL Transaction Quantity | OIUREP_GL_TRANS_QY | OIUH_DEC11_2 |
GL_GR_AM | GL Gross Amount | OIUREP_GL_GR_AM | OIUH_CURR11_2 |
GL_GR_QY | GL Gross Quantity | OIUREP_GL_GR_QY | OIUH_DEC11_2 |
GL_PD_CD | Material Number | MATNR | MATNR |
GL_VL_TYPE_CD | GL Volume Type Code | OIUREP_GL_VL_TYPE_CD | CHAR2 |
GL_PU_NO | OIUH_CHAR6 | OIUH_CHAR6 | CHAR6 |
GL_PU_SEQ_NO | OIUH_CHAR2 | OIUH_CHAR2 | CHAR2 |
GL_CT_NO | Contract No. | OIUREP_GL_CT_NO | CHAR6 |
GL_CT_TYPE_CD | GL Contract Type Code | OIUREP_GL_CT_TYPE_CD | CHAR2 |
GL_PR_NO | Joint venture | JV_NAME | JV_NAME |
GL_DOI_NO | Division of interest (DOI) | OIU_DOI_NO | OIU_DOI_NO |
GL_WL_NO | Well ID number | OIU_WL_NO | OIU_WL_NO |
GL_WC_NO | Well Completion Number | OIU_WC_NO | OIU_WC_NO |
GL_SA_MP_NO | Measurement point number | OIU_MP_NO | OIU_MP_NO |
GL_SA_DT | GL Sales Date | OIUREP_GL_SA_DT | CHAR14 |
GL_DN_NO | OIUH_CHAR4 | OIUH_CHAR4 | CHAR4 |
GL_SUB_NWK_NO | OIUH_CHAR4 | OIUH_CHAR4 | CHAR4 |
GL_CHV_RPT_CD | GL Cost Center | OIUREP_GL_CHV_RPT_CD | CHAR10 |
OPSL_BTU_QY | OPSL BTU Quantity | OIUREP_OPSL_BTU_QY | OIUH_DEC7_3 |
OPSL_PS_BASE_QY | OPSL Pressure Base Quantity | OIUREP_OPSL_PS_BASE_QY | OIUH_DEC6_3 |
OPSL_GRV_QY | Gravity Quantity | OIUREP_GRV_QY_NUMC4 | NUMC4 |
OPSL_OWN_NO | Master Record | OIUCM_MASTER | OIUCM_MASTER |
OPSL_PRDR_NO | OPSL Producer No. | OIUREP_OPSL_PRDR_NO | CHAR6 |
PSL_PRDR_SEQ_NO | OPSL Producer Sequence No. | OIUREP_PSL_PRDR_SEQ_NO | CHAR2 |
OWN_INT_DECM_QY | OIUH_DEC9_8 | OIUH_DEC9_8 | OIUH_DEC9_8 |
OWN_INT_TYPE_CD | OIUH_CHAR2 | OIUH_CHAR2 | CHAR2 |
OWN_INT_SEQ_NO | OIUH_CHAR2 | OIUH_CHAR2 | CHAR2 |
PSL_RVRS_RSN_CD | OIUH_CHAR2 | OIUH_CHAR2 | CHAR2 |
UNIT_OF_MEAS_CD | OIUH_CHAR3 | OIUH_CHAR3 | CHAR3 |
OPSL_SUS_RSN_CD | OIUH_CHAR2 | OIUH_CHAR2 | CHAR2 |
OPSL_ORIG_MP_NO | Measurement point number | OIU_MP_NO | OIU_MP_NO |
OPSL_DED_RMB_AM | Local amount | OIUH_CURR11_2 | OIUH_CURR11_2 |
L_DED_GR_RMB_AM | Local amount | OIUH_CURR11_2 | OIUH_CURR11_2 |
OPSL_TAX_RMB_AM | Local amount | OIUH_CURR11_2 | OIUH_CURR11_2 |
L_TAX_GR_RMB_AM | Local amount | OIUH_CURR11_2 | OIUH_CURR11_2 |
OPSL_PAY_CD | OIUH_CHAR2 | OIUH_CHAR2 | CHAR2 |
OPSL_ST_CD | OPSL State Code | OIUREP_OPSL_ST_CD | CHAR2 |
OWN_BAL_DECM_QY | OIUH_DEC9_8 | OIUH_DEC9_8 | OIUH_DEC9_8 |
OPSL_UNIT_PR_NO | Joint venture | JV_NAME | JV_NAME |
L_NET_TRANSP_AM | Local amount | OIUH_CURR11_2 | OIUH_CURR11_2 |
L_NET_OTH_MK_AM | Local amount | OIUH_CURR11_2 | OIUH_CURR11_2 |
SL_GR_TRANSP_AM | Local amount | OIUH_CURR11_2 | OIUH_CURR11_2 |
SL_GR_OTH_MK_AM | Local amount | OIUH_CURR11_2 | OIUH_CURR11_2 |
OPSL_AES_FL | OIUH_CHAR1 | OIUH_CHAR1 | CHAR1 |
OPSL_TXN_VAL_AM | Local amount | OIUH_CURR11_2 | OIUH_CURR11_2 |
OPSL_GR_PVR_AM | OIUH_DEC11_2 | OIUH_DEC11_2 | OIUH_DEC11_2 |
OPSL_OWN_PVR_AM | OIUH_DEC11_2 | OIUH_DEC11_2 | OIUH_DEC11_2 |
MMBTU_OWN_VL_AM | OIUH_DEC11_2 | OIUH_DEC11_2 | OIUH_DEC11_2 |
PSL_SPC_PYMT_CD | OIUH_CHAR1 | OIUH_CHAR1 | CHAR1 |
OPSL_LGND_CD | OIUH_CHAR2 | OIUH_CHAR2 | CHAR2 |
OPSL_ESCH_FL | OIUH_CHAR1 | OIUH_CHAR1 | CHAR1 |
OPSL_CMT_SYS_NO | OIUH_DEC18 | OIUH_DEC18 | DEC18 |
PSL_INT_PAID_FL | OIUH_CHAR1 | OIUH_CHAR1 | CHAR1 |
SL_OP_NON_OP_FL | OIUH_CHAR1 | OIUH_CHAR1 | CHAR1 |
OTAX_TAX_AM1 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
OTAX_TAX_AM2 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
OTAX_TAX_AM3 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
OTAX_TAX_AM4 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
OTAX_TAX_AM5 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
OTAX_TAX_AM6 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
OTAX_TAX_AM7 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
OTAX_TAX_AM8 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
OTAX_TAX_AM9 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
OTAX_TAX_AM10 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
GTAX_TAX_AM1 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
GTAX_TAX_AM2 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
GTAX_TAX_AM3 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
GTAX_TAX_AM4 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
GTAX_TAX_AM5 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
GTAX_TAX_AM6 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
GTAX_TAX_AM7 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
GTAX_TAX_AM8 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
GTAX_TAX_AM9 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
GTAX_TAX_AM10 | Tax Amount | OIUREP_TAX_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM1 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM2 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM3 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM4 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM5 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM6 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM7 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM8 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM9 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM10 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM11 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM12 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM13 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM14 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM15 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM16 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM17 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
ODED_DED_AM18 | Deduction Amount | OIUREP_DED_AMOUNT | OIUH_CURR11_2 |
REJECT_FLAG | Reject flag | OIUREP_REJECT_FLAG | OIUREP_REJECT_FLAG |
GL_TIMESTAMP | OIUH_CHAR14 | OIUH_CHAR14 | CHAR14 |
OIUREP_XTRCT_ROY related tables
Table | Note |
---|---|
OIUREP_XTRCT_ROY | Extract Royaty Data for the current reporting period |
COAT_E_TY_T | COAT: Extract Text Table to Extract Types |
P05TPRNL_C_SEQNO | Pension Return: Current sequence number per period |
TE655 | Category of the current billing period |
TE655T | Category of the current billing period |
DRP_SMTC_DEVCL | DEV Reporting (SE28): Control Table for Current Run |
DFKKGP_SHORT | Data Extract: BP Data |
FKK_GPSHAD | Data Extract: Business Partner Data (Faster Access) |
BKK42 | Current Account Master Data: Operative Data |
AMATR | Global Performance Analysis: Extract Data (Attribute View) |
AMATRT | Global Performance Analysis: Extract Data Attribut Texts |
CNVMBTDEXACTIONS | DMIS PCL Data Extract Action history |
CNVMBTDEXCVERS | DMIS PCL Data Extract - source system information from CVE |
CNVMBTDEXDEFAULT | DMIS PCL Data Extract - Default values for system |
CNVMBTDEXFILES | DMIS PCL Data Extract Files |
Get current payroll period TablesHow to check current payroll period TablesFiscal year of current period TablesHow to extract data from sap TablesHow to extract data from sap ecc TablesHow to extract all customer master data TablesHow to extract customer master data TablesPeriod indicator (day, week, month, posting period) Tables
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP