Microsoft Access DDIC (SAP Data Repository)

You should read the table from top to bottom to see the order in which the data fields are stored in the data records in the Access database.

Field name is the name of the field in the table. Type shows the field’s attribute and length gives the length of the data field. Text indicates the type of data.

Field name

Type

Length

Text

TABNAME

CHAR

10

Table name

FIELDNAME

CHAR

10

Field name

LANGU

LANG

1

Language

POSITION

NUMC

4

–

OFFSET

NUMC

6

Offset

DOMNAME

CHAR

10

Domain name

ROLLNAME

CHAR

10

Data element

CHECKTABLE

CHAR

10

Table name

LENG

NUMC

6

Field length

INTLEN

NUMC

6

Internal length

OUTPUTLEN

NUMC

6

Output length

DECIMALS

NUMC

6

Decimal places

DATATYPE

CHAR

4

Data type

INTTYPE

CHAR

1

Internal type

REFTABLE

CHAR

10

Reference table

REFFIELD

CHAR

10

Reference field

PRECFIELD

CHAR

10

Precise field

AUTHORID

CHAR

3

Authorization

MEMORYID

CHAR

3

Set/get parameter ID

LOGFLAG

CHAR

1

Change document

MASK

CHAR

20

Template

MASKLEN

NUMC

4

Template length

CONVEXIT

CHAR

5

Conversion routine

HEADLEN

NUMC

2

Heading length

SCRLEN1

NUMC

2

Key word length: short

SCRLEN2

NUMC

2

Key word length: middle

SCRLEN3

NUMC

2

Key word length: long

FIELDTEXT

CHAR

60

Short description

REPTEXT

CHAR

55

Heading

SCRTEXT_S

CHAR

10

Key word: short

SCRTEXT_M

CHAR

20

Key word: middle

SCRTEXT_L

CHAR

40

Key word: long

KEYFLAG

CHAR

1

Key field

LOWERCASE

CHAR

1

Lower case letters

MAC

CHAR

1

–

GENKEY

CHAR

1

–

NOFORKEY

CHAR

1

–

VALEXI

CHAR

1

Existing values

NOAUTHCH

CHAR

1

–

SIGN

CHAR

1

Signs

DYNPFLD

CHAR

1

Screen field