Dear consultants,
the 'problem' is as followed:
I use the following files:
SIL
SSM
RCM
IIM
2. Matched records with primary file
ILSAL1 EQ SSAL
ILCUSB EQ CCUST
ILPROD EQ IPROD
Select records:
ILPROD LIKE 'F%'
AND ILDATE GE 20100501
AND ILWHS LIKE 'Q%'
AND SNAME LIKE '%F%'
As output I want to see these fields but than summarized on quantity per
item, while I have more lines for the same item.
10 T01.ILQTY Quantity
20 T02.SSAL Salesman Number
30 T02.SNAME Salesman Name
40 T01.ILCUSB Billing Customer
50 T03.CNME Customer Name
60 T01.ILPROD Item
70 PIECE ilrev/ilqty
80 T04.IDESC Item Description
90 T04.IDSCE Extra Description
The output I want to use in another query.
Thank you very much for your help already!
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. ---------------------------------------------------------------------------------------------------------------------
midrange.com
