Custom Databases

The following lists the file name of each custom database file. Using SAP Crystal Reports, you can access the custom page databases and create your own reports to review and use your information.

Note: The database structure for these files vary based on the custom fields you have added for your custom pages.

HRTKPERS field information

 
Seq Field Name Type Length Dec Description

1

U_COMPANY

C

3

0

Employer Code

2

U_EMPNO

C

9

0

Employee ID

3

U_CHADATE

D

8

0

Change Date

TKFIELD field information

 
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 Page

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

TKSCREEN field information

 
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

Page 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 Page

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

TKMULXXX field information

 
Seq Field Name Type  Length Dec Description

1

U_COMPANY

C

3

0

Employer Code

2

U_EMPNO

C

9

0

Employee ID

Note: The TKMULXXX files relate to multi-record pages only. The number of multi-record custom page databases varies based on the number of multi-record pages you create. You can create 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 all TKMULXXX files varies based on the custom fields you have added to your Employee, Applicant or Requisition multi-record custom pages.