Adding a picture (jpg, bmp, etc.) in Adobe format is a common business scenario. We may bind the necessary image using Image Field UI. However, today’s subject is distinct.
How can we merge an image to an existing Adobe PDF form??
However, how can we combine an image in Adobe’s preexisting formats? One of the members of our Telegram group recently inquired about the case’s solution and potential solutions. He needed the photographs saved in PO Generic Object Services (GOS) to be attached and shown with
the PO Output Form. When two picture files (usually in “.jpg” format) are saved at the Purchase Order, they should be
combined with the PO Output form and returned to the vendor. To put it briefly, the task was to combine the PDF PO Output Form with the image files in the GOS of the PO.
After some head scratching and cool thinking, the below two steps looked a good start:
Let us dig into the actual technicalities now.
1. Create an Adobe form ZPB_TEST_CONVERT_JPG, Interface ZPB_TEST_CONVERT_JPG with an import parameter as GV_CONTENT of type XSTRING.
2. In context of form, create a Graphics Node as follow:
3. Set the graphics node properties as follow:
4. Create an Image field UI in form layout and bind it with GRAPHICS node created in the context.
We are done with creation of 1st Adobe form in which any image from driver program can be uploaded as PDF and then it needs to be merged with any existing Adobe form.
Next, I have created another Adobe form ZPB_HIDE_TABLE_COLUMN with simple table display. Just create one adobe and hard code some table values. This will act like our 2nd PDF file which we want to merge.
5. Create a driver program with the below steps:
i. Call FP_JOB_OPEN
ii. Generate FM for 1st Adobe form:
iii. Upload an image file from local system.
iv. Convert Binary data into Raw data :
v. Call FM for 1st Adobe Form from step 1 and collect it’s Raw data into an internal table GT_PDF:
vi. Call 2nd Adobe form in which we want to merge the image as PDF and collect it’s Raw data in the internal table GT_PDF:
vii. Now, merge both the PDFs (1st Image, 2nd Adobe Form PDF) into one PDF.
viii. Close the form processing as:
ix. Now, you can generate the result merged PDF (GV_MERGE) from above step vii with the following code:
Testing Time:
Run the driver software. Save the combined PDF to your local computer after selecting an image file from your system (I liked the ELEARNING image):
I hope you are able to bring the solution home. As usual, this is the first and most straightforward approach that comes to mind, but there may be other ways to accomplish the same goal. Please feel free to leave a remark below if you have any other ideas. In this development, we did not do anything new. We just implemented what we have learnt and performed independently in other business requirements. knew how to convert the data to RAW. We knew how to create Adobe Forms. Knew how to get RAW data of the Adobe Forms. knew how to merge PDF files. What we did was just bringing together all this answers to one.
SAP Adobe Interactive. Part XVIII. How to Hide a Table Column Dynamically Using JavaScript?
We’ve recently been working on a real-world use case for Interactive SAP Adobe Forms. In this post, we demonstrated a real-world project situation in which we used Java Scripts
to hide/display a table column in a simple, hierarchical
business model.Essentially, we will show a practical example
of how to use Java script to conceal or display a certain
column in an Adobe forms table. It is a frequent demand and there
are numerous ways to fulfill it, and JavaScript is the
lucky choice for our project.
Business requirement:
Table Data Structure is as follow:
Requirement: At runtime,
When Product is “EDITION”, column Territory should be hidden
When Product is “RENDITION”, column ISBN should be hidden
The expected result should be as follows:
To further understand, let’s use a basic example rather than the layered table structure described before.
Create an Adobe form ZPB_HIDE_TABLE_COLUMN with an interface with import parameter as IV_PRODUCT and IT_DETAILS.
IV_PRODUCT : Product Type entered from driver program
IT_DETAILS : Detail table with following structure
2. In Adobe Layout, create a table from the data view using IT_DETAILS as follows:
Column Territory should be hidden if the user enters “E” as the product type. So, whenever each body row of the table is populated, we must read the product type IV_PRODUCT, and the corresponding column for the same data row should be hidden.
3. Write a driver application to invoke Adobe form functions, load test data into this table, and then pass the table into an FM that is generated by an Adobe form. The test data might look like this:
4. In the script editor, Write the below Java script code in initialization event of body row of table GT_DETAILS_SIMPLE as follow:
Let’s try to understand the highlighted script code.
Adobe’s XML Form Architecture, or XFA for short, is the foundational component of an XML file used by Adobe PDF. By providing its path as a parameter in the resolveNode method, we can gain access to a particular object in the hierarchy. The reference of the object supplied as an argument would be returned by this method, allowing us to utilize the relevant characteristics of that object.
We obtained the IV_PRODUCT context field reference in the highlighted script, and we used the rawValue property to obtain the product type value that the user had supplied in a local variable called product.
We attempted to set the visibility attribute (presence) of the corresponding columns to “hidden” based on the product value.
5. Test program creation and result of adobe form print-preview:
a. In the test driver software, create the selection parameter P_PROD that the user will supply to call the Adobe form.
b. Test the program and observe the result:
You can see that the Java script has successfully hidden the column value (Territory as Product type input as E) if you compare the above result with the actual test data from step 3. However, the column header “Territory” has not been deleted. As a result, every column has been moved one spot to the left, creating an incorrect PDF form.
How to correctly display the data?
Another Java script must be written for the table header row’s startup event since we also need to hide the matching column headers from the table header row.
6. In the script editor, Write the below Java script code in initialization event of header row of table GT_DETAILS_SIMPLE as follow:
The current object in which the event has been written will always be referenced. This would be in reference to “data.sbf_details.GT_DETAILS_simple.header” in the highlighted sentence above. Script code is built to set the presence property of territory and isbn texts because we wish to hide a particular field in the header.
txt_territory : Text field name in header in hierarchy for Territory column
txt_isbn : Text field name in header in hierarchy for ISBN column
7. Test the program and observe the form result in “Print-Preview”:
Two important observations if we compare the above result with actual test data in step 3:
Since the Territory column is fully hidden and the product entered is “E,
” we have met the criterion. Nevertheless, there has been a disturbance in the column width. The NET_UNITS field was not set as large as it seems in the following example. The ISBN column width has taken its place, and this also applies to any further columns that follow.
What would be the exact solution now?
We noticed that in addition to concealing a column field and header, we also need to dynamically modify the column width. This can be accomplished by writing Java Script code in one location, which will handle everything at once, as opposed to creating numerous Java Scripts on multiple objects (BodyRow, HeaderRow, Table Column Width changes).
8. After step 3, Follow this step and write the below Java script code in initialization event of table GT_DETAILS_SIMPLE as follow:
Explanation of above Script code is as follow:
var width = this.columnWidths – Return the whole string as set of all column’s width
var array = width.split(” “) – Split the width string by space, return an array with each column
array[2] = ‘”0.001mm” – Replace third column width with 0.001mm.
array.join(” “) – Concatenate all the array data sets and return a string.
9. Test program creation and result of adobe form print-preview same as step 5 above:
Now that the product entered is “E,” the Territory column is suppressed and all column widths are shown correctly.
However, the height of the column header is now automatically changed A “Text” UI’s layout properties cannot be changed dynamically, thus we must change its type to “Text Field” and double-check the outcomes.
10. Change the type of the Header columns to “Text Field” as follow:
a. Select column header and go to Object palattes:
b. Set the default column header text as follow:
c. Follow the above steps for all column headers.
11. Repeat step 9 and check the result in print-preview:
a. When Product = E
b. When Product = R
Conclusion:
Using Java Script code, we have now seen numerous methods for hiding or displaying a certain column in Table UI in Adobe forms. The most effective and straightforward method is to use Table’s Property
column Width. The aforementioned straightforward table use case allows us to apply the same guidelines to intricate corporate settings.
We will now learn how to handle a nested Table columns controlled by Java Script.
12. a. Extend the above Adobe form with new context created in form interface:
IT_NESTED : Detailed Product structure with Table type as follow:
b. Create a table from data view using IT_NESTED in Adobe layout as follow:
c. Set the PRODUCT_TYPE column in table IT_NESTED as invisible
We must now read the Product field for each DATA record in IT_NESTED and modify the columnWidth property of the DETAILS Table in order to conceal or display the matching columns in the details table.
13. Write the below Java script code in initialization event of table DETAILS as follow:
14. Check the result in print-preview:
As you can see, we can quickly accomplish complex business scenarios with just one Java Script code block. That is Adobe Forms’ Java Script’s strength. These days, SAP Adobe makes extensive use of JavaScript. JavaScript is crucial to SAPUI5. It’s imperative that ABAP engineers understand JavaScript for their career advancement. `
Interactive Adobe. Part XVII. How to Execute URL Dynamically by Button Click Event?
Numerous multiple times, we have a business prerequisites where we might want to have editable structure or fastens/check encloses the adobe structure which client can click and wanted activity ought to be executed. Now and then we additionally might want to communicate with SAP utilizing activities performed by intuitive structures.
These sorts of business prerequisites can be satisfied utilizing IFBA (SAP Intelligent Structures By Adobe). Or on the other hand essentially Intelligent Structure By Adobe.
IFBA can be used in 2 scenarios:
Offline
Online
Online situations are significantly utilized in Web Dynpro Applications where IFBA can be coordinated as UI component of web dynpro part.
Offiline situations can be perceived as IFBA utilizing email connection shipped off a client, client opens the pdf connection, top off the information in the structure and submit it.
Prerequisites:
Most significant essential is to empower intelligent highlights on Promotions. Naturally, printed Adobe structures can be made and worked upon however for IFBA, Adobe peruser privileges certifications ought to be arranged on Promotions. These peruser privileges would be given in “.pfx” record by SAP itself. Kindly go through the accompanying SAP Notes and solicitation your Premise group for this setup:
How to test configuration of SAP ADS?
You can always check if Adobe reader rights credentials are configured correctly by executing a test report provided by SAP: FP_TEST_IA_01.
In the event that adobe structure shows in the wake of executing above report, you can alter the structure and save then your SAP Adobe Advertisements design is turned out totally great.
Information on making Adobe shapes and prearranging.
Fundamental information on ABAP.
Business requirement:
In Receipt Structure, a button for installment connect page ought to be accessible so clients with substantial email locations can get the receipt on their letter drop and can pay the due sum utilizing that button.
Solution:
We will make a basic Adobe Structure with some text fields and a button. In structure interface, we will make an import boundary IV_URL. From driver program, we can give the URL data and utilizing JavaScript, we can peruse this URL in Structure and predicament to Fasten click activity.
Step 1 – Create an Adobe Form and the corresponding Interface
Create an Adobe form ZPB_DISPLAY_DYNAMIC_URL and interface with import parameter IV_URL as follow:
Step 2 – Design your form as per the requirement
For our case, we are making a straightforward text for guidelines and a button for installment as observe:
Now, we need to provide the URL which should be executed as soon as payment button is clicked.
In the event that we have a static URL (for example organization site), we don’t have to pass it from driver program/structure interface. We can straightforwardly deal with it in the Adobe Structure itself. Simply change the “Control Type” quality of Button object to “Submit” and give the URL there.
Step 3 – Choose the Button Control Type as Submit
Select button “btn_payment” from Hierarchy. Go to toolbar, select Palettes and select Object -> Control Type -> Submit.
Step 4 – Assign the URL to Button
Select “Submit” tab in Object palates and provide the static URL:
Step 5 – Test the Button with URL Hyperlink
To test the usefulness, go to “Review PDF” and click on Installment Button:
You can see the result as below:
That is very simple with next to no ABAP code and Java Content code. In any case, life isn’t that simple in genuine undertakings. Recall our business prerequisite?
We need to pass this URL powerfully from driver program. URL for each and every other client would be unique and not entirely set in stone at run-time. All in all, the installment connect URL would be produced distinctively for each request. So it’s a precarious part and indeed, Java Contents can assist us with accomplishing it.
Step 6 – Go to Script Editor of Adobe
Select button and go to script editor (I think with my previous blog, you must know how to access script editor in Adobe forms. If not, please refer that for better understanding about scripting in Adobe forms )
Step 7 – Write JavaScripts code on Click Event
We have to write our script on “Click” event of button. Select “Click” event from available events drop down:
Did you notice? “Click” event is disabled and can’t be selected for this payment button.
Reason: Since we chose Control Kind of button as “Submit”, framework would expect the activity statically and that is the reason “click” occasion is crippled.
To empower it, we want to change the Control Kind of button as “Customary”.
Step 8 – Change the Button Control Type to Regular
Go to object palates of payment button and select control type “Regular”.
Repeat step 7 and try to select “edit” event, it will be available this time.
Step 9 – Insert the JavaScript code
Select “click” event for button “btn_payment”, language as formcalc and run at client.
Write the below JavaScript code in script editor:
var valueUrl = xfa.resolveNode("$record.IV_URL").value;
xfa.host.gotoURL(valueUrl);
We are done with Form development. Now, another tricky part is passing control parameters for interactive forms.
Step 10 – Call Adobe Form from Driver Program
Make a driver program and call all the Structure handling FMs with required control boundaries and create the result.
Assuming you see intently, there is NO interactive feature enabled on button and it wouldn’t permit tapping on button. What might be the issue then? We previously checked Promotions arrangement in essentials area and its turned out great.
Reason:
There is a banner in structure boundaries structure SFPDOCPARAMS called Usable.
As a matter of course it’s clear so adobe structures are shown as a print structure naturally.
On the off chance that we believe that structure should have intelligent highlights, this banner ought to be set.
Step 11 – Set the FILLABLE Form Parameter to ‘X’
Set the form parameter before calling Form Function Module as follow :
Step 12 – Re-test the driver program
Now execute the driver program again and check the output.
If you check the highlighted section on button, you can see a cursor and button is enabled to be clicked. Here we go and get the access to URL which was passed from driver program:
This is an actual real project development. I have used this option in my project where we are sending invoices with due amount to our digital customers. For each invoice, payment landing page URL is generated dynamically so that when customers will click on payment button, they just need to enter their Credit Card details and payment will be captured against that invoice.
A sample of the invoice with payment button sent to customers is as follow:
In my next blog, I will share a business situation in intuitive Adobe structures where end clients can top off subtleties in an editable structure and submit it to Drain information base tables. All in all, you are playing out a Muck activity in SAP from an Adobe Structure. Along these lines, kindly stay tuned.
SAP Adobe Form Tutorial. Part XVI. Practical Use Case of FormCalc and JavaScript
In this article, we would exhibit the utilization of Aggregate in FormCalc and afterward progressively change text style involving JavaScript in SAP Adobe structures
The fundamental benefit of utilizing prearranging is that we can further develop usefulness and can oversee structures at runtime powerfully.
SAP Adobe form supports 2 scripting languages:
FormCalc
JavaScript
Both prearranging dialects are having advantages and hindrances, so we can conclude in view of our necessities which prearranging language to be utilized. In this blog, we will give not many normal business situations from both the prearranged dialects.
If it’s not too much trouble, note that we have previously distributed an article on the utilization of JavaScript in Adobe Structure. You might allude to it for greater lucidity.
Additionally Read: Powerfully Stow away and Show Fields involving Javascript in Adobe Structure In view of Conditions
Requirements:
Fundamental information on SAP Adobe structure with Tables Essential comprehension of JavaScript and FormCalc capabilities ABAP programming abilities Business Requirements:
In the definite explanation shipped off clients, we might want to show aggregate sum and absolute units as subtotal at the end of all details.
In the depiction segment of an assertion, we might want to show header results of the order as striking and in various style so that recognizing the header item in the entire statement is simple. Solution: We would have to make an Adobe structure and point of interaction with worldwide information. We will add some test information in these worldwide information interior tables in interface “code instatement” and later tie these worldwide interior tables with UI tables in Adobe Structure format.
P.S. We could likewise accomplish this by composing handling rationale in the driver program and passing the necessary interior table as import boundaries of the Adobe structure. Since this blog is more on utilization of contents, we have not considered the best methodology for information handling.
Step-by-step process
Make a structure interface ZPB_TEST_SCRIPTS utilizing T-Code SFP
Make Worldwide Information for Subtleties and depictions inside table
Structure for Depiction
Structure for Subtleties
Go to code instatement and fill test information in inner tables as follows:
Drag Worldwide information of connection point from passed on side board to Setting of structure in right side board
Presently Go to Design of Adobe structure and make table utilizing these setting information planned with Worldwide factors in interface. Kindly follow the underneath steps :
a. Go to Information View Ranges from toolbar
b. Select GT_DETAILS table as featured and drop on Detail page of structure design
c. You would see a table made and naturally binded with GT_DETAILS.
d. Make a footer column for “Subtotal.”. For that, go to Order Ranges, Grow GT_DETAILS Table, and make another column after Information. Go to Protest Ranges for the new column ( DATA[1] )and change the line type to “Footer.”.
Kindly note that assuming we will make a table component utilizing a table collaborator , a footer will be made accordingly. Since I went through information view ranges, I needed to physically make a footer.
Presently, we will do the intriguing step. Compose Formcalc Content to ascertain aggregate for all details.
Select text field in footer under NET_UNITS and go to arrange supervisor
Presently, go to the Show Occasions drop-down, and you will find all occasions are turned grayed out. WHY?
This is on the grounds that for few UI fields, prearranging isn’t permitted, and that is the reason every one of the occasions are in show mode as it were. To empower the occasions and compose the content rationale, we really want to change the kind of UI component from “text” to “text field.”.
Check the beneath picture. At the point when the Sort is Text, the Show occasions are turned grayed out.
At the point when we transformed it to Text Field, every one of the occasions got empowered.
Change the UI type for NET UNITS and Absolute Eminences fields in Footer line as “Text Field”
You can see that for featured fields above, line variety has been changed to red, and for different fields, it stayed blue. It is a marker to recognize text UI or textField UI.
Presently, rehash stages 8 and 9 for choosing a suitable occasion to compose a prearranged rationale.
Do you recall our business necessity? We might want to compute the amount of all the details and show it in the footer line as a subtotal.
Select Ascertain occasion from the all occasions dropdown , lang. as Formcalc, and compose the underneath code :
Presently, make a test pilot program to produce the outcome pdf ( if it’s not too much trouble, allude the past web journals to make a driver program for testing Adobe structures ) and create a pdf with subtotal :
By utilizing only a solitary Total capability and with next to no ABAP rationale, we can compute the all out of details in a table in Adobe structures and print likewise utilizing FormCalc prearranging.
There are additionally different capabilities accessible in FormCalc like Normal, Rate and so on
Time to mess with some JS (JavaScript) coding in script manager
Kindly recurrent stage 7 from a-c and make one more table for portrayal utilizing setting table GT_DESCRIPTION from information view.
Recollect another business necessity? We really want to set header Item in the portrayal field as Striking and with various text style and things as italic in view of Strong/ITALIC settings at runtime.
Select Information line of GT_DESCRIPTION table from Order and go to prearrange manager.
Select “structure : prepared” occasion , language as “javascript,” and compose the underneath code :
Run the driver program made in sync 12 and actually take a look at the outcomes:
For text to be changed in italic in view of the italic banner, rehash ventures from stage 15 :
Select “structure : prepared” occasion , language as “javascript,” and compose the below code :
Result from Driver Program:
Result
This article was to give genuine case models that engineers can imitate in their SAP scene. Subsequent to going this instructional exercise, anybody can evaluate in their own framework and utilize Java scripts and FormCalc prearranging dialects in Adobe structures. In the event that you actually face an issue, kindly go ahead and compose your inquiries in the remarks segment underneath or reach us straightforwardly at
Assuming you think our page is useful, remember to impart our connections to your companions, partners and colleagues. Do like our facebook page and follow us at twitter and instagram. Kindly buy into our youtube feed with the expectation of complimentary start to finish video courses.
SAP Adobe Form How to make the TextField Caption Background Color Different?
When my senior ABAP tutor told me, “If you know R and F of RICEF, you would survive in the SAP world,” I realized the importance of mastering these elements. Regardless of a client’s business needs, they will always require reports for consolidation and analysis of transactions. Additionally, they need to print statements and forms for legal and documentation purposes. Thus, reports and forms hold significant value in SAP. In this context, we present “SAP Adobe Form Tutorial Part XV Different Background Color for Label and Content Text,” where we explore techniques for customizing Adobe Forms to enhance their appearance and functionality.
He needed his result like beneath.
My most memorable response was – Who cares here? Be that as it may, when I attempted to find the response, I was unable to make the foundation tone unique. Furthermore, of late, I have been chipping away at SAP Adobe broadly. That was the incongruity.
Presently I needed the answer for myself, it was auxiliary to help the part. Thus, I began to dig all the more genuinely and got to the arrangement.
Here you go.
Step 1 – Go to Border Tab in the Layout Palette, look for Background Fill at the bottom.
Pick the Style as Strong. What’s more, pick a variety you want. We have picked Red for our prerequisite.
This will make both the Label and the Content area of the Text Field Red as shown above.
Step 2 – Go to Object Tab -> Field ->Appearance -> Custom.
Please note choosing Custom Appearance is the trick.
Step 3 – When you select Custom Appearance, a spring up window would come.
Step 4 – We really want to choose the White Foundation for the Text Content as displayed underneath.
So presently we have filled two distinct tones for the Foundation. Red for the Mark and White for the genuine Substance.
So the two foundation tones are unique.
Opps, you still have Red border on the Content Area!! You do not want it to be Red.
Step 5 – Go to Layout -> Margins and make them 0.
When we set the margin to 0, the red lines vanish. Presently we have met our objective of having the Name foundation not quite the same as the Message (content) foundation.
Really look at the Review PDF to affirm our finding.
This was one of the simplest requirements for us, yet it wasn’t as straightforward as it seemed. When you encounter “SAP Adobe Form Tutorial Part XV Different Background Color for Label and Content Text“ for the first time, it may seem complex, but once you understand it, it becomes quite simple.
Enter the Point of interaction and press on Make (Interface is mandatory for Adobe form)SAP
The portrayal, and press Enter.
Enter the bundle name and save. Beneath Screen shows up.
Press the Make button to add a bringing-in boundary.
Add IV_AUFNR, which is of type AUFNR, and really take a look at the discretionary banner. Check, Save, and Actuate the Structure Connection point.
Back. The structure name and press the Make button.
Enter the portrayal and point of interaction name that we made before.
Enter the bundle name and save. Following screen shows up.
Open the import boundary and simplify the expected variable to Setting.
Then press the Design Tab. The accompanying screen shows up.
Intuitive the field that you needed to print on the structure to the configuration view. You can put this field anywhere in the format.
There will be a toolbar with the name Object Library. If you are not able to find it, go to Palettes -> Object Library.
In the Toolbar, search for Barcodes choice. Grow it.
The following are the various sorts of standardized tags. Generally, we use Code 128C, yet it can change in view of the nation and prerequisite.
Simplified the Code 128C Standardized Identification to your Format.
Go to Data Binding and bind the order number: IV_AUFNR.
Place a heading (text) on the top (not required): BARCODE GENERATION EXAMPLE
Check, save, and enact the structure. We are finished putting the scanner tag and restricting it to an information source. It is just straightforward. Isn’t it?
Testing Adobe Form Stand-Alone:
To see yield for test reason. Go to SFP and give your structure name. Press F8 and give a worth to bringing in boundaries, very much as you accomplish for capability module and see the result.
Enter the IV_AUFNR (Request Number). Execute (F8). Press the print review button and see the result.
Check the scanner tag closely. It has the same number as the request number. Your machine can easily recognize it. For a more detailed guide, refer to “SAP Adobe Form Tutorial. Part XIV, How to Generate Barcode in Adobe,“ where we explain how to position tables side by side in your Adobe forms.
Displaying two tables side by side on a SAP Adobe Form is a common requirement, but many of us find it challenging to achieve on the first try. If you search for a solution using keywords such as “SAP Adobe Form Tutorial Part XIII How to Print two Tables Adjacent to each other“ or “Data Overflow Issue in Sub Forms Tables in SAP Adobe Forms,” you will find the following links as the top few search results.
Situation 1 asked by one Client
I have a form with a body page and two tables. The body page’s property is set to ‘Streamed’ with ‘through and through’ as the stream direction, and the checkbox for page break is enabled. In “SAP Adobe Form Tutorial Part XIII How to Print two Tables Adjacent to each other“, we will explore how to configure the form to print these two tables side by side on the same page.
Necessity
The two tables should be printed nearby one another.
Approach followed until now
Since the body page is ‘Streamed’ type, the two tables are set one underneath the other (Tab1 and Tab2). So I attempted to set the Stream bearing of the Body page to ‘Western text’. In any case, this didn’t address the issue as since it is set to ‘western text’, solely after Tab1 is delivered, table Tab2 begins printing itself, which isn’t wanted. Both the tables ought to be printed simultaneously.
I enclosed both the tables by one sub form with ‘Type’ set to ‘Situated’ and set the checkbox for the page break. Presently I organized the tables nearby one another. However, the checkbox for page break for both the tables was handicapped and along these lines in the event that there isn’t adequate room to print the all out records of both the tables, the total tables are moved to another page leaving the past page clear.
Similar Scenario asked by another User
“I generally disapprove of 2 tables lying next to each other – say Table An on the left and Table B on the right. At the point when Table B has a flood of information in the following page. Then the overflown dataset lines of Table B goes to the left on the following page rather than its segment head for example .right of Table A. This happens just when table B is spilling over and Table An on the left excess on Page 1.”
On the off chance that you didn’t comprehend the issue situation, then, at that point, the under two pictures ought to help. Keep an eye on page 2, the right-hand side table is spilling over to page 2 from page 1, yet it has moved to the left as opposed to remaining on the right side.
Trust you figure out the situation now.
There are numerous ideas to accomplish this. Some said to connect every one of the inward tables to one major inside table to be shown. It would work, however that is super unwieldy assuming you have numerous tables.
The other most normal viable arrangement gave is to placed the tables in two different SubForms, make them Streamed with page break and print them together. Allow us to do likewise.
We are not telling you the best way to make the tables and SubForm. We accept, you know it so we are simply showing the Connection point and Structure settings and codes.
Adobe Form Interface
TYPES
Global Data
Code Initialization
Form Routines
The Form is designed as below.
Two SubForms LHS and RHS are enclosed by one SubForm LHSandRHS. MARA_Table SubForm and MARC_Table SubForm are wrapped inside LHS SubForm. Likewise, EKPO_Table SubForm is wrapped inside RSH SubForm.
The following is the extended perspective on all the Ordered progression Items.
All the SubForms are Items are Streamed with Stream Course Western Text.
Additionally, remember to make the Page DetailBody Content as Streamed and Permit Page Breaks with Content.
We wrote the below Driver Program to test our form.
***---------------------------------------------------------------------* *** Date :19/03/2025 * *** Author :Varad(www.elearningsolutions.co.in) * *** Title :Demo Printing of Tables Side by Side in Adobe with * *** Overflow to next page * ***---------------------------------------------------------------------* REPORT ELEARNING.
PARAMETERS: p_rowl TYPE i, " Number of Rows p_rowr TYPE i. " Number of Rows
CONSTANTS : gv_form_name TYPE fpname VALUE 'ELEARNING'. **&&~~ Data Objects DATA: gv_fm_name TYPE rs38l_fnam, " FM Name gs_fp_docparams TYPE sfpdocparams, gs_fp_outputparams TYPE sfpoutputparams.
*&---------------------------------------------------------------------* **&&~~ Form Processing: Call Form - Open * CALL FUNCTION 'FP_JOB_OPEN' CHANGING ie_outputparams = gs_fp_outputparams EXCEPTIONS cancel = 1 usage_error = 2 system_error = 3 internal_error = 4 OTHERS = 5. IF sy-subrc <> 0. " Suitable Error Handling ENDIF. *&---------------------------------------------------------------------* **&&~~ Get the Function module name based on Form Name * CALL FUNCTION 'FP_FUNCTION_MODULE_NAME' EXPORTING i_name = gv_form_name IMPORTING e_funcname = gv_fm_name. IF sy-subrc <> 0. " Suitable Error Handling ENDIF. *&---------------------------------------------------------------------* **&&~~ Take the FM name by executing the form - by using Pattern- **&&~~ call that FM and replace the FM Name by gv_fm_name * **&&~~ Call the Generated FM CALL FUNCTION gv_fm_name "'/1BCDWB/SM00000176' EXPORTING /1bcdwb/docparams = gs_fp_docparams v_row_r = p_rowr v_row_l = p_rowl EXCEPTIONS usage_error = 1 system_error = 2 internal_error = 3 OTHERS = 4. IF sy-subrc <> 0.
* Implement suitable error handling here ENDIF. *&---------------------------------------------------------------------* **&&~~ Form Processing: Call Form - Open * CALL FUNCTION 'FP_JOB_CLOSE' * IMPORTING * E_RESULT = EXCEPTIONS usage_error = 1 system_error = 2 internal_error = 3 OTHERS = 4. IF sy-subrc <> 0. * Implement suitable error handling here ENDIF.
We should test it. To keep the left side table inside the principal page, we give a lower number to choose on the determination screen. Whilright-handt hand side table we pull more columns to drive it to spill over to the following page.
The main page looks great. The left hand side quits developing while the right hand side develops to next page.
However, look, on the following page the right hand side has been moved to the left side. This isn’t the very thing that our end clients need. The Purch Doc segment ought to be lined up with the section from the principal page.
Where did it go wrong? Allow us to check the design and settings once more.
We have set the Subform Content as Streamed for Detail, LeftHandSide (LHS), RHS and all SubForms are Streamed. In any case, the design in the subsequent page is moved to left. We attempted to adjust the Stream Course Through and through to Western Text. Be that as it may, it didn’t help.
So we were constrained to attempt an alternate methodology. We will probably make a table with 1 line and 2 segments i.e it would have just 2 cells. Line 1 Segment 1 would have every one of the LHS subforms (2 tables mara and marc information) and Row1 Section 2 would have every one of the RHS subforms (1 table with ekpo information).
We want to wrap the two cells into subform and make them Streamed.
The following is a table with 2 cells and in every cell we would put subforms for our information.
We ought to get it going. Permit us first to make a Table with one Line and two Segments.
We have renamed the table to TwoColTables. Allow us to rename Cell1 to LHS and Cell2 to RHS.
Presently right snap on Cell1 and Enclose by SubForm. Wrap Cell2 to SubForm as well.
Subsequent to wrapping and renaming, it would look like beneath.
Erase the texts LHS and RHS.
Presently drag LHS from SubformToHold2SubForms above and put into this LHS in the Row1 of the table.
Comparatively drag RHS from SubformToHold2SubForms above and put into this RHS in the Row1 of the table.
On the other hand, you can make these subforms in the LHS and RHS cell new. Yet, we are sluggish and we need to utilize what we did before.
It ought to look like beneath.
You want to have all the SubForms as Streamed expect the two Cells which were wrapped as SubForms. They should be Situated.
Positioned SubForm Cell 1 (LHS)
Positioned SubForm Cell 2 (RHS)
This is the stunt of this post. All streamed aside from the two cells which must be Situated. The two cells Content must be set as Situated in light of the fact that you would rather not permit the cells to move around openly. The width (and beginning x,y organizes) of the cells are fixed to the position you set. So when any one cell spills over to the following page, it actually is on a similar arrangement as at the main page.
How about we test now. Run the Print Program
Your table currently is streaming accurately. In the event that your left side table or right side table don’t begin from a similar level of the page or position (Y Coordinate), then, at that point, you should make them 0, 0 in the Design or some other worth you need. So both the tables start from a similar position and stream down.
I trust you found this tutorial helpful. The issue of printing two tables adjacent to each other is quite common, and the solution is also relatively straightforward. For a detailed guide on “SAP Adobe Form Tutorial Part XIII How to Print two Tables Adjacent to each other,” stay tuned as we explore this topic further.
One fine morning, your business comes to you and pleasantly suggests, “Adobe Forms are cool. We should convert our Smartforms to Adobe.” You might be unsure how to respond. Indeed, converting existing Smartforms to Adobe Forms could require significant time and effort. In SAP Adobe Form Tutorial Part XII How to Convert Smartform to Adobe Form?, we will guide you through the process of making this transition smoothly. We recommend giving it a go and exploring the benefits of Adobe Forms!
SAP has forever been ground-breaking and in reverse viable. In a similar line of reasoning, they have given a choice to switch Smartforms over completely to Adobe for certain snaps. Allow us to check. How?
Allow us first to create a basic Smartform.
Exchange: SMARTFORMS
Press the Create button
Add a Boundary in Structure Connection point
IT_VBAK TYPE VBAK_T
Add one more boundary in Worldwide Definitions
Make text under Fundamental Window in %PAGE1
WA_VBAK TYPE VBAK
Make a table under Fundamental Window
Double tap on %TABLE1
Go to the Information Tab and keep up with the Interior Table (IT_VBAK) and Work Area (WA_VBAK) Subtles.
Then, at that point, Go to Table Tab, and change line type to 2 sections.
Right Click on Header -> Create -> Table Line
Select Line Type %LTYPE1
Keep up with the Header in 2 cells by making the Messages
Right Snap on Principal Region – > Make – > Table Line
Select Line Type %LTYPE1
Keep up with the 2 factors by under the Cells Deals request (VBELN) And Deals Association (VKORG)
Check, Save, Initiate.
We are finished with making the Smartform.
Can we test now?
Yes. For this situation, we are not utilizing any driver programs. We will test remain solitary.
From the smartform screen, press the Execute (F8) button. Again, you press the Execute (F8) button. All things considered, smartform is saved as a capability module in SAP.
Enter a few information into IT_VBAK table
Press on Supplement Information button.
Then press the Execute button, select some neighborhood printer, and press Print Review.
You see a basic smartform yield.
Go to SMARTFORMS Exchange. Give your smartform name.
Go to Utilities -> Migration -> Interactive Form -> Export
Enter the necessary Adobe Structure name and press Enter.
Enter.
Select all the necessary really look at boxes
Enter. Save as a Nearby Item ($TMP) or in transport on the off chance that you have.
Presently Go to Exchange SFP
Initiate the Connection point.
Return.
Give the Adobe Structure name YRAM_ADOBE_FORM and press the Change button.
Go to Setting. Check a setting in Adobe Setting region is now replicated.
Go to Design and see the format that is duplicated from Smartform.
Check, Save, and Enact.
Presently, we can test the Adobe frame? Indeed, physically once more!!
Enter the information into IT_VBAK
.
You have just switched a Smartform over to a rich Adobe Form. I trust you find this process valuable. For more detailed instructions, refer to “SAP Adobe Form Tutorial Part XII How to Convert Smartform to Adobe Form?“ where we cover the steps and best practices for this conversion.
After more than 10 articles on SAP Adobe Form, we had to make room for this basic topic. Configuring Adobe Forms overlaps with the steps done in Smartforms and SAPScripts. But, still, we thought it would be helpful if we dedicated a short article to cover the concept here.
On a high level, we need to configure the forms in t-codes NACE, OPK8, and SPRO based on the modules you are working for.
NACE
Go to Transaction code NACE. You would find the list of all the applications in SAP.
Select the application area where you wanted to configure your Adobe Form and the Driver Program.
For example select V1 for Sales and press on Output types.
Here you can find all the output types which are related to Sales.
Select the relevant output type and press on processing routines.
Go to change mode and add your Adobe Form name beside to PDF/Smartform Form. Do not forget to change the Form type to “PDF”.
Save the change.
OPK8
If you want to configure PP or PM module related forms you need to do it in the OPK8 transaction.
Go to Transaction OPK8.
Select one of the Output Types and press on Forms.
Here you can Configure your Adobe Form.
Hit Save. You are done with the process of Configuring the Adobe Form in OPK8 Transaction.
SPRO
You can configure the QM (Quality Management) Forms in SPRO Setting. Go to transaction SPRO
Press button “SAP Reference IMG”.
Navigate list as follows
SAP Customizing Implementation Guide
Quality Management
Quality Notifications
Notification Processing
Print control
Define Shop Papers, Forms, Print Programs
Double click on Define shop papers.
Enter any application area.
Hit Enter. You can configure under the Name of the PDF-Based From.
You just completed the SPRO Configuration of Adobe Forms for Quality Management area.
Uncertainties and “buts” are an integral part of life, and Adobe Forms are no exception. You often encounter real-life scenarios where printing depends on specific conditions. In such cases, “SAP Adobe Form Tutorial Part X Alternative in Adobe Forms“ explores a feature called “Alternative” that allows you to print data conditionally based on the requirements.
Transaction Code: SFP.
Enter the connection point name and make (the connection point is compulsory for Adobe structure).
Enter the necessary short portrayal and save.
Enter the bundle name and save.
Allow us to add our own custom boundary name. Select the Import choice under the Structure Connection point (left side) and press the Make button (right side) to add a bringing-in boundary.
FLAG is for alternative. TEXT1 and TEXT2 are for printing the texts.
Save, Check, and Actuate the Connection Point.
Go to the back SFP Exchange fundamental screen. Make the structure.
Press the make button. Give the short portrayal and connection point name that you have made before.
Enter the bundle name and save.
Drag Banner, TEXT1, and TEXT2 from Point of Interaction to Setting.
Go to setting. Right-click on the YRAM_ADOBE_FORM10 under the unique circumstance and make an alternative.
Alternative:
Alternative is the option that we use for conditional printing with TRUE / FALSE option.
When it is TRUE, it will print the details, which are specified under TRUE and vice versa.
Simplified the TEXT1 under the Genuine Condition and the TEXT2 to Bogus Condition.
Make a condition for elective. Press on Alternative Conditions button.
Add a condition: FLAG = ‘X’
That’s what it intends – when you pass ‘X’ it is Valid, when Space it is Misleading.
Go to Design. Simplified the TEXT1 and TEXT2 to the design.
Save and enact the structure.
Allow us to construct the Driver program
*&---------------------------------------------------------------------* *======================================================================* * YRAM_ADOBE_FORM_PROGRAM8 * *======================================================================* * Project : SAP Adobe Forms Tutorial * * Author : varad (www.elearningsolutions.co.in) * * Description : Using Alternative in Adobe form * *======================================================================* REPORT yram_adobe_form_program10.
*======================================================================* * Selection Screen *======================================================================* PARAMETERS : p_flag TYPE char1. *======================================================================* * Data Objects *======================================================================*
DATA: gv_fm_name TYPE rs38l_fnam, " FM Name gs_fp_docparams TYPE sfpdocparams, gs_fp_outputparams TYPE sfpoutputparams, gv_text1 type char255, gv_text2 type char255.
*======================================================================* * Constants *======================================================================* CONSTANTS : gv_form_name TYPE fpname VALUE 'YRAM_ADOBE_FORM10'.
gv_text1 = 'Welcome to Adobe form tutorial'. gv_text2 = 'Welcome to SAP ABAP'. *======================================================================* * START of Calling the Form *======================================================================* *&---------------------------------------------------------------------* **&&~~ Form Processing: Call Form - Open * CALL FUNCTION 'FP_JOB_OPEN' CHANGING ie_outputparams = gs_fp_outputparams EXCEPTIONS cancel = 1 usage_error = 2 system_error = 3 internal_error = 4 OTHERS = 5. IF sy-subrc <> 0. " Suitable Error Handling ENDIF. *&---------------------------------------------------------------------* **&&~~ Get the Function module name based on Form Name * CALL FUNCTION 'FP_FUNCTION_MODULE_NAME' EXPORTING i_name = gv_form_name IMPORTING e_funcname = gv_fm_name. IF sy-subrc <> 0. " Suitable Error Handling ENDIF. *&---------------------------------------------------------------------* **&&~~ Take the FM name by execuing the form - by using Pattern- **&&~~ call that FM and replace the FM Name by gv_fm_name **&&~~ Call the Generated FM
*&---------------------------------------------------------------------* *&---- Close the spool job CALL FUNCTION 'FP_JOB_CLOSE' EXCEPTIONS usage_error = 1 system_error = 2 internal_error = 3 OTHERS = 4. IF sy-subrc <> 0. * <error handling> ENDIF.
Allow us to execute this structure and see the result.
Test 1 : Execute program YRAM_ADOBE_FORM_PROGRAM10 to test TRUE Alternative.
Pass ‘X’
Execute. Press on Print see
Test 2 : Execute program YRAM_ADOBE_FORM_PROGRAM10 to test FALSE Alternative
Pass no worth.
Execute. Press on Print see.
Trust this post was clear enough for you to comprehend. A legitimate showcase is something which we really want in each elective structures. It tends to be taken care of in more than one way however when SAP has given a shrewd Elective why not use it.
We put a lot of effort into conceptualizing, testing, and writing each article. If you could share this link with at least 5 colleagues or friends who might benefit from our post, it would be a great support to our team. We believe our articles, including “SAP Adobe Form Tutorial Part X Alternative in Adobe Forms,” should reach as many audiences as possible so that everyone can benefit and our team remains motivated, ensuring our work does not get lost in the vast expanse of the web.
Thank you kindly for visiting. Kindly leave your remarks/praises, great and no so great so we can continue to improve and giving you quality stuff.
