We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-acct] SAP QuickViewer -T.code SQVI - Suggest a table

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from sridharca on Jan 23 at 10:17 AM
If you use logical database, there is no option for joining.
What you can do is to define additional field using SKB1-txt20 or txt50 for GL text. For some reason, table SKA1 does not work.
Same is the case with cost center text.
Once you define additional field, you need to a simple coding to select appropriate record from the GL and cost center table. Make sure you add the coding to BSEG table level.

Then, add these additional fields to your field group and show it in the query.

Sridhar S

---------------Original Message---------------
From: Sridhar
Sent: Monday, May 27, 2013 9:06 AM
Subject: SAP QuickViewer -T.code SQVI - Suggest a table

Dear Friends,

I have created a SAP query using T.code SQVI (Quick viewer). I have all the details in the table BKPF. However, Amount in local currency and document currency is not available in table bkpf.

I have used tables BSID & BSIS.


However, the query is not being executed and output is "no data is selected".

Please suggest how to overcome the problem.

Regards
Sridhar

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2014 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
sridharca  

achievements
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Become a blogger at Toolbox.com and share your expertise with the community. Start today.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language