topic Re: fields in Application Development and Automation Discussions

fields

Former Member — Tue, 30 Jan 2007 18:49:47 GMT

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

Re: fields

RichHeilman — Tue, 30 Jan 2007 18:52:02 GMT

Customer ID, - VBAK-KUNNR

Material Number, - VBAP-MATNR

Customer PO #, -VBKD-BSTKD

Regards,

Rich Heilman

Re: fields

Former Member — Tue, 30 Jan 2007 18:56:57 GMT

Hi,

You will get the fields in these table...

VBAK, VBAP, VBPA, VBDK.

Regards

Sudheer

Re: fields

RichHeilman — Tue, 30 Jan 2007 18:57:23 GMT

Order Qty - VBAP-KWMENG

Also check VBAP for price unit and currency.

Regards,

RIch Heilman

Re: fields

Former Member — Tue, 30 Jan 2007 19:08:34 GMT

Hi,

Customer ID : VBAK-KUNNR

Material Number : VBAP-MATNR

Customer PO # : VBAK-BSTNK

Date requested : VBAK-VDATU (Requested Delivery Date)

Order Qty : VBAP-KWMENG

Order Value (Order Value = Order Qty * Material Unit price ) : VBAP-NETWR

Currency : VBAP-WAERK

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

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

Reward points if the answer is helpful.

Regards,

Mukul