Remove duplicate values in Query AA tables

[former_member615468]

Hello,

i'm creating a query report and trying to join tables ANLA ,ANLB, ANLC, ANLP and ANLZ but i got duplicate output entries.

can anyone please explain to me why i got these duplicate values and how can i delete them?

thanks.

[former_member615468]

Hello,

i'm creating a query report and trying to join tables ANLA ,ANLB, ANLC, ANLP and ANLZ but i got duplicate output entries.

can anyone please explain to me why i got these duplicate values and how can i delete them?

thanks.

[vijay_hariharan]

Hi Mohamed,

The output from the Query would depend on the conditions you have given while querying on the various Asset tables. Would be rather difficult for someone to help you without knowing the query n conditions you have used. Would suggest taking help from someone around you who could assist you with the condition used. You may post the conditions here, maybe an expert here could offer help.

All the Best!

Regards,
Vijay

[TammyPowlas]

I agree with Vijay's comments

Also before joining tables, I recommend looking at logical database ADA to see if it meets your needs. SAP provides SAP query examples in user group AM (see SQ01, user group AM):

[former_member615468]

hello Vijay,

thanks for the reply, the join is defined in the screenshot.

a coding is necessary to remove the duplicate values?

thanks.

join-tables.png

[former_member615468]

table-data.png