How SAP Text list functionality works in DSP?

Answered

Venkata Ravi Kumar Mullamuri

• November 30, 2020 16:47

Hi All,

Can anyone explain how SAP Text list functionality works in DSP like from where it reads the text data in SAP and can we customize the columns in text table, if so what are the list of columns we can add and where to see the list of columns which can be added?

Thanks & Regards

Ravi

1

• Best answer

  

  Joseph Flesche

  • November 30, 2020 18:03

  Ah, ok. I'm aware of this, I didn't realize that it is called SAP Text List.

  Can anyone explain how SAP Text list functionality works in DSP

  From my experiences with Cransoft, you need to use a BOA / Syniti Function to have SAP compile the long text data. It used to be installed on the SAP application server (I forget the specifics). I'm not too sure if DSP uses the standard READ_TEXT function now (the program could be called something else, I do not recall the exact name).

  I believe that the Collect package will create a RFC (Remote Function Call) to compile the data and then download it.

  where it reads the text data in SAP

  SAP stores the long text data in STXH and STXL.

  can we customize the columns in text table

  Not that I know of.

  what are the list of columns

  Here are the fields.

  • MANDT
  • TDOBJECT
  • TDNAME
  • TDID
  • TDSPRAS
  • COUNTER
  • SequenceNo
  • TDFORMAT
  • TDLINE
  • INSTANCE

  what are the list of columns we can add and where to see the list of columns which can be added

  From my experiences with SAP Long Text, I don't think that you can add any columns. What are you looking to add?

  1
• 

  Joseph Flesche

  • November 30, 2020 17:26

  SAP Text list? Do you mean SAP Task List? Or SAP Long Text? Which specific parent object are you talking about?

  0
• 

  Venkata Ravi Kumar Mullamuri

  • November 30, 2020 17:42

  Hi Joseph,

  I am talking about the SAP text list(which is used to extract SAP long text) option which is available in Collect->Administrative->Advanced Options->SAP Text List.

  PFA screenshot for your reference.

  Thanks & Regards

  Ravi

  0
• 

  Ben Bauer

  • November 30, 2020 17:59
  • Edited

  Hi Ravi,

  The "SAP Text" package type in Collect makes use of the configuration on the SAP Text List page to run a function on the SAP application server named /BOA/ZRFC_READ_TEXT.  That function is a wrapper for the standard RFC_READ_TEXT function in the SAP application.  It essentially downloads data from the tables STXH and STXL.

  Related Help articles:

  • https://dsphelp.syniti.com/740/general/Collect/Use_Cases/Package_Types.htm?Highlight=%22sap%20text%22
  • https://dsphelp.syniti.com/740/general/Collect/Use_Cases/Use_Advanced_Options.htm?Highlight=%22sap%20text%22
  • https://dsphelp.syniti.com/740/general/Collect/Page_Desc/SAP_Text_List_H.htm

  More Detail on the RFC_READ_TEXT function in SAP:

  • https://blogs.sap.com/2015/08/02/sap-pb-part-2-rfcreadtable/
  • https://answers.sap.com/questions/2818966/RFC_READ_TABLE.html

  Thanks,

  Ben

  1
• 

  Venkata Ravi Kumar Mullamuri

  • December 02, 2020 15:10

  Thank you Ben and Joseph for your responses, it clears my query.

  Joseph Flesche - I am trying to see the feasibility of adding additional columns into SAP Text table other than what is already available.

  From your responses i understood that we can add columns from STXH,STXL tables if required, correct me if understanding is wrong.

  Thanks & Regards

  Ravi

  0

Please sign in to leave a comment.