| 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 | USERNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SYUNAME | Allow NULL? |
| 3 | COST | Maximum No. of Account Assignment Objects in My Input Help | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | PTRV_F4_KEEPMAX_COST | |
| 4 | COUNTRY | Maximum Number of Trip Countries in My Input Help | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | PTRV_F4_KEEPMAX_COUNTRY | |
| 5 | TEXT | Maximum Number of Text Field Entries in My Input Help | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | PTRV_F4_KEEPMAX_TEXT | |
| 6 | FRAMEDATA | Control of Data Areas in Travel Management | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TOGGLE_DATA_AREA | Allow NULL? |
| 7 | EDIT_REASON | Control of Data Areas in Travel Management | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TOGGLE_DATA_AREA | Allow NULL? |
| 8 | AIRTRAVEL | Control of Data Areas in Travel Management | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TOGGLE_DATA_AREA | Allow NULL? |
| 9 | EDIT_ADVANCE | Control of Data Areas in Travel Management | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TOGGLE_DATA_AREA | Allow NULL? |
| 10 | COST_DIST | Control of Data Areas in Travel Management | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TOGGLE_DATA_AREA | Allow NULL? |
| 11 | FLAT_RATES | Control of Data Areas in Travel Management | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TOGGLE_DATA_AREA | Allow NULL? |
| 12 | DEDUCTIONS | Control of Data Areas in Travel Management | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TOGGLE_DATA_AREA | Allow NULL? |
| 13 | MILEAGE | Control of Data Areas in Travel Management | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TOGGLE_DATA_AREA | Allow NULL? |
| 14 | ITINERARY | Control of Data Areas in Travel Management | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TOGGLE_DATA_AREA | Allow NULL? |
| 15 | RECEIPTS | Control of Data Areas in Travel Management | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TOGGLE_DATA_AREA | Allow NULL? |
| 16 | ADDINFO | Control of Data Areas in Travel Management | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TOGGLE_DATA_AREA | Allow NULL? |
| 17 | RECEDIT | Control of Data Areas in Travel Management | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TOGGLE_DATA_AREA | Allow NULL? |
| 18 | REC_COST_DIS | Control of Data Areas in Travel Management | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_TOGGLE_DATA_AREA | Allow NULL? |
| 19 | SHOW_PICTURE | Display *.JPG, *.GIF, ... in HTML Form | char | 1 | 0 | CHAR | (N' ') | Yes | | PTP_SHOW_PICTURE | Allow NULL? |
| 20 | ENTER_RECEIPT | 'Enter' Adds Receipt to Receipt List | char | 1 | 0 | CHAR | (N' ') | Yes | | PTP_ENTER_RECEIPT | Allow NULL? |
| 21 | SHOW_LASTYEAR | Display Trips of Last Year Only | char | 1 | 0 | CHAR | (N' ') | Yes | | PTP_SHOW_LASTYEAR | Allow NULL? |
| 22 | SHOW_THISYEAR | Display Trips of Current Year Only | char | 1 | 0 | CHAR | (N' ') | Yes | | PTP_SHOW_THISYEAR | Allow NULL? |
| 23 | WINDOW_WIDTH | Width of Overview Area | char | 1 | 0 | CHAR | (N' ') | Yes | | PTP_WINDOW_WIDTH | Allow NULL? |
| 24 | SHOW_TREE | Parallel Display of Trip Overview Tree | char | 1 | 0 | CHAR | (N' ') | Yes | | PTP_SHOW_TREE | Allow NULL? |
| 25 | SHOW_ACTIVITIES | Display All Subsequent Activities | char | 1 | 0 | CHAR | (N' ') | Yes | | PTP_SHOW_ALL_ACTIVITIES | Allow NULL? |
| 26 | FAST_FILL | Uses 'Fast Fill' Table Type of Dynamic Documents | char | 1 | 0 | CHAR | (N' ') | Yes | | PTP_FAST_FILL | Allow NULL? |
| 27 | NO_PICTURES | Do Not Display Images | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_NO_PICTURES | Allow NULL? |
| 28 | NO_MAP | Do Not Display Map | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_NO_MAP | Allow NULL? |
| 29 | NO_HELP | Do Not Display Help Texts | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_NO_HELP | Allow NULL? |
