SAP ABAP Table OIRBPBLPBL (Link Table Location-Loc(Competitor assgnmnt)(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	OIRBPBLPBL	Table Relationship Diagram
Short Description	Link Table Location-Loc(Competitor assgnmnt)(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	COMPPBLNR	☑	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIRBPBLB
5	VALID_TO	☑	OIRB_DATETO	DATUM	DATS	8	0	Valid to date
6	VALID_FROM	☐	OIRB_DATEFROM	DATUM	DATS	8	0	Valid from date
7	DOMID	☐	OIRB_DOMID	CHAR2	CHAR	2	0	Dominance indicator
8	DIST	☐	OIRB_DIST	NUMC4	NUMC	4	0	Distance from competitor's location
9	DISTUOM	☐	OIRB_DISTUOM	MEINS	UNIT	3	0	Distance unit of measurement	T006
10	EXTCOMPNR	☐	OIRB_EXTCOMPNR	NUMC2	NUMC	2	0	External competitor number at location

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIRBPBLPBL	COMPPBLNR	OIRBPBLB	PBLNR	KEY	1	CN
2	OIRBPBLPBL	DISTUOM	T006	MSEHI	REF	1	CN
3	OIRBPBLPBL	MANDT	T000	MANDT	KEY
4	OIRBPBLPBL	PBLNR	OIFSPBL	PBLNR	KEY	1	CN
5	OIRBPBLPBL	RNBT	OIRARNBT	RNBT

History

Last changed by/on	SAP	20050224
SAP Release Created in