| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PERNR_D | Allow NULL? |
| 3 | REINR | Trip Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | REINR | Allow NULL? |
| 4 | PLANNR | Travel Plan Number (Sequential Number) | nvarchar | 2 | 0 | NUMC | (N'00') | No | * | PLAN_NR | Allow NULL? |
| 5 | VARIANTE | Plan variant number (sequential number) | nvarchar | 2 | 0 | NUMC | (N'00') | No | | VARIANT_NR | Allow NULL? |
| 6 | VARIANTVRS | Version of travel plan | nvarchar | 2 | 0 | NUMC | (N'00') | No | FTPT_VARIANT | VARIANT_VERSION | Allow NULL? |
| 7 | REQUESTVRS | Version of travel request | nvarchar | 2 | 0 | NUMC | (N'00') | No | FTPT_REQ_HEAD | REQUEST_VERSION | Allow NULL? |
| 8 | PLAN_REQUEST | Plan Request Indicator | char | 1 | 0 | CHAR | (N' ') | No | | PLAN_REQUEST | Allow NULL? |
| 9 | REQUEST | Request number (sequential number | nvarchar | 2 | 0 | NUMC | (N'00') | No | | REQUEST_NR | Allow NULL? |
| 10 | ITINERARY_NUMBER | Number of trip segment | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ITINERARY_NUMBER | Allow NULL? |
| 11 | DATE_BEG | Beginning Date of Trip Segment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REQUEST_DATEBEG | Allow NULL? |
| 12 | TIME_BEG | Start Time of Trip Segment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | REQUEST_TIMEBEG | Allow NULL? |
| 13 | DATE_END | End Date of Trip Segment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REQUEST_DATEEND | Allow NULL? |
| 14 | TIME_END | End Time of Trip Segment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | REQUEST_TIMEEND | Allow NULL? |
| 15 | LOCATION_BEG | Starting location of trip segment | nvarchar | 59 | 0 | CHAR | (N' ') | Yes | | REQUEST_LOC_BEG | Allow NULL? |
| 16 | COUNTRY_BEG | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 17 | LOCATION_END | End location of trip segment | nvarchar | 59 | 0 | CHAR | (N' ') | Yes | | REQUEST_LOC_END | Allow NULL? |
| 18 | COUNTRY_END | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 19 | REQUEST_TYPE | Travel Item Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | REQUEST_TYPE | Allow NULL? |
| 20 | DEP_ARR | Arrival/Departure time | char | 1 | 0 | CHAR | (N' ') | Yes | | DEP_ARR | Allow NULL? |
| 21 | ITEM | Travel Request Item Number (Sequential Number) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | FTPT_ITEM | ITEMPOS_NR | Allow NULL? |
| 22 | REASON | Reason for trip (e.g. customer/requisitioner) | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | RKUND | Allow NULL? |
| 23 | ACTIVITY | Trip Activity Type | char | 1 | 0 | CHAR | (N' ') | Yes | TA20R | PLAN_ACTIVITY | Allow NULL? |
| 24 | FIRST_TCODE | Transaction Code | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | SYTCODE | Allow NULL? |
| 25 | COUNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 26 | REGION | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 27 | CITY | City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY1 | Allow NULL? |
| 28 | POST_CODE | City postal code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD1 | Allow NULL? |
| 29 | STREET | Street | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | AD_STREET | Allow NULL? |
| 30 | HOUSE_NUM | House Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM1 | Allow NULL? |
| 31 | LATITUDE | Geo location latitude | decimal | 15 | 12 | DEC | ((0)) | Yes | | GEOLAT | |
| 32 | LONGITUDE | Geo location longitude | decimal | 15 | 12 | DEC | ((0)) | Yes | | GEOLON | |
| 33 | IATA_FLIGHT | IATA Location for Airport | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | IATA_LOCATION_AIRPORT | Allow NULL? |
| 34 | IATA_GROUND | IATA Location for Hotel | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | IATA_LOCATION_HOTEL | Allow NULL? |
| 35 | TRAIN_STATION | International Unique Train Station Number | int | 10 | 0 | INT4 | ((0)) | Yes | | TRAIN_BFNR | Allow NULL? |
| 36 | RGION | Trip Country/Trip Country Group/Trip Region | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | RGION | Allow NULL? |
| 37 | CITY_DISTRICTADR | District | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY2 | Allow NULL? |
| 38 | CITY_CODEADR | City code for city/street file | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AD_CITYNUM | Allow NULL? |
| 39 | OFFICE_FIND | Grouping for Sales Office Determination | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OFFICE_FIND | Allow NULL? |
| 40 | OS_CODE | Other Travel Service: Code | char | 1 | 0 | CHAR | (N' ') | Yes | | OTHER_SERVICE_CODE | Allow NULL? |
| 41 | LOC_BEG_IATA | Start Location of Trip Segment (IATA) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | REQUEST_LOC_BEG_IATA | Allow NULL? |
| 42 | LOC_END_IATA | End Location of Trip Segment (IATA) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | REQUEST_LOC_END_IATA | Allow NULL? |
| 43 | OS_STATUS | Status of Other Service | char | 1 | 0 | CHAR | (N' ') | Yes | | OS_STATUS | Allow NULL? |
| 44 | OS_CONF_NUMBER | Confirmation Code of Other Service | nvarchar | 16 | 0 | NUMC | (N'0000000000000000') | Yes | | OS_CONF_NUMBER | Allow NULL? |
| 45 | PRICE | Price of Request | decimal | 10 | 2 | CURR | ((0)) | Yes | | REQUEST_PRICE | |
| 46 | CURRENCY | Currency of Request | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | REQUEST_CURRENCY | Allow NULL? |
| 47 | COMMENT1 | Comment About Request | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | REQUEST_COMMENT | Allow NULL? |
| 48 | KZREA | Trip Type: Statutory | char | 1 | 0 | CHAR | (N' ') | Yes | * | KZREA | Allow NULL? |
| 49 | BEREI | Trip Type: Enterprise-Specific | char | 1 | 0 | CHAR | (N' ') | Yes | * | BEREI | Allow NULL? |
| 50 | KZTKT | Trip Activity Type | char | 1 | 0 | CHAR | (N' ') | Yes | * | KZTKT | Allow NULL? |
| 51 | KZPRI | Private Stopover | char | 1 | 0 | CHAR | (N' ') | Yes | | KZPRI | Allow NULL? |
| 52 | SLEEP_AT_HOME | Overnight Stay at Home | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_SLEEP_AT_HOME | Allow NULL? |
