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.
Field |
Meaning |
Work order |
If active, work orders are archived. Select by completion date (displayed in work order position). Additionally, a document number can be entered. 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 |
This is to archive results of Batch-Calculation. Select by creation date.
Following tables are affected: BEAS_OITM_CALCPRICE, BEAS_OITM_CALCPRICE_SCHEMA
Affected data areas: Item master: Price history Batch-calculation history
|
Change log |
Archives the change log. Select by creation date.
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 |
A server or a data base can be indicated, to which data shall be moved. 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 |
Data from vacation planning, recorded attendance times, shift planning and monthly values of persons can be deleted.
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 |