We have Material Variant BOM in SAP, and using Collect to extract the tables, we still couldnt build the views to explode the right Bill of Material.
we are exploring the option to extract using Integrate - BAPI\RFC Script using RFC Function CS_BOM_EXPL_MAT_V2_RFC. But we are stuck at the point of how to provide inputs in Integrate to extract using Function
Any guidance is highly appreciated
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.
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.
Hi Andrew,
Thanks for the response, yes we are able to run in SE37 and get the output as desired
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?
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'
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.
I took am also interested in seeing how this is setup. Could you invite me also? joseph_flesche@merck.com
Please sign in to leave a comment.
Comments
7 comments