Skip to Content

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

Report Logic

Hi All

I have a internal table with fields and data as:

salesoffice, coordinator, invoicetype , invoice_dt, order_creation dt

london AA 001 26/01/2007 25/01/2007

london AA 001 23/01/2007 22/01/2007

london BB 003 11/01/2007 01/01/2007

I want the summarized report in this format

sales_office, coordinator, inv_type, wk1, wk2

london AA 001 2 0

BB 003 0 1

where wk1 is the diff between invoice_dt and order creation date. if the diff is <=7 it counts the number of records and put in wk1, simmilarly for wk2 i.e if diff is <=14.

if any body can help me with this that will be great.



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