Skip to Content

Data Type Conversion not working - Join failing


Hi Experts,

I have 2 join 2 views in HANA Studio.

1. 1 of those views is CV , Containing Analytics View based upon SAP BW DSO (with no measure only characteristics).Here all Data Types in the Analytics views are NVARCHAR.

2. The other one is CV based upon some SAP TM Tables and as SAP TM Tables has Parent/DB Key which are VARBINARY format.

I tried doing data conversion by creating SQL Script based CV from NVARCHAR to VARBINARY using TO_NVARCHAR Function but its getting converting into 64 character and the same is still not matching.

Same way i treid for the other one from VARBINARY to NVARCHAR using TO_NVARCHAR option but it didn't do anything. Column value remain same.

Any help would be highly appreciated.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Aug 12, 2015 at 11:54 AM

    Hi Kamal,

    Is this VARBINARY on SAP, the GUID 64 positions?

    We faced similar on SP7 if I remind correctly it got supported on SP8, at least I don't remember that it's an issue now that we are on rev82.

    What HANA revision you are using?

    What is the error you receive on first case?

    Regards, Fernando Da Rós

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 16, 2015 at 10:06 AM

    Hi kamal Mehta,

    I hope this work.

    CAST( <column> as VARBINARY) Function to converting NVARCHAR to VARBINARY

    In this <column> is NVARCHAR column.

    For more information ---- CAST - SAP HANA SQL and System Views Reference - SAP Library



    Regrads,

    Khaga.

    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.