Automate

 View Only
Expand all | Collapse all

VOE4 EDPAR

  • 1.  VOE4 EDPAR

    Posted 06-12-2024 08:32

    Does anyone have a script to add entries to the EDPAR table without it existing the TCODE to enter the second line in the data?   

    Essentially want to add new entry, Save, Back.. then new entry, Save, Back.  



    ------------------------------
    Steve Sheppard
    Sr Director Accounting
    Spectrum Brands, Inc.
    GA
    ------------------------------


  • 2.  RE: VOE4 EDPAR

    Employee
    Posted 06-12-2024 12:34

    Hi Steve

    We don't provide the ability to go directly to the backend tables in SAP to maintain them.  You'd have to enable some type of edit capabilities for your table(s) in a tcode like SE16(N) or SM30 or a custom tcode or bapi, which is through the application layer.

    Best Regards,

    Sigrid



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



  • 3.  RE: VOE4 EDPAR

    Posted 06-12-2024 12:44

    Thanks Sigrid... I have a script that adds "new entries" via the VOE4 tcode.  I want to be able to enter multiple "new entries" at once and save them.   Right now it adds the new entry, saves and exits TCODE.  Then Opens VOE4 again and adds the second record.   And so on...  Looking for some way to keep the script from exiting the TCODE after the first record. 

     



    ------------------------------
    Steve Sheppard
    Sr Director Accounting
    Spectrum Brands, Inc.
    GA
    ------------------------------



  • 4.  RE: VOE4 EDPAR

    Employee
    Posted 06-12-2024 12:56

    Hi Steve

    Missed that - sorry.  Can you please share what you have?  It should be possible to add new rows in a loop, if that's what you're after?

    click new entries

    then

    (1) add one on the last row

    (2) hit enter (which moves it to the top)

    (3) page to bottom & last page with navigation in case you screen is full with entries

    Put a loop around the above steps.

    I haven't tried it with this tcode, but something like that normally works for what I think you want to do.

    Best Regards,

    Sigrid



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



  • 5.  RE: VOE4 EDPAR

    Posted 06-12-2024 13:21

    Thank you again for your input.   If I create the loop.... What field would be my header?  

    I have a script that works but need to load 16000 records and it is ultra slow.  



    ------------------------------
    Steve Sheppard
    Sr Director Accounting
    Spectrum Brands, Inc.
    GA
    ------------------------------



  • 6.  RE: VOE4 EDPAR

    Employee
    Posted 06-12-2024 14:31

    Hi Steve,

    There woudn't be any header fields and that's ok. 

    I just did a quick and dirty test

    So it should work.  Please make sure you do a page to the bottom and then a page down in the loop so that you don't overwrite any entries.

    HTH,

    Sigrid



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



  • 7.  RE: VOE4 EDPAR

    Posted 06-12-2024 17:54

    Can you show me what your expert view of the loop looks like?  I am getting an error message that External Partner is not an input field.  

    Thank you so much for your help



    ------------------------------
    Steve Sheppard
    Sr Director Accounting
    Spectrum Brands, Inc.
    GA
    ------------------------------



  • 8.  RE: VOE4 EDPAR

    Employee
    Posted 06-14-2024 20:18

    Hi Steve,

    Here you go:

    Attaching example, but I didn't do exhaustive testing, so please review and test on a non-prod system.

    Best Regards,

    Sigrid



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

    Attachment(s)

    Txr
    VOE4 _20240612_112658.Txr   210 KB 1 version


  • 9.  RE: VOE4 EDPAR

    Posted 07-16-2024 00:25

    tried recording like this for any table update vis sm30 confused how will script understand that now I have reached end of rows and need to press last page button vs next page button ? 



    ------------------------------
    Gagan Pareek
    Technical Delivery Lead
    Nielsen Consumer, LLC
    COLUMBIA MD
    ------------------------------



  • 10.  RE: VOE4 EDPAR

    Employee
    Posted 07-16-2024 10:47

    Hi Gagan

    You proactively scroll to the bottom (last page) and page down.  Put a loop around that. Then you are guaranteed the last row is empty.

    If you manually get into the tcode and fill a bit more than a page, you'll see this works.

    Best Regards,

    Sigrid



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



  • 11.  RE: VOE4 EDPAR

    Posted 07-16-2024 10:49

    Gagan, 

    Attached is my script for VOE4.     Let me know if this makes sense.   Each entry is saved temporarily and then at the end the transaction is saved and the table is updated. 



    ------------------------------
    Steve Sheppard
    Sr Director Accounting
    Spectrum Brands, Inc.
    GA
    ------------------------------

    Attachment(s)

    Txr
    VOE4_EDPAR_LOAD.Txr   128 KB 1 version
    xlsx
    VOE4_EDPAR_LOAD.xlsx   11 KB 1 version


  • 12.  RE: VOE4 EDPAR

    Posted 13 days ago

    A user is requesting an update to this script.    They are saying they need a way to click on the "Skip" button on the top of the screen if they somehow enter a combination that already exists in the table.   

    Any thoughts? 



    ------------------------------
    Steve Sheppard
    Sr Director Accounting
    Spectrum Brands, Inc.
    GA
    ------------------------------



  • 13.  RE: VOE4 EDPAR

    Employee
    Posted 11 days ago

    Hi Steve,

    Am not sure what you're seeing. I get a hard error

    Can you share what you're seeing?

    Typically with loops it's all or nothing. If you remove the loop, it will post what it can and then error out on the duplicates - slower but still effective.

    Please advise on your message,

    Sigrid



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



  • 14.  RE: VOE4 EDPAR

    Posted 6 days ago

    Hi Sigrid,  

    That is the message that we are getting.   There is a button up at the top below the word new.   The team is asking if we can have Winshuttle click on that button to skip the duplicate.   As a workaround, I have created a query of the EDPAR table with a "cheat" column that concatenates all of the fields for them to check before they load.

    Thanks!    



    ------------------------------
    Steve Sheppard
    Sr Director Accounting
    Spectrum Brands, Inc.
    GA
    ------------------------------



  • 15.  RE: VOE4 EDPAR

    Employee
    Posted 6 days ago

    Hi Steve

    That would work for one at a time, but not in a loop. It's not a pop-up you can skip if not found -- it's an error message. Because you have encountered an error, the script stops. I tried a few things anyway, and it didn't work.

    Your workaround for a loop is great. For one at a time, you can ignore the error because it's a duplicate.

    Best Regards,

    Sigrid



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