ROIRI_MARG_ALV SAP (Structure for alv display of location master(IS-OIL, SSR)) Structure details

Dictionary Type: Structure
Description: Structure for alv display of location master(IS-OIL, SSR)




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




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

ROIRI_MARG_ALV 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 "Structure for alv display of location master(IS-OIL, SSR)" 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_ROIRI_MARG_ALV TYPE ROIRI_MARG_ALV.

The ROIRI_MARG_ALV table consists of various fields, each holding specific information or linking keys about Structure for alv display of location master(IS-OIL, SSR) data available in SAP. These include PBLTYP (Business Location Type (IS-Oil MRN)), NAME1 (Internal name field), CITY1 (City), CITY2 (District).. 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 ROIRI_MARG_ALV 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
PBLTYPBusiness Location Type (IS-Oil MRN) OIF_PBLTYPCHAR4Assigned to domainOIF_PBLTYP
NAME1Internal name field OIF_PBNAM1CHAR35CHAR35
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
BEZEI_REGIONDescriptive text for the region OIRA_REG_BEZEI20CHAR20TEXT20
TIME_ZONEAddress time zone AD_TZONECHAR6Assigned to domainTZNZONE
TEL_NUMBERFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
NAME2Name 2 AD_NAME2CHAR40TEXT40
NAME3Name 3 AD_NAME3CHAR40TEXT40
NAME4Name 4 AD_NAME4CHAR40TEXT40
LOCAALocation area assignment OIRB_LAACHAR5OIRBLAAOIRB_LAA
DESC_LAADescriptive text OIRB_DESCRCHAR50TEXT50
LOCREGLocation region OIRB_REGIONCHAR4Assigned to domainOIRB_REGION
DESCR_REGDescriptive text OIRB_DESCRCHAR50TEXT50
LOCAREALocation area OIRB_AREACHAR4Assigned to domainOIRB_AREA
DESCR_AREADescriptive text OIRB_DESCRCHAR50TEXT50
LOCSAREALocation sub-area OIRB_SAREACHAR4Assigned to domainOIRB_SAREA
DESCR_SAREADescriptive text OIRB_DESCRCHAR50TEXT50
WAERKSD Document Currency WAERKCUKY5Assigned to domainWAERSFWS
VRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
BASMEBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
OIRCOMMNETSSR - Location net commission OIRI_COMMNETCURR15(2) WERTV8
OIRCOMMVATSSR - Location vat on commission OIRI_COMMVATCURR15(2) WERTV8
OIRPFEENETSSR - Location net participation fee OIRI_PARTFEENETCURR15(2) WERTV8
OIRPFEEVATSSR - Location net participation vat OIRI_PARTFEEVATCURR15(2) WERTV8
OIRFUGRSSR-Location fuel sales gross OIRI_FUELGRCURR15(2) WERTV8
OIREBVEBV cost OIRI_EBVCURR15(2) WERTV8
OIRFCFEESSSR Fleet Card processing fees OIRI_FCFEESCURR15(2) WERTV8
OIRCHFEESSSR Clearing house processing fees OIRI_CHFEESCURR15(2) WERTV8
OIRFREIGHTFreight cost OIRI_FREIGHTCURR15(2) WERTV8
OIRPURPRPurchase cost of material OIRI_PURPRICECURR15(2) WERTV8
OIRFUNETFuel sales net OIRI_FUELNETCURR15(2) WERTV8
OIRFUVATFuel sales vat OIRI_FUELVATCURR15(2) WERTV8
FKIMGActual Invoiced Quantity FKIMGQUAN13(3) MENG13
FKLMGBilling quantity in stockkeeping unit FKLMGQUAN13(3) MENG13
PRICEAverage product sales price OIRI_PRICECURR15(2) WERTV8
MARGIN1Margin element value OIRI_MARGIN_ELEMENTCURR15(2) WERTV8
MARGIN2Margin element value OIRI_MARGIN_ELEMENTCURR15(2) WERTV8
MARGIN3Margin element value OIRI_MARGIN_ELEMENTCURR15(2) WERTV8
MARGIN4Margin element value OIRI_MARGIN_ELEMENTCURR15(2) WERTV8
REL_MARGIN1Margin element value OIRI_MARGIN_ELEMENTCURR15(2) WERTV8
REL_MARGIN2Margin element value OIRI_MARGIN_ELEMENTCURR15(2) WERTV8
REL_MARGIN3Margin element value OIRI_MARGIN_ELEMENTCURR15(2) WERTV8
REL_MARGIN4Margin element value OIRI_MARGIN_ELEMENTCURR15(2) WERTV8
BASISRelative margin calculation basis OIRI_BASISCHAR5CHAR005

Key field Non-key field



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

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

How to access SAP table ROIRI_MARG_ALV

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