Skip to Content
0

Unable to find tables under SDI remote source created using ABAP Adapter

Dec 12, 2016 at 11:47 AM

463

avatar image
Former Member

We have used ABAP Adapters in SDI to connect our BW-on-HANA DB to an ECC system. However, we are unable to find some of the tables under the folder structure of ABAP Tables. E,g: COPA tables (CE2XXXX), BSIS, BSAS do not appear under the folder structure of ABAP tables.

Therefore, we are not able to create a virtual table based on the tables. Could you please suggest if there are any additional settings that need to be performed to view the tables?

Following are the steps followed:

a. Right Click on "Remote Source" under Provisioning and select "New remote source".

b. Configure the remote source choosing adapter as ABAPAdapter and Source Location as dpagent.

c. Once the connection details are given, clicked on save.

d. Many tables like BSEG / BKPF etc could be found under the folders under the main folder "ABAP Tables". However, we could not locate the above tables mentioned.

e. Additionally, we did not find the option "Find Table" when we clicked on the remote source thus created.

sdi
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member
Dec 12, 2016 at 02:43 PM
0

Hi Anjana,

I just tried this on my system using a recent SDI agent and ABAP adapter, and I'm able to see all the tables you mentioned.

Can you try to use the latest SDI agent ? Several changes were made to optimize the ABAP adapter. In the latest version you will see you can browse tables alphabetically by name, or use the "find table". I recommend to use SDI SP03 patch 40, which can be used with both HANA SPS11 and HANA SPS12.

abap-table-by-name.jpg

bsas.jpg

Thanks,

Ben.

--

Product manager HANA smart data integration


bsas.jpg (18.6 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Ben,

Thank you for the suggestion. We'll propose an upgrade of SDI.

Also, just for information, our source systems are based on Oracle Database. So, when we create an SDI connection using OracleECCAdapter, we are able to see some of these tables (all custom tables and the CE1XXXX tables). However, when the SDI connection is created using ABAP adapter, the tables are not visible.

Thank You,

Anjana

0
Former Member
Former Member

Hello Anjana,

I also have this question, do you have some ides?

0