(How) Can I include Long Texts in Reports or Queries?

[Former Member]

Hello,

We need to send our vendors their contract details including some of the long texts data.

So far we were sending excel spreadsheets to the vendors without the long texts. Is there some way we can start sending the spreadsheets to our vendors adding few extra columns for the long texts. Some of the vendors contracts have 20+ lines of data in the long texts.

Are there any better or easier ways than excel spreadsheets?

Is any kind of query development possible where long texts can be included?

Appreciate your time and answers.

Fred.

[Former Member]

Hi Fred

Try this link.

[https://forums.sdn.sap.com/click.jspa?searchID=22991360&messageID=6810980]

Regards

Hareesh

[former_member182096]

First, to answer your question on "Can I include Long Texts in Reports or Queries?", the answer is Yes. Absolutely.

How to do it...

While there are other ways to do it, I always felt the easiest way is to:

1. Go to SO10 - create a Standard text.

2. Use Read_text id with id equal to the name you created in step 1 and object = 'TEXT'

This will give you the lines from Standard text.

Regards,

Srini

P.S. I just assumed that you are looking for a static text...

P.S. Also, there are ways to do communicate your POs / contracts with suppliers electronically (if that is what your intent is)...

[Former Member]

Hi,

You can include long texts in excelsheet .

FIRST you need to create standard text by using SO10 ,if it's a static Text

But if its dynamic then you need to create text objects.

For using it hav a look on following link:

https://www.sdn.sap.com/irj/scn/wiki?path=/display/abap/anIntroductionofTextObjects

Now after read_text , that text can be passed to excelsheet.

Thanks,

Smita

[Former Member]

Sorry friends for not communicating my requirement clearly. I am aware of the functions to retrieve the long texts data for purchase orders/contracts.

I need some help in downloading the data to excel sheets. I believe there are restrictions in the number of characters that can be accomodated in a excel column, so I am not sure if very long texts (say >500 lines & 72 chars each) can be wrapped around within a excel column.

Also can a query be written to extract long texts, or can long texts, >500 lines & 72 chars each, be displayed using ALVs?

Thanks a lot for your time. Appreciate your inputs.

Below is a sample of how the report needs to look.

Contract Number	Vendor	Long Text1	Long Text2
0000000001	                ABC Firm	Text ID'01ABC' Text ID'01ABC' Text ID'01ABC' Text ID'01ABC' 	Text ID'02ABC' Text ID'02ABC' Text ID'02ABC' Text ID'02ABC' 
		                                Text ID'01ABC' Text ID'01ABC' Text ID'01ABC' Text ID'01ABC' 	Text ID'02ABC' Text ID'02ABC' Text ID'02ABC' Text ID'02ABC' 
		                                Text ID'01ABC' Text ID'01ABC' Text ID'01ABC' Text ID'01ABC' 	Text ID'02ABC' Text ID'02ABC' Text ID'02ABC' Text ID'02ABC' 
		                                Text ID'01ABC' Text ID'01ABC' Text ID'01ABC' Text ID'01ABC' 	Text ID'02ABC' Text ID'02ABC' Text ID'02ABC' Text ID'02ABC' 
0000000002	                XYZ Firm	Text ID'01XYZ' Text ID'01XYZ' Text ID'01XYZ' Text ID'01XYZ'	Text ID'02XYZ' Text ID'02XYZ' Text ID'02XYZ' Text ID'02XYZ' 
		                                Text ID'01XYZ' Text ID'01XYZ' Text ID'01XYZ' Text ID'01XYZ'	Text ID'02XYZ' Text ID'02XYZ' Text ID'02XYZ' Text ID'02XYZ' 
		                                Text ID'01XYZ' Text ID'01XYZ' Text ID'01XYZ' Text ID'01XYZ'	Text ID'02XYZ' Text ID'02XYZ' Text ID'02XYZ' Text ID'02XYZ' 
		                                Text ID'01XYZ' Text ID'01XYZ' Text ID'01XYZ' Text ID'01XYZ'	Text ID'02XYZ' Text ID'02XYZ' Text ID'02XYZ' Text ID'02XYZ' 

[Former Member]

Haven't got an answer...