Skip to Content
0
Former Member
Dec 31, 2007 at 11:27 AM

ALV Report. filter

27 Views

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.

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.

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.

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