ROIR_HLM_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 ROIR_HLM_ALV
Related tables to ROIR_HLM_ALV
Access table ROIR_HLM_ALV




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

ROIR_HLM_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_ROIR_HLM_ALV TYPE ROIR_HLM_ALV.

The ROIR_HLM_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 MANDT (Client), PBLNR (Business location identifier (IS-Oil MRN)), NAME1 (Internal name field), A1_SGRNDB (Land Register Number (IS-Oil MRN Demo APPEND)).. 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 ROIR_HLM_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
MANDTClient MANDTCLNT3T000MANDT
PBLNRBusiness location identifier (IS-Oil MRN) OIF_PBLNRCHAR10Assigned to domainALPHAOIF_PBLNROI0OIFB
NAME1Internal name field OIF_PBNAM1CHAR35CHAR35
.INCLU--AP 0
A1_SGRNDBLand Register Number (IS-Oil MRN Demo APPEND) OIF_SGRNDBNUMC8OIF_SGRNDB
A1_UTILTPUsage Type of Property (IS-Oil MRN Demo APPEND) OIF_UTILTPCHAR2OIF_UTILTP
A1_GRTYPProperty Type (IS-Oil MRN Demo APPEND) OIF_GRTYPNUMC3OIF_GRTYP
A1_GRQALQuality of Business Location (IS-Oil MRN Demo APPEND) OIF_GRQALNUMC3OIF_GRQAL
A1_GRFRMProperty Type (IS-Oil MRN Demo APPEND) OIF_GRFRMNUMC3OIF_GRFRM
A1_GRGZSOverall Condition of Property (IS-Oil MRN Demo APPEND) OIF_GRGZSNUMC3OIF_GRGZS
A1_DAKTBDate Active in Inventory (IS-Oil MRN Demo APPEND) OIF_DAKTBDATS8OIF_DAKTB
.INCLU--AP 0
PBLTYPBusiness Location Type (IS-Oil MRN) OIF_PBLTYPCHAR4OIFSPBLTOIF_PBLTYP
ADDRNUMAddress No. in ADRC OIF_ADNUMCHAR10OIFSMCADDRALPHAAD_ADDRNUM
ERDATDate Record Created on (Date) OIF_ERDATDATS8DATS
ERZEITTime Record Created at (Time) OIF_ERZEITTIMS6TIME
ERNAMUser who Created Record OIF_ERNAMCHAR12USNAM
AEDATDate Record Changed on (Date) OIF_AEDATDATS8DATS
AEZEITTime when Record Was Changed OIF_AEZEITTIMS6TIME
AENAMUser who Changed Record OIF_AENAMCHAR12USNAM
BLOINDBlock Indicator OIF_BLOINDCHAR1XFELD
DELINDDeletion indicator OIF_DELINDCHAR1XFELD
BLCODEBusiness Location Blocking Indicator (IS-Oil MRN) OIF_BLCDCHAR2OIFSBLCDOIF_BLCD
OBJNRObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
BRANDLocation brand OIRB_BRANDCHAR5OIRBBRANDOIRB_BRAND
LOCVALUERelative location value OIRB_VALCHAR2OIRBPBLVALOIRB_VAL
LOCVDIFFLocation value differentiator OIRB_LOCVDIFFCHAR2OIRBPBLVALDOIRB_LOCVDIFF
LOCAALocation area assignment OIRB_LAACHAR5OIRBLAAOIRB_LAA
LOCMPSSR Pricing - Margins procedure assigned to this location OIRC_KALKSCHAR1OIRCTVKDOIRC_KALKS
PCGROUPProcess control group OIRA_PCGCHAR10OIRAPCGOIRA_PCG
AUTGRAuthorization group OIRB_AUTGRCHAR4CHAR4
VALGPSSR PC: Upload validation group OIREVALGROUPCHAR2OIREVALGPOIREVALGROUP
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
OIRIPGRPSSR SD/FI Invoice posting group OIRI_PGRPCHAR2OIRI_PGRP
CONVGRSSR Interface conversion group definition (IS-Oil, SSR) OIRH_CONVGRCHAR4OIRHCVGRDEFCCHAR4
LOGSYSLogical system for EDI OIRH_LOGSYSCHAR10TBDLSALPHALOGSYS
.INCLU--AP 0
TPLSTTransportation planning point TPLSTCHAR4TTDSTPLSTTDP
TPLST_TXTDescription of transportation planning point TPLST_TXTCHAR20TEXT20
LONGITUDEGeo location longitude GEOLONDEC15(12) GEOLONLAT
LATITUDEGeo location latitude GEOLATDEC15(12) GEOLONLAT
TIME_TO_ADDDuration to Add at Base Location (in hours:minutes) OIO_TIME_TO_ADDDEC11TSTRNTSTRDURAN
AVRG_STAYTDuration of Stay at Remote Location (in hours:minutes) OIO_AVRG_STAYTDEC11TSTRNTSTRDURAN
KNOTETransportation Connection Points KNOTECHAR10TVKNKNOTN
KNOTE_BEZNode name KNOTE_BEZCHAR30TEXT30
ROUTEShipment route ROUTRCHAR6TVROROUTEVMTR
TXROUDescription of Route ROUTBEZCHAR40TEXT40
R_CON_POINTRadiobutton for connection point in RLM VMIS location OIO_VMIS_CCHAR1XRADI
R_ROUTERadiobutton for shipment route in RLM VMIS location OIO_VMIS_RCHAR1XRADI
.INCLU--AP 0
XCOORX coordinate OIRB_COOR_XFLTP16(16)
YCOORY coordinate OIRB_COOR_YFLTP16(16)
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
TIME_ZONEAddress time zone AD_TZONECHAR6Assigned to domainTZNZONE
TEL_NUMBERFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
KOKRS_CCControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
KOSTL_CCCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
DATBI_CCValid To Date DATBIDATS8DATUM
BEZEI_CCName of the controlling area BEZEICHAR25TEXT25
ABTEI_CCDepartment ABTEICHAR12ABTEI
VERAK_CCPerson Responsible VERAKCHAR20VERAK
NAME_CCName 1 NAME1_GPCHAR35NAME
KOKRS_PCControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
PRCTR_PCProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
DATBI_PCValid To Date DATBIDATS8DATUM
DATAB_PCValid-From Date DATABDATS8DATUM
BEZEI_PCName of the controlling area BEZEICHAR25TEXT25
ABTEI_PCDepartment ABTEILCHAR12ABTEI
NAME1_PCName 1 NAME1_GPCHAR35NAME
VERAPC_PCPerson Responsible for Profit Center VERAPCCHAR20VERAK
BUKRS_AMCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
ANLN1_AMMain Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
ANLN2_AMAsset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
TXT50_AMAsset description TXA50_ANLTCHAR50TEXT50
ANLKL_AMAsset Class ANLKLCHAR8Assigned to domainALPHAANLKLANKSH_ANLKA
TXK50_AMAsset class description TXT50_ANKTCHAR50TEXT50
TPLNR_FLFunctional Location TPLNRCHAR30Assigned to domainTPLNRTPLNRIFLIFLM
PLTXT_FLDescription of functional location PLTXTCHAR40TEXT40
TPLMA_FLSuperior functional location TPLMACHAR30Assigned to domainTPLNRTPLNRIFLM
WERKS_SLPlant for storage location assignment entry (IS-Oil MRN) OIF_WERKSLCHAR4Assigned to domainWERKS
BWKEY_SLValuation Area BWKEYCHAR4Assigned to domainBWKEYBWK
BUKRS_SLCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
LGORT_SLStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
LGOBE_SLDescription of Storage Location LGOBECHAR16TEXT16
SPART_SLDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
WERKS_PAPlant assignment entry (IS-Oil MRN) OIF_WERKSWCHAR4Assigned to domainWERKSWRK
NAME1_PAName NAME1CHAR30TEXT30
BWKEY_PAValuation Area BWKEYCHAR4Assigned to domainBWKEYBWK
BUKRS_PACompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
NAME2Name 2 AD_NAME2CHAR40TEXT40
NAME3Name 3 AD_NAME3CHAR40TEXT40
NAME4Name 4 AD_NAME4CHAR40TEXT40
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
STATUSLocation status OIRB_STATUSCHAR2Assigned to domainOIRB_STATUS
STATUSTDescriptive text OIRA_DESCRCHAR50TEXT50
LOCVALUETDescriptive text OIRB_DESCRCHAR50TEXT50
LOCVDIFFTDescriptive text OIRB_DESCRCHAR50TEXT50
LOCMPTDescription BEZEI20CHAR20TEXT20
PCGROUPTDescriptive text OIRA_DESCRCHAR50TEXT50
CONVGRTDescriptive text (IS-Oil, SSR) OIRH_DESCRCHAR50TEXT50
VALGPTSSR PC: Validation group description OIREVALDESCCHAR50TEXT50

Key field Non-key field



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

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

How to access SAP table ROIR_HLM_ALV

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