Automate

 View Only
  • 1.  Query PR header text

    Posted 04-28-2021 02:25
    Is there a way to use Winshuttle query to pull the header text from a number of PR's. I'm not having much luck!

    Any help would be greatly appreciated!

    Lauren ​

    ------------------------------
    Lauren Simpson | Process Control Engineer
    BP Limited (UK) |
    ------------------------------


  • 2.  RE: Query PR header text

    Posted 04-28-2021 08:54
    Hi Lauren -

    You have a couple of different options. If you are using a not super old version of Studio and have the WFM installed on your SAP system, then you could use the built-in Winshuttle functionality for creating  or reading long text using a t-code. You can actually use ME52N or ME53N.  

    If that does not work, then you could try the extraction by query way, but you would have to provide the individual details of the type of long text you are trying to extract, and then feed in the PR numbers as one of the criteria, and you would want to use an IN operator since you want to look at list of PRs. Also seems like the leading zeros need to be included in the PR number in your list provided, not just pad the 0s using query itself. 

    I've attached some simplified examples. 

    Thank you!

    ------------------------------
    Jennifer Hwang | SE
    Winshuttle North America
    ------------------------------

    Attachment(s)

    Qsq
    PRHeaderNote.Qsq   33 KB 1 version
    xlsx
    ME52N_ReadHeaderNote.xlsx   4 KB 1 version
    Txr
    ME52N_ReadHeaderNote.Txr   3.21 MB 1 version