Unable to use extractor 2LIS_11_VAHDR with Data Services

[Former Member]

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

[Former Member · Accepted solution]

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!

[Former Member · Accepted solution]

Hi Abhishek,

What version of ECC are you on? Do you know if Data Services will function with the business content extractors on ECC 6 lower versions ? R/3 4.6/4.7?

Thanks.

Roy

[Former Member · Accepted solution]

Roy,

We are on SAP ECC 6.0. I am not sure if the extractors will work with lower versions of SAP.

Abhi

[Former Member]

Hello Abhishek,

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

[Former Member]

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

[Former Member]

Hello Subbarao,

Thanks for your suggestion.

As suggested we tried activating rest of the datasources in that group and tried again. We are seeing the same issue.

Thanks,
Abhi

[Former Member]

Hello Abhishek,

Then plz check the Logical system.. else have look at this S-note 914268 .

[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

[former_member189153]

Hi,

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

[Former Member]

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

[Former Member]

Thanks Dusmanta. The data source is already active.

[Former Member]

Before LBWE go to LBWG give the application no. and delete it. then go to LBWE to enhance the datasource . Before you lode data first delete it . after that you lode setup table. t-code OLI7BW

[Former Member]

Thanks Dusmanta. We tried it but unfortunately it didn't resolve the issue.