SAP ABAP Table TCY31_H (Definition of a sort per layout and chart)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TCY31_H	Table Relationship Diagram
Short Description	Definition of a sort per layout and chart

Delivery and Maintenance

Pool/cluster
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	LAYOUT	☑	CY_LAYOUT	CY_LAYOUT	CHAR	10	0	Grouping of layout keys	TCY31_G
3	CHARTNR	☑	CY_CHARTN	CY_CHARTN	NUMC	2	0	Number of chart	TCY31_C
4	SORTING	☑	CY_SORTING	CY_SORTING	CHAR	10	0	Description of a sort per layout and chart	TCY31_F
5	GRUPPE	☑	CY_GRUPPES	CY_GRUPPES	NUMC	2	0	Allocation of sort keys or sort layout key for group
6	SORT	☐	AUFBKEY2	AUFBKEY	CHAR	10	0	Format key for sorting	TCY38
7	SORT_KEY	☐	CYSORT_KEY	CYSORTKEY	CHAR	10	0	Sort key	TCY38_M

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TCY31_H	CHARTNR	TCY31_C	CHARTNR	KEY	1	CN
2	TCY31_H	LAYOUT	TCY31_G	LAYOUT	KEY	1	CN
3	TCY31_H	MANDT	T000	MANDT	KEY	1	CN
4	TCY31_H	SORT	TCY38	AUFBKEY	KEY	1	CN
5	TCY31_H	SORTING	TCY31_F	SORTING	KEY	1	CN
6	TCY31_H	SORT_KEY	TCY38_M	SORT_KEY	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in