Hi
We're trying to extract a view from ECC to SQL DM via BODS. In the DataStore, the view already been successfully imported from 'Table' option. However, no data display when view data or run the job. We're sure there did data in the source of ECC. But somehow could not loaded into DS.
Thanks for your help!
Hi CC Gao,
Can you try vewing data in BODS (view data) and check if the imported view has data or not. We faced similar issue with a ECC view in one of our project.
If the View is empty is BODS then you need to work with BASIS team or you can get underlyng tables and join conditions used to create the view and you have to import all those tables and do join manually in DS dataflow.
Thanks,
Ravi kiran.
Hi Ravi,
There is no data from 'view data' while this source in ECC has data. Thanks for you suggestion, which probably works for our case. I still would like to see if there is any way to extract the view directly. But I will try your solution. Thanks a lot! Really appreciated!
CC
I think your ECC system missing couple of Data Services supporting functions that is required for seamless communication between DS and ECC.
Please refer "Data Services Supplement for SAP".
______________________________________________________
Here's the excerpt
SAP Data Services uses functions that support the use of the ABAP, BAPI, and IDoc interfaces on SAP servers.
You need some or all of the functions in the normal operation of the software in an SAP environment. The functions perform many operations. For example:
- Dynamic load and execution of ABAP programs from Data Services
- Run preloaded ABAP programs
- Browse and import metadata from SAP servers
- Report status of running jobs