Replicating cluster table BSEG with SLT

[former_member185171]

Hi,

we started a POC in HANA for out financial modules.

One of the tables we want to replicate into HANA is table BSEG. The replication with SLT works fine - taking it's time, but OK.

When we want to access the table from ABAP we encounter an error:

This is the select statement:

SELECT COUNT( * ) FROM bseg " rfblg
               CONNECTION (p_dbcon)
               INTO v_teller4
               WHERE gjahr IN s_gjahr.

When activating we get the following message: If "CONNECTION" additoin is used, the table BSEG must be a transparent table.

BSEG indeed is a cluster table. Do we have to transform it somehow into a transparent table in order to make te access in HANA possible? If so, how and when can we do that? Before setting up SLT, can it still be done after setting up the SLT ...

Thanks for any help.

Greetings.

Kris

[SK-EA]

Kris,

Try including the SLT schema name in the query. All replicated tables to SAP HANA server will be under your SLT schema and while accessing them you should use the notation <schema_name>.<table_name>

For ex: SELECT COUNT(*) from FMGRC.BSEG

From HANA Studio SQL Editor:

Hope it helps.

Thanks & Regards,

Srinivas K.

[Former Member]

Kris,

afaik, #bseg cannot be queried against as indeed it's a cluster table. have you considered a flat file

dump and putting it through some kind of ETL process? it is not pretty, but it does work.

thx,

greg

[Prabhith]

Hi ,

I have read some where that we need to check the SAP NOTE 1662438 before we start working on the cluster tables in HANA,

could you please see that note and check whether you have any clue in that note for your issue!

BR,

Prabhith