Creating Logic and modeling for SAP BW datasource in SAP HANA views and SLT

[pavneet_rana]

Hi to all,

I have small question.

We have BW system and SAP ECC as source system and to get data from SAP ECC source system we are using SAP ECC Standard data source.

Now we required to, create modeling in SAP HANA by use of HANA View and get data from SAP ECC source table via SLT.

So we can replicate same modeling,as we done in SAP BW system.

But  my question is that, as SAP ECC standard data source hit multiple table and do run-time calculation, before sending to SAP BI.

How we can derives such calculation and logic, in our HANA studio, because as we know in SLT data transformation can be done in limited way also

in view we can not drive such logic via SQL script ?.

• Is there any way we can do such modeling and logic in SAP HANA ?

or

• is there any standard document for this type of case, which we can use ?

Note: We don't want to use SAP DS or DXC for data loading to HANA, as  we want it in more real time.

Regards

Pavneet Rana

[former_member186082 · Accepted solution]

Hi Pavneet,

You can do transformations in ABAP include and include the same in SLT transformation. As we use ABAP here, we can achieve complex transformation also.

Other way is load entire data to HANA. Build Stored Procedures, which used SQLScript and hence we can achieve any logic.  With this, advantage would be, we will have data available at table level so that report execution would be faster. But the limiltation would be executing the procedures adhocly.

You can also implement the same logic (as in Stored Procedure) in SQLScript view but the report runtime depends on the complexity of the logic.

Regards,

Chandu.

[pavneet_rana · Accepted solution]

Thanks for reply,

As SLT is based on ABAP, so we can write complex logic in it.

But if we talk about SAP ECC standard data source, they have complex logic, based on multiple table.

So we need to write code from scratch in SLT to derive same result. but it will be huge time consuming , and required good ABAP skills, also it will lead to bug in code.

Also it will reduce the real time performance of SLT, due to complex logic.

Second option is procedure via SQL script, which is again huge effort in term if logic and can lead to error/bug in logic.

Does we have any other way or architecture to do this is very simple way, with high performance and less error issue.

Regards

Pavneet Rana

[former_member186082 · Accepted solution]

No Pavneet, there are no other ways with SLT as replication technique. As we can replicate tables only using SLT, you have to implement the data source logic either in ABAP or SQL Script in HANA.

Regards

Chandu