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.
Window system_backup.psr
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 (Times, vacation)
|
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/beas202402/index.html?archiv.htm
|