1. Home
  2. Resources
  3. SAP Tables
  4. ROIR_HLM_ALV - Structure for alv display of location master(IS-OIL, SSR)

SAP Table ROIR_HLM_ALV

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

ROIR_HLM_ALV (Structure for alv display of location master(IS-OIL, SSR)) 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 ROIR_HLM_ALV to other SAP tables.

Source: ROIR_HLM_ALV (Structure for alv display of location master(IS-OIL, SSR))

ROIR_HLM_ALV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PBLNR Business location identifier (IS-Oil MRN) OIF_PBLNR CHAR 10 0
NAME1 Internal name field OIF_PBNAM1 CHAR 35 0
A1_SGRNDB Land Register Number (IS-Oil MRN Demo APPEND) OIF_SGRNDB NUMC 8 0
A1_UTILTP Usage Type of Property (IS-Oil MRN Demo APPEND) OIF_UTILTP CHAR 2 0
A1_GRTYP Property Type (IS-Oil MRN Demo APPEND) OIF_GRTYP NUMC 3 0
A1_GRQAL Quality of Business Location (IS-Oil MRN Demo APPEND) OIF_GRQAL NUMC 3 0
A1_GRFRM Property Type (IS-Oil MRN Demo APPEND) OIF_GRFRM NUMC 3 0
A1_GRGZS Overall Condition of Property (IS-Oil MRN Demo APPEND) OIF_GRGZS NUMC 3 0
A1_DAKTB Date Active in Inventory (IS-Oil MRN Demo APPEND) OIF_DAKTB DATS 8 0
PBLTYP Business Location Type (IS-Oil MRN) OIF_PBLTYP OIFSPBLT CHAR 4 0
ADDRNUM Address No. in ADRC OIF_ADNUM OIFSMCADDR CHAR 10 0
ERDAT Date Record Created on (Date) OIF_ERDAT DATS 8 0
ERZEIT Time Record Created at (Time) OIF_ERZEIT TIMS 6 0
ERNAM User who Created Record OIF_ERNAM CHAR 12 0
AEDAT Date Record Changed on (Date) OIF_AEDAT DATS 8 0
AEZEIT Time when Record Was Changed OIF_AEZEIT TIMS 6 0
AENAM User who Changed Record OIF_AENAM CHAR 12 0
BLOIND Block Indicator OIF_BLOIND CHAR 1 0
X Yes
NULL No
DELIND Deletion indicator OIF_DELIND CHAR 1 0
X Yes
NULL No
BLCODE Business Location Blocking Indicator (IS-Oil MRN) OIF_BLCD OIFSBLCD CHAR 2 0
OBJNR Object number J_OBJNR CHAR 22 0
BRAND Location brand OIRB_BRAND OIRBBRAND CHAR 5 0
LOCVALUE Relative location value OIRB_VAL OIRBPBLVAL CHAR 2 0
LOCVDIFF Location value differentiator OIRB_LOCVDIFF OIRBPBLVALD CHAR 2 0
LOCAA Location area assignment OIRB_LAA OIRBLAA CHAR 5 0
LOCMP SSR Pricing - Margins procedure assigned to this location OIRC_KALKS OIRCTVKD CHAR 1 0
PCGROUP Process control group OIRA_PCG OIRAPCG CHAR 10 0
AUTGR Authorization group OIRB_AUTGR CHAR 4 0
VALGP SSR PC: Upload validation group OIREVALGROUP OIREVALGP CHAR 2 0
BUKRS Company Code BUKRS T001 CHAR 4 0
OIRIPGRP SSR SD/FI Invoice posting group OIRI_PGRP CHAR 2 0
CONVGR SSR Interface conversion group definition (IS-Oil, SSR) OIRH_CONVGR OIRHCVGRDEFC CHAR 4 0
LOGSYS Logical system for EDI OIRH_LOGSYS TBDLS CHAR 10 0
TPLST Transportation planning point TPLST TTDS CHAR 4 0
TPLST_TXT Description of transportation planning point TPLST_TXT CHAR 20 0
LONGITUDE Geo location longitude GEOLON DEC 15 12
LATITUDE Geo location latitude GEOLAT DEC 15 12
TIME_TO_ADD Duration to Add at Base Location (in hours:minutes) OIO_TIME_TO_ADD DEC 11 0
AVRG_STAYT Duration of Stay at Remote Location (in hours:minutes) OIO_AVRG_STAYT DEC 11 0
KNOTE Transportation Connection Points KNOTE TVKN CHAR 10 0
KNOTE_BEZ Node name KNOTE_BEZ CHAR 30 0
ROUTE Shipment route ROUTR TVRO CHAR 6 0
TXROU Description of Route ROUTBEZ CHAR 40 0
R_CON_POINT Radiobutton for connection point in RLM VMIS location OIO_VMIS_C CHAR 1 0
X Yes
NULL No
. No
R_ROUTE Radiobutton for shipment route in RLM VMIS location OIO_VMIS_R CHAR 1 0
X Yes
NULL No
. No
XCOOR X coordinate OIRB_COOR_X FLTP 16 16
YCOOR Y coordinate OIRB_COOR_Y FLTP 16 16
CITY1 City AD_CITY1 CHAR 40 0
CITY2 District AD_CITY2 CHAR 40 0
POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
STREET Street AD_STREET CHAR 60 0
COUNTRY Country Key LAND1 CHAR 3 0
REGION Region (State, Province, County) REGIO CHAR 3 0
TIME_ZONE Address time zone AD_TZONE CHAR 6 0
TEL_NUMBER First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
KOKRS_CC Controlling Area KOKRS CHAR 4 0
KOSTL_CC Cost Center KOSTL CHAR 10 0
DATBI_CC Valid To Date DATBI DATS 8 0
BEZEI_CC Name of the controlling area BEZEI CHAR 25 0
ABTEI_CC Department ABTEI CHAR 12 0
VERAK_CC Person Responsible VERAK CHAR 20 0
NAME_CC Name 1 NAME1_GP CHAR 35 0
KOKRS_PC Controlling Area KOKRS CHAR 4 0
PRCTR_PC Profit Center PRCTR CHAR 10 0
DATBI_PC Valid To Date DATBI DATS 8 0
DATAB_PC Valid-From Date DATAB DATS 8 0
BEZEI_PC Name of the controlling area BEZEI CHAR 25 0
ABTEI_PC Department ABTEIL CHAR 12 0
NAME1_PC Name 1 NAME1_GP CHAR 35 0
VERAPC_PC Person Responsible for Profit Center VERAPC CHAR 20 0
BUKRS_AM Company Code BUKRS CHAR 4 0
ANLN1_AM Main Asset Number ANLN1 CHAR 12 0
ANLN2_AM Asset Subnumber ANLN2 CHAR 4 0
TXT50_AM Asset description TXA50_ANLT CHAR 50 0
ANLKL_AM Asset Class ANLKL CHAR 8 0
TXK50_AM Asset class description TXT50_ANKT CHAR 50 0
TPLNR_FL Functional Location TPLNR CHAR 30 0
PLTXT_FL Description of functional location PLTXT CHAR 40 0
TPLMA_FL Superior functional location TPLMA CHAR 30 0
WERKS_SL Plant for storage location assignment entry (IS-Oil MRN) OIF_WERKSL CHAR 4 0
BWKEY_SL Valuation Area BWKEY CHAR 4 0
BUKRS_SL Company Code BUKRS CHAR 4 0
LGORT_SL Storage Location LGORT_D CHAR 4 0
LGOBE_SL Description of Storage Location LGOBE CHAR 16 0
SPART_SL Division SPART CHAR 2 0
WERKS_PA Plant assignment entry (IS-Oil MRN) OIF_WERKSW CHAR 4 0
NAME1_PA Name NAME1 CHAR 30 0
BWKEY_PA Valuation Area BWKEY CHAR 4 0
BUKRS_PA Company Code BUKRS CHAR 4 0
NAME2 Name 2 AD_NAME2 CHAR 40 0
NAME3 Name 3 AD_NAME3 CHAR 40 0
NAME4 Name 4 AD_NAME4 CHAR 40 0
DESC_LAA Descriptive text OIRB_DESCR CHAR 50 0
LOCREG Location region OIRB_REGION CHAR 4 0
DESCR_REG Descriptive text OIRB_DESCR CHAR 50 0
LOCAREA Location area OIRB_AREA CHAR 4 0
DESCR_AREA Descriptive text OIRB_DESCR CHAR 50 0
LOCSAREA Location sub-area OIRB_SAREA CHAR 4 0
DESCR_SAREA Descriptive text OIRB_DESCR CHAR 50 0
STATUS Location status OIRB_STATUS CHAR 2 0
STATUST Descriptive text OIRA_DESCR CHAR 50 0
LOCVALUET Descriptive text OIRB_DESCR CHAR 50 0
LOCVDIFFT Descriptive text OIRB_DESCR CHAR 50 0
LOCMPT Description BEZEI20 CHAR 20 0
PCGROUPT Descriptive text OIRA_DESCR CHAR 50 0
CONVGRT Descriptive text (IS-Oil, SSR) OIRH_DESCR CHAR 50 0
VALGPT SSR PC: Validation group description OIREVALDESC CHAR 50 0

ROIR_HLM_ALV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ROIR_HLM_ALV ADDRNUM ROIR_HLM_ALV MANDT OIFSMCADDR Link Table Between OIFSPBL and ADRC for Matchcode MANDT
ROIR_HLM_ALV ADDRNUM ROIR_HLM_ALV PBLNR OIFSMCADDR Link Table Between OIFSPBL and ADRC for Matchcode PBLNR
ROIR_HLM_ALV ADDRNUM ROIR_HLM_ALV ADDRNUM OIFSMCADDR Link Table Between OIFSPBL and ADRC for Matchcode ADDRNUM
ROIR_HLM_ALV BLCODE ROIR_HLM_ALV MANDT OIFSBLCD Blocking Indicator for Business Locations MANDT
ROIR_HLM_ALV BLCODE ROIR_HLM_ALV BLCODE OIFSBLCD Blocking Indicator for Business Locations BLCODE
ROIR_HLM_ALV BRAND ROIR_HLM_ALV BRAND OIRBBRAND Location Brand (IS-OIL SSR) BRANDID
ROIR_HLM_ALV BRAND * OIRBBRAND Location Brand (IS-OIL SSR) MANDT
ROIR_HLM_ALV BUKRS ROIR_HLM_ALV BUKRS T001 Company Codes BUKRS
ROIR_HLM_ALV BUKRS * T001 Company Codes MANDT
ROIR_HLM_ALV CONVGR ROIR_HLM_ALV CONVGR OIRHCVGRDEFC Conversion Group Definitions(IS-Oil, SSR) CONVGR
ROIR_HLM_ALV CONVGR * OIRHCVGRDEFC Conversion Group Definitions(IS-Oil, SSR) MANDT
ROIR_HLM_ALV KNOTE ROIR_HLM_ALV MANDT TVKN Routes: Transportation Connection Points MANDT
ROIR_HLM_ALV KNOTE ROIR_HLM_ALV KNOTE TVKN Routes: Transportation Connection Points KNOTE
ROIR_HLM_ALV LOCAA ROIR_HLM_ALV LOCAA OIRBLAA Location area assignment (IS-OIL SSR) LOCAA
ROIR_HLM_ALV LOCAA * OIRBLAA Location area assignment (IS-OIL SSR) LOCAACTRY
ROIR_HLM_ALV LOCAA ' ' OIRBLAA Location area assignment (IS-OIL SSR) RNBT
ROIR_HLM_ALV LOCAA SY MANDT OIRBLAA Location area assignment (IS-OIL SSR) MANDT
ROIR_HLM_ALV LOCMP * OIRCTVKD SSR Pricing - Location Margin Procedure MANDT
ROIR_HLM_ALV LOCMP ROIR_HLM_ALV LOCMP OIRCTVKD SSR Pricing - Location Margin Procedure KALKS
ROIR_HLM_ALV LOCVALUE ROIR_HLM_ALV LOCVALUE OIRBPBLVAL Relative Location Value (IS-OIL SSR) LOCVALUE
ROIR_HLM_ALV LOCVALUE * OIRBPBLVAL Relative Location Value (IS-OIL SSR) MANDT
ROIR_HLM_ALV LOCVDIFF * OIRBPBLVALD Location Value differentiator (IS-OIL SSR) MANDT
ROIR_HLM_ALV LOCVDIFF ROIR_HLM_ALV LOCVDIFF OIRBPBLVALD Location Value differentiator (IS-OIL SSR) LOCVDIFF
ROIR_HLM_ALV LOGSYS ROIR_HLM_ALV LOGSYS TBDLS Logical system LOGSYS
ROIR_HLM_ALV MANDT ROIR_HLM_ALV MANDT T000 Clients MANDT
ROIR_HLM_ALV PBLTYP ROIR_HLM_ALV PBLTYP OIFSPBLT Physical Business Location Type PBLTYP
ROIR_HLM_ALV PBLTYP ROIR_HLM_ALV MANDT OIFSPBLT Physical Business Location Type MANDT
ROIR_HLM_ALV PCGROUP ROIR_HLM_ALV PCGROUP OIRAPCG Process Control Group (IS-OIL SSR) PCGROUP
ROIR_HLM_ALV PCGROUP * OIRAPCG Process Control Group (IS-OIL SSR) CLIENT
ROIR_HLM_ALV ROUTE ROIR_HLM_ALV ROUTE TVRO Routes ROUTE
ROIR_HLM_ALV ROUTE ROIR_HLM_ALV MANDT TVRO Routes MANDT
ROIR_HLM_ALV TPLST ROIR_HLM_ALV MANDT TTDS Organizational Unit: Transportation Scheduling Point MANDT
ROIR_HLM_ALV TPLST ROIR_HLM_ALV TPLST TTDS Organizational Unit: Transportation Scheduling Point TPLST
ROIR_HLM_ALV VALGP * OIREVALGP SSR PC: Upload Validation Group MANDT
ROIR_HLM_ALV VALGP ROIR_HLM_ALV VALGP OIREVALGP SSR PC: Upload Validation Group VALGP