how will you go for row level locking of a z table
Answers were Sorted based on User's Feedback
Answer / kubera naidu
Hi Swapna,
1)Create a lock object, suppose EZLOCK in SE11 for the table
ZLOCK (having fields..field1, field2, field3).
2)Activate it, system will automatically generates two
function modules for locking and unlocking.
3) How to use them in program ?
Here you go..
loop at itab into wa_tab.
* For Locking the table ZLOCK
CALL FUNCTION 'ENQUEUE_EZLOCK'
EXPORTING
mode_ZLOCK = 'E'
mandt = sy-mandt
field1 = wa_zlock-field1
field2 = wa_zlock-field2
field3 = wa_zlock-field3
EXCEPTIONS
foreign_lock = 1
system_failure = 2
OTHERS = 3.
* For Unlocking the table ZLOCK
CALL FUNCTION 'DEQUEUE_EZLOCK'
EXPORTING
mode_ZLOCK = 'E'
mandt = sy-mandt
field1 = wa_zlock-field1
field2 = wa_zlock-field2
field3 = wa_zlock-field3
endloop.
Regards,
Kubera Naidu.
Is This Answer Correct ? | 19 Yes | 2 No |
Answer / balraju
by using an function module enqueue_table name inside a loop
end loop
Is This Answer Correct ? | 6 Yes | 4 No |
9) We give KEEP in BDC structure...what is its purpose?
How to attach a search help? how can you validate the entries in TMG?
What are the contents in technical specifications?
what is meant stacked list?
1.why dont use top of page. wat is the use? 2. wat is sub screen? 3. why u select the session method in bdc ? how many records wil be updated on that time? 4.why dont use start form in script? 5.wat is difference b/w dilldown and interactive report? 6. wat is pf status interactine report?
Can we use flow logic control key words in abap/4 and vice-verse?
please clear this what is the diff b/w select single * and select up to 1 row?
how to replacing the BDC with the BAPI, wherever possible
What is abap?
What is open sql?
How to transfer data which is coming from are report as output to another report
Which transaction code can I use to analyze the performance of abap program?