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

[Former Member]

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.

[Former Member]

Hi Shaan

Pl

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

Regards

Khaga

[Former Member]

Field - .INCLUDE

Data Element : PAKEY

Data type - STRUCTURE

Desc - Key for HR Master Data

Yes the records are appearing twice in both the table.So my output is correct right ?

This is what I found in PA0000 table and pa0002 table. Please check the attachment.

[Former Member]

Hi Shaan If you select the analysis in the data preview the data will be distinct values Regards Khaga