SAP ABAP Table V_TA20NC (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TA20NC	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	PROVIDER	☑	NEGO_PROVIDER	FTPD_PROVIDER_CODE	CHAR	3	0	Provider of negotiated rate	TA21P
3	LOCATIONTYPE	☑	NEGO_CAR_GEO_TYPE	FTPD_GEO_TYPE	CHAR	1	0	Geographical area type
4	LOCATION	☑	NEGO_CAR_GEO	FTPD_GEO_ID	CHAR	3	0	Geographical Area of Negotiated Car Rental Rate
5	CAR_CODE	☑	NEGO_CAR_CODE	FTPD_CAR_CODE	CHAR	2	0	Car rental specification of necotiated rate	TA21CA
6	RATECODE	☑	NEGO_CAR_RATE_CODE	FTPD_CAR_RATE_CODE	CHAR	3	0	Negotiated car rental rate	TA21CAR
7	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
8	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
9	CORPDISC	☐	CORPO_DISCOUNT	CHAR20	CHAR	20	0	Contract number for identification
10	PUSE	☐	PUSE_FLAG	CHAR1_X	CHAR	1	0	Private usage permitted
11	PRICE	☐	NEGO_FARE	FTPD_PRICE	CURR	10	2	Price of negotiated rate
12	CURRENCY	☐	NEGO_FARE_CURRENCY	WAERS	CUKY	5	0	Currency of negotiated rate	TCURC
13	SHORTTXT	☐	NEGO_SHORT_TEXT	TEXT20	CHAR	20	0	Description of Rate
14	LONGTXT	☐	NEGO_LONG_TEXT	TEXT132	CHAR	132	0	Rate Description
15	KTEXT	☐	KTEXT_CURT	TEXT15	CHAR	15	0	Short text
16	NAME	☐	PROVIDER_NAME	TEXT30	CHAR	30	0	Provider Name
17	CARSPEC	☐	CAR_CODE_NAME	TEXT30	CHAR	30	0	Description of rental car classification

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_TA20NC	CAR_CODE	TA21CA	CAR_CODE	KEY	1	CN
2	V_TA20NC	CURRENCY	TCURC	WAERS	REF	1	CN
3	V_TA20NC	PROVIDER	TA21P	PROVIDER	KEY	1	CN
4	V_TA20NC	RATECODE	TA21CAR	RATECODE	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in