topic Re: how to modify VBKD in Application Development and Automation Discussions

how to modify VBKD

Former Member — Fri, 10 Oct 2008 09:52:52 GMT

Hi at all,

i need to change "Terms of Payment Key", so I'm editing the "userexit_save_document" .

When I run VA02 I modify VBKD-ZTERM with posnr = '00000' and vbeln = vbak-vbeln, it runs well.

When I run VA01 I can't modify VBKD because the record with vbak-vbeln doesn't exist so the value ZTERM in VBKD is override from KNVV .

How can I modify the vbkd in VA01 ?

Re: how to modify VBKD

Former Member — Fri, 10 Oct 2008 10:03:34 GMT

Hi,

I think you can use the XVBAK structure in MV45AFZZ user exit include in that main program SAPMV45A. Please note that VBAK and XVBAK structures alternate in holding the data.

So first check if VBAK is initial if so use XVBAK.

Regards,

Pramod

Re: how to modify VBKD

Former Member — Fri, 10 Oct 2008 10:05:05 GMT

Hi,

Why you need to consider VBELN. Whatever you want to change will be applicable to only the sales order you are creating/changing. There are no other sales orders available here. Hence you can directly modify ZTERM value here.

Regards,

Ramesh

Re: how to modify VBKD

Former Member — Fri, 10 Oct 2008 10:05:38 GMT

you can use 'XXXXXXXXXX' as vbeln and 'XXXXXX' for posnr.

Re: how to modify VBKD

satsrockford — Fri, 10 Oct 2008 10:11:25 GMT

Hi,

Try FM 'VS_BT_VBKD_MODIFY' to modify the table VBKD.

try the FM 'J_1B_SD_SA_VBKD_COPY'.

Hope it helps...

regards

Satish

Re: how to modify VBKD

Former Member — Fri, 10 Oct 2008 10:24:03 GMT

you can use 'XXXXXXXXXX' as vbeln and 'XXXXXX' for posnr.

It doesn't work fine.

Edited by: Domenico Petronella on Oct 10, 2008 12:24 PM

Re: how to modify VBKD

Former Member — Fri, 10 Oct 2008 12:56:36 GMT

FM 'VS_BT_VBKD_MODIFY' modify the table VBKD but it doesn't insert any row ..

Have you any ideas ?

Re: how to modify VBKD

Former Member — Fri, 10 Oct 2008 13:01:19 GMT

I think you are using the wrong User exit. write your code in USEREXIT_SAVE_DOCUMENT_PREPARE

instead of USEREXIT_SAVE_DOCUMENT

regards,

Advait

Re: how to modify VBKD

valter_oliveira — Fri, 10 Oct 2008 13:05:09 GMT


READ TABLE xvbkd 
    WITH KEY vbeln = vbak-vbeln "or xvbak-vbeln
             posnr = '000000'.
IF sy-subrc NE 0.
  READ TABLE xvbkd WITH KEY posnr = '000000'.
ENDIF
MODIFY xvbkd TRANSPORTING field.

Use something similar to above code.

I think you are using the wrong User exit. write your code in USEREXIT_SAVE_DOCUMENT_PREPARE
instead of USEREXIT_SAVE_DOCUMENT

Correct.

Regards,

Valter Oliveira.

Re: how to modify VBKD

Former Member — Fri, 10 Oct 2008 13:07:46 GMT

I've just tried to use the prepare user exit.

it doesn't work fine

Edited by: Domenico Petronella on Oct 10, 2008 3:09 PM

Re: how to modify VBKD

Former Member — Fri, 10 Oct 2008 13:14:55 GMT

MODIFY xvbkd TRANSPORTING field.

Which line in the internal table? You're missing the index.

Re: how to modify VBKD

Former Member — Fri, 10 Oct 2008 13:19:54 GMT

Could you paste your code ?

regards,

Advait

Re: how to modify VBKD

Former Member — Fri, 10 Oct 2008 14:19:07 GMT

READ TABLE xvbkd

WITH KEY vbeln = vbak-vbeln "or xvbak-vbeln

posnr = '000000'

TRANSPORTING NO FIELDS. .

idx = sy-tabix.

IF sy-subrc NE 0.

READ TABLE xvbkd WITH KEY posnr = '000000'

TRANSPORTING NO FIELDS. .

idx = sy-tabix.

ENDIF.

move t_cond_pagamento to wa_xvbkd-zterm.

MODIFY xvbkd index idx from wa_xvbkd

TRANSPORTING zterm.

Re: how to modify VBKD

Former Member — Fri, 10 Oct 2008 18:53:14 GMT

change your code to below in save_document_prepare user exit

loop at xvbkd.

move t_cond_pagamento to xvbkd-zterm.

MODIFY xvbkd.

endllop..

Re: how to modify VBKD

Former Member — Fri, 10 Oct 2008 19:00:07 GMT


> READ TABLE xvbkd
>     WITH KEY vbeln = vbak-vbeln "or xvbak-vbeln
>              posnr = '000000'
>      TRANSPORTING NO FIELDS.              .
>      idx = sy-tabix.
> IF sy-subrc NE 0.
>   READ TABLE xvbkd WITH KEY posnr = '000000'
>      TRANSPORTING NO FIELDS.              .
>      idx = sy-tabix.
> ENDIF.
> move t_cond_pagamento to wa_xvbkd-zterm.
> MODIFY xvbkd index idx from wa_xvbkd
> TRANSPORTING zterm.

Does that work or doesn't it?

Re: how to modify VBKD

Former Member — Sun, 12 Oct 2008 10:27:43 GMT

Hi,

READ TABLE xvbkd 
WITH KEY vbeln = vbak-vbeln "or xvbak-vbeln
posnr = '000000'
TRANSPORTING NO FIELDS.
idx = sy-tabix.
IF sy-subrc NE 0.
READ TABLE xvbkd WITH KEY posnr = '000000'
TRANSPORTING NO FIELDS. 
idx = sy-tabix.
ENDIF.
move t_cond_pagamento to wa_xvbkd-zterm.
MODIFY xvbkd index idx from wa_xvbkd
TRANSPORTING zterm.

The program generally runs for one sales order at a time, so using the vbak-vbeln for seraching the record is really not needed here and only posnr = '000000' should be enough for VA01 as well as VA02.

If it still doesn't work then you try to loop at xvbkd as mentioned above.

regards,

Advait

Re: how to modify VBKD

Former Member — Mon, 13 Oct 2008 10:53:32 GMT

Now it works fine.

Thanks a lot.