SAP table CEFORMS (Table for description of structures)
SAP table CEFORMS has 8 primary key fields being MANDT,APPLCLASS,SUBCLASS,TABNAME,FORM,SUBNR,ELNR1,ELNR2.
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
MANDT
Client
CLNT
3
0
T000
MANDT
APPLCLASS
Application class for DD objects (not used)
CHAR
4
0
TAPPL
APPLCLASS
SUBCLASS
Subgroup by application class
CHAR
2
0
SUBCLASS
TABNAME
Table Name
CHAR
30
0
*
TABNAME
FORM
Form
CHAR
12
0
TKES1
RKE_CFORM
SUBNR
Subnumber
NUMC
2
0
RKE_SUBNR
ELNR1
Element number of a structure
NUMC
4
0
RKE_ELNR
ELNR2
Element number of a structure
NUMC
4
0
RKE_ELNR
EDIM
CO-PA dimension of an element
CHAR
1
0
RKE_EDIM
FLEVEL
Level of structure
NUMC
1
0
RKE_FLEVEL
ELTYP
Element type
CHAR
1
0
RKE_ETYP
NUMBR
Number of translation key in currency translation
NUMC
3
0
*
CFNUMBR
ABLAGE
Element storage type
CHAR
1
0
RKE_ATYP
POINTER
Element pointer
CHAR
30
0
RKE_POINT
ZWAERS
Target Currency
CUKY
5
0
*
CGSDCURR
EDIMP
CO-PA dimension of an element
CHAR
1
0
RKE_EDIM
ATTRB
User Attribute (Internal Number)
CHAR
4
0
KPP_UATTR
Possible values
H001
Data Cell
H002
Distribution Key
H003
Action for Data Field
H004
Quantity/Currency Unit
H005
Misc. Non-Data Field Man.
INPUT
Set as Ready for Input
CHAR
1
0
INPUT
LPAGE
Report/Planning Painter: Logical page
NUMC
4
0
*
RKE_LPAGE
CEFORMS foreign key relationships
Table
Field
Check Table
Check Field
0 CEFORMS
APPLCLASS
TAPPL
R/3-DDIC: Application classes
APPLCLASS
1 CEFORMS
FORM
TKES1
Row/column structures
MANDT
1 CEFORMS
FORM
TKES1
Row/column structures
APPLCLASS
1 CEFORMS
FORM
TKES1
Row/column structures
TABNAME
1 CEFORMS
FORM
TKES1
Row/column structures
FORM
0 CEFORMS
MANDT
T000
Clients
MANDT