SAP Table
OIRBLAA Location area assignment (IS-OIL SSR)
SAP table OIRBLAA has 4 primary key fields being MANDT,RNBT,LOCAA,LOCAACTRY.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
OIRBLAA columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyRNBT | Business type | CHAR | 4 | 0 | OIRARNBT | OIRA_RNBT | |
| KeyLOCAA | Location area assignment | CHAR | 5 | 0 | OIRB_LAA | ||
| KeyLOCAACTRY | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |
| LOCREG | Location region | CHAR | 4 | 0 | OIRBREG | OIRB_REGION | |
| LOCAREA | Location area | CHAR | 4 | 0 | OIRBAREA | OIRB_AREA | |
| LOCSAREA | Location sub-area | CHAR | 4 | 0 | OIRBSAREA | OIRB_SAREA |
/ Relationships
OIRBLAA foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| OIRBLAA | LOCAACTRY | T005 | Countries | MANDT |
| OIRBLAA | LOCAACTRY | T005 | Countries | LAND1 |
| OIRBLAA | LOCAREA | OIRBAREA | Location Area (IS-OIL SSR) | MANDT |
| OIRBLAA | LOCAREA | OIRBAREA | Location Area (IS-OIL SSR) | AREACTRY |
| OIRBLAA | LOCAREA | OIRBAREA | Location Area (IS-OIL SSR) | LOCAREA |
| OIRBLAA | LOCREG | OIRBREG | Location region indicator (IS-OIL SSR) | MANDT |
| OIRBLAA | LOCREG | OIRBREG | Location region indicator (IS-OIL SSR) | REGCTRY |
| OIRBLAA | LOCREG | OIRBREG | Location region indicator (IS-OIL SSR) | LOCREGION |
| OIRBLAA | LOCSAREA | OIRBSAREA | Location sub area (IS-OIL SSR) | MANDT |
| OIRBLAA | LOCSAREA | OIRBSAREA | Location sub area (IS-OIL SSR) | SAREACTRY |
| OIRBLAA | LOCSAREA | OIRBSAREA | Location sub area (IS-OIL SSR) | LOCSAREA |
| OIRBLAA | MANDT | T000 | Clients | MANDT |
| OIRBLAA | RNBT | OIRARNBT | Retail Network Business Types | MANDT |