01-09-2012 9:29 AM
Hi experts,
i have report in that report identify all US sales orders.But in VBAK and VBAP tables dont have related to that field.
So my question is how can i identyify specific countries Sales Orders. Is there any FM module or anything....
Thanks and Regards
V.Venu
01-09-2012 9:31 AM
you can check the sales organization or customers as per your need and those will tell you which country is it for...
by the way you want seller country or customer country?
01-09-2012 9:35 AM
01-09-2012 9:41 AM
prakash anyway tell me if seller base and customer base how can i identify sales orders..
01-09-2012 9:44 AM
Hi Venu,
In VBAK you can find the customer for sales order. and in kna1 table you can find specific country with that customer.
kna1-land1 is the field.
Regards,
Amar
01-09-2012 9:56 AM
amar your answer ok.but the thing is if customer base or seller base,how can i identify sales orders..
Ex:1. US customer palce an order diff country "customer base
2. in US sellers have diff customers from diff country.."seller base
01-09-2012 10:01 AM
with customer you can get customer country from address data,,, (adrc table)..
sales organization. .will also have adrc data..
01-09-2012 10:01 AM
prakash how i can identify sales orders based on seller..because sellers have sales orders from US and UK and AUS.
so how can i identify only US orders..
01-09-2012 10:14 AM
in sales organization doesn't have adrnr field how it is possible.so how can i know ardc data..
01-09-2012 10:18 AM
see.. all you need is the partners.. ok?
you need UK orders and US orders that means SOLD-TO-party .. right??
so from VBUP get the partner.. and the partner address.. .done
01-09-2012 9:43 AM
I think table VBPA will help you where you have to pass PARVW = 'SH' and the field LAND1 holds the country & VBELN holds sales order.
PARVW = 'BU' - Buyer, Sh - Ship to party ,SE - Sender etc.
01-09-2012 10:10 AM
Hi Venu,
If you want to identify all US sales order, you can consider the currency field of vbak table. i.e. in VBAK Table consider the WAERK field as 'USD'. Like this considering the currency field you can filter any country's sales order.
Thanks,
Sanjeeb
01-09-2012 10:16 AM
already i tried.But that is performance issue..and thats wrong US and AUS etc also have USD currency..is there any alternate?
Edited by: venu.knd on Jan 9, 2012 11:17 AM
01-09-2012 10:40 AM
How can you consider US and AUS both have currency as USD. Both US and AUS Dollar conversion rate is different. For US the currency is USD and For AUS the currency is AUD i.e Australian Dollar. So Currency you can filter .