Automate

Is it possible to use Query to retrieve long text from a service notification? What resources are available to guide me through the setup process?
Despite spending several hours reviewing online support resources, I can only locate STXL table, which publishes CLISTD field data (FF06020102028000343130330000000099040000121F9D02AB596A5B691808A2A718C107F11BF2A83E68142BE88320B64A414AF102BE496C6209B469C90511F24582).
Is it possible to use Direct to pull long text from a service notification? What resources are available to guide me through the setup process?

Thank you in advance.

------------------------------
Benjamin Kielas | Supervisor SAP Master Data
Generac Power Systems, Inc. | 12625106580
------------------------------

Hey Ben, 
These are the options available to use with the "Add Long Text" feature in Studio 20.2  (as of Aug 2022)- This feature hugely simplifies the long text read and update. 

As you see, IW53 is not listed. We may add more Tcodes in the future (we do some with each release) and Product Mgt is receptive to Customer requests. So please feel free to create one.

Fortunately, Reading text is much easier than writing -- so here are some options that can help you now:

1. Use Query and read from table STXL -- In table STXL - the field STXL-CLUSTD has the long text 
you would need to know the Object type STXL.TDOBJECT and for service notfication, this value should be QMEL 
and STXL.TDNAME = Service notification Number (with all its leading zeroes) 



OutputExample:


2. Use Direct and call the RFM - RFC_READ_TEXT

Input Structure: 


Output Example: 


The hardest part in this was to find out the Object Type for any given long text. 
This table has them - TDWOT
I was tripping up with using SMQMEL, turns out it was just QMEL --- I had to run some queries to figure this out. 
Hope this helps you make some progress.
Jayasri



​​​

------------------------------
Jayasri Varyani | SE
Winshuttle North America |
------------------------------

Original Message:
Sent: 08-19-2022 12:39
From: Benjamin Kielas
Subject: Looking for help on how to extract Service Notifications long text from IW53

Is it possible to use Query to retrieve long text from a service notification? What resources are available to guide me through the setup process?
Despite spending several hours reviewing online support resources, I can only locate STXL table, which publishes CLISTD field data (FF06020102028000343130330000000099040000121F9D02AB596A5B691808A2A718C107F11BF2A83E68142BE88320B64A414AF102BE496C6209B469C90511F24582).
Is it possible to use Direct to pull long text from a service notification? What resources are available to guide me through the setup process?

Thank you in advance.

------------------------------
Benjamin Kielas | Supervisor SAP Master Data
Generac Power Systems, Inc. | 12625106580
------------------------------

Thank you.
I will work on testing these options on how to pull the text info.

------------------------------
Benjamin Kielas | Supervisor SAP Master Data
Generac Power Systems, Inc. | 12625106580
------------------------------

Original Message:
Sent: 08-22-2022 10:11
From: Jayasri Varyani
Subject: Looking for help on how to extract Service Notifications long text from IW53

Hey Ben, 
These are the options available to use with the "Add Long Text" feature in Studio 20.2  (as of Aug 2022)- This feature hugely simplifies the long text read and update. 

As you see, IW53 is not listed. We may add more Tcodes in the future (we do some with each release) and Product Mgt is receptive to Customer requests. So please feel free to create one.

Fortunately, Reading text is much easier than writing -- so here are some options that can help you now:

1. Use Query and read from table STXL -- In table STXL - the field STXL-CLUSTD has the long text 
you would need to know the Object type STXL.TDOBJECT and for service notfication, this value should be QMEL 
and STXL.TDNAME = Service notification Number (with all its leading zeroes) 



OutputExample:


2. Use Direct and call the RFM - RFC_READ_TEXT

Input Structure: 


Output Example: 


The hardest part in this was to find out the Object Type for any given long text. 
This table has them - TDWOT
I was tripping up with using SMQMEL, turns out it was just QMEL --- I had to run some queries to figure this out. 
Hope this helps you make some progress.
Jayasri



​​​

------------------------------
Jayasri Varyani | SE
Winshuttle North America |

Original Message:
Sent: 08-19-2022 12:39
From: Benjamin Kielas
Subject: Looking for help on how to extract Service Notifications long text from IW53

Is it possible to use Query to retrieve long text from a service notification? What resources are available to guide me through the setup process?
Despite spending several hours reviewing online support resources, I can only locate STXL table, which publishes CLISTD field data (FF06020102028000343130330000000099040000121F9D02AB596A5B691808A2A718C107F11BF2A83E68142BE88320B64A414AF102BE496C6209B469C90511F24582).
Is it possible to use Direct to pull long text from a service notification? What resources are available to guide me through the setup process?

Thank you in advance.

------------------------------
Benjamin Kielas | Supervisor SAP Master Data
Generac Power Systems, Inc. | 12625106580
------------------------------

Jayasri,
Where I am stuck is knowing what boxes to check and what ones need to be upload and what ones need to be download data. I get an error with the layout I have currently.  As well as question if the loop is needed. Any help is appreciated. Trying to understand how to use direct is a challenge as I do not use BAPI or Function modules at all. I have attached the excel, script, and word with each screen and my current layout. Along with the error message I am getting.

------------------------------
Benjamin Kielas | Master Data
Generac Power Systems, Inc. | 2625106580
------------------------------

Original Message:
Sent: 08-22-2022 10:11
From: Jayasri Varyani
Subject: Looking for help on how to extract Service Notifications long text from IW53

Hey Ben, 
These are the options available to use with the "Add Long Text" feature in Studio 20.2  (as of Aug 2022)- This feature hugely simplifies the long text read and update. 

As you see, IW53 is not listed. We may add more Tcodes in the future (we do some with each release) and Product Mgt is receptive to Customer requests. So please feel free to create one.

Fortunately, Reading text is much easier than writing -- so here are some options that can help you now:

1. Use Query and read from table STXL -- In table STXL - the field STXL-CLUSTD has the long text 
you would need to know the Object type STXL.TDOBJECT and for service notfication, this value should be QMEL 
and STXL.TDNAME = Service notification Number (with all its leading zeroes) 



OutputExample:


2. Use Direct and call the RFM - RFC_READ_TEXT

Input Structure: 


Output Example: 


The hardest part in this was to find out the Object Type for any given long text. 
This table has them - TDWOT
I was tripping up with using SMQMEL, turns out it was just QMEL --- I had to run some queries to figure this out. 
Hope this helps you make some progress.
Jayasri



​​​

------------------------------
Jayasri Varyani | SE
Winshuttle North America |

Original Message:
Sent: 08-19-2022 12:39
From: Benjamin Kielas
Subject: Looking for help on how to extract Service Notifications long text from IW53

Is it possible to use Query to retrieve long text from a service notification? What resources are available to guide me through the setup process?
Despite spending several hours reviewing online support resources, I can only locate STXL table, which publishes CLISTD field data (FF06020102028000343130330000000099040000121F9D02AB596A5B691808A2A718C107F11BF2A83E68142BE88320B64A414AF102BE496C6209B469C90511F24582).
Is it possible to use Direct to pull long text from a service notification? What resources are available to guide me through the setup process?

Thank you in advance.

------------------------------
Benjamin Kielas | Supervisor SAP Master Data
Generac Power Systems, Inc. | 12625106580
------------------------------