1. Home
  2. Resources
  3. SAP Tables
  4. OIUREP_ROY_AGY - Reporting Agencies for Tax and Royalty

SAP Table OIUREP_ROY_AGY

Reporting Agencies for Tax and Royalty

OIUREP_ROY_AGY (Reporting Agencies for Tax and Royalty) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIUREP_ROY_AGY to other SAP tables.

OIUREP_ROY_AGY table fields

Field Data element Checktable Datatype Length Decimals
AGENCY Agency for Reporting OIUREP_ROY_AGENCY CHAR 3 0
COUNTRY Country Key LAND1 CHAR 3 0
STATE Primary geographical location (PRI geo. loc.) OIU_PRI_GEO_LOC CHAR 2 0
VOL_EXTRACT Falg to indicate if volume extract is required OIUREP_VOL_XTRCT CHAR 1 0
Y Required
N Not required
AMND_CONCEPT Flag to indicate if the new amended concept is applicable OIUREP_AMND_CONCEPT CHAR 1 0
GRAVITY_FLAG Gravity applicable flag OIUREP_GRAVITY_FLAG CHAR 1 0
ZERO_VOL_RPT Reporting for Zero Volume OIUREP_ZERO_VOL_FLAG CHAR 1 0
Y Reporting Required
N No Reporting Required
TAX_ROY_IND Report Type (Tax or Royalty) OIUREP_REPORT_TYPE CHAR 1 0
T Tax Reporting
R Royalty Reporting
STRUCT_LNK Structure with parameters at PUID and RE link level OIUX1_LNK_STRU CHAR 30 0
STRUCT_RE Structure with parameters at RE level OIUX1_RE_STRU CHAR 30 0
STRUCT_PUID Structure with parameters at PUID level OIUX1_PUID_STRU CHAR 30 0
STRUCT_RSG Structure with parameters at RSG level OIUX1_RSG_STRU CHAR 30 0
STRUCT_RPT Structure with parameters at RPT level OIUX1_RPT_STRU CHAR 30 0
TABLE_LNK Table with parameters at LNK level OIUX1_LNK_TAB CHAR 30 0
TABLE_RE Table with parameters at RE level OIUX1_RE_TAB CHAR 30 0
TABLE_PUID Table with parameters at PUID level OIUX1_PUID_TAB CHAR 30 0
TABLE_RSG Table with parameters at RSG level OIUX1_RSG_TAB CHAR 30 0
TABLE_RPT Table with parameters at RPT level OIUX1_RPT_TAB CHAR 30 0
REF_AGENCY Reference Agency for Volume Data OIUX1_REF_AGENCY CHAR 3 0
FREQUENCY Reporting Frequency OIUREP_FREQUENCY CHAR 1 0
W Weekly
F Fortnighly
M Monthly
B Bi-monthly
Q Quarterly
S Semi-annually
A Annually
GENERIC Generic Flag OIUX1_GENERIC CHAR 1 0
PROC_IND Processing indicator to indicate the tax types allowed OIUX1_PROC_IND CHAR 1 0
NULL Single tax type
M Multiple tax types with no tier
T Multiple tax types with tier
VARKEY_RULE Rule for the variable key in tax reporting OIUX1_VARKEY_RULE CHAR 1 0
NULL Default
R Reporting Company for Producer and Purchaser
D Reporting Company for Producer for all cases
A '01' if pruchaser/producer is affiliated, '00' otherwise
UPLOAD_LEVEL Upload level flag OIUREP_UPLOAD_FL CHAR 1 0
L Lease Level
E Entity Level
BLPS_AS_GROSS Use wet-less-residue volume as gross volume for NGL OIUX2_WLR_AS_GROSS CHAR 1 0
NULL Use gross volume
X Use wet-less-residue volume as gross volume for NGL
WLR_AS_GROSS Use wet-less-residue volume as gross volume for NGL OIUX2_WLR_AS_GROSS CHAR 1 0
NULL Use gross volume
X Use wet-less-residue volume as gross volume for NGL
SPECIAL_LOGIC General Flag FLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set