cancel
Showing results for 
Search instead for 
Did you mean: 

rearding actual delivery & ordered qty

Former Member
0 Kudos

Where can get actual delivery and ordered qty fields.

Thanks

Vikranth

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

You can also use the FM RV_FLOW with VBTYP_N = 'J'

But you will not get exact one to one relation.

Like you can't check the exact relation between Schedule line and delivered Qty.

SAP calculate it dynamically.

You also need to take care of any reversal.

It is a calculated value, not a value of a table field. Also, it may lead to wrong results if you don't pay attention to this description of the field here under in bold.

Delivered quantity in sales units

The quantity from the schedule line that has already

been delivered.

Use

When there is more than one schedule line for an item,

the system distributes the total delivered quantity for

the item across the schedule lines according to the

sequence of their delivery.

Example

A sales order item has three schedule lines, each with

an order quantity of 50 pieces. You make two subsequent

deliveries: the first for 20 pieces, the second for 60

pieces. The delivered quantity for the first schedule

line is 50 pieces, for the second 30 pieces, and for the

third zero.

If you delete the first delivery (20 pieces), the

delivered quantity for this schedule line is still 50

pieces. However, the system reduces the delivered

quantity for the second schedule line to 10 pieces.

Former Member
0 Kudos

For a sales document, look at the Sales Document Flow table VBFA with VBFA-VBTYP_N = 'C' order, 'J' deleivery, 'H' return (there may be others).

Rob

former_member181966
Active Contributor
0 Kudos

<b>VBAP Order qty Against material number

Deliverqty LIPS Against material number</b>

Hope this’ll give you idea!!

<b>P.S award the points.</b>

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

Former Member
0 Kudos

Hi Khimavath,

If you are looking to get the Order quantity, delivered quantity(Goods received) get them from following tables.

EKPO for PO items (it will have PO item details)

EKBE for GR (Goods Receipt) quantity and invoiced quantity

or

You have to read tables VBAP ( Order qty ) , Deliver qty ( LIKP or LIPS )

also check the below link

http://www.sapgenie.com/abap/tables_sd.htm

Regards,

Naveen