Skip to Content
avatar image
Former Member

Unable to use extractor 2LIS_11_VAHDR with Data Services

Hi,

We are currently trying to use Data Services to extract data from ECC to HANA using standard Business Content extractors. BW is beyond the scope of this project and we want to build a custom SQL data mart using Data Services and HANA.

We would like to use the extractor 2LIS_11_VAHDR to extract Sales Order Header information. However, when we try to fill the setup tables for application 11, we see the error ‘No extraction structure active or no BW connected’:

We have confirmed that the data sources are active in both t-codes RSA6 and LBWE. We are also able to pull the DataSource up in t-code RSA3 but obviously no records are returned because the setup tables are empty.

RSA6

LBWE

RSA3

Please advise as to any other steps needed to allow the filling of the setup tables. Your help is highly appreciated.

Thanks,
Abhi

2 PNG.png (12.2 kB)
3 PNG.png (17.8 kB)
4 PNG.png (28.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 03, 2014 at 07:40 PM

    We were able to resolve this issue with SAP's help. Here is the solution.

    If you want to be able to execute OLI7BW, you need to either connect a BW system to the source system or create at least one subscription within Operational Delta Queue.

    If you do not want to connect a BW system, this means you would first have to issue a CDC request from Data Service for a 2LIS_11* data source (e.g. 2LIS_11_VAITM) with an empty setup table.

    This will create an active subscription, enabling you to start the setup program OLI7BW.

    After this you should be able to request a second initial load from Data Services, by temporarily setting property "Initial load" to "Yes". This will be the "real" delta init, providing the data from the setup tables to Data Services.

    Hope it helps!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 15, 2014 at 06:47 AM

    Before you go to RSA6 . First you activate the data source T-code RSA5 . Then you replicate.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 15, 2014 at 07:49 AM

    Hi,

    Check whether the Extractor active or not, if active you able to import like below

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 16, 2014 at 03:59 AM

    Hello Abhishek,

    Make sure remaining data sources are also active (vaitm,vascl....) see the picture attached by you.. it shows remaining ds's are in yellow ... make them green..

    since setup tables will fill all the datasource's belongs to application 11.

    let us know the result once after activating remaining ds's


    Regards

    Subbarao M

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks Subrarao. We looked at this SAP note. It pertains to a system where in an instance we use both SAP ERP and BW which we do not currently.

      BW is beyond the scope of our project.

      Thanks,
      Abhi

  • avatar image
    Former Member
    Apr 18, 2014 at 05:36 AM

    Hello Abhishek,

      go through the link No extraction structure active or no BW connected | SCN

    Add comment
    10|10000 characters needed characters exceeded