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