topic Re: Code for select query in Application Development and Automation Discussions

Code for select query

Former Member — Mon, 01 Sep 2008 09:31:03 GMT

Hi please help me to write this select query

report i/ps are :bukrs,anlkl,report date,ktansw,budat and posnr

report o/p:belnr,bukrs

bukrs:value is entered in the selection screen

anlkl:optional field in selection screen

report date:fetched and placed in a table

ktansw:can this be directly fetched from table

budat:fetched and placed in a table

posnr:already fetched and placed in the table

Re: Code for select query

Former Member — Mon, 01 Sep 2008 09:34:08 GMT

Hi,

What condition u want 2 fetch the data.....

regards:

Prabu

Re: Code for select query

Former Member — Mon, 01 Sep 2008 09:36:27 GMT

using whatever i have mentioned in the report i/p should be in the where codn.

Re: Code for select query

Former Member — Mon, 01 Sep 2008 09:38:06 GMT

Hi,

on what condition it should be fetched and give the table names.

Narendra

Re: Code for select query

Former Member — Mon, 01 Sep 2008 09:42:48 GMT

anek table which has the values of belnr,bukrs.

anlav structure which has the field anlkl,

rbada structure which has the value of brdatu(but this is already fetched and placed in a table)

Re: Code for select query

christine_evans — Mon, 01 Sep 2008 10:06:14 GMT

ANLAV is a structure. Structures don't hold data. You need to find the associated database table.

Then, you just select the data you want (and don't already have) from the database tables into internal tables defined in your program ....and there you have it.