Unable to use extractor 2LIS_11_VAHDR with Data Services
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.
Please advise as to any other steps needed to allow the filling of the setup tables. Your help is highly appreciated.
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!