Item with last transaction date

Good morning dear consultants!,

with downstanding two queries, i try to get a list of all transactions in
query 1, and in the second one i try to find the last used transaction date
for each item (of query 1). I would like to have a list with only the last
transaction with the items.

I use BPCS version 6.1/release GA.

Can you assist me with this?

Thank you!


Query 1:
Used files: ITH, CICL01, IIML01, ILIL01,

Select records:
ICFAC EQ 'AA'
AND TWHS LIKE 'B%'
AND TTYPE NLIST 'C' 'A' 'T'
AND TTYPE NLIKE 'T%'
AND LWHS LIKE 'B%'
AND TCLAS NLIKE 'P%'
AND TCLAS NLIKE 'R%'


Query 2:
Used files: Output file 1, ILI.

Select records:
LWHS LIKE 'B%'
AND TCLAS NLIKE 'P%'
AND TCLAS NLIKE 'T%'

Matched records with primary file and TPROD EQ LPROD


I don't get a good list myself. Do you have any information to get this?

Thank you!

Rgds,

David AntonissePlease consider the environment before printing this e-mail. --------------------------------------------------------------------------------------------------------------------- Discover Impress on http://www.impressgroup.com The information contained in this e-mail and any attachments is strictly confidential and may be legally privileged.It is intended solely for the use of the individual or entity to whom it is addressed. If you are not the named addressee, you are hereby notified that it is prohibited and may be unlawful to disclose, distribute, store, copy the information in any medium or usage for another purpose. ---------------------------------------------------------------------------------------------------------------------