Query

[Former Member]

Hi Guruu2019s

We created a query which is having a customer number along with one of the partner function(AB).

For this we utilized the tables KNA1,KNVP and PA0002 to create a query.

PA0002 is selected for First name and Last name of the Partner Function.

Now business requirement is that for a customer number, along with Partner function u2013AB , one more Partner Function u2013 BC has to display in the output of the query.

In the selection screen, when iam including the 2 partner Functions under Multiple Screen(arrow button) , the result is displaying as either AB or BC in the output of the query.

The requirement is that the output of the query has to display only the customers which are having both the Partner Functions AB and BC.

Regards

Steph

[Jelena · Accepted solution]

This is not an SD question. If you're talking about SQ01 query then this would require custom programming, at which point it might be easier / more efficient to rewrite it as a custom report (since customer's appetite for requirements seems to be increasing).

In SQ01 you'd have to let it select the records for either one of those partner types and then in query add custom code to look up the record with another partner type and, if not found, skip the record. This is not very efficient, but queries have only limited functionality.

[jignesh_mehta3]

Hello Steph,

Yes, I agree with Jelena above.

For such kind of requirements it is better to go for a ABAP report. The benefit of ABAP report will be that it will be easier to modify it in future.

Hope this helps,

Thanks,

Jignesh Mehta