SAP table TKEF (CO-PA field catalog)

SAP table TKEF has 2 primary key fields being FIENM,USGFL.

Field Description Data Type Length Decimals Checktable Data Element
FIENM Field Name CHAR 30 0 FIELDNAME
USGFL Use flag CHAR 1 0 CGSUSGFL
ROLNM Data element (semantic domain) CHAR 30 0 ROLLNAME
TIMFL Flag: Field with time dimension CHAR 1 0 CGSTIMFL
CHTAB Check table CHAR 30 0 CGSCHTAB
CHFIE Check table field CHAR 30 0 * CGSCHFIE
VALEX Flag: Domain values CHAR 1 0 CGSVALEX
FIXVL Constant (value of characteristic) CHAR 18 0 CGSFIXVL
TIMLC Time logic CHAR 1 0 CGSTIMLC
Default (no time dependence)
I Time period (from - to)
N Time dependence not taken into account
RETAB Read (text) table CHAR 30 0 CGSRETAB
REFIE Read (text) field CHAR 30 0 * CGSREFIE
REFIL Long Text Field CHAR 30 0 * CGSREFIL
REFLL Length of long text field NUMC 6 0 CGSREFLL
VIEWN View name CHAR 30 0 * CGSVIEWN
TCDIS Transaction Code: Display Characteristic Values CHAR 20 0 * CGSTCDIS
TCMOD Transaction Code: Change Characteristic Values CHAR 20 0 * CGSTCMOD
ATRFB Function Module for Reading Attributes CHAR 30 0 * CGDATRFB
SPCTR Special handling of fields of an operating concern CHAR 3 0 RKE_SHANDLING
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 CHAR 30 0 CGSORTAB
ORFIE Origin field CHAR 30 0 * CGSORFIE
OAPPL Source application CHAR 4 0 * CGSOAPPL
OAFIE Original field (of the application) CHAR 30 0 * CGSOAFIE
DIMPR Characteristic Display CHAR 1 0 CGSDIMPR
REPIN Report Indicator CHAR 1 0 CGSREPIN
PLAIN Planning Indicator CHAR 1 0 CGSPLAIN
LITIN Line Item Indicator CHAR 1 0 CGSLITIN
RCSIN Row/Column Structure Indicator CHAR 1 0 CGSRCSIN
RSLIN Report Selection Indicator CHAR 1 0 CGSRSLIN
CHAIN Characteristic Value Indicator CHAR 1 0 CGSCHAIN
AGGDI Aggregation CHAR 3 0 CGSAGGDI
AGGTM Aggregation based on time CHAR 3 0 CGSAGGTM
AGGFI Reference Field for Time-Based Aggregation CHAR 30 0 * CGSAGGFI
PRDEC Decimal Places (Output) CHAR 1 0 CGSDEC
PRSNT Scaling factor CHAR 1 0 CGSPRS
SBGRP Key figure groups CHAR 3 0 TKCKU CGSSBGRP
CCNUM Currency Translation Number NUMC 3 0 CGSCCNUM
DCURR Target Currency CUKY 5 0 TCURC CGSDCURR
RFTAB Reference Table for Field CHAR 30 0 * REFTABLE
RFFIE Reference Field for Currency and Quantity Fields CHAR 30 0 * REFFIELD
DSRFF Reference field in the data structure CHAR 30 0 * CGSDSRFF
CQMRK Quantity/amount/number indicator CHAR 1 0 CGSCQMRK
CUKY0 Currency CUKY 5 0 TCURC CGSCUKY
UNIT0 Unit UNIT 3 0 T006 CGSUNIT
CQFIE Reference field for currency / unit CHAR 30 0 * CGSCQFIE
TFLAG Flag: Text CHAR 1 0 CGSTFLAG
COBJID Folder Entry ID (Obj+Fol+Forwarder Name) CHAR 46 0 SO_ENTRYID
DMAC Matchcode CHAR 31 0 CGSDMAC
CHNAM User CHAR 12 0 CGSCHNAM
CHDAT Changed On DATS 8 0 CGSCHDAT
CHTIM Time of Change TIMS 6 0 CGSCHTIM
KFLDN Field name for SD interface CHAR 30 0 RKE_KFLDN
COPAACDOCA_FIELD Name of CO-PA field in structure ACDOCA CHAR 30 0 FCO_COPAACDOCA_FIELD
LEVEL_ACDOC_ITEM The Level of the field in structure FINS_ACDOC_ITEM CHAR 1 0 FCO_POS_FINS_ACDOC_ITEM
C customer specific CO-PA field - in COPA_EXT
E Enhancement field - in EXT - lowest level
F CO-PA field - in COPA_FIX
M business context market segment field - lowest level
N normal - lowest level
Q in quantity table FINST_ACDOC_QUANTITY
IS_KEY_USER_FIELD Key User Field CHAR 1 0 FCO_KEY_USER_FIELD
FIELD_INCONSISTENT SFIN: Field is inconsistent CHAR 1 0 FCO_COPA_FIELD_INCONSISTENT
C Checktable for custom field is inconsistent
I Custom field is incomplete

TKEF foreign key relationships

Table Field Check Table Check Field
0 TKEF CUKY0 TCURC Currency Codes MANDT
0 TKEF CUKY0 TCURC Currency Codes WAERS
1 TKEF DCURR TCURC Currency Codes MANDT
1 TKEF DCURR TCURC Currency Codes WAERS
0 TKEF SBGRP TKCKU Key Figure Assignment Groups APPLC
1 TKEF UNIT0 T006 Units of Measurement MANDT
1 TKEF UNIT0 T006 Units of Measurement MSEHI