Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Table for sales order & status profile???

Go to solution
Former Member

‎09-24-2008 7:03 AM

0 Kudos

Hi,

Is there any table which links sales order number and status profile???

or

eg:::

Already sales order has been created with status profile ZSD003.

Now a new status profile is been created ZSDITM.

How to change the statusprofile for the already existing sale order having profile ZSD003 with the new status profile ZSDITM

being ZSD003 in grade out state.

Regards,

Pradeep.

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎09-24-2008 8:39 AM

0 Kudos

Hi Pradeep,

Use the FM BAPI_SALESORDER_GETSTATUS to get the sales order status details .

To get the Status profile.

Use VBAK-VBELN and get VBAK-OBJNR.

Use VBAK-OBJNR as JSTO-OBJNR and fetch JSTO-STSMA (STATUS PROFILE).

Regards

Arun

Edited by: Arun Thiyagarajan on Sep 24, 2008 1:09 PM

2 REPLIES 2

Go to solution
Former Member

‎09-24-2008 8:19 AM

0 Kudos

Hi Pradeep,

The status of the sales order is set in standard tables JEST and JSTO.You can change the status by usinf FM 'STATUS_UPDATE'. Here you have tables to insert new entries, updated and delete entries. Check in these table what is the default status and accordingly change the entries.

Thanks & Regards

Vijaya

Go to solution
Former Member

‎09-24-2008 8:39 AM

0 Kudos

Hi Pradeep,

Use the FM BAPI_SALESORDER_GETSTATUS to get the sales order status details .

To get the Status profile.

Use VBAK-VBELN and get VBAK-OBJNR.

Use VBAK-OBJNR as JSTO-OBJNR and fetch JSTO-STSMA (STATUS PROFILE).

Regards

Arun

Edited by: Arun Thiyagarajan on Sep 24, 2008 1:09 PM