Skip to Content
0
Former Member
Aug 09, 2007 at 09:18 PM

validate customer,shipto,sales rep against sales area

21 Views

Hi experts,

I need to validate customer,ship to and sales rep.

which table do i need to use for validation.

for customer number i can check KNA1.

for ship to i can check KNVP table but i don't understand how to write query

for it.

select kunn2 from knvp

where vkorg = <internal table-vkorg>

vtweg = <internal table-vtweg>

spart = <internal table-spart>

parvw = 'sh'

kunnr = <internal table-kunnr>

please let me know if i am wrong.

thanks,

Neo