OIUREP_ROY_AGY SAP (Reporting Agencies for Tax and Royalty) Table details

Dictionary Type: Table
Description: Reporting Agencies for Tax and Royalty




ABAP Code to SELECT data from OIUREP_ROY_AGY
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 areas
Display/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
AGENCYAgency for Reporting OIUREP_ROY_AGENCYCHAR3CHAR3OIUREP_AGENCYOIUREP_SH_ROY_AGY
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
STATEPrimary geographical location (PRI geo. loc.) OIU_PRI_GEO_LOCCHAR2Assigned to domainOIU_PRI_GEO_LOCOIU_PRI_GEO_LOC
VOL_EXTRACTFalg to indicate if volume extract is required OIUREP_VOL_XTRCTCHAR1OIUREP_VOL_XTRCT
AMND_CONCEPTFlag to indicate if the new amended concept is applicable OIUREP_AMND_CONCEPTCHAR1CHAR1
GRAVITY_FLAGGravity applicable flag OIUREP_GRAVITY_FLAGCHAR1CHAR1
ZERO_VOL_RPTReporting for Zero Volume OIUREP_ZERO_VOL_FLAGCHAR1OIUREP_ZERO_VOL_FLAG
TAX_ROY_INDReport Type (Tax or Royalty) OIUREP_REPORT_TYPECHAR1OIUREP_REPORT_TYPE
STRUCT_LNKStructure with parameters at PUID and RE link level OIUX1_LNK_STRUCHAR30OBJECTNAME
STRUCT_REStructure with parameters at RE level OIUX1_RE_STRUCHAR30OBJECTNAME
STRUCT_PUIDStructure with parameters at PUID level OIUX1_PUID_STRUCHAR30OBJECTNAME
STRUCT_RSGStructure with parameters at RSG level OIUX1_RSG_STRUCHAR30OBJECTNAME
STRUCT_RPTStructure with parameters at RPT level OIUX1_RPT_STRUCHAR30OBJECTNAME
TABLE_LNKTable with parameters at LNK level OIUX1_LNK_TABCHAR30OBJECTNAME
TABLE_RETable with parameters at RE level OIUX1_RE_TABCHAR30OBJECTNAME
TABLE_PUIDTable with parameters at PUID level OIUX1_PUID_TABCHAR30OBJECTNAME
TABLE_RSGTable with parameters at RSG level OIUX1_RSG_TABCHAR30OBJECTNAME
TABLE_RPTTable with parameters at RPT level OIUX1_RPT_TABCHAR30OBJECTNAME
REF_AGENCYReference Agency for Volume Data OIUX1_REF_AGENCYCHAR3CHAR3OIUREP_AGENCYOIUX1_SH_TAX_AGY
FREQUENCYReporting Frequency OIUREP_FREQUENCYCHAR1OIUREP_FREQUENCY
GENERICGeneric Flag OIUX1_GENERICCHAR1CHAR1
PROC_INDProcessing indicator to indicate the tax types allowed OIUX1_PROC_INDCHAR1OIUX1_PROC_IND
VARKEY_RULERule for the variable key in tax reporting OIUX1_VARKEY_RULECHAR1OIUX1_VARKEY_RULE
UPLOAD_LEVELUpload level flag OIUREP_UPLOAD_FLCHAR1UPLOAD_LEVEL_FL
BLPS_AS_GROSSUse wet-less-residue volume as gross volume for NGL OIUX2_WLR_AS_GROSSCHAR1OIUX2_WLR_AS_GROSS
WLR_AS_GROSSUse wet-less-residue volume as gross volume for NGL OIUX2_WLR_AS_GROSSCHAR1OIUX2_WLR_AS_GROSS
SPECIAL_LOGICGeneral Flag FLAGCHAR1FLAG

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 table
DATA: 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 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!