Product Information
Simple extensibility of Data Sources for Output Forms in SAP S/4HANA Cloud
Back in the days, adjusting or extending forms was a time-consuming task which almost always involved ABAP development. However, in SAP S/4HANA Cloud the process of extending forms has become a lot easier with the help of in-app extensibility. So if you have a little knowledge of Data Sources and Adobe LiveCycle you are able to extend your organization’s forms yourself.
In this blog, we will add several standard fields to the standard Kanban Card (for example) by extending the underlaying Data Source.
Prerequisites
– Business roles: The table below contains all business roles required to execute the Kanban process (scope item 1E3).
Description |
Role |
Production Supervisor – Repetitive Manufacturing |
SAP_BR_PRODN_SUPERVISOR_RPTV |
Production Planner |
SAP_BR_PRODN_PLNR |
Production Planner – Lean Manufacturing |
SAP_BR_PRODN_PLNR_LEAN_MFG |
Production Operator – Repetitive Manufacturing |
SAP_BR_PRODN_OPTR_RPTV |
Production Operator – Lean Manufacturing |
SAP_BR_PRODN_OPTR_LEAN_MFG |
Warehouse Clerk |
SAP_BR_WAREHOUSE_CLERK |
Cost Accountant – Production |
SAP_BR_PRODN_ACCOUNTANT |
Administrator |
SAP_BR_ADMINISTRATOR |
Inventory Manager |
SAP_BR_INVENTORY_MANAGER |
Purchaser |
SAP_BR_PURCHASER |
Configuration Expert |
SAP_BR_BPC_EXPERT |
– Software: Adobe LiveCycle Designer is installed. It can be downloaded from the ‘Install Additional Software’ app.
Overview
1. Extend the Data Source
2. Adjust the Form Template
3. Upload the custom Form Template
4. Configure output determination
5. Result
1. Extend the Data Source
From the SAP Fiori Launchpad, open the app ‘Custom Fields and Logic’.
Figure 1: Custom Fields and Logic app
Next, open the tab Data Source Extensions and create a new Data Source Extensions by clicking the + icon.
Figure 2: Tab Data Source Extensions
Choose the Data Source ‘Manufacturing: Kanban Card Form’ from the drop-down list, give the new Data Source Extension a meaningful description and click on create.
Note: The Extension ID is automatically copied from the description but can also be maintained manually.
Figure 3: New Data Source Extension
Expand the field path to display all standard fields that are available to extend the Data Source. Choose the fields you want to display on the Kanban card. For this example the fields ‘Supplier’, ‘Supplier Name’ and ‘Control Cycle Category’ are chosen and become visible in the right pane.
Click ‘Save’ and subsequently ‘Publish’ to make the extended data source available for use.
Figure 4: Field Selection
2. Adjust the predelivered Form Template
Open the app Maintain Form Templates in the Output Management catalog. In the tab Predelivered Templates, search for the template ‘PP_KANBAN_CARD’. Click the download button for the language of your choosing.
Figure 5: Download Form Template
Extract the downloaded .zip file and open the .xdp file with the Adobe LiveCycle Designer. Here, you can drag-and-drop the fields you added to the Data Source in the previous steps onto the form template.
Figure 6: Adobe LiveCycle Designer
Go to File à Save as and save your custom template ‘YY1_PP_KANBAN_CARD_E_EXTENDED’.
3. Upload the custom Form Template
Once again, open the app Maintain Form Templates in the Output Management catalog and click New. In the next dialog screen you can add the details of the custom Form Template you just created. Click browse to upload the newly created .xdp file.
Figure 7: Create Form Template
4. Configure Output Determination
Go to the app Manage Your Solution in the Implementation Cockpit group and click Configure Your Solution next. Search for “Form template”, choose the Ouput Control configuration item.
Figure 8: Configure Output Determination
Copy the row for the Kanban application object and add your newly created Form Template.
Figure 9: Copy Application Object Type
The Kanban Form Template is now known in the system, bus has to be added to the control cycle which you are using. Therefor open the app Manage Kanban Control Cycle and open the Control Cycle of your liking. Choose the tab Print Control at the bottom of the screen and add your custom Form Template.
Figure 10: Kanban Control Cycle
5. Result
If we print the Kanbans for the control cycle chosen in the previous step we can see the result of the extension, the fields Supplier no, Supplier and Control Cycle are printed on the Kanban Card.
Old:
Figure 11: Old Kanban Card
New:
Figure 12: New Kanban Card
Links
– SAP Help
Great blog and easy to consume content, thanks
Thanks for sharing, very helpful!
Thanks Rick this is great information. I have a question on whether it is possible to utilize extensibility or an extended data source to dictate form assignment. For example, if we have a set of suppliers that we want to get a PO form with a unique set of terms and conditions vs our standard form terms and conditions. It would be great if we could leverage extensibility to change output determination/behavior.
Very useful MFG example, keep it going.
Very well wrriten. The steps can be easily replicated for other customers.
Very useful we are using the same extension principle - Data Source Extension - for manufacturing order pick list and order form, however we found out that some of the required fields are returning blank value, e.g. in the pick list despite having extended purchase requisition multiple times nothing shows up when we print the form. We are banging our heads on the possible cause.
Very well explained!
Hi Rick,
It could be observed from Figure 3, that the name of the Data Source is not a technical name and it is some description explaining the process.
When we try to enhance an existing form template, we get the technical name of the data source. How can we determine the data source from the description (first dropdown in Fig3) for the relevant technical data source name that we determine from the template.
Ex: I would like to enhance a standard invoice form whose template is SDBIL_CI_STANDARD_DE. From the template, it could be determined that the data source associated is FDP_V3_BD_STANDARD_SRV. But when we try to extend the data source using above method, I didn't find a suitable description for this data source. In such a case, how to determine the right data source.
Kindly enlighten us with further information. Also please let us know, if all the data sources provided by SAP could be extended or not.
Thanks & Regards,
Kiran
Great blog Rick! One additional point that is worth mentioning - the data source extension field cannot be seen in the PDF preview mode. To check if the extension is really working for sales orders; on the first screen of VA02, select menu path 'more' -> Sales Document -> Issue output to... Then select [Display document].