Customer sales area data report

[Former Member]

Hi

Before building a new report using SQ01, I wonder if there is a system report in which I can get the sales areas master data report.

The data I need is the Customer code, Customer Name, Sales Organization, Country, sales group and sales group description.

I need this in order to cleanse the customers' sales area data in the system.

Thanks

Ofer

[Former Member · Accepted solution]

HI

Try in VCUST Tcode i hope it almost suits your requirement

regards

Prashanth

[Former Member · Accepted solution]

Hi,

Prashanth's suggestion is almost what I needed.

Thanks all.

Thanks

Ofer

[Former Member]

hi,

this is to inform you that,

execute SAP1, a t.code tor standard reports there you can find all the t.ocdes.

there goto sales & distribution - information systems - you can go any where here like customer/material/sales organization/shippint point/sales employee/sales office - you will find different t.code execute all and take which ever suits you.

hope this clears this issue

balajia

[reazuddin_md]

As already expressed,

I think you can check in all SAP std reports

tx:SD00- check in Information system .

tx: MCSE or MSCI or MC30 etcc.,

Regards,

ReazuddinMD

[Former Member]

hi,

this is to inform you that please execute MC+2

if you are not satisfied with the above then go to SE16N with KNA1 combination and prepare a report via ABAP query.

balajia

[Former Member]

try KNVV table

but here you wil get all details but not DECRIPTION

for decription, you need to check different table

Customer Name: KNA1

TVKO Sales organisation / company code

TVTW Distribution channel

TVBUR Sales office

TVKBT Sales office text

TVKGR Sales group

TVGRT Sales group text

T171T Sales district text