1. Home
  2. Resources
  3. SAP Tables
  4. PTRV_WEB_RECEIPTS_INT_2 - Trip Receipts

SAP Table PTRV_WEB_RECEIPTS_INT_2

Trip Receipts

PTRV_WEB_RECEIPTS_INT_2 (Trip Receipts) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PTRV_WEB_RECEIPTS_INT_2 to other SAP tables.

PTRV_WEB_RECEIPTS_INT_2 table fields

Field Data element Checktable Datatype Length Decimals
RECEIPTNO Document Number NRBEL CHAR 3 0
EXP_TYPE Travel Expense Type SPKZL T706B1 CHAR 4 0
VISIBLESPK Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTSPK Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDSPK Checkbox XFELD CHAR 1 0
X Yes
NULL No
EXP_CATE Travel Expense Category BELAR CHAR 1 0
U Accommodations
M Meals
T Public Transportation
F Expenses for Private Car
S Other
V Meals Itemization (Maximum Rate per Day)
O Advance
K Cash Advance
VISIBLEPAP Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTPAP Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDPAP Checkbox XFELD CHAR 1 0
X Yes
NULL No
PAPER_RECEIPT Paper Receipt Exists PAPER_RECEIPT_CORE CHAR 1 0
X Yes
NULL No
REC_AMOUNT Amount on Individual Receipt PTRV_WEB_REC_AMOUNT CURR 10 2
VISIBLEAMN Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTAMN Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDAMN Checkbox XFELD CHAR 1 0
X Yes
NULL No
REC_CURR Currency Key WAERS TCURC CUKY 5 0
VISIBLECUR Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTCUR Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDCUR Checkbox XFELD CHAR 1 0
X Yes
NULL No
REC_RATE Exchange Rate UKURS_CURR DEC 9 5
VISIBLERAT Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTRAT Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDRAT Checkbox XFELD CHAR 1 0
X Yes
NULL No
S_FACTOR Ratio for the "From" Currency Units FFACT_CURR DEC 9 0
T_FACTOR Ratio for the "To" Currency Units TFACT_CURR DEC 9 0
VISIBLEDAT Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTDAT Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDDAT Checkbox XFELD CHAR 1 0
X Yes
NULL No
REC_DATE Receipt Date BELDT DATS 8 0
PAY_AMOUNT Amount on Individual Receipt GESBB CURR 10 2
VISIBLEPAM Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTPAM Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDPAM Checkbox XFELD CHAR 1 0
X Yes
NULL No
PAY_CURR Accounting Currency of Expense Receipt or Advance PTRV_PAYCURR TCURC CUKY 5 0
VISIBLEPCU Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTPCU Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDPCU Checkbox XFELD CHAR 1 0
X Yes
NULL No
TAX_CODE Tax on sales/purchases code MWSKZ T007A CHAR 2 0
TAXJURCODE Tax Jurisdiction TXJCD CHAR 15 0
VISIBLESTX Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTSTX Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDSTX Checkbox XFELD CHAR 1 0
X Yes
NULL No
SHORTTXT Short Receipt Information TXBEL CHAR 10 0
COUNTRY Trip Country / Trip Country Group LNDGR CHAR 3 0
REGION Trip Country/Trip Country Group/Trip Region RGION CHAR 5 0
FROM_DATE From Date FRDAT DATS 8 0
TO_DATE To Date TODAT DATS 8 0
NO_UNIT Number ERANZ DEC 3 0
NO_BRFT Number of Breakfasts NUBRF CHAR 2 0
DESCRIPT Description ERDES CHAR 50 0
LOCATION Location ERPLC CHAR 50 0
BUS_PURPO Business Purpose BUSPU CHAR 50 0
VISIBLEBPP Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTBPP Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDBPP Checkbox XFELD CHAR 1 0
X Yes
NULL No
BUS_REASON Business Partners BUSRE CHAR 50 0
CCOMP Code of Payment Card Company CCOMP CHAR 2 0
VISIBLECCP Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTCCP Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDCCP Checkbox XFELD CHAR 1 0
X Yes
NULL No
C_DOC Document Number of Credit Card Receipt C_DOC CHAR 20 0
VISIBLECDC Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTCDC Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDCDC Checkbox XFELD CHAR 1 0
X Yes
NULL No
C_TXT Delivered Description of a Credit Card Transaction C_TXT CHAR 50 0
VISIBLECTX Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTCTX Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDCTX Checkbox XFELD CHAR 1 0
X Yes
NULL No
CCARD Credit Card Number C_NUM CHAR 19 0
CEKEY Transaction Key (Supplied by Credit Card Company) CEKEY CHAR 10 0
P_CTG Provider Category PROVIDER_CATEGORY CHAR 1 0
F Airline
C Car Rental Company
H Hotel Chain
R Reservation System
T Rail Company
K Credit Card Company
P_PRV Provider Code PROVIDER_CODE CHAR 3 0
P_DOC Document Number of a (Paper) Document P_DOC CHAR 20 0
N_STF Number of Employees CH_NO_STAFF CHAR 3 0
N_PTN Number of Employees of Business Partners CH_NO_PARTNERS CHAR 3 0
N_GST Number of Additional Guests CH_NO_GUESTS CHAR 3 0
PAID_COM Paid by Company BEZFA CHAR 1 0
X Yes
NULL No
PAYOUT Service Provider PAYOT CHAR 2 0
ABOVE_LIMIT Customizing Limit for Travel Expense Type Exceeded PTRV_ABOVE_LIMIT CHAR 1 0
A Default value
B Reason for exceeding maximum rate is required
C Warning message for exceeding maximum rate
D Distribution of receipt amount to different wage types
E Error message for exceeding maximum rate
F Issue warning if paper receipt is missing (manual receipt)
G Issue warning if paper receipt is missing (credit card rcpt)
H Issue warning if maximum difference is exceeded
I Reason for exceeding maximum difference is required
COMING_FROM_PLAN Protection Indicator of Entry PROTECT CHAR 1 0
NULL Not protected
P Protect travel planning
A Protect travel planning / changed travel expenses accounting
REF_NO Reference Document Number NOBEL CHAR 3 0
VISIBLEROK Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTROK Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDROK Checkbox XFELD CHAR 1 0
X Yes
NULL No
RECEIPT_OK Expense Receipt Checked RECEIPT_VALIDATED_CORE CHAR 1 0
X Yes
NULL No
TT_COMSP Trip Type: Enterprise-Specific BEREI CHAR 1 0
CHECK_RESULT Result of Receipt Check RECEIPT_CHECK_RESULT CHAR 1 0
NULL No check performed
S Check successful
I Check successful
W Check generated warning message
E Check generated error message
A Check generated termination message
Z Check generated maximum rate excess and active Wizard
DISPLAY_ONLY Individual Receipt Can Only Be Displayed RECEIPT_DISPLAY_ONLY CHAR 1 0
X Yes
NULL No
EDITOR Editor in Web Structures PTRV_WEB_EDITOR STRG 0 0
EXP_TYPE_ORIGINAL Travel Expense Type SPKZL CHAR 4 0
EXP_TYPE1 Travel Expense Type SPKZL CHAR 4 0
EXP_TYPE2 Travel Expense Type SPKZL CHAR 4 0
EXP_TYPE3 Travel Expense Type SPKZL CHAR 4 0
EXP_TYPE4 Travel Expense Type SPKZL CHAR 4 0
EXP_TYPE5 Travel Expense Type SPKZL CHAR 4 0
EXP_TYPE6 Travel Expense Type SPKZL CHAR 4 0
PRIEXP Expense Type for Private Shares PRIEXP CHAR 4 0
NO_LUNCH Number of Lunches in Hotel Receipt PTRV_ANZLU CHAR 3 0
NO_DINNER Number of Dinners in Hotel Receipt PTRV_ANZDI CHAR 3 0
FULL_AMOUNT_REIMB Reimbursement of Accommodations Receipt in Full PTRV_GENEHM_U_BELEG CHAR 1 0
PAPER_MISSING Required Paper Receipt Is Missing PAPER_MISSING CHAR 1 0
A Default value
B Reason for exceeding maximum rate is required
C Warning message for exceeding maximum rate
D Distribution of receipt amount to different wage types
E Error message for exceeding maximum rate
F Issue warning if paper receipt is missing (manual receipt)
G Issue warning if paper receipt is missing (credit card rcpt)
H Issue warning if maximum difference is exceeded
I Reason for exceeding maximum difference is required
BOOKED_PRICE Booked Price from Travel Planning BOOKED_PRICE CURR 10 2
BOOKED_CURR Booked Currency from Planning BOOKED_CURR CUKY 5 0
DIFF_AMOUNT Difference Amount DIFF_AMOUNT CURR 10 2
DIFF_CURR Currency of Difference Amount DIFF_CURR CUKY 5 0
REASON Reason for Difference PTRV_REASON CHAR 50 0
DIFF_VIOLATION Maximum Difference Exceeded DIFF_VIOLATION CHAR 1 0
A Default value
B Reason for exceeding maximum rate is required
C Warning message for exceeding maximum rate
D Distribution of receipt amount to different wage types
E Error message for exceeding maximum rate
F Issue warning if paper receipt is missing (manual receipt)
G Issue warning if paper receipt is missing (credit card rcpt)
H Issue warning if maximum difference is exceeded
I Reason for exceeding maximum difference is required
RECEIPT_NO Invoice Number of Original Receipt PTRV_RECEIPT_NO CHAR 16 0
VISIBLERNO Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTRNO Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDRNO Checkbox XFELD CHAR 1 0
X Yes
NULL No
RECEIPT_ITEM Number of Invoice Item PTRV_RECEIPT_ITEM NUMC 3 0
VISIBLERIT Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTRIT Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDRIT Checkbox XFELD CHAR 1 0
X Yes
NULL No
VAT_AMOUNT Tax amount in document currency WMWST CURR 13 2
VISIBLEVAM Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTVAM Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDVAM Checkbox XFELD CHAR 1 0
X Yes
NULL No
VAT_SERVICE_CODE VAT Refund Code PTRV_VAT_SERVICE_CODE CHAR 3 0
VISIBLEVSC Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTVSC Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDVSC Checkbox XFELD CHAR 1 0
X Yes
NULL No
VAT_SERVICE_DESC Description of Goods and Services PTRV_VAT_SERVICE_DESC CHAR 100 0
VISIBLEVSD Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTVSD Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDVSD Checkbox XFELD CHAR 1 0
X Yes
NULL No
VAT_REG_NO VAT Registration Number STCEG CHAR 20 0
VISIBLEVRN Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTVRN Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDVRN Checkbox XFELD CHAR 1 0
X Yes
NULL No
VAT_REG_NO_NAT Tax Number 1 STCD1 CHAR 16 0
VISIBLEVNN Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTVNN Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDVNN Checkbox XFELD CHAR 1 0
X Yes
NULL No
NAME Name 1 AD_NAME1 CHAR 40 0
VISIBLENAM Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTNAM Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDNAM Checkbox XFELD CHAR 1 0
X Yes
NULL No
STREET Street AD_STREET CHAR 60 0
VISIBLESTR Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTSTR Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDSTR Checkbox XFELD CHAR 1 0
X Yes
NULL No
HOUSE_NUM House Number AD_HSNM1 CHAR 10 0
VISIBLEHNU Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTHNU Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDHNU Checkbox XFELD CHAR 1 0
X Yes
NULL No
POST_CODE City postal code AD_PSTCD1 CHAR 10 0
VISIBLEPCD Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTPCD Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDPCD Checkbox XFELD CHAR 1 0
X Yes
NULL No
CITY City AD_CITY1 CHAR 40 0
VISIBLECTY Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTCTY Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDCTY Checkbox XFELD CHAR 1 0
X Yes
NULL No
VAT_SUB_SRV_CODE Subcodes for Goods and Services PTRV_VAT_SUB_SRV_CODE CHAR 15 0
VAT_SRV_DESC_LANGU Language of Description of Goods and Services PTRV_VAT_SRV_DESC_LANGU LANG 1 0
VAT_CHANGED_MAN VAT Amount Changed Manually PTRV_VAT_CHANGED_MAN CHAR 1 0
IMAGE_LINK Contains the UUID for a Document on the Archive Server PTRA_IMAGE_LINK CHAR 32 0
FROM_MOBILE Receipt from Mobile Application PTRA_FROM_MOBILE CHAR 1 0
X Yes
NULL No
VISIBLEMOB Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTMOB Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDMOB Checkbox XFELD CHAR 1 0
X Yes
NULL No
AIR_DEPARTURE IATA - Airport Location AIR_LOCATION CHAR 3 0
VISIBLEAID Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTAID Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDAID Checkbox XFELD CHAR 1 0
X Yes
NULL No
AIR_ARRIVAL IATA - Airport Location AIR_LOCATION CHAR 3 0
VISIBLEAIA Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTAIA Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDAIA Checkbox XFELD CHAR 1 0
X Yes
NULL No
AIRLINE Airline AIRLINE CHAR 3 0
VISIBLEAIL Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTAIL Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDAIL Checkbox XFELD CHAR 1 0
X Yes
NULL No
AIR_CABIN_CLASS Cabin Class AIR_CABIN_CLASS CHAR 1 0
S Supersonic
F First
B Business
E Economy
VISIBLEAIC Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTAIC Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDAIC Checkbox XFELD CHAR 1 0
X Yes
NULL No
AIR_TICKET_NUMBER Ticket Number PTRV_TICKET_NUMBER CHAR 15 0
VISIBLEAIT Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTAIT Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDAIT Checkbox XFELD CHAR 1 0
X Yes
NULL No
CAR_ODOMETER_READING Odometer Mileage CAR_ODOMETER_READING NUMC 8 0
VISIBLEODO Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTODO Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDODO Checkbox XFELD CHAR 1 0
X Yes
NULL No
SE_NAME Name 1 AD_NAME1 CHAR 40 0
VISIBLESNA Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTSNA Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDSNA Checkbox XFELD CHAR 1 0
X Yes
NULL No
SE_STREET Street AD_STREET CHAR 60 0
VISIBLESST Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTSST Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDSST Checkbox XFELD CHAR 1 0
X Yes
NULL No
SE_CITY City AD_CITY1 CHAR 40 0
VISIBLESCI Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTSCI Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDSCI Checkbox XFELD CHAR 1 0
X Yes
NULL No
SE_STATE_PROVINCE District (US: County) SE_STATE_PROVINCE CHAR 40 0
VISIBLESPR Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTSPR Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDSPR Checkbox XFELD CHAR 1 0
X Yes
NULL No
SE_COUNTRY Country of Vendor SE_COUNTRY CHAR 3 0
VISIBLESCO Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTSCO Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDSCO Checkbox XFELD CHAR 1 0
X Yes
NULL No
SE_POSTAL_CODE City postal code AD_PSTCD1 CHAR 10 0
VISIBLESPC Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTSPC Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDSPC Checkbox XFELD CHAR 1 0
X Yes
NULL No
SE_CUSTOMER_SERVICE_PHONE Customer Service Telephone No. of Vendor SE_CUSTOMER_SERVICE_PHONE CHAR 30 0
VISIBLESPH Checkbox XFELD CHAR 1 0
X Yes
NULL No
INPUTSPH Checkbox XFELD CHAR 1 0
X Yes
NULL No
REQUIREDSPH Checkbox XFELD CHAR 1 0
X Yes
NULL No
BELSA Receipt Contains Collective Item PTRVPS_BELSA CHAR 1 0
NULL Not Specified
1 Yes
2 No
MAZUB Meals Included in Accommodations Receipt PTRVPS_MAZUB CHAR 1 0
NULL Not Specified
1 Yes
2 No
RECAG Invoice Issued to Employer PTRVPS_RECAG CHAR 1 0
NULL Not Specified
1 Yes
2 No
SADV Collective Item Is Business Related Only PTRVPS_SADV CHAR 1 0
NULL Not Specified
1 Yes
2 No
T_GUEST PTRV_GUEST_TAB TTYP 0 0

PTRV_WEB_RECEIPTS_INT_2 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PTRV_WEB_RECEIPTS_INT_2 EXP_TYPE * T706B1 Travel Expense Types MOREI
PTRV_WEB_RECEIPTS_INT_2 EXP_TYPE PTRV_WEB_RECEIPTS_INT_2 EXP_TYPE T706B1 Travel Expense Types SPKZL
PTRV_WEB_RECEIPTS_INT_2 EXP_TYPE * T706B1 Travel Expense Types ENDDA
PTRV_WEB_RECEIPTS_INT_2 EXP_TYPE SYST MANDT T706B1 Travel Expense Types MANDT
PTRV_WEB_RECEIPTS_INT_2 PAY_CURR SYST MANDT TCURC Currency Codes MANDT
PTRV_WEB_RECEIPTS_INT_2 PAY_CURR PTRV_WEB_RECEIPTS_INT_2 PAY_CURR TCURC Currency Codes WAERS
PTRV_WEB_RECEIPTS_INT_2 REC_CURR PTRV_WEB_RECEIPTS_INT_2 REC_CURR TCURC Currency Codes WAERS
PTRV_WEB_RECEIPTS_INT_2 REC_CURR SYST MANDT TCURC Currency Codes MANDT
PTRV_WEB_RECEIPTS_INT_2 TAX_CODE SYST MANDT T007A Tax Keys MANDT
PTRV_WEB_RECEIPTS_INT_2 TAX_CODE * T007A Tax Keys KALSM
PTRV_WEB_RECEIPTS_INT_2 TAX_CODE PTRV_WEB_RECEIPTS_INT_2 TAX_CODE T007A Tax Keys MWSKZ