Microsoft Access KBEDR (Capacity Requirements)
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 |
PLNUM |
CHAR |
10 |
Planned order |
AUFNR |
CHAR |
12 |
Order/network |
VORNR |
CHAR |
4 |
Activity |
UVORN |
CHAR |
4 |
Element |
AUTYPTXT |
CHAR |
40 |
Order type |
KAPNM |
CHAR |
8 |
Capacity |
KAPTXT |
CHAR |
40 |
Short description |
ARBPL |
CHAR |
8 |
Work center |
ARBTXT |
CHAR |
40 |
Work center text |
WERKS |
CHAR |
4 |
Plant |
KAPAR |
CHAR |
3 |
Capacity category |
KAPARTXT |
CHAR |
20 |
Capacity category description |
TYPKZ |
CHAR |
1 |
Order type |
BEDSOLL |
QUAN |
9 |
Capacity requirements |
BEDREST |
QUAN |
9 |
Remaining capacity reqmts |
KEINH |
UNIT |
3 |
Capacity unit |
FSTAD |
DATS |
10 |
Earliest start date |
FSTAU |
TIMS |
8 |
Earliest start time |
FENDD |
DATS |
10 |
Earliest finish date |
FENDU |
TIMS |
8 |
Earliest finish time |
SSTAD |
DATS |
10 |
Latest start date |
SSTAU |
TIMS |
8 |
Latest start time |
SENDD |
DATS |
10 |
Latest finish date |
SENDU |
TIMS |
8 |
Latest finish time |
ISTAD |
DATS |
10 |
Actual start date |
ISTAU |
TIMS |
8 |
Actual start time |
IENDD |
DATS |
10 |
Actual finish date |
IENDU |
TIMS |
8 |
Actual finish time |
PENDD |
DATS |
10 |
Forecast finish date |
PENDU |
TIMS |
8 |
Forecast finish time |
KPVER |
CHAR |
8 |
Distribution key |
ISMNW |
QUAN |
17 |
Confirmed activity |
PERNR |
NUMC |
8 |
Personnel number |
PERTXT |
CHAR |
Text personnel number |
|
SPLIT |
INT1 |
3 |
No. of splits |
MGVRG |
QUAN |
Activity quantity |
|
MEINH |
UNIT |
Unit of measure, activity |
|
RSTUF |
NUMC |
Reduction level |
|
PLSCN |
NUMC |
Planning scenario |
|
USR04 |
QUAN |
User quantity 1 |
|
USE04 |
UNIT |
User quantity unit 1 |
|
USR05 |
QUAN |
User quantity 2 |
|
USE05 |
UNIT |
User quantity unit 2 |
|
BEAZE |
UNIT |
Unit for edit |
|
ARBEI |
QUAN |
Work |
|
ARBEH |
UNIT |
Unit for work |
|
LEKNW |
CHAR |
No remaining activity |
|
ASVRG |
QUAN |
Scrap quantity |
|
STATXT |
CHAR |
40 |
Status |
FRUEHER |
QUAN |
7 |
Earlier |
SPAETER |
QUAN |
7 |
Later |
VERZUG |
QUAN |
7 |
Delay |
VORBEI |
QUAN |
7 |
Past |
VEINH |
UNIT |
3 |
Unit |