Skip to Content
Author's profile photo Troy Thurston
Troy Thurston
November 28, 2014 1 minute read

Table T006D for SHINE

The EPM sample data included with the SHINE demo application is a helpful resource for working on development and modeling scenarios.

Included in the sample data are supporting tables that are required to perform Unit of Measure and Currency conversions in analytic and calculation views, as stated in the SAP HANA Modeling Guide.

Image1.png

However, the sample data is missing table T006D.  Without this table, an error is generated when attempting a Unit of Measure conversion.

Image2.png

The attached file has the necessary SQL DDL and DML scripts to create and load a column table (and create a related synonym) for T006D.  The scripts can be executed from a SQL Console view in the SAP HANA Modeler perspective.

Image3.png

After refreshing the schema, T006D is displayed and can be referenced for Unit of Measure conversions.

Image4.png

Image6.png

(Note: T006D table structure and default data obtained from SAP BW 7.4 SP8.)

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      can i get the t006d file