Delivered Qty Field in Schdule Line

[Former Member]

Hello All,

Can any one tell me from where the value will be updated for this field in the Schedule line sin sales order, my ABAPER needs name for this field "Delivered Qty" .

Thanks & Regards,

Sundu

[Former Member · Accepted solution]

Hi Sorry,

First system copies ordered qty and decides the scheduled qty as per the availability and confirms the same. once the confirmed qty delivered to the customer. the delivery qty field will be updated.

Muthu

Edited by: Muthupandiyan on Feb 18, 2008 2:50 PM

[Former Member]

Hi,

This can be achieved in following ways.

1. use table VBAK and VBFA-RFMNG. That is Sales order quantity and the summation of delivery quantities from VBFA.

2. Use the bapi - BAPI_SALESORDER_GETSTATUS.

Since the Delivery Quantity is coming from structure you need to ask your abaper to do this to get the Delivery Quantity in the report.

Thanks

Krishna.

Edited by: Krishnamurthy Natarajan on Feb 18, 2008 11:36 AM

[Former Member]

hi..

1) why you did not take LIPS-LFIMG

2) u can get delivered quantity...through VBFA(salesdocument flow table)

VBFA-VBELV(sales order)... then u will get deliver document VBFA-VBELN, VBTYP_N=J... take that delivery document number and then go to LIPS-LFIMG.

RAVI..

[Former Member]

Hi Sundar,

Say you are working in MTS (Make to Stock) scenario & have created a sales order for 10 pieces. The plant has stock of more than 10 pieces so the system will automatically allot or confirm 10 pieces for the sales order. In this case when you see the schedule line data of the sales order item the system will show you as under:

18/02/2008(a) 10(b) 10(c) 10(d)

Column a - Delivery date

Column b - Order qty.

Column c - Rounded Qty.

Column d - Confirmed Qty.

The system will only allow you to create a delivery for the sales order item only if it finds at least a single confirmed qyantity for the date on which the delivery is being created. (The delivered qty. field is blank as no delivery has been created)

Go to VL01N & create a delivery for only 5 pieces & save it. Now go to VA02 - select the sales order no. - enter - double click on the line item - go to schedule lines - here you will see 5 in the delivered qty. field. Even if you don't do the PGI then also the system will create an entry in the delivered qty. field. This is how the system creates an entry in the delivered qty. field.

FIELDS:

The delivered qty. field is VBEPD-VSMNG. Now you won't fin this field VSMNG in the sales order item table. In the table VBEP & VBAP you will find the following fields which can be used to relate the 2 tables to complete the logic.

VBELN - sales order

POSNR - Sales Document Item

MATNR - Material Number.

Tell your ABAPER to use the 3 fields mentioned above to relate the 2 tables VBEP & VBAP.

Hope this clarifies your doubt.

Reward points if solution helps.

Regards,

Allabaqsh G. Patil

[Former Member]

Hi,

The field for the "delivery Qty" is VSMNG

and the table name is VBEPD.

To view this table and field ,go to transaction "SE11",

enter the table VBEPD and to will get lists of all fields in this table.

Here You will find field VSMNG for delivery qty.

for any queries or clarifications,revert back.

Thanks and Regards,

Umesh Karane.

[Former Member]

Hi Umesh Karane,

But this is a stracture , what we are looking for a database table, because we need to restrict in our programme by the value in this filed.

Thanks & Regards,

Sundu

[Lakshmipathi]

Dear Sundar

May be if you can tell your process and what you need from that, may be some solution could be given.

If you want to track just what is delivered quantity against ordered quantity, the same can be achieved through SE16 / SQVI itself.

thanks

G. Lakshmipathi

[Former Member]

Dear Lakshmipati,

We have requirement like this we have program for Back order scheduling from the standard one V_V2 but in our z_Porgram we are trying to check customer opening hours in to consideration, but when ever we run this Z program it is updating the schedule line date for which there is already qty are delivered, so we have to stop this updating date in the schedule line. So we are looking for this field for ABAPER.

Thanks

Sundu

[Former Member]

Hi,

To find the delivered qty need to be small calculation.

Take your sales document number ( VBAK-VBELN), pass to VBFA table by giving inputs to fields

VBELV (Preceding sales and distribution document) enter sales document numbers here

VBTYP_N (Document category of subsequent document) select J here

and execute the table now you will find the output for this

check field RFMNG (Referenced quantity in base unit of measure).

so Pick all the following document numeber for this selection.

eg:

Preceding doc. Preceding item Follow-on doc. Subsequent item Subs.doc.categ. Quantity

Example :

Prece doc. Follow doc. Subs.doc.categ. Qutity

0000000082 0080000075 J 15,000

0000000082 0080000075 J 15,000

Kindly Reward points if usefull.

Regards

vK

[Former Member]

Hi Sundar,

From the defination of a Structure,

Structures that are used more than once can be changed centrally because they were defined centrally.

ABAP programs or screen templates that use a structure are automatically adjusted when the structure changes.

So you modify the structure and try to put the condition you want on this component ie field "delivery qty" in the Structure ,so that this will take care of your condition in the Schedule line Screen of the Sales order Document.

Incase of queries or clarifications revert back.

Thanks and Regards,

Umesh Karane.

.

[Lakshmipathi]

Dear Sundar

The field name for "Delivered Qty" is VSMNG (Table RV45A). This field will be updated as and when PGI is done in delivery.

thanks

G. Lakshmipathi

[Former Member]

Hi Lakshmipathi,

I need the name of this filed in the sales order schedule line level ? or bcz we need to restrict something in the program when this field has some value so how can i know the name of the Delivered Qty Technical field name??

[Lakshmipathi]

Dear Sundar

The technical name at schedule line level for "Delivered Qty" is VSMNG (Table VBEPD)

thanks

G. Lakshmipathi

[Former Member]

Dear G. Lakshmipathi,

I can not see this table VBEPD from the transaction se16n , is there any way we can find.

Regards,

Veer

[Former Member]

Hi Sundar,

This field is updated after doing the deliver for this order..

For Ex: the ordrr containing 100 items u created delivery for 60 items, after saving the delivery and see this field in order there that means in this delivery qty field is updated with 60 Qty..

I hope it is cleared..

Rewards, if it is useful..

Regards

Durga Prasad