|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Using Where conditions to relate header and item tables in Adobe forms
By Jayachandra Nagaram, YASH Technologies
In this demo we will create an Adobe form, which displays
relating data from two tables (Header and Item) by using ‘Where conditions’
in Form context.
Go to transaction SFP and create interface for the form.
this demo we can use the interface YDEMO_ALTERNATIVE which is used in previous
tutorial using alternatives.
Create Form YDEMO_TABLELEVEL
Maintain Interface type ABAP-Dictionary
Base interface. (IN ECC6.0 Version)
see two parts in screen Interface and context.
Drag and drop Global table GT_SPFLI from interface to context area.
Select all fields which are not required to display and deactivate the fields. (right click)
Select DATA under table GT_SPFLI and right click.
create a table i.e., a sub loop under the main loop.
when you drag a table in to context it will internally create a loop processing
in the form.
dialog box will open asking for table which you want to loop inside main loop.
Click the F4 help button, it shows the tables that exists in the interface.
Select the table GT_SFLIGHT (item details)
internally create a sub loop i.e, a table GT_SFLIGHT under the table SPFLI data.
Select the fields which are not required to display and deactivate.
Double click table GT_SFLIGHT and go to the where conditions tab available in
lower part of the window.
where condition for the table loop.
internally creates below code.
Loop at GT_SPFLI. Loop at GT_SFLIGHT where CARRID eq GT_SPFLI-CARRID and CONNID eq GT_SPFLI-CONNID.
.............................. } -----> code processing .............................. Endloop. Endloop.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards