Custom Details database file list
The following sections shows the field names and information about each database file. The files are listed alphabetically by file name. Using SAP Crystal Reports, you can access the custom page databases and create your own reports.
Seq | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
U_CHADATE |
D |
8 |
0 |
Change Date |
2 |
U_COMPANY |
C |
3 |
0 |
Employer Code |
3 |
U_EMPNO |
C |
9 |
0 |
Employee ID |
Note: The database structure for this file varies based on the custom fields added for your company's custom pages.
Seq | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
D_ALIAS |
C |
8 |
0 |
Field Alias |
2 |
D_CHGLEVEL |
C |
10 |
0 |
Change Level |
3 |
D_DEC |
N |
3 |
0 |
Decimal Places |
4 |
D_DESC |
C |
40 |
0 |
Field Description |
5 |
D_DOSCOMP |
C |
3 |
0 |
DOS Company Code |
6 |
D_FIELD |
C |
10 |
0 |
Field Name |
7 |
D_FILE |
C |
8 |
0 |
File Name |
8 |
D_FORMULA |
M |
10 |
0 |
Formula |
9 |
D_LEN |
N |
3 |
0 |
Field Length |
10 |
D_LEVEL |
N |
2 |
0 |
RR Security Level |
11 |
D_MASSUP |
L |
1 |
0 |
Mass Updateable |
12 |
D_OBJTYPE |
C |
1 |
0 |
Object Type |
13 |
D_ORDER |
N |
2 |
0 |
Order |
14 |
D_PANEL |
C |
30 |
0 |
Related Detail |
15 |
D_SECNAME |
C |
8 |
0 |
Secondary Alias Name |
16 |
D_TABLE |
C |
2 |
0 |
Table ID |
17 |
D_TABNAME |
C |
25 |
0 |
Table Name |
18 |
D_TYPE |
C |
1 |
0 |
Field Type |
19 |
D_WIDTH |
N |
4 |
0 |
Font Width |
Seq | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
S_ALIAS |
C |
8 |
0 |
Field Alias |
2 |
S_COL |
C |
10 |
0 |
Column Position |
3 |
S_DOSCOMP |
C |
3 |
0 |
DOS Company Code |
4 |
S_FIELD |
C |
10 |
0 |
Field Name |
5 |
S_LBLLEFT |
N |
3 |
0 |
Left Position of Label |
6 |
S_NAME |
C |
25 |
0 |
Detail Name |
7 |
S_OBJLEFT |
N |
3 |
0 |
Left Position of Object |
8 |
S_OBJTYPE |
C |
1 |
0 |
Object Type |
9 |
S_OBJWIDTH |
N |
3 |
0 |
Object Width |
10 |
S_PAGE |
N |
1 |
0 |
Page Number |
11 |
S_PANTYPE |
C |
2 |
0 |
Type of Detail |
12 |
S_REQUIRED |
C |
1 |
0 |
Required Field |
13 |
S_ROW |
C |
1 |
0 |
Row Position |
14 |
S_SECURITY |
C |
10 |
0 |
Security Setting |
15 |
S_TITLE |
C |
20 |
0 |
Field Title |
16 |
S_VALIDATE |
C |
1 |
0 |
User Defined Function Call |
Seq | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
Code |
C |
15 |
0 |
Code |
2 |
Desc |
C |
25 |
0 |
Description |
3 |
Program |
C |
100 |
0 |
Program Call |
4 |
UD1 |
C |
25 |
0 |
User-Defined Title 1 |
5 |
UD2 |
C |
25 |
0 |
User-Defined Title 2 |
6 |
UD3 |
C |
25 |
0 |
User-Defined Title 3 |
7 |
UD4 |
C |
25 |
0 |
User-Defined Title 4 |
8 |
UD5 |
C |
25 |
0 |
User-Defined Title 5 |
9 |
UD6 |
C |
25 |
0 |
User-Defined Title 6 |
Seq | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
U_COMPANY |
C |
3 |
0 |
Employer Code |
2 |
U_EMPNO |
C |
9 |
0 |
Employee ID |
Note: These database files relate to multi-record pages only. There can be up to 999 multi-record pages, thus the name
of the database file can be TKMUL001 to TKMUL999. The database file description
includes the name of the page.
The database structure for these TKMULXXX files varies based on the custom
fields added to your company's multi-record custom pages.