Table Search Help to Remove Duplicate Entry

[Former Member]

Hi All Tha ABAP GURUS,

I have created 2 tables say A with fields main description and sub decription and another table B in which there are these 2 fields with other fields. I want to display search help for Table B for fields main description and sub decription separately and I have done the same by creating Elementary Search Help (ZDS and ZDM resp.) . For sub description it is working fine and for main description it is displaying value but duplicate. How to remove these duplicate values.

For Eg Values are

Main Desc Sub Desc

1 A

1 B

1 C

2 D

2 E

In my case it is showing

1

1

1

2

2

but I want

1

2

I want to achieve this without creating any ZProg. Can I use search help exit.Kindly guide me in this matter how to use it.

Thanks & Regards,

Bharti Jain

[Former Member]

Hi All Tha ABAP GURUS,

I have created 2 tables say A with fields main description and sub decription and another table B in which there are these 2 fields with other fields. I want to display search help for Table B for fields main description and sub decription separately and I have done the same by creating Elementary Search Help (ZDS and ZDM resp.) . For sub description it is working fine and for main description it is displaying value but duplicate. How to remove these duplicate values.

For Eg Values are

Main Desc Sub Desc

1 A

1 B

1 C

2 D

2 E

In my case it is showing

1

1

1

2

2

but I want

1

2

I want to achieve this without creating any ZProg. Can I use search help exit.Kindly guide me in this matter how to use it.

Thanks & Regards,

Bharti Jain

[Sandeep_Panghal]

In table A both dec. and sub desc are key fields ?

[Former Member]

Yes both are the key fields in Table A.

Regards,

Bharti Jain

[RaymondGiuseppi]

Yes you can delete duplicates in a search help exit, but not without "without creating any ZProg" as you will create a Function Module (and Group)

Duplicate the sample FM F4IF_SHLP_EXIT_EXAMPLE in a customer function group, and delete duplicate records of RECORD_TAB in the step 'DISP' (executed before display).

You could also perform the select yourself adding a DISTINCT option to the statement in the 'SELECT' step but this will take more time to develop, as you must read the other parameters to use selections provided by user or program.

Regards

Raymond,

[Former Member]

Thanks All For the kind help.

Issue has been resolved.

Regards,

Bharti Jain