OIRBLAA
Location area assignment (IS-OIL SSR)Bekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel OIRBLAA.
SAP-tabel OIRBLAA heeft 4 primaire sleutelvelden: MANDT,RNBT,LOCAA,LOCAACTRY.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
OIRBLAA velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |
|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Sleutel RNBT | Business type | CHAR | 4 | 0 | OIRARNBT | OIRA_RNBT | |
| Sleutel LOCAA | Location area assignment | CHAR | 5 | 0 | OIRB_LAA | ||
| Sleutel LOCAACTRY | 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 |
OIRBLAA relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| 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 |