SAP table T706O (Names for Trip Country/Trip Country Group/Trip Region)
SAP table T706O has 5 primary key fields being MANDT,SPRAS,MOREI,LAND1,RGION.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| SPRAS | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| MOREI | Trip Provision Variant | CHAR | 2 | 0 | T702N | MOREI | |
| LAND1 | Trip Country / Trip Country Group | CHAR | 3 | 0 | LNDGR | ||
| RGION | Trip Country/Trip Country Group/Trip Region | CHAR | 5 | 0 | T702O | RGION | |
| TEXT25 | Name of Trip Country/Country Group/Region | CHAR | 25 | 0 | TEXT_RGION |
T706O foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T706O | MOREI | T702N | Trip Provision Variants | MOREI |
| 1 T706O | RGION | T702O | Trip country/Trip region/Trip country group | MOREI |
| 1 T706O | RGION | T702O | Trip country/Trip region/Trip country group | LAND1 |
| 1 T706O | RGION | T702O | Trip country/Trip region/Trip country group | RGION |
| 0 T706O | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |