ROIUX1_PRD_UIDB SAP (Update structure for production units) Structure details

Dictionary Type: Structure
Description: Update structure for production units




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




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

ROIUX1_PRD_UIDB 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 "Update structure for production units" 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_ROIUX1_PRD_UIDB TYPE ROIUX1_PRD_UIDB.

The ROIUX1_PRD_UIDB table consists of various fields, each holding specific information or linking keys about Update structure for production units data available in SAP. These include MANDT (Client), RSG (Report Submission Group), AGENCY (Agency for Reporting), OGIND (Oil and Gas Indicator).. 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 ROIUX1_PRD_UIDB 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
RSGReport Submission Group OIUX1_RSGCHAR4OIUX1_RPT_SGRPOIUX1_RSGRSG
AGENCYAgency for Reporting OIUX1_TAX_AGENCYCHAR3Assigned to domainCHAR3OIUREP_AGENCYOIUX1_SH_TAX_AGY
OGINDOil and Gas Indicator OIUREP_OIL_GAS_INDCHAR1OIUREP_OIL_GAS_INDOIUREP_OIL_GAS_IND
PUIDProduction Unit ID for tax reporting OIUX1_PUIDCHAR20OIUX1_PROD_UNITOIUX1_PUID
OPERATOROperator OIU_OPERATORCHAR10Assigned to domainALPHAKUNNR
FIELDField ID OIU_FIELDIDCHAR10OIU_PR_FIELDALPHAOIU_FIELDIDOIU_FIELD
PUID_TYPEProduction unit type OIUX1_PUID_TYPECHAR2OIUX1_PUID_TYPE
PUID_GRPProduction unit group OIUX1_PUID_GRPCHAR4OIUX1_PUID_GRP
LEASE_SHARELease share OIUX1_LEASE_SHAREDEC9(8) OIUX1_LEASE_SHARE
EXEMPT_DECexempt decimal OIUX1_EXEMPT_DECDEC9(8) OIUX1_EXEMPT_DEC
INACTIVE_FLAGInactive Flag OIUX1_INACTIVE_FLAGCHAR1OIUX1_INACTIVE_FLAG
USERNAMEName of Person who Created the Object ERNAMCHAR12USNAM
TIMESTAMPTime stamp in Numeric Character OIUX1_TIMESTAMPNUMC14OII_TIMEST
DB_ACTIONType of change (Insert, Delete or Update) OIUREP_CHANGE_TYPECHAR1OIUREP_CHANGE_TYPE

Key field Non-key field



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

As ROIUX1_PRD_UIDB 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 ROIUX1_PRD_UIDB as there is no data to select.

How to access SAP table ROIUX1_PRD_UIDB

Within an ECC or HANA version of SAP you can also view further information about ROIUX1_PRD_UIDB 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!