topic Re: BAPI doesn't write data to database? why? in Application Development and Automation Discussions

BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 10:01:54 GMT

Hi,

I am using my web dynpro app to call BAPI_PR_CREATE, BAPI_RESERVATION_CREATE1.

all the input is right, and it returns me a Purchase No, and Reservation No, but when i check the number against the database, they have not been created.

why is this happening? how to solve?

thanks!

Re: BAPI doesn't write data to database? why?

GauthamV — Thu, 23 Oct 2008 10:03:13 GMT

hi,

you have to use this function module to update database.

BAPI_TRANSACTION_COMMIT.

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 10:04:24 GMT

Hi,

Use the BAPI, BAPI_TRANSACTION_COMIT also after the other bapis. give wait = 'X'.

Also chek if you are getting any Update Terminated messages.

Regards,

Renjith Michael.

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 10:05:29 GMT

Hi:

Commit work is required.

Regards

Shashi

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 10:08:41 GMT

Hi,

Check whether a commit work is required.

While executing in se37,Select Test Sequences from se37 menu .Give BAPI_PR_CREATE, BAPI_TRANSACTION_COMMIT and then execute it one by one.

if we are using the bapi in a report,then u can use commit work command .

Regards,

Rachel

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 11:00:07 GMT

thanks for the replies

what is the "WAIT" for here?

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 11:06:21 GMT

Operations that change the database must be carried out through the updating process. Otherwise, thereu2019s a risk that both unchecked and unwanted database COMMITs are executed during the RFC call.

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 11:08:19 GMT

read documentation fro the BAPI. Wait = 'X' will wait untill all DB updates are finished. you can fdecide to use that depends on your requirements

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 12:18:47 GMT


While executing in se37,Select Test Sequences from se37 menu .Give BAPI_PR_CREATE, BAPI_TRANSACTION_COMMIT and then execute it one by one.
if we are using the bapi in a report,then u can use commit work command .

i m no sap gui expert, how to do this exactly.

i add BAPI_PR_CREATE and BAPI_TRANSACTION_COMMIT one by one to the list

then i excute it, i chose a set of test data from the list where it's going to provide me with a correct result.

then click excute, the PR_CREATE got excuted

then how to proceed to the next level?

thanks

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 12:27:53 GMT

execute again and bapi_transaction_commit is executed

kind regards

arthur

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 12:28:33 GMT

Hi,

Check my post in wiki for how to do it

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/function%2bmodule%2btest%2bsequence

Regards,

Sachin

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 13:12:14 GMT

after i execute the first one, i click back, then execute the Transaction_Commit, but the returns table is empty, doesn't tell me it's error or success?

any advice?

but thanks everyone for the input so far!

<removed_by_moderator>

Edited by: Julius Bussche on Oct 23, 2008 3:18 PM

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 13:24:27 GMT

you would not be able to use SE37 to test it. once you press back there, the buffer is gone, and BAPI_TRANSCATION_COMMIT has no effect.

You need to test it from your calling program

call BAPI 1

commit BAPI ( if you need data from 1st BAPI in 2nd call )

Call BAPI2

commit BAPI

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 13:51:01 GMT

yes, i tried it in my program.

execute bapi_pr_create

excute bapi_transaction_commit

then try to debug the commit return table, table is empty except for some initial 000s

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 13:52:57 GMT

thats fine, commit return table will be empty unless there are some errors

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 13:59:30 GMT

and is the return table of BAPI_PR_CREATE also empty ??

kind regards

arthur

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 14:21:52 GMT

That you need to check. You can set external break-points in BAPI, so can chek whats happenign in the BAPI

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 15:54:13 GMT

it's working fine now

the BAPI_PR_CREATE return table is not empty, it returns "s"

but i really want to know how to test bapis and commit them in se37

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 15:56:15 GMT

you cant do Commit in SE37. SE37 can give you the idea if the db posting will be successfull or not, but it would nto commit that.

come to think of that you woudlnt want someone to update Database usign SE37 , right?

Re: BAPI doesn't write data to database? why?

Former Member — Thu, 23 Oct 2008 16:04:52 GMT

it's working, following the wiki page.

it can be committed with test sequence

thanks everyone for the input i m closing the questions now.