Posts

Showing posts with the label Sum of a field in SAP ALV Report

Using BAPI upload excel file for t-code AS02 in SAP

Using BAPI " BAPI_FIXEDASSET_CHANGE " create a zprogram to upload excel file for mass change fixed asset in SAP. REPORT  ZAS02_ASSET_CHANGE_UPLOAD . TYPE-POOLS :  truxs . " Structure for Excel data TYPES :  BEGIN  OF  ty_excel ,          anln1  TYPE  anln1 ,          bukrs  TYPE  bukrs ,          kostl  TYPE  kostl ,          werks  TYPE  werks ,          prctr  TYPE  prctr ,         END  OF  ty_excel . DATA :  lt_excel     TYPE  TABLE  OF  ty_excel ,       ls_excel     TYPE  ty_excel ,     ...

Sum of a field in SAP ALV Report

 In sap ALV report some times we need to sum column value. We can easily doing this job just define <field catalog>-do_sum = 'X' and must define <field catalog>-fieldname = 'QUAN' / 'CUR'. example given below:       W_FIELDCAT - FIELDNAME  =  'Deviation' .   W_FIELDCAT - DO_SUM  =  'X' .   W_FIELDCAT - DATATYPE  =  'QUAN' .   W_FIELDCAT - SELTEXT_L  =  'Deviation %' .   W_FIELDCAT - TABNAME  =  'TY_TABLE' .    APPEND  W_FIELDCAT  TO  FIELDCAT .