topic Re: Query - Delivered quantity in Application Development and Automation Discussions

Query - Delivered quantity

antonio_bruno — Mon, 19 Nov 2012 16:57:16 GMT

Hi,

i need to add to my query the field Delivered quantity (RV45A-VSMNG), the quantity from the schedule line that has already been delivered.

Is there a way to have a single value for a specific sales order position?

Thanks and best regards.

Antonio

Re: Query - Delivered quantity

Former Member — Tue, 20 Nov 2012 07:05:15 GMT

Hi Antonio,

I believe you can get delivered quantity from the Purchase Order directly from the concerned tables.

For sales order you can get open quantity from the table and substract it from the total quantity of the item and you get the deliivered quantity.

check the below link to find open quantity of sales order https://scn.sap.com/message/10290302

Regards,

Umar Syed.

Re: Query - Delivered quantity

antonio_bruno — Tue, 20 Nov 2012 07:56:26 GMT

Hy Umar,

Excuse me, i'm not an expert of abap. How can i calculate it?

Isn't there a way to obtain the field RV45A-VSMNG?

Because i need a single value for a specific sales order position, also for the position delivered. In the VBBE there are more datas for the single "planned" position (linked to the schedule line) .

Regards.

Antonio

Re: Query - Delivered quantity

Former Member — Wed, 21 Nov 2012 05:32:47 GMT

Hi Antonio,

RV45A is a Structure, so the value assigned here is always calculated and not availabe in any table.

as i said earlier you can calculate is as below

delivery quantity = total quantity - open quantity

( you should be albe to find open quantity in VBBE if you can compare the values in the Sales order and the table VBBE after partial delivery or may be check for any of the sales item tables to get it for a single position .)

Found an intresting link for your query. please check this out you might find it useful.

http://scn.sap.com/message/9376172

Regards,

Umar Syed.

Re: Query - Delivered quantity

antonio_bruno — Mon, 03 Dec 2012 09:45:44 GMT

Hi Umar,

i've solved with the VBFA.

In particular with the following code:

select sum( rfmng ) into (QTCON)

from vbfa where vbelv = vbap-vbeln

and posnv = vbap-posnr

and VBTYP_N = 'J'.