Microsoft Access ELEMR (Activity Elements)

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

ARNUMMER

NUMC

6

Archiving run

VSGRUPPE

CHAR

20

Version group

VSNUMMER

CHAR

12

Version key

PRCTR

CHAR

10

Profit center

PRNAM

CHAR

8

Capital investment program

PRPOS

CHAR

24

Item ID

PSPID

CHAR

24

Project definition

POSID

CHAR

24

WBS element

KDAUF

CHAR

10

Sales document

KDPOS

NUMC

6

Sales item

AUFNR

CHAR

12

Order/network

VORNR

CHAR

4

Activity

UVORN

CHAR

4

Element

AUTYPTXT

CHAR

40

Order type

STEUS

CHAR

4

Control key

STEUTXT

CHAR

40

Control key text

ARBPL

CHAR

8

Work center

ARBTXT

CHAR

40

Work center text

WERKS

CHAR

4

Plant

KTSCH

CHAR

7

Standard text key

LTXA1

CHAR

40

Activity description

TXTSP

LANG

1

Language

RSTRA

CHAR

2

Reduction strategy

SORTL

CHAR

10

Sort string

LIFNR

CHAR

10

Vendor

PREIS

CURR

14

Price

PEINH

DEC

6

Price unit

SAKTO

CHAR

10

Cost element

WAERS

CUKY

5

Currency

INFNR

CHAR

10

Purchasing info record

ESOKZ

CHAR

1

Purchasing info record category

EKORG

CHAR

4

Purchasing organization

EKGRP

CHAR

3

Purchasing group

KZLGF

CHAR

1

External processing with fixed lot–size

KZWRTF

CHAR

1

Fixed value

MATKL

CHAR

9

Material group

DDEHN

CHAR

1

Extendible duration

ANZZL

INT1

3

Number

PRZNT

INT1

3

Percent

MLSTN

CHAR

5

Milestone

MLSTXT

CHAR

40

Milestone text

BUKRS

CHAR

4

Company code

ANFKO

CHAR

10

Required cost center

ANFKOKRS

CHAR

4

Controlling area

INDET

CHAR

1

Calculation key

LARNT

CHAR

6

Activity type

PRKST

CURR

14

Amount

RUECK

NUMC

10

Confirmation

RMZHL

NUMC

8

Counter

BANFN

CHAR

10

Purchase requisition

BNFPO

NUMC

5

Purchase requisition number

KALID

CHAR

2

Factory calendar ID

KALTX

CHAR

20

Factory calendar

VERTL

CHAR

8

Distribution of capacity requirements: network

LEKNW

CHAR

1

No remaining activity

NPRIO

CHAR

1

Priority

TXJCD

CHAR

15

Jurisdiction code

SCOPE

CHAR

5

Object class

GSBER

CHAR

4

Business area

NO_DISP

CHAR

1

Reservation/purchase req.

EVGEW

DEC

10

% completion

CLASF

CHAR

1

Project summarization

MEINH

UNIT

3

Activity unit of measure

PLIFZ

DEC

3

Planned delivery time

DAUNO

QUAN

7

Normal duration

DAUNE

UNIT

3

Normal duration unit

DAUMI

QUAN

7

Minimum duration

DAUME

UNIT

3

Minimum duration unit

EINSA

CHAR

1

Constraint start

EINSE

CHAR

1

Constraint finish

ARBEI

QUAN

9

Work

ARBEH

UNIT

3

Work unit

MGVRG

QUAN

17

Activity quantity

ASVRG

QUAN

17

Scrap quantity

ISMNW

QUAN

9

Actual work

FSAVD

DATS

10

Earliest start date (basic)

FSAVZ

TIMS

8

Earliest start time (basic)

FSEDD

DATS

10

Earliest finish date (basic)

FSEDZ

TIMS

8

Earliest finish time (basic)

SSAVD

DATS

10

Latest start date (basic)

SSAVZ

TIMS

8

Latest start time (basic)

SSEDD

DATS

10

Latest finish date (basic)

SSEDZ

TIMS

8

Latest finish time (basic)

ISDD

DATS

10

Actual start date

ISDZ

TIMS

8

Actual start time

IEDD

DATS

10

Actual finish date

IEDZ

TIMS

8

Actual finish time

PEDD

DATS

10

Forecast finish date

PEDZ

TIMS

8

Forecast finish time

PUFFR

DEC

4

Free buffer

PUFGS

DEC

4

Total buffer

NTANF

DATS

10

Constraint start

NTANZ

TIMS

8

Constraint start time

NTEND

DATS

10

Constraint finish

NTENZ

TIMS

8

Constraint finish time

EWSTD

DATS

10

Forecast start date

EWSTZ

TIMS

8

Forecast start time

EWEND

DATS

10

Forecast finish date

EWENZ

TIMS

8

Forecast finish time

EWDAN

QUAN

7

Normal duration (forecast)

EWDNE

UNIT

3

Normal duration unit (forecast)

EWDAM

QUAN

7

Minimum duration (forecast)

EWDME

UNIT

3

Minimum duration unit

EWSTE

CHAR

1

Constraint finish

EWSTA

CHAR

1

Constraint start

DABEA

QUAN

9

Processing duration

BEAZE

UNIT

3

Processing time unit

OFMNW

QUAN

9

Forecast work

OFFSTB

QUAN

7

Time interval start

EHOFFB

UNIT

3

Unit

OFFSTE

QUAN

7

Time interval finish

EHOFFE

UNIT

3

Unit

FPAVD

DATS

10

Earliest start date (basic)

FPAVZ

TIMS

8

Earliest start time (basic)

FPEDD

DATS

10

Earliest finish date (basic)

FPEDZ

TIMS

8

Earliest finish time (basic)

SPAVD

DATS

10

Latest start date (basic)

SPAVZ

TIMS

8

Latest start time (basic)

SPEDD

DATS

10

Latest finish

SPEDZ

TIMS

8

Latest dates

BEAZP

UNIT

3

Processing time unit

PUFGP

DEC

4

Total buffer

PUFFP

DEC

4

Free buffer

DAPBE

QUAN

9

Processing duration

EPANF

DATS

10

Planned start

EPANZ

TIMS

8

Planned start time

EPEND

DATS

10

Planned finish

EPENZ

TIMS

8

Planned finish time

PDAU

QUAN

7

Forecast duration from confirmation

PDAE

UNIT

3

Forecast duration unit

SLWID

CHAR

7

Field key

USR00

CHAR

20

User field (20 char.)

USR01

CHAR

20

User field (20 char.)

USR02

CHAR

10

User field

USR03

CHAR

10

User field

USR04

QUAN

18

User field: Quantity

USE04

UNIT

3

User field: Unit

USR05

QUAN

18

User field: Quantity

USE05

UNIT

3

User field: Unit

USR06

CURR

18

User field: Value

USE06

CUKY

5

User field: Unit

USR07

CURR

18

User field: Value

USE07

CUKY

5

User field: Unit

USR08

DATS

10

User field: Date

USR09

DATS

10

User field: Date

USR10

CHAR

1

User field: Indicator

USR11

CHAR

1

User field: Indicator

LOSVG

QUAN

17

Activity quantity

LOSME

UNIT

3

Base unit of measure

WEMNG_OPR

QUAN

17

Goods receipt quantity

WEMEH_OPR

UNIT

3

Order unit

FLG_PURS

CHAR

1

Purchase order exists

FLG_VAB

CHAR

1

Subnetwork exists

PSTXTAR

CHAR

2

PS text

PSTXTTI

CHAR

20

Description

IDAUR

QUAN

7

Actual duration

IDAUE

UNIT

3

Unit for actual duration

ODAUR

QUAN

7

Remaining duration

ODAUE

UNIT

3

Remaining duration unit

ABARBD

NUMC

3

Degree of processing

REMNW

QUAN

9

Remaining work

REMNE

UNIT

3

Work unit

ABARBA

NUMC

3

Degree of processing

IDAUR

QUAN

7

Actual duration

IDAUE

UNIT

3

Actual duration unit

STATXT

CHAR

40

Status

FRUEHER

QUAN

7

Earlier

SPAETER

QUAN

7

Later

VERZUG

QUAN

7

Delay

VORBEI

QUAN

7

Past

VEINH

UNIT

3

Unit

VGTYP

CHAR

3

Type

LOSME

UNIT

3

Base unit of measure

FLG_RCKMLD

CHAR

1

Can be confirmed