ROIRA_AGGFIELDS SAP (SSR Structures available for DD03L table name foreign key) Structure details

Dictionary Type: Structure
Description: SSR Structures available for DD03L table name foreign key




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




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

ROIRA_AGGFIELDS 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 "SSR Structures available for DD03L table name foreign key" 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_ROIRA_AGGFIELDS TYPE ROIRA_AGGFIELDS.

The ROIRA_AGGFIELDS table consists of various fields, each holding specific information or linking keys about SSR Structures available for DD03L table name foreign key data available in SAP. These include PBLNR (Business location identifier (IS-Oil MRN)), DATATYPE (Data type), SRCETAB (Source table), RNBT (Business type).. 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 ROIRA_AGGFIELDS 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
PBLNRBusiness location identifier (IS-Oil MRN) OIF_PBLNRCHAR10Assigned to domainALPHAOIF_PBLNROI0OIFB
DATATYPEData type OIRA_DATATYPECHAR3OIRA_DATATYPE
SRCETABSource table OIRA_SRCETABCHAR16OIRA_SRCETAB
RNBTBusiness type OIRA_RNBTCHAR4Assigned to domainOIRA_RNBTOIRA_0
PARFNMRN business partner role / relation type OIF_PARFNCHAR4Assigned to domainOIF_PARFN
FTMSTMStart of partner function validity period: time stamp OIF_FTMSTMNUMC14OIF_TMSTM
PARPOSPartner counter OIF_PARPOSNUMC3OIF_PARPOS
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
STYPService type OIRA_STYPCHAR4Assigned to domainOIRA_STYPOIR_ST
VKDATSSR PC: Sales date at the service station OIRE_VKDATDATS8DATSOIRE_VKDAT
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
CHOBJSSR PC: Clearing house OIRE_CHOBJCHAR6Assigned to domainOIRE_CHOBJ
SSR_CCINSSSR PC: Payment card type OIRE_CCINSCHAR4Assigned to domainOIRE_CCINSOIRE_CCINS
STORNOSSR PC: Reversal indicator OIRE_STORNOCHAR1CHAR1
COMPFLComplaint indicator for OIRADBT entries OIRA_COMPFLCHAR1CHAR1
VRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
DCINDDebit/Credit indicator OIRA_DCINDCHAR1OIRE_DCIND
KBETRRate (condition amount or percentage) KBETRCURR11(2) WERTV6
KONWARate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
KPEINCondition pricing unit KPEINDEC5KPEIN
KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
MENGESSR PC: Quantity sold at the business location OIRE_MENGEQUAN13(3) MENG13V
BRTWRSSR PC: Gross value OIRE_BRTWRCURR13(2) WERTV7
STPARTPROCPartially processed indicator for Settlement transmission OIRE_SETTRANPARTPROCCHAR1YESNO
SEQNRGMM: Sequence number of meter assigned to customer OII_GSEQNRCHAR10ALPHAOII_SEQNR
TNKNRSequence number of SO assigned to business location OII_BSEQNRCHAR10ALPHAOII_SEQNR
HDRNRSSR PC: DTF payment card transaction number (internal) OIRE_UPLNRCHAR10CHAR10OIRE_UPLNR
ITMNRItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
GMMNRGMM: Number of general meter OII_GMMNRCHAR20Assigned to domainALPHAOII_GMMNROIJ
ITMSTMUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
METREVSSR: Meter event type OIRC_METREVCHAR2Assigned to domainOIRC_METREV
TRANSYEARDocument link number year OIRA_JAHRNUMC4GJAHRGJAHR
SOCNRSOC: Storage object characteristic segment number OII_SOCNRCHAR20Assigned to domainOII_SOCNR
ETMSTMSSR Stocks - Tank dip time stamp OIRC_TMSTMDEC15TZNTSTMPS
SOCEVSOC event OII_SOCEVCHAR2Assigned to domainOII_SOCEV
KWAEHCondition currency (for cumulation fields) KWAEHCUKY5Assigned to domainWAERSFWS
SRCD_DATESSR - Source data date OIRA_SRCD_DATEDATS8DATUM
SRCD_TIMESSR - Source date time OIRA_SRCD_TIMETIMS6UZEIT
OIRA_CUSTDummy function in length 1 DUMMYCHAR1DUMMY

Key field Non-key field



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

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

How to access SAP table ROIRA_AGGFIELDS

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