SAP Application Extract

[Former Member]

Hi

Greetings.

Trying to extract data from SAP Application and for that i am able to successfully create RFC connection but getting below error when trying to import a table from the same server.

Error: Connot import the metadata table <name-KNA1>.

SAP error dynamically importing SAP table: <ERROR: TABLE KNA1 DOES NOT EXIST.>. (BODI-1112339)

Below are the parameters passed, part of Data Store created:

ABAP execution option as "Generate and Execute"

Data Transfer Method as "Shared Directory"

Directory: \\B\opt\ds\ds32dev1\transfer_ABAP

Above directory is what i am using. To resolve this issue, do we need to have tables placed under this directory.

Please provide me some inputs/steps on how to have these tables in SAP BW and also to extract same through SAP Dataservices.

Thanks,

Abdulrasheed.

[Former Member · Accepted solution]

Hi Abdul

After creating the RFC connection in SAP ECC

then you need to check in the Data management console -->> SAP connection -->> RFC server configuration you create here also to configuration should be must and its show the green colour its highlighted.

after this you need to go SAP BODS then create data-store connection then you need go to advanced then gave the  RFC program name or directory Path after finish you need to apply condition.

Then only you metadata can import is possible.

Thanks & Regards,

Rajesh

[Former Member · Accepted solution]

Have done all these and the connection works fine but it doesn't show the tables list in it.

[Former Member · Accepted solution]

You have to import the tables what you need in the datastore.

[Former Member · Accepted solution]

If the connection established correctly to the SAP ECC then

import the tables under the sap datastore external metadata or search the table KNA1 first in that before importing

try to share a screenshot of that

[former_member198401 · Accepted solution]

Hi Abdul,

Are you facing this issue with all the SAP ECC tables or with only specific tables.

Can you please check with the BASIS team if they have installed the necessary SAP FM's for BODS

Also check if the RFC user has SAP_ALL and BW_ALL rights.

You can also apply a  trace using the T Code ST01 to check if this is a authorization issue

Also check the RFC Logs for more details.

http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_sap_en.pdf

Regards

Arun Sasi

[Former Member · Accepted solution]

Hi Arun,

Thanks for understanding this issue right. Have tried above provided steps as well but still unable to import those table.

Can you please tell me, which add-on or something to install to get those SAP FMs on to SAP BW system for SAP BODS.

Thanks,

Abdulrasheed.

[Former Member · Accepted solution]

Have you connected your SAP BW system in BODS using RFC, If yes, you'll not see SAP ECC tables under it.

Regards,

Sandeep

[former_member198401 · Accepted solution]

Hi Abdul,

The default installation places two function module files for SAP servers in the below installation folder

\Data Services\Admin\R3_Functions\transport directory.

You can deploy them using the SAP Correction and Transport System (CTS) or manually. Using CTS allows for version control as the functions evolve across releases. If CTS is not possible then manually deploy these function modules.

For more reference refer SAP Supplement Guide

Topic 2 Installing Functions on the SAP Server (2.1 and 2.2)

Regards

Arun Sasi

[Former Member · Accepted solution]

Hi Arun,

Working with Basis team and seems like SAP_APPL component is missing and they are trying to install this. Once done, will have a try and let you know the status.

Thanks,

Abdulrasheed.

[former_member198401 · Accepted solution]

Hi Abdul,

Although you can install the component, I dont think SAP_APPL component is necessary for importing table metadata in BODS. There is a function called Z_AW_RFC_READ_TABLE which is responsible for reading SAP ECC Table data. Can you check if this function is installed by your BASIS team.

Can you see section 2.3 Function Modules in the SAP Supplement Guide

Try to install most of them.

Regards

Arun Sasi

[former_member198401 · Accepted solution]

Any update..

[Former Member · Accepted solution]

Arun,

For now, i am able to see only these tables.

"/BIC/AZCUST_D100"

"/BIC/AZDSO_BG300"

"/BIC/MORDER_ID"

"/BIC/MP_ID"

"/BIC/MPR_NAME"

When i have verified with BW team, they said they are unable to install that component but can do it on SAP ECC. Not sure

Will try more.

Thanks for your help.

Abdulrasheed.

[Former Member · Accepted solution]

Shaikh,

As told you earlier, you are connecting your BW system through SAP application. You'll not see SAP ECC tables under it.

Regards,

Sandeep

[Former Member · Accepted solution]

Hi Sandeep,

Sorry for the delay. Here are the connection details:

Here is the error screen shot when importing table KNA1:

Is there anything missing in it. Please advise.

Thanks,

Abdulrasheed.

[former_member198401 · Accepted solution]

Hi Abdul,

It seems that you are using SAP BW source datastore. KNA1 is an SAP table and not a sap bw table. Try creating a sap application datastore and you will be able to import the table.

Regards

Arun Sasi

[Former Member · Accepted solution]

Hi Arun,

Initially, have tried using SAP Applications only. Since i am getting an error i have created with BW to check. Still i m getting same. The issue could be from BW team where they have to install/place something which they are unable to. But it's nice experience to know what and all to be taken care to extract data from SAP.

Thanks All for your help.

FYI: I m referring to this Post for now - http://scn.sap.com/docs/DOC-48917

Regards,

Abdulrasheed.

[former_member198401 · Accepted solution]

Ok!!

Let us know what was the issue

Regards

Arun Sasi

[Former Member · Accepted solution]

Hi Arun/Sandeep,

Problem was with the application path to the shared directory. Now i m able to successfully import tables. Thanks Again.

Abdulrasheed.

[Former Member · Accepted solution]

Hi Arun,

How to find these sort of table \BIC\AZCUST_D100 in SAP BW. What is the T-Code for it.

Also how to differentiate on what can be extracted from BW and ECC.

Please advise.

Thanks,

Abdulrasheed.

[former_member198401 · Accepted solution]

Hi Abdul,

Following link might be useful

http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=243631905

/BIC/<xyz> means that are custom defined tables based on some object i.e. DSO,Cube, InfoObject etc.

Go to Transaction SE11 in BW and give /BIC/* and press F4 and see all the tables and also data in that table.

Regards

Arun Sasi

[Former Member]

Hi,

This is strange.

Try checking the table at the SAP end, if the table is there then possibly some authorization missing for RFC user.

Regards,

Sandeep