Automate

Hi all,

I need to check the long texts in a Project with WBS-elements.
Therefore I've connected tables PROJ, PRPS, PRTX and PSTX.
This works fine and I see the PMS- and PS-texts.
But I need also the long texts connected to the PS-texts.
PSTX-PSTXTKY is the internal textnumber in PSTX.
I need to connect this to table STXL where the long texts are stored.
STXL-TDNAME contains this number but the length of this field is 70 char. PSTX-PSTXTKY is 12 char.
This gives a mismatch in the join.

When I query on table STXL and enter the objects myself I get the correct texts returned.
I could create 2 query's and connect them to get the result but I wanted to retreive the texts in one query.
Is there a way to transform PSTXTKY to TDNAME during setting up the criteria?

Thanks in advance,

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169
------------------------------

Hi Jan

I've been in the same place as you.  You can't easily (at all?) connect the long text tables to the "normal" tables.

You'll either be stuck with 2 queries and vlookups or a script that reads/downloads the long text.

Feel free to open a ticket to request that one of the CJxyz tcodes gets added to the WFM (aka Winshuttle Function Module) way of handling long text.  Perhaps CJ20? 

Best Regards,
Sigrid

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

Original Message:
Sent: 07-31-2020 07:23
From: Jan van Asseldonk
Subject: Retreiving long texts with query

Hi all,

I need to check the long texts in a Project with WBS-elements.
Therefore I've connected tables PROJ, PRPS, PRTX and PSTX.
This works fine and I see the PMS- and PS-texts.
But I need also the long texts connected to the PS-texts.
PSTX-PSTXTKY is the internal textnumber in PSTX.
I need to connect this to table STXL where the long texts are stored.
STXL-TDNAME contains this number but the length of this field is 70 char. PSTX-PSTXTKY is 12 char.
This gives a mismatch in the join.

When I query on table STXL and enter the objects myself I get the correct texts returned.
I could create 2 query's and connect them to get the result but I wanted to retreive the texts in one query.
Is there a way to transform PSTXTKY to TDNAME during setting up the criteria?

Thanks in advance,

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169
------------------------------

Hi Sigrid,

I've opened a ticket for this and in the meantime it has been raised as a enhancement request. (Ref.nr. WIN-39627)

Best Regards,
Jan

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169
------------------------------

Original Message:
Sent: 08-05-2020 15:25
From: Sigrid Kok
Subject: Retreiving long texts with query

Hi Jan

I've been in the same place as you.  You can't easily (at all?) connect the long text tables to the "normal" tables.

You'll either be stuck with 2 queries and vlookups or a script that reads/downloads the long text.

Feel free to open a ticket to request that one of the CJxyz tcodes gets added to the WFM (aka Winshuttle Function Module) way of handling long text.  Perhaps CJ20?

Best Regards,
Sigrid

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

Original Message:
Sent: 07-31-2020 07:23
From: Jan van Asseldonk
Subject: Retreiving long texts with query

Hi all,

I need to check the long texts in a Project with WBS-elements.
Therefore I've connected tables PROJ, PRPS, PRTX and PSTX.
This works fine and I see the PMS- and PS-texts.
But I need also the long texts connected to the PS-texts.
PSTX-PSTXTKY is the internal textnumber in PSTX.
I need to connect this to table STXL where the long texts are stored.
STXL-TDNAME contains this number but the length of this field is 70 char. PSTX-PSTXTKY is 12 char.
This gives a mismatch in the join.

When I query on table STXL and enter the objects myself I get the correct texts returned.
I could create 2 query's and connect them to get the result but I wanted to retreive the texts in one query.
Is there a way to transform PSTXTKY to TDNAME during setting up the criteria?

Thanks in advance,

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169
------------------------------

Hi Jan--Did this go anywhere? I'm in a similar boat.

------------------------------
Jaime Satko | Data Solutions Engineer I
Patterson Companies | 6514054989
------------------------------

Original Message:
Sent: 08-11-2020 09:58
From: Jan van Asseldonk
Subject: Retreiving long texts with query

Hi Sigrid,

I've opened a ticket for this and in the meantime it has been raised as a enhancement request. (Ref.nr. WIN-39627)

Best Regards,
Jan

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169

Original Message:
Sent: 08-05-2020 15:25
From: Sigrid Kok
Subject: Retreiving long texts with query

Hi Jan

I've been in the same place as you.  You can't easily (at all?) connect the long text tables to the "normal" tables.

You'll either be stuck with 2 queries and vlookups or a script that reads/downloads the long text.

Feel free to open a ticket to request that one of the CJxyz tcodes gets added to the WFM (aka Winshuttle Function Module) way of handling long text.  Perhaps CJ20?

Best Regards,
Sigrid

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

Original Message:
Sent: 07-31-2020 07:23
From: Jan van Asseldonk
Subject: Retreiving long texts with query

Hi all,

I need to check the long texts in a Project with WBS-elements.
Therefore I've connected tables PROJ, PRPS, PRTX and PSTX.
This works fine and I see the PMS- and PS-texts.
But I need also the long texts connected to the PS-texts.
PSTX-PSTXTKY is the internal textnumber in PSTX.
I need to connect this to table STXL where the long texts are stored.
STXL-TDNAME contains this number but the length of this field is 70 char. PSTX-PSTXTKY is 12 char.
This gives a mismatch in the join.

When I query on table STXL and enter the objects myself I get the correct texts returned.
I could create 2 query's and connect them to get the result but I wanted to retreive the texts in one query.
Is there a way to transform PSTXTKY to TDNAME during setting up the criteria?

Thanks in advance,

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169
------------------------------

Hi Jaime,

I didn't get further response on the enhancement request yet.
If so I will share it in this post.

Regards

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169
------------------------------

Original Message:
Sent: 10-12-2020 13:48
From: Jaime Jost
Subject: Retreiving long texts with query

Hi Jan--Did this go anywhere? I'm in a similar boat.

------------------------------
Jaime Satko | Data Solutions Engineer I
Patterson Companies | 6514054989

Original Message:
Sent: 08-11-2020 09:58
From: Jan van Asseldonk
Subject: Retreiving long texts with query

Hi Sigrid,

I've opened a ticket for this and in the meantime it has been raised as a enhancement request. (Ref.nr. WIN-39627)

Best Regards,
Jan

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169

Original Message:
Sent: 08-05-2020 15:25
From: Sigrid Kok
Subject: Retreiving long texts with query

Hi Jan

I've been in the same place as you.  You can't easily (at all?) connect the long text tables to the "normal" tables.

You'll either be stuck with 2 queries and vlookups or a script that reads/downloads the long text.

Feel free to open a ticket to request that one of the CJxyz tcodes gets added to the WFM (aka Winshuttle Function Module) way of handling long text.  Perhaps CJ20?

Best Regards,
Sigrid

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

Original Message:
Sent: 07-31-2020 07:23
From: Jan van Asseldonk
Subject: Retreiving long texts with query

Hi all,

I need to check the long texts in a Project with WBS-elements.
Therefore I've connected tables PROJ, PRPS, PRTX and PSTX.
This works fine and I see the PMS- and PS-texts.
But I need also the long texts connected to the PS-texts.
PSTX-PSTXTKY is the internal textnumber in PSTX.
I need to connect this to table STXL where the long texts are stored.
STXL-TDNAME contains this number but the length of this field is 70 char. PSTX-PSTXTKY is 12 char.
This gives a mismatch in the join.

When I query on table STXL and enter the objects myself I get the correct texts returned.
I could create 2 query's and connect them to get the result but I wanted to retreive the texts in one query.
Is there a way to transform PSTXTKY to TDNAME during setting up the criteria?

Thanks in advance,

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169
------------------------------

One thing I have done for "querying" long text is to download it into a text file. We have also had our IT developers create a wrapper for a BAPI to be able to run a direct script in Winshutte.

If you go the download method you can save the text file to a targeted directory. From there I use VBA to change all the text files into Excel files and then I have another VBA to combine all the Excel files into individual tabs in Excel. It's also possible to merge all of these onto a single tab in Excel with VBA.

------------------------------
Derek Sayres | SAP PLM Business Analyst
------------------------------

Original Message:
Sent: 10-13-2020 05:07
From: Jan van Asseldonk
Subject: Retreiving long texts with query

Hi Jaime,

I didn't get further response on the enhancement request yet.
If so I will share it in this post.

Regards

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169

Original Message:
Sent: 10-12-2020 13:48
From: Jaime Jost
Subject: Retreiving long texts with query

Hi Jan--Did this go anywhere? I'm in a similar boat.

------------------------------
Jaime Satko | Data Solutions Engineer I
Patterson Companies | 6514054989

Original Message:
Sent: 08-11-2020 09:58
From: Jan van Asseldonk
Subject: Retreiving long texts with query

Hi Sigrid,

I've opened a ticket for this and in the meantime it has been raised as a enhancement request. (Ref.nr. WIN-39627)

Best Regards,
Jan

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169

Original Message:
Sent: 08-05-2020 15:25
From: Sigrid Kok
Subject: Retreiving long texts with query

Hi Jan

I've been in the same place as you.  You can't easily (at all?) connect the long text tables to the "normal" tables.

You'll either be stuck with 2 queries and vlookups or a script that reads/downloads the long text.

Feel free to open a ticket to request that one of the CJxyz tcodes gets added to the WFM (aka Winshuttle Function Module) way of handling long text.  Perhaps CJ20?

Best Regards,
Sigrid

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

Original Message:
Sent: 07-31-2020 07:23
From: Jan van Asseldonk
Subject: Retreiving long texts with query

Hi all,

I need to check the long texts in a Project with WBS-elements.
Therefore I've connected tables PROJ, PRPS, PRTX and PSTX.
This works fine and I see the PMS- and PS-texts.
But I need also the long texts connected to the PS-texts.
PSTX-PSTXTKY is the internal textnumber in PSTX.
I need to connect this to table STXL where the long texts are stored.
STXL-TDNAME contains this number but the length of this field is 70 char. PSTX-PSTXTKY is 12 char.
This gives a mismatch in the join.

When I query on table STXL and enter the objects myself I get the correct texts returned.
I could create 2 query's and connect them to get the result but I wanted to retreive the texts in one query.
Is there a way to transform PSTXTKY to TDNAME during setting up the criteria?

Thanks in advance,

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169
------------------------------

I just went the route of extracting the long text via a transaction script and using a good ol' vlookup to line it up with the query results, which worked just fine. I appreciate that Winshuttle makes getting to the long text easy, at least in Studio 12.1, I can't attest to the older versions.

------------------------------
Jaime Jost | Data Solutions Engineer I
Patterson Companies | 6514054989
------------------------------

Original Message:
Sent: 10-13-2020 08:00
From: Derek Sayres
Subject: Retreiving long texts with query

One thing I have done for "querying" long text is to download it into a text file. We have also had our IT developers create a wrapper for a BAPI to be able to run a direct script in Winshutte.

If you go the download method you can save the text file to a targeted directory. From there I use VBA to change all the text files into Excel files and then I have another VBA to combine all the Excel files into individual tabs in Excel. It's also possible to merge all of these onto a single tab in Excel with VBA.

------------------------------
Derek Sayres | SAP PLM Business Analyst

Original Message:
Sent: 10-13-2020 05:07
From: Jan van Asseldonk
Subject: Retreiving long texts with query

Hi Jaime,

I didn't get further response on the enhancement request yet.
If so I will share it in this post.

Regards

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169

Original Message:
Sent: 10-12-2020 13:48
From: Jaime Jost
Subject: Retreiving long texts with query

Hi Jan--Did this go anywhere? I'm in a similar boat.

------------------------------
Jaime Satko | Data Solutions Engineer I
Patterson Companies | 6514054989

Original Message:
Sent: 08-11-2020 09:58
From: Jan van Asseldonk
Subject: Retreiving long texts with query

Hi Sigrid,

I've opened a ticket for this and in the meantime it has been raised as a enhancement request. (Ref.nr. WIN-39627)

Best Regards,
Jan

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169

Original Message:
Sent: 08-05-2020 15:25
From: Sigrid Kok
Subject: Retreiving long texts with query

Hi Jan

I've been in the same place as you.  You can't easily (at all?) connect the long text tables to the "normal" tables.

You'll either be stuck with 2 queries and vlookups or a script that reads/downloads the long text.

Feel free to open a ticket to request that one of the CJxyz tcodes gets added to the WFM (aka Winshuttle Function Module) way of handling long text.  Perhaps CJ20?

Best Regards,
Sigrid

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

Original Message:
Sent: 07-31-2020 07:23
From: Jan van Asseldonk
Subject: Retreiving long texts with query

Hi all,

I need to check the long texts in a Project with WBS-elements.
Therefore I've connected tables PROJ, PRPS, PRTX and PSTX.
This works fine and I see the PMS- and PS-texts.
But I need also the long texts connected to the PS-texts.
PSTX-PSTXTKY is the internal textnumber in PSTX.
I need to connect this to table STXL where the long texts are stored.
STXL-TDNAME contains this number but the length of this field is 70 char. PSTX-PSTXTKY is 12 char.
This gives a mismatch in the join.

When I query on table STXL and enter the objects myself I get the correct texts returned.
I could create 2 query's and connect them to get the result but I wanted to retreive the texts in one query.
Is there a way to transform PSTXTKY to TDNAME during setting up the criteria?

Thanks in advance,

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169
------------------------------