PTRV_SADD SAP (Trip Statistics - Add. Receipt Data) Table details
Dictionary Type: Table
Description: Trip Statistics - Add. Receipt Data
Description: Trip Statistics - Add. Receipt Data
Table field list including key, data, relationships and ABAP select examples
PTRV_SADD is a standard SAP Table which is used to store Trip Statistics - Add. Receipt Data data and is available within R/3 SAP systems depending on the version and release level.
The PTRV_SADD table consists of various fields, each holding specific information or linking keys about Trip Statistics - Add. Receipt Data data available in SAP. These include MANDT (Client), PERNR (Personnel Number), REINR (Trip Number), PERIO (Trip Period Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP PTRV_SADD table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
REINR | Trip Number | REINR | NUMC | 10 | REINR | ||||
PERIO | Trip Period Number | PTRV_PEROD | NUMC | 3 | PTRV_PEROD | ||||
RECEIPTNO | Document Number | NRBEL | CHAR | 3 | NRBEL | ||||
NO_BRFT | Number of Breakfasts | FRANZ | DEC | 2 | FRANZ | ||||
COUNTRY | Trip Country / Trip Country Group | LNDGR | CHAR | 3 | Assigned to domain | LNDGR | |||
REGION | Trip Country/Trip Country Group/Trip Region | RGION | CHAR | 5 | Assigned to domain | RGION | |||
TT_COMSP | Trip Type: Enterprise-Specific | BEREI | CHAR | 1 | Assigned to domain | BEREI | |||
FROM_DATE | From Date | FRDAT | DATS | 8 | DATUM | ||||
TO_DATE | To Date | TODAT | DATS | 8 | DATUM | ||||
MULTIPLI | Number | ERANZ | DEC | 3 | DEC3 | ||||
DESCRIPT | Description | ERDES | CHAR | 50 | TEXT50 | ||||
LOCATION | Location | ERPLC | CHAR | 50 | TEXT50 | ||||
BUS_PURPO | Business Purpose | BUSPU | CHAR | 50 | TEXT50 | ||||
BUS_REASON | Business Partners | BUSRE | CHAR | 50 | TEXT50 | ||||
CCOMP | Code of Payment Card Company | CCOMP | CHAR | 2 | Assigned to domain | CCOMP | |||
C_DOC | Document Number of Credit Card Receipt | C_DOC | CHAR | 20 | TEXT20 | ||||
C_TXT | Delivered Description of a Credit Card Transaction | C_TXT | CHAR | 50 | TEXT50 | ||||
P_CTG | Provider Category | PROVIDER_CATEGORY | CHAR | 1 | FTPD_PROVIDER_CATEGORY | ||||
P_PRV | Provider Code | PROVIDER_CODE | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
P_DOC | Document Number of a (Paper) Document | P_DOC | CHAR | 20 | TEXT20 | ||||
.INCLU--AP | 0 | ||||||||
N_STF | Number of Employees | CH_NO_STAFF | CHAR | 3 | CHAR3 | ||||
N_PTN | Number of Employees of Business Partners | CH_NO_PARTNERS | CHAR | 3 | CHAR3 | ||||
N_GST | Number of Additional Guests | CH_NO_GUESTS | CHAR | 3 | CHAR3 | ||||
ANZLU_DEC | Number of Lunches on Hotel Receipt | PTRV_ANZLU_DEC | DEC | 3 | DEC3 | ||||
ANZDI_DEC | Number of Dinners on Hotel Receipt | PTRV_ANZDI_DEC | DEC | 3 | DEC3 | ||||
BOOKED_PRICE | Booked Price from Travel Planning | BOOKED_PRICE | CURR | 10(2) | GESBE | ||||
DIFF_AMOUNT | Difference Amount | DIFF_AMOUNT | CURR | 10(2) | GESBE | ||||
DIFF_CURR | Currency of Difference Amount | DIFF_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
REASON | Reason for Difference | PTRV_REASON | CHAR | 50 | TEXT50 | ||||
AIR_DEPARTURE | IATA - Airport Location | AIR_LOCATION | CHAR | 3 | Assigned to domain | FTPD_IATA_LOCATION | |||
AIR_ARRIVAL | IATA - Airport Location | AIR_LOCATION | CHAR | 3 | Assigned to domain | FTPD_IATA_LOCATION | |||
AIRLINE | Airline | AIRLINE | CHAR | 3 | Assigned to domain | FTPD_PROVIDER_CODE | |||
AIR_CABIN_CLASS | Cabin Class | AIR_CABIN_CLASS | CHAR | 1 | FTPD_FLIGHT_CABIN | ||||
AIR_TIC_NUM | Ticket Number | PTRV_TICKET_NUMBER | CHAR | 15 | PTRV_TICKET_NUMBER | ||||
CAR_ODO_READ | Odometer Mileage | CAR_ODOMETER_READING | NUMC | 8 | |||||
SE_NAME | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
SE_STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
SE_CITY | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
SE_STA_PROV | District (US: County) | SE_STATE_PROVINCE | CHAR | 40 | TEXT40 | ||||
SE_COUNTRY | Country of Vendor | SE_COUNTRY | CHAR | 3 | Assigned to domain | LNDGR | |||
SE_POSTAL_CODE | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
SE_CUST_SER_PH | Customer Service Telephone No. of Vendor | SE_CUSTOMER_SERVICE_PHONE | CHAR | 30 | CHAR30 |
Key field | Non-key field |
How do I retrieve data from SAP table PTRV_SADD using ABAP code
The following ABAP code Example will allow you to do a basic selection on PTRV_SADD to SELECT all data from the tableDATA: WA_PTRV_SADD TYPE PTRV_SADD.
SELECT SINGLE *
FROM PTRV_SADD
INTO CORRESPONDING FIELDS OF WA_PTRV_SADD
WHERE...
How to access SAP table PTRV_SADD
Within an ECC or HANA version of SAP you can also view further information about PTRV_SADD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects