Skip to Content

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

Query on Checks deposited for the day

Hi Experts,

Can I have a query on checks which were deposited on-date. Columns would be: Dep No. Customer code, Customer Name, Check date, Check No., Bank code and Amount. Parameter would be the Deposit date.

Many thanks.

Don

Former Member
replied

Hi Don

SELECT T1.[DeposNum], T1.[DeposDate], T0.[CardCode], T0.[CardName], T2.[BankCode], T2.[CheckNum], T2.[CheckDate], T2.[CheckSum] FROM OCRD T0 , ODPS T1 INNER JOIN OCHH T2 ON T1.DeposId = T2.DpstAbs WHERE T0.[CardCode] = T2.[CardCode] and T1.[DeposDate] =[%0] GROUP BY T1.[DeposNum], T1.[DeposDate], T0.[CardCode], T0.[CardName], T2.[BankCode], T2.[CheckNum], T2.[CheckDate], T2.[CheckSum]

check this query i think this will solve ur problem if so pls do close the thread

Cheers

Jenny

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question