topic Re: QUERY IN SMART-FORMS in Application Development and Automation Discussions

QUERY IN SMART-FORMS

Former Member — Thu, 04 Oct 2007 07:16:38 GMT

I have a issue in SMART-FORMS::

The Long-text in AC01 is not displaying properly

where should i pass the parameters for read_text

where should i write the code for read_text function module

Re: QUERY IN SMART-FORMS

Former Member — Thu, 04 Oct 2007 07:19:26 GMT

Hi Ashok,

You can write the code for READ_TEXT in your driver program. pass the value from read_text to some variable and then pass that variable to smartform.

Hope this solves your problem.

Regards,

Bharat.

Reward points if helpful.

Re: QUERY IN SMART-FORMS

Former Member — Thu, 04 Oct 2007 07:28:15 GMT

Hi ,

No need to write the READ_TEXT fm,

in the TEXT node, Select INCLUDE TEXT in the TEXT TYPE , then in this it will ask the Object , ID ....everything whatever u p[ass to FM.

It is not advisable to use READ TEXT fm , when u have this best Option in INCLUDE TEXT.

Revert back if any issues,

Reward if helpful.

regards,

Naveen

Message was edited by:

Naveen Deva

Re: QUERY IN SMART-FORMS

Former Member — Thu, 04 Oct 2007 07:41:38 GMT

HI Ashok,

You can write the code for READ_TEXT in your smartform in program lines.

go and find out the name object id and object name from your long text and pass them accordingly.

CLEAR: IT_TLINE,

IT_TLINE[].

V_NAME = xyz.

V_ID = 'xyz'.

V_OBJECT = 'xyz'.

CALL FUNCTION 'READ_TEXT'

EXPORTING

CLIENT = SY-MANDT

ID = V_ID

LANGUAGE = SY-LANGU

NAME = V_NAME

OBJECT = V_OBJECT

TABLES

LINES = IT_TLINE

EXCEPTIONS

ID = 1

LANGUAGE = 2

NAME = 3

NOT_FOUND = 4

OBJECT = 5

REFERENCE_CHECK = 6

WRONG_ACCESS_TO_ARCHIVE = 7

OTHERS = 8.

Reward points if helpful.

Regards,

Harini.S

Re: QUERY IN SMART-FORMS

former_member189629 — Thu, 04 Oct 2007 07:50:26 GMT

Ashok,

Long text can be directly displayed in Smartforms without using READ_TEXT. Add the text element as an "Include Text" mention the object name, id, client, language etc. This will automatically pich the long text for that object and display...

Reward if helpful,

Karthik

Re: QUERY IN SMART-FORMS

Former Member — Thu, 04 Oct 2007 09:19:27 GMT

Thanks for your answer,

But in my Purchase-order (one document number)..There is one header-item

and 10 number of line-items....

The Long-text differs from one item-number to another item...

But i am getting the same long-text for all the item-numbers..

so plese kindly can you help me

Re: QUERY IN SMART-FORMS

former_member189629 — Thu, 04 Oct 2007 09:25:24 GMT

clear the ltext variable b4 populating & displaying it

Re: QUERY IN SMART-FORMS

Former Member — Thu, 04 Oct 2007 09:35:12 GMT

But in my Query,

I have 10 Line-items,I have 10 Long-text for 10 lIne-Items,it is displaying only

one long-text for all 10 Line Items...

The long Text for 10 Line-items is different,But only one long-text is displaying for all line-items..

so please clarify me this problem....

Re: QUERY IN SMART-FORMS

former_member189629 — Thu, 04 Oct 2007 09:37:53 GMT

Then r u extractign text tor all 10 items? I mean are u using the READ_TEXT in a loop thru the item table?