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

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-SSR (Application Component) Service Station Retailing
     ⤷ OIR_H (Package) SSR Interfaces/Internet/BAPIs (IS-Oil ServiceStationRetail.)

Basic Data

Table Category	INTTAB	Structure
Structure	ROIR_HLM_ALV	Table Relationship Diagram
Short Description	Structure for alv display of location master(IS-OIL, SSR)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Physical Location - Master Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
4	NAME1	☐	OIF_PBNAM1	CHAR35	CHAR	35	0	Internal name field
5	.INCLU--AP	☐				0	0	Business location property data (IS-Oil MRN demo APPEND)
6	.INCLUDE	☐				0	0	MRN business location - Real estate property data (demo)
7	A1_SGRNDB	☐	OIF_SGRNDB	OIF_SGRNDB	NUMC	8	0	Land Register Number (IS-Oil MRN Demo APPEND)
8	A1_UTILTP	☐	OIF_UTILTP	OIF_UTILTP	CHAR	2	0	Usage Type of Property (IS-Oil MRN Demo APPEND)
9	A1_GRTYP	☐	OIF_GRTYP	OIF_GRTYP	NUMC	3	0	Property Type (IS-Oil MRN Demo APPEND)
10	A1_GRQAL	☐	OIF_GRQAL	OIF_GRQAL	NUMC	3	0	Quality of Business Location (IS-Oil MRN Demo APPEND)
11	A1_GRFRM	☐	OIF_GRFRM	OIF_GRFRM	NUMC	3	0	Property Type (IS-Oil MRN Demo APPEND)
12	A1_GRGZS	☐	OIF_GRGZS	OIF_GRGZS	NUMC	3	0	Overall Condition of Property (IS-Oil MRN Demo APPEND)
13	A1_DAKTB	☐	OIF_DAKTB	OIF_DAKTB	DATS	8	0	Date Active in Inventory (IS-Oil MRN Demo APPEND)
14	.INCLU--AP	☐				0	0	Oil fields OIFSPBL
15	PBLTYP	☐	OIF_PBLTYP	OIF_PBLTYP	CHAR	4	0	Business Location Type (IS-Oil MRN)	OIFSPBLT
16	ADDRNUM	☐	OIF_ADNUM	AD_ADDRNUM	CHAR	10	0	Address No. in ADRC	OIFSMCADDR
17	ERDAT	☐	OIF_ERDAT	DATS	DATS	8	0	Date Record Created on (Date)
18	ERZEIT	☐	OIF_ERZEIT	TIME	TIMS	6	0	Time Record Created at (Time)
19	ERNAM	☐	OIF_ERNAM	USNAM	CHAR	12	0	User who Created Record
20	AEDAT	☐	OIF_AEDAT	DATS	DATS	8	0	Date Record Changed on (Date)
21	AEZEIT	☐	OIF_AEZEIT	TIME	TIMS	6	0	Time when Record Was Changed
22	AENAM	☐	OIF_AENAM	USNAM	CHAR	12	0	User who Changed Record
23	BLOIND	☐	OIF_BLOIND	XFELD	CHAR	1	0	Block Indicator
24	DELIND	☐	OIF_DELIND	XFELD	CHAR	1	0	Deletion indicator
25	BLCODE	☐	OIF_BLCD	OIF_BLCD	CHAR	2	0	Business Location Blocking Indicator (IS-Oil MRN)	OIFSBLCD
26	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
27	.INCLUDE	☐				0	0	Business location enhancement for OIFSPBL (IS-OIL SSR)
28	BRAND	☐	OIRB_BRAND	OIRB_BRAND	CHAR	5	0	Location brand	OIRBBRAND
29	LOCVALUE	☐	OIRB_VAL	OIRB_VAL	CHAR	2	0	Relative location value	OIRBPBLVAL
30	LOCVDIFF	☐	OIRB_LOCVDIFF	OIRB_LOCVDIFF	CHAR	2	0	Location value differentiator	OIRBPBLVALD
31	LOCAA	☐	OIRB_LAA	OIRB_LAA	CHAR	5	0	Location area assignment	OIRBLAA
32	LOCMP	☐	OIRC_KALKS	OIRC_KALKS	CHAR	1	0	SSR Pricing - Margins procedure assigned to this location	OIRCTVKD
33	PCGROUP	☐	OIRA_PCG	OIRA_PCG	CHAR	10	0	Process control group	OIRAPCG
34	AUTGR	☐	OIRB_AUTGR	CHAR4	CHAR	4	0	Authorization group
35	VALGP	☐	OIREVALGROUP	OIREVALGROUP	CHAR	2	0	SSR PC: Upload validation group	OIREVALGP
36	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
37	OIRIPGRP	☐	OIRI_PGRP	OIRI_PGRP	CHAR	2	0	SSR SD/FI Invoice posting group
38	.INCLUDE	☐				0	0	Conversion Group Structure-Field Conversion(IS-OIL, SSR)
39	CONVGR	☐	OIRH_CONVGR	CHAR4	CHAR	4	0	SSR Interface conversion group definition (IS-Oil, SSR)	OIRHCVGRDEFC
40	LOGSYS	☐	OIRH_LOGSYS	LOGSYS	CHAR	10	0	Logical system for EDI	TBDLS
41	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
42	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
43	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
44	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
45	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
46	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
47	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	*
48	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
49	KOKRS_CC	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
50	KOSTL_CC	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
51	DATBI_CC	☐	DATBI	DATUM	DATS	8	0	Valid To Date
52	BEZEI_CC	☐	BEZEI	TEXT25	CHAR	25	0	Name of the controlling area
53	ABTEI_CC	☐	ABTEI	ABTEI	CHAR	12	0	Department
54	VERAK_CC	☐	VERAK	VERAK	CHAR	20	0	Person Responsible
55	NAME_CC	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
56	KOKRS_PC	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
57	PRCTR_PC	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
58	DATBI_PC	☐	DATBI	DATUM	DATS	8	0	Valid To Date
59	DATAB_PC	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
60	BEZEI_PC	☐	BEZEI	TEXT25	CHAR	25	0	Name of the controlling area
61	ABTEI_PC	☐	ABTEIL	ABTEI	CHAR	12	0	Department
62	NAME1_PC	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
63	VERAPC_PC	☐	VERAPC	VERAK	CHAR	20	0	Person Responsible for Profit Center
64	BUKRS_AM	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
65	ANLN1_AM	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
66	ANLN2_AM	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
67	TXT50_AM	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
68	ANLKL_AM	☐	ANLKL	ANLKL	CHAR	8	0	Asset Class	*
69	TXK50_AM	☐	TXT50_ANKT	TEXT50	CHAR	50	0	Asset class description
70	TPLNR_FL	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
71	PLTXT_FL	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
72	TPLMA_FL	☐	TPLMA	TPLNR	CHAR	30	0	Superior functional location	*
73	WERKS_SL	☐	OIF_WERKSL	WERKS	CHAR	4	0	Plant for storage location assignment entry (IS-Oil MRN)	*
74	BWKEY_SL	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
75	BUKRS_SL	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
76	LGORT_SL	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
77	LGOBE_SL	☐	LGOBE	TEXT16	CHAR	16	0	Description of Storage Location
78	SPART_SL	☐	SPART	SPART	CHAR	2	0	Division	*
79	WERKS_PA	☐	OIF_WERKSW	WERKS	CHAR	4	0	Plant assignment entry (IS-Oil MRN)	*
80	NAME1_PA	☐	NAME1	TEXT30	CHAR	30	0	Name
81	BWKEY_PA	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
82	BUKRS_PA	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
83	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
84	NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
85	NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
86	DESC_LAA	☐	OIRB_DESCR	TEXT50	CHAR	50	0	Descriptive text
87	LOCREG	☐	OIRB_REGION	OIRB_REGION	CHAR	4	0	Location region	*
88	DESCR_REG	☐	OIRB_DESCR	TEXT50	CHAR	50	0	Descriptive text
89	LOCAREA	☐	OIRB_AREA	OIRB_AREA	CHAR	4	0	Location area	*
90	DESCR_AREA	☐	OIRB_DESCR	TEXT50	CHAR	50	0	Descriptive text
91	LOCSAREA	☐	OIRB_SAREA	OIRB_SAREA	CHAR	4	0	Location sub-area	*
92	DESCR_SAREA	☐	OIRB_DESCR	TEXT50	CHAR	50	0	Descriptive text
93	STATUS	☐	OIRB_STATUS	OIRB_STATUS	CHAR	2	0	Location status	*
94	STATUST	☐	OIRA_DESCR	TEXT50	CHAR	50	0	Descriptive text
95	LOCVALUET	☐	OIRB_DESCR	TEXT50	CHAR	50	0	Descriptive text
96	LOCVDIFFT	☐	OIRB_DESCR	TEXT50	CHAR	50	0	Descriptive text
97	LOCMPT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
98	PCGROUPT	☐	OIRA_DESCR	TEXT50	CHAR	50	0	Descriptive text
99	CONVGRT	☐	OIRH_DESCR	TEXT50	CHAR	50	0	Descriptive text (IS-Oil, SSR)
100	VALGPT	☐	OIREVALDESC	TEXT50	CHAR	50	0	SSR PC: Validation group description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIR_HLM_ALV	ADDRNUM	OIFSMCADDR	ADDRNUM	REF
2	ROIR_HLM_ALV	BLCODE	OIFSBLCD	BLCODE	REF
3	ROIR_HLM_ALV	BRAND	OIRBBRAND	BRANDID	REF
4	ROIR_HLM_ALV	BUKRS	T001	BUKRS
5	ROIR_HLM_ALV	CONVGR	OIRHCVGRDEFC	CONVGR
6	ROIR_HLM_ALV	LOCAA	OIRBLAA	LOCAA
7	ROIR_HLM_ALV	LOCMP	OIRCTVKD	KALKS	KEY
8	ROIR_HLM_ALV	LOCVALUE	OIRBPBLVAL	LOCVALUE	REF
9	ROIR_HLM_ALV	LOCVDIFF	OIRBPBLVALD	LOCVDIFF	REF
10	ROIR_HLM_ALV	LOGSYS	TBDLS	LOGSYS
11	ROIR_HLM_ALV	MANDT	T000	MANDT		1	CN
12	ROIR_HLM_ALV	PBLTYP	OIFSPBLT	PBLTYP	REF
13	ROIR_HLM_ALV	PCGROUP	OIRAPCG	PCGROUP	REF	1	CN
14	ROIR_HLM_ALV	VALGP	OIREVALGP	VALGP	REF

History

Last changed by/on	SAP	20130529
SAP Release Created in