Posts

Showing posts from August, 2021

MySQL : Stored Procedure Array Parameter In Where Clause

Define Stored Procedure : DELIMITER $$ CREATE PROCEDURE GetVendor(IN pRegid TEXT) BEGIN   SET @sql = CONCAT('SELECT * FROM vendorMaster WHERE regid IN (', pRegid, ')');   PREPARE stmt FROM @sql;   EXECUTE stmt;   DEALLOCATE PREPARE stmt; END $$ Call Stored Procedure SET @regid = '\'1625628909\',\'1625642907\''; call GetVendor(@regid)

SAP ABAP : Parallel Cursor

Image
  *&---------------------------------------------------------------------* *& Report Z_PARALEL_CURSOR *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT  Z_PARALEL_CURSOR . DATA  :  LT_BKPF  TYPE  TABLE  OF  BKPF ,        LT_BSEG  TYPE  TABLE  OF  BSEG ,        LS_BKPF  TYPE  BKPF ,        LS_BSEG  TYPE  BSEG . DATA  :  LV_TIME1                TYPE  I ,        LV_TIME2                TYPE  I ,        LV_TIME3    ...

SAP ABAP FV60 : Park Document Using Custom Function Module

Image
  I_Header Structure LT_GLACCOUNT structure LT_WIHTAX Structure Complete Source Code : function  z_vim_park_fv60 . *"---------------------------------------------------------------------- *"*"Local Interface: *"  IMPORTING *"     REFERENCE(I_HEADER) TYPE  ZSVIM_LIVNPO_HEADER *"  TABLES *"      LT_GLACCOUNT STRUCTURE  ZSVIM_LIVNPO_GL OPTIONAL *"      LT_WIHTAX STRUCTURE  ZSVIM_LIVNPO_WHT OPTIONAL *"      LT_RETURN STRUCTURE  BDCMSGCOLL *"----------------------------------------------------------------------    data  :      ls_gl       type  zsvim_livnpo_gl ,      ls_wihtax   type  zsvim_livnpo_wht ,      ls_bdcopt   type...