topic Re: Create long text for notification in Application Development and Automation Discussions

Create long text for notification

Former Member — Tue, 27 Mar 2012 12:30:12 GMT

Hi All, I have a requirement wherein, PI is passing data to SAP R/3 using a custom RFC developed using ABAP. There is a field in the RFC which is to input the long text. But the long text can be of any large length. Can I know what should the length of this RFC long text field be in order to recieve the long text from the PI as input?

Re: Create long text for notification

Private_Member_49934 — Tue, 27 Mar 2012 12:41:49 GMT

Does the long text get saved into the database? if yest then you should be able to convert the data in table to use the FM SAVE_TEXT. If it just any field in the database which will get updated then it depends upon the requirement.

I think it should be the target field which is getting updated by RFC which will determine the length.

Re: Create long text for notification

Former Member — Tue, 27 Mar 2012 12:45:12 GMT

Actually I am not fetching any long text from the database to pass it to the RFC. PI is passing a long text to the ABAP RFC. This RFC is custom development. I do not understand how much length I must give to this RFC long text input field so as to accomodate all the contents of the long text that is passed from PI. After I fetch the text from PI, I am passing this text to BAPI_ALM_NOTIF_CREATE to create a notification.

Re: Create long text for notification

former_member189779 — Tue, 27 Mar 2012 12:47:43 GMT

If you are going to update this text in SAP then make Table paramter in your FM type TLINE

And ask PI to send text in this table so that you can also have multiple line text. One line will have 132 Char.

Re: Create long text for notification

Former Member — Tue, 27 Mar 2012 12:54:00 GMT

Yes I too thought of the same solution. My doubt is, PI is inturn fetching bulk data from a 3rd party database table and this contains the text too. This data is passed in bulk to my RFC. So will PI be able to pass just the long text data in table format? If yes, then how?

Re: Create long text for notification

Former Member — Tue, 27 Mar 2012 13:00:45 GMT

hi,

create variable as string or xstring.

then u can split the string and store in database as well.

Thnk and regards.

Re: Create long text for notification

Private_Member_49934 — Tue, 27 Mar 2012 13:08:46 GMT

Make it as string .

Then use the FM CONVERT_STREAM_TO_ITF_TEXT to convert it in text table.

Finaly use it to poulate

LONGTEXTS in the BAPI.

Re: Create long text for notification

Former Member — Tue, 27 Mar 2012 13:13:00 GMT

Hi,

Yes, PI should be able to do the job of splitting the single line data to multiple lines/table format based on the length, PI can have a logic to check the length up to 135 characters and pass it as single line of the table and the new line for the next 135 chars. Standard BAPI uses the struture longtexts

Field	Data Element	Data Type	length	Value
OBJTYPE	SWO_OBJTYP	CHAR	000010	Object type related to PM notification
OBJKEY	QOBJKEY	NUMC	000008	Notification number
FORMAT_COL	TDFORMAT	CHAR	000002	Default "*"
TEXT_LINE	TDLINE	CHAR	000132	Text

Cheers,
Prasanna

Re: Create long text for notification

former_member189779 — Tue, 27 Mar 2012 13:18:43 GMT

In PI they can write a small User defined function to split the text and send it through internal table as an array by using result.addValue method of Java.

Re: Create long text for notification

Former Member — Tue, 27 Mar 2012 13:56:16 GMT

I just found out that the table from which PI is fetching the data contains the long text in a field of length VARCHAR2(1750 bytes). I thought I can use the same length in RFC also. Can you please tell me what is the length I should use in this case. How do I convert this length to characters?

Re: Create long text for notification

former_member189779 — Tue, 27 Mar 2012 14:19:41 GMT

You can use STRING

Re: Create long text for notification

Private_Member_49934 — Tue, 27 Mar 2012 15:08:48 GMT

Hi Smitha,

If you see the keyword help you will find that string is predefined data type in data dictionary. It is capable of handling variable length of character starting 256 characters.

You can use you import parameter in the RFC FM as string and you should be able to get it in the FM properly. NO NEED TO SPECIFY ANY LENGHT.

Now in you RFC FM

You can code something like below

TYPES : ty_string_tab TYPE STANDARD TABLE OF char72
                        WITH KEY table_line.

DATA : l_v_len TYPE i,
       l_it_string_tab TYPE ty_string_tab,
       l_it_lng_txt TYPE tline_t,
       l_v_char72 TYPE char72.
l_v_len = STRLEN( l_v_text ).

IF l_v_len <> 0.
DO .
    IF l_v_len <= 72.
      l_v_char72 = l_v_text(l_v_len).
      APPEND l_v_char72 TO l_it_string_tab.
      CLEAR l_v_char72.
      EXIT.
    ELSE.
      l_v_len = l_v_len - 72.
      l_v_char72 = l_v_text(72).
      APPEND l_v_char72 TO l_it_string_tab.
      SHIFT l_v_text BY 72 PLACES LEFT.
    ENDIF.
    CLEAR l_v_char72.
ENDDO.
ENDIF.

CALL FUNCTION 'CONVERT_STREAM_TO_ITF_TEXT'
TABLES
    text_stream = l_it_string_tab
    itf_text    = l_it_lng_txt.

Finallly loop at l_it_lng_txt and append the table of you bapi. You will get the format and text line from this table. The first two columns you must be knowing already.

Note : the string in the database is varchar2 . It may contain tabs and new line. That is why the above FM is required to get the correct format.

Let me know if it is not clear still. Rewar POINTS if helpfu.

Re: Create long text for notification

Former Member — Tue, 27 Mar 2012 15:36:48 GMT

I used the string format for the field but unfortunately, I am not able to input any data into this field. When i try executing the RFC, the import table which contains field to enter the text is shown in display mode. PFA the screen where it gives me a message that I can only see the table in display mode.

Re: Create long text for notification

Private_Member_49934 — Tue, 27 Mar 2012 16:21:28 GMT

can you post the function module interface parameter? I can comment after that only.

Re: Create long text for notification

Former Member — Wed, 28 Mar 2012 05:25:35 GMT

The RFC has the following Import parameter:

IT_NOTIF which is of table type ZMPM_NOTIF_CREATE_TY. This table type is of line type ZMPM_NOTIF_CREATE having the custom structure containing the fields:

Notif_no,

NOTIF_TYPE

NOTIF_DESCRIBE

The field of concern is NOTIF_DESCRIBE which needs to accomodate the long text. If I create a data element of type string and associate this with NOTIF_DESCRIBE field, then while executing the RFC, i am not able to give any input in the IT_NOTIF table. Please help

Re: Create long text for notification

Former Member — Wed, 28 Mar 2012 05:47:59 GMT

Hi,

Create the table type as ZMPM_NOTIF_CREATE_TY.pass this to import parameter,now you havin all the data from PI.

loop the table .

use RKD_WORD_WRAP.pass your line type NOTIF_DESRIBE to this FM.

you can move that into saparate variables,you can store in intarnal table.

endloop.

thank and regards

Re: Create long text for notification

Former Member — Wed, 28 Mar 2012 06:06:29 GMT

Yes but data from PI is getting truncated even if i declare the type as string. It is accepting only a maximum of 255 characters.

Re: Create long text for notification

Private_Member_49934 — Wed, 28 Mar 2012 08:05:20 GMT

If you are doing everything correctly then it's the problem from PI end and not from abap end.

Please check the attachment with screenshot. I am not getting any problem. Also check the documentation attached. String doesn't has any limit.

But please note that in FM test environment you won't be able to add more than 255 character which is the LIMIT OF FUNCTION MODULE TEST ENVIRONMENT. But you can test it programatically. I am sure it won't get tructed.

Let me know if you find it useful.

Re: Create long text for notification

Former Member — Wed, 28 Mar 2012 10:51:31 GMT

Please check the attached screen shots. I am still not able to enter any data.

Re: Create long text for notification

Private_Member_49934 — Wed, 28 Mar 2012 11:03:04 GMT

Could you please check the table type Z243_TY. Is it sorted?