In SAP HANA how to create dummy members and store them in another table?

[Former Member]

• We already have master data in HANA in one table. Its replicated from ECC. We have to create dummy members and store them in another table.

Please explore what is the possible way to that.

• 1.Is it possible through SQL Script/Procedure?

• 2.What will be replication mechanism?

• 3.Should we do this kind of thing in HANA or in BW?

• 4.How we can merge these two tables and use in info object.

• Example:.
• Table 1:

Distributer Description MU1 Management Unit PU1 Planning Unit MS1 Market State DR1 Distributor MU2 Management unit

• 
  Table 2: This will have only dummy members for Management unit.

Distributer Description MU1_D Management Unit MU2_D Management unit