PATH: Administration > Utilities > Database test > Archive data Open button.
Use the data archive function to move data from productive system into archive tables or to an archive data base or archive server.
Thus, the continuous growth of recently used tables can be prevented. The authorization "System" is required.
IMPORTANT:
The process cannot be undone.
Create a backup before archiving data.
There is no access on archive data within beas.
Recommendation: regular annual backup to keep an access on old data.
Process:
1. Data base is backed up
2. Select the area to be archived
3. Select a target server or target db
4. Select a period to be included in archive
5. Start archiving
Archiving process:
1. on target data base table structure is created or updated. A 1:1-image of the source table is created.
Name: BEAS_BACKUP_[Origin Table name], eg: from "BEAS_FTHAUPT" the table "BEAS_BACKUP_FTHAUPT" is created.
2. All data are moved.
3. Data in source tables are deleted.
Depending on the selected area tabs are displayed, to enter more data.
|
|
Work order
|
Select by completion date (displayed in work order position). Additionally, a document number can be entered.
The following tables are affected:
BEAS_FTHAUPT,BEAS_FTPOS,BEAS_FTSTL,BEAS_FTAPL,BEAS_FTAPLCHARE,BEAS_FTCAFT_VARENRTY,BEAS_FTPOS_PROFITCENTER,BEAS_FTPOS_RESERVIERUNG,BEAS_FTPOS_SCHEMA,BEAS_FTPOS_SCHEMA_HEADER,BEAS_FTPOS_SCHEMA_JOURNAL,BEAS_FTZUORDNUNG,BEAS_JOURNAL,BEAS_ARBZEIT
Affected data areas:
- Work order
- Order times
- Batch / Serial number tracing
- Batch-calculation / Batch-post-calculation
|
|
Precalculation
|
Following tables are affected:
BEAS_OITM_CALCPRICE, BEAS_OITM_CALCPRICE_SCHEMA
Affected data areas:
Item master: Price history
Batch-calculation history
|
|
Change log
|
Following tables are affected:
BEAS_AENDERUNG
Affected data areas:
All windows, in which right-click - Change log is available. Not in item master, because there, the change log of SAP Business One - is used.
See Change log
|
|
QC Order
|
If active, QC order are archived. The indicated "to date" considers all QC orders, which had been created until this date.
Affected tables:
BEAS_QSFTHAUPT,BEAS_QSFTMESSUNG,BEAS_QSFTPOS,BEAS_QSFTATTACHMENT,BEAS_QSFTATTACHMENT_CONFIRM
|
External target server
|
Required information: server, data base, user, pass word and trusted connection.
Any change is saved immediately and is available at next call up.
In MSSQL-environment a MSSQL-Server is needed, in HANA-environment a HANA-Server is needed.
|
|
Personnel
|
You can only delete dates that are at least 500 calendar days older.
Note: Archiving is not possible, only deletion.
The following tables are affected:
beas 9.3-001-000
|
|
Help URL: https://help.beascloud.com/beas202106/index.html?archiv.htm
|