Skip to Content
author's profile photo Former Member
Former Member

Embedded BI-Language Text: how/why does it work?

Our attempt to supply a Z-IOBJ with language dependent texts from a custom built HANA view fails. Hence we figured to use a BC object as a model, but cannot understand how it works.

Language dependent BC IOBJ /ERP/BUSAREA is sourced by HANA view: FCO_C_BUSINESS_AREA

As can be seen the view does NOT contain the language field SPRAS.

In the 'Maintain HANA-Assignments' of the IOBJ interface only the following two fields appear (as targets): '/ERP/BUSAREA' and '1TXTMD'.

The selectable HANA view fields (as sources) are: 'MANDT', 'GSBER' and 'GTEXT'.

NO mapping of a language field. Yet when I log in with English the text is in English and when I log on in another language the text is in that other language.

How is it possible that this works without a language field anywhere in the model???

Unbenannt.JPG (54.1 kB)
Unbenannt.JPG (47.7 kB)
Unbenannt.JPG (24.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 26, 2016 at 07:20 AM

    Ok, we don't see whether or not the TEXT JOIN is used here, but let's say it is.

    Then the SPRAS field gets evaluated against the current session language context setting.

    See here Text Joins - SAP HANA Modeling Guide for SAP HANA Web Workbench - SAP Library and SESSION_CONTEXT - SAP HANA SQL and System Views Reference - SAP Library.

    The relevant context variables are LOCALE and LOCALE_SAP (both set by the SAP Netweaver DB interface library).

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.