Customer master Query report doesnt pick all the customer account groups

[former_member212707]

Hello experts

We have a custom Query report created using customer master tables KNA1,KNVV,KNB1 etc. We have customers maintained under 5 customer account groups. One of the selection fields in the query is account group. But it displays customers only in 4 of the 5 account groups for some reason, even though we have customers maintained in that group(prospective customers).

Any reason why this could occur? How do i ensure that customers from all account groups are visible?

Thanks in advance

[od_manikandan · Accepted solution]

Hai Ravi

In SAP query if you join

KNA1 - KNB1- KNVV

General - Sasles data - company data

May be your 5th Account type is created without company code data.

The query will display only if the data is linked in all tables.

In case if you don't have company code data but you want the details of the account group customer

In the query join screen.

Right click on the joining line between KNB1 and KNVV and select Left outer join.

Now run the report , it will show all the account group data.

Regards,

Mani

[former_member212707 · Accepted solution]

Hi all

Thank you for the responses as ever.

Mr Mani, your solution resolved my problem. One of the joins was messed up because of some earlier changes. This is now working fine after i checked for the same.

It has been resolved. Closing the thread.

Thanks

[Former Member]

Hi Ravi,

It depends on the other filtering or selection criteria in your query and the way you're joining different tables.

Regards.

Raghu.

[madhu_vadlamani]

Hi Ravin,

As Krishna suggested check that field .You will get all account groups.Check this and post if need help.

Regards,

Madhu.

[former_member204407]

Hi ravi,

check with KNA1-KTOKD

Regards,

Krishna.