ROIUREP_XTRCT_ROY SAP (Extract structure before conversion) Structure details

Dictionary Type: Structure
Description: Extract structure before conversion




ABAP Code to SELECT data from ROIUREP_XTRCT_ROY
Related tables to ROIUREP_XTRCT_ROY
Access table ROIUREP_XTRCT_ROY




Structure field list including key, data, relationships and ABAP select examples

ROIUREP_XTRCT_ROY is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Extract structure before conversion" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_ROIUREP_XTRCT_ROY TYPE ROIUREP_XTRCT_ROY.

The ROIUREP_XTRCT_ROY table consists of various fields, each holding specific information or linking keys about Extract structure before conversion data available in SAP. These include YEAR_MONTH (Reporting Year and Month), AGENCY (Agency for Reporting), OIL_GAS_IND (Oil and Gas Indicator), GL_OR_LVL_1_NO (Company Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP ROIUREP_XTRCT_ROY structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
YEAR_MONTHReporting Year and Month OIUREP_RPT_YYYYMMNUMC6OIUREP_RPT_YYYYMM
AGENCYAgency for Reporting OIUREP_ROY_AGENCYCHAR3CHAR3OIUREP_AGENCYOIUREP_SH_ROY_AGY
OIL_GAS_INDOil and Gas Indicator OIUREP_OIL_GAS_INDCHAR1OIUREP_OIL_GAS_INDOIUREP_OIL_GAS_IND
GL_OR_LVL_1_NOCompany Code OIUREP_ORG_LEVEL1_NOCHAR3CHAR3OIUREP_COMP_CODE
OPSL_GL_SYS_NOOIUH_DEC18 OIUH_DEC18DEC18DEC18
GL_ACCT_PERD_DTAccounting Period Date OIUREP_ACCT_PERD_DTCHAR14CHAR14
GL_ACCT_NOGL Account No. OIUREP_GL_ACCT_NOCHAR10CHAR10
BTCH_TYPE_CODEBatch Type OIUREP_BTCH_TYPE_CODECHAR2CHAR2
GL_TRANS_AMGL Transaction Amount OIUREP_GL_TRANS_AMCURR11(2) OIUH_CURR11_2
GL_TRANS_QYGL Transaction Quantity OIUREP_GL_TRANS_QYDEC11(2) OIUH_DEC11_2
GL_GR_AMGL Gross Amount OIUREP_GL_GR_AMCURR11(2) OIUH_CURR11_2
GL_GR_QYGL Gross Quantity OIUREP_GL_GR_QYDEC11(2) OIUH_DEC11_2
GL_PD_CDGL Product Code OIUREP_GL_PD_CDCHAR3CHAR3
GL_VL_TYPE_CDGL Volume Type Code OIUREP_GL_VL_TYPE_CDCHAR2CHAR2
GL_PU_NOOIUH_CHAR6 OIUH_CHAR6CHAR6CHAR6
GL_PU_SEQ_NOOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
GL_CT_NOContract No. OIUREP_GL_CT_NOCHAR6CHAR6
GL_CT_TYPE_CDGL Contract Type Code OIUREP_GL_CT_TYPE_CDCHAR2CHAR2
GL_PR_NOProperty No. OIUREP_PROPERTY_NOCHAR8CHAR8
GL_DOI_NODivision of interest (DOI) OIU_DOI_NOCHAR5Assigned to domainALPHAOIU_DOI_NOOIU_DOIH_OIU_DO_DI
GL_WL_NOWell No. OIUREP_WL_NOCHAR6CHAR6
GL_WC_NOWell Completion No. OIUREP_WC_NOCHAR2CHAR2
GL_SA_MP_NOMeasurement Point No. OIUREP_MP_NOCHAR6CHAR6
GL_SA_DTGL Sales Date OIUREP_GL_SA_DTCHAR14CHAR14
GL_DN_NOOIUH_CHAR4 OIUH_CHAR4CHAR4CHAR4
GL_SUB_NWK_NOOIUH_CHAR4 OIUH_CHAR4CHAR4CHAR4
GL_CHV_RPT_CDGL Cost Center OIUREP_GL_CHV_RPT_CDCHAR10CHAR10
OPSL_BTU_QYOPSL BTU Quantity OIUREP_OPSL_BTU_QYDEC7(3) OIUH_DEC7_3
OPSL_PS_BASE_QYOPSL Pressure Base Quantity OIUREP_OPSL_PS_BASE_QYDEC6(3) OIUH_DEC6_3
OPSL_GRV_QYOIUH_DEC3_1 OIUH_DEC3_1DEC3(1) OIUH_DEC3_1
OPSL_OWN_NOOIUH_CHAR6 OIUH_CHAR6CHAR6CHAR6
OPSL_OWN_SEQ_NOOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
OPSL_PRDR_NOOPSL Producer No. OIUREP_OPSL_PRDR_NOCHAR6CHAR6
PSL_PRDR_SEQ_NOOPSL Producer Sequence No. OIUREP_PSL_PRDR_SEQ_NOCHAR2CHAR2
OWN_INT_DECM_QYOIUH_DEC9_8 OIUH_DEC9_8DEC9(8) OIUH_DEC9_8
OWN_INT_TYPE_CDOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
OWN_INT_SEQ_NOOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
PSL_RVRS_RSN_CDOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
UNIT_OF_MEAS_CDOIUH_CHAR3 OIUH_CHAR3CHAR3CHAR3
OPSL_SUS_RSN_CDOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
OPSL_ORIG_MP_NOMeasurement Point No. OIUREP_MP_NOCHAR6CHAR6
OPSL_DED_RMB_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
L_DED_GR_RMB_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
OPSL_TAX_RMB_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
L_TAX_GR_RMB_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
OPSL_PAY_CDOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
OPSL_ST_CDOPSL State Code OIUREP_OPSL_ST_CDCHAR2CHAR2
OWN_BAL_DECM_QYOIUH_DEC9_8 OIUH_DEC9_8DEC9(8) OIUH_DEC9_8
OPSL_UNIT_PR_NOProperty No. OIUREP_PROPERTY_NOCHAR8CHAR8
L_NET_TRANSP_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
L_NET_OTH_MK_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
SL_GR_TRANSP_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
SL_GR_OTH_MK_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
OPSL_AES_FLOIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
OPSL_TXN_VAL_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
OPSL_GR_PVR_AMOIUH_DEC11_2 OIUH_DEC11_2DEC11(2) OIUH_DEC11_2
OPSL_OWN_PVR_AMOIUH_DEC11_2 OIUH_DEC11_2DEC11(2) OIUH_DEC11_2
MMBTU_OWN_VL_AMOIUH_DEC11_2 OIUH_DEC11_2DEC11(2) OIUH_DEC11_2
PSL_SPC_PYMT_CDOIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
OPSL_LGND_CDOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
OPSL_ESCH_FLOIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
OPSL_CMT_SYS_NOOIUH_DEC18 OIUH_DEC18DEC18DEC18
PSL_INT_PAID_FLOIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
SL_OP_NON_OP_FLOIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
OTAX_TAX_AM1Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
OTAX_TAX_AM2Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
OTAX_TAX_AM3Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
OTAX_TAX_AM4Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
OTAX_TAX_AM5Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
OTAX_TAX_AM6Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
OTAX_TAX_AM7Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
OTAX_TAX_AM8Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
OTAX_TAX_AM9Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
OTAX_TAX_AM10Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
GTAX_TAX_AM1Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
GTAX_TAX_AM2Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
GTAX_TAX_AM3Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
GTAX_TAX_AM4Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
GTAX_TAX_AM5Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
GTAX_TAX_AM6Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
GTAX_TAX_AM7Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
GTAX_TAX_AM8Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
GTAX_TAX_AM9Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
GTAX_TAX_AM10Tax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM1Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM2Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM3Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM4Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM5Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM6Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM7Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM8Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM9Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM10Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM11Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM12Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM13Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM14Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM15Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM16Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM17Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ODED_DED_AM18Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
REJECT_FLAGReject flag OIUREP_REJECT_FLAGCHAR1OIUREP_REJECT_FLAG
GL_TIMESTAMPOIUH_CHAR14 OIUH_CHAR14CHAR14CHAR14
GL_SYS_SRCE_CDOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
OPSL_GR_PTR_AMOIUH_DEC11_2 OIUH_DEC11_2DEC11(2) OIUH_DEC11_2
OPSL_OWN_PTR_AMOIUH_DEC11_2 OIUH_DEC11_2DEC11(2) OIUH_DEC11_2
O_INT_1_AMOwner internal mkt amt 1 OIU_O_INT_1_AMCURR11(2) OIUH_CURR11_2
O_INT_2_AMOwner internal mkt amt 2 OIU_O_INT_2_AMCURR11(2) OIUH_CURR11_2
O_INT_3_AMOwner internal mkt amt 3 OIU_O_INT_3_AMCURR11(2) OIUH_CURR11_2
O_INT_4_AMOwner internal mkt amt 4 OIU_O_INT_4_AMCURR11(2) OIUH_CURR11_2
O_INT_5_AMOwner internal mkt amt 5 OIU_O_INT_5_AMCURR11(2) OIUH_CURR11_2
O_INT_6_AMOwner internal mkt amt 6 OIU_O_INT_6_AMCURR11(2) OIUH_CURR11_2
O_INT_7_AMOwner internal mkt amt 7 OIU_O_INT_7_AMCURR11(2) OIUH_CURR11_2
O_INT_8_AMOwner internal mkt amt 8 OIU_O_INT_8_AMCURR11(2) OIUH_CURR11_2
O_INT_9_AMOwner internal mkt amt 9 OIU_O_INT_9_AMCURR11(2) OIUH_CURR11_2
O_INT_10_AMOwner internal mkt amt10 OIU_O_INT_10_AMCURR11(2) OIUH_CURR11_2
O_EXT_1_AMOwner external mkt amt 1 OIU_O_EXT_1_AMCURR11(2) OIUH_CURR11_2
O_EXT_2_AMOwner external mkt amt 2 OIU_O_EXT_2_AMCURR11(2) OIUH_CURR11_2
O_EXT_3_AMOwner external mkt amt 3 OIU_O_EXT_3_AMCURR11(2) OIUH_CURR11_2
O_EXT_4_AMOwner external mkt amt 4 OIU_O_EXT_4_AMCURR11(2) OIUH_CURR11_2
O_EXT_5_AMOwner external mkt amt 5 OIU_O_EXT_5_AMCURR11(2) OIUH_CURR11_2
O_EXT_6_AMOwner external mkt amt 6 OIU_O_EXT_6_AMCURR11(2) OIUH_CURR11_2
O_EXT_7_AMOwner external mkt amt 7 OIU_O_EXT_7_AMCURR11(2) OIUH_CURR11_2
O_EXT_8_AMOwner external mkt amt 8 OIU_O_EXT_8_AMCURR11(2) OIUH_CURR11_2
O_EXT_9_AMOwner external mkt amt 9 OIU_O_EXT_9_AMCURR11(2) OIUH_CURR11_2
O_EXT_10_AMOwner external mkt amt10 OIU_O_EXT_10_AMCURR11(2) OIUH_CURR11_2
G_INT_1_AMGross internal mkt amt 1 OIU_G_INT_1_AMCURR11(2) OIUH_CURR11_2
G_INT_2_AMGross internal mkt amt 2 OIU_G_INT_2_AMCURR11(2) OIUH_CURR11_2
G_INT_3_AMGross internal mkt amt 3 OIU_G_INT_3_AMCURR11(2) OIUH_CURR11_2
G_INT_4_AMGross internal mkt amt 4 OIU_G_INT_4_AMCURR11(2) OIUH_CURR11_2
G_INT_5_AMGross internal mkt amt 5 OIU_G_INT_5_AMCURR11(2) OIUH_CURR11_2
G_INT_6_AMGross internal mkt amt 6 OIU_G_INT_6_AMCURR11(2) OIUH_CURR11_2
G_INT_7_AMGross internal mkt amt 7 OIU_G_INT_7_AMCURR11(2) OIUH_CURR11_2
G_INT_8_AMGross internal mkt amt 8 OIU_G_INT_8_AMCURR11(2) OIUH_CURR11_2
G_INT_9_AMGross internal mkt amt 9 OIU_G_INT_9_AMCURR11(2) OIUH_CURR11_2
G_INT_10_AMGross internal mkt amt10 OIU_G_INT_10_AMCURR11(2) OIUH_CURR11_2
G_EXT_1_AMGross external mkt amt 1 OIU_G_EXT_1_AMCURR11(2) OIUH_CURR11_2
G_EXT_2_AMGross external mkt amt 2 OIU_G_EXT_2_AMCURR11(2) OIUH_CURR11_2
G_EXT_3_AMGross external mkt amt 3 OIU_G_EXT_3_AMCURR11(2) OIUH_CURR11_2
G_EXT_4_AMGross external mkt amt 4 OIU_G_EXT_4_AMCURR11(2) OIUH_CURR11_2
G_EXT_5_AMGross external mkt amt 5 OIU_G_EXT_5_AMCURR11(2) OIUH_CURR11_2
G_EXT_6_AMGross external mkt amt 6 OIU_G_EXT_6_AMCURR11(2) OIUH_CURR11_2
G_EXT_7_AMGross external mkt amt 7 OIU_G_EXT_7_AMCURR11(2) OIUH_CURR11_2
G_EXT_8_AMGross external mkt amt 8 OIU_G_EXT_8_AMCURR11(2) OIUH_CURR11_2
G_EXT_9_AMGross external mkt amt 9 OIU_G_EXT_9_AMCURR11(2) OIUH_CURR11_2
G_EXT_10_AMGross external mkt amt 10 OIU_G_EXT_10_AMCURR11(2) OIUH_CURR11_2

Key field Non-key field



How do I retrieve data from SAP structure ROIUREP_XTRCT_ROY using ABAP code?

As ROIUREP_XTRCT_ROY is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ROIUREP_XTRCT_ROY as there is no data to select.

How to access SAP table ROIUREP_XTRCT_ROY

Within an ECC or HANA version of SAP you can also view further information about ROIUREP_XTRCT_ROY and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!