SAP ABAP Table TA20NC1 (Negotiated rental car rates (language-dependent))

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	TA20NC1	Table Relationship Diagram
Short Description	Negotiated rental car rates (language-dependent)

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	LANGU	☑	LANGU	SPRAS	LANG	1	0	Language Key	*
3	PROVIDER	☑	NEGO_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Provider of negotiated rate	TA21P
4	LOCATIONTYPE	☑	NEGO_CAR_GEO_TYPE	FTPD_GEO_TYPE	CHAR	1	0	Geographical area type
5	LOCATION	☑	NEGO_CAR_GEO	FTPD_GEO_ID	CHAR	3	0	Geographical Area of Negotiated Car Rental Rate
6	CAR_CODE	☑	NEGO_CAR_CODE	FTPD_CAR_CODE	CHAR	2	0	Car rental specification of necotiated rate	TA21CA
7	RATECODE	☑	NEGO_CAR_RATE_CODE	FTPD_CAR_RATE_CODE	CHAR	3	0	Negotiated car rental rate	TA21CAR
8	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date	TA20NC
9	SHORTTXT	☐	NEGO_SHORT_TEXT	TEXT20	CHAR	20	0	Description of Rate
10	LONGTXT	☐	NEGO_LONG_TEXT	TEXT132	CHAR	132	0	Rate Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TA20NC1	CAR_CODE	TA21CA	CAR_CODE	KEY	1	CN
2	TA20NC1	ENDDA	TA20NC	ENDDA	TEXT	1	N
3	TA20NC1	PROVIDER	TA21P	PROVIDER	KEY	1	CN
4	TA20NC1	RATECODE	TA21CAR	RATECODE	KEY	1	CN

History

Last changed by/on	SAP	20031107
SAP Release Created in