Issue related to BDC Process & Locking Z-tables

[Former Member]

Hi All,

I have couple of issues.

<b>1.</b> I Have one issue in BDC I am running a CALL Transaction Method for one BDC program.

In that if the process is successful or not i am creating a error Log in SM35.

If the above CALL Transaction for BDC is successful i am updating 2 Z-Tables and if it unsuccessful i am creating a session[Error Log] in SM35 through Session Method.

Now what i want is when if above CALL Transaction fails then Z-Tables will not be updated.

Then user will go to SM35 and modify the log and Re-Process BDC from SM35. But here Z-Tables will not get updated though now process will run successfully.

Means if the BDC fails, these updates to the Z-tables never happen even if we re-process the BDC & then we have an out of Sync condition.

2. In the same program i am updating Z-Tables so what i want is to Lock that Z-Table while i am updating then release them after successful updation.

What is the step-by-step procedure for the same!

Can anybody give the solutions for the above issues.

Thanks in advance.

Thanks & Regards,

Prasad.

[former_member223537]

Hi Prasad,

1. Goto transaction SE11.

2. Create a lock object with name as EZ****

3. In the lock object specify the table name.

4. Activate the same.

5. Automatically 2 FM`s would be created. Viz. ENQUEUE_EZ****** and DEQUEUE_EZ******.

While locking the table , you can lock it at table level or record level.

6. So call FM ENQUEUE_EZ****** and pass the primary keys for which you want to lock the table.

7. Do the processing viz. updating table etc.

8. Unlock the table using DEQUEUE_EZ******

Best regards,

Prashant

[Former Member]

Solution for your first issue, I see it as a program which is scheduled as a job, checks the status of the each execution in transaction(probably checking from tables which are updated by BDC) and making changes to your Ztable.

Second one you can create lock objects in SE11 and there after use those in your program.

Hope this throws some light to your issue.

Cheers,

Thomas.

[Former Member]

HI,

For 1st issue how can i update entries in Z-Tables when BDC Fails.

And then i have to correct and run Error Log from the SM35.

In this case Z-Tables will not be updated!

So what can be the solution to this issue!

Thanks,

Prasad.