Wednesday, February 9, 2011

Using Where conditions to relate header and item tables in Adobe forms

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.




Step11: Go to Layout: in data view a nested loop (table) will be displayed.

SFLIGHT under SPFLI. Create the boiler plate objects if needed.

Step12: Drag and drop all the fields under GT_SPFLI table into body page.

Note: Do not drag the entire table into body page. We need to follow creating table using sub forms concept.

Go to hierarchy view; Select all fields of spfli, Wrap the fields into sub form by right clicking.

Again wrap the sub form in to another sub form. Sub form properties are maintained latter.

Step13: Drag and drop the fields from sflight into body page and create sub forms as showed in below snap. Keep note that the subforms created for sflight fields should be place inside the spflidata subform.

Maintain names as spflitable
'-->spflidata
'-->sflighttable
---> Sflightdata

Step14: Content of body page should be flowed.

Step15: Maintain the subforms properties as showed in the below snaps.

Subform: spflitable

Subform: spflidata

Subform: sflighttable

Subform: sflightdata

Step16: Now your FORM is ready, check for syntax and activate it.

Execute the form and follow the below to get the data in hierarchy level. Header and its corresponding item details.

Output: Page1

Page2



No comments:

Tutorials on SAP-ABAP

Adobe Interactive Forms Tutorials

Business Server Pages (BSP)

Userexits/BADIs

Web Dynpro for ABAP (Step by step procedure for web dynpro,Tutorials on Web Dynpro,)

ALV Tutorials

Blog Archive

goodsites