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. 

Step1: Go to transaction SFP and create interface for the form.

In this demo we can use the interface YDEMO_ALTERNATIVE which is used in previous tutorial using alternatives. 

Step2: Create Form YDEMO_TABLELEVEL

Note: Maintain Interface type ABAP-Dictionary Base interface. (IN ECC6.0 Version) 

You will see two parts in screen Interface and context.

Step3: Drag and drop Global table GT_SPFLI from interface to context area.

Step4: Select all fields which are not required to display and deactivate the fields. (right click)

Step5: Select DATA under table GT_SPFLI and right click.

Go to create--> Loop

This will create a table i.e., a sub loop under the main loop.

Note: when you drag a table in to context it will internally create a loop processing in the form.

Step6: A dialog box will open asking for table which you want to loop inside main loop.

Step7: Click the F4 help button, it shows the tables that exists in the interface. 

Step8: Select the table GT_SFLIGHT (item details) 

It will internally create a sub loop i.e, a table GT_SFLIGHT under the table SPFLI data. 

Step9: Select the fields which are not required to display and deactivate.

Step10: Double click table GT_SFLIGHT and go to the where conditions tab available in lower part of the window.

Create the where condition for the table loop.

This 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.

Click here to continue...