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

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PBLNR Business location identifier (IS-Oil MRN) CHAR 10 0 OIF_PBLNR
NAME1 Internal name field CHAR 35 0 OIF_PBNAM1
PBLTYP Business Location Type (IS-Oil MRN) CHAR 4 0 OIFSPBLT OIF_PBLTYP
ADDRNUM Address No. in ADRC CHAR 10 0 OIFSMCADDR OIF_ADNUM
ERDAT Date Record Created on (Date) DATS 8 0 OIF_ERDAT
ERZEIT Time Record Created at (Time) TIMS 6 0 OIF_ERZEIT
ERNAM User who Created Record CHAR 12 0 OIF_ERNAM
AEDAT Date Record Changed on (Date) DATS 8 0 OIF_AEDAT
AEZEIT Time when Record Was Changed TIMS 6 0 OIF_AEZEIT
AENAM User who Changed Record CHAR 12 0 OIF_AENAM
BLOIND Block Indicator CHAR 1 0 OIF_BLOIND
DELIND Deletion indicator CHAR 1 0 OIF_DELIND
BLCODE Business Location Blocking Indicator (IS-Oil MRN) CHAR 2 0 OIFSBLCD OIF_BLCD
OBJNR Object number CHAR 22 0 * J_OBJNR
BRAND Location brand CHAR 5 0 OIRBBRAND OIRB_BRAND
LOCVALUE Relative location value CHAR 2 0 OIRBPBLVAL OIRB_VAL
LOCVDIFF Location value differentiator CHAR 2 0 OIRBPBLVALD OIRB_LOCVDIFF
LOCAA Location area assignment CHAR 5 0 OIRBLAA OIRB_LAA
LOCMP SSR Pricing - Margins procedure assigned to this location CHAR 1 0 OIRCTVKD OIRC_KALKS
PCGROUP Process control group CHAR 10 0 OIRAPCG OIRA_PCG
AUTGR Authorization group CHAR 4 0 OIRB_AUTGR
VALGP SSR PC: Upload validation group CHAR 2 0 OIREVALGP OIREVALGROUP
BUKRS Company Code CHAR 4 0 T001 BUKRS
OIRIPGRP SSR SD/FI Invoice posting group CHAR 2 0 OIRI_PGRP
CONVGR SSR Interface conversion group definition (IS-Oil, SSR) CHAR 4 0 OIRHCVGRDEFC OIRH_CONVGR
LOGSYS Logical system for EDI CHAR 10 0 TBDLS OIRH_LOGSYS
CITY1 City CHAR 40 0 AD_CITY1
CITY2 District CHAR 40 0 AD_CITY2
POST_CODE1 City postal code CHAR 10 0 AD_PSTCD1
STREET Street CHAR 60 0 AD_STREET
COUNTRY Country/Region Key CHAR 3 0 LAND1
REGION Region (State, Province, County) CHAR 3 0 REGIO
TIME_ZONE Address time zone CHAR 6 0 AD_TZONE
TEL_NUMBER First telephone no.: dialling code+number CHAR 30 0 AD_TLNMBR1
KOKRS_CC Controlling Area CHAR 4 0 KOKRS
KOSTL_CC Cost Center CHAR 10 0 KOSTL
DATBI_CC Valid To Date DATS 8 0 DATBI
BEZEI_CC Name of the controlling area CHAR 25 0 BEZEI
ABTEI_CC Department CHAR 12 0 ABTEI
VERAK_CC Person Responsible CHAR 20 0 VERAK
NAME_CC Name 1 CHAR 35 0 NAME1_GP
KOKRS_PC Controlling Area CHAR 4 0 KOKRS
PRCTR_PC Profit Center CHAR 10 0 PRCTR
DATBI_PC Valid To Date DATS 8 0 DATBI
DATAB_PC Valid-From Date DATS 8 0 DATAB
BEZEI_PC Name of the controlling area CHAR 25 0 BEZEI
ABTEI_PC Department CHAR 12 0 ABTEIL
NAME1_PC Name 1 CHAR 35 0 NAME1_GP
VERAPC_PC Person Responsible for Profit Center CHAR 20 0 VERAPC
BUKRS_AM Company Code CHAR 4 0 BUKRS
ANLN1_AM Main Asset Number CHAR 12 0 ANLN1
ANLN2_AM Asset Subnumber CHAR 4 0 ANLN2
TXT50_AM Asset Description CHAR 50 0 TXA50_ANLT
ANLKL_AM Asset Class CHAR 8 0 ANLKL
TXK50_AM Asset class description CHAR 50 0 TXT50_ANKT
TPLNR_FL Functional Location CHAR 30 0 TPLNR
PLTXT_FL Description of functional location CHAR 40 0 PLTXT
TPLMA_FL Superior functional location CHAR 30 0 TPLMA
WERKS_SL Plant for storage location assignment entry (IS-Oil MRN) CHAR 4 0 OIF_WERKSL
BWKEY_SL Valuation area CHAR 4 0 BWKEY
BUKRS_SL Company Code CHAR 4 0 BUKRS
LGORT_SL Storage location CHAR 4 0 LGORT_D
LGOBE_SL Description of Storage Location CHAR 16 0 LGOBE
SPART_SL Division CHAR 2 0 SPART
WERKS_PA Plant assignment entry (IS-Oil MRN) CHAR 4 0 OIF_WERKSW
NAME1_PA Name CHAR 30 0 NAME1
BWKEY_PA Valuation area CHAR 4 0 BWKEY
BUKRS_PA Company Code CHAR 4 0 BUKRS
NAME2 Name 2 CHAR 40 0 AD_NAME2
NAME3 Name 3 CHAR 40 0 AD_NAME3
NAME4 Name 4 CHAR 40 0 AD_NAME4
DESC_LAA Descriptive text CHAR 50 0 OIRB_DESCR
LOCREG Location region CHAR 4 0 OIRB_REGION
DESCR_REG Descriptive text CHAR 50 0 OIRB_DESCR
LOCAREA Location area CHAR 4 0 OIRB_AREA
DESCR_AREA Descriptive text CHAR 50 0 OIRB_DESCR
LOCSAREA Location sub-area CHAR 4 0 OIRB_SAREA
DESCR_SAREA Descriptive text CHAR 50 0 OIRB_DESCR
STATUS Location status CHAR 2 0 OIRB_STATUS
STATUST Descriptive text CHAR 50 0 OIRA_DESCR
LOCVALUET Descriptive text CHAR 50 0 OIRB_DESCR
LOCVDIFFT Descriptive text CHAR 50 0 OIRB_DESCR
LOCMPT Description CHAR 20 0 BEZEI20
PCGROUPT Descriptive text CHAR 50 0 OIRA_DESCR
CONVGRT Descriptive text (IS-Oil, SSR) CHAR 50 0 OIRH_DESCR
VALGPT SSR PC: Validation group description CHAR 50 0 OIREVALDESC

ROIR_HLM_ALV foreign key relationships

Table Field Check Table Check Field
0 ROIR_HLM_ALV ADDRNUM OIFSMCADDR Link Table Between OIFSPBL and ADRC for Matchcode MANDT
0 ROIR_HLM_ALV ADDRNUM OIFSMCADDR Link Table Between OIFSPBL and ADRC for Matchcode PBLNR
1 ROIR_HLM_ALV BLCODE OIFSBLCD Blocking Indicator for Business Locations MANDT
1 ROIR_HLM_ALV BLCODE OIFSBLCD Blocking Indicator for Business Locations BLCODE
0 ROIR_HLM_ALV BRAND OIRBBRAND Location Brand (IS-OIL SSR) MANDT
1 ROIR_HLM_ALV BUKRS T001 Company Codes BUKRS
0 ROIR_HLM_ALV CONVGR OIRHCVGRDEFC Conversion Group Definitions(IS-Oil, SSR) MANDT
0 ROIR_HLM_ALV CONVGR OIRHCVGRDEFC Conversion Group Definitions(IS-Oil, SSR) CONVGR
1 ROIR_HLM_ALV LOCAA OIRBLAA Location area assignment (IS-OIL SSR) MANDT
1 ROIR_HLM_ALV LOCAA OIRBLAA Location area assignment (IS-OIL SSR) RNBT
1 ROIR_HLM_ALV LOCAA OIRBLAA Location area assignment (IS-OIL SSR) LOCAACTRY
0 ROIR_HLM_ALV LOCMP OIRCTVKD SSR Pricing - Location Margin Procedure MANDT
1 ROIR_HLM_ALV LOCVALUE OIRBPBLVAL Relative Location Value (IS-OIL SSR) MANDT
1 ROIR_HLM_ALV LOCVALUE OIRBPBLVAL Relative Location Value (IS-OIL SSR) LOCVALUE
0 ROIR_HLM_ALV LOCVDIFF OIRBPBLVALD Location Value differentiator (IS-OIL SSR) MANDT
0 ROIR_HLM_ALV LOCVDIFF OIRBPBLVALD Location Value differentiator (IS-OIL SSR) LOCVDIFF
1 ROIR_HLM_ALV LOGSYS TBDLS Logical system LOGSYS
0 ROIR_HLM_ALV PBLTYP OIFSPBLT Physical Business Location Type MANDT
0 ROIR_HLM_ALV PBLTYP OIFSPBLT Physical Business Location Type PBLTYP
1 ROIR_HLM_ALV PCGROUP OIRAPCG Process Control Group (IS-OIL SSR) PCGROUP
0 ROIR_HLM_ALV VALGP OIREVALGP SSR PC: Upload Validation Group MANDT
0 ROIR_HLM_ALV VALGP OIREVALGP SSR PC: Upload Validation Group VALGP