/
2.4.4 Data Staging

2.4.4 Data Staging

Owned by Andre Reforma (Deactivated)
Last updated: Jun 18, 2018

Most of the time, data entry needs to have an approval process before it can be committed into the SAP standard database tables. One main feature of FAB is its Data Staging process and tables. Data can be read and analysed upfront before it can be eventually be decided and saved in to the SAP standard tables.
This promotes transparency and monitoring of data by using the reports provided (TCODEs /IQX/FAB_DATA and /IQX/FAB_ANALYSIS). It can also serve as audit artefacts in the area of the business governance, risk control and mitigation.

By default all the fields set in the Fields Area Section will be saved in the FAB staging tables, mainly /IQX/FORMS_INST and /IQX/FORMS_REL_I. The first one is the staging table for the individual fields and the second is for the data in the form of table or array.

At the same time, FAB provides flexibility by which set of fields can be identified and selected to be saved in the staging tables.This in turn optimises the integration process between the UI and the backend as it tries to minimise the data and footprint that will be saved in the staging tables.
The settings can be found in the Fields Area Section in the columns/checkboxes DoNotSave (Do not save data from field) and Ref/Table (Reference / Table Level field only).

Practical implementation

There might be a need for fields/variable or table fields that is only important and should only hold values during run-time. 

  1. DoNotSave (Do not save data from field)
    Marking this field property will not save the values in the table /IQX/FORMS_INST as [Field Name / Field Value] pair.

    Although the data is not getting saved in the table as a [Field Name / Field Value] pair, for applications having the property Use Data Model selected, the data will still and always be saved in the JSON string under the Field Name DATA. Moreover, the [Field Name / Field Value] pair will also be shown in the list of fields in the report /IQX/FAB_DATA.

  2. Ref/Table (Reference / Table Level field only)
    Marking this field property will not save the values in the table /IQX/FORMS_REL_I as [Field Name / Field Value] pair.

    Although the data is not getting saved in the table as a [Field Name / Field Value] pair, for applications having the property Use Data Model selected, the data will still and always be saved in the JSON string under the Field Name DATA.


Related content