on 01-03-2008 9:32 AM
Hi
I am trying to do a join in SQVI with Field VBELN
however No data is beign pulled...
are there any settings to be done...
John
Hi John
If you are trying SQVI and filed VBELN to join its probably VBAK and some other sales related table.
You should be able to do join with respect to this field if its not, you should probably run the same scebario on some other server and see .....
Also check sap notes for SQVI error if you are getting some pertucal type of error
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
got to SQVI and in QUICK VIEW enter ur query name and press create and give TITLE and description and in "DATA soruce" selct "table join" and select "ok" and u reach one screen press "insert table" or press "shiftF1" in application tool bar and give ur table name again press "insert table" or press "shiftF1". in this way we can joint tables in SQVI.
reward me if it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear srilatha reddy
The QuickViewer is a new product that is actually a variant of the standard query maintenance transaction. It contains the following new features:
The reports created using the QuickViewer are called QuickViews. They have the same functional properties as queries, but only basic lists may be defined.
User groups are no longer necessary in the QuickViewer. All users have their own personal supply of QuickViews that cannot be passed between different users. You may, however, convert QuickViews to queries and then assign them to a user group.
Functional areas are no longer a requirement when defining QuickViews. When defining a QuickView you must initially specify a data source. This data source may be a table, a database view, a table join, a logical database, or a functional area that already exists.
The QuickViewer has two different modes for creating QuickViews Basis mode and Layout mode. In basis mode, only those fields you want to use in the report are selected (including sort fields and selection fields) and your report's graphical layout is determined by the tool you choose to display it in (Excel, ALV, as a list, etc.). In layout mode, the Query Painter described above is used to layout your list.
The QuickViewer uses several different controls and can only be used if your system meets the appropriate hardware and software requirements.
Use transaction code SQVI to call the QuickViewer. You can also use the menu option System -> Services -> QuickViewer.
The initial screen of the QuickViewer is similar to the initial query maintenance screen. You will find an additional window at the left of your screen containing help texts. You may change the size of this window using your mouse. You can call existing QuickViews for processing by selecting a QuickView directly from the table or by entering its name in the appropriate input field. Then choose the function Change.
To create a new QuickView you enter a new name in the input field and choose Create . A dialog box appears where you must make the following entries:
Title (long text) and remarks, if you so desire
Type of data source (table/database view, table join, logical database, functional area)
Name of the data source
At this point different kinds of entries may be expected from the user depending on the type of data source selected. Use the possible entries pushbutton for a list of possible data sources.
Mode (basis mode or layout mode)
If you have chosen a table join as your data source, the join must be defined before you can begin with QuickView definition. During join definition, a control is made available to users allowing them to visualize the relationships between the individual tables. The join definition procedure will be described in depth below.
If you have chosen a functional area as your data source, the functional area must come from the standard area. Functional areas from the global query area may not be used in QuickView construction.
If you have chosen basis mode for defining you QuickView, a screen is displayed containing a tab strip with three tabs where you can make all of the necessary entries pertaining to the fields you want to display. Here you determine which fields are to be displayed, which fields you want to use as sort fields, and which fields should be used as selection fields. Each tab contains a table on the left with those fields selected and a table on the right containing all fields available for use. The table on the left may contain additional infomation about the fields selected depending on how the are to be used (display, sorting, selection).
To choose a field, select it in the table on the right and use the pushbutton Arrow pointing left to move it to the other table. To deselect a selected field, select it in the table on the left and use the pushbutton Arrow pointing right to move it back to the table on the right. You can select and move more than one field at a time. In addition, pushbuttons exist that allow you to move all of one table's fields to the other.
You can select a field in the selected field list on the left and use the pushbuttons to the left of this table to move the field up or down in the field sequence. This allows you to determine the display or sort sequence of these fields depending on which subscreen (tab) you are currently on. The sort subscreen also has pushbuttons allowing you to alter the sort direction (ascending or descending).
In addition, basis mode contains a selection field with dropdown box that allows you to choose which tool you want to display your list in (Excel, ABAP List Viewer, as a list, etc.).
If you want to design your list's layout yourself and choose layout mode instead, the graphical Query Painter described above appears instead of these tab strips.
Regarding your question where it will be used, supposing you have to generate a report based on the customer sales area, if the despatch details has to be generated, you have to use SQVI and table join KNVV (for sales area) and VBRP (for despatch details).
Hope this explanation is suffice and reward suitably.
Thanks
G. Lakshmipathi
Hi,
Always two active tables are required to do a 'join'.
Also, i am not able to get what you are trying to do?
What is this SQVI - is it a table? i am not able to find one such in SAP..
Could u please brief little more?
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
between which two table your trying to join
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi smith
Kindly tell me what is SQVI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hai John,
Are using abap query? then it is sq01,sq02,sq03.
Regards
Pradeep Belur
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
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.