OIUREP_ROY_AGY SAP (Reporting Agencies for Tax and Royalty) Table details
Description: Reporting Agencies for Tax and Royalty
Related tables to OIUREP_ROY_AGY
Access table OIUREP_ROY_AGY
Table field list including key, data, relationships and ABAP select examples
OIUREP_ROY_AGY is a standard SAP Table which is used to store Reporting Agencies for Tax and Royalty data and is available within R/3 SAP systems depending on the version and release level.
The OIUREP_ROY_AGY table consists of various fields, each holding specific information or linking keys about Reporting Agencies for Tax and Royalty data available in SAP. These include COUNTRY (Country Key), STATE (Primary geographical location (PRI geo. loc.)), VOL_EXTRACT (Falg to indicate if volume extract is required), AMND_CONCEPT (Flag to indicate if the new amended concept is applicable).. 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: E - Control table, SAP and customer have separate key areasDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
Text table = OIUREP_ROY_AGYTX
SAP OIUREP_ROY_AGY table 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 |
AGENCY | Agency for Reporting | OIUREP_ROY_AGENCY | CHAR | 3 | CHAR3 | OIUREP_AGENCY | OIUREP_SH_ROY_AGY | ||
COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
STATE | Primary geographical location (PRI geo. loc.) | OIU_PRI_GEO_LOC | CHAR | 2 | Assigned to domain | OIU_PRI_GEO_LOC | OIU_PRI_GEO_LOC | ||
VOL_EXTRACT | Falg to indicate if volume extract is required | OIUREP_VOL_XTRCT | CHAR | 1 | OIUREP_VOL_XTRCT | ||||
AMND_CONCEPT | Flag to indicate if the new amended concept is applicable | OIUREP_AMND_CONCEPT | CHAR | 1 | CHAR1 | ||||
GRAVITY_FLAG | Gravity applicable flag | OIUREP_GRAVITY_FLAG | CHAR | 1 | CHAR1 | ||||
ZERO_VOL_RPT | Reporting for Zero Volume | OIUREP_ZERO_VOL_FLAG | CHAR | 1 | OIUREP_ZERO_VOL_FLAG | ||||
TAX_ROY_IND | Report Type (Tax or Royalty) | OIUREP_REPORT_TYPE | CHAR | 1 | OIUREP_REPORT_TYPE | ||||
STRUCT_LNK | Structure with parameters at PUID and RE link level | OIUX1_LNK_STRU | CHAR | 30 | OBJECTNAME | ||||
STRUCT_RE | Structure with parameters at RE level | OIUX1_RE_STRU | CHAR | 30 | OBJECTNAME | ||||
STRUCT_PUID | Structure with parameters at PUID level | OIUX1_PUID_STRU | CHAR | 30 | OBJECTNAME | ||||
STRUCT_RSG | Structure with parameters at RSG level | OIUX1_RSG_STRU | CHAR | 30 | OBJECTNAME | ||||
STRUCT_RPT | Structure with parameters at RPT level | OIUX1_RPT_STRU | CHAR | 30 | OBJECTNAME | ||||
TABLE_LNK | Table with parameters at LNK level | OIUX1_LNK_TAB | CHAR | 30 | OBJECTNAME | ||||
TABLE_RE | Table with parameters at RE level | OIUX1_RE_TAB | CHAR | 30 | OBJECTNAME | ||||
TABLE_PUID | Table with parameters at PUID level | OIUX1_PUID_TAB | CHAR | 30 | OBJECTNAME | ||||
TABLE_RSG | Table with parameters at RSG level | OIUX1_RSG_TAB | CHAR | 30 | OBJECTNAME | ||||
TABLE_RPT | Table with parameters at RPT level | OIUX1_RPT_TAB | CHAR | 30 | OBJECTNAME | ||||
REF_AGENCY | Reference Agency for Volume Data | OIUX1_REF_AGENCY | CHAR | 3 | CHAR3 | OIUREP_AGENCY | OIUX1_SH_TAX_AGY | ||
FREQUENCY | Reporting Frequency | OIUREP_FREQUENCY | CHAR | 1 | OIUREP_FREQUENCY | ||||
GENERIC | Generic Flag | OIUX1_GENERIC | CHAR | 1 | CHAR1 | ||||
PROC_IND | Processing indicator to indicate the tax types allowed | OIUX1_PROC_IND | CHAR | 1 | OIUX1_PROC_IND | ||||
VARKEY_RULE | Rule for the variable key in tax reporting | OIUX1_VARKEY_RULE | CHAR | 1 | OIUX1_VARKEY_RULE | ||||
UPLOAD_LEVEL | Upload level flag | OIUREP_UPLOAD_FL | CHAR | 1 | UPLOAD_LEVEL_FL | ||||
BLPS_AS_GROSS | Use wet-less-residue volume as gross volume for NGL | OIUX2_WLR_AS_GROSS | CHAR | 1 | OIUX2_WLR_AS_GROSS | ||||
WLR_AS_GROSS | Use wet-less-residue volume as gross volume for NGL | OIUX2_WLR_AS_GROSS | CHAR | 1 | OIUX2_WLR_AS_GROSS | ||||
SPECIAL_LOGIC | General Flag | FLAG | CHAR | 1 | FLAG |
Key field | Non-key field |
How do I retrieve data from SAP table OIUREP_ROY_AGY using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIUREP_ROY_AGY to SELECT all data from the tableDATA: WA_OIUREP_ROY_AGY TYPE OIUREP_ROY_AGY.
SELECT SINGLE *
FROM OIUREP_ROY_AGY
INTO CORRESPONDING FIELDS OF WA_OIUREP_ROY_AGY
WHERE...
How to access SAP table OIUREP_ROY_AGY
Within an ECC or HANA version of SAP you can also view further information about OIUREP_ROY_AGY and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects