on 01-25-2008 8:33 PM
Hello Experts -
I'm trying to create an SAP query and need to use some fields from the KONV table.
I need to join this with VBAK, VBAP and VBPA.
But when I'm creating the InfoSet for the query, its saying I can't join KONV table because its a clustered table.
What other tables should I look into?
I need the following fields:
- KWERT
- KINAK
- KMPRS
- KSCHL
Thanks in advance for all your help!
Thats drawback of SAP query, it doesnt allow cluster table and there is no other table from wich u can get all pricing relevant field and thats constraint or restiction in SAP query otrherwise everyone will go for SAP query rather then ABAP/BW for reports and pls note that in production with more number of data's, ur SAP query will take hell lot of time to fetch u result...i mean perfirmance will not be good ...so pls go for custamized report through ABAP....
Regards
Jagdish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
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.