Skip to Content
0
Former Member
Dec 07, 2009 at 10:14 PM

Fetch the data from the Data base based on selection criteria in ABAP

43 Views

Hi

I am new to ABAP and working on the Screen where User Enters Company code from and to , Document no and to, I have defined as specified below

SELECT-OPTIONS Company FOR p_ccode.

SELECT-OPTIONS Document FOR p_fdocnr.

SELECT-OPTIONS Year FOR p_fyear.

When I debug in the pgm I get the values as

IBT11001100 (From and To Company Code)

IBT23234241002323424246 (From and To doc no)

IBT20092009 (From and To Year)

How can write a SQL select statement to fetch the data from the Database based on the above inputs

Thanks

PR