topic Re: about data for blocked sales order in Application Development and Automation Discussions

about data for blocked sales order

Former Member — Fri, 09 Jan 2009 09:54:25 GMT

hi friends,

i have one requirement . i.e i want to create the BLOCKED SALES ORDER , whate are the fields require for the creation.

if there is any BAPI for this please tell me.

help me

naresh

Re: about data for blocked sales order

Former Member — Fri, 09 Jan 2009 09:59:47 GMT

HELLO NO ONE IS THERE .PLZ .....

HELP ME.

Re: about data for blocked sales order

GauthamV — Fri, 09 Jan 2009 10:06:28 GMT

hi,

use VBUK table

VBUK-SPSTG = C.

Re: about data for blocked sales order

Former Member — Fri, 09 Jan 2009 10:07:54 GMT

hi,

In VBUK table check the sales order (SPSTG = C)

Try below tcodes.

VE31 Blocked SD Documents

VKM1 Blocked SD Documents

V.14 Sales Orders Blocked for Delivery

V23 Sales Documents Blocked for Billing

VA14L Sales Documents Blocked for Delivery

thanks

Re: about data for blocked sales order

Former Member — Fri, 09 Jan 2009 10:08:38 GMT

hi,

when your are creating sales order press enter,

it shows what are mandatory fields.

other than that dont worry, with the materail number every thing takes automatically.

Re: about data for blocked sales order

SujeetMishra — Fri, 09 Jan 2009 10:13:44 GMT

Hello Naresh.

You can Show your blocked Sales order Using table MVKE(Sales Data for Material) and TVMS(Materials: Status in Sales and Distribution).

Logic is :1. Check Field MVKE-VMSTA.

2. find corresponding entries of MVKE-VMSTA in Table TVMS.

by matching MVKE-VMSTA = TVMS-VMSTA.

3. For Above same Entries see the Blocked check in Field TVMS-SPVBC.

IF TVMS-SPVBC = 'B' means this sales order is blocked.

and check all matnr of MVKE according to this logic.

In case any Problem,you can let me know so that i can help you in better ways.

Have a Nice Day,

Regards,

Sujeet.

Re: about data for blocked sales order

Former Member — Fri, 09 Jan 2009 10:18:35 GMT

hi SUJEET thanks for your response,

i want to display that blocked sales order by using the VBUK table .

is there any BAPI for that blocked sales order .

if not what are all the fields need to display

Re: about data for blocked sales order

GauthamV — Fri, 09 Jan 2009 10:22:09 GMT

use this

[bapi for block sales oder details|https://forums.sdn.sap.com/click.jspa?searchID=20755144&messageID=2477502]

Re: about data for blocked sales order

Former Member — Fri, 09 Jan 2009 10:23:06 GMT

hi SUJEET thanks for your response,

i want to display that blocked sales order by using the VBUK table .

is there any BAPI for that blocked sales order .

if not what are all the fields need to display

Re: about data for blocked sales order

SujeetMishra — Fri, 09 Jan 2009 10:41:31 GMT

Hello Naresh,

use BAPI "BAPI_SALESORDER_GETSTATUS" to get your sales order.

and then loop accordingly blocked condition.

FSSTK,LSSTK,SPSTG these fields of VBUK is for showing blocked order.

you can use this also.

Regards,

Sujeet

Re: about data for blocked sales order

SujeetMishra — Fri, 09 Jan 2009 10:43:45 GMT

Naresh,

fields will be totally based on your client's Requirements. whatever fields they need you display only same accordingly blocked condition which i told you.

Regards,

Sujeet