cancel
Showing results for 
Search instead for 
Did you mean: 

Changing status for outbound delivery

Former Member
0 Kudos
2,970

Hi all,

My requirement is for a given delivery nummer(vl02n)i have to check the status(all fields) in VBUP and VBUK tables and change all staus from A or B to C and save in the database through se16.

Please kindly help me how to proceed this requirement.

regards

chandu.

Accepted Solutions (1)

Accepted Solutions (1)

former_member181962
Active Contributor
0 Kudos

Hi sai,

You cannot update the tables directly(In se16).

You need to write a program and use the bapi

BAPI_OUTB_DELIVERY_CHANGE, to chage anythig related to outbound delivery.

Regards,

Ravi Kanth

Former Member
0 Kudos

hi ravi,

Thanks for ur reply .I know i have to write program.But i cant find BAPI you have given in my system 4.6c.

and for the tables VBUK VBUP i have to check all status fields.

please advise.

regards

chandu.

Former Member
0 Kudos

Hi anid,

Thanks for ur reply.

But i have to check all status fields.

Any optimized method to check.

regards

chandu.

Former Member
0 Kudos

HI,

go to se11 or se16>ctrlshiftF10> put your VBELN number in the S"D document"->f8..here you can see the values..

or i am missing something...follow the proceedure and let me know if you want to mean something else by "i have to check all status fields"..

thanks

former_member181962
Active Contributor
0 Kudos

Hi Sai,

If you have indeed chosen to use the update otion, then you need to set the new values for each field

eg:

UPDATE SCUSTOM SET RFSTA

RFGSA = 'B'

BESTA = 'B'

LFSTA = 'B'

LFGSA = 'B'

WBSTA = 'B'

FKSTA = 'B'

FKSAA = 'B'.

Former Member
0 Kudos

Hi Anid,

Let me explain you clearly.

For a given delivery nummer in VBUP and VBUK i have a lot sttus fields.

to say in VBUP

wbstk,fkstk,lfsta,etc...

So my requirement is to check all those fields which are not null and if have status A or B then i must update to C.

I hope now its clear..

Thanks and regards

chandu.

Former Member
0 Kudos

Hi,

for checking the values>go to <b>se16n</b> (instead of se16)>

enter table name as (<b>VBUP</b>)> in SALES DOCUMENT field enter your <b>vbeln</b> value(s)>execute--> you will find the status record --> in a nice grid layout.

cheers.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Sai,

You can use FM BAPI_INB_DELIVERY_CHANGE for changing the status.

Can refer to the FM Documentation.

Regards,

Raj

Former Member
0 Kudos

if LFSTA is the status field..then

just run this code from se38.

all entries will be updated in ne shot

update VBUP set LFSTA = 'C'

where ( LFSTA = 'A' or

LFSTA = 'B' )

and VBELN = 'your delvery number' .

update VBUK set LFSTA = 'C'

where ( LFSTA = 'A' or

LFSTA = 'B' ).

and VBELN = 'your delvery number'.

commit work.