SAP table TCNS (Project Info System: Sort Criteria)

SAP table TCNS has 4 primary key fields being MANDT,TABNAME,PROFID,KENNI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TABNAME Table Name CHAR 30 0 TCNE TABNAME
PROFID Project Information System Profile: Sort Criteria CHAR 12 0 PS_PROF_SR
KENNI Numc3, internal use NUMC 3 0 NUMC3
FIELDNAME Field Name CHAR 30 0 DD03L FIELDNAME
AENAM Last changed by CHAR 12 0 PS_AENAM
PROTECT Indicator: Protected entry CHAR 1 0 PS_PROTECT
CUSTOM Indicator: Maintenance only allowed from initial menu CHAR 1 0 PS_CUSTOM
SORT_DOWN Sort in descending order CHAR 1 0 FLAG_DOWN
ORIGIN Origin indicator for field names CHAR 1 0 PS_ORIGIN
Field name from data dictionary
A Field name from earned value analysis (Customizing)

TCNS foreign key relationships

Table Field Check Table Check Field
0 TCNS FIELDNAME DD03L Table Fields TABNAME
0 TCNS FIELDNAME DD03L Table Fields FIELDNAME
0 TCNS FIELDNAME DD03L Table Fields AS4LOCAL
0 TCNS FIELDNAME DD03L Table Fields AS4VERS
1 TCNS TABNAME TCNE PS Info System: Object Table for Reporting Structures TABNAME