topic Re: Displaying Total Stoc & Open Order Quantity while creating SO in Application Development and Automation Discussions

Displaying Total Stoc & Open Order Quantity while creating SO

Former Member — Fri, 28 Nov 2008 11:35:36 GMT

Dear Experts,

we have requiremet that while creating SO (VA01) for each item it sould show the message (Popup Screen) about Total Stock & Total Open Oder quantity for that material when user enters the material, plant & storage location in line item.

Please let me know your ideas in detail if anyone knows about this....

Thanks in Advance

Best Regards

Venkatesh

Re: Displaying Total Stoc & Open Order Quantity while creating SO

agnihotro_sinha2 — Fri, 28 Nov 2008 11:43:02 GMT

hi,

you will need a user_exit or find a BADI for this purpose....

Search one as it will need some time.

ags.

Re: Displaying Total Stoc & Open Order Quantity while creating SO

Former Member — Mon, 01 Dec 2008 01:17:44 GMT

Hello Venkatesh,

You can use userexit USEREXIT_MOVE_FIELD_TO_VBAP in include MV45AFZZ. This user exit is executed every time the user enters item data and hits return. The VBAP data is available in structure xvbap.

xvbap-kwmeng contains the ordered qty. for that item

xvbap-kbmeng contains the confirmed qty. for that item

I am not so sure in regard of the available stock qty. because it depends on your stock set up (e.g. batch stock, etc.) but you should be able to figure that out.

Just check, if the required xvbap fields are populated and then raise the popup which displays the information to the user.

Hope that helps,

Michael

Re: Displaying Total Stoc & Open Order Quantity while creating SO

Former Member — Mon, 01 Dec 2008 04:10:36 GMT

Hello Michael,

The purpose of this is to display Available Stock = Total Stock (MARD-LABST) - Total Open Order Quantity (VBBE-OMENG) when user enters the Material No, Plant and Storage Location while creating Sales Order, this is because to know the user whether stock of the material is available or not for the specific Plant and Storage Location.

please let me know if know the suitable exit for this requirement.

Best Regards

Venkatesh

Re: Displaying Total Stoc & Open Order Quantity while creating SO

Former Member — Mon, 01 Dec 2008 04:18:19 GMT

Hi V ,

in addition to Michael , u can use program MV45AFZZ , to raise popup message after going all ur validations , check for form DOCUMENT_PREPARE, but one thing u need to know is , dont raise any error msgs , If you raise error msgs , user cannt change the values in that screen.

regards

Prabhu