To display Table data along with Long Texts in Adobe forms
Requirement:
Item No. |
Material No. |
Description |
Qty |
Price |
Long Text |
||||
10 |
P1000 |
ABC 1 ltr |
5 pcs |
250.00 |
Long Text of Material P1000 |
||||
20 |
P1001 |
XYZ 2 ltr |
5 pcs |
450.00 |
Long Text of Material P1001 |
Step 1: Go to Tcode: SE11 and create a structure YSTABLE1 as shown below:
Step 2: Create a table type YTTABLE for the above structure using Tcode: SE11
Step 3: Go to Tcode: SFP and create an interface YTABLE_INTERFACE as shown below
Step 4: Go to Tcode: SFP and design a form YFTABLE by providing the above interface.
In the context tab, drag and drop the internal table IT_TABLE into context area as shown below.
Step 5: To display long text, create a text field by right-clicking on data as shown below.
Select the text type as Include text. I have hard-coded the values of Text Object, Text Id, and Language. You can also pass them dynamically similar to that of Text Name.
Step 6: Go to Layout tab, and click on Data view as shown below
Now drag and drop the above fields into the below format and wrap them into a Subform eg. Body
Provide the Accessibility role of Subform as ‘Body Row’
Similarly create another Subform by name ‘Header’ for the Header description. Provide the Accessibility role as ‘Header Row’.
Wrap Subforms Header and Body into another Subform say ‘Table’.
Bind the Subform ‘Table’ as shown below
Make Subform ‘Table’ as Flowed.
Similarly bind the Subform ‘Body’ as shown below
For testing purpose, I have created a long text YTEXT using Tcode: SO10
Activate and run the form with the below test data.
Output:
Thanks,
Narsingh Ravinder
Cool...
nicely explained...worthful.
Good
Very helpful ..Good Job 🙂
Very well explained .. Thank You 🙂
Nice Blog.. Keep up the good work...!!!
May i know how can we do the ‘overflow’ setting for this long text design?
Noticed that if our subform is set to positioned, we will not be able to flow to next page. If we set it to ‘flowed’, then we are unable to position our text field accordingly.
Hello, thanks for the blog, very helpful, I have a question: I have standard description of material, but my client have a long_text in detail position text, I need to print standard text by default, but if the text position exist, I need to print those text, how can I do that ?
Thanks in advance
Cool, good detail explaination, appreciate it.