SAP table PTKXX (Field documentation structure for HR Travel)

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

PTKXX foreign key relationships

Table Field Check Table Check Field
0 PTKXX PERNR PTRV_HEAD General Trip Data .INCLUDE
0 PTKXX PERNR PTRV_HEAD General Trip Data MANDT
0 PTKXX PERNR PTRV_HEAD General Trip Data PERNR
0 PTKXX PERNR PTRV_HEAD General Trip Data REINR
1 PTKXX REINR PTRV_HEAD General Trip Data .INCLUDE
1 PTKXX REINR PTRV_HEAD General Trip Data MANDT
1 PTKXX REINR PTRV_HEAD General Trip Data PERNR
1 PTKXX REINR PTRV_HEAD General Trip Data REINR
0 PTKXX SABKR T549A Payroll areas MANDT
0 PTKXX SABKR T549A Payroll areas ABKRS
1 PTKXX SJAHR T549Q Payroll Periods MANDT
1 PTKXX SJAHR T549Q Payroll Periods PERMO
1 PTKXX SJAHR T549Q Payroll Periods PABRJ
1 PTKXX SJAHR T549Q Payroll Periods PABRP
0 PTKXX SPERI T549Q Payroll Periods MANDT
0 PTKXX SPERI T549Q Payroll Periods PERMO
0 PTKXX SPERI T549Q Payroll Periods PABRJ
0 PTKXX SPERI T549Q Payroll Periods PABRP