on 02-14-2008 7:51 AM
Hi !
Can anyone plz guide me as to how can I get a list of all the Sales Groups under a Company Code?
Go to TC-ec01.select structure and then navigation u will get all the company codes.Selecting ur company code u can find what all are assigned to your company code.
Reward if useful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Simply Goto EC01, then press structure, then Navigation,
Then u can extend the tree, u can find out the sales groups assigned to all sales offices.
Hope it is useful.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Shamik
Go to SQVI and Table Join KNB1 (for Company Code) and KNVV (for sales office) and run the report.
thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
The sales group are assigned to Sales offices which is assigned to sales area.
Hence develop a query with tables
T001-- list of company codes
TVKBZ-Sales office assignement to org units
TVBVk-Asssignment of sales groups to sales office
hope this helps u
regards,
Arun prasad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hello, friend.
you can use queries to present your required data. first run t-code SQVI. enter a file name and click create.
on the following screen, choose 'Table Join' and Basis Mode. click 'enter'.
insert tables TVKO, TVKBZ and TVBVK. click on the left green arrow.
on the Quickviewer: Initial Screen, go to the 'list field selection' tab and choose the fields Company Code and Sales group.
next go to the 'sort sequence' tab and click on company code and/or sales group. do the same for the 'selection fields' tab.
now execute this query. you will see the list of sales groups per company code.
regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Sales groups are not assigned to company code directly.Sales groups are assigned to sales offices, and sales offices are assigned to sales areas.
You may have to get the details from the tables: TVBVK & TVKBZ.
Muraleedharan.R
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Guptha,
I think there is no standard report avail for your requirement, so you need go for new development or create SAP Quiery as for your convinience.
Regards,
Murali.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.