Skip to Content
author's profile photo Former Member
Former Member

SAP Application Extract

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 07, 2015 at 12:21 PM

    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


    6.png (24.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2015 at 11:47 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.