topic Re: BDC in Application Development and Automation Discussions

BDC

Former Member — Thu, 22 Feb 2007 06:23:36 GMT

Hi all,

I am in a fix and need your help.

I had created a screen through which user may enter data, that is stored in a Z-Table which I created .

In another screen on clicking on SAVE button, the same data is uploaded through BDC to a transaction (MB11).

Suppose I had stored <u>Qty = 10</u> while storing the data in Z-Table, but while running the BDC, I choose to change (OR I have to change) Qty from 10 to 2 (i.e. now <u>Qty = 2</u>).

Now, the problem is that, I want to store (or replace) the changed value in my

Z-Table i.e. 2 in place of 10 in the correct position.

I thought of finding some link between the Z-Table and MSEG, MSEG also has one of the primary field of Z-Table, but since it's not in the transaction MB11, it is not filled when running the BDC.

Please suggest asap.

Re: BDC

Former Member — Thu, 22 Feb 2007 06:28:10 GMT

Hi Amit,

Store the value in a variable, and after CALL TRANSACTION statement in your BDC program write an UPDATE statement to reflect the changes in the Z-TABLE.

Hope this works.

Regards,

Sandeep Shenoy

Re: BDC

Former Member — Thu, 22 Feb 2007 06:34:58 GMT

hi,

one suggestion may be,you go to the bdcrecx1 include of your bdc program create a form for updating the z-table using UPDATE command. come to the main program and call the form after call transaction or create session perform.

just try this.

regards,

pankaj singh

Re: BDC

Former Member — Thu, 22 Feb 2007 06:54:48 GMT

Use Call Transaction mothod.

Anyhow you are passing data from Ztable records one by one to BDC.

Check whethr the transaction is succesful, if it is successul then using update the record in Ztable using update command.

Call transaction ......

If sy-subrc = 0.

Update Ztable set qty = g_qty

where <condition>.

endif.