ABAP Select data from SAP table RIP_DATA into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP RIP_DATA table and store it within an internal table, including using the newer @DATA inline declaration methods. It also shows you various ways to process this data using ABAP work area, inline declaration or field symbols including executing all the relevant CONVERSION_EXIT routines specific to RIP_DATA. See here for more generic Select statement tips.

Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. These input/output conversation FM routines are what translates the data between the two formats.

There is also a full declaration of the RIP_DATA table where each field has a char/string type for you to simply copy and paste. This allows you to use processing that is only available to these field types such as the CONCATENATE statement.

DATA: IT_RIP_DATA TYPE STANDARD TABLE OF RIP_DATA,
      WA_RIP_DATA TYPE RIP_DATA,
      GD_STR TYPE STRING.

DATA: lo_typedescr type REF TO cl_abap_typedescr.
DATA: lv_fieldname type fieldname.

FIELD-SYMBOLS: <FIELD> TYPE any.
FIELD-SYMBOLS: <RIP_DATA> TYPE RIP_DATA.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_RIP_DATA.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM RIP_DATA
  INTO TABLE IT_RIP_DATA.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RIP_DATA
*  INTO TABLE @DATA(IT_RIP_DATA2).
*--Further methods of using ABAP code to  select data from SAP database tables

*You can also declare the header/work area using the in-line DATA declaration method
READ TABLE IT_RIP_DATA INDEX 1 INTO DATA(WA_RIP_DATA2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_RIP_DATA ASSIGNING <RIP_DATA>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<RIP_DATA>-FEBKO = 1.
<RIP_DATA>-MANDT = 1.
<RIP_DATA>-ANWND = 1.
<RIP_DATA>-ABSND = 1.
<RIP_DATA>-AZIDT = 1.
ENDLOOP.

LOOP AT IT_RIP_DATA INTO WA_RIP_DATA.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RIP_DATA-EMKEY, sy-vline,
WA_RIP_DATA-KUKEY, sy-vline,
WA_RIP_DATA-ASTAT, sy-vline,
WA_RIP_DATA-DSTAT, sy-vline,
WA_RIP_DATA-VB1OK, sy-vline,
WA_RIP_DATA-VB2OK, sy-vline.
ENDLOOP. *Add any further fields from structure WA_RIP_DATA you want to display... WRITE:/ sy-uline. * Aternatively use generic code to Write field values (and NAME) to screen report DO. ASSIGN COMPONENT sy-index OF STRUCTURE wa_RIP_DATA TO <field>. IF sy-subrc <> 0. EXIT. ENDIF. WRITE:/ 'Field Value', <field>, sy-vline. gd_str = <field> . lo_typedescr ?= CL_ABAP_DATADESCR=>DESCRIBE_BY_DATA( <field> ). lv_fieldname = lo_typedescr->GET_RELATIVE_NAME( ). WRITE:/ 'Field Name', lv_fieldname. ENDDO. *Redo loop but convert all fields from internal to out value LOOP AT IT_RIP_DATA INTO WA_RIP_DATA. *Write horizonal line to screen report. WRITE:/ sy-uline. *Convert all fields to display/output versions using conversion routines PERFORM convert_all_field_values CHANGING wa_EKKO. ENDLOOP. *&---------------------------------------------------------------------* *& Form convert_all_field_values *&---------------------------------------------------------------------* FORM convert_all_field_values CHANGING p_EKKO LIKE wa_EKKO. DATA: ld_input(1000) TYPE c, ld_output(1000) TYPE C.

*Conversion exit ALPHA, internal->external for field HKONT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-HKONT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-HKONT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU172, internal->external for field SSBTR CALL FUNCTION 'CONVERSION_EXIT_AU172_OUTPUT' EXPORTING input = WA_RIP_DATA-SSBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-SSBTR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU172, internal->external for field SUMSO CALL FUNCTION 'CONVERSION_EXIT_AU172_OUTPUT' EXPORTING input = WA_RIP_DATA-SUMSO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-SUMSO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU172, internal->external for field SUMHA CALL FUNCTION 'CONVERSION_EXIT_AU172_OUTPUT' EXPORTING input = WA_RIP_DATA-SUMHA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-SUMHA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU172, internal->external for field ESBTR CALL FUNCTION 'CONVERSION_EXIT_AU172_OUTPUT' EXPORTING input = WA_RIP_DATA-ESBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-ESBTR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU172, internal->external for field ESDMB CALL FUNCTION 'CONVERSION_EXIT_AU172_OUTPUT' EXPORTING input = WA_RIP_DATA-ESDMB IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-ESDMB.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU172, internal->external for field CLOSING_AVAILABLE_BALANCE CALL FUNCTION 'CONVERSION_EXIT_AU172_OUTPUT' EXPORTING input = WA_RIP_DATA-CLOSING_AVAILABLE_BALANCE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-CLOSING_AVAILABLE_BALANCE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field BELNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-BELNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-BELNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field GJAHR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_RIP_DATA-GJAHR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-GJAHR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field KWBTR CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_RIP_DATA-KWBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-KWBTR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU132, internal->external for field SPESK CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT' EXPORTING input = WA_RIP_DATA-SPESK IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-SPESK.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field FWBTR CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_RIP_DATA-FWBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-FWBTR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU132, internal->external for field SPESF CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT' EXPORTING input = WA_RIP_DATA-SPESF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-SPESF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PRCTR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-PRCTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-PRCTR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field VERTN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-VERTN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-VERTN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field NBBLN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-NBBLN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-NBBLN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field AK1BL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-AK1BL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-AK1BL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field AKBLN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-AKBLN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-AKBLN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KNRZA CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-KNRZA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-KNRZA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field AVKON CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-AVKON IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-AVKON.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRT, internal->external for field KURSF CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_RIP_DATA-KURSF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-KURSF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SDOC2 CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-SDOC2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-SDOC2.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU132, internal->external for field ARRSK CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT' EXPORTING input = WA_RIP_DATA-ARRSK IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-ARRSK.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SVKON CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-SVKON IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-SVKON.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ACCDOC_TMP_DOC_ID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-ACCDOC_TMP_DOC_ID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-ACCDOC_TMP_DOC_ID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field AK1BL_GJAHR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_RIP_DATA-AK1BL_GJAHR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-AK1BL_GJAHR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field AKBLN_GJAHR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_RIP_DATA-AKBLN_GJAHR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-AKBLN_GJAHR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field BELNR_GJAHR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_RIP_DATA-BELNR_GJAHR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-BELNR_GJAHR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field NBBLN_GJAHR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_RIP_DATA-NBBLN_GJAHR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-NBBLN_GJAHR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field SDOC2_GJAHR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_RIP_DATA-SDOC2_GJAHR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-SDOC2_GJAHR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRT, internal->external for field CURR_RATE CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_RIP_DATA-CURR_RATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-CURR_RATE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit FMCIL, internal->external for field FIPEX CALL FUNCTION 'CONVERSION_EXIT_FMCIL_OUTPUT' EXPORTING input = WA_RIP_DATA-FIPEX IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-FIPEX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SAKIN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-SAKIN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-SAKIN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SAKN1 CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-SAKN1 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-SAKN1.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SAKN2 CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-SAKN2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-SAKN2.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SAKINB CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RIP_DATA-SAKINB IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RIP_DATA-SAKINB.
WRITE:/ 'New Value:', ld_input.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_RIP_DATA_STR,
FEBKO TYPE STRING,
MANDT TYPE STRING,
ANWND TYPE STRING,
ABSND TYPE STRING,
AZIDT TYPE STRING,
EMKEY TYPE STRING,
KUKEY TYPE STRING,
ASTAT TYPE STRING,
DSTAT TYPE STRING,
VB1OK TYPE STRING,
VB2OK TYPE STRING,
KIPRE TYPE STRING,
VFDAT TYPE STRING,
GRP01 TYPE STRING,
XKEP1 TYPE STRING,
GRP02 TYPE STRING,
XKEP2 TYPE STRING,
WVDAT TYPE STRING,
WVTIM TYPE STRING,
WVART TYPE STRING,
HKONT TYPE STRING,
KTONR TYPE STRING,
KTOIH TYPE STRING,
KTOSB TYPE STRING,
AZNUM TYPE STRING,
AZSNR TYPE STRING,
AZDAT TYPE STRING,
BUKRS TYPE STRING,
KTOPL TYPE STRING,
WAERS TYPE STRING,
SSTYP TYPE STRING,
SSVOZ TYPE STRING,
SSBTR TYPE STRING,
SUMSO TYPE STRING,
SUMHA TYPE STRING,
ESTYP TYPE STRING,
ESVOZ TYPE STRING,
ESBTR TYPE STRING,
ESDMB TYPE STRING,
BLAUF TYPE STRING,
ELAUF TYPE STRING,
HZINS TYPE STRING,
TEILN TYPE STRING,
BKTOA TYPE STRING,
ANZES TYPE STRING,
VGTYP TYPE STRING,
EFART TYPE STRING,
HBKID TYPE STRING,
HKTID TYPE STRING,
EUSER TYPE STRING,
EDATE TYPE STRING,
ETIME TYPE STRING,
BKREF TYPE STRING,
XFDIS TYPE STRING,
DSART TYPE STRING,
XVERD TYPE STRING,
XBENR TYPE STRING,
XBTYP TYPE STRING,
SEQ_NUMBER TYPE STRING,
SEQ_STATUS TYPE STRING,
INPUT_FORMAT TYPE STRING,
SIBAN TYPE STRING,
AZPGNO TYPE STRING,
FILEHASH TYPE STRING,
CLOSING_AVAILABLE_BALANCE TYPE STRING,
DUMMY_FEBKO TYPE STRING,
BSIMP_PSETID TYPE STRING,
SUPFINCOR TYPE STRING,
CASHUPD TYPE STRING,
CASHUPDOK TYPE STRING,
FEBEP TYPE STRING,
MANDT TYPE STRING,
KUKEY TYPE STRING,
ESNUM TYPE STRING,
EPERL TYPE STRING,
VB1OK TYPE STRING,
VB2BA TYPE STRING,
VB2OK TYPE STRING,
PIPRE TYPE STRING,
GRPNR TYPE STRING,
ESTAT TYPE STRING,
BELNR TYPE STRING,
GJAHR TYPE STRING,
BVDAT TYPE STRING,
BUDAT TYPE STRING,
VALUT TYPE STRING,
BUTIM TYPE STRING,
VOZEI TYPE STRING,
KWAER TYPE STRING,
KWBTR TYPE STRING,
SPESK TYPE STRING,
FWAER TYPE STRING,
FWBTR TYPE STRING,
SPESF TYPE STRING,
VORGC TYPE STRING,
TEXTS TYPE STRING,
VGEXT TYPE STRING,
VGMAN TYPE STRING,
VGINT TYPE STRING,
VGDEF TYPE STRING,
KFMOD TYPE STRING,
VGSAP TYPE STRING,
BUTXT TYPE STRING,
ANZSP TYPE STRING,
XBLNR TYPE STRING,
ZUONR TYPE STRING,
PABKS TYPE STRING,
PABLZ TYPE STRING,
PASWI TYPE STRING,
PAKTO TYPE STRING,
PARTN TYPE STRING,
BUSAB TYPE STRING,
KOSTL TYPE STRING,
GSBER TYPE STRING,
PRCTR TYPE STRING,
VERTN TYPE STRING,
VERTT TYPE STRING,
PNOTA TYPE STRING,
CHECT TYPE STRING,
STAVV TYPE STRING,
TXTVV TYPE STRING,
EPVOZ TYPE STRING,
INFO1 TYPE STRING,
INFO2 TYPE STRING,
AVSID TYPE STRING,
INTAG TYPE STRING,
NBBLN TYPE STRING,
AK1BL TYPE STRING,
AKBLN TYPE STRING,
KNRZA TYPE STRING,
AVKOA TYPE STRING,
AVKON TYPE STRING,
BATCH TYPE STRING,
ITMNR TYPE STRING,
KURSF TYPE STRING,
SGTXT TYPE STRING,
JPDAT TYPE STRING,
POSAG TYPE STRING,
SDOC2 TYPE STRING,
VGREF TYPE STRING,
XBENR TYPE STRING,
XBTYP TYPE STRING,
ARRSK TYPE STRING,
PFORM TYPE STRING,
KIDNO TYPE STRING,
KKREF TYPE STRING,
KKRF2 TYPE STRING,
MANSP TYPE STRING,
FNAM1 TYPE STRING,
FVAL1 TYPE STRING,
FKOA1 TYPE STRING,
FNAM2 TYPE STRING,
FVAL2 TYPE STRING,
FKOA2 TYPE STRING,
FNAM3 TYPE STRING,
FVAL3 TYPE STRING,
FKOA3 TYPE STRING,
IDENR TYPE STRING,
B1APP TYPE STRING,
B1ERR TYPE STRING,
B1STD TYPE STRING,
B1DOC TYPE STRING,
B1TYP TYPE STRING,
B2APP TYPE STRING,
B2ERR TYPE STRING,
B2STD TYPE STRING,
B2DOC TYPE STRING,
B2TYP TYPE STRING,
PIBAN TYPE STRING,
N2PCH TYPE STRING,
SVBUK TYPE STRING,
SVKOA TYPE STRING,
SVKON TYPE STRING,
SVAVS TYPE STRING,
REPRO TYPE STRING,
TRNID TYPE STRING,
ACCDOC_TMP_DOC_ID TYPE STRING,
CHECT_ORIG TYPE STRING,
CHECT_TYPE TYPE STRING,
ML_STATUS TYPE STRING,
PR_STATUS TYPE STRING,
AK1BL_GJAHR TYPE STRING,
AKBLN_GJAHR TYPE STRING,
BELNR_GJAHR TYPE STRING,
NBBLN_GJAHR TYPE STRING,
SDOC2_GJAHR TYPE STRING,
POSTINGRULEUUID TYPE STRING,
DUMMY_FEBEP TYPE STRING,
BP_ID_CATEGORY TYPE STRING,
BP_ID_NUMBER TYPE STRING,
ADDITIONAL_INFO TYPE STRING,
KEYPP TYPE STRING,
ML_STATUS_ACCDET TYPE STRING,
PART_APPL_STATUS TYPE STRING,
TATYP TYPE STRING,
X_FWBTR_CHG TYPE STRING,
CURR_RATE TYPE STRING,
REPROCREASONCODE TYPE STRING,
XREF1 TYPE STRING,
FIPEX TYPE STRING,
ERD TYPE STRING,
LOCAL_AMOUNT_GL TYPE STRING,
LOCAL_AMOUNT_USAGE TYPE STRING,
ZUONR TYPE STRING,
KUKEY TYPE STRING,
ESNUM TYPE STRING,
KWAER TYPE STRING,
IKOFI TYPE STRING,
ANWND TYPE STRING,
EIGR1 TYPE STRING,
EIGR2 TYPE STRING,
EIGR3 TYPE STRING,
EIGR4 TYPE STRING,
KTOPL TYPE STRING,
KOMO1 TYPE STRING,
KOMO2 TYPE STRING,
SAKIN TYPE STRING,
BSCH1 TYPE STRING,
KTOS1 TYPE STRING,
SHBK1 TYPE STRING,
KOMK1 TYPE STRING,
SAKN1 TYPE STRING,
BSCH2 TYPE STRING,
KTOS2 TYPE STRING,
SHBK2 TYPE STRING,
KOMK2 TYPE STRING,
SAKN2 TYPE STRING,
FPART TYPE STRING,
ATTR1 TYPE STRING,
ATTR2 TYPE STRING,
KOMO1B TYPE STRING,
KOMO2B TYPE STRING,
SAKINB TYPE STRING,
STGRD TYPE STRING,
BSCAK TYPE STRING,END OF T_EKKO_STR. DATA: WA_RIP_DATA_STR type T_EKKO_STR. DATA: ld_text TYPE string. LOOP AT IT_EKKO INTO WA_EKKO. MOVE-CORRESPONDING wa_EKKO TO WA_EKKO_STR. CONCATENATE: sy-vline
WA_RIP_DATA_STR-FEBKO sy-vline
WA_RIP_DATA_STR-MANDT sy-vline
WA_RIP_DATA_STR-ANWND sy-vline
WA_RIP_DATA_STR-ABSND sy-vline
WA_RIP_DATA_STR-AZIDT sy-vline
WA_RIP_DATA_STR-EMKEY sy-vline
WA_RIP_DATA_STR-KUKEY sy-vline
WA_RIP_DATA_STR-ASTAT sy-vline
WA_RIP_DATA_STR-DSTAT sy-vline
WA_RIP_DATA_STR-VB1OK sy-vline
WA_RIP_DATA_STR-VB2OK sy-vline
WA_RIP_DATA_STR-KIPRE sy-vline
WA_RIP_DATA_STR-VFDAT sy-vline
WA_RIP_DATA_STR-GRP01 sy-vline
WA_RIP_DATA_STR-XKEP1 sy-vline
WA_RIP_DATA_STR-GRP02 sy-vline
WA_RIP_DATA_STR-XKEP2 sy-vline
WA_RIP_DATA_STR-WVDAT sy-vline
WA_RIP_DATA_STR-WVTIM sy-vline
WA_RIP_DATA_STR-WVART sy-vline
WA_RIP_DATA_STR-HKONT sy-vline
WA_RIP_DATA_STR-KTONR sy-vline
WA_RIP_DATA_STR-KTOIH sy-vline
WA_RIP_DATA_STR-KTOSB sy-vline
WA_RIP_DATA_STR-AZNUM sy-vline
WA_RIP_DATA_STR-AZSNR sy-vline
WA_RIP_DATA_STR-AZDAT sy-vline
WA_RIP_DATA_STR-BUKRS sy-vline
WA_RIP_DATA_STR-KTOPL sy-vline
WA_RIP_DATA_STR-WAERS sy-vline
WA_RIP_DATA_STR-SSTYP sy-vline
WA_RIP_DATA_STR-SSVOZ sy-vline
WA_RIP_DATA_STR-SSBTR sy-vline
WA_RIP_DATA_STR-SUMSO sy-vline
WA_RIP_DATA_STR-SUMHA sy-vline
WA_RIP_DATA_STR-ESTYP sy-vline
WA_RIP_DATA_STR-ESVOZ sy-vline
WA_RIP_DATA_STR-ESBTR sy-vline
WA_RIP_DATA_STR-ESDMB sy-vline
WA_RIP_DATA_STR-BLAUF sy-vline
WA_RIP_DATA_STR-ELAUF sy-vline
WA_RIP_DATA_STR-HZINS sy-vline
WA_RIP_DATA_STR-TEILN sy-vline
WA_RIP_DATA_STR-BKTOA sy-vline
WA_RIP_DATA_STR-ANZES sy-vline
WA_RIP_DATA_STR-VGTYP sy-vline
WA_RIP_DATA_STR-EFART sy-vline
WA_RIP_DATA_STR-HBKID sy-vline
WA_RIP_DATA_STR-HKTID sy-vline
WA_RIP_DATA_STR-EUSER sy-vline
WA_RIP_DATA_STR-EDATE sy-vline
WA_RIP_DATA_STR-ETIME sy-vline
WA_RIP_DATA_STR-BKREF sy-vline
WA_RIP_DATA_STR-XFDIS sy-vline
WA_RIP_DATA_STR-DSART sy-vline
WA_RIP_DATA_STR-XVERD sy-vline
WA_RIP_DATA_STR-XBENR sy-vline
WA_RIP_DATA_STR-XBTYP sy-vline
WA_RIP_DATA_STR-SEQ_NUMBER sy-vline
WA_RIP_DATA_STR-SEQ_STATUS sy-vline
WA_RIP_DATA_STR-INPUT_FORMAT sy-vline
WA_RIP_DATA_STR-SIBAN sy-vline
WA_RIP_DATA_STR-AZPGNO sy-vline
WA_RIP_DATA_STR-FILEHASH sy-vline
WA_RIP_DATA_STR-CLOSING_AVAILABLE_BALANCE sy-vline
WA_RIP_DATA_STR-DUMMY_FEBKO sy-vline
WA_RIP_DATA_STR-BSIMP_PSETID sy-vline
WA_RIP_DATA_STR-SUPFINCOR sy-vline
WA_RIP_DATA_STR-CASHUPD sy-vline
WA_RIP_DATA_STR-CASHUPDOK sy-vline
WA_RIP_DATA_STR-FEBEP sy-vline
WA_RIP_DATA_STR-MANDT sy-vline
WA_RIP_DATA_STR-KUKEY sy-vline
WA_RIP_DATA_STR-ESNUM sy-vline
WA_RIP_DATA_STR-EPERL sy-vline
WA_RIP_DATA_STR-VB1OK sy-vline
WA_RIP_DATA_STR-VB2BA sy-vline
WA_RIP_DATA_STR-VB2OK sy-vline
WA_RIP_DATA_STR-PIPRE sy-vline
WA_RIP_DATA_STR-GRPNR sy-vline
WA_RIP_DATA_STR-ESTAT sy-vline
WA_RIP_DATA_STR-BELNR sy-vline
WA_RIP_DATA_STR-GJAHR sy-vline
WA_RIP_DATA_STR-BVDAT sy-vline
WA_RIP_DATA_STR-BUDAT sy-vline
WA_RIP_DATA_STR-VALUT sy-vline
WA_RIP_DATA_STR-BUTIM sy-vline
WA_RIP_DATA_STR-VOZEI sy-vline
WA_RIP_DATA_STR-KWAER sy-vline
WA_RIP_DATA_STR-KWBTR sy-vline
WA_RIP_DATA_STR-SPESK sy-vline
WA_RIP_DATA_STR-FWAER sy-vline
WA_RIP_DATA_STR-FWBTR sy-vline
WA_RIP_DATA_STR-SPESF sy-vline
WA_RIP_DATA_STR-VORGC sy-vline
WA_RIP_DATA_STR-TEXTS sy-vline
WA_RIP_DATA_STR-VGEXT sy-vline
WA_RIP_DATA_STR-VGMAN sy-vline
WA_RIP_DATA_STR-VGINT sy-vline
WA_RIP_DATA_STR-VGDEF sy-vline
WA_RIP_DATA_STR-KFMOD sy-vline
WA_RIP_DATA_STR-VGSAP sy-vline
WA_RIP_DATA_STR-BUTXT sy-vline
WA_RIP_DATA_STR-ANZSP sy-vline
WA_RIP_DATA_STR-XBLNR sy-vline
WA_RIP_DATA_STR-ZUONR sy-vline
WA_RIP_DATA_STR-PABKS sy-vline
WA_RIP_DATA_STR-PABLZ sy-vline
WA_RIP_DATA_STR-PASWI sy-vline
WA_RIP_DATA_STR-PAKTO sy-vline
WA_RIP_DATA_STR-PARTN sy-vline
WA_RIP_DATA_STR-BUSAB sy-vline
WA_RIP_DATA_STR-KOSTL sy-vline
WA_RIP_DATA_STR-GSBER sy-vline
WA_RIP_DATA_STR-PRCTR sy-vline
WA_RIP_DATA_STR-VERTN sy-vline
WA_RIP_DATA_STR-VERTT sy-vline
WA_RIP_DATA_STR-PNOTA sy-vline
WA_RIP_DATA_STR-CHECT sy-vline
WA_RIP_DATA_STR-STAVV sy-vline
WA_RIP_DATA_STR-TXTVV sy-vline
WA_RIP_DATA_STR-EPVOZ sy-vline
WA_RIP_DATA_STR-INFO1 sy-vline
WA_RIP_DATA_STR-INFO2 sy-vline
WA_RIP_DATA_STR-AVSID sy-vline
WA_RIP_DATA_STR-INTAG sy-vline
WA_RIP_DATA_STR-NBBLN sy-vline
WA_RIP_DATA_STR-AK1BL sy-vline
WA_RIP_DATA_STR-AKBLN sy-vline
WA_RIP_DATA_STR-KNRZA sy-vline
WA_RIP_DATA_STR-AVKOA sy-vline
WA_RIP_DATA_STR-AVKON sy-vline
WA_RIP_DATA_STR-BATCH sy-vline
WA_RIP_DATA_STR-ITMNR sy-vline
WA_RIP_DATA_STR-KURSF sy-vline
WA_RIP_DATA_STR-SGTXT sy-vline
WA_RIP_DATA_STR-JPDAT sy-vline
WA_RIP_DATA_STR-POSAG sy-vline
WA_RIP_DATA_STR-SDOC2 sy-vline
WA_RIP_DATA_STR-VGREF sy-vline
WA_RIP_DATA_STR-XBENR sy-vline
WA_RIP_DATA_STR-XBTYP sy-vline
WA_RIP_DATA_STR-ARRSK sy-vline
WA_RIP_DATA_STR-PFORM sy-vline
WA_RIP_DATA_STR-KIDNO sy-vline
WA_RIP_DATA_STR-KKREF sy-vline
WA_RIP_DATA_STR-KKRF2 sy-vline
WA_RIP_DATA_STR-MANSP sy-vline
WA_RIP_DATA_STR-FNAM1 sy-vline
WA_RIP_DATA_STR-FVAL1 sy-vline
WA_RIP_DATA_STR-FKOA1 sy-vline
WA_RIP_DATA_STR-FNAM2 sy-vline
WA_RIP_DATA_STR-FVAL2 sy-vline
WA_RIP_DATA_STR-FKOA2 sy-vline
WA_RIP_DATA_STR-FNAM3 sy-vline
WA_RIP_DATA_STR-FVAL3 sy-vline
WA_RIP_DATA_STR-FKOA3 sy-vline
WA_RIP_DATA_STR-IDENR sy-vline
WA_RIP_DATA_STR-B1APP sy-vline
WA_RIP_DATA_STR-B1ERR sy-vline
WA_RIP_DATA_STR-B1STD sy-vline
WA_RIP_DATA_STR-B1DOC sy-vline
WA_RIP_DATA_STR-B1TYP sy-vline
WA_RIP_DATA_STR-B2APP sy-vline
WA_RIP_DATA_STR-B2ERR sy-vline
WA_RIP_DATA_STR-B2STD sy-vline
WA_RIP_DATA_STR-B2DOC sy-vline
WA_RIP_DATA_STR-B2TYP sy-vline
WA_RIP_DATA_STR-PIBAN sy-vline
WA_RIP_DATA_STR-N2PCH sy-vline
WA_RIP_DATA_STR-SVBUK sy-vline
WA_RIP_DATA_STR-SVKOA sy-vline
WA_RIP_DATA_STR-SVKON sy-vline
WA_RIP_DATA_STR-SVAVS sy-vline
WA_RIP_DATA_STR-REPRO sy-vline
WA_RIP_DATA_STR-TRNID sy-vline
WA_RIP_DATA_STR-ACCDOC_TMP_DOC_ID sy-vline
WA_RIP_DATA_STR-CHECT_ORIG sy-vline
WA_RIP_DATA_STR-CHECT_TYPE sy-vline
WA_RIP_DATA_STR-ML_STATUS sy-vline
WA_RIP_DATA_STR-PR_STATUS sy-vline
WA_RIP_DATA_STR-AK1BL_GJAHR sy-vline
WA_RIP_DATA_STR-AKBLN_GJAHR sy-vline
WA_RIP_DATA_STR-BELNR_GJAHR sy-vline
WA_RIP_DATA_STR-NBBLN_GJAHR sy-vline
WA_RIP_DATA_STR-SDOC2_GJAHR sy-vline
WA_RIP_DATA_STR-POSTINGRULEUUID sy-vline
WA_RIP_DATA_STR-DUMMY_FEBEP sy-vline
WA_RIP_DATA_STR-BP_ID_CATEGORY sy-vline
WA_RIP_DATA_STR-BP_ID_NUMBER sy-vline
WA_RIP_DATA_STR-ADDITIONAL_INFO sy-vline
WA_RIP_DATA_STR-KEYPP sy-vline
WA_RIP_DATA_STR-ML_STATUS_ACCDET sy-vline
WA_RIP_DATA_STR-PART_APPL_STATUS sy-vline
WA_RIP_DATA_STR-TATYP sy-vline
WA_RIP_DATA_STR-X_FWBTR_CHG sy-vline
WA_RIP_DATA_STR-CURR_RATE sy-vline
WA_RIP_DATA_STR-REPROCREASONCODE sy-vline
WA_RIP_DATA_STR-XREF1 sy-vline
WA_RIP_DATA_STR-FIPEX sy-vline
WA_RIP_DATA_STR-ERD sy-vline
WA_RIP_DATA_STR-LOCAL_AMOUNT_GL sy-vline
WA_RIP_DATA_STR-LOCAL_AMOUNT_USAGE sy-vline
WA_RIP_DATA_STR-ZUONR sy-vline
WA_RIP_DATA_STR-KUKEY sy-vline
WA_RIP_DATA_STR-ESNUM sy-vline
WA_RIP_DATA_STR-KWAER sy-vline
WA_RIP_DATA_STR-IKOFI sy-vline
WA_RIP_DATA_STR-ANWND sy-vline
WA_RIP_DATA_STR-EIGR1 sy-vline
WA_RIP_DATA_STR-EIGR2 sy-vline
WA_RIP_DATA_STR-EIGR3 sy-vline
WA_RIP_DATA_STR-EIGR4 sy-vline
WA_RIP_DATA_STR-KTOPL sy-vline
WA_RIP_DATA_STR-KOMO1 sy-vline
WA_RIP_DATA_STR-KOMO2 sy-vline
WA_RIP_DATA_STR-SAKIN sy-vline
WA_RIP_DATA_STR-BSCH1 sy-vline
WA_RIP_DATA_STR-KTOS1 sy-vline
WA_RIP_DATA_STR-SHBK1 sy-vline
WA_RIP_DATA_STR-KOMK1 sy-vline
WA_RIP_DATA_STR-SAKN1 sy-vline
WA_RIP_DATA_STR-BSCH2 sy-vline
WA_RIP_DATA_STR-KTOS2 sy-vline
WA_RIP_DATA_STR-SHBK2 sy-vline
WA_RIP_DATA_STR-KOMK2 sy-vline
WA_RIP_DATA_STR-SAKN2 sy-vline
WA_RIP_DATA_STR-FPART sy-vline
WA_RIP_DATA_STR-ATTR1 sy-vline
WA_RIP_DATA_STR-ATTR2 sy-vline
WA_RIP_DATA_STR-KOMO1B sy-vline
WA_RIP_DATA_STR-KOMO2B sy-vline
WA_RIP_DATA_STR-SAKINB sy-vline
WA_RIP_DATA_STR-STGRD sy-vline
WA_RIP_DATA_STR-BSCAK sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.