SAP ABAP Table OIRBPBLB (Business location at business type level (IS-OIL SSR))

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-SSR (Application Component) Service Station Retailing
     ⤷ OIR_B (Package) SSR Service Station Base (IS-Oil Sevice Station Retailing)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIRBPBLB	Table Relationship Diagram
Short Description	Business location at business type level (IS-OIL SSR)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PBLNR	☑	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
3	RNBT	☑	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	OIRARNBT
4	BRAND	☐	OIRB_BRAND	OIRB_BRAND	CHAR	5	0	Location brand	OIRBBRAND
5	LOCVALUE	☐	OIRB_VAL	OIRB_VAL	CHAR	2	0	Relative location value	OIRBPBLVAL
6	LOCVDIFF	☐	OIRB_LOCVDIFF	OIRB_LOCVDIFF	CHAR	2	0	Location value differentiator	OIRBPBLVALD
7	STD_STYP	☐	OIRA_STD_STYP	OIRA_STYP	CHAR	4	0	Standard service type	OIRASTYP
8	LOCAA	☐	OIRB_LAA	OIRB_LAA	CHAR	5	0	Location area assignment	OIRBLAA
9	PR_AUTGR	☐	OIRC_PR_AUTGR	CHAR4	CHAR	4	0	SSR Pricing - Authorization group
10	LPRCLU	☐	OIRC_LPRCLU	OIRC_LPRCLU	CHAR	10	0	SSR Pricing - Location price cluster	OIRCLPC
11	SFDIFFGR	☐	OIRC_SFDIFFGR	OIRC_SFDIFFGR	CHAR	10	0	SSR Pricing - service type difference price group	OIRCSDPG
12	MDIFFGR	☐	OIRC_MDIFFGR	OIRC_MDIFFGR	CHAR	10	0	SSR Pricing - material difference price group	OIRCMDPG
13	F_PR	☐	OIRC_F_PR	OIRC_F_PR	CHAR	2	0	SSR - processing profile ID	OIRC_FUELS_PR
14	INV_BLOCK	☐	OIRC_IND_IBL	OIRC_IND_IBL	CHAR	1	0	SSR Meters - invoicing block indicator
15	BL_DATE_FROM	☐	OIRC_IB_D_FROM	DATE	DATS	8	0	SSR Meters - Invoicing block date from
16	BL_TIME_FROM	☐	OIRC_IB_T_FROM	TIME	TIMS	6	0	SSR Meters - Invoicing block time from
17	BL_DATE_TO	☐	OIRC_IB_D_TO	DATE	DATS	8	0	SSR Meters - Invoicing block date to
18	BL_TIME_TO	☐	OIRC_IB_T_TO	TIME	TIMS	6	0	SSR Meters - Invoicing block time to
19	ACC_GROUP	☐	OIRC_ACC_GR	OIRC_ACC_GR	CHAR	2	0	SSR Meters - meter access profile ID	OIRC_ACCGR
20	MATHANDGRP	☐	OIRA_MATHANDGRP	OIRA_MATHANDGRP	CHAR	2	0	Material handling group (IS-Oil SSR)	OIRAMATHANDGRPD
21	.INCLUDE	☐				0	0	Conversion Group Structure-Field Conversion(IS-OIL, SSR)
22	CONVGR	☐	OIRH_CONVGR	CHAR4	CHAR	4	0	SSR Interface conversion group definition (IS-Oil, SSR)	OIRHCVGRDEFC
23	LOGSYS	☐	OIRH_LOGSYS	LOGSYS	CHAR	10	0	Logical system for EDI	TBDLS
24	.INCLUDE	☐				0	0	Object link data status fields (IS-Oil MRN)
25	ERDAT	☐	OIF_ERDAT	DATS	DATS	8	0	Date Record Created on (Date)
26	ERZEIT	☐	OIF_ERZEIT	TIME	TIMS	6	0	Time Record Created at (Time)
27	ERNAM	☐	OIF_ERNAM	USNAM	CHAR	12	0	User who Created Record
28	AEDAT	☐	OIF_AEDAT	DATS	DATS	8	0	Date Record Changed on (Date)
29	AEZEIT	☐	OIF_AEZEIT	TIME	TIMS	6	0	Time when Record Was Changed
30	AENAM	☐	OIF_AENAM	USNAM	CHAR	12	0	User who Changed Record
31	BLOIND	☐	OIF_BLOIND	XFELD	CHAR	1	0	Block Indicator
32	DELIND	☐	OIF_DELIND	XFELD	CHAR	1	0	Deletion indicator

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in