topic help needed on a query ?? in Application Development and Automation Discussions

help needed on a query ??

Former Member — Mon, 20 Nov 2006 12:27:15 GMT

Hello to All,

I need to construct a query for the following,

-> Filter document number from table BSIS on (current date minus 1) with doc type SA.Filter it on the bank account (123456)

-> Filter the numbers on SHKZG = 'H'.

-> sum the amounts(WRBTR) GL account wise

-> Get house bank name from gl account

-> should be grouped bank account wise

Now i can easily get the records from BSIS after the required filtering, but is there any way by which i can JOIN the tables and get the required end result.If yes, then can you please show me how, thru a sample query ... Thank..

Hope i am comprehendable.

Shehryar Dahar

Re: help needed on a query ??

Former Member — Mon, 20 Nov 2006 12:59:41 GMT

u need to write select statement first to get documents based on current date - 1 & doc type & bank account & shkgz. Now write one more using for all entries with remaining conditions...Loop one table & read another and move to final internal table.

Re: help needed on a query ??

Former Member — Tue, 21 Nov 2006 07:14:06 GMT

Hello,

Can you show me how to do the above i.e how to loop one table and read the another...

Re: help needed on a query ??

Former Member — Wed, 22 Nov 2006 00:37:27 GMT

Hi,

You can create a infoset with the required tables and then click on the push button 'Extras', that will give you a table control. Select the tabstrip 'Code', in this tabstrip you can select the event 'End-of-selection (before list)' from the drop down box for 'Coding section' and then put in your code.

Hope this helps.

Thanks.