SAP ABAP Table TCNS (Project Info System: Sort Criteria)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-IS (Application Component) Information System
     ⤷ CNIS (Package) Application development R/3 PS information system

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TCNS	Table Relationship Diagram
Short Description	Project Info System: Sort Criteria

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	TABNAME	☑	TABNAME	AS4TAB	CHAR	30	0	Table Name	TCNE
3	PROFID	☑	PS_PROF_SR	PS_PROF_SR	CHAR	12	0	Project Information System Profile: Sort Criteria
4	KENNI	☑	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
5	FIELDNAME	☐	FIELDNAME	FDNAME	CHAR	30	0	Field Name	DD03L
6	AENAM	☐	PS_AENAM	USNAM	CHAR	12	0	Last changed by
7	PROTECT	☐	PS_PROTECT	XFELD	CHAR	1	0	Indicator: Protected entry
8	CUSTOM	☐	PS_CUSTOM	XFELD	CHAR	1	0	Indicator: Maintenance only allowed from initial menu
9	SORT_DOWN	☐	FLAG_DOWN	XFELD	CHAR	1	0	Sort in descending order
10	ORIGIN	☐	PS_ORIGIN	PS_ORIGIN	CHAR	1	0	Origin indicator for field names

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TCNS	FIELDNAME	DD03L	FIELDNAME	REF	C	CN
2	TCNS	MANDT	T000	MANDT	KEY	1	CN
3	TCNS	TABNAME	TCNE	TABNAME	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in