Skip to Content

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

Cheque formula

Trying to create a query which looks at the following tables:

  • Deposit - ODPS

  • Deposit lines - OCHH

  • Payment means - RCT1

This query is aimed at providing a list of cheque details per deposit slip number, which includes specific UDF's which are sitting in the payment means/ cheque screen.

I would like the following information:

ODPS - Deposit

  • Payment number

  • Payment date

Where payment type = 'K' = cheque

Where payment number = [0%]

OCHH - deposit lines

  • Cheque date

  • Cheque number

  • Branch

  • A/C number

  • Cheque amount

RCT1

  • Amount

  • UDF1

  • UDF2

When I bring the tables together, the lines duplicate.

I would greatly appreciate some assistance please.

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