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 |