on 11-27-2009 2:12 PM
hi all,
i have an issue to have the list of customer we can use
Vcust t- code, but my client wants to have the list of customer and their details which have been entered in the customer master data . for taking a print out
is there any other T code for it or do we have to customized the ztable becasue the clients wants to know all the customer and the list of their details which are enter in the master data. ( only the field which are activated according to the sales area)
kindly tell me the t code if there is one
kumaresh
Hi,
The customer master is stored in different tables. KNA1(General Data in Customer Master), KNB1(Customer Master (Company Code)), KNVV (Customer Master Sales Data); Make a report and fetch data from all the above said tables. This is possible if you know SAP Query; by combining these tables you can generate reports. If you want to get excise details, add that table also.
Hope this information will be useful to you.
Regards,
K Bharathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks for your ur update?
i tried the sap query , but i cannot able to process further or after creating Abap query , i have created infoset and i have created user group and i have assigned the infoset to the user group and after creating abap query i could not proceed after clicking the basic list icon on the application tool bar, it's showing a different layout design and i have document which asking for fields
like " coloumns seperated by", "line", " sequence" " sort" fields like that
can u help me from here.
thanks
TCode SQVI is the simplest method.
Go to SQVI and do the following:
1) Give some description in "Quickview"
2) Click "Create" button
3) Give some description in "Title"
4) From the tab "Data Source", select "Table Join" and click blue tick
5) Press "Shift + F1"
6) Give the table you wanted and press enter
7) Again Press "Shift + F1"
😎 Again give the table you wanted and press enter
9) Press F3
10) On your left screen you can see those two tables with header "List fields" and "Selection Field"
11) Whatever data you want to give as input, (say for example based on sales organisation, you want some report), select the white box under selection field
12) Whatever data you want as report format, select those fields under List fields
13) Execute the report
thanks
G. Lakshmipathi
hi, thnks for the update,
i have followed as per your guidelines, but i could not able to generate the report , i have included the tables knb1, kna1 and knvv. and in the list field i have selected all the dialog box , and in the selection list i am selecting according to the customer account group .
but i cannot able to excuete the report it says "no data has been selected" and it says the following msg
"When executing a query on the selection screen, no data was found for the criteria you entered. Therefore, no list could be generated."
is there any problem in choosing the table should i have to choose according to the order level , like General data, company code data, and sales area data .
can u help me on this
thanks
To assign a Tcode to this query created in SQVI.
steps:-
1- create the same query in using SQVI in Production.
2- Execute the query ,now goto System- status, Copy the program name from "Program" field in the status screen.
3- Tcode:SE93 in dev, enter the Tcode ( statrs withZ*) & choose create.
4- Assign the package , enter the program name with Tcode text,
5 - mark - "Professional User Transaction" under classification tab & SAP GUI for HTML,SAP GUI for JAVA,SAP GUI for WINDOWS under GUI Support & save in Transport request.
6- Now move this TR to Production.
Try ,this will work , if not, Take assistance of your ABAPer
User | Count |
---|---|
102 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
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.