Hi All,
I need to extract data from a cluster table, for this i am using BOA RFC package type in collect and i need to apply few filters to extract the data from source system. However i don't see any option to filter the data while using BOA RFC option.
Can you please let me know in case if there is a way to apply filter while using BOA RFC option for extraction?
Thanks & Regards
Ravi
Hi Ravi,
In Collect, on the vertical view of the table > Advanced Settings - you can use the Where Clause Override.
Note:
If you require a more complicated filter criteria, please consider the following article:
https://support.syniti.com/hc/en-us/articles/360000062588--Collect-Download-Clustered-Tables
Kind regards,
Nav
Hey Folks,
I wanted to let you both know that an enhancement to Collect was made in the 7.4.1 release of the SST/DSP application. This allows more than 71 characters to be used in the [Where Clause Override] setting for a "BOA RFC" package. 2000 characters is the new limit.
Link: https://dsphelp.syniti.com/741/general/Whats_New/Whats_New_741.htm#Enhancements
Thank you for your great answer here Nav!
Thank you Navdeep Rauli for quick response.
it answers my query.
Thanks & Regards
Ravi
Thank you Ben Bauer
Hi All,
Just a query, in where clause of KONV table i entered filter like KAPPL = M AND KSCHL IN ( 'P000' ,'P001','R000') and i am getting timeout error.
is this correct way of entering the condition or is there any other efficient way to maintain this filter conditions.
Thanks & Regards
Ravi
Hi Ravi,
It would be best to pose a new question in a new Post so that it is more visible to people visiting/using Data Insiders.
I think in some cases a WHERE clause can cause a timeout because the source database needs to take a bit of time to build the query result before batches of rows start coming back to the SST/DSP app server. You can of course increase the timeout value for certain package types. If this is an RFC package type, then you can review complete technical details here: https://support.syniti.com/hc/en-us/articles/1500000398021-SAP-RFC-Extraction-Overview
Thank you Ben... I will post a new question for any new queries on this topic.
Hello Ravi
Using the RFC method to extract data is challenging for extremely large table such as KONV. There is another possible option to do this by creating queries in SAP using SQ01. In the case of KONV, you could join it to the Sales Order Header VBAK and then create a variant that includes the criteria related to what you want to extract.
SAP has an RFC function called RSAQ_REMOTE_QUERY_CALL that allows the results of a query to be extracted. Here's an example of calling the function
This function can be called from Integrate to extract the results and download to a SQL database.
Here's an example of the results. This extracted data will need to be processed a little after the extract to get the data into columns.
Let me know if you need any further advice.
Andy
Ravi - do you want to try extracting the order price conditions using an SAP query plus integrate? I really think this is the best way to go forward. Do you have access to SAP transaction SQVI? If so, you can very quickly create a query based upon logical database VAV.
You can create a variant that includes the orders you needed and then extract using Integrate. I'm happy to do a screen share to get this set-up.
Hi Andrew,
I have access to SQVI t code in ECC, please let me know your convenient time today, we can have a screen share session and can work on this.
Thanks & Regards
Ravi
Ravi - please send me an email to andrew.lund@syniti.com for a meeting at 5pm CET (in 30 mins). I can do a 30 minute session then - we can see how far we get.
Please sign in to leave a comment.
Comments
11 comments