ABAP Select data from SAP table IONRA 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 IONRA 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 IONRA. 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 IONRA 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_IONRA TYPE STANDARD TABLE OF IONRA,
      WA_IONRA TYPE IONRA,
      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: <IONRA> TYPE IONRA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM IONRA
*  INTO TABLE @DATA(IT_IONRA2).
*--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_IONRA INDEX 1 INTO DATA(WA_IONRA2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_IONRA ASSIGNING <IONRA>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<IONRA>-OBJNR = 1.
<IONRA>-OBART = 1.
<IONRA>-RCODE = 1.
<IONRA>-ACNUM_INT = 1.
<IONRA>-ACTN = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_IONRA-AENNR, sy-vline,
WA_IONRA-AETYP, sy-vline,
WA_IONRA-ANLN1, sy-vline,
WA_IONRA-ANLN2, sy-vline,
WA_IONRA-AOBAR, sy-vline,
WA_IONRA-AOTYP, sy-vline.
ENDLOOP. *Add any further fields from structure WA_IONRA 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_IONRA 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_IONRA INTO WA_IONRA. *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 ACTN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IONRA-ACTN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IONRA-ACTN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit POSNR, internal->external for field IM_POSNR CALL FUNCTION 'CONVERSION_EXIT_POSNR_OUTPUT' EXPORTING input = WA_IONRA-IM_POSNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IONRA-IM_POSNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REQNR, internal->external for field IMA_POSNR CALL FUNCTION 'CONVERSION_EXIT_REQNR_OUTPUT' EXPORTING input = WA_IONRA-IMA_POSNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IONRA-IMA_POSNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit MATN1, internal->external for field MATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_IONRA-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IONRA-MATNR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ABPSN, internal->external for field POSID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_IONRA-POSID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IONRA-POSID.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ABPSN, internal->external for field PSPID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_IONRA-PSPID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IONRA-PSPID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSP, internal->external for field PSPNR CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_IONRA-PSPNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IONRA-PSPNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit MATN1, internal->external for field CU_ID CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_IONRA-CU_ID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IONRA-CU_ID.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ALPHA, internal->external for field WCNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IONRA-WCNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IONRA-WCNR.
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_IONRA_STR,
OBJNR TYPE STRING,
OBART TYPE STRING,
RCODE TYPE STRING,
ACNUM_INT TYPE STRING,
ACTN TYPE STRING,
AENNR TYPE STRING,
AETYP TYPE STRING,
ANLN1 TYPE STRING,
ANLN2 TYPE STRING,
AOBAR TYPE STRING,
AOTYP TYPE STRING,
APLZL TYPE STRING,
APLZL_VOR TYPE STRING,
APLZL_NCH TYPE STRING,
AUFNR TYPE STRING,
AUFPL TYPE STRING,
AUFPL_VOR TYPE STRING,
AUFPL_NCH TYPE STRING,
BEDID TYPE STRING,
BEDZL TYPE STRING,
BKKRS TYPE STRING,
BUKRS TYPE STRING,
BWVAR TYPE STRING,
BZOBJ TYPE STRING,
CANUM TYPE STRING,
CLINT TYPE STRING,
CO_POSNR TYPE STRING,
CTYP TYPE STRING,
DOKAR TYPE STRING,
DOKNR TYPE STRING,
DOKVR TYPE STRING,
DOKTL TYPE STRING,
DPERBEG TYPE STRING,
EBELN TYPE STRING,
EBELP TYPE STRING,
EBRID TYPE STRING,
EB_VERSION TYPE STRING,
EINRI TYPE STRING,
EQUNR TYPE STRING,
ERKRS TYPE STRING,
FALNR TYPE STRING,
FICTR TYPE STRING,
FIKRS TYPE STRING,
GSBER TYPE STRING,
IBASE TYPE STRING,
INSTANCE TYPE STRING,
IM_GJAHR TYPE STRING,
IM_PRNAM TYPE STRING,
IM_POSNR TYPE STRING,
IMA_POSNR TYPE STRING,
IMA_VARNT TYPE STRING,
ISLNR TYPE STRING,
ISMNR TYPE STRING,
KADKY TYPE STRING,
KALKA TYPE STRING,
KALN1 TYPE STRING,
KALNR TYPE STRING,
KANTE TYPE STRING,
KKZMA TYPE STRING,
KOKRS TYPE STRING,
KOSTL TYPE STRING,
KSTRG TYPE STRING,
LSTAR TYPE STRING,
MANUM TYPE STRING,
MATNR TYPE STRING,
MIMAX TYPE STRING,
NORDER TYPE STRING,
NPERSOND TYPE STRING,
OBJKT TYPE STRING,
PAOBJNR TYPE STRING,
PBLNR TYPE STRING,
PHYNR TYPE STRING,
POSID TYPE STRING,
POSNR TYPE STRING,
PRCTR TYPE STRING,
PRUEFLOS TYPE STRING,
PRZNR TYPE STRING,
PSPID TYPE STRING,
PSPNR TYPE STRING,
PZLFH TYPE STRING,
QMNUM TYPE STRING,
RANL TYPE STRING,
RBESTO TYPE STRING,
RBKONT TYPE STRING,
RECN TYPE STRING,
RECN32 TYPE STRING,
RECNNR TYPE STRING,
RFHA TYPE STRING,
RIDXRT TYPE STRING,
RIDRTEXT TYPE STRING,
RIDBSTD TYPE STRING,
RMZHL TYPE STRING,
ROBJNR TYPE STRING,
RSART TYPE STRING,
RSERVI TYPE STRING,
RSNUM TYPE STRING,
RSPOS TYPE STRING,
RUBEST TYPE STRING,
RUECK TYPE STRING,
SAKNR TYPE STRING,
SEMPSL TYPE STRING,
SGENR TYPE STRING,
SGRNR TYPE STRING,
SMENR TYPE STRING,
SMIVE TYPE STRING,
SNKSL TYPE STRING,
SOBJART TYPE STRING,
SPEC_NO TYPE STRING,
SERVICE_DOC_ID TYPE STRING,
SERVICE_DOC_ITEM_ID TYPE STRING,
SVWNR TYPE STRING,
SWENR TYPE STRING,
TEILLOS TYPE STRING,
TL_PLNTY TYPE STRING,
TL_PLNNR TYPE STRING,
TL_PLNAL TYPE STRING,
TL_ZAEHL TYPE STRING,
TPLNR TYPE STRING,
TRPNR TYPE STRING,
TVERS TYPE STRING,
VBELN TYPE STRING,
VORLNR TYPE STRING,
VERID TYPE STRING,
VERSION TYPE STRING,
VSNMR TYPE STRING,
VTNUM_INT TYPE STRING,
WAPOS TYPE STRING,
WARPL TYPE STRING,
WERKS TYPE STRING,
WP_RANL TYPE STRING,
ZAEHL TYPE STRING,
ZEKKN TYPE STRING,
OBJNR_IW TYPE STRING,
OBJNR_IG TYPE STRING,
OBJNR_IB TYPE STRING,
OBJNR_IM TYPE STRING,
OBJNR_IV TYPE STRING,
OBJNR_IC TYPE STRING,
OBJNR_IA TYPE STRING,
OBJNR_IS TYPE STRING,
OBJNR_LONG TYPE STRING,
VTKEY TYPE STRING,
VTPOS TYPE STRING,
CU_ID TYPE STRING,
CMNUM TYPE STRING,
CUGUID TYPE STRING,
DESGUID TYPE STRING,
WAPNR TYPE STRING,
WAPINR TYPE STRING,
WCNR TYPE STRING,
WCITM TYPE STRING,
WCTYP TYPE STRING,END OF T_EKKO_STR. DATA: WA_IONRA_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_IONRA_STR-OBJNR sy-vline
WA_IONRA_STR-OBART sy-vline
WA_IONRA_STR-RCODE sy-vline
WA_IONRA_STR-ACNUM_INT sy-vline
WA_IONRA_STR-ACTN sy-vline
WA_IONRA_STR-AENNR sy-vline
WA_IONRA_STR-AETYP sy-vline
WA_IONRA_STR-ANLN1 sy-vline
WA_IONRA_STR-ANLN2 sy-vline
WA_IONRA_STR-AOBAR sy-vline
WA_IONRA_STR-AOTYP sy-vline
WA_IONRA_STR-APLZL sy-vline
WA_IONRA_STR-APLZL_VOR sy-vline
WA_IONRA_STR-APLZL_NCH sy-vline
WA_IONRA_STR-AUFNR sy-vline
WA_IONRA_STR-AUFPL sy-vline
WA_IONRA_STR-AUFPL_VOR sy-vline
WA_IONRA_STR-AUFPL_NCH sy-vline
WA_IONRA_STR-BEDID sy-vline
WA_IONRA_STR-BEDZL sy-vline
WA_IONRA_STR-BKKRS sy-vline
WA_IONRA_STR-BUKRS sy-vline
WA_IONRA_STR-BWVAR sy-vline
WA_IONRA_STR-BZOBJ sy-vline
WA_IONRA_STR-CANUM sy-vline
WA_IONRA_STR-CLINT sy-vline
WA_IONRA_STR-CO_POSNR sy-vline
WA_IONRA_STR-CTYP sy-vline
WA_IONRA_STR-DOKAR sy-vline
WA_IONRA_STR-DOKNR sy-vline
WA_IONRA_STR-DOKVR sy-vline
WA_IONRA_STR-DOKTL sy-vline
WA_IONRA_STR-DPERBEG sy-vline
WA_IONRA_STR-EBELN sy-vline
WA_IONRA_STR-EBELP sy-vline
WA_IONRA_STR-EBRID sy-vline
WA_IONRA_STR-EB_VERSION sy-vline
WA_IONRA_STR-EINRI sy-vline
WA_IONRA_STR-EQUNR sy-vline
WA_IONRA_STR-ERKRS sy-vline
WA_IONRA_STR-FALNR sy-vline
WA_IONRA_STR-FICTR sy-vline
WA_IONRA_STR-FIKRS sy-vline
WA_IONRA_STR-GSBER sy-vline
WA_IONRA_STR-IBASE sy-vline
WA_IONRA_STR-INSTANCE sy-vline
WA_IONRA_STR-IM_GJAHR sy-vline
WA_IONRA_STR-IM_PRNAM sy-vline
WA_IONRA_STR-IM_POSNR sy-vline
WA_IONRA_STR-IMA_POSNR sy-vline
WA_IONRA_STR-IMA_VARNT sy-vline
WA_IONRA_STR-ISLNR sy-vline
WA_IONRA_STR-ISMNR sy-vline
WA_IONRA_STR-KADKY sy-vline
WA_IONRA_STR-KALKA sy-vline
WA_IONRA_STR-KALN1 sy-vline
WA_IONRA_STR-KALNR sy-vline
WA_IONRA_STR-KANTE sy-vline
WA_IONRA_STR-KKZMA sy-vline
WA_IONRA_STR-KOKRS sy-vline
WA_IONRA_STR-KOSTL sy-vline
WA_IONRA_STR-KSTRG sy-vline
WA_IONRA_STR-LSTAR sy-vline
WA_IONRA_STR-MANUM sy-vline
WA_IONRA_STR-MATNR sy-vline
WA_IONRA_STR-MIMAX sy-vline
WA_IONRA_STR-NORDER sy-vline
WA_IONRA_STR-NPERSOND sy-vline
WA_IONRA_STR-OBJKT sy-vline
WA_IONRA_STR-PAOBJNR sy-vline
WA_IONRA_STR-PBLNR sy-vline
WA_IONRA_STR-PHYNR sy-vline
WA_IONRA_STR-POSID sy-vline
WA_IONRA_STR-POSNR sy-vline
WA_IONRA_STR-PRCTR sy-vline
WA_IONRA_STR-PRUEFLOS sy-vline
WA_IONRA_STR-PRZNR sy-vline
WA_IONRA_STR-PSPID sy-vline
WA_IONRA_STR-PSPNR sy-vline
WA_IONRA_STR-PZLFH sy-vline
WA_IONRA_STR-QMNUM sy-vline
WA_IONRA_STR-RANL sy-vline
WA_IONRA_STR-RBESTO sy-vline
WA_IONRA_STR-RBKONT sy-vline
WA_IONRA_STR-RECN sy-vline
WA_IONRA_STR-RECN32 sy-vline
WA_IONRA_STR-RECNNR sy-vline
WA_IONRA_STR-RFHA sy-vline
WA_IONRA_STR-RIDXRT sy-vline
WA_IONRA_STR-RIDRTEXT sy-vline
WA_IONRA_STR-RIDBSTD sy-vline
WA_IONRA_STR-RMZHL sy-vline
WA_IONRA_STR-ROBJNR sy-vline
WA_IONRA_STR-RSART sy-vline
WA_IONRA_STR-RSERVI sy-vline
WA_IONRA_STR-RSNUM sy-vline
WA_IONRA_STR-RSPOS sy-vline
WA_IONRA_STR-RUBEST sy-vline
WA_IONRA_STR-RUECK sy-vline
WA_IONRA_STR-SAKNR sy-vline
WA_IONRA_STR-SEMPSL sy-vline
WA_IONRA_STR-SGENR sy-vline
WA_IONRA_STR-SGRNR sy-vline
WA_IONRA_STR-SMENR sy-vline
WA_IONRA_STR-SMIVE sy-vline
WA_IONRA_STR-SNKSL sy-vline
WA_IONRA_STR-SOBJART sy-vline
WA_IONRA_STR-SPEC_NO sy-vline
WA_IONRA_STR-SERVICE_DOC_ID sy-vline
WA_IONRA_STR-SERVICE_DOC_ITEM_ID sy-vline
WA_IONRA_STR-SVWNR sy-vline
WA_IONRA_STR-SWENR sy-vline
WA_IONRA_STR-TEILLOS sy-vline
WA_IONRA_STR-TL_PLNTY sy-vline
WA_IONRA_STR-TL_PLNNR sy-vline
WA_IONRA_STR-TL_PLNAL sy-vline
WA_IONRA_STR-TL_ZAEHL sy-vline
WA_IONRA_STR-TPLNR sy-vline
WA_IONRA_STR-TRPNR sy-vline
WA_IONRA_STR-TVERS sy-vline
WA_IONRA_STR-VBELN sy-vline
WA_IONRA_STR-VORLNR sy-vline
WA_IONRA_STR-VERID sy-vline
WA_IONRA_STR-VERSION sy-vline
WA_IONRA_STR-VSNMR sy-vline
WA_IONRA_STR-VTNUM_INT sy-vline
WA_IONRA_STR-WAPOS sy-vline
WA_IONRA_STR-WARPL sy-vline
WA_IONRA_STR-WERKS sy-vline
WA_IONRA_STR-WP_RANL sy-vline
WA_IONRA_STR-ZAEHL sy-vline
WA_IONRA_STR-ZEKKN sy-vline
WA_IONRA_STR-OBJNR_IW sy-vline
WA_IONRA_STR-OBJNR_IG sy-vline
WA_IONRA_STR-OBJNR_IB sy-vline
WA_IONRA_STR-OBJNR_IM sy-vline
WA_IONRA_STR-OBJNR_IV sy-vline
WA_IONRA_STR-OBJNR_IC sy-vline
WA_IONRA_STR-OBJNR_IA sy-vline
WA_IONRA_STR-OBJNR_IS sy-vline
WA_IONRA_STR-OBJNR_LONG sy-vline
WA_IONRA_STR-VTKEY sy-vline
WA_IONRA_STR-VTPOS sy-vline
WA_IONRA_STR-CU_ID sy-vline
WA_IONRA_STR-CMNUM sy-vline
WA_IONRA_STR-CUGUID sy-vline
WA_IONRA_STR-DESGUID sy-vline
WA_IONRA_STR-WAPNR sy-vline
WA_IONRA_STR-WAPINR sy-vline
WA_IONRA_STR-WCNR sy-vline
WA_IONRA_STR-WCITM sy-vline
WA_IONRA_STR-WCTYP sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.