SAP table TCNF (Project Information System: Displayed Fields)
SAP table TCNF 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
Client
CLNT
3
0
T000
MANDT
Table Name
CHAR
30
0
TCNE
TABNAME
Information System Profile: Displayed Fields
CHAR
12
0
PS_PROF_FD
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
OUTPUTLEN
Output Length
NUMC
6
0
OUTPUTLEN
FACTOR
Conversion factor for displaying values
CHAR
1
0
MCFACTOR
ODECIMALS
Number of decimal places
CHAR
1
0
MCDECIP
Possible values
Decimal Places for Domain/Unit
0
No Decimal Places
1
1 Decimal Place
2
2 Decimal Places
3
3 Decimal Places
4
4 Decimal Places
5
5 Decimal Places
6
6 Decimal Places
7
7 Decimal Places
8
8 Decimal Places
9
9 Decimal Places
ORIGIN
Origin indicator for field names
CHAR
1
0
PS_ORIGIN
Possible values
Field name from data dictionary
A
Field name from earned value analysis (Customizing)
TCNF foreign key relationships
Table
Field
Check Table
Check Field
0 TCNF
FIELDNAME
DD03L Table Fields
TABNAME
0 TCNF
FIELDNAME
DD03L Table Fields
FIELDNAME
0 TCNF
FIELDNAME
DD03L Table Fields
AS4LOCAL
0 TCNF
FIELDNAME
DD03L Table Fields
AS4VERS
1 TCNF
TABNAME
TCNE PS Info System: Object Table for Reporting Structures
TABNAME