topic Re: ABAP: VBAP table data modify in Application Development and Automation Discussions

ABAP: VBAP table data modify

aneel_munawar — Tue, 28 Oct 2014 11:21:46 GMT

Dea All,

Can I modify data of VBAP table .? I want to change the FKREL field from A to C.

Regards,

Aneel

Re: ABAP: VBAP table data modify

Former Member — Tue, 28 Oct 2014 11:59:09 GMT

Moderator message: updating standard SAP table directly is a silly thing to do, and it is equally silly to advise others to do it.

Hello

go to se38-> type UPDATE-> hit F1.

*------------------------

TABLES VBAP.

UPDATE VBAP SET FKREL = 'C'

WHERE FKREL = 'A' .

*------------------------

regrads

faiz rahman

Moderator message: updating standard SAP table directly is a silly thing to do, and it is equally silly to advise others to do it.

Message was edited by: Matthew Billingham

Re: ABAP: VBAP table data modify

Former Member — Tue, 28 Oct 2014 12:01:26 GMT

Moderator message: updating standard SAP table directly is a silly thing to do, and it is equally silly to advise others to do it.

Hi,

If you are trying to multiple records then you can use the above logic which has suggested by Anish otherwise if you are trying to modify few records then please follow this process. its very simple.

in se11-> display the records whatever data you want to modify->enter /h in command box and select enter->then it will get the debugging mode->there change the value of Code(initally the value will be 'SHOW').

code = EDIT then you will get change mode there you can change the data.

Thanks & Regards,

Polu

Moderator message: updating standard SAP table directly is a silly thing to do, and it is equally silly to advise others to do it.

Message was edited by: Matthew Billingham

Re: ABAP: VBAP table data modify

Former Member — Tue, 28 Oct 2014 12:45:52 GMT

The question you should be asking, is "should you modify data of table VBAP"... The answers you have received so far make me cry.

There is a massive gap between what you can technically do on a system, and what you should actually do. There are all sorts of reasons why direct updates of standard SAP tables are bad. If you search, you will find lots of discussions about them.

Cheers,

Re: ABAP: VBAP table data modify

Former Member — Tue, 28 Oct 2014 12:47:17 GMT

Hi Polu,

Are you suggesting that using debug to work around authorisation checks and directly update a standard SAP table is something you would actually consider doing on your's/your customer's systems?

Cheers,

Re: ABAP: VBAP table data modify

Former Member — Tue, 28 Oct 2014 13:01:36 GMT

Can I modify data of VBAP table .?

Yes.

Should I modify data of VBAP table .?

Can you explain your requirement? what do you want to achieve?

Re: ABAP: VBAP table data modify

Lakshmipathi — Tue, 28 Oct 2014 13:05:22 GMT

If you can explain the business process as to why you want to change in table instead of achieving via standard configuration, suitable suggestion can be given. Also, you have not indicated at which stage you want to change. After saving the sale order or creation of subsequent document ? Need more detailed explanation

G. Lakshmipathi

Re: ABAP: VBAP table data modify

Colleen — Tue, 28 Oct 2014 13:21:35 GMT

I'm not a developer and I can see why some client sites have the developers sit a test before they are provided with a developer key and S_DEVELOP access.

Re: ABAP: VBAP table data modify

FredericGirod — Tue, 28 Oct 2014 13:29:53 GMT

You know, it's a place for developper here, only developper

sorry, hard day today

Fred

Re: ABAP: VBAP table data modify

Former Member — Tue, 28 Oct 2014 13:30:11 GMT

You should not change the transactional data of client directly from the table as all these changes are get stored and at the time of audit can cause issues. Ask your functional consultant to do it through front end.

Thanks

Re: ABAP: VBAP table data modify

RaymondGiuseppi — Tue, 28 Oct 2014 13:36:07 GMT

Did you try BAPI_SALESORDER_CHANGE.

NB: Don't update standard tables with OPEN-SQL statement, for database sake (or just database consistency)

But why do you want to change this field, is its valued determined thru Customizing (VOV7 ?) as well as history/flow of documents, so you should change other fields (e.g. ) to get this result. Ask functional to perform this requirement thru VA02, if they cannot, close.

Regards,

Raymond

Re: ABAP: VBAP table data modify

matt — Tue, 28 Oct 2014 13:58:30 GMT

Hopefully my editing of those responses will allow you to dry your eyes. I was going to reject them, but I think I'll leave them with my comment, pour encourager les autres.

Re: ABAP: VBAP table data modify

aneel_munawar — Wed, 29 Oct 2014 04:37:42 GMT

Dear All,

Thanks for your reply and help. I dont want to update the table by using direct sql. I want to use BAPI. I have used the fillowing code . The system gives message that order has been updated but when I open the table, the data is not updated. The code is given below. Remember that I want to change the field 'FKREL' of VBAP table from 'A' to 'C'.

Regards,

Aneel

report zaneel.

data: t_item like bapisditm occurs 0 with header line.

data: t_itemx like bapisditmx occurs 0 with header line.

data: t_return like bapiret2 occurs 0 with header line.

data: bapisdh1x like bapisdh1x.

data: t_vbap like vbap occurs 0 with header line.

bapisdh1x-updateflag = 'u'.

t_item-itm_number = '10'.

t_item-bill_rel = 'A'.

append t_item. t_itemx-itm_number = '10'.

t_itemx-updateflag = 'u'.

t_itemx-bill_rel = 'C'.

append t_itemx.

call function 'bapi_salesorder_change'

exporting

salesdocument = '0020000085'

order_header_inx = bapisdh1x

tables return = t_return

order_item_in = t_item

order_item_inx = t_itemx .

loop at t_return where type = 'e'

or type = 'a'.

exit.

endloop.

if sy-subrc = 0.

write: / 'sales order not updated',

t_return-message.

else.

write: / 'sales order updated'. endif.

commit work.

Re: ABAP: VBAP table data modify

Former Member — Wed, 29 Oct 2014 04:53:45 GMT

Agreed ,

Rather than rejecting these threads should be highlighted like this only.

This will make people stop themselves and think twice before posting any REALLY SILLY answers like this.

And this will even make them smile when after having a long experience with SAP they turn back their earlier pages in SCN.

Re: ABAP: VBAP table data modify

Former Member — Wed, 29 Oct 2014 05:40:16 GMT

t_item-bill_rel = 'A'. < --- this should be 'C'

t_itemx-bill_rel = 'C'. <-- this you try 'U" and 'X', one of them should affect.

Re: ABAP: VBAP table data modify

aneel_munawar — Wed, 29 Oct 2014 05:48:11 GMT

I used this code then even data not changed.

REPORT zaneel.

DATA: t_item LIKE bapisditm OCCURS 0 WITH HEADER LINE.

DATA: t_itemx LIKE bapisditmx OCCURS 0 WITH HEADER LINE.

DATA: t_return LIKE bapiret2 OCCURS 0 WITH HEADER LINE.

DATA: bapisdh1x LIKE bapisdh1x.

DATA: t_vbap LIKE vbap OCCURS 0 WITH HEADER LINE.

bapisdh1x-updateflag = 'U'.

t_item-itm_number = '000010'.

t_item-bill_rel = 'A'.

APPEND t_item.

t_itemx-itm_number = '000010'.

t_itemx-updateflag = 'U'.

t_itemx-bill_rel = 'X'.

APPEND t_itemx.

CALL FUNCTION 'BAPI_SALESORDER_CHANGE'

EXPORTING

salesdocument = '0020000085'

order_header_inx = bapisdh1x

TABLES

return = t_return

order_item_in = t_item

order_item_inx = t_itemx.

COMMIT WORK.

LOOP AT t_return WHERE type = 'e'

OR type = 'a'.

EXIT.

ENDLOOP.

IF sy-subrc = 0.

WRITE: / 'sales order not updated',

t_return-message.

ELSE.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

EXPORTING

wait = 'X'.

WRITE: / 'sales order updated'.

ENDIF.

COMMIT WORK.

Re: ABAP: VBAP table data modify

Former Member — Wed, 29 Oct 2014 05:54:22 GMT

t_item-bill_rel = 'A'.

Shouldnt this be 'C'?

Also try to debug to see if this value is passed onto vbap-fkrel or else you'll have to use some exit or badi for the same

Re: ABAP: VBAP table data modify

aneel_munawar — Wed, 29 Oct 2014 06:11:41 GMT

It should become 'A'. but it is not working.

Regards

Aneel

Re: ABAP: VBAP table data modify

Lakshmipathi — Wed, 29 Oct 2014 06:24:12 GMT

As I said already, with the functional configuration itself, this is possible but you need to answer to my queries already raised. When some requirement can be achieved via functional configuration, why you are going for customized one?

G. Lakshmipathi

Re: ABAP: VBAP table data modify

aneel_munawar — Wed, 29 Oct 2014 06:33:27 GMT

I want to change by using BAPI. Why above code is not working.?

Regards,

Aneel