Need Guidance on setting up Extraction of BOM data using RFC Functions in Integrate

Answered

Comments

7 comments

  • Best answer
    Avatar
    Ben Bauer

    FYI - This discussion was moved to a Support ticket where we found that the issue is related to a RAW data column that produces an error in our Integrate product.  This issue with RAW columns is resolved in the 7.4.1 release of our Integrate product.  Before that release, some customers have worked around the problem by developing "wrappers" in ABAP to exclude the RAW column.

    Comment actions Permalink
  • Avatar
    Andrew Lund

    Subbiah Arunachalam - have you been able to successfully test CS_BOM_EXPL_MAT_V2_RFC directly in SAP using transaction SE37 and get the output you expect? If so, then we should be able to call from Integrate by populating the associated upload tables with the same parameters. If not, then you'll need help on the SAP application side to understand how the function works.

    0
    Comment actions Permalink
  • Avatar
    Subbiah Arunachalam

    Hi Andrew,

    Thanks for the response, yes we are able to run in SE37 and get the output as desired

    0
    Comment actions Permalink
  • Avatar
    Andrew Lund

    Subbiah Arunachalam - so what's the problem with Integrate? Have you tried creating the Template / Process (using the autogen feature to create the SQL objects) and then passing the same values that you used in SE37 into the created upload table?

    0
    Comment actions Permalink
  • Avatar
    Subbiah Arunachalam

    we have not used this feature of DSP Integrate, we have the following tables created by AutoGen - ttConfigBOM_DownloadConfigBOM__Download, ttConfigBOM_DownloadConfigBOM_Matcat_Download, ttConfigBOM_DownloadConfigBOM_Stb_Download. so trying to understand if we need to pass the inputs for the BOMs to be downloaded in ttConfigBOM_DownloadConfigBOM__Download. we have a field CAPID which is also expected to be passed in the function

    we have the following view from which we have the data in 

    SELECT CONVERT(nvarchar,getdate(),104) AS TopMat_DATUV, MATNR AS TopMat_MATNR, STLAN AS TopMat_STLAN, WERKS AS TopMat_WERKS
    FROM dgEP1.dbo.MAST WHERE WERKS = '5US5' AND CSLTY = 'X' AND STLAN = '3'

     

    0
    Comment actions Permalink
  • Avatar
    Andrew Lund

    Hello Subbiah - please can you arrange a call with me at a time of your convenience. You can send an invite to andrew.lund@syniti.com . We can do a screen share and see if we can get this working. In my experience, when you autogen the SQL objects, you typically get a _Upload and _Download tables and it's in the _upload tables that you pass the parameters.

    0
    Comment actions Permalink
  • Avatar
    Joseph Flesche

    I took am also interested in seeing how this is setup. Could you invite me also? joseph_flesche@merck.com

    0
    Comment actions Permalink

Please sign in to leave a comment.