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