SAP Table KNB1- Extract KNB1 Customer Master (Company Code) Data From SAP Table to CSV Using ABAP Program

 Extract Data From SAP to CSV Using ABAP Program For SAP Table KNB1 

Requirement - Extract Customer Master (Company Code)  Data From SAP KNB1 Table For All Available Company Code(s) / Cost Center(s).

Filed(s) Name -  KUNNR, ZWELS, ZTERM

Remark - How To Use INNER JOIN Table Join OR Where Clause In ABAP Program 

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

*& Report  Z_KNB1_COMPANY_CODE

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

*&*& Extract SAP Data For Customer Master (Company Code) SAP TABLE KNB1 Into cvs File Called KNB1.csv

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

*& Developed By -   SAI CONSULTANCY SERVICES LIMITED

*& Date - 12/04/2024

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

*&--KUNNR        ZWELS  ZTERM

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

REPORT  Z_KNB1_COMPANY_CODE.

 

type-pools:TRUXS.

data: begin of itab occurs 0,

      kunnr like knb1-kunnr,

      zwels like knb1-zwels,

      zterm like knb1-zterm,

      bukrs like knb1-bukrs,

      end of itab.

data:  itab1 type TRUXS_T_TEXT_DATA.

select  knb1~kunnr

         knb1~zwels

         knb1~zterm

         knb1~bukrs

         from KNB1

         into table itab

         where knb1~bukrs = 'UK01'.

 

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:\tmp\KNB1.csv'

    TABLES

      data_tab = itab1

    EXCEPTIONS

      OTHERS   = 1.