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:
Binding:
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.
I need a help from you, I haev nested table and based on the index change of first table there is a page break now the requirement is if there is page break then page number shoulf reset say for first iteration it has 2 pages then it will print as 1 of 2 2 of 2, after page break say there are 3 pages then 1 of 3 2 of 3 3of 3 like,,,i m not able to find solution for this..could you pls hel me
Hi All,
Please help me in achieving my requirement.
I have header data in which if there is a change in one of the field's data of the header, i need to populate corresponding item data, i.e a conditional page break. The example that is shown above is not helping me great, as my header data is not in a table, wherein if i give the sub form as flowed and western text, the position of the text fields is getting changed ( which shouldn't be the case ). In the above, the Sub forms are in flowed and western text. This is not working for me 🙁 . Kindly do suggest me the needful.