1. Home
  2. Resources
  3. SAP Tables
  4. PTKXX - Field documentation structure for HR Travel

SAP Table PTKXX

Field documentation structure for HR Travel

PTKXX (Field documentation structure for HR Travel) 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 PTKXX to other SAP tables.

Source: PTKXX (Field documentation structure for HR Travel)

PTKXX table fields

Field Data element Checktable Datatype Length Decimals
RENUM Trip Number REINR NUMC 10 0
PERNR Personnel Number PERNR_D PTRV_HEAD NUMC 8 0
REINR Trip Number REINR PTRV_HEAD NUMC 10 0
PERIO Character field of length 6 CHAR6 CHAR 6 0
SPERI Editing period SELPE T549Q NUMC 2 0
SJAHR Year of editing period SELJA T549Q NUMC 4 0
DATV1 Start date SDAV1 DATS 8 0
DATB1 End date of selection interval SDAB1 DATS 8 0
SRENR Trip Number REINR NUMC 10 0
ZORT1 Location RZIEL CHAR 17 0
ZLAND Country Key LAND1 CHAR 3 0
KUNDE Reason for trip (e.g. customer/requisitioner) RKUND CHAR 17 0
ANTRG_1 Trip status 1 RSTA1 CHAR 1 0
X Yes
NULL No
ANTRG_2 Trip status 1 RSTA1 CHAR 1 0
X Yes
NULL No
ANTRG_3 Trip status 1 RSTA1 CHAR 1 0
X Yes
NULL No
ANTRG_4 Trip status 1 RSTA1 CHAR 1 0
X Yes
NULL No
ANTRG_5 Trip status 1 RSTA1 CHAR 1 0
X Yes
NULL No
ABREC_0 Trip status 2 RSTA2 CHAR 1 0
X Yes
NULL No
ABREC_1 Trip status 2 RSTA2 CHAR 1 0
X Yes
NULL No
ABREC_2 Trip status 2 RSTA2 CHAR 1 0
X Yes
NULL No
ABREC_3 Trip status 2 RSTA2 CHAR 1 0
X Yes
NULL No
UEB_DFL Trip status 2 RSTA2 CHAR 1 0
X Yes
NULL No
SELST Trip status 2 RSTA2 CHAR 1 0
X Yes
NULL No
DIMEN Number of entries in list PAGEN NUMC 3 0
ZEILE Number of first entry on current page PAGEA NUMC 3 0
BETRG Assign Receipt in Absolute Amounts ABSLT CHAR 1 0
X Yes
NULL No
PROZT Assign Amount on Receipt by Percent BTRPR CHAR 1 0
X Yes
NULL No
AUFRE Travel Expenses Distribution in Percent DISTR DEC 4 2
AUFZI Travel Expenses Distribution in Percent DISTR DEC 4 2
STAT1 Name for trip status RSTEX CHAR 17 0
STAT2 Name for trip status RSTEX CHAR 17 0
STAT3 Name for trip status RSTEX CHAR 17 0
STAT4 Name for trip status RSTEX CHAR 17 0
STAT5 Name for trip status RSTEX CHAR 17 0
STAT6 Name for trip status RSTEX CHAR 17 0
STAT7 Trip status for fast entry of trip data STPR2 CHAR 1 0
WA1XX Status: Application Entered RSTA31 CHAR 1 0
WA2XX Status: ECR approved RSTA32 CHAR 1 0
WA3XX Status: Trip Effected RSTA33 CHAR 1 0
WA4XX Status: Trip Approved RSTA34 CHAR 1 0
WAX0X Status: Open RSTA40 CHAR 1 0
WAX1X Status: To Be Settled RSTA41 CHAR 1 0
WAX3X Status: Cancelled RSTA43 CHAR 1 0
FTEXT Field Name FELDX CHAR 20 0
XNODI Radio buttons for field control XDISP CHAR 1 0
X Yes
NULL No
XOBLG Radio buttons for field control XDISP CHAR 1 0
X Yes
NULL No
XOPTN Radio buttons for field control XDISP CHAR 1 0
X Yes
NULL No
XDISP Radio buttons for field control XDISP CHAR 1 0
X Yes
NULL No
X04O1 Use of expense type P_PR04O CHAR 1 0
X Yes
NULL No
X04O2 Use of expense type P_PR04O CHAR 1 0
X Yes
NULL No
X04O3 Use of expense type P_PR04O CHAR 1 0
X Yes
NULL No
ANZFR Number of Breakfasts NUBRF CHAR 2 0
DATW1 Beginning Date of Week in Weekly Report DTBWK DATS 8 0
SUMD1 Receipt Total in Weekly Report BELRT CURR 10 2
SUMD2 Receipt Total in Weekly Report BELRT CURR 10 2
SUMD3 Receipt Total in Weekly Report BELRT CURR 10 2
SUMD4 Receipt Total in Weekly Report BELRT CURR 10 2
SUMD5 Receipt Total in Weekly Report BELRT CURR 10 2
SUMD6 Receipt Total in Weekly Report BELRT CURR 10 2
SUMD7 Receipt Total in Weekly Report BELRT CURR 10 2
BELRT Receipt Total in Weekly Report BELRT CURR 10 2
GSBET Payment Amount GSBET CURR 10 2
KMGES Total miles/kms for the day TKMGS DEC 5 0
KMGE1 Miles/Kilometers Allowance BELGE CURR 10 2
KMGE2 Miles/Kilometers Allowance BELGE CURR 10 2
KMGE3 Miles/Kilometers Allowance BELGE CURR 10 2
KMGE4 Miles/Kilometers Allowance BELGE CURR 10 2
KMGE5 Miles/Kilometers Allowance BELGE CURR 10 2
KMGE6 Miles/Kilometers Allowance BELGE CURR 10 2
KMGE7 Miles/Kilometers Allowance BELGE CURR 10 2
KMBET Miles/Kilometers Allowance BELGE CURR 10 2
WAERS Currency Key WAERS CUKY 5 0
SABKR Payroll subunit for determining editing period SABKR T549A CHAR 2 0
MEHR Further Cost Assignments in Coding Block AFTLX CHAR 1 0
X Yes
NULL No
PAUVS1 Input tax entry in Travel Management PTRV_VORST CHAR 1 0
X Yes
NULL No
PAUVS2 Input tax entry in Travel Management PTRV_VORST CHAR 1 0
X Yes
NULL No
PAUVS3 Input tax entry in Travel Management PTRV_VORST CHAR 1 0
X Yes
NULL No
DEFMWSKZ1 Input Tax Default Value for International Expense Receipts PTRV_DEFMWSKZ CHAR 1 0
X Yes
NULL No
DEFMWSKZ2 Input Tax Default Value for International Expense Receipts PTRV_DEFMWSKZ CHAR 1 0
X Yes
NULL No
HCURR0 Settlement of foreign curr.receipts and advances PTRV_HCURR CHAR 1 0
X Yes
NULL No
HCURR1 Settlement of foreign curr.receipts and advances PTRV_HCURR CHAR 1 0
X Yes
NULL No
HCURR2 Settlement of foreign curr.receipts and advances PTRV_HCURR CHAR 1 0
X Yes
NULL No
KZREA_DFW_ Business trip PTRV_KZREA_DFW_ CHAR 1 0
X Yes
NULL No
KZREA_DFW_1 Off-site work PTRV_KZREA_DFW_1 CHAR 1 0
X Yes
NULL No
KZREA_DFW_2 Separation Bonus_External_Stay PTRV_KZREA_DFW_2 CHAR 1 0
X Yes
NULL No
KZREA_DFW_3 Separation bonus_daily_return PTRV_KZREA_DFW_3 CHAR 1 0
X Yes
NULL No
KZREA_DFW_H Night in 'Hybel' (Norwegian accounting) PTRV_KZREA_DFW_H CHAR 1 0
X Yes
NULL No
KZREA_DFW_B Bruspenger during course or training (Norwegian accounting) PTRV_KZREA_DFW_B CHAR 1 0
X Yes
NULL No
KZREA_DFW_E Night in pensjonat (Norwegian accounting) PTRV_KZREA_DFW_E CHAR 1 0
X Yes
NULL No
KZREA_DFW_P Private PTRV_KZREA_DFW_P CHAR 1 0
X Yes
NULL No
KZREA_DFW_S Full taxation for trips > 183 days PTRV_KZREA_DFW_S CHAR 1 0
X Yes
NULL No
KZREA_DFW_R Night in hotel (Norwegian accounting) PTRV_KZREA_DFW_R CHAR 1 0
X Yes
NULL No
KZREA_DFW_X Non-business trip PTRV_KZREA_DFW_X CHAR 1 0
X Yes
NULL No
KZREA_DFW_L Business trip > 3 months PTRV_KZREA_DFW_L CHAR 1 0
X Yes
NULL No
KZREA_DFW_K Business trip with receipts - Payment of additional per diem PTRV_KZREA_DFW_K CHAR 1 0
X Yes
NULL No
KZREA_DFW_M Bus.Trip with Receipts - Add.Per Diem as Income-Rel.Expense PTRV_KZREA_DFW_M CHAR 1 0
X Yes
NULL No
HBETR Amount on Individual Receipt GESBB CURR 10 2
CTRLREC Payment and Taxation of Travel Expense Type PTRV_CTRLREC CHAR 1 0
1 Reimburse to Employee
2 Paid by Company
3 Taxable by Employee, No Payment to Employee
4 Taxable by Employee, Payment to Employee
5 Estimated Costs, No Reimbursement to Employee
7 Already Paid by Company, Taxable by Employee
6 Private Expenses; No Reimbursement to Employee
8 Rounded Receipt
ABWLAN Number of entries with nonstandard long texts PTRV_PRD_ABWLAN NUMC 4 0
EINDOP Number of double entries PTRV_PRD_EINDOP NUMC 4 0
EINFEH Number of missing entries PTRV_PRD_EINFEH NUMC 4 0
EINGEL File with Daily Rates Has Been Imported PTRV_PRD_EINGEL CHAR 1 0
X Yes
NULL No
GESAMT Total number of entries PTRV_PRD_GESAMT NUMC 4 0
KORREK Number of correct entries PTRV_PRD_KORREK NUMC 4 0
NICGEF Missing entries PTRV_PRD_NICGEF NUMC 4 0
HCURR3 Settlement of foreign curr.receipts and advances PTRV_HCURR CHAR 1 0
X Yes
NULL No
ANTRG00 Radio buttons for field control XDISP CHAR 1 0
X Yes
NULL No
ANTRGFI Radio buttons for field control XDISP CHAR 1 0
X Yes
NULL No
ANTRGHR Radio buttons for field control XDISP CHAR 1 0
X Yes
NULL No
ANTRGDT Radio buttons for field control XDISP CHAR 1 0
X Yes
NULL No
KZREA_DFW_A PS Germany Separation Allowance: Absence from Place of Work PTRV_KZREA_DFW_A CHAR 1 0
X Yes
NULL No
KZREA_DFW_5 Ps Germany: Trip to Return from Work PTRV_KZREA_DFW_5 CHAR 1 0
X Yes
NULL No
KZREA_DFW_4 PS Germany: Trip to Start Work PTRV_KZREA_DFW_4 CHAR 1 0
X Yes
NULL No
KZREA_DFW_C Italian Accounting: Per Diem and Flat Rate Settlement PTRV_KZREA_DFW_C CHAR 1 0
X Yes
NULL No
KZREA_DFW_D Italian Accounting: Receipt Settlement (Pie di Lista) PTRV_KZREA_DFW_D CHAR 1 0
X Yes
NULL No
KZREA_DFW_6 Italian Accounting: Per Diem + M Receipts PTRV_KZREA_DFW_6 CHAR 1 0
X Yes
NULL No
KZREA_DFW_7 Italian Accounting: Per Diem + U Receipts PTRV_KZREA_DFW_7 CHAR 1 0
X Yes
NULL No
KZREA_DFW_8 Italian Accounting: Per Diem + M and U Receipts PTRV_KZREA_DFW_8 CHAR 1 0
X Yes
NULL No
KZREA_DFW_G Italian Accounting: Trip Within Home Town PTRV_KZREA_DFW_G CHAR 1 0
X Yes
NULL No
VERPA_TEXT Name of Checkbox "Meals per Diem" VERPA_TEXT CHAR 38 0
M_RECEIPTS_VALID Receipts of Expense Category M Are Valid PTKXX_M_RECEIPTS_VALID CHAR 1 0
M_RECEIPTS_NOT_VALID Receipts of Expense Category M Are Not Valid PTKXX_M_RECEIPTS_NOT_VALID CHAR 1 0
U_RECEIPTS_VALID Receipts of Expense Category U Are Valid PTKXX_U_RECEIPTS_VALID CHAR 1 0
U_RECEIPTS_NOT_VALID Receipts of Expense Category U Are Not Valid PTKXX_U_RECEIPTS_NOT_VALID CHAR 1 0
V_RECEIPTS_VALID Receipts of Expense Category V Are Valid PTKXX_V_RECEIPTS_VALID CHAR 1 0
V_RECEIPTS_NOT_VALID Receipts of Expense Category V Are Not Valid PTKXX_V_RECEIPTS_NOT_VALID CHAR 1 0
S_RECEIPTS_VALID Receipts of Expense Category S Are Valid PTKXX_S_RECEIPTS_VALID CHAR 1 0
S_RECEIPTS_NOT_VALID Receipts of Expense Category S Are Not Valid PTKXX_S_RECEIPTS_NOT_VALID CHAR 1 0
DATUM_RED_PAUSCH IT Banking CA: Date from Which Reduced Per Diems Apply DATUM_RED_PAUSCH DATS 8 0
PERNR_FOR_SH Personnel Number PERNR_D NUMC 8 0
VAT_RFD Advanced VAT Refund for Trip Provision Variant PTRV_VATRFD CHAR 1 0
NULL Advanced VAT Refund Not Allowed
X Advanced VAT Refund Allowed
ANKUNFT Arrival at Home or Workplace PTRV_ANKUNFT CHAR 60 0
ABFAHRT Departure from Home or Workplace PTRV_ABFAHRT CHAR 60 0
BERKZ_DFW_1 Business Trip: Rate 1 PTRV_BERKZ_DFW_1 CHAR 1 0
X Yes
NULL No
BERKZ_DFW_2 Business Trip: Rate 2 PTRV_BERKZ_DFW_2 CHAR 1 0
X Yes
NULL No
BERKZ_DFW_3 Transport with Business Trips: Rate 1 PTRV_BERKZ_DFW_3 CHAR 1 0
X Yes
NULL No
BERKZ_DFW_4 Transport with District Trips Without Overnight Fee: Rate 2 PTRV_BERKZ_DFW_4 CHAR 1 0
X Yes
NULL No
BERKZ_DFW_5 District Trips with Entitlement to Overnight Fee: Rate 1 PTRV_BERKZ_DFW_5 CHAR 1 0
X Yes
NULL No
BERKZ_DFW_6 District Trips With Entitlement to Overnight Fee: Rate 2 PTRV_BERKZ_DFW_6 CHAR 1 0
X Yes
NULL No
BERKZ_DFW_7 District Trips Without Entitlement to Overnight Fee: Rate 2 PTRV_BERKZ_DFW_7 CHAR 1 0
X Yes
NULL No
BERKZ_DFW_8 Trip Abroad PTRV_BERKZ_DFW_8 CHAR 1 0
X Yes
NULL No
BERKZ_DFW_9 Absence During Business Trip PTRV_BERKZ_DFW_9 CHAR 1 0
X Yes
NULL No
BERKZ_DFW_A Hospital Stay: Rate 1 PTRV_BERKZ_DFW_A CHAR 1 0
X Yes
NULL No
BERKZ_DFW_B Hospital Stay: Rate 2 PTRV_BERKZ_DFW_B CHAR 1 0
X Yes
NULL No
BERKZ_DFW_C Duty Allocation: Reduced Rate 1 PTRV_BERKZ_DFW_C CHAR 1 0
BERKZ_DFW_D Duty Allocation: Reduced Hospital Rate PTRV_BERKZ_DFW_D CHAR 1 0
BERKZ_DFW_E Absence During Duty Allocation PTRV_BERKZ_DFW_E CHAR 1 0

PTKXX foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PTKXX PERNR * PTRV_HEAD General Trip Data REINR
PTKXX PERNR PTKXX REINR PTRV_HEAD General Trip Data PERNR
PTKXX PERNR PTKXX PERNR PTRV_HEAD General Trip Data MANDT
PTKXX PERNR SYST MANDT PTRV_HEAD General Trip Data .INCLUDE
PTKXX REINR * PTRV_HEAD General Trip Data REINR
PTKXX REINR PTKXX REINR PTRV_HEAD General Trip Data PERNR
PTKXX REINR PTKXX PERNR PTRV_HEAD General Trip Data MANDT
PTKXX REINR SYST MANDT PTRV_HEAD General Trip Data .INCLUDE
PTKXX SABKR PTKXX SABKR T549A Payroll areas ABKRS
PTKXX SABKR SYST MANDT T549A Payroll areas MANDT
PTKXX SJAHR SYST MANDT T549Q Payroll Periods MANDT
PTKXX SJAHR * T549Q Payroll Periods PABRP
PTKXX SJAHR PTKXX SJAHR T549Q Payroll Periods PABRJ
PTKXX SJAHR T549A PERMO T549Q Payroll Periods PERMO
PTKXX SPERI PTKXX SPERI T549Q Payroll Periods PABRP
PTKXX SPERI PTKXX SJAHR T549Q Payroll Periods PABRJ
PTKXX SPERI T549A PERMO T549Q Payroll Periods PERMO
PTKXX SPERI SYST MANDT T549Q Payroll Periods MANDT