SAP ABAP Table TA20REBF (Discount Agreement for Flights)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ FI-TV-PL (Application Component) Travel Planning
     ⤷ PTRP (Package) Travel Planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TA20REBF	Table Relationship Diagram
Short Description	Discount Agreement for Flights

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	PROVIDER	☑	REBATE_PROVIDER_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Discount provider	TA21P
3	GEOORG_TYPE	☑	GEO_ORIGIN_TYPE	FTPD_GEO_TYPE	CHAR	1	0	Geographical Origin Type
4	GEOORG	☑	GEO_ORIGIN	FTPD_GEO_ID	CHAR	3	0	Geographical Origin
5	GEODEST_TYPE	☑	GEO_DESTINATION_TYPE	FTPD_GEO_TYPE	CHAR	1	0	Type of Geographical Destination
6	GEODEST	☑	GEO_DESTINATION	FTPD_GEO_ID	CHAR	3	0	Geographical Destination
7	DIRECTIONALITY	☑	DIRECTIONALITY	FTPD_DIRECTIONALITY	CHAR	1	0	Direction
8	ON_CABIN	☑	FLIGHT_CABIN	FTPD_FLIGHT_CABIN	CHAR	1	0	Flight Cabin Class
9	ON_CLASS	☑	FLIGHT_BOOKING_CODE	FTPD_BOOKING_CODE	CHAR	2	0	Booking Code
10	ON_FAREBASIS	☑	REBATE_FARE_BASIS	FTPD_FARE_BASIS	CHAR	8	0	Fare Basis
11	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
12	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
13	TXN_USE	☐	TXN_USE	CHAR1_X	CHAR	1	0	Usage with Reservation
14	PUSE	☐	PUSE_FLAG	CHAR1_X	CHAR	1	0	Private usage permitted
15	ROUTING	☐	ROUTING_NUMBER	FTPD_ROUTING_NUMBER	NUMC	4	0	Route	TA20ROUTE
16	DISC_NATURE	☐	FARE_NATURE	FTPD_FARE_NATURE	CHAR	2	0	Rate Type (One-Way or Round Trip)
17	DISCTYPE	☐	REBATE_DISC_TYPE	FTPD_DISC_TYPE	CHAR	1	0	Discount Type
18	DISCPERCENT	☐	REBATE_DISC_PERCENT	INT2	INT2	5	0	Discount in Percent
19	DISCAMOUNT	☐	REBATE_DISC_AMOUNT	FTPD_AMOUNT	CURR	10	2	Discount Amount
20	AMOUNT_FIRST	☐	AMOUNT_FIRST	CHAR1_X	CHAR	1	0	Deduct Amount First
21	CURRENCY	☐	REBATE_CURRENCY	WAERS	CUKY	5	0	Currency of Rebate Amount	TCURC
22	MANDATORY_USE	☐	MANDATORY_FLAG	CHAR1_X	CHAR	1	0	Usage of Rate is Mandatory
23	FARE_INDEX	☐	FARE_INDEX	NUMC06	NUMC	6	0	Rate Index Tables

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TA20REBF	CURRENCY	TCURC	WAERS	KEY	1	CN
2	TA20REBF	PROVIDER	TA21P	PROVIDER	KEY	1	CN
3	TA20REBF	ROUTING	TA20ROUTE	ROUTING_NUMBER	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in