SAP ABAP Table TCY09 (List profiles (standard settings for lists))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CY (Package) R/3 Application development: Capacity Planning

Basic Data

Table Category	POOL	Pooled table
Pooled table	TCY09	Table Relationship Diagram
Short Description	List profiles (standard settings for lists)

Delivery and Maintenance

Pool/cluster	ATAB
Delivery Class	E	Control table, SAP and customer have separate key areas
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	T000
2	LISPROF_ID	☑	LISPROF_ID	LISPROF_ID	CHAR	10	0	List profile
3	LVARI	☐	CY_LVARI	CHAR2	CHAR	2	0	Version of the detailed capacity list
4	LIVAR	☐	CY_LIVAR	CY_LIVAR	CHAR	10	0	List version of variable overview	TCY17
5	SORT1	☐	CY_SORT1	CY_SORT	NUMC	1	0	Sort accord. to sort criterion "order number"
6	SORT2	☐	CY_SORT2	CY_SORT	NUMC	1	0	Sort accord. to start date
7	SORT3	☐	CY_SORT3	CY_SORT	NUMC	1	0	Sort accord. to finish date
8	SORT4	☐	CY_SORT4	CY_SORT	NUMC	1	0	Sort according to sort criterion "delivery date"
9	SORT5	☐	CY_SORT5	CY_SORT	NUMC	1	0	Sorting acc. to sort criterion "priority"
10	DEFLISTE	☐	CY_DEFLIST	CY_DEFLIST	CHAR	1	0	Default list
11	EX_PFAD	☐	PC_PATH	PC_PATH	CHAR	66	0	PC path name
12	EX_INQ	☐	CY_EXINQ	KREUZ	CHAR	1	0	Query for file name in case of download?
13	EX_DVAR	☐	CY_LVARI	CHAR2	CHAR	2	0	Version of the detailed capacity list
14	EX_UDAT	☐	CY_EXUDAT	PC_FNAME	CHAR	8	0	File name of EXCEL table for standard overview
15	EX_DDAT	☐	CY_EXDDAT	PC_FNAME	CHAR	8	0	File name of EXCEL table for detailed capacity list
16	EX_VDAT	☐	CY_EXVDAT	PC_FNAME	CHAR	8	0	File name of EXCEL table for variable overview
17	EX_OVER	☐	CY_EXOVER	KREUZ	CHAR	1	0	Query before overwriting an existing file
18	EX_PAGE	☐	CPCODEPAGE	CPCODEPAGE	NUMC	4	0	SAP Character Set ID	TCP00
19	EX_DVAR1	☐	PROFID_LIS	PROFID_LIS	CHAR	12	0	Profile for a list version	TCYD
20	EX_TABNAME	☐	TABNAME	AS4TAB	CHAR	30	0	Table Name	TCYE
21	LVARILIS	☐	PROFID_LIS	PROFID_LIS	CHAR	12	0	Profile for a list version	TCYD
22	TABNAME	☐	TABNAME	AS4TAB	CHAR	30	0	Table Name	TCYE

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TCY09	EX_DVAR1	TCYD	PROFID_LIS	KEY	1	CN
2	TCY09	EX_PAGE	TCP00	CPCODEPAGE
3	TCY09	EX_TABNAME	TCYE	TABNAME	KEY	1	CN
4	TCY09	LIVAR	TCY17	LIVAR	KEY	1	CN
5	TCY09	LVARILIS	TCYD	PROFID_LIS	KEY	1	CN
6	TCY09	MANDT	T000	MANDT	KEY	1	CN
7	TCY09	TABNAME	TCYE	TABNAME	KEY	1	CN

History

Last changed by/on	SAP	19971105
SAP Release Created in