topic Re: ALV Report. filter in Application Development and Automation Discussions

ALV Report. filter

Former Member — Mon, 31 Dec 2007 11:27:51 GMT

hi,

IF p_hkont IS INITIAL.

IF S_GSBER IS INITIAL.

SELECT * FROM bsik

INTO TABLE ibsik

WHERE bukrs = 'DHPL' AND

lifnr IN s_lifnr AND "Customer

umskz = p_umskz AND

budat <= p_budat.

ELSE.

SELECT * FROM bsik

INTO TABLE ibsik

WHERE bukrs = 'DHPL' AND

lifnr IN s_lifnr AND "Customer

umskz = p_umskz AND

budat <= p_budat.

ENDIF.

else.

IF S_GSBER IS INITIAL.

SELECT * FROM bsik

INTO TABLE ibsik

WHERE bukrs = 'DHPL' AND

hkont = p_hkont AND "GL accnt

umskz = p_umskz AND

GSBER IN S_GSBER AND

budat <= p_budat.

ELSE.

SELECT * FROM bsik

INTO TABLE ibsik

WHERE bukrs = 'DHPL' AND

hkont = p_hkont AND "GL accnt

umskz = p_umskz AND

GSBER IN S_GSBER AND

budat <= p_budat.

ENDIF.

IF p_hkont IS INITIAL.

IF S_GSBER IS INITIAL.

if s_lifnr is NOT initial.

SELECT * FROM bsik

INTO TABLE ibsik

WHERE bukrs = 'DHPL' AND

lifnr IN s_lifnr AND "Customer

umskz = p_umskz AND

budat <= p_budat.

ELSE.

SELECT * FROM bsik

INTO TABLE ibsik

WHERE bukrs = 'DHPL' AND

lifnr IN s_lifnr AND "Customer

umskz = p_umskz AND

budat <= p_budat.

ENDIF.

else.

IF S_GSBER IS INITIAL.

if s_lifnr is NOT initiaL.

SELECT * FROM bsik

INTO TABLE ibsik

WHERE bukrs = 'DHPL' AND

hkont = p_hkont AND "GL accnt

umskz = p_umskz AND

GSBER IN S_GSBER AND

budat <= p_budat.

ELSE.

SELECT * FROM bsik

INTO TABLE ibsik

WHERE bukrs = 'DHPL' AND

hkont = p_hkont AND "GL accnt

umskz = p_umskz AND

GSBER IN S_GSBER AND

budat <= p_budat.

ENDIF.

endif.

i am trying to filter gsber and lifnr at atime. but i am not able to filter with this code .give me solution.urgent.

Edited by: vasanth kandula on Jan 1, 2008 10:23 AM

Re: ALV Report. filter

Former Member — Tue, 01 Jan 2008 05:14:46 GMT

vasanth,

u r confuse between parameter and select-options characteristic.

u do not need to check s_gsber initial or s_lifnr is initial.

Directly u can put in where condition. if is is blank no record will be selected. if possible convert your parameter in select-options and put in where condition. within single select statement u can fetch data...

raj

Re: ALV Report. filter

Former Member — Tue, 01 Jan 2008 05:22:09 GMT

hi,.

Thanks for you reply.

i need to display with out filter of gsber and lifner also and give me ur syntax also.

my requriment is :

if i given gsber input on selection screen i need to display particular gsber only and

if i given lifner input without gsber i need to display particular lifner details only and

if i given gsber and lifner on selction screen i need to display for particular lifner and plant only and

if i am not given gsber and lifner also i need to display output

here gsber and lifner both are select-options.

please give me solution on that scenario.

Edited by: vasanth kandula on Jan 1, 2008 10:55 AM

Edited by: vasanth kandula on Jan 1, 2008 10:56 AM

Re: ALV Report. filter

Former Member — Tue, 01 Jan 2008 05:31:44 GMT

simple,

SELECT *

FROM bsik

INTO TABLE ibsik

WHERE bukrs = 'DHPL'

AND hkont = p_hkont

AND umskz = p_umskz

AND budat <= p_budat.

u can add lifnr + gsber in where condition. do not put obligatory in select-options. if your user want all data they keep blank in gsber and lifnr. if they need data base on gsber and lifnr they will enter filter data on selection-screen only.

raj

Re: ALV Report. filter

Former Member — Tue, 01 Jan 2008 05:39:29 GMT

fgffssf

Edited by: vasanth kandula on Jan 2, 2008 3:58 PM