Table/Structure Field list used by SAP ABAP Program DBPTRVPSEL (Selektionen der logischen Datenbank PTRVP)
SAP ABAP Program
DBPTRVPSEL (Selektionen der logischen Datenbank PTRVP) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | FTPS_HOTEL_APPEND - COUNTRY | HRS Country Code | ||
| 2 | FTPS_HOTEL_APPEND - LOC_TEXT | Location for Hotel Search | ||
| 3 | FTPS_HOTEL_APPEND_HRS - COUNTRY | HRS Country Code | ||
| 4 | FTPS_HOTEL_APPEND_HRS - LOC_TEXT | Location for Hotel Search | ||
| 5 | FTPT_CAR - DATE_BEG | Start Date for Rental Car | ||
| 6 | FTPT_CAR - DATE_END | End date for car rental | ||
| 7 | FTPT_CAR - LOC_BEG | Rental Car Starting Location | ||
| 8 | FTPT_CAR - PROVIDER | Car Rental Provider | ||
| 9 | FTPT_CAR - STATUS | Car Rental Status | ||
| 10 | FTPT_FLIGHT - AIRLINE | Airline | ||
| 11 | FTPT_FLIGHT - DATE_DEP | Flight departure date | ||
| 12 | FTPT_FLIGHT - LOC_ARR | Flight Arrival Location | ||
| 13 | FTPT_FLIGHT - LOC_DEP | Departure Location | ||
| 14 | FTPT_FLIGHT - STATUS | Flight Status | ||
| 15 | FTPT_HOTEL - COUNTRY | HRS Country Code | ||
| 16 | FTPT_HOTEL - DATE_ARR | Arrival Date Hotel | ||
| 17 | FTPT_HOTEL - DATE_DEP | Departure Date Hotel | ||
| 18 | FTPT_HOTEL - HOTEL | Hotel Chain | ||
| 19 | FTPT_HOTEL - LOC | Hotel Location | ||
| 20 | FTPT_HOTEL - LOC_TEXT | Location for Hotel Search | ||
| 21 | FTPT_HOTEL - PROPERTY | Hotel Code (Key for an Individual Hotel) | ||
| 22 | FTPT_HOTEL - STATUS | Hotel Status | ||
| 23 | FTPT_OTHER - DATE_BEG | Start Date of Other Service | ||
| 24 | FTPT_OTHER - LOC_BEG | Start Location of Other Service (IATA) | ||
| 25 | FTPT_OTHER - LOC_BEG_TEXT | Start Location of Other Service | ||
| 26 | FTPT_OTHER - LOC_END | End Location of Other Service (IATA) | ||
| 27 | FTPT_OTHER - LOC_END_TEXT | End Location of Other Service | ||
| 28 | FTPT_OTHER - SERVICE_CODE | Other Travel Service: Code | ||
| 29 | FTPT_OTHER - STATUS | Status of Other Service | ||
| 30 | FTPT_TRAIN - CLASS | Train class | ||
| 31 | FTPT_TRAIN - DATE_DEP | Start date | ||
| 32 | FTPT_TRAIN - PROVIDER | Train provider | ||
| 33 | FTPT_TRAIN - STATUS | Status | ||
| 34 | FTPT_TRAIN - TRAIN_NR | Train number | ||
| 35 | FTPT_VARIANT - STATUS | Variant status | ||
| 36 | PA0001 - BEGDA | Start Date | ||
| 37 | PA0001 - BUKRS | Company Code | ||
| 38 | PA0001 - ENDDA | End Date | ||
| 39 | PA0001 - KOSTL | Cost Center | ||
| 40 | PA0001 - PERNR | Personnel number | ||
| 41 | PA0001 - PERSG | Employee Group | ||
| 42 | PA0001 - PERSK | Employee Subgroup | ||
| 43 | PAKEY - BEGDA | Start Date | ||
| 44 | PAKEY - ENDDA | End Date | ||
| 45 | PAKEY - PERNR | Personnel number | ||
| 46 | PS0001 - BUKRS | Company Code | ||
| 47 | PS0001 - KOSTL | Cost Center | ||
| 48 | PS0001 - PERSG | Employee Group | ||
| 49 | PS0001 - PERSK | Employee Subgroup | ||
| 50 | PS0001_SAP - BUKRS | Company Code | ||
| 51 | PS0001_SAP - KOSTL | Cost Center | ||
| 52 | PS0001_SAP - PERSG | Employee Group | ||
| 53 | PS0001_SAP - PERSK | Employee Subgroup | ||
| 54 | PTP60 - REINR | Trip Number | ||
| 55 | PTP81 - ALLOC_AMOUNT | Amount per Account Assignment | ||
| 56 | PTP81 - COSTCENTER | Cost Center | ||
| 57 | PTP81 - CO_AREA | Controlling Area | ||
| 58 | PTP81 - CURRENCY | Currency Key | ||
| 59 | PTP81 - INTERNAL_ORDER | Order Number | ||
| 60 | PTP81 - PROJECT_EXT_ID | Project Number (cProjects) | ||
| 61 | PTP81 - SALES_ORD | Sales Order Number | ||
| 62 | PTP81 - S_ORD_ITEM | Item number in Sales Order | ||
| 63 | PTP81 - TASK_ROLE_EXT_ID | Task Number (cProjects) | ||
| 64 | PTP81 - WBS_ELEMT | Work Breakdown Structure Element (WBS Element) | ||
| 65 | PTP81_APPEND - PROJECT_EXT_ID | Project Number (cProjects) | ||
| 66 | PTP81_APPEND - TASK_ROLE_EXT_ID | Task Number (cProjects) | ||
| 67 | PTPHD - DATB1 | End Date of Trip Segment | ||
| 68 | PTPHD - DATV1 | Beginning Date of Trip Segment | ||
| 69 | PTPHD - KUNDE | Reason for Trip (for example, customer/requisitioner) | ||
| 70 | PTPHD - ZLAND | Trip Country / Trip Country Group | ||
| 71 | PTPHD - ZORT1 | Location | ||
| 72 | PTPPD - ABREC | Open / To be Settled / Settled (Indicator) | ||
| 73 | PTPPD - ANTRG | Travel Request or Trip Approved (Indicator) | ||
| 74 | PTPPD - UEBDT | Data Medium Exchange Transfer (Indicator) | ||
| 75 | PTPPD - UEBLG | HR Payroll Transfer (Indicator) | ||
| 76 | PTPPD - UEBRF | FI Transfer (Indicator) | ||
| 77 | PTPSD - CURRENCY | Currency Key | ||
| 78 | PTPSD - SUM_ADVANC | Total Advances for a Trip | ||
| 79 | PTPSD - SUM_PAIDCO | Travel Expenses Paid by Company | ||
| 80 | PTPSD - SUM_PAYOUT | Payment Amount | ||
| 81 | PTPSD - SUM_REIMBU | Reimbursement Amount for a Trip | ||
| 82 | PTPSD - TRIP_TOTAL | Total Cost of Trip | ||
| 83 | PTP_VAT_DETAILS - CITY | City | ||
| 84 | PTP_VAT_DETAILS - HOUSE_NUM | House Number | ||
| 85 | PTP_VAT_DETAILS - INTCA | Country ISO code | ||
| 86 | PTP_VAT_DETAILS - NAME | Name 1 | ||
| 87 | PTP_VAT_DETAILS - POST_CODE | City postal code | ||
| 88 | PTP_VAT_DETAILS - STCD1 | Tax Number 1 | ||
| 89 | PTP_VAT_DETAILS - STCEG | VAT Registration Number | ||
| 90 | PTP_VAT_DETAILS - STREET | Street | ||
| 91 | PTRV_HEAD - DATB1 | End Date of Trip Segment | ||
| 92 | PTRV_HEAD - DATV1 | Beginning Date of Trip Segment | ||
| 93 | PTRV_HEAD - KUNDE | Reason for Trip (for example, customer/requisitioner) | ||
| 94 | PTRV_HEAD - REINR | Trip Number | ||
| 95 | PTRV_HEAD - ZLAND | Trip Country / Trip Country Group | ||
| 96 | PTRV_HEAD - ZORT1 | Location | ||
| 97 | PTRV_PERIO - ABREC | Open / To be Settled / Settled (Indicator) | ||
| 98 | PTRV_PERIO - ANTRG | Travel Request or Trip Approved (Indicator) | ||
| 99 | PTRV_PERIO - UEBDT | Data Medium Exchange Transfer (Indicator) | ||
| 100 | PTRV_PERIO - UEBLG | HR Payroll Transfer (Indicator) | ||
| 101 | PTRV_PERIO - UEBRF | FI Transfer (Indicator) | ||
| 102 | PTRV_SCOS - ALLOC_AMOUNT | Amount per Account Assignment | ||
| 103 | PTRV_SCOS - COSTCENTER | Cost Center | ||
| 104 | PTRV_SCOS - CO_AREA | Controlling Area | ||
| 105 | PTRV_SCOS - CURRENCY | Currency Key | ||
| 106 | PTRV_SCOS - INTERNAL_ORDER | Order Number | ||
| 107 | PTRV_SCOS - PROJECT_EXT_ID | Project Number (cProjects) | ||
| 108 | PTRV_SCOS - SALES_ORD | Sales Order Number | ||
| 109 | PTRV_SCOS - S_ORD_ITEM | Item number in Sales Order | ||
| 110 | PTRV_SCOS - TASK_ROLE_EXT_ID | Task Number (cProjects) | ||
| 111 | PTRV_SCOS - WBS_ELEMT | Work Breakdown Structure Element (WBS Element) | ||
| 112 | PTRV_SHDR - CURRENCY | Currency Key | ||
| 113 | PTRV_SHDR - SUM_ADVANC | Total Advances for a Trip | ||
| 114 | PTRV_SHDR - SUM_PAIDCO | Travel Expenses Paid by Company | ||
| 115 | PTRV_SHDR - SUM_PAYOUT | Payment Amount | ||
| 116 | PTRV_SHDR - SUM_REIMBU | Reimbursement Amount for a Trip | ||
| 117 | PTRV_SHDR - TRIP_TOTAL | Total Cost of Trip | ||
| 118 | PTRV_SREC - ABOVE_LIMIT | Customizing Limit for Travel Expense Type Exceeded | ||
| 119 | PTRV_SREC - EXP_TYPE | Travel Expense Type | ||
| 120 | PTRV_SREC - LOC_AMOUNT | Receipt amount in local currency | ||
| 121 | PTRV_SREC - LOC_CURR | Currency Key | ||
| 122 | PTRV_SREC - PAID_COM | Paid by Company | ||
| 123 | PTRV_SREC - REC_DATE | Receipt Date | ||
| 124 | PTRV_STATS_DOCU - CURRENT_VERSION | Select Current Trip Version Only | ||
| 125 | PTRV_VATDETAIL - CITY | City | ||
| 126 | PTRV_VATDETAIL - HOUSE_NUM | House Number | ||
| 127 | PTRV_VATDETAIL - INTCA | Country ISO code | ||
| 128 | PTRV_VATDETAIL - NAME | Name 1 | ||
| 129 | PTRV_VATDETAIL - POST_CODE | City postal code | ||
| 130 | PTRV_VATDETAIL - STCD1 | Tax Number 1 | ||
| 131 | PTRV_VATDETAIL - STCEG | VAT Registration Number | ||
| 132 | PTRV_VATDETAIL - STREET | Street | ||
| 133 | RPRXXXXX - RADIO0 | Checkbox | ||
| 134 | RPRXXXXX - RADIO1 | Checkbox | ||
| 135 | RPRXXXXX - RADIO2 | Checkbox |