SAP table STRAVELAG (Travel agency)
SAP table STRAVELAG has 2 primary key fields being MANDT,AGENCYNUM.
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 | S_MANDT | |
| AGENCYNUM | Travel Agency Number | NUMC | 8 | 0 | SBUSPART | S_AGNCYNUM | |
| NAME | Travel agency name | CHAR | 25 | 0 | S_AGNCYNAM | ||
| STREET | Street | CHAR | 30 | 0 | S_STREET | ||
| POSTBOX | PO Box | CHAR | 10 | 0 | S_POSTBOX | ||
| POSTCODE | Postal Code | CHAR | 10 | 0 | POSTCODE | ||
| CITY | City | CHAR | 25 | 0 | CITY | ||
| COUNTRY | Country Code | CHAR | 3 | 0 | S_COUNTRY | ||
| REGION | Region | CHAR | 3 | 0 | S_REGION | ||
| TELEPHONE | Telephone number of flight customer | CHAR | 30 | 0 | S_PHONENO | ||
| URL | Travel agency homepage URL | CHAR | 255 | 0 | S_URL | ||
| LANGU | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| CURRENCY | Travel agency local currency | CUKY | 5 | 0 | * | S_CURR_AG |
STRAVELAG foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 STRAVELAG | AGENCYNUM | SBUSPART | Airline Partner | MANDANT |