Short overview about main table structure inside Beas Database
oitm (items)
|
|- beas_apl (rounting)
| |_ [itemcode,pos_id] - beas_apl_wkz (resource)
| |_ [wkz_id, resourcentyp='W'] beas_wkz (ToolAdministration)
| |_ [wkz_id, resourcentyp='A'/'R'] beas_aplatz (Work Center)
| |_ [aplatz_id] - beas_aplatz (Work Center)
| |_ [ag_id] - beas_ag (Operations)
|
|- beas_stl (Bill of Materials)
|_ beas_me (Unit of M.)
beas_fthaupt (workorder)
|
|- [belnr_id] beas_ftpos (Position)
| |_[docentry,auftragpos=rdr1.linenum] ordr (Order) and rdr1 (Orderline)
| |_[belnr_id,belpos_id] beas_ftstl (Bill of Materials)
| |_ [belnr_id-dln1.u_belnrid,belpos_id-dln1.u_belposid,pos_id-dln1.u_posid]
| oige,ige1 (Goods Receipt) and oign,ign1 (Goods Issue)
| |_[belnr_id,belpos_id] beas_ftapl (Routing)
| |_ [belnr_id,belpos_id,pos_id] beas_ftapl_wkz
| |_ [wkz_id, resourcentyp='W'] beas_wkz (ToolAdministration)
| |_ [wkz_id, resourcentyp='A'/'R'] beas_aplatz (Work Center)
| |_ [aplatz_id] beas_aplatz (Work Center)
| |_ [belnr_id,belpos_id,pos_id] beas_ftpool (Pool Report)
| |_ [belnr_id,belpos_id,pos_id,aplatz_id] beas_resourcen (Dispatches)
| |_ [belnr_id-dln1.u_belnrid,belpos_id-dln1.u_belposid,pos_id-dln1.u_posid]
| orpd,rpd1 (Goods Return) and opch/pch1 (A/P Invoice)
| |_ [belnr_id,belpos_id,pos_id] beas_arbzeit (Production Time Receipt)
beas_qsartikelhaupt
|
|___[itemcode,knd_id] beas_qsartikel
|__________[qs_id] beas_qs
|__________beas_qsstichprobe
beas_qsfthaupt
|___beas_qsftmessung
|__________beas_qsartikelhaupt
| |_ ....
|__________beas_qsstichprobe
|__________beas_qsftpos
|_beas_wkz
|_beas_qs
related to operation
Pxx/yy/zz-0001
| | |_ beas_ftpos.pos_id
| |---- beas_ftpos.belpos_id
|-------- beas_ftpos.belnr_id
work order credit - related to receipt ign1
Exx/yy
| |_____ linenum
|________ docentry
goods receipt
Ixx/y-0001
| |_____ linenum
|________ docentry
Normal receipt
Cxx/yy-0001
| |_____ linenum
|________ docentry