Code for select query

[Former Member]

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

[Former Member]

Hi,

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

regards:

Prabu

[Former Member]

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

[Former Member]

Hi,

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

Narendra

[Former Member]

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)

[christine_evans]

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.