Query - Delivered quantity

[antonio_bruno]

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

[Former Member]

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.

[antonio_bruno]

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

[Former Member]

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.

[antonio_bruno]

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'.