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

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in