fields

[Former Member]

hello all,

can someone tell me what the fields are, that are used for the following report.

If the Order is a regular Order (one order for a single shipment), we have to consider the total of pieces we have shipped to that order, and we should show on this report

Customer ID,

Material Number,

Customer PO #,

Date requested,

Order Qty.

Order Value (Order Value = Order Qty * Material Unit price )

Currency.

Total pieces shipped (during the time frame set on the report).

Balance Left (Balance left = Order Qty - Total pieces shipped)

Value of the balance left Value of the balance left = Balance left * Unit price only if the Balance left is greater than cero,

if the balance left is lower than or equals cero, the value of the balance left show be cero.

% Delivery. (% Delivery = Total Pieces shipped / Order Qty.)

thanks in advance

seenu

[RichHeilman]

Customer ID, - VBAK-KUNNR

Material Number, - VBAP-MATNR

Customer PO #, -VBKD-BSTKD

Regards,

Rich Heilman

[Former Member]

Hi,

You will get the fields in these table...

VBAK, VBAP, VBPA, VBDK.

Regards

Sudheer

[RichHeilman]

Order Qty - VBAP-KWMENG

Also check VBAP for price unit and currency.

Regards,

RIch Heilman

[Former Member]

Hi,

Customer ID : <b>VBAK-KUNNR</b>

Material Number : <b>VBAP-MATNR</b>

Customer PO # : <b>VBAK-BSTNK</b>

Date requested : <b>VBAK-VDATU (Requested Delivery Date)</b>

Order Qty : <b>VBAP-KWMENG</b>

Order Value (Order Value = Order Qty * Material Unit price ) : <b>VBAP-NETWR</b>

Currency : <b>VBAP-WAERK</b>

Total pieces shipped (during the time frame set on the report) : <b>Get the total number of quantity shipped from LIPS-LFIMG</b>

Balance Left (Balance left = Order Qty - Total pieces shipped) : <b>VBAP-KWMENG - total of LIPS-LFIMG</b>

Reward points if the answer is helpful.

Regards,

Mukul