topic Re: Displaying order text in smartforms in Application Development and Automation Discussions

Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 17:53:57 GMT

Hi,

I have designed a smartform where I need to print (using Read Text FM) sales order header text with text ID 0001selecting from VBFA.

Can anyone please help on the logic to fetch it and the steps.

Thanks in advance

Regards,

Tina

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 18:03:39 GMT

Are you saying that you don't know what parameters to feed to read_text?

Neal

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 18:09:21 GMT

No i mean I am not too sure about the logic to fetch the sales order header text VBBK from VBFA

Tina

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 18:13:16 GMT

So, which document type do you have in VBFA?

Neal

Re: Displaying order text in smartforms

former_member227140 — Mon, 03 Feb 2014 18:17:35 GMT

Use include text to display text ..

Go to VA02 and go to the text in question, go into the long text mode and then in the menu 'GoTo-->Header' option will give you how it is stored in the database. Just pass the NAME, OBJECT, and ID and language.

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 18:18:01 GMT

its a credit debit memo (YSDN)

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 18:21:06 GMT

So lets say that you have an invoice and your invoice was created from delivery and your delivery was created from SO. In VBFA with your invoice, you'd have to find the predecessor document that was a delivery. Then once again from VBFA with the found delivery document, you'd have to find the predecessor document that was of type sales order document.

Is that what you wanted?

Neal

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 18:29:46 GMT

You can use the function module below to get the Order flow, it will fetch the vbfa from Sales order.

CALL FUNCTION 'RV_ORDER_FLOW_INFORMATION'

EXPORTING

comwa = ls_comwa

TABLES

vbfa_tab = lt_return

EXCEPTIONS

no_vbfa = 1

no_vbuk_foun = 2

OTHERS = 3.

Regards,

Felipe

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 18:29:52 GMT

No.. I have all that info. I have the Vbtyp_n = L and vbtyp_v = k. but how do i get the order text? like what does the function module return? and does it return in a table? how do I get the header order text from there?

Tina

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 18:30:19 GMT

Hi Tina,

Go to t-code VA03 and Enter sales order and then goto=>header=>texts.

Click on the text editor and again go to=>header.

Now you will get all relevant details to sales order data ( NAME, OBJECT, and ID and language).

Just pass it the FM 'Read_Text' .

Hope it will help you..

Re: Displaying order text in smartforms

former_member227140 — Mon, 03 Feb 2014 18:31:30 GMT

why you want to go to VBFA table its document flow table ..just use read_text with following parameters

OBJECT VBBK

NAME 0000255562 here name is your sales order number

ID 0012

SPRAS EN

i am not sure what you wanted to achieve by going to VBFA for sales order header text.

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 18:42:04 GMT

I need to get the document number vbelv from vbfa. please help me with dispalying the order text that i ll get through the return parameter of READ_TEXT

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 18:48:15 GMT

Hi Tina,

Could you please clear your exact requirment??

Thanks.

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 18:55:34 GMT

You mention that you have all the info, if you have order number just call READ_TEXT with the parameters that abhijeet deshpande mentioned.

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 19:06:36 GMT

I wanted to know how to display the order text from the table that the FM returns

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 19:37:53 GMT

Hi Tina,

Please Check table 'STXH' with your sales order header text data ( NAME, OBJECT, and ID and language)

Thanks

Re: Displaying order text in smartforms

Former Member — Mon, 03 Feb 2014 21:25:04 GMT

There is really no practical solution for doing so without the FM.

Neal

Re: Displaying order text in smartforms

former_member227140 — Tue, 04 Feb 2014 04:26:23 GMT

if you wanted to display in smartforms

when you create simple text , for that text select text type as 'INCLUDE TEXT' and pass parameters i mentioned

OBJECT VBBK

NAME 0000255562 here name is your sales order number

ID 0012

SPRAS EN

here i have hard coded sales order number , get sales order number into a variable and pass to name. and thats it it will display header text on your smartforms.

why dont you try all these things which everyone is suggesting. please make yourself work on all the suggestions mentioned by all experts here.