on 05-25-2006 8:18 PM
Where can get actual delivery and ordered qty fields.
Thanks
Vikranth
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<b>VBAP Order qty Against material number
Deliverqty LIPS Against material number</b>
Hope thisll give you idea!!
<b>P.S award the points.</b>
Good luck
Thanks
Saquib Khan
"Some are wise and some are otherwise"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.