SAP ABAP Table PTKXX (Field documentation structure for HR Travel)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ FI-TV-COS (Application Component) Travel Expenses
     ⤷ PTRA (Package) Travel Expenses Application Dev. (R/3 Enterprise Core)

Basic Data

Table Category	INTTAB	Structure
Structure	PTKXX	Table Relationship Diagram
Short Description	Field documentation structure for HR Travel

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	RENUM	☐	REINR	REINR	NUMC	10	0	Trip Number
2	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number	PTRV_HEAD
3	REINR	☐	REINR	REINR	NUMC	10	0	Trip Number	PTRV_HEAD
4	PERIO	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
5	SPERI	☐	SELPE	PABRP	NUMC	2	0	Editing period	T549Q
6	SJAHR	☐	SELJA	GJAHR	NUMC	4	0	Year of editing period	T549Q
7	DATV1	☐	SDAV1	DATS	DATS	8	0	Start date
8	DATB1	☐	SDAB1	DATS	DATS	8	0	End date of selection interval
9	SRENR	☐	REINR	REINR	NUMC	10	0	Trip Number
10	ZORT1	☐	RZIEL	RZIEL	CHAR	17	0	Location
11	ZLAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
12	KUNDE	☐	RKUND	RKUND	CHAR	17	0	Reason for trip (e.g. customer/requisitioner)
13	ANTRG_1	☐	RSTA1	XFELD	CHAR	1	0	Trip status 1
14	ANTRG_2	☐	RSTA1	XFELD	CHAR	1	0	Trip status 1
15	ANTRG_3	☐	RSTA1	XFELD	CHAR	1	0	Trip status 1
16	ANTRG_4	☐	RSTA1	XFELD	CHAR	1	0	Trip status 1
17	ANTRG_5	☐	RSTA1	XFELD	CHAR	1	0	Trip status 1
18	ABREC_0	☐	RSTA2	XFELD	CHAR	1	0	Trip status 2
19	ABREC_1	☐	RSTA2	XFELD	CHAR	1	0	Trip status 2
20	ABREC_2	☐	RSTA2	XFELD	CHAR	1	0	Trip status 2
21	ABREC_3	☐	RSTA2	XFELD	CHAR	1	0	Trip status 2
22	UEB_DFL	☐	RSTA2	XFELD	CHAR	1	0	Trip status 2
23	SELST	☐	RSTA2	XFELD	CHAR	1	0	Trip status 2
24	DIMEN	☐	PAGEN	NUM3	NUMC	3	0	Number of entries in list
25	ZEILE	☐	PAGEA	NUM3	NUMC	3	0	Number of first entry on current page
26	BETRG	☐	ABSLT	XFELD	CHAR	1	0	Assign Receipt in Absolute Amounts
27	PROZT	☐	BTRPR	XFELD	CHAR	1	0	Assign Amount on Receipt by Percent
28	AUFRE	☐	DISTR	DISTR	DEC	4	2	Travel Expenses Distribution in Percent
29	AUFZI	☐	DISTR	DISTR	DEC	4	2	Travel Expenses Distribution in Percent
30	STAT1	☐	RSTEX	CHAR17	CHAR	17	0	Name for trip status
31	STAT2	☐	RSTEX	CHAR17	CHAR	17	0	Name for trip status
32	STAT3	☐	RSTEX	CHAR17	CHAR	17	0	Name for trip status
33	STAT4	☐	RSTEX	CHAR17	CHAR	17	0	Name for trip status
34	STAT5	☐	RSTEX	CHAR17	CHAR	17	0	Name for trip status
35	STAT6	☐	RSTEX	CHAR17	CHAR	17	0	Name for trip status
36	STAT7	☐	STPR2	CHAR1	CHAR	1	0	Trip status for fast entry of trip data
37	WA1XX	☐	RSTA31	CHAR1	CHAR	1	0	Status: Application Entered
38	WA2XX	☐	RSTA32	CHAR1	CHAR	1	0	Status: ECR approved
39	WA3XX	☐	RSTA33	CHAR1	CHAR	1	0	Status: Trip Effected
40	WA4XX	☐	RSTA34	CHAR1	CHAR	1	0	Status: Trip Approved
41	WAX0X	☐	RSTA40	CHAR1	CHAR	1	0	Status: Open
42	WAX1X	☐	RSTA41	CHAR1	CHAR	1	0	Status: To Be Settled
43	WAX3X	☐	RSTA43	CHAR1	CHAR	1	0	Status: Cancelled
44	FTEXT	☐	FELDX	TEXT20	CHAR	20	0	Field Name
45	XNODI	☐	XDISP	XFELD	CHAR	1	0	Radio buttons for field control
46	XOBLG	☐	XDISP	XFELD	CHAR	1	0	Radio buttons for field control
47	XOPTN	☐	XDISP	XFELD	CHAR	1	0	Radio buttons for field control
48	XDISP	☐	XDISP	XFELD	CHAR	1	0	Radio buttons for field control
49	X04O1	☐	P_PR04O	XFELD	CHAR	1	0	Use of expense type
50	X04O2	☐	P_PR04O	XFELD	CHAR	1	0	Use of expense type
51	X04O3	☐	P_PR04O	XFELD	CHAR	1	0	Use of expense type
52	ANZFR	☐	NUBRF	CHAR2	CHAR	2	0	Number of Breakfasts
53	DATW1	☐	DTBWK	DATS	DATS	8	0	Beginning Date of Week in Weekly Report
54	SUMD1	☐	BELRT	GESBE	CURR	10	2	Receipt Total in Weekly Report
55	SUMD2	☐	BELRT	GESBE	CURR	10	2	Receipt Total in Weekly Report
56	SUMD3	☐	BELRT	GESBE	CURR	10	2	Receipt Total in Weekly Report
57	SUMD4	☐	BELRT	GESBE	CURR	10	2	Receipt Total in Weekly Report
58	SUMD5	☐	BELRT	GESBE	CURR	10	2	Receipt Total in Weekly Report
59	SUMD6	☐	BELRT	GESBE	CURR	10	2	Receipt Total in Weekly Report
60	SUMD7	☐	BELRT	GESBE	CURR	10	2	Receipt Total in Weekly Report
61	BELRT	☐	BELRT	GESBE	CURR	10	2	Receipt Total in Weekly Report
62	GSBET	☐	GSBET	GESBE	CURR	10	2	Payment Amount
63	KMGES	☐	TKMGS	KMANZ	DEC	5	0	Total miles/kms for the day
64	KMGE1	☐	BELGE	GESBE	CURR	10	2	Miles/Kilometers Allowance
65	KMGE2	☐	BELGE	GESBE	CURR	10	2	Miles/Kilometers Allowance
66	KMGE3	☐	BELGE	GESBE	CURR	10	2	Miles/Kilometers Allowance
67	KMGE4	☐	BELGE	GESBE	CURR	10	2	Miles/Kilometers Allowance
68	KMGE5	☐	BELGE	GESBE	CURR	10	2	Miles/Kilometers Allowance
69	KMGE6	☐	BELGE	GESBE	CURR	10	2	Miles/Kilometers Allowance
70	KMGE7	☐	BELGE	GESBE	CURR	10	2	Miles/Kilometers Allowance
71	KMBET	☐	BELGE	GESBE	CURR	10	2	Miles/Kilometers Allowance
72	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
73	SABKR	☐	SABKR	ABKRS	CHAR	2	0	Payroll subunit for determining editing period	T549A
74	MEHR	☐	AFTLX	XFELD	CHAR	1	0	Further Cost Assignments in Coding Block
75	PAUVS1	☐	PTRV_VORST	XFELD	CHAR	1	0	Input tax entry in Travel Management
76	PAUVS2	☐	PTRV_VORST	XFELD	CHAR	1	0	Input tax entry in Travel Management
77	PAUVS3	☐	PTRV_VORST	XFELD	CHAR	1	0	Input tax entry in Travel Management
78	DEFMWSKZ1	☐	PTRV_DEFMWSKZ	XFELD	CHAR	1	0	Input Tax Default Value for International Expense Receipts
79	DEFMWSKZ2	☐	PTRV_DEFMWSKZ	XFELD	CHAR	1	0	Input Tax Default Value for International Expense Receipts
80	HCURR0	☐	PTRV_HCURR	XFELD	CHAR	1	0	Settlement of foreign curr.receipts and advances
81	HCURR1	☐	PTRV_HCURR	XFELD	CHAR	1	0	Settlement of foreign curr.receipts and advances
82	HCURR2	☐	PTRV_HCURR	XFELD	CHAR	1	0	Settlement of foreign curr.receipts and advances
83	KZREA_DFW_	☐	PTRV_KZREA_DFW_	XFELD	CHAR	1	0	Business trip
84	KZREA_DFW_1	☐	PTRV_KZREA_DFW_1	XFELD	CHAR	1	0	Off-site work
85	KZREA_DFW_2	☐	PTRV_KZREA_DFW_2	XFELD	CHAR	1	0	Separation Bonus_External_Stay
86	KZREA_DFW_3	☐	PTRV_KZREA_DFW_3	XFELD	CHAR	1	0	Separation bonus_daily_return
87	KZREA_DFW_H	☐	PTRV_KZREA_DFW_H	XFELD	CHAR	1	0	Night in 'Hybel' (Norwegian accounting)
88	KZREA_DFW_B	☐	PTRV_KZREA_DFW_B	XFELD	CHAR	1	0	Bruspenger during course or training (Norwegian accounting)
89	KZREA_DFW_E	☐	PTRV_KZREA_DFW_E	XFELD	CHAR	1	0	Night in pensjonat (Norwegian accounting)
90	KZREA_DFW_P	☐	PTRV_KZREA_DFW_P	XFELD	CHAR	1	0	Private
91	KZREA_DFW_S	☐	PTRV_KZREA_DFW_S	XFELD	CHAR	1	0	Full taxation for trips > 183 days
92	KZREA_DFW_R	☐	PTRV_KZREA_DFW_R	XFELD	CHAR	1	0	Night in hotel (Norwegian accounting)
93	KZREA_DFW_X	☐	PTRV_KZREA_DFW_X	XFELD	CHAR	1	0	Non-business trip
94	KZREA_DFW_L	☐	PTRV_KZREA_DFW_L	XFELD	CHAR	1	0	Business trip > 3 months
95	KZREA_DFW_K	☐	PTRV_KZREA_DFW_K	XFELD	CHAR	1	0	Business trip with receipts - Payment of additional per diem
96	KZREA_DFW_M	☐	PTRV_KZREA_DFW_M	XFELD	CHAR	1	0	Bus.Trip with Receipts - Add.Per Diem as Income-Rel.Expense
97	HBETR	☐	GESBB	GESBE	CURR	10	2	Amount on Individual Receipt
98	CTRLREC	☐	PTRV_CTRLREC	PTRV_CTRLREC	CHAR	1	0	Payment and Taxation of Travel Expense Type
99	ABWLAN	☐	PTRV_PRD_ABWLAN	NUMC4	NUMC	4	0	Number of entries with nonstandard long texts
100	EINDOP	☐	PTRV_PRD_EINDOP	NUMC4	NUMC	4	0	Number of double entries
101	EINFEH	☐	PTRV_PRD_EINFEH	NUMC4	NUMC	4	0	Number of missing entries
102	EINGEL	☐	PTRV_PRD_EINGEL	XFELD	CHAR	1	0	File with Per Diems Has Been Imported
103	GESAMT	☐	PTRV_PRD_GESAMT	NUMC4	NUMC	4	0	Total number of entries
104	KORREK	☐	PTRV_PRD_KORREK	NUMC4	NUMC	4	0	Number of correct entries
105	NICGEF	☐	PTRV_PRD_NICGEF	NUMC4	NUMC	4	0	Missing entries
106	.INCLU--AP	☐				0	0	Enhancement for PTKXX in Extension System
107	HCURR3	☐	PTRV_HCURR	XFELD	CHAR	1	0	Settlement of foreign curr.receipts and advances
108	ANTRG00	☐	XDISP	XFELD	CHAR	1	0	Radio buttons for field control
109	ANTRGFI	☐	XDISP	XFELD	CHAR	1	0	Radio buttons for field control
110	ANTRGHR	☐	XDISP	XFELD	CHAR	1	0	Radio buttons for field control
111	ANTRGDT	☐	XDISP	XFELD	CHAR	1	0	Radio buttons for field control
112	KZREA_DFW_A	☐	PTRV_KZREA_DFW_A	XFELD	CHAR	1	0	PS Germany Separation Allowance: Absence from Place of Work
113	KZREA_DFW_5	☐	PTRV_KZREA_DFW_5	XFELD	CHAR	1	0	Ps Germany: Trip to Return from Work
114	KZREA_DFW_4	☐	PTRV_KZREA_DFW_4	XFELD	CHAR	1	0	PS Germany: Trip to Start Work
115	KZREA_DFW_C	☐	PTRV_KZREA_DFW_C	XFELD	CHAR	1	0	Italian Accounting: Per Diem and Flat Rate Settlement
116	KZREA_DFW_D	☐	PTRV_KZREA_DFW_D	XFELD	CHAR	1	0	Italian Accounting: Receipt Settlement (Pie di Lista)
117	KZREA_DFW_6	☐	PTRV_KZREA_DFW_6	XFELD	CHAR	1	0	Italian Accounting: Per Diem + M Receipts
118	KZREA_DFW_7	☐	PTRV_KZREA_DFW_7	XFELD	CHAR	1	0	Italian Accounting: Per Diem + U Receipts
119	KZREA_DFW_8	☐	PTRV_KZREA_DFW_8	XFELD	CHAR	1	0	Italian Accounting: Per Diem + M and U Receipts
120	KZREA_DFW_G	☐	PTRV_KZREA_DFW_G	XFELD	CHAR	1	0	Italian Accounting: Trip Within Home Town
121	VERPA_TEXT	☐	VERPA_TEXT	CHAR38	CHAR	38	0	Name of Checkbox "Meals per Diem"
122	M_RECEIPTS_VALID	☐	PTKXX_M_RECEIPTS_VALID	CHAR1	CHAR	1	0	Receipts of Expense Category M Are Valid
123	M_RECEIPTS_NOT_VALID	☐	PTKXX_M_RECEIPTS_NOT_VALID	CHAR1	CHAR	1	0	Receipts of Expense Category M Are Not Valid
124	U_RECEIPTS_VALID	☐	PTKXX_U_RECEIPTS_VALID	CHAR1	CHAR	1	0	Receipts of Expense Category U Are Valid
125	U_RECEIPTS_NOT_VALID	☐	PTKXX_U_RECEIPTS_NOT_VALID	CHAR1	CHAR	1	0	Receipts of Expense Category U Are Not Valid
126	V_RECEIPTS_VALID	☐	PTKXX_V_RECEIPTS_VALID	CHAR1	CHAR	1	0	Receipts of Expense Category V Are Valid
127	V_RECEIPTS_NOT_VALID	☐	PTKXX_V_RECEIPTS_NOT_VALID	CHAR1	CHAR	1	0	Receipts of Expense Category V Are Not Valid
128	S_RECEIPTS_VALID	☐	PTKXX_S_RECEIPTS_VALID	CHAR1	CHAR	1	0	Receipts of Expense Category S Are Valid
129	S_RECEIPTS_NOT_VALID	☐	PTKXX_S_RECEIPTS_NOT_VALID	CHAR1	CHAR	1	0	Receipts of Expense Category S Are Not Valid
130	DATUM_RED_PAUSCH	☐	DATUM_RED_PAUSCH	DATS	DATS	8	0	IT Banking CA: Date from Which Reduced Per Diems Apply
131	PERNR_FOR_SH	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
132	VAT_RFD	☐	PTRV_VATRFD	PTRV_VATRFD	CHAR	1	0	Advanced VAT Refund for Trip Provision Variant
133	ANKUNFT	☐	PTRV_ANKUNFT		CHAR	60	0	Arrival at Home or Workplace
134	ABFAHRT	☐	PTRV_ABFAHRT		CHAR	60	0	Departure from Home or Workplace
135	.INCLU--AP	☐				0	0	Enhancement for PTKXX in R/3 Enterprise Add-On for PS AT
136	BERKZ_DFW_1	☐	PTRV_BERKZ_DFW_1	XFELD	CHAR	1	0	Business Trip: Rate 1
137	BERKZ_DFW_2	☐	PTRV_BERKZ_DFW_2	XFELD	CHAR	1	0	Business Trip: Rate 2
138	BERKZ_DFW_3	☐	PTRV_BERKZ_DFW_3	XFELD	CHAR	1	0	Transport with Business Trips: Rate 1
139	BERKZ_DFW_4	☐	PTRV_BERKZ_DFW_4	XFELD	CHAR	1	0	Transport with District Trips Without Overnight Fee: Rate 2
140	BERKZ_DFW_5	☐	PTRV_BERKZ_DFW_5	XFELD	CHAR	1	0	District Trips with Entitlement to Overnight Fee: Rate 1
141	BERKZ_DFW_6	☐	PTRV_BERKZ_DFW_6	XFELD	CHAR	1	0	District Trips With Entitlement to Overnight Fee: Rate 2
142	BERKZ_DFW_7	☐	PTRV_BERKZ_DFW_7	XFELD	CHAR	1	0	District Trips Without Entitlement to Overnight Fee: Rate 2
143	BERKZ_DFW_8	☐	PTRV_BERKZ_DFW_8	XFELD	CHAR	1	0	Trip Abroad
144	BERKZ_DFW_9	☐	PTRV_BERKZ_DFW_9	XFELD	CHAR	1	0	Absence During Business Trip
145	BERKZ_DFW_A	☐	PTRV_BERKZ_DFW_A	XFELD	CHAR	1	0	Hospital Stay: Rate 1
146	BERKZ_DFW_B	☐	PTRV_BERKZ_DFW_B	XFELD	CHAR	1	0	Hospital Stay: Rate 2

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PTKXX	PERNR	PTRV_HEAD	MANDT	REF	1	CN
2	PTKXX	REINR	PTRV_HEAD	PERNR	REF	1	CN
3	PTKXX	SABKR	T549A	ABKRS	KEY	1	CN
4	PTKXX	SJAHR	T549Q	PABRJ	KEY	1	CN
5	PTKXX	SPERI	T549Q	PABRP	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in