Custom Report - Open Order

Dear All,

We are in a Process to Develop certain Z-Reports.

One of the Z-Reports is Open Order Status, which includes following informations:

Sales Office--Customer Code-Sales Order No.--Item No.Material Description-Booking Qty--Delivered QtyOpen QtySales Unit of MeasurementRate/ Unit--Total Open Value (Open Qty*Rate)

Everything is fine, except Two columns, i.e.

1. Delivered Qty

2. Sales Unit of Measurement

The Problem is:

In Report, we are able to capture the Booking Qty (in terms of Sales Unit).

For example: If, in Sales Order Booking qty is 20 Months, Report shows 20.000 in Column: Booking Qty.

But, 5 Months have been delivered, then, instead of 5.000 Report shows 150.000 as in Column: Delivered Qty. Apparently, Column: Open Qty, shows -130.000 as open Qty.

Also, instead of picking Sales Unit of Measurement as Month, System is showing DAY/ TAG in Column: Sales unit of measurement.

My second Query is:

Is there any way to get information from Structure, in to Program? As, I referred few Standard Program (related to Sales UoM and Delivered Qty). In Standard Program, value is getting referred to Structure (say, VBMTV, for example).

Best Regards,

Amit