how to find the table in the dictionary?

[Former Member]

Hi,

I have to get the values of kunnr corresponding to the values of vkorg,vtweg and spart i..e.

I have to fetch the customer data based upon the values of sales organization,channel and division..

Is thr any table which includes all these 4 fields together??...

I found one table A007,its a pooled table..

are there any other tables??...

Thanks,

Sri

[Former Member]

I am not on sap system right now to verify this, but i think KNVV has these fields.

just chk it out.

[Former Member]

Thank u Mr.Karthik.

[Former Member]

Hi,

KNVV table has all the fields. Check it..

Thanks.