SAP table V_TKEF (Generated Table for View)

SAP table V_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
CQMRK Quantity/amount/number indicator CHAR 1 0 CGSCQMRK
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
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
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
DIMPR Characteristic Display CHAR 1 0 CGSDIMPR
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
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
DMAC Matchcode CHAR 31 0 CGSDMAC
KFLDN Field name for SD interface CHAR 30 0 RKE_KFLDN
CHNAM User CHAR 12 0 CGSCHNAM
CHDAT Changed On DATS 8 0 CGSCHDAT
CHTIM Time of Change TIMS 6 0 CGSCHTIM