1. Home
  2. Resources
  3. SAP Tables
  4. V_TKEF - Generated Table for View

SAP Table V_TKEF

Generated Table for View

V_TKEF (Generated Table for View) 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 V_TKEF to other SAP tables.

Source: V_TKEF (Generated Table for View)

V_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
CQMRK Quantity/amount/number indicator CGSCQMRK CHAR 1 0
C Amount (currency)
Q Quantity
D Number (without 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
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
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
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
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
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
DMAC Matchcode CGSDMAC CHAR 31 0
KFLDN Field name for SD interface RKE_KFLDN CHAR 30 0
CHNAM User CGSCHNAM CHAR 12 0
CHDAT Changed On CGSCHDAT DATS 8 0
CHTIM Time of Change CGSCHTIM TIMS 6 0