How to display notes in reports?

[Former Member]

Dear community,

my customer wants to have a report listing all CRM activities (ActivityTasks, phone calls, emails, letters, appointments, etc.) with the notes.

I searched for suitable data sources but did not find any that includes the notes...

My second approach was to create my own business object, that is linked to the activity object and has one field as data type "LANGUAGEINDEPENDENT_Note" which holds the notes of the actual activity object. I then created a data source, joined it with another data source and tried to display the data in a report. Unfortunately, the report only shows the first 60 characters of notes...

Is there a way to show all contents of the field in a report?

Do you have another solution on how to display CRM activity notes in reports?

Thanks for your help and best regards,

Georg

[Former Member]

Hi Georg,

Please check in the current version 1608, you can export more characters.

Thanks

Arunkumar Kannan

[Former Member]

Hello Georg,

A bit late...

In reports, you can enable showing of extended text in report settings. See the attached image here. This shows up to 1024 characters but if you download the report, I guess it shows the entire text.

Hope this helps.

- Mahesh Tatini

[Former Member]

Hello Manesh,

Could you say where did you find this button?

because in the report I have this:

By the way do you have field "NOTE" in the Data Source of your report?

Maybe you know how I can add it to the data source?

BR,
Eugene

[Former Member]

I am not sure which report you are trying to update, but see in "Add fields" you find "Notes". If not, you need to modify the report itself to add Notes. If you cannot find the field in report wizard in Silverlight, you need to update the data source to add Notes, and then modify the report in wizard and then create the report view.

The screen shot I attached in my earlier reply is from HTML5 view. In table characterstics, you can control the field length.

Hope this helps.

thanks

Mahesh

[edavid_kramer]

I would like to use LanguageIndependent_Extended_Note, as an experiment initially.

The studio is requiring me to import a namespace. Does anyone know the name of the namespace needed to support this data type?

Thanks, David Kramer

Message was edited by: E. David Kramer

[Jacques-Antoine]

Hello David,

There is no LanguageIndependent_Extended_Note data type in ByDesign.

Instead use LANGUAGEINDEPENDENT_Note wit the namespace http://sap.com/xi/AP/Common/GDT

Thank you for your attention.

Best regards.

Jacques-Antoine Ollier

[Former Member]

Hi Georg,

Do you want to display the Activity and the Notes content in the activity in report?

If this is the requirement you can use the FM : "CRM_DNO_READ_ORDER_TEXT" which gives the notes in the particular transaction in an internal table.

Check this one.

Regards,

Rajya lakshmi.

[Former Member]

Hi Rajya Lakshmi,

yes, I want to have a report with the content of the notes-TextBox of Activities in reports.

How do I access / use the "CRM_DNO_READ_ORDER_TEXT"? Or what is it? I'm not familiar with this in ByDesign.

@Jacques-Antoine: Thanks for your hint! Unfortunately I have notes with have up to 1000 characters...

[Former Member]

Hi Georg,

Get the Activities guid and pass the guid to the below fm then you will get the Texts.

data: lT_ALLTEXTS TYPE COMT_TEXT_TEXTDATA_T,
      ls_ALLTEXTS TYPE COMT_TEXT_TEXTDATA.

CALL FUNCTION 'CRM_DNO_READ_ORDER_TEXT'
      EXPORTING
        iv_header_guid = gv_guid(header guid)
      IMPORTING
        et_alltexts    = lt_alltexts.

In the lt_alltexts internal table you can get the notes.

if necessary check the other parameters also.

Regards,

Rajya lakshmi ch

[Former Member]

Hi Rajya Lakshmi,

I'm afraid I don't know how to do this. I'm a partner and only have access to either the ByDesign system frontend as administrator or via the Cloud Applications Studio as developer user.

As far as I know I can't Access database tables or ABAP code in ByDesign directly. Could you tell / show me how to do this?

Thanks for your help!

Best regards,

Georg

[Jacques-Antoine]

Hello there,

I am not sure at all, but I think there is a problem with the length of your text string, so your notes.

Try to change your field data type with LANGUAGEINDEPENDENT_EXTENDED_Note

Normally, the extended type is a 255 characters string, which I hope is enough for your notes.

Hope that can help.

Regards,

Jacques-Antoine