Open ODS Views – influence of 0CURRENCY/0UNIT mapping

Introduction

We have OpenODSView of type Facts having key figures like Amount in different currencies or quantities in different units.

There is special treatment to such data in openODSView

We know that if we have a key figure of type amount or quantity, we have to specify a reference field 0CURRENCY or 0UNIT in key figure properties. Also 0CURRENCY , 0UNIT should be a separate field in same OpenODSView under respective folders.

Create one such openODSView with some sample data from a table in HANA database.

Make sure to assign currency and unit as reference fields for amount and quantity respectively in your OpenODSView

Save and activate your openODSView

Create a query to check the data.

Now insert a new record in underlying HANA table with a currency which is not present in BW base tables (TCURC table) or any unit which is not present in BW (CUNI transaction code)

e.g. unit ‘STK’

Execute your query again.

What do you observe?

The query shows no data and error message is displayed No SID found for unit ‘STK’

To resolve this error, maintain the unit in BW.

To do this you have to call transaction SPRO and select the relevant customizing entry point.

After maintaining the currency, rerun the query.

Now the query shows data. 🙂

Note: To get date in proper format in report, you can associate date field in OpenODSView with 0CALDAY or 0DATE

Rerun the query-