Display Item table of every Header Table record in a New Page using Conditional Breaks
This article explains how to Display Item table in a New page for every Header Record in the Header table .
Here is an Example.
Go to Transaction code SFP(Form Builder).
Enter the Name of the Interface as shown below and click on Create button.
A pop up will be displayed. Enter the description and Interface Type .Click on Save.
Interface will be created as shown below. Create Invoice Number as Import Parameter.
Click on Save and Activate.
Create FORM ‘ZAF_BILLING_ITEM_DETAILS‘.
Assign Interface and Click on Save.
Get all the layout attributes(Fields.Tables…) into Context level from Interface level..
To display the Item table of each header record,
Create a loop between Header data table and Item data table as shown below.
Specify the Item table as shown below.
Under Conditions, enter the prerequisites that need to be met before the table is processed at run time
and displayed in the form.
Based on given where condition a loop will be triggered between Header data Item data at Run time.
Create the layout as shown below.
Set the Properties of Header and Item table Sub forms to act as a Table as shown below.
Material_Table(VBRP) Sub form Properties:
Material Number Sub form Properties:
Item table Sub form Properties:
Item Data Sub form Properties:
Click on Save , Activate and Execute.
Enter the Invoice Number and Execute.
Output will be displayed as shown below ..
To display the Second Header Record and its item table data on Next Page we need to add conditional breaks
Click on Material Number Sub form Which act as a Header Table.
Click on Add Icon. Select MATNR
Condition will be added as shown below. Select the Top of Next page as shown below.
Save ,Activate and Execute the Form Now each Item table will be displayed in a New Page.
Material Number 1 and its item table displayed in First page.
Material Number 2 and corresponding item table to started in Second Page.