SAP ABAP Table PTRV_UTIL_ZIEL (Destinations of Trip)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV-COS (Application Component) Travel Expenses
     ⤷ PTRA_WEB_INTERFACE (Package) RFC Modules for Web User Interface: Travel Expenses

Basic Data

Table Category	INTTAB	Structure
Structure	PTRV_UTIL_ZIEL	Table Relationship Diagram
Short Description	Destinations of Trip

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	.INCLUDE	☐				0	0	Stopover
2	ZIKEY	☐	KEYZI	KEYZI	CHAR	2	0	Destination Assignment
3	KZREA	☐	KZREA	KZREA	CHAR	1	0	Trip Type: Statutory	T702G
4	KZTKT	☐	KZTKT	KZTKT	CHAR	1	0	Trip Activity Type	T702R
5	ZLAND	☐	LNDGR	LNDGR	CHAR	3	0	Trip Country / Trip Country Group	T702O
6	BEREI	☐	BEREI	BEREI	CHAR	1	0	Trip Type: Enterprise-Specific	T702X
7	ZORT1	☐	RZIEL	RZIEL	CHAR	17	0	Location
8	KUNDE	☐	RKUND	RKUND	CHAR	17	0	Reason for trip (e.g. customer/requisitioner)
9	RVDAT	☐	REBED	REDAT	DATS	8	0	Beginning Date of Trip Segment
10	RVUHR	☐	REBEU	REUHR	TIMS	6	0	Beginning Time of Trip Segment
11	RBDAT	☐	REEND	REDAT	DATS	8	0	End Date of Trip Segment
12	RBUHR	☐	REENU	REUHR	TIMS	6	0	End Time of Trip Segment
13	RADAT	☐	DATZA	REDAT	DATS	8	0	Trip Segment: Arrival Date
14	RAUHR	☐	UHRZA	REUHR	TIMS	6	0	Part of trip: Arrival time
15	UEBPA	☐	ANUEP	ANUEP	DEC	2	0	Number of Overnight Stays for Per-Diem Settlement
16	KZPRI	☐	KZPRI	XFELD	CHAR	1	0	Private Stopover
17	RGION	☐	RGION	RGION	CHAR	5	0	Trip Country/Trip Country Group/Trip Region	T702O
18	PROTECT	☐	PROTECT	PRTV_PROTECT	CHAR	1	0	Protection Indicator of Entry
19	.INCLU--AP	☐				0	0	Enhancement of Travel Expenses Destination Structure PTK05
20	ABWH_ART	☐	PTRVPS_ABWH_ART	PTRVPS_ABWH_ART	CHAR	1	0	Absence type
21	ZUSCH_ART	☐	PTRVPS_ZUSCH_ART	PTRVPS_ZUSCH_ART	CHAR	1	0	Allowance Type
22	TRG_PARTNER	☐	PTRVPS_PARTNER	PTRVPS_PARTNER	CHAR	1	0	Separation Allowance Action of Spouse at Same Location
23	ENTGELT_UNTERK	☐	PTRVPS_ENTG_UNT	XFELD	CHAR	1	0	Chargeable Accommodations Retained During Absence
24	TAX_PER_DIEM	☐	PTRV_TAX_PER_DIEM	XFELD	CHAR	1	0	Automatic Taxation of Meals and Accommodations Per Diems
25	TAX_PD_MAN	☐	PTRV_TAX_PD_MAN	XFELD	CHAR	1	0	Manually Triggered Taxation of Meals Per Diems
26	TAX_OV_MAN	☐	PTRV_TAX_OV_MAN	XFELD	CHAR	1	0	Manually Triggered Taxation of Accommodations Per Diems
27	SLEEP_AT_HOME	☐	PTRV_SLEEP_AT_HOME	XFELD	CHAR	1	0	Overnight Stay at Home
28	MPD_EXCL	☐	GLO_PTRV_MPD_EXCL	XFELD	CHAR	1	0	Exclude Meals Per Diem From Calculation
29	.INCLU-ADR	☐				0	0	Travel Web Interface: Addresses
30	ADRNRADR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
31	CITYADR	☐	AD_CITY1	TEXT40	CHAR	40	0	City
32	CITY_DISTRICTADR	☐	AD_CITY2	TEXT40	CHAR	40	0	District
33	POST_CODEADR	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
34	CITY_CODEADR	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
35	STREETADR	☐	AD_STREET	TEXT60	CHAR	60	0	Street
36	HOUSE_NUMADR	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
37	COUNTRYADR	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
38	REGIONADR	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
39	DISPLAY_ONLY	☐	STOPOVER_DISPLAY_ONLY	XFELD	CHAR	1	0	Stopover Can Only Be Displayed
40	PLAN_ACTIVITY_TYPE	☐	PLAN_ACTIVITY	FTPD_PLAN_ACTIVITY	CHAR	1	0	Trip Activity Type	*
41	REQ_ITINERARY_NUMBER	☐	ITINERARY_NUMBER	PTRVNUMC2	NUMC	2	0	Number of trip segment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PTRV_UTIL_ZIEL	BEREI	T702X	BEREI	KEY	1	CN
2	PTRV_UTIL_ZIEL	KZREA	T702G	KZREA	KEY	1	CN
3	PTRV_UTIL_ZIEL	KZTKT	T702R	KZTKT	KEY	1	CN
4	PTRV_UTIL_ZIEL	RGION	T702O	RGION		1	CN
5	PTRV_UTIL_ZIEL	ZLAND	T702O	LAND1	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	100