PTRV_WEB_RECEIPTS_EXT_2 SAP (Trip Receipts for External Representation) Structure details

Dictionary Type: Structure
Description: Trip Receipts for External Representation




ABAP Code to SELECT data from PTRV_WEB_RECEIPTS_EXT_2
Related tables to PTRV_WEB_RECEIPTS_EXT_2
Access table PTRV_WEB_RECEIPTS_EXT_2




Structure field list including key, data, relationships and ABAP select examples

PTRV_WEB_RECEIPTS_EXT_2 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Trip Receipts for External Representation" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_PTRV_WEB_RECEIPTS_EXT_2 TYPE PTRV_WEB_RECEIPTS_EXT_2.

The PTRV_WEB_RECEIPTS_EXT_2 table consists of various fields, each holding specific information or linking keys about Trip Receipts for External Representation data available in SAP. These include RECEIPTNO (Document Number), EXP_TYPE (Travel Expense Type), VISIBLESPK (Checkbox), INPUTSPK (Checkbox).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP PTRV_WEB_RECEIPTS_EXT_2 structure 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
RECEIPTNODocument Number NRBELCHAR3NRBEL
EXP_TYPETravel Expense Type SPKZLCHAR4T706B1SPKZLRSASH_EXPENSE_TYPES
.INCLU-SPK 0
VISIBLESPKCheckbox XFELDCHAR1XFELD
INPUTSPKCheckbox XFELDCHAR1XFELD
REQUIREDSPKCheckbox XFELDCHAR1XFELD
EXP_CATETravel Expense Category BELARCHAR1BELAR
.INCLU-PAP 0
VISIBLEPAPCheckbox XFELDCHAR1XFELD
INPUTPAPCheckbox XFELDCHAR1XFELD
REQUIREDPAPCheckbox XFELDCHAR1XFELD
PAPER_RECEIPTPaper Receipt Exists PAPER_RECEIPT_CORECHAR1XFELD
REC_AMOUNTAmount on Individual Receipt PTRV_WEB_REC_AMOUNTCURR10(2) PTRV_WEB_REC_AMOUNT
.INCLU-AMN 0
VISIBLEAMNCheckbox XFELDCHAR1XFELD
INPUTAMNCheckbox XFELDCHAR1XFELD
REQUIREDAMNCheckbox XFELDCHAR1XFELD
REC_CURRCurrency Key WAERSCUKY5TCURCWAERSFWS
.INCLU-CUR 0
VISIBLECURCheckbox XFELDCHAR1XFELD
INPUTCURCheckbox XFELDCHAR1XFELD
REQUIREDCURCheckbox XFELDCHAR1XFELD
REC_RATEExchange Rate UKURS_CURRDEC9(5) EXCRTUKURS
.INCLU-RAT 0
VISIBLERATCheckbox XFELDCHAR1XFELD
INPUTRATCheckbox XFELDCHAR1XFELD
REQUIREDRATCheckbox XFELDCHAR1XFELD
S_FACTORRatio for the 'From' Currency Units FFACT_CURRDEC9DEC9
T_FACTORRatio for the 'To' Currency Units TFACT_CURRDEC9DEC9
.INCLU-DAT 0
VISIBLEDATCheckbox XFELDCHAR1XFELD
INPUTDATCheckbox XFELDCHAR1XFELD
REQUIREDDATCheckbox XFELDCHAR1XFELD
REC_DATEReceipt Date BELDTDATS8REDAT
PAY_AMOUNTAmount on Individual Receipt GESBBCURR10(2) GESBE
.INCLU-PAM 0
VISIBLEPAMCheckbox XFELDCHAR1XFELD
INPUTPAMCheckbox XFELDCHAR1XFELD
REQUIREDPAMCheckbox XFELDCHAR1XFELD
PAY_CURRAccounting Currency of Expense Receipt or Advance PTRV_PAYCURRCUKY5TCURCWAERS
.INCLU-PCU 0
VISIBLEPCUCheckbox XFELDCHAR1XFELD
INPUTPCUCheckbox XFELDCHAR1XFELD
REQUIREDPCUCheckbox XFELDCHAR1XFELD
TAX_CODETax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
TAXJURCODETax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
.INCLU-STX 0
VISIBLESTXCheckbox XFELDCHAR1XFELD
INPUTSTXCheckbox XFELDCHAR1XFELD
REQUIREDSTXCheckbox XFELDCHAR1XFELD
SHORTTXTShort Receipt Information TXBELCHAR10TXBEL
COUNTRYTrip Country / Trip Country Group LNDGRCHAR3Assigned to domainLNDGR
REGIONTrip Country/Trip Country Group/Trip Region RGIONCHAR5Assigned to domainRGION
FROM_DATEFrom Date FRDATDATS8DATUM
TO_DATETo Date TODATDATS8DATUM
NO_UNITNumber ERANZDEC3DEC3
NO_BRFTNumber of Breakfasts NUBRFCHAR2CHAR2
DESCRIPTDescription ERDESCHAR50TEXT50
LOCATIONLocation ERPLCCHAR50TEXT50
BUS_PURPOBusiness Purpose BUSPUCHAR50TEXT50
.INCLU-BPP 0
VISIBLEBPPCheckbox XFELDCHAR1XFELD
INPUTBPPCheckbox XFELDCHAR1XFELD
REQUIREDBPPCheckbox XFELDCHAR1XFELD
BUS_REASONBusiness Partners BUSRECHAR50TEXT50
CCOMPCode of Payment Card Company CCOMPCHAR2Assigned to domainCCOMP
.INCLU-CCP 0
VISIBLECCPCheckbox XFELDCHAR1XFELD
INPUTCCPCheckbox XFELDCHAR1XFELD
REQUIREDCCPCheckbox XFELDCHAR1XFELD
C_DOCDocument Number of Credit Card Receipt C_DOCCHAR20TEXT20
.INCLU-CDC 0
VISIBLECDCCheckbox XFELDCHAR1XFELD
INPUTCDCCheckbox XFELDCHAR1XFELD
REQUIREDCDCCheckbox XFELDCHAR1XFELD
C_TXTDelivered Description of a Credit Card Transaction C_TXTCHAR50TEXT50
.INCLU-CTX 0
VISIBLECTXCheckbox XFELDCHAR1XFELD
INPUTCTXCheckbox XFELDCHAR1XFELD
REQUIREDCTXCheckbox XFELDCHAR1XFELD
CCARDCredit Card Number C_NUMCHAR19TEXT19
CEKEYTransaction Key (Supplied by Credit Card Company) CEKEYCHAR10CEKEY
P_CTGProvider Category PROVIDER_CATEGORYCHAR1FTPD_PROVIDER_CATEGORY
P_PRVProvider Code PROVIDER_CODECHAR3Assigned to domainFTPD_PROVIDER_CODE
P_DOCDocument Number of a (Paper) Document P_DOCCHAR20TEXT20
N_STFNumber of Employees CH_NO_STAFFCHAR3CHAR3
N_PTNNumber of Employees of Business Partners CH_NO_PARTNERSCHAR3CHAR3
N_GSTNumber of Additional Guests CH_NO_GUESTSCHAR3CHAR3
PAID_COMPaid by Company BEZFACHAR1XFELDTRV_PAID_COMPANY
PAYOUTService Provider PAYOTCHAR2Assigned to domainPAYOT
ABOVE_LIMITCustomizing Limit for Travel Expense Type Exceeded PTRV_ABOVE_LIMITCHAR1P_ATYPE
COMING_FROM_PLANProtection Indicator of Entry PROTECTCHAR1PRTV_PROTECT
REF_NOReference Document Number NOBELCHAR3NRBEL
.INCLU-ROK 0
VISIBLEROKCheckbox XFELDCHAR1XFELD
INPUTROKCheckbox XFELDCHAR1XFELD
REQUIREDROKCheckbox XFELDCHAR1XFELD
RECEIPT_OKExpense Receipt Checked RECEIPT_VALIDATED_CORECHAR1XFELD
TT_COMSPTrip Type: Enterprise-Specific BEREICHAR1Assigned to domainBEREI
CHECK_RESULTResult of Receipt Check RECEIPT_CHECK_RESULTCHAR1CHECK_RESULT
DISPLAY_ONLYIndividual Receipt Can Only Be Displayed RECEIPT_DISPLAY_ONLYCHAR1XFELD
EDITOREditor in Web Structures PTRV_WEB_EDITORSTRG0
EXP_TYPE_ORIGINALTravel Expense Type SPKZLCHAR4Assigned to domainSPKZLRSASH_EXPENSE_TYPES
EXP_TYPE1Travel Expense Type SPKZLCHAR4Assigned to domainSPKZLRSASH_EXPENSE_TYPES
EXP_TYPE2Travel Expense Type SPKZLCHAR4Assigned to domainSPKZLRSASH_EXPENSE_TYPES
EXP_TYPE3Travel Expense Type SPKZLCHAR4Assigned to domainSPKZLRSASH_EXPENSE_TYPES
EXP_TYPE4Travel Expense Type SPKZLCHAR4Assigned to domainSPKZLRSASH_EXPENSE_TYPES
EXP_TYPE5Travel Expense Type SPKZLCHAR4Assigned to domainSPKZLRSASH_EXPENSE_TYPES
EXP_TYPE6Travel Expense Type SPKZLCHAR4Assigned to domainSPKZLRSASH_EXPENSE_TYPES
PRIEXPExpense Type for Private Shares PRIEXPCHAR4Assigned to domainSPKZL
NO_LUNCHNumber of Lunches in Hotel Receipt PTRV_ANZLUCHAR3CHAR3
NO_DINNERNumber of Dinners in Hotel Receipt PTRV_ANZDICHAR3CHAR3
FULL_AMOUNT_REIMBReimbursement of Accommodations Receipt in Full PTRV_GENEHM_U_BELEGCHAR1CHAR1
PAPER_MISSINGRequired Paper Receipt Is Missing PAPER_MISSINGCHAR1P_ATYPE
BOOKED_PRICEBooked Price from Travel Planning BOOKED_PRICECURR10(2) GESBE
BOOKED_CURRBooked Currency from Planning BOOKED_CURRCUKY5Assigned to domainWAERS
DIFF_AMOUNTDifference Amount DIFF_AMOUNTCURR10(2) GESBE
DIFF_CURRCurrency of Difference Amount DIFF_CURRCUKY5Assigned to domainWAERS
REASONReason for Difference PTRV_REASONCHAR50TEXT50
DIFF_VIOLATIONMaximum Difference Exceeded DIFF_VIOLATIONCHAR1P_ATYPE
RECEIPT_NOInvoice Number of Original Receipt PTRV_RECEIPT_NOCHAR16
.INCLU-RNO 0
VISIBLERNOCheckbox XFELDCHAR1XFELD
INPUTRNOCheckbox XFELDCHAR1XFELD
REQUIREDRNOCheckbox XFELDCHAR1XFELD
RECEIPT_ITEMNumber of Invoice Item PTRV_RECEIPT_ITEMNUMC3
.INCLU-RIT 0
VISIBLERITCheckbox XFELDCHAR1XFELD
INPUTRITCheckbox XFELDCHAR1XFELD
REQUIREDRITCheckbox XFELDCHAR1XFELD
VAT_AMOUNTTax amount in document currency WMWSTCURR13(2) WERT7
.INCLU-VAM 0
VISIBLEVAMCheckbox XFELDCHAR1XFELD
INPUTVAMCheckbox XFELDCHAR1XFELD
REQUIREDVAMCheckbox XFELDCHAR1XFELD
VAT_SERVICE_CODEVAT Refund Code PTRV_VAT_SERVICE_CODECHAR3Assigned to domainPTRV_VAT_SERVICE_CODE
.INCLU-VSC 0
VISIBLEVSCCheckbox XFELDCHAR1XFELD
INPUTVSCCheckbox XFELDCHAR1XFELD
REQUIREDVSCCheckbox XFELDCHAR1XFELD
VAT_SERVICE_DESCDescription of Goods and Services PTRV_VAT_SERVICE_DESCCHAR100TEXT100
.INCLU-VSD 0
VISIBLEVSDCheckbox XFELDCHAR1XFELD
INPUTVSDCheckbox XFELDCHAR1XFELD
REQUIREDVSDCheckbox XFELDCHAR1XFELD
VAT_REG_NOVAT Registration Number STCEGCHAR20STCEG
.INCLU-VRN 0
VISIBLEVRNCheckbox XFELDCHAR1XFELD
INPUTVRNCheckbox XFELDCHAR1XFELD
REQUIREDVRNCheckbox XFELDCHAR1XFELD
VAT_REG_NO_NATTax Number 1 STCD1CHAR16STCD1
.INCLU-VNN 0
VISIBLEVNNCheckbox XFELDCHAR1XFELD
INPUTVNNCheckbox XFELDCHAR1XFELD
REQUIREDVNNCheckbox XFELDCHAR1XFELD
NAMEName 1 AD_NAME1CHAR40TEXT40
.INCLU-NAM 0
VISIBLENAMCheckbox XFELDCHAR1XFELD
INPUTNAMCheckbox XFELDCHAR1XFELD
REQUIREDNAMCheckbox XFELDCHAR1XFELD
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
.INCLU-STR 0
VISIBLESTRCheckbox XFELDCHAR1XFELD
INPUTSTRCheckbox XFELDCHAR1XFELD
REQUIREDSTRCheckbox XFELDCHAR1XFELD
HOUSE_NUMHouse Number AD_HSNM1CHAR10TEXT10
.INCLU-HNU 0
VISIBLEHNUCheckbox XFELDCHAR1XFELD
INPUTHNUCheckbox XFELDCHAR1XFELD
REQUIREDHNUCheckbox XFELDCHAR1XFELD
POST_CODECity postal code AD_PSTCD1CHAR10CHAR10
.INCLU-PCD 0
VISIBLEPCDCheckbox XFELDCHAR1XFELD
INPUTPCDCheckbox XFELDCHAR1XFELD
REQUIREDPCDCheckbox XFELDCHAR1XFELD
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
.INCLU-CTY 0
VISIBLECTYCheckbox XFELDCHAR1XFELD
INPUTCTYCheckbox XFELDCHAR1XFELD
REQUIREDCTYCheckbox XFELDCHAR1XFELD
VAT_SUB_SRV_CODESubcodes for Goods and Services PTRV_VAT_SUB_SRV_CODECHAR15PTRV_VAT_SUB_SRV_CODE
VAT_SRV_DESC_LANGULanguage of Description of Goods and Services PTRV_VAT_SRV_DESC_LANGULANG1ISOLASYLANGU
VAT_CHANGED_MANVAT Amount Changed Manually PTRV_VAT_CHANGED_MANCHAR1
IMAGE_LINKContains the UUID for a Document on the Archive Server PTRA_IMAGE_LINKCHAR32SYSUUID_C
FROM_MOBILEReceipt from Mobile Application PTRA_FROM_MOBILECHAR1XFELD
.INCLU-MOB 0
VISIBLEMOBCheckbox XFELDCHAR1XFELD
INPUTMOBCheckbox XFELDCHAR1XFELD
REQUIREDMOBCheckbox XFELDCHAR1XFELD
AIR_DEPARTUREIATA - Airport Location AIR_LOCATIONCHAR3Assigned to domainFTPD_IATA_LOCATION
.INCLU-AID 0
VISIBLEAIDCheckbox XFELDCHAR1XFELD
INPUTAIDCheckbox XFELDCHAR1XFELD
REQUIREDAIDCheckbox XFELDCHAR1XFELD
AIR_ARRIVALIATA - Airport Location AIR_LOCATIONCHAR3Assigned to domainFTPD_IATA_LOCATION
.INCLU-AIA 0
VISIBLEAIACheckbox XFELDCHAR1XFELD
INPUTAIACheckbox XFELDCHAR1XFELD
REQUIREDAIACheckbox XFELDCHAR1XFELD
AIRLINEAirline AIRLINECHAR3Assigned to domainFTPD_PROVIDER_CODE
.INCLU-AIL 0
VISIBLEAILCheckbox XFELDCHAR1XFELD
INPUTAILCheckbox XFELDCHAR1XFELD
REQUIREDAILCheckbox XFELDCHAR1XFELD
AIR_CABIN_CLASSCabin Class AIR_CABIN_CLASSCHAR1FTPD_FLIGHT_CABIN
.INCLU-AIC 0
VISIBLEAICCheckbox XFELDCHAR1XFELD
INPUTAICCheckbox XFELDCHAR1XFELD
REQUIREDAICCheckbox XFELDCHAR1XFELD
AIR_TICKET_NUMBERTicket Number PTRV_TICKET_NUMBERCHAR15PTRV_TICKET_NUMBER
.INCLU-AIT 0
VISIBLEAITCheckbox XFELDCHAR1XFELD
INPUTAITCheckbox XFELDCHAR1XFELD
REQUIREDAITCheckbox XFELDCHAR1XFELD
CAR_ODOMETER_READINGOdometer Mileage CAR_ODOMETER_READINGNUMC8
.INCLU-ODO 0
VISIBLEODOCheckbox XFELDCHAR1XFELD
INPUTODOCheckbox XFELDCHAR1XFELD
REQUIREDODOCheckbox XFELDCHAR1XFELD
SE_NAMEName 1 AD_NAME1CHAR40TEXT40
.INCLU-SNA 0
VISIBLESNACheckbox XFELDCHAR1XFELD
INPUTSNACheckbox XFELDCHAR1XFELD
REQUIREDSNACheckbox XFELDCHAR1XFELD
SE_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
.INCLU-SST 0
VISIBLESSTCheckbox XFELDCHAR1XFELD
INPUTSSTCheckbox XFELDCHAR1XFELD
REQUIREDSSTCheckbox XFELDCHAR1XFELD
SE_CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
.INCLU-SCI 0
VISIBLESCICheckbox XFELDCHAR1XFELD
INPUTSCICheckbox XFELDCHAR1XFELD
REQUIREDSCICheckbox XFELDCHAR1XFELD
SE_STATE_PROVINCEDistrict (US: County) SE_STATE_PROVINCECHAR40TEXT40
.INCLU-SPR 0
VISIBLESPRCheckbox XFELDCHAR1XFELD
INPUTSPRCheckbox XFELDCHAR1XFELD
REQUIREDSPRCheckbox XFELDCHAR1XFELD
SE_COUNTRYCountry of Vendor SE_COUNTRYCHAR3Assigned to domainLNDGR
.INCLU-SCO 0
VISIBLESCOCheckbox XFELDCHAR1XFELD
INPUTSCOCheckbox XFELDCHAR1XFELD
REQUIREDSCOCheckbox XFELDCHAR1XFELD
SE_POSTAL_CODECity postal code AD_PSTCD1CHAR10CHAR10
.INCLU-SPC 0
VISIBLESPCCheckbox XFELDCHAR1XFELD
INPUTSPCCheckbox XFELDCHAR1XFELD
REQUIREDSPCCheckbox XFELDCHAR1XFELD
SE_CUSTOMER_SERVICE_PHONECustomer Service Telephone No. of Vendor SE_CUSTOMER_SERVICE_PHONECHAR30CHAR30
.INCLU-SPH 0
VISIBLESPHCheckbox XFELDCHAR1XFELD
INPUTSPHCheckbox XFELDCHAR1XFELD
REQUIREDSPHCheckbox XFELDCHAR1XFELD
BELSAReceipt Contains Collective Item PTRVPS_BELSACHAR1PTRV_DETAIL_ACCOMODATION_REC
MAZUBMeals Included in Accommodations Receipt PTRVPS_MAZUBCHAR1PTRV_DETAIL_ACCOMODATION_REC
RECAGInvoice Issued to Employer PTRVPS_RECAGCHAR1PTRV_DETAIL_ACCOMODATION_REC
SADVCollective Item Is Business Related Only PTRVPS_SADVCHAR1PTRV_DETAIL_ACCOMODATION_REC
T_GUEST 0
EXP_TYPE_NAMEName of Travel Expense Type TEXT_SPKZLCHAR30REITX
EXP_CATE_NAMELong Text LTEXTCHAR40TEXT40
REC_CURR_NAMELong Text LTEXTCHAR40TEXT40
PAY_CURR_NAMELong Text LTEXTCHAR40TEXT40
TAX_CODE_NAMEName for value-added tax TEXT1_007SCHAR50TEXT50
TAXJURCODE_NAMEDescription of the tax jurisdiction code structure TM_TEXT1_TXJCDCHAR50TEXT50
COUNTRY_REGION_NAMEName of Trip Country/Country Group/Region TEXT_RGIONCHAR25TRV25
CCOMP_NAMEName of Credit Card Company TEXT_CCARDCHAR50TEXT50
P_CTG_NAMELong Text LTEXTCHAR40TEXT40
P_PRV_NAMEProvider Name PROVIDER_NAMECHAR30TEXT30
PAYOUT_NAMEName of service provider TEXT_CCOMPCHAR50TEXT50
TT_COMSP_NAMEName for enterprise-specific trip type TEXT_BEREICHAR25TRV25

Key field Non-key field



How do I retrieve data from SAP structure PTRV_WEB_RECEIPTS_EXT_2 using ABAP code?

As PTRV_WEB_RECEIPTS_EXT_2 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on PTRV_WEB_RECEIPTS_EXT_2 as there is no data to select.

How to access SAP table PTRV_WEB_RECEIPTS_EXT_2

Within an ECC or HANA version of SAP you can also view further information about PTRV_WEB_RECEIPTS_EXT_2 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!