Administration > Utility programs > Database test > Archive data - robinfeng/beashelp GitHub Wiki

数据归档

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 can not 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 is moved.
  3. Data in source tables is 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.

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

Pre-calculation 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.

beas9.0-004-054

返回 主页

返回 主页

⚠️ **GitHub.com Fallback** ⚠️