Automate

 View Only
  • 1.  Problem to run a web service on a repeating table after an excel data upload

    Posted 12-04-2023 06:04

    Hi,

    I hava a webservice running at the change of a column in a repeating table to check if the selected material already exists in SAP. It's based on BAPI_Existence_Check.

    It works well when I add items to the repeating table, but when I make a data upload by excel, the rows are uploaded than disappear and only the first entered value appears.

    How can I fix this issue?

    Thanks



    ------------------------------
    Skander HASSAYOUNE
    Data Operational Excellence Manager
    Hager Electro SAS
    OBERNAI
    ------------------------------


  • 2.  RE: Problem to run a web service on a repeating table after an excel data upload

    Posted 12 days ago

    Hi Skander,

    Did you find a resolution for this issue? This is happening for me as well.

    Thanks,

    Tim



    ------------------------------
    tim dempsey
    Process Engineer
    Clear Process Solutions
    OH
    ------------------------------



  • 3.  RE: Problem to run a web service on a repeating table after an excel data upload

    Employee
    Posted 11 days ago

    Hi Skander

    This is an area that sometimes takes a few tries to get right  :)  Can you please share how you are triggering the rule to run the BAPI on the row? 

    A few quick things to try - in the order that I would try them:

    • Is the run on load checked?  Have you tried to check onload?
    • Have you tried to convert the rule to Javascript to see if it behaves properly.  Please copy the rule first and disable the regular rule
    • Sometimes having what we call a helper field trigger it, one that isn't populated from a query or copy table helps.  You would set the rule to run on the helper field at the row level, and set that helper field when the material number gets filled in to a value, like "X" or "true".

    Hope that gives you a few ideas,

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------