Posts

Showing posts from June, 2024

Enqueue and dequeue in SAP ABAP

Image
Enqueue - It is used to lock the database while updating the database. Because values are not overlapped. Dequeue - It is used to unlock the database after updating the database. In This scenario I am updating the date in database TVARVC. Report     REPORT  zab_rp_enqueue_dequeue .      PARAMETERS :   p_date  TYPE  sy - datum .      CONSTANTS :   g_c_po_date  TYPE  string  VALUE  'ZAB_DATE1' .      DATA ( lv_year )  =  p_date+0 ( 4 ) .      DATA ( lv_mon )  =  p_date+4 ( 2 ) .      DATA ( lv_date )  =  p_date+6 ( 2 ) .      CONCATENATE  lv_year lv_mon lv_date  INTO  DATA ( lv_final ) .      CALL  FUNCTION  ' ENQUEUE_E_TABLE '        EXPORTING         mode_rstable    =  'E'         tabname         =  'TVARVC'        EXCEPTIONS         foreign_lock    =  1         system_failure  =  2          OTHERS          =  3 .        IF   sy - subrc  =  0 .        UPDATE  tvarvc  SET  low  =  lv_final  WHERE  name  =  g_c_po_date .        IF   sy - subrc  =  0 .