Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Cost centre check and update in PA IT0001

    Posted 02-19-2020 22:57

    Hi All,

    I am trying to do a bulk upload for cost centre records held in PA IT0001 org assignment. What is the best way to do this utilizing winshuttle. Some of the changes are back dated to say 01.10.2019 . I have a script already but what I am wanting to do is avoid overriding any future dated records already in place starting after 01.10.2019.If the end date for the upload is 31.12.9999 winshuttle seems to override any future date records that already exist in IT0001 and this causes problems with data integrity.  Is there a way to use the winshuttle studio to validate if a future dated record exists in IT0001 before doing the upload?

    Thanks

    Sean



    ------------------------------
    Sean
    ------------------------------


  • 2.  RE: Cost centre check and update in PA IT0001

    Employee
    Posted 02-20-2020 13:53
    Hi Sean

    Your best bet is to use Query.  

    I setup an demo employee to have a future dated entry

    I created a simple query to extract just future dated rows for an employee using table PA0001 - when correlates to your infotype.

    Simple example is attached

    You can change the search criteria to meet your needs.  For example, provide a list of employee numbers in excel and use an IN operator.

    Hope that gives you an idea.

    Best Regards,
    Sigrid



    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Attachment(s)

    Qsq
    QueryPA0001FutureDated.Qsq   67 KB 1 version
    xlsx
    QueryPA0001FutureDated.xlsx   5 KB 1 version


  • 3.  RE: Cost centre check and update in PA IT0001

    Employee
    Posted 02-20-2020 14:03
    One other thought, Sean. 

    If you just want to know if anything is future dated - you could record PA30:
    - choose infotype 1
    - hit the overview
    - feed row 1 into the input box at the bottom and/or just select the first row
    - click edit and return the start and end dates.   

    That will tell you if there are any future dated entries.  But it won't tell you if there are several future dated entries - just that there is at least one.
    Sigrid-


    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------