SAP ABAP Table ROIRB0200 (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)
⤷ 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 | ROIRB0200 | 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 | PBLNR | OIF_PBLNR | OIF_PBLNR | CHAR | 10 | 0 | Business location identifier (IS-Oil MRN) | OIFSPBL | |
2 | RNBT | OIRA_RNBT | OIRA_RNBT | CHAR | 4 | 0 | Business type | OIRBPBLB | |
3 | COMPPBLNR | OIF_PBLNR | OIF_PBLNR | CHAR | 10 | 0 | Business location identifier (IS-Oil MRN) | OIRBPBLB | |
4 | VALID_TO | OIRB_DATETO | DATUM | DATS | 8 | 0 | Valid to date | ||
5 | VALID_FROM | OIRB_DATEFROM | DATUM | DATS | 8 | 0 | Valid from date | ||
6 | DOMID | OIRB_DOMID | CHAR2 | CHAR | 2 | 0 | Dominance indicator | ||
7 | DIST | OIRB_DIST | NUMC4 | NUMC | 4 | 0 | Distance from competitor's location | ||
8 | DISTUOM | OIRB_DISTUOM | MEINS | UNIT | 3 | 0 | Distance unit of measurement | T006 | |
9 | EXTCOMPNR | OIRB_EXTCOMPNR | NUMC2 | NUMC | 2 | 0 | External competitor number at location | ||
10 | NAME1 | AD_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 | ||
11 | BRAND | OIRB_BRAND | OIRB_BRAND | CHAR | 5 | 0 | Location brand | * | |
12 | CREDITCARDIND | OIRB_COMPPBL_CCIND | CHAR1 | CHAR | 1 | 0 | SSR PC: Competitor location Credit card indicator | ||
13 | FLEETCARDIND | OIRB_COMPPBL_FCIND | CHAR1 | CHAR | 1 | 0 | SSR PC: Competitor location Fleet card indicator | ||
14 | ECCARDIND | OIRB_COMPPBL_ECIND | CHAR1 | CHAR | 1 | 0 | SSR PC: Competitor location EC card indicator | ||
15 | CHKBOX | OIF_CHKBOX | OIF_CHKBOX | CHAR | 1 | 0 | Checkbox for loop processing | ||
16 | RATE | KBETR_KOND | WERTV6 | CURR | 11 | 2 | Rate (condition amount or percentage) where no scale exists | ||
17 | KONWA | KONWA | WAERS | CUKY | 5 | 0 | Rate unit (currency or percentage) | * | |
18 | KPEIN | KPEIN | KPEIN | DEC | 5 | 0 | Condition pricing unit | ||
19 | KMEIN | KMEIN | MEINS | UNIT | 3 | 0 | Condition Unit | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIRB0200 | COMPPBLNR | OIRBPBLB | PBLNR | KEY | 1 | CN |
2 | ROIRB0200 | DISTUOM | T006 | MSEHI | |||
3 | ROIRB0200 | PBLNR | OIFSPBL | PBLNR | 1 | CN | |
4 | ROIRB0200 | RNBT | OIRBPBLB | RNBT | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |