Automate

 View Only
  • 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