1. Home
  2. Resources
  3. SAP Tables
  4. TKEF - CO-PA field catalog

SAP Table TKEF

CO-PA field catalog

TKEF (CO-PA field catalog) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TKEF to other SAP tables.

TKEF table fields

Field Data element Checktable Datatype Length Decimals
FIENM Field Name FIELDNAME CHAR 30 0
USGFL Use flag CGSUSGFL CHAR 1 0
NULL Undefined
B Basic key figure
D Dimension (characteristic)
F Fixed characteristic
K Key figure
S Fixed basic key figure
T Technical field
U Unit
V Fixed unit
ROLNM Data element (semantic domain) ROLLNAME CHAR 30 0
TIMFL Flag: Field with time dimension CGSTIMFL CHAR 1 0
X Yes
NULL No
CHTAB Check table CGSCHTAB CHAR 30 0
CHFIE Check table field CGSCHFIE CHAR 30 0
VALEX Flag: Domain values CGSVALEX CHAR 1 0
X Yes
NULL No
FIXVL Constant (value of characteristic) CGSFIXVL CHAR 18 0
TIMLC Time logic CGSTIMLC CHAR 1 0
NULL Default (no time dependence)
I Time period (from - to)
N Time dependence not taken into account
RETAB Read (text) table CGSRETAB CHAR 30 0
REFIE Read (text) field CGSREFIE CHAR 30 0
REFIL Long Text Field CGSREFIL CHAR 30 0
REFLL Length of long text field CGSREFLL NUMC 6 0
VIEWN View name CGSVIEWN CHAR 30 0
TCDIS Transaction Code: Display Characteristic Values CGSTCDIS CHAR 20 0
TCMOD Transaction Code: Change Characteristic Values CGSTCMOD CHAR 20 0
ATRFB Function Module for Reading Attributes CGDATRFB CHAR 30 0
SPCTR Special handling of fields of an operating concern RKE_SHANDLING CHAR 3 0
010 Personnel Number
020 Retail: Department
031 Retail: Material Group Hierarchy Level 1
032 Retail: Material Group Hierarchy Level 2
033 Retail: Material Group Hierarchy Level 3
034 Retail: Material Group Hierarchy Level 4
035 Retail: Material Group Hierarchy Level 5
036 Retail: Material Group Hierarchy Level 6
050 Region from Table KNA1
051 Region from Table T001W
060 Cost Center
061 Process
101 Product Hierarchy Level 1 from MARA
102 Product Hierarchy Level 2 from MARA
103 Product Hierarchy Level 3 from MARA
104 Product Hierarchy Level 4 from MARA
105 Product Hierarchy Level 5 from MARA
106 Product Hierarchy Level 6 from MARA
107 Product Hierarchy Level 7 from MARA
108 Product Hierarchy Level 8 from MARA
109 Product Hierarchy Level 9 from MARA
111 Product Hierarchy Level 1 from MVKE
112 Product Hierarchy Level 2 from MVKE
113 Product Hierarchy Level 3 from MVKE
114 Product Hierarchy Level 4 from MVKE
115 Product Hierarchy Level 5 from MVKE
116 Product Hierarchy Level 6 from MVKE
117 Product Hierarchy Level 7 from MVKE
118 Product Hierarchy Level 8 from MVKE
119 Product Hierarchy Level 9 from MVKE
121 Product Hierarchy Level 1 from VBAP
122 Product Hierarchy Level 2 from VBAP
123 Product Hierarchy Level 3 from VBAP
124 Product Hierarchy Level 4 from VBAP
125 Product Hierarchy Level 5 from VBAP
126 Product Hierarchy Level 6 from VBAP
127 Product Hierarchy Level 7 from VBAP
128 Product Hierarchy Level 8 from VBAP
129 Product Hierarchy Level 9 from VBAP
800 CRM Marketing Element
801 CRM Cost Element
802 CRM Key Figure
809 CRM Marketing Element (External Display)
810 CRM Business Partner (Locally in CO-PA)
811 CRM Business Partner (Centrally in ERP)
812 CRM Business Partner (No Check Table)
820 CRM Business Transaction Number
821 CRM Business Transaction Type
822 CRM Product Category ID
823 CRM Service Organization
824 CRM Responsible Organizational Unit
825 CRM Service Technician Organization
830 CRM Customer Hierarchy Level 1
831 CRM Customer Hierarchy Level 2
832 CRM Customer Hierarchy Level 3
833 CRM Customer Hierarchy Level 4
834 CRM Customer Hierarchy Level 5
835 CRM Customer Hierarchy Level 6
836 CRM Customer Hierarchy Level 7
837 CRM Customer Hierarchy Level 8
838 CRM Customer Hierarchy Level 9
839 CRM Customer Hierarchy Level 10
850 CRM Title Level 1 (IPM)
851 CRM Title Level 2 (IPM)
852 CRM Title Level 3 (IPM)
853 CRM Market (IPM)
854 CRM Area (IPM)
855 CRM Language (IPM)
860 Project Type (cProjects)
861 Reason for Project (cProjects)
ORTAB Origin Table CGSORTAB CHAR 30 0
ORFIE Origin field CGSORFIE CHAR 30 0
OAPPL Source application CGSOAPPL CHAR 4 0
OAFIE Original field (of the application) CGSOAFIE CHAR 30 0
DIMPR Characteristic Display CGSDIMPR CHAR 1 0
NULL Not assigned
0 Key and text
1 Text
2 Key
3 Text and key
4 Long Text
5 Key and Long Text
6 Long Text and Key
REPIN Report Indicator CGSREPIN CHAR 1 0
NULL Do not use characteristic
1 Characteristic in the 1st group
2 Characteristic in the 2nd group
3 Characteristic in the 3rd group
PLAIN Planning Indicator CGSPLAIN CHAR 1 0
1 Master Characteristic
2 Required Characteristic
3 Optional Characteristic
4 Characteristic "Unit"
5 Dimension "Time"
6 Quantity Field
7 Currency Field
LITIN Line Item Indicator CGSLITIN CHAR 1 0
NULL Characteristic not relevant for line item display
1 Characteristic relevant for actual line item display
2 Characteristic relevant for plan line item display
3 Characteristic relevant for line item display
RCSIN Row/Column Structure Indicator CGSRCSIN CHAR 1 0
NULL Field cannot be selected for form
1 Field can be selected for form
RSLIN Report Selection Indicator CGSRSLIN CHAR 1 0
NULL Field cannot be chosen for a report.
1 Field can be chosen for a report.
2 Field must be selected for report.
CHAIN Characteristic Value Indicator CGSCHAIN CHAR 1 0
NULL Characteristic value cannot be defined in the report.
1 Characteristic value can be defined in the report.
2 Char. value must be defined for each cell (form/report)
3 Characteristic value must be defined completely
4 Characteristic value must be defined for each cell (on list)
5 Characteristic value must be defined uniquely for each cell
AGGDI Aggregation CGSAGGDI CHAR 3 0
MAX Maximum
MIN Minimum
NGA No hierarchy aggregation (only to be used internally)
NHA No hierarchy aggregation (only to be used internally)
NO1 No aggregation (X, if more than one record occurs)
NO2 No aggregation (X, if more than one value occurs)
NOP No aggregation (X, if more than one value not = 0 occurs)
SCP Summation if > 0
SCM Summation if < 0
SUM Summation
AGGTM Aggregation based on time CGSAGGTM CHAR 3 0
AVG Average (all values)
AV0 Average (values not equal to zero)
AV1 Average (weighted to relevant calendar days)
AV2 Average (weighted to factory calendar days)
CNA Counter (all values)
CNT Counter (values not =0)
FIR First value
LAS Last value
MAX Maximum
MIN Minimum
NOP No aggregation (X, if more than one value not = 0 occurs)
SCP Summation if > 0
SCM Summation if < 0
STD Standard deviation
SUM Summation
VAR Variance
AGGFI Reference Field for Time-Based Aggregation CGSAGGFI CHAR 30 0
PRDEC Decimal Places (Output) CGSDEC CHAR 1 0
PRSNT Scaling factor CGSPRS CHAR 1 0
SBGRP Key figure groups CGSSBGRP TKCKU CHAR 3 0
CCNUM Currency Translation Number CGSCCNUM NUMC 3 0
DCURR Target Currency CGSDCURR TCURC CUKY 5 0
RFTAB Table for reference field REFTABLE CHAR 30 0
RFFIE Reference field for currency and qty fields REFFIELD CHAR 30 0
DSRFF Reference field in the data structure CGSDSRFF CHAR 30 0
CQMRK Quantity/amount/number indicator CGSCQMRK CHAR 1 0
C Amount (currency)
Q Quantity
D Number (without unit)
CUKY0 Currency CGSCUKY TCURC CUKY 5 0
UNIT0 Unit CGSUNIT T006 UNIT 3 0
CQFIE Reference field for currency / unit CGSCQFIE CHAR 30 0
TFLAG Flag: Text CGSTFLAG CHAR 1 0
COBJID Folder Entry ID (Obj+Fol+Forwarder Name) SO_ENTRYID CHAR 46 0
DMAC Matchcode CGSDMAC CHAR 31 0
CHNAM User CGSCHNAM CHAR 12 0
CHDAT Changed On CGSCHDAT DATS 8 0
CHTIM Time of Change CGSCHTIM TIMS 6 0
KFLDN Field name for SD interface RKE_KFLDN CHAR 30 0

TKEF foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TKEF CUKY0 TKEF CUKY0 TCURC Currency Codes WAERS
TKEF CUKY0 CGSPAR MANDT TCURC Currency Codes MANDT
TKEF DCURR CGSPAR MANDT TCURC Currency Codes MANDT
TKEF DCURR TKEF DCURR TCURC Currency Codes WAERS
TKEF SBGRP CGSPAR APPLC TKCKU Key Figure Assignment Groups APPLC
TKEF SBGRP TKEF SBGRP TKCKU Key Figure Assignment Groups SBGRP
TKEF UNIT0 CGSPAR MANDT T006 Units of Measurement MANDT
TKEF UNIT0 TKEF UNIT0 T006 Units of Measurement MSEHI