SAP Table ANLB - Extract ANLB (Depreciation Master) Data From SAP Table to CSV Using ABAP Program

Extract ANLB (Depreciation Table) Data From SAP to CSV Using ABAP Program

Requirement - Extract Depreciation Data From SAP ANLB Table For All Available Company Code(s).

Field(s) To Extract -  ANLN1, NDJAR,NDPER,AFABH,AFASL

*&---------------------------------------------------------------------*

*& Report  Z_ANLB_DEPRECIATION

*&

*& Extract SAP Data For Asset Master Record Segment SAP TABLE ANLB Into cvs File Called ANLC.csv

*&---------------------------------------------------------------------*

*& Developed By - SAI CONSULTANCY SERVICES LIMITED

 

*& Date - 08/10/2021

*&---------------------------------------------------------------------*

*&--ANLN1 NDJAR   NDPER AFABH AFASL

*&---------------------------------------------------------------------*

 

REPORT  Z_ANLB_DEPRECIATION.

 

type-pools:TRUXS.

data: begin of itab occurs 0,

      anln1 like anlb-anln1,

                ndjar like anlb-ndjar,

                nbper like anlb-ndper,

                afabg like anlb-afabg,

                afasl like anlb-afasl,

                bukrs like anlb-bukrs,

      end of itab.

data:  itab1 type TRUXS_T_TEXT_DATA.

select  anlb~anln1

                             anlb~ndjar

                             anlb~ndper

                             anlb~afabg

                             anlb~afasl

                             anlb~bukrs

         from anlb

         into table itab.

CALL FUNCTION 'SAP_CONVERT_TO_CSV_FORMAT'

EXPORTING

   I_FIELD_SEPERATOR          = ','

 TABLES

    I_TAB_SAP_DATA             = itab

CHANGING

   I_TAB_CONVERTED_DATA       =  itab1

EXCEPTIONS

   CONVERSION_FAILED          = 1

   OTHERS                     = 2

          .

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

 

   CALL FUNCTION 'GUI_DOWNLOAD'

    EXPORTING

      filename = 'C:\SAI_CONSULTANCY_SERVICES_LIMITED\DATA\ANLB.csv'

    TABLES

      data_tab = itab1

    EXCEPTIONS

      OTHERS   = 1.