BDC

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.