select query

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

qwr