Gold Client - transformation rule (Derived - Multiplier) PA**** Tables

[suresh_babu]

Intro

Data Transformation functionality was introduced in Gold Client version 8.0. It allows the transformation of fields during the Export of data in Gold Client. This functionality is delivered with default configuration; however, users are provided the flexibility to define their own data transformation routines for any table and field. 

Summary:

When we have Derived transformation to multiply a value in PA**** tables, Gold Client allows to transform values based on a reference field (it can be the field itself) by applying a multiply factor.

Customizing table /HTG/NOPERNRSYNC plays a major role here, because this table allows the synchronization of each record in PA* tables by employee.

The table contains only two columns (Table name, Field name). This is field level customization, and all required fields should be maintained in customization. To maintain entries in this customizing table, please use transaction SM30.

1. If the entry is not maintained in the customizing table /HTG/NOPERNRSYNC, Gold Client will transform all records related to a particular PERNR to the same value, and that is calculated from the first record of that PERNR.
2. If the entry is maintained in the customizing table /HTG/NOPERNRSYNC, each record is calculated from its own original value.

Example:

• In PA0014 there are 4 records for PERNR “00070036” and each row contains a different value in BETRG Field.
  
• Create a Transformation rule for PA0014-BETRG field where field BETRG will be derived by its own field by a multiplication factor of 1.5x.
  
• Assign this rule to the corresponding data type in Default Rules
  

Scenario 1: Configuration Not Maintained

• SM30 ---> Table /HTG/NOPERNRSYNC - “Do not sync same-PERNR records for GC Transformation”
  
• Run Data Snap – Data type – HR - PERSONNEL MASTER
  
• Check Sizing Report
  

Scenario 2: Configuration Maintained

• SM30 ---> Table /HTG/NOPERNRSYNC - “Do not sync same-PERNR records for GC Transformation”
  à Configuration for PA0014-BETRG
  
• Run Data Snap – Data type HR - PERSONNEL MASTER
  
• Check Sizing Report
  

Note:

1. In the first scenario (PA0014-BETRG is not maintained in the configuration table /HTG/NOPERNRSYNC). All rows contain the same value for field BETRG, and this value is calculated from the first-row original value (18 = 16 * 1.5) and replicated to all other lines.
2. In the second scenario (PA0014-BETRG is maintained in the configuration table /HTG/NOPERNRSYNC). Each row is calculated from its own original value:
   18          =            12         *  1.5
   32.25    =            21.50    *  1.5
   51.75     =            34.50   *  1.5
   300       =            200      *  1.5

For more information, see the Data Transform User Guide found at: 

Data Transform User Guide 8.7

If you are unable to resolve the issue, freely submit a support case, and the Qlik Gold Client team will respond accordingly. 

Tags:

• Qlik Gold Client
• Transformation
• SAP
• S4HANA

Labels  

• Qlik Gold Client