Skip to Content
avatar image
Former Member

which join to use ? for records appearing 4 times in raw data in HANA

I am new to SAP and HANA so starting with small assignment. Records are appearing more than the no. of times they exist  in the Raw data section in HANA. How I can I solve it ? the join I took is Text join. But there is no SPRAS option. Following is the small assignment I am working on. I am trying to take PERNR from PA0000 table and link it to PA0002 table with other details to see.

Untitled.png (23.9 kB)
0.png (9.8 kB)
project work.PNG (43.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 29, 2015 at 04:27 PM

    Hi Shaan


    Please once check the master data in tables PA0000 and PA0002

    In this tables pernr values will be repeated . this column will be not primary key column .it will be composite primary key column. i.e pernr one of the key column. That’s ways values will be repeated.

    Please see the attached file

    For example pernr = 1000 value will be repeated twice from both table.

    While performing join in this two tables. The result will be repeated values (duplicate) if not select the other columns In both tables.

    If you select the analysis in the data preview. The data will be distinct values



    shaan1.gif (224.2 kB)
    Add comment
    10|10000 characters needed characters exceeded