ABAP Select data from SAP table ACC_CYDETAIL 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 ACC_CYDETAIL 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 ACC_CYDETAIL. 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 ACC_CYDETAIL 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_ACC_CYDETAIL TYPE STANDARD TABLE OF ACC_CYDETAIL,
      WA_ACC_CYDETAIL TYPE ACC_CYDETAIL,
      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: <ACC_CYDETAIL> TYPE ACC_CYDETAIL.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ACC_CYDETAIL
*  INTO TABLE @DATA(IT_ACC_CYDETAIL2).
*--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_ACC_CYDETAIL INDEX 1 INTO DATA(WA_ACC_CYDETAIL2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_ACC_CYDETAIL ASSIGNING <ACC_CYDETAIL>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<ACC_CYDETAIL>-WERKS = 1.
<ACC_CYDETAIL>-ARBPL = 1.
<ACC_CYDETAIL>-KAPAR = 1.
<ACC_CYDETAIL>-PERIOD = 1.
<ACC_CYDETAIL>-BED_VERUR = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ACC_CYDETAIL-VORNR, sy-vline,
WA_ACC_CYDETAIL-AUART, sy-vline,
WA_ACC_CYDETAIL-BED_MENGE, sy-vline,
WA_ACC_CYDETAIL-BED_EINH, sy-vline,
WA_ACC_CYDETAIL-APRIO, sy-vline,
WA_ACC_CYDETAIL-BEDARF, sy-vline.
ENDLOOP. *Add any further fields from structure WA_ACC_CYDETAIL 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_ACC_CYDETAIL 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_ACC_CYDETAIL INTO WA_ACC_CYDETAIL. *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 BED_VERUR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-BED_VERUR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-BED_VERUR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field BED_EINH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-BED_EINH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-BED_EINH.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field LIEINH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-LIEINH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-LIEINH.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field KEINH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-KEINH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-KEINH.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field WRTZE CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-WRTZE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-WRTZE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field RSTZE CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-RSTZE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-RSTZE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field BEAZE CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-BEAZE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-BEAZE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field ARUZE CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-ARUZE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-ARUZE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field LIGZE CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-LIGZE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-LIGZE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRAZE CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-TRAZE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-TRAZE.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit NUMCV, internal->external for field STLNR CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-STLNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-STLNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field GMEIN CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-GMEIN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-GMEIN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field MEINH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-MEINH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-MEINH.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field ARBEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-ARBEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-ARBEH.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field DAUNE CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-DAUNE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-DAUNE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field EWDNE CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-EWDNE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-EWDNE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field VGE01 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-VGE01 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-VGE01.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field VGE02 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-VGE02 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-VGE02.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field VGE03 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-VGE03 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-VGE03.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field VGE04 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-VGE04 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-VGE04.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field VGE05 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-VGE05 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-VGE05.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field VGE06 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-VGE06 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-VGE06.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field USE04 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-USE04 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-USE04.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field USE05 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-USE05 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-USE05.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit CUNIT, internal->external for field MEINS CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-MEINS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-MEINS.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit PDATE, internal->external for field GBDAT CALL FUNCTION 'CONVERSION_EXIT_PDATE_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-GBDAT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-GBDAT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field LIEINHA CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ACC_CYDETAIL-LIEINHA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ACC_CYDETAIL-LIEINHA.
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_ACC_CYDETAIL_STR,
WERKS TYPE STRING,
ARBPL TYPE STRING,
KAPAR TYPE STRING,
PERIOD TYPE STRING,
BED_VERUR TYPE STRING,
VORNR TYPE STRING,
AUART TYPE STRING,
BED_MENGE TYPE STRING,
BED_EINH TYPE STRING,
APRIO TYPE STRING,
BEDARF TYPE STRING,
LIEINH TYPE STRING,
SSTAD TYPE STRING,
SENDD TYPE STRING,
KRUESOLL TYPE STRING,
KRUEREST TYPE STRING,
KBEASOLL TYPE STRING,
KBEAREST TYPE STRING,
KABRSOLL TYPE STRING,
KABRREST TYPE STRING,
KEINH TYPE STRING,
FSTAD TYPE STRING,
FSTAU TYPE STRING,
FENDD TYPE STRING,
FENDU TYPE STRING,
SSTAU TYPE STRING,
SENDU TYPE STRING,
ISTAD TYPE STRING,
ISTAU TYPE STRING,
IENDD TYPE STRING,
IENDU TYPE STRING,
KPVER TYPE STRING,
FSAVD TYPE STRING,
FSAVZ TYPE STRING,
FSSBD TYPE STRING,
FSSBZ TYPE STRING,
FSSAD TYPE STRING,
FSSAZ TYPE STRING,
FSEDD TYPE STRING,
FSEDZ TYPE STRING,
FSSLD TYPE STRING,
FSSLZ TYPE STRING,
FSELD TYPE STRING,
FSELZ TYPE STRING,
SSAVD TYPE STRING,
SSAVZ TYPE STRING,
SSSBD TYPE STRING,
SSSBZ TYPE STRING,
SSSAD TYPE STRING,
SSSAZ TYPE STRING,
SSEDD TYPE STRING,
SSEDZ TYPE STRING,
SSSLD TYPE STRING,
SSSLZ TYPE STRING,
SSELD TYPE STRING,
SSELZ TYPE STRING,
ISDD TYPE STRING,
ISDZ TYPE STRING,
IERD TYPE STRING,
IERZ TYPE STRING,
ISBD TYPE STRING,
ISBZ TYPE STRING,
IEBD TYPE STRING,
IEBZ TYPE STRING,
ISAD TYPE STRING,
ISAZ TYPE STRING,
IEDD TYPE STRING,
IEDZ TYPE STRING,
WARTZ TYPE STRING,
WRTZE TYPE STRING,
RUEST TYPE STRING,
RSTZE TYPE STRING,
BEARZ TYPE STRING,
BEAZE TYPE STRING,
ABRUE TYPE STRING,
ARUZE TYPE STRING,
LIEGZ TYPE STRING,
LIGZE TYPE STRING,
TRANZ TYPE STRING,
TRAZE TYPE STRING,
AUFNR TYPE STRING,
STLNR TYPE STRING,
DISPO TYPE STRING,
FEVOR TYPE STRING,
PVERW TYPE STRING,
PLNAW TYPE STRING,
PLGRP TYPE STRING,
FTRMP TYPE STRING,
GLTRP TYPE STRING,
GSTRP TYPE STRING,
FTRMS TYPE STRING,
GLTRS TYPE STRING,
GSTRS TYPE STRING,
GSTRI TYPE STRING,
GLTRI TYPE STRING,
FTRMI TYPE STRING,
GAMNG TYPE STRING,
GMEIN TYPE STRING,
AUTYP TYPE STRING,
REDKZ TYPE STRING,
REFNR TYPE STRING,
KTEXT TYPE STRING,
BUKRS TYPE STRING,
GSBER TYPE STRING,
KOKRS TYPE STRING,
CCKEY TYPE STRING,
PRONR TYPE STRING,
PROJN TYPE STRING,
RUECK TYPE STRING,
CY_SEQNR TYPE STRING,
CY_SEQNRV TYPE STRING,
EQUNR TYPE STRING,
TPLNR TYPE STRING,
QUALF TYPE STRING,
BAUTL TYPE STRING,
ILOAN TYPE STRING,
IWERK TYPE STRING,
INGPR TYPE STRING,
APGRP TYPE STRING,
KUNUM TYPE STRING,
ANLBD TYPE STRING,
WARPL TYPE STRING,
LAUFN TYPE STRING,
QMNUM TYPE STRING,
VAWRK TYPE STRING,
VAPLZ TYPE STRING,
VATXT TYPE STRING,
INNAM TYPE STRING,
KDAUF TYPE STRING,
KDPOS TYPE STRING,
LGORT TYPE STRING,
VERID TYPE STRING,
CHARG TYPE STRING,
NAME1 TYPE STRING,
PLNNR TYPE STRING,
PLNAL TYPE STRING,
PLNFL TYPE STRING,
PLNTY TYPE STRING,
UVORN TYPE STRING,
LTXA1 TYPE STRING,
LOART TYPE STRING,
MGVRG TYPE STRING,
MEINH TYPE STRING,
RFGRP TYPE STRING,
RFSCH TYPE STRING,
RASCH TYPE STRING,
ARBEI TYPE STRING,
ARBEH TYPE STRING,
PSTXTTI TYPE STRING,
DAUNO TYPE STRING,
DAUNE TYPE STRING,
EWDAN TYPE STRING,
EWDNE TYPE STRING,
OFMNW TYPE STRING,
ASVRG TYPE STRING,
VGE01 TYPE STRING,
VGW01 TYPE STRING,
VGE02 TYPE STRING,
VGW02 TYPE STRING,
VGE03 TYPE STRING,
VGW03 TYPE STRING,
VGE04 TYPE STRING,
VGW04 TYPE STRING,
VGE05 TYPE STRING,
VGW05 TYPE STRING,
VGE06 TYPE STRING,
VGW06 TYPE STRING,
USR00 TYPE STRING,
USR01 TYPE STRING,
USR02 TYPE STRING,
USR03 TYPE STRING,
USR04 TYPE STRING,
USE04 TYPE STRING,
USR05 TYPE STRING,
USE05 TYPE STRING,
USR06 TYPE STRING,
USE06 TYPE STRING,
USR07 TYPE STRING,
USE07 TYPE STRING,
USR08 TYPE STRING,
USR09 TYPE STRING,
USR10 TYPE STRING,
USR11 TYPE STRING,
VNAME TYPE STRING,
PLNUM TYPE STRING,
MATNR TYPE STRING,
PLWRK TYPE STRING,
PWWRK TYPE STRING,
PAART TYPE STRING,
GSMNG TYPE STRING,
MEINS TYPE STRING,
SERNR TYPE STRING,
PLSCN TYPE STRING,
KAPFX TYPE STRING,
SEQNR TYPE STRING,
ABKRS TYPE STRING,
KOSTL TYPE STRING,
PSTTR TYPE STRING,
PEDTR TYPE STRING,
PERNR TYPE STRING,
OTYPE TYPE STRING,
ORGEH TYPE STRING,
ORGEH_TXT TYPE STRING,
BEGDA TYPE STRING,
ENDDA TYPE STRING,
PLANS TYPE STRING,
PLANS_TXT TYPE STRING,
STELL TYPE STRING,
STELL_TXT TYPE STRING,
ENAME TYPE STRING,
TITEL TYPE STRING,
GBDAT TYPE STRING,
FAMST TYPE STRING,
PSTLZ TYPE STRING,
ORT01 TYPE STRING,
STRAS TYPE STRING,
ANRED TYPE STRING,
NATIO TYPE STRING,
VERWE TYPE STRING,
VERAN TYPE STRING,
MATYP TYPE STRING,
ARBPLTEXT TYPE STRING,
AZMAX TYPE STRING,
KAPARTEXT TYPE STRING,
NAME TYPE STRING,
PLANR TYPE STRING,
POOLK TYPE STRING,
MEHR TYPE STRING,
IBEDARF TYPE STRING,
SBEDARF TYPE STRING,
VRG_ARBPL TYPE STRING,
VRG_ARBPLT TYPE STRING,
STATUS TYPE STRING,
STATUV TYPE STRING,
MATTEXT TYPE STRING,
ANGEB TYPE STRING,
LIEINHA TYPE STRING,
STTXT TYPE STRING,
ISTRUEST TYPE STRING,
ISTBEARB TYPE STRING,
ISTABRUE TYPE STRING,
ANZZL TYPE STRING,
BSTKZ TYPE STRING,
SAFNR TYPE STRING,
GSTRU TYPE STRING,
VSNDA TYPE STRING,
VONDAT TYPE STRING,
BISDAT TYPE STRING,
PERIV TYPE STRING,
MENGE TYPE STRING,
VRSIO TYPE STRING,
VSNMR TYPE STRING,END OF T_EKKO_STR. DATA: WA_ACC_CYDETAIL_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_ACC_CYDETAIL_STR-WERKS sy-vline
WA_ACC_CYDETAIL_STR-ARBPL sy-vline
WA_ACC_CYDETAIL_STR-KAPAR sy-vline
WA_ACC_CYDETAIL_STR-PERIOD sy-vline
WA_ACC_CYDETAIL_STR-BED_VERUR sy-vline
WA_ACC_CYDETAIL_STR-VORNR sy-vline
WA_ACC_CYDETAIL_STR-AUART sy-vline
WA_ACC_CYDETAIL_STR-BED_MENGE sy-vline
WA_ACC_CYDETAIL_STR-BED_EINH sy-vline
WA_ACC_CYDETAIL_STR-APRIO sy-vline
WA_ACC_CYDETAIL_STR-BEDARF sy-vline
WA_ACC_CYDETAIL_STR-LIEINH sy-vline
WA_ACC_CYDETAIL_STR-SSTAD sy-vline
WA_ACC_CYDETAIL_STR-SENDD sy-vline
WA_ACC_CYDETAIL_STR-KRUESOLL sy-vline
WA_ACC_CYDETAIL_STR-KRUEREST sy-vline
WA_ACC_CYDETAIL_STR-KBEASOLL sy-vline
WA_ACC_CYDETAIL_STR-KBEAREST sy-vline
WA_ACC_CYDETAIL_STR-KABRSOLL sy-vline
WA_ACC_CYDETAIL_STR-KABRREST sy-vline
WA_ACC_CYDETAIL_STR-KEINH sy-vline
WA_ACC_CYDETAIL_STR-FSTAD sy-vline
WA_ACC_CYDETAIL_STR-FSTAU sy-vline
WA_ACC_CYDETAIL_STR-FENDD sy-vline
WA_ACC_CYDETAIL_STR-FENDU sy-vline
WA_ACC_CYDETAIL_STR-SSTAU sy-vline
WA_ACC_CYDETAIL_STR-SENDU sy-vline
WA_ACC_CYDETAIL_STR-ISTAD sy-vline
WA_ACC_CYDETAIL_STR-ISTAU sy-vline
WA_ACC_CYDETAIL_STR-IENDD sy-vline
WA_ACC_CYDETAIL_STR-IENDU sy-vline
WA_ACC_CYDETAIL_STR-KPVER sy-vline
WA_ACC_CYDETAIL_STR-FSAVD sy-vline
WA_ACC_CYDETAIL_STR-FSAVZ sy-vline
WA_ACC_CYDETAIL_STR-FSSBD sy-vline
WA_ACC_CYDETAIL_STR-FSSBZ sy-vline
WA_ACC_CYDETAIL_STR-FSSAD sy-vline
WA_ACC_CYDETAIL_STR-FSSAZ sy-vline
WA_ACC_CYDETAIL_STR-FSEDD sy-vline
WA_ACC_CYDETAIL_STR-FSEDZ sy-vline
WA_ACC_CYDETAIL_STR-FSSLD sy-vline
WA_ACC_CYDETAIL_STR-FSSLZ sy-vline
WA_ACC_CYDETAIL_STR-FSELD sy-vline
WA_ACC_CYDETAIL_STR-FSELZ sy-vline
WA_ACC_CYDETAIL_STR-SSAVD sy-vline
WA_ACC_CYDETAIL_STR-SSAVZ sy-vline
WA_ACC_CYDETAIL_STR-SSSBD sy-vline
WA_ACC_CYDETAIL_STR-SSSBZ sy-vline
WA_ACC_CYDETAIL_STR-SSSAD sy-vline
WA_ACC_CYDETAIL_STR-SSSAZ sy-vline
WA_ACC_CYDETAIL_STR-SSEDD sy-vline
WA_ACC_CYDETAIL_STR-SSEDZ sy-vline
WA_ACC_CYDETAIL_STR-SSSLD sy-vline
WA_ACC_CYDETAIL_STR-SSSLZ sy-vline
WA_ACC_CYDETAIL_STR-SSELD sy-vline
WA_ACC_CYDETAIL_STR-SSELZ sy-vline
WA_ACC_CYDETAIL_STR-ISDD sy-vline
WA_ACC_CYDETAIL_STR-ISDZ sy-vline
WA_ACC_CYDETAIL_STR-IERD sy-vline
WA_ACC_CYDETAIL_STR-IERZ sy-vline
WA_ACC_CYDETAIL_STR-ISBD sy-vline
WA_ACC_CYDETAIL_STR-ISBZ sy-vline
WA_ACC_CYDETAIL_STR-IEBD sy-vline
WA_ACC_CYDETAIL_STR-IEBZ sy-vline
WA_ACC_CYDETAIL_STR-ISAD sy-vline
WA_ACC_CYDETAIL_STR-ISAZ sy-vline
WA_ACC_CYDETAIL_STR-IEDD sy-vline
WA_ACC_CYDETAIL_STR-IEDZ sy-vline
WA_ACC_CYDETAIL_STR-WARTZ sy-vline
WA_ACC_CYDETAIL_STR-WRTZE sy-vline
WA_ACC_CYDETAIL_STR-RUEST sy-vline
WA_ACC_CYDETAIL_STR-RSTZE sy-vline
WA_ACC_CYDETAIL_STR-BEARZ sy-vline
WA_ACC_CYDETAIL_STR-BEAZE sy-vline
WA_ACC_CYDETAIL_STR-ABRUE sy-vline
WA_ACC_CYDETAIL_STR-ARUZE sy-vline
WA_ACC_CYDETAIL_STR-LIEGZ sy-vline
WA_ACC_CYDETAIL_STR-LIGZE sy-vline
WA_ACC_CYDETAIL_STR-TRANZ sy-vline
WA_ACC_CYDETAIL_STR-TRAZE sy-vline
WA_ACC_CYDETAIL_STR-AUFNR sy-vline
WA_ACC_CYDETAIL_STR-STLNR sy-vline
WA_ACC_CYDETAIL_STR-DISPO sy-vline
WA_ACC_CYDETAIL_STR-FEVOR sy-vline
WA_ACC_CYDETAIL_STR-PVERW sy-vline
WA_ACC_CYDETAIL_STR-PLNAW sy-vline
WA_ACC_CYDETAIL_STR-PLGRP sy-vline
WA_ACC_CYDETAIL_STR-FTRMP sy-vline
WA_ACC_CYDETAIL_STR-GLTRP sy-vline
WA_ACC_CYDETAIL_STR-GSTRP sy-vline
WA_ACC_CYDETAIL_STR-FTRMS sy-vline
WA_ACC_CYDETAIL_STR-GLTRS sy-vline
WA_ACC_CYDETAIL_STR-GSTRS sy-vline
WA_ACC_CYDETAIL_STR-GSTRI sy-vline
WA_ACC_CYDETAIL_STR-GLTRI sy-vline
WA_ACC_CYDETAIL_STR-FTRMI sy-vline
WA_ACC_CYDETAIL_STR-GAMNG sy-vline
WA_ACC_CYDETAIL_STR-GMEIN sy-vline
WA_ACC_CYDETAIL_STR-AUTYP sy-vline
WA_ACC_CYDETAIL_STR-REDKZ sy-vline
WA_ACC_CYDETAIL_STR-REFNR sy-vline
WA_ACC_CYDETAIL_STR-KTEXT sy-vline
WA_ACC_CYDETAIL_STR-BUKRS sy-vline
WA_ACC_CYDETAIL_STR-GSBER sy-vline
WA_ACC_CYDETAIL_STR-KOKRS sy-vline
WA_ACC_CYDETAIL_STR-CCKEY sy-vline
WA_ACC_CYDETAIL_STR-PRONR sy-vline
WA_ACC_CYDETAIL_STR-PROJN sy-vline
WA_ACC_CYDETAIL_STR-RUECK sy-vline
WA_ACC_CYDETAIL_STR-CY_SEQNR sy-vline
WA_ACC_CYDETAIL_STR-CY_SEQNRV sy-vline
WA_ACC_CYDETAIL_STR-EQUNR sy-vline
WA_ACC_CYDETAIL_STR-TPLNR sy-vline
WA_ACC_CYDETAIL_STR-QUALF sy-vline
WA_ACC_CYDETAIL_STR-BAUTL sy-vline
WA_ACC_CYDETAIL_STR-ILOAN sy-vline
WA_ACC_CYDETAIL_STR-IWERK sy-vline
WA_ACC_CYDETAIL_STR-INGPR sy-vline
WA_ACC_CYDETAIL_STR-APGRP sy-vline
WA_ACC_CYDETAIL_STR-KUNUM sy-vline
WA_ACC_CYDETAIL_STR-ANLBD sy-vline
WA_ACC_CYDETAIL_STR-WARPL sy-vline
WA_ACC_CYDETAIL_STR-LAUFN sy-vline
WA_ACC_CYDETAIL_STR-QMNUM sy-vline
WA_ACC_CYDETAIL_STR-VAWRK sy-vline
WA_ACC_CYDETAIL_STR-VAPLZ sy-vline
WA_ACC_CYDETAIL_STR-VATXT sy-vline
WA_ACC_CYDETAIL_STR-INNAM sy-vline
WA_ACC_CYDETAIL_STR-KDAUF sy-vline
WA_ACC_CYDETAIL_STR-KDPOS sy-vline
WA_ACC_CYDETAIL_STR-LGORT sy-vline
WA_ACC_CYDETAIL_STR-VERID sy-vline
WA_ACC_CYDETAIL_STR-CHARG sy-vline
WA_ACC_CYDETAIL_STR-NAME1 sy-vline
WA_ACC_CYDETAIL_STR-PLNNR sy-vline
WA_ACC_CYDETAIL_STR-PLNAL sy-vline
WA_ACC_CYDETAIL_STR-PLNFL sy-vline
WA_ACC_CYDETAIL_STR-PLNTY sy-vline
WA_ACC_CYDETAIL_STR-UVORN sy-vline
WA_ACC_CYDETAIL_STR-LTXA1 sy-vline
WA_ACC_CYDETAIL_STR-LOART sy-vline
WA_ACC_CYDETAIL_STR-MGVRG sy-vline
WA_ACC_CYDETAIL_STR-MEINH sy-vline
WA_ACC_CYDETAIL_STR-RFGRP sy-vline
WA_ACC_CYDETAIL_STR-RFSCH sy-vline
WA_ACC_CYDETAIL_STR-RASCH sy-vline
WA_ACC_CYDETAIL_STR-ARBEI sy-vline
WA_ACC_CYDETAIL_STR-ARBEH sy-vline
WA_ACC_CYDETAIL_STR-PSTXTTI sy-vline
WA_ACC_CYDETAIL_STR-DAUNO sy-vline
WA_ACC_CYDETAIL_STR-DAUNE sy-vline
WA_ACC_CYDETAIL_STR-EWDAN sy-vline
WA_ACC_CYDETAIL_STR-EWDNE sy-vline
WA_ACC_CYDETAIL_STR-OFMNW sy-vline
WA_ACC_CYDETAIL_STR-ASVRG sy-vline
WA_ACC_CYDETAIL_STR-VGE01 sy-vline
WA_ACC_CYDETAIL_STR-VGW01 sy-vline
WA_ACC_CYDETAIL_STR-VGE02 sy-vline
WA_ACC_CYDETAIL_STR-VGW02 sy-vline
WA_ACC_CYDETAIL_STR-VGE03 sy-vline
WA_ACC_CYDETAIL_STR-VGW03 sy-vline
WA_ACC_CYDETAIL_STR-VGE04 sy-vline
WA_ACC_CYDETAIL_STR-VGW04 sy-vline
WA_ACC_CYDETAIL_STR-VGE05 sy-vline
WA_ACC_CYDETAIL_STR-VGW05 sy-vline
WA_ACC_CYDETAIL_STR-VGE06 sy-vline
WA_ACC_CYDETAIL_STR-VGW06 sy-vline
WA_ACC_CYDETAIL_STR-USR00 sy-vline
WA_ACC_CYDETAIL_STR-USR01 sy-vline
WA_ACC_CYDETAIL_STR-USR02 sy-vline
WA_ACC_CYDETAIL_STR-USR03 sy-vline
WA_ACC_CYDETAIL_STR-USR04 sy-vline
WA_ACC_CYDETAIL_STR-USE04 sy-vline
WA_ACC_CYDETAIL_STR-USR05 sy-vline
WA_ACC_CYDETAIL_STR-USE05 sy-vline
WA_ACC_CYDETAIL_STR-USR06 sy-vline
WA_ACC_CYDETAIL_STR-USE06 sy-vline
WA_ACC_CYDETAIL_STR-USR07 sy-vline
WA_ACC_CYDETAIL_STR-USE07 sy-vline
WA_ACC_CYDETAIL_STR-USR08 sy-vline
WA_ACC_CYDETAIL_STR-USR09 sy-vline
WA_ACC_CYDETAIL_STR-USR10 sy-vline
WA_ACC_CYDETAIL_STR-USR11 sy-vline
WA_ACC_CYDETAIL_STR-VNAME sy-vline
WA_ACC_CYDETAIL_STR-PLNUM sy-vline
WA_ACC_CYDETAIL_STR-MATNR sy-vline
WA_ACC_CYDETAIL_STR-PLWRK sy-vline
WA_ACC_CYDETAIL_STR-PWWRK sy-vline
WA_ACC_CYDETAIL_STR-PAART sy-vline
WA_ACC_CYDETAIL_STR-GSMNG sy-vline
WA_ACC_CYDETAIL_STR-MEINS sy-vline
WA_ACC_CYDETAIL_STR-SERNR sy-vline
WA_ACC_CYDETAIL_STR-PLSCN sy-vline
WA_ACC_CYDETAIL_STR-KAPFX sy-vline
WA_ACC_CYDETAIL_STR-SEQNR sy-vline
WA_ACC_CYDETAIL_STR-ABKRS sy-vline
WA_ACC_CYDETAIL_STR-KOSTL sy-vline
WA_ACC_CYDETAIL_STR-PSTTR sy-vline
WA_ACC_CYDETAIL_STR-PEDTR sy-vline
WA_ACC_CYDETAIL_STR-PERNR sy-vline
WA_ACC_CYDETAIL_STR-OTYPE sy-vline
WA_ACC_CYDETAIL_STR-ORGEH sy-vline
WA_ACC_CYDETAIL_STR-ORGEH_TXT sy-vline
WA_ACC_CYDETAIL_STR-BEGDA sy-vline
WA_ACC_CYDETAIL_STR-ENDDA sy-vline
WA_ACC_CYDETAIL_STR-PLANS sy-vline
WA_ACC_CYDETAIL_STR-PLANS_TXT sy-vline
WA_ACC_CYDETAIL_STR-STELL sy-vline
WA_ACC_CYDETAIL_STR-STELL_TXT sy-vline
WA_ACC_CYDETAIL_STR-ENAME sy-vline
WA_ACC_CYDETAIL_STR-TITEL sy-vline
WA_ACC_CYDETAIL_STR-GBDAT sy-vline
WA_ACC_CYDETAIL_STR-FAMST sy-vline
WA_ACC_CYDETAIL_STR-PSTLZ sy-vline
WA_ACC_CYDETAIL_STR-ORT01 sy-vline
WA_ACC_CYDETAIL_STR-STRAS sy-vline
WA_ACC_CYDETAIL_STR-ANRED sy-vline
WA_ACC_CYDETAIL_STR-NATIO sy-vline
WA_ACC_CYDETAIL_STR-VERWE sy-vline
WA_ACC_CYDETAIL_STR-VERAN sy-vline
WA_ACC_CYDETAIL_STR-MATYP sy-vline
WA_ACC_CYDETAIL_STR-ARBPLTEXT sy-vline
WA_ACC_CYDETAIL_STR-AZMAX sy-vline
WA_ACC_CYDETAIL_STR-KAPARTEXT sy-vline
WA_ACC_CYDETAIL_STR-NAME sy-vline
WA_ACC_CYDETAIL_STR-PLANR sy-vline
WA_ACC_CYDETAIL_STR-POOLK sy-vline
WA_ACC_CYDETAIL_STR-MEHR sy-vline
WA_ACC_CYDETAIL_STR-IBEDARF sy-vline
WA_ACC_CYDETAIL_STR-SBEDARF sy-vline
WA_ACC_CYDETAIL_STR-VRG_ARBPL sy-vline
WA_ACC_CYDETAIL_STR-VRG_ARBPLT sy-vline
WA_ACC_CYDETAIL_STR-STATUS sy-vline
WA_ACC_CYDETAIL_STR-STATUV sy-vline
WA_ACC_CYDETAIL_STR-MATTEXT sy-vline
WA_ACC_CYDETAIL_STR-ANGEB sy-vline
WA_ACC_CYDETAIL_STR-LIEINHA sy-vline
WA_ACC_CYDETAIL_STR-STTXT sy-vline
WA_ACC_CYDETAIL_STR-ISTRUEST sy-vline
WA_ACC_CYDETAIL_STR-ISTBEARB sy-vline
WA_ACC_CYDETAIL_STR-ISTABRUE sy-vline
WA_ACC_CYDETAIL_STR-ANZZL sy-vline
WA_ACC_CYDETAIL_STR-BSTKZ sy-vline
WA_ACC_CYDETAIL_STR-SAFNR sy-vline
WA_ACC_CYDETAIL_STR-GSTRU sy-vline
WA_ACC_CYDETAIL_STR-VSNDA sy-vline
WA_ACC_CYDETAIL_STR-VONDAT sy-vline
WA_ACC_CYDETAIL_STR-BISDAT sy-vline
WA_ACC_CYDETAIL_STR-PERIV sy-vline
WA_ACC_CYDETAIL_STR-MENGE sy-vline
WA_ACC_CYDETAIL_STR-VRSIO sy-vline
WA_ACC_CYDETAIL_STR-VSNMR sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.