about data for blocked sales order

[Former Member]

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

[Former Member]

hi,

use VBUK table

VBUK-SPSTG = C.

[Former Member]

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

HELP ME.

[GauthamV]

hi,

use VBUK table

VBUK-SPSTG = C.

[Former Member]

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

[Former Member]

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.

[SujeetMishra]

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.

[Former Member]

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

[SujeetMishra]

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

[Former Member]

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

[GauthamV]

use this

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

[SujeetMishra]

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