SAP ABAP Table ROIR_HLBT_ALV2 (Structure for Business Type level ALV Display (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_HLBT_ALV2	Table Relationship Diagram
Short Description	Structure for Business Type level ALV Display (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	Business location at business type level (IS-OIL SSR)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
4	RNBT	☐	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	OIRARNBT
5	BRAND	☐	OIRB_BRAND	OIRB_BRAND	CHAR	5	0	Location brand	OIRBBRAND
6	LOCVALUE	☐	OIRB_VAL	OIRB_VAL	CHAR	2	0	Relative location value	OIRBPBLVAL
7	LOCVDIFF	☐	OIRB_LOCVDIFF	OIRB_LOCVDIFF	CHAR	2	0	Location value differentiator	OIRBPBLVALD
8	STD_STYP	☐	OIRA_STD_STYP	OIRA_STYP	CHAR	4	0	Standard service type	OIRASTYP
9	LOCAA	☐	OIRB_LAA	OIRB_LAA	CHAR	5	0	Location area assignment	OIRBLAA
10	PR_AUTGR	☐	OIRC_PR_AUTGR	CHAR4	CHAR	4	0	SSR Pricing - Authorization group
11	LPRCLU	☐	OIRC_LPRCLU	OIRC_LPRCLU	CHAR	10	0	SSR Pricing - Location price cluster	OIRCLPC
12	SFDIFFGR	☐	OIRC_SFDIFFGR	OIRC_SFDIFFGR	CHAR	10	0	SSR Pricing - service type difference price group	OIRCSDPG
13	MDIFFGR	☐	OIRC_MDIFFGR	OIRC_MDIFFGR	CHAR	10	0	SSR Pricing - material difference price group	OIRCMDPG
14	F_PR	☐	OIRC_F_PR	OIRC_F_PR	CHAR	2	0	SSR - processing profile ID	OIRC_FUELS_PR
15	INV_BLOCK	☐	OIRC_IND_IBL	OIRC_IND_IBL	CHAR	1	0	SSR Meters - invoicing block indicator
16	BL_DATE_FROM	☐	OIRC_IB_D_FROM	DATE	DATS	8	0	SSR Meters - Invoicing block date from
17	BL_TIME_FROM	☐	OIRC_IB_T_FROM	TIME	TIMS	6	0	SSR Meters - Invoicing block time from
18	BL_DATE_TO	☐	OIRC_IB_D_TO	DATE	DATS	8	0	SSR Meters - Invoicing block date to
19	BL_TIME_TO	☐	OIRC_IB_T_TO	TIME	TIMS	6	0	SSR Meters - Invoicing block time to
20	ACC_GROUP	☐	OIRC_ACC_GR	OIRC_ACC_GR	CHAR	2	0	SSR Meters - meter access profile ID	OIRC_ACCGR
21	MATHANDGRP	☐	OIRA_MATHANDGRP	OIRA_MATHANDGRP	CHAR	2	0	Material handling group (IS-Oil SSR)	OIRAMATHANDGRPD
22	.INCLUDE	☐				0	0	Conversion Group Structure-Field Conversion(IS-OIL, SSR)
23	CONVGR	☐	OIRH_CONVGR	CHAR4	CHAR	4	0	SSR Interface conversion group definition (IS-Oil, SSR)	OIRHCVGRDEFC
24	LOGSYS	☐	OIRH_LOGSYS	LOGSYS	CHAR	10	0	Logical system for EDI	TBDLS
25	.INCLUDE	☐				0	0	Object link data status fields (IS-Oil MRN)
26	ERDAT	☐	OIF_ERDAT	DATS	DATS	8	0	Date Record Created on (Date)
27	ERZEIT	☐	OIF_ERZEIT	TIME	TIMS	6	0	Time Record Created at (Time)
28	ERNAM	☐	OIF_ERNAM	USNAM	CHAR	12	0	User who Created Record
29	AEDAT	☐	OIF_AEDAT	DATS	DATS	8	0	Date Record Changed on (Date)
30	AEZEIT	☐	OIF_AEZEIT	TIME	TIMS	6	0	Time when Record Was Changed
31	AENAM	☐	OIF_AENAM	USNAM	CHAR	12	0	User who Changed Record
32	BLOIND	☐	OIF_BLOIND	XFELD	CHAR	1	0	Block Indicator
33	DELIND	☐	OIF_DELIND	XFELD	CHAR	1	0	Deletion indicator
34	KOKRS_CC	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
35	KOSTL_CC	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
36	DATBI_CC	☐	DATBI	DATUM	DATS	8	0	Valid To Date
37	BEZEI_CC	☐	BEZEI	TEXT25	CHAR	25	0	Name of the controlling area
38	ABTEI_CC	☐	ABTEI	ABTEI	CHAR	12	0	Department
39	VERAK_CC	☐	VERAK	VERAK	CHAR	20	0	Person Responsible
40	NAME_CC	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
41	KOKRS_PC	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
42	PRCTR_PC	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
43	DATBI_PC	☐	DATBI	DATUM	DATS	8	0	Valid To Date
44	DATAB_PC	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
45	BEZEI_PC	☐	BEZEI	TEXT25	CHAR	25	0	Name of the controlling area
46	ABTEI_PC	☐	ABTEIL	ABTEI	CHAR	12	0	Department
47	NAME1_PC	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
48	VERAPC_PC	☐	VERAPC	VERAK	CHAR	20	0	Person Responsible for Profit Center
49	BUKRS_AM	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
50	ANLN1_AM	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
51	ANLN2_AM	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
52	TXT50_AM	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
53	ANLKL_AM	☐	ANLKL	ANLKL	CHAR	8	0	Asset Class	*
54	TXK50_AM	☐	TXT50_ANKT	TEXT50	CHAR	50	0	Asset class description
55	TPLNR_FL	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
56	PLTXT_FL	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
57	TPLMA_FL	☐	TPLMA	TPLNR	CHAR	30	0	Superior functional location	*
58	WERKS_SL	☐	OIF_WERKSL	WERKS	CHAR	4	0	Plant for storage location assignment entry (IS-Oil MRN)	*
59	LGORT_SL	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
60	NAME1_SL	☐	NAME1	TEXT30	CHAR	30	0	Name
61	BWKEY_SL	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
62	BUKRS_SL	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
63	BUTXT_SL	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
64	LGOBE_SL	☐	LGOBE	TEXT16	CHAR	16	0	Description of Storage Location
65	SPART_SL	☐	SPART	SPART	CHAR	2	0	Division	*
66	VTXTK_SL	☐	VTXTK	TEXT20	CHAR	20	0	Name
67	WERKS_PA	☐	OIF_WERKSW	WERKS	CHAR	4	0	Plant assignment entry (IS-Oil MRN)	*
68	NAME1_PA	☐	NAME1	TEXT30	CHAR	30	0	Name
69	BWKEY_PA	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
70	BUKRS_PA	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
71	LOCVALUET	☐	OIRB_DESCR	TEXT50	CHAR	50	0	Descriptive text
72	LOCVDIFFT	☐	OIRB_DESCR	TEXT50	CHAR	50	0	Descriptive text
73	LPRCLUT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
74	SFDIFFGRT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
75	MDIFFGRT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
76	F_PRT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
77	MATHANDGRPT	☐	OIRA_DESCR	TEXT50	CHAR	50	0	Descriptive text
78	STATUS	☐	OIRB_STATUS	OIRB_STATUS	CHAR	2	0	Location status	*
79	STATUST	☐	OIRA_DESCR	TEXT50	CHAR	50	0	Descriptive text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIR_HLBT_ALV2	ACC_GROUP	OIRC_ACCGR	ACCGR
2	ROIR_HLBT_ALV2	BRAND	OIRBBRAND	BRANDID	REF
3	ROIR_HLBT_ALV2	CONVGR	OIRHCVGRDEFC	CONVGR
4	ROIR_HLBT_ALV2	F_PR	OIRC_FUELS_PR	F_PR
5	ROIR_HLBT_ALV2	LOCAA	OIRBLAA	LOCAA
6	ROIR_HLBT_ALV2	LOCVALUE	OIRBPBLVAL	LOCVALUE	REF
7	ROIR_HLBT_ALV2	LOCVDIFF	OIRBPBLVALD	LOCVDIFF	REF
8	ROIR_HLBT_ALV2	LOGSYS	TBDLS	LOGSYS
9	ROIR_HLBT_ALV2	LPRCLU	OIRCLPC	LPRCLU	REF
10	ROIR_HLBT_ALV2	MANDT	T000	MANDT
11	ROIR_HLBT_ALV2	MATHANDGRP	OIRAMATHANDGRPD	MATHANDGRP
12	ROIR_HLBT_ALV2	MDIFFGR	OIRCMDPG	MDIFFGR	REF
13	ROIR_HLBT_ALV2	PBLNR	OIFSPBL	PBLNR	KEY	1	CN
14	ROIR_HLBT_ALV2	RNBT	OIRARNBT	RNBT	KEY	1	CN
15	ROIR_HLBT_ALV2	SFDIFFGR	OIRCSDPG	SFDIFFGR	REF
16	ROIR_HLBT_ALV2	STD_STYP	OIRASTYP	STYP	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in