How to enrich SAP extracts 2. – adding new fields


Going back and forth between SAP and an external business intelligence tool  like Tableau to refine data extracts can be really painful if one does not have the same level of agility in both worlds.

Last time we have seen how easy it is to add text descriptions to code fields in SAP data sets with VirtDB’s Data Unfolder. Now, what if we needed a new SAP field in a Tableau dashboard? If you don’t like the idea of time traveling back to the 20th century and pay for ABAP development you can use Field Catalog Extension features of VirtDB instead.

Let us extend the frequently used SAP report VA05 (List of sales orders) with the customer material number.

VA05_report_fields

You can see that the required field (VBAP-KDMAT, the Customer Material) is not there in the standard Sales Orders report. (There is even a SAP Service Note (350068) on how to add it. SAP’s proposed solution includes ABAP coding and changing the data dictionary manually.)

With VirtDB you can remain ABAP-free and agile: go to the VirtDB menu / Field Catalog Extension menu item to bring up the list of fields available in the report.

VA05_report_VirtDB_menu

In order to add a new column and fill it from a database table, click the left top button over the Field Catalog and choose “Fields from DB”.

VA05_report_field_catalog_adddbfield

Now you have to enter which SAP table you want to add fields from.

VA05_report_field_catalog_tableselect

The next step is to select the field(s) you want to include in the report.

VA05_report_field_catalog_fieldselect

Finally, map the key field(s) of the selected table to the key field(s) of the base report. This will define an outer join on the new table, so if no entries were found for a line in the report, the new field will come empty but will not remove existing rows.

VA05_report_field_catalog_keymapping

Once finished, press Save and the report will be automatically extended with new data. This new field will become constantly visible for you and all other consumers of the VA05 report in the SAP system.

VA05_report_newfield_appeared

Not bad, with a few clicks we have extended our SAP data set with new information and no coding was required. With VirtDB even your business users can add new fields to reports, tables or whatever SAP data sets, send it directly to Tableau and start crunch immediately.

VA05_report_Tableau

If you want to know more or want to see it in action


2017-06-21T14:42:33+00:00 May 31st, 2016|0 Comments

About the Author:

Leave A Comment