Thursday, 8 June 2017

Text join using pa0000 table in hana

I am sharing you concept called text join in HANA, which we mainly use to extract descriptive data from a table or language specific data from a table.

Text Join is used in order to get language-specific data.

Text Join is used to fetch the description based on user’s session language. Once we implement the text join in SAP HANA, it automatically find out user’s language and give description in that language.
Requirement: change text column in PA0000 table from english language to German language using text join concept, using graphical calculation view,

First create one calculation view in your package and add table PA0000(HR Master Record), T529U(Value Table) AND T002(Language Key)  in three different projection

as following

SAP HANA Tutorials and Materials, SAP HANA Certifications

now add these columns in output from these three projections

SAP HANA Tutorials and Materials, SAP HANA Certifications

SAP HANA Tutorials and Materials, SAP HANA Certifications

SAP HANA Tutorials and Materials, SAP HANA Certifications

Join projection1 and projection 2 as following

Give join between STATN and STAT2 as text join and make sure that language column should be SPRSL

SAP HANA Tutorials and Materials, SAP HANA Certifications

SAP HANA Tutorials and Materials, SAP HANA Certifications
And projection2 and projection3 as following

Give join between SPRAS and TEXT1 as text join and make sure that language column should be SPRAS

SAP HANA Tutorials and Materials, SAP HANA Certifications

SAP HANA Tutorials and Materials, SAP HANA Certifications
Now map all respective column of two joins with the help of union

SAP HANA Tutorials and Materials, SAP HANA Certifications

SAP HANA Tutorials and Materials, SAP HANA Certifications
Add these column in output in top projection below semantics

SAP HANA Tutorials and Materials, SAP HANA Certifications

This is complete calculation view objects for your help

SAP HANA Tutorials and Materials, SAP HANA Certifications

Now check your data in data preview, here the data is displayed in english language as you can see in below screen shot

SAP HANA Tutorials and Materials, SAP HANA Certifications

AS you can see the data is displayed here in English language, now let’s cahnge text1 column in  German language then follow these procedures to get your output

Go to your HANA system, right click their and then go to properties

SAP HANA Tutorials and Materials, SAP HANA Certifications

Next go to additional properties there you can choose your language

SAP HANA Tutorials and Materials, SAP HANA Certifications

Once you finish this then activate and validate your view, you can see the changes in data preview

Now you can see that your data is in German language

SAP HANA Tutorials and Materials, SAP HANA Certifications

I hope this blog is helpful for all to understand Text join concepts in HANA!!!