Skip to Content
0
Former Member
Dec 04, 2008 at 02:53 PM

SQL Help

76 Views

I have following requirment:

Select statement show any checks withing paying co, hsg bank and account id where:

Payment date from blank to period ending parameter ZALDT

AND

voidd date 00/00/0000 - VOIDD

OR

void date greater than period ending parameter - VOIDD

OR

encashment date 00/00/0000 - BANCD

OR

encashment date greater than period ending parameter - BANCD

I wrote following select statement which i want to verify whether I am correct or not.

SELECT CHECT ZALDT VBLNR BANCD VOIDD HBKID HKTID

FROM PAYR

INTO TABLE ITAB

WHERE ZBUKR = P_ZBUKR

AND HBKID = P_HBKID

AND HKTID = P_HKTID

AND ZALDT <= P_ZALDT

AND ( VOIDD = ' ' OR VOIDD > P_ZALDT )

AND ( BANCD = ' ' OR BANCD > P_ZALDT )

Thanks in advance