How to Restrict the data while extracting from source using BOA RFC package type?

Answered

Comments

11 comments

  • Best answer
    Avatar
    Navdeep Rauli

    Hi Ravi, 

    In Collect, on the vertical view of the table > Advanced Settings - you can use the Where Clause Override.

    Note: 

    • Spaces are required around the equal signs (=).  This is/was a limitation of the RFC, not Collect.
    • The entire string must be 71 characters or less.  Again, this is/was a limitation of the RFC, not Collect.

    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 

    Comment actions Permalink
  • Avatar
    Venkata Ravi Kumar Mullamuri

    Thank you Navdeep Rauli for quick response.

    it answers my query.

    Thanks & Regards

    Ravi

    0
    Comment actions Permalink
  • Avatar
    Ben Bauer

    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!

    2
    Comment actions Permalink
  • Avatar
    Venkata Ravi Kumar Mullamuri

    Thank you Ben Bauer

    0
    Comment actions Permalink
  • Avatar
    Venkata Ravi Kumar Mullamuri

    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

    0
    Comment actions Permalink
  • Avatar
    Ben Bauer

    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

    0
    Comment actions Permalink
  • Avatar
    Venkata Ravi Kumar Mullamuri

    Thank you Ben... I will post a new question for any new queries on this topic.

    0
    Comment actions Permalink
  • Avatar
    Andrew Lund

    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

    0
    Comment actions Permalink
  • Avatar
    Andrew Lund

    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.

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • Avatar
    Andrew Lund

    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.

    0
    Comment actions Permalink

Please sign in to leave a comment.