| 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 | PTRV_HEAD | PERNR_D | Allow NULL? |
| 3 | REINR | Trip Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | REINR | Allow NULL? |
| 4 | REQUESTVRS | Version of travel request | nvarchar | 2 | 0 | NUMC | (N'00') | No | | REQUEST_VERSION | Allow NULL? |
| 5 | PLAN_REQUEST | Plan Request Indicator | char | 1 | 0 | CHAR | (N' ') | No | | PLAN_REQUEST | Allow NULL? |
| 6 | LOCATION_END | Trip Destination | nvarchar | 59 | 0 | CHAR | (N' ') | Yes | | REQUEST_END | Allow NULL? |
| 7 | COUNTRY_END | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 8 | REQUEST_REASON | Reason for Trip | nvarchar | 59 | 0 | CHAR | (N' ') | Yes | | REQUEST_REASON | Allow NULL? |
| 9 | DATE_BEG | Beginning Date of Trip Segment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REQUEST_DATEBEG | Allow NULL? |
| 10 | TIME_BEG | Start Time of Trip Segment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | REQUEST_TIMEBEG | Allow NULL? |
| 11 | DATE_END | End Date of Trip Segment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REQUEST_DATEEND | Allow NULL? |
| 12 | TIME_END | End Time of Trip Segment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | REQUEST_TIMEEND | Allow NULL? |
| 13 | ACTIVITY_TYPE | Trip Activity Type | char | 1 | 0 | CHAR | (N' ') | Yes | TA20R | PLAN_ACTIVITY | Allow NULL? |
| 14 | ESTIMATED_COST | Estimated Total Cost of Trip | decimal | 13 | 2 | CURR | ((0)) | Yes | | PTRV_ESTIMATED_COST | |
| 15 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TRVWAERS | Allow NULL? |
| 16 | STATUS | Travel Plan Status | char | 1 | 0 | CHAR | (N' ') | Yes | | PLAN_STATUS | Allow NULL? |
| 17 | DATES | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 18 | TIMES | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEUHR | Allow NULL? |
| 19 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 20 | REPID | Change Report | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AEREP | Allow NULL? |
| 21 | DEPAR | Departure from Residence or Place of Work | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_DEPAR | Allow NULL? |
| 22 | CREATEDBY | User Who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ANGNAM | Allow NULL? |
| 23 | APPROVEDBY | Agent Who Approved the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | GENNAM | Allow NULL? |
| 24 | DELIVERY_DATE | Delivery Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REQ_DELIVERY_DATE | Allow NULL? |
| 25 | DELIVERY_LOC | Delivery Location | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | REQ_DELIVERY_LOC | Allow NULL? |
| 26 | DELIVERY_AREA | Delivery Area | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | REQ_DELIVERY_AREA | Allow NULL? |
| 27 | DELIVERY_EMPL | Recipient of Delivery | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | REQ_DELIVERY_EMPLOYEE | Allow NULL? |
| 28 | ARRIVAL_WORK | Arrival at Accommodations/New Place of Work | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_ARRIVAL_WORK | Allow NULL? |
| 29 | RETURN_WORK | Arrival at Home/Workplace | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_RETURN_WORK | Allow NULL? |
| 30 | T_ACTYPE | Trip Activity Type | char | 1 | 0 | CHAR | (N' ') | Yes | * | KZTKT | Allow NULL? |
| 31 | PERM_TRIP_APPR | Standing Approval of Business Trips | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_PERM_TRIP_APPROVAL | Allow NULL? |
| 32 | TT_STATU | Trip Type: Statutory | char | 1 | 0 | CHAR | (N' ') | Yes | * | KZREA | Allow NULL? |
| 33 | TT_COMSP | Trip Type: Enterprise-Specific | char | 1 | 0 | CHAR | (N' ') | Yes | * | BEREI | Allow NULL? |
| 34 | GWE | Request for Full Trip Segment Reimbursement | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_ANTRAG_GWE | Allow NULL? |
| 35 | EDI | Significant Official Interest | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_ERH_DIENST_INT | Allow NULL? |
| 36 | CARRY_OTH | Number of Employees Carpooling with Me (as the driver) | char | 1 | 0 | NUMC | (N'0') | Yes | | PTRV_NO_CARRY_OTHERS | Allow NULL? |
| 37 | CARRIED_BY_OTH | Employee is carpooling as a passenger with another employee | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_CARRIED_BY_OTHER | Allow NULL? |
| 38 | DATECOW | Date of Commencement of Work | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_PS_DATV1_DIENST | Allow NULL? |
| 39 | TIMECOW | Time at Which Work Commences | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PTRV_PS_UHRV1_DIENST | Allow NULL? |
| 40 | DATEEOW | Date on Which Work Ends | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PTRV_PS_DATB1_DIENST | Allow NULL? |
| 41 | TIMEEOW | Time at Which Work Ends | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PTRV_PS_UHRB1_DIENST | Allow NULL? |
