Skip to Content
avatar image
Yvonne Jutz

HCM: What happens with cluster tables during HANA migration?

Jan 26, 2017 at 08:30 AM | 1.6k Views | Last edit Oct 12, 2017 at 09:06 PM 3 rev.

Hi,

we plan to migrate our HR system from Oracle to HANA (using DMO). In HCM there are some cluster tables like PCL1 or PCL2. We have found some information that before the migration to HANA no preparation is necessary because of cluster tables. During DMO these tables are declustered automatically. We wonder now what happens to the cluster tables: Are the cluster tables still available after migration or are they deleted? What happens to the data of the cluster tables? What do we have to keep in mind?

Thanks & regards

Yvonne

SAP HANA
HCM (Human Capital Management) | dmo | cluster
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Siddharth Rajora
    Feb 12, 2017 at 11:43 PM

    for HR ie Time and Payroll, Cluster Tables remain on HANA as well

    its better to decluster them if you have reporting needs by using standard report and also activate switch

    so Payroll is updated both in cluster and declustered tables, but both will remain and it doesn't go away if you move to HANA for HR

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Volker Binder
    Jan 26, 2017 at 12:06 PM
    -2

    see here:

    http://help.sap.com/erp_hcm_ias_2013_01/helpdata/en/1c/515747d6164336acd41e6598b49a66/content.htm?frameset=%2Fen%2Fd7%2Fbff5483e4411d2a5c90000e83ddb11%2Fframeset.htm

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Vladimir Semashko
    Feb 09, 2017 at 02:05 PM
    -2

    Somewhere SAP stated that cluster will remain even after HANA migration due to the need of huge reprogramming in case of getting rid of it. Declustering can be used on top, but must be activated.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Yvonne Jutz
    Jan 31, 2017 at 09:37 AM

    Is there anyone else with some experience regarding cluster tables and HANA?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    antoine foucault
    Feb 01, 2017 at 11:57 AM

    Hi Yvonne:

    I am not sure if I understand your question correctly because the term "HANA" is used in a variety of senses and applies almost to every new product SAP is releasing... but maybe I can clarify your doubt if your question applies to SAP HANA database.

    I am currently on SAP HANA DB...

    Actually currently moving from an DB2 system to SAP HANA system.

    For the moment I have a copy of my DB2 system in the SAP Hana instance... (or should have)

    I see payroll result are still in the PCL2 table and declustered tables are empty. I have made a simulation of payroll, previous result are read correctly it seems..

    My understanding is the declustered payroll result is necessary if you want to use new services such as the payroll control center but not really necessary if you stick to our old legacy transaction of calculating payroll, posting result to FI or any other old one that actually fetch the payroll result from the clustered tables PCL2. There is an option to activate the declustering and once activated the payroll result are pushed to both clustered and declustered table.

    I have not yet started proper testing and adjustment so obviously I cannot be 100% sure but so far this is how it looks and feels...

    Best,

    Antoine

    Add comment
    10|10000 characters needed characters exceeded

    • antoine foucault Yvonne Jutz
      Feb 06, 2017 at 08:49 AM

      Bonjour:

      Sure thing, will do... actually if you want declustered table to be filled you need to activate business functions 50 in SFW5 transaction. So I tend to believe that it's not because we change of DB system that we actually are changing the scope of our business functions.

      Best,

      Antoine

  • avatar image
    Yvonne Jutz
    Feb 14, 2017 at 12:45 PM

    Thank you all, that calms us.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Yvonne Jutz
    Mar 21, 2017 at 02:37 PM

    Just for your information:

    We have migrated our sandbox system to HANA and everything is fine with our cluster tables - without doing any preparations.

    It seems that what we call "cluster tables" in HCM are not really cluster tables in SAP because in SE11 these tables are transparent tables (before and after HANA migration).

    Add comment
    10|10000 characters needed characters exceeded