Posts

Showing posts from September, 2019

How to convert TEXT in justified case .

Justified case : First letter in upper case rest in lower case .                         Example : input - hi all .                                          output - Hi All . CALL  FUNCTION  'ISP_CONVERT_FIRSTCHARS_TOUPPER'  "    EXPORTING     input_string  = variable1              " c *   separators = ' -.,;:'       " c    IMPORTING     output_string  =  variable2          " c      .   "  ISP_CONVERT_FIRSTCHARS_TOUPPER

Getting Subtoal in sap abap programming language

DATA  :  gt_sort  TYPE  slis_t_sortinfo_alv  . DATA  :  gs_sort  LIKE  LINE  OF  gt_sort . FORM  f_subtotal  .   gs_sort - fieldname  =  'ZTRN' .   gs_sort - up  =  'X' . *  gs_sort-SPOS = 1. *  gs_sort-expa = 'X'.   gs_sort - subtot  =  'X ' .    APPEND  gs_sort  TO  gt_sort  . ENDFORM .  

Getting Customer information balance amount

This is Function Module we can get customer credit limit amount    CALL  FUNCTION  'BAPI_AR_ACC_GETKEYDATEBALANCE'      EXPORTING       companycode         =  '50AG'       customer            =  lv_customer       keydate             =  SY - DATUM    BALANCESPGLI        =  'X' *   NOTEDITEMS         = ' ' * IMPORTING *   RETURN             =      TABLES       keybalance          =  gt_key_balance              .

Make any cell to color mode

data : wa_cellcolor        TYPE  lvc_s_scol , and put field in final table cellcolor  TYPE  lvc_t_scol ,  "Cell Color base on condition you can Change the field if  wa_final - lbankn  is  NOT  INITIAL .                      wa_cellcolor - fname  =  'LBANKN' .                      wa_cellcolor - color - col  =  6 .                      wa_cellcolor - color - int  =  '1' .                      wa_cellcolor - color - inv  =  '0' .                       APPEND  wa_cellcolor  TO  wa_final - cellcolor .                       CLEAR :  wa_cellcolor .                       endif . Change the code append wa_final to gt_Final.

Sent Mail PDF Attachment

Some Time Requirement to send mail as PDF attachments below peace of  code send mail as PDF attachment to user so try to write code and test yourself as pdf attachment  code  DATA  :  lv_credit_note  TYPE  zcredti_note_n ,          lv_post_docu    TYPE  char10 ,          e_devtype   TYPE   rspoptype .   lv_credit_note  =  p_l_number1 .   lv_post_docu  =  p_lv_obj_key+0 ( 10 ) . * Internal Table declarations    DATA :  i_otf  TYPE  itcoo  OCCURS  0  WITH  HEADER  LINE ,         i_tline  TYPE  TABLE  OF  tline  WITH  HEADER  LINE ,         i_receivers  TYPE  TABLE  OF  somlreci1  WITH  HEADER  LINE ,         i_record  LIKE  solisti1  OCCURS  0  WITH  HEADER  LINE , * Objects to send mail.         i_objpack  LIKE  sopcklsti1  OCCURS  0  WITH  HEADER  LINE ,         i_objtxt  LIKE  solisti1  OCCURS  0  WITH  HEADER  LINE ,         i_objbin  LIKE  solisti1  OCCURS  0  WITH  HEADER  LINE ,         i_reclist  LIKE  somlreci1  OCCURS  0  WITH  HEADER  LINE , * Work Are