Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Select query with blank date

Hi All,

I have issue with my select query, this query should execute when the date is empty in the table. Fields for the date is (trrecv and trpay)

code:

SELECT * FROM zcat3_mov

INTO CORRESPONDING FIELDS OF

TABLE lt_invmov

WHERE bukrs EQ zcat3_mov-bukrs

AND trans EQ zcat3_mov-trans

AND status EQ 'CD'

AND clear EQ ' '

AND trrecv EQ ' '

AND trpay EQ ' '.

Thanks,

FED

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question