topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Wed, 05 Nov 2008 07:19:24 GMT

How to write a select query for this:

I have a Report .That report has to be executed for FR company code and only for FR country code vendors, and results exported to Excel for the record of the journal

Re: select query

Former Member — Wed, 05 Nov 2008 07:23:49 GMT

Hi Vinay,

Welcome to SDN!!!

First of all could you please elaborate your requirement.

As of now you need to put a query in the table for this tellme the exact requiremnt.. I am not clear with your problem.

Thanks,

Chidanand

Re: select query

Former Member — Wed, 05 Nov 2008 07:46:33 GMT

Hi,

As much as i could understand from your post, i think you want to process only for FR country code vendors and my assumption is that you must be reading the Company code from somewhere so you should put the authorization checks for that ,if user is not authorized for that he will not be able to execute the report.T001 is the check table for Company Codes.

Re: select query

Former Member — Wed, 05 Nov 2008 08:01:21 GMT

Thankyou chidand and neha,

My requirement is : The country code for vendors from LFA1 must be added to report as a selection option and as a column in the layout.

Re: select query

Former Member — Fri, 20 Feb 2009 05:41:35 GMT

qwr