ABAP Select data from SAP table RELS_FLURST_HIERARCHIE 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 RELS_FLURST_HIERARCHIE 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 RELS_FLURST_HIERARCHIE. 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 RELS_FLURST_HIERARCHIE 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_RELS_FLURST_HIERARCHIE TYPE STANDARD TABLE OF RELS_FLURST_HIERARCHIE,
      WA_RELS_FLURST_HIERARCHIE TYPE RELS_FLURST_HIERARCHIE,
      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: <RELS_FLURST_HIERARCHIE> TYPE RELS_FLURST_HIERARCHIE.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RELS_FLURST_HIERARCHIE
*  INTO TABLE @DATA(IT_RELS_FLURST_HIERARCHIE2).
*--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_RELS_FLURST_HIERARCHIE INDEX 1 INTO DATA(WA_RELS_FLURST_HIERARCHIE2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_RELS_FLURST_HIERARCHIE ASSIGNING <RELS_FLURST_HIERARCHIE>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<RELS_FLURST_HIERARCHIE>-MANDT = 1.
<RELS_FLURST_HIERARCHIE>-LFDNR = 1.
<RELS_FLURST_HIERARCHIE>-EBENE = 1.
<RELS_FLURST_HIERARCHIE>-XLBEZ = 1.
<RELS_FLURST_HIERARCHIE>-PARTNR2 = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RELS_FLURST_HIERARCHIE-PARTNAME2, sy-vline,
WA_RELS_FLURST_HIERARCHIE-PARTNR1, sy-vline,
WA_RELS_FLURST_HIERARCHIE-PARTNAME1, sy-vline,
WA_RELS_FLURST_HIERARCHIE-INTRENO_FL, sy-vline,
WA_RELS_FLURST_HIERARCHIE-LAND1, sy-vline,
WA_RELS_FLURST_HIERARCHIE-LANDX, sy-vline.
ENDLOOP. *Add any further fields from structure WA_RELS_FLURST_HIERARCHIE 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_RELS_FLURST_HIERARCHIE 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_RELS_FLURST_HIERARCHIE INTO WA_RELS_FLURST_HIERARCHIE. *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 PARTNR2 CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RELS_FLURST_HIERARCHIE-PARTNR2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RELS_FLURST_HIERARCHIE-PARTNR2.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field FEINS_SN CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_RELS_FLURST_HIERARCHIE-FEINS_SN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RELS_FLURST_HIERARCHIE-FEINS_SN.
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_RELS_FLURST_HIERARCHIE_STR,
MANDT TYPE STRING,
LFDNR TYPE STRING,
EBENE TYPE STRING,
XLBEZ TYPE STRING,
PARTNR2 TYPE STRING,
PARTNAME2 TYPE STRING,
PARTNR1 TYPE STRING,
PARTNAME1 TYPE STRING,
INTRENO_FL TYPE STRING,
LAND1 TYPE STRING,
LANDX TYPE STRING,
BUNDESLAND TYPE STRING,
BEZEI TYPE STRING,
GEMARKUNG TYPE STRING,
XGEMARK TYPE STRING,
FLUR TYPE STRING,
FLURSTUECK TYPE STRING,
KREIS TYPE STRING,
XKREIS TYPE STRING,
GEMEINDE TYPE STRING,
XGEMEINDE TYPE STRING,
REGBEZIRK TYPE STRING,
XMADMDIST TYPE STRING,
STADTBEZIRK TYPE STRING,
XMCITDIST TYPE STRING,
STADTTEIL TYPE STRING,
XMCITSEC TYPE STRING,
PARTNR_KATAMT TYPE STRING,
PARTNR_KATAMT_EXT TYPE STRING,
NAME_KATAMT TYPE STRING,
KUNNR_KATAMT TYPE STRING,
BIEXIST TYPE STRING,
LBEXIST TYPE STRING,
FLAECHE_KAT TYPE STRING,
FEINS_KAT TYPE STRING,
COUNTRY TYPE STRING,
STATE TYPE STRING,
SLIDENUM TYPE STRING,
CLASSIFICATION TYPE STRING,
XMCLASS TYPE STRING,
FLAECHE_NA TYPE STRING,
FEINS_NA TYPE STRING,
BODENKLASSE TYPE STRING,
XBODENKLASSE TYPE STRING,
ZUSTANDSSTUFE TYPE STRING,
BODENART TYPE STRING,
XBODENART TYPE STRING,
EMZ TYPE STRING,
FARMLANDDIGIT TYPE STRING,
PARTNR_WEIGE TYPE STRING,
PARTNR_WEIGE_EXT TYPE STRING,
VBUND_WEIGE TYPE STRING,
NAME_WEIGE TYPE STRING,
KUNNR_WEIGE TYPE STRING,
PARTID TYPE STRING,
VERTR_BINDUNG TYPE STRING,
VERTR_BINDUNG_FEINS TYPE STRING,
NUTZUNGSFLAECHE TYPE STRING,
NUTZUNGSFLAECHE_FEINS TYPE STRING,
VERTRAGSFLAECHE TYPE STRING,
VERTRAGSFLAECHE_FEINS TYPE STRING,
BESITZFLAECHE TYPE STRING,
BESITZFLAECHE_FEINS TYPE STRING,
EIGENTUMSFLAECHE TYPE STRING,
EIGENTUMSFLAECHE_FEINS TYPE STRING,
GUELTIG_VON_WE TYPE STRING,
GUELTIG_BIS_WE TYPE STRING,
BRUCHT_ZAEHL TYPE STRING,
BRUCHT_NENNER TYPE STRING,
GESAMT_ZAEHL TYPE STRING,
GESAMT_NENNER TYPE STRING,
FLAG_GRUNDB TYPE STRING,
SGRUNDB TYPE STRING,
SGBVON TYPE STRING,
XGBVON TYPE STRING,
NBANDNR TYPE STRING,
NBLATTNR TYPE STRING,
SGRBA TYPE STRING,
XLBEZ_GB TYPE STRING,
SBVNR TYPE STRING,
FLAECHE_GRUNDB TYPE STRING,
FEINS_GRUNDB TYPE STRING,
MITEIGTZ TYPE STRING,
MITEIGTN TYPE STRING,
GUELTIG_VON_BVNR TYPE STRING,
PARTNR_EIGE TYPE STRING,
PARTNR_EIGE_EXT TYPE STRING,
VBUND_EIGE TYPE STRING,
NAME_EIGE TYPE STRING,
KUNNR_EIGE TYPE STRING,
BRUCHTZ TYPE STRING,
BRUCHTN TYPE STRING,
GESHNDZ TYPE STRING,
GESHNDN TYPE STRING,
GUELTIG_VON_EIGE TYPE STRING,
PARTNR_JEIGE TYPE STRING,
PARTNR_JEIGE_EXT TYPE STRING,
VBUND_JEIGE TYPE STRING,
NAME_JEIGE TYPE STRING,
KUNNR_JEIGE TYPE STRING,
NUTZUNGSART TYPE STRING,
XNUTZUNGSART TYPE STRING,
UNTERNUTZUNGSART TYPE STRING,
XUNUTZUNGSART TYPE STRING,
GRUPPE TYPE STRING,
XGRUPPE TYPE STRING,
BETRIEBSNOTW TYPE STRING,
FLAECHE_INA TYPE STRING,
FEINS_INA TYPE STRING,
IEP_NUTZUNGSART TYPE STRING,
IEP_XNUTZUNGSART TYPE STRING,
IEP_UNTERNUTZUNGSART TYPE STRING,
IEP_XUNUTZUNGSART TYPE STRING,
IEP_GRUPPE TYPE STRING,
IEP_XGRUPPE TYPE STRING,
IEP_BETRIEBSNOTW TYPE STRING,
IEP_REALISIERUNG_AB TYPE STRING,
IEP_FLAECHE TYPE STRING,
IEP_FEINS TYPE STRING,
KZ_AN TYPE STRING,
BUKRS_AN TYPE STRING,
SWENR TYPE STRING,
ANLN1 TYPE STRING,
ANLN2 TYPE STRING,
ANLKL TYPE STRING,
TXK50 TYPE STRING,
FLAECHE_AN TYPE STRING,
FEINS_AN TYPE STRING,
KANSW_HR TYPE STRING,
WAERS_HR TYPE STRING,
KANSW_SB TYPE STRING,
WAERS_SB TYPE STRING,
KANSW_KO TYPE STRING,
WAERS_KO TYPE STRING,
KANSW_S1 TYPE STRING,
WAERS_S1 TYPE STRING,
KANSW_S2 TYPE STRING,
WAERS_S2 TYPE STRING,
FLAECHE_ART TYPE STRING,
XFLAECHE_ART TYPE STRING,
FLAECHE_SN TYPE STRING,
FEINS_SN TYPE STRING,
FLURSTKZ TYPE STRING,END OF T_EKKO_STR. DATA: WA_RELS_FLURST_HIERARCHIE_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_RELS_FLURST_HIERARCHIE_STR-MANDT sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-LFDNR sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-EBENE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XLBEZ sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-PARTNR2 sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-PARTNAME2 sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-PARTNR1 sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-PARTNAME1 sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-INTRENO_FL sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-LAND1 sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-LANDX sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-BUNDESLAND sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-BEZEI sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-GEMARKUNG sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XGEMARK sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FLUR sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FLURSTUECK sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-KREIS sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XKREIS sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-GEMEINDE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XGEMEINDE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-REGBEZIRK sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XMADMDIST sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-STADTBEZIRK sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XMCITDIST sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-STADTTEIL sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XMCITSEC sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-PARTNR_KATAMT sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-PARTNR_KATAMT_EXT sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-NAME_KATAMT sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-KUNNR_KATAMT sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-BIEXIST sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-LBEXIST sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FLAECHE_KAT sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FEINS_KAT sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-COUNTRY sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-STATE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-SLIDENUM sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-CLASSIFICATION sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XMCLASS sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FLAECHE_NA sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FEINS_NA sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-BODENKLASSE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XBODENKLASSE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-ZUSTANDSSTUFE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-BODENART sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XBODENART sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-EMZ sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FARMLANDDIGIT sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-PARTNR_WEIGE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-PARTNR_WEIGE_EXT sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-VBUND_WEIGE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-NAME_WEIGE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-KUNNR_WEIGE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-PARTID sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-VERTR_BINDUNG sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-VERTR_BINDUNG_FEINS sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-NUTZUNGSFLAECHE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-NUTZUNGSFLAECHE_FEINS sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-VERTRAGSFLAECHE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-VERTRAGSFLAECHE_FEINS sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-BESITZFLAECHE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-BESITZFLAECHE_FEINS sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-EIGENTUMSFLAECHE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-EIGENTUMSFLAECHE_FEINS sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-GUELTIG_VON_WE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-GUELTIG_BIS_WE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-BRUCHT_ZAEHL sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-BRUCHT_NENNER sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-GESAMT_ZAEHL sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-GESAMT_NENNER sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FLAG_GRUNDB sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-SGRUNDB sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-SGBVON sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XGBVON sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-NBANDNR sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-NBLATTNR sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-SGRBA sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XLBEZ_GB sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-SBVNR sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FLAECHE_GRUNDB sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FEINS_GRUNDB sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-MITEIGTZ sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-MITEIGTN sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-GUELTIG_VON_BVNR sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-PARTNR_EIGE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-PARTNR_EIGE_EXT sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-VBUND_EIGE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-NAME_EIGE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-KUNNR_EIGE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-BRUCHTZ sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-BRUCHTN sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-GESHNDZ sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-GESHNDN sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-GUELTIG_VON_EIGE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-PARTNR_JEIGE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-PARTNR_JEIGE_EXT sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-VBUND_JEIGE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-NAME_JEIGE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-KUNNR_JEIGE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-NUTZUNGSART sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XNUTZUNGSART sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-UNTERNUTZUNGSART sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XUNUTZUNGSART sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-GRUPPE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XGRUPPE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-BETRIEBSNOTW sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FLAECHE_INA sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FEINS_INA sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-IEP_NUTZUNGSART sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-IEP_XNUTZUNGSART sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-IEP_UNTERNUTZUNGSART sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-IEP_XUNUTZUNGSART sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-IEP_GRUPPE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-IEP_XGRUPPE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-IEP_BETRIEBSNOTW sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-IEP_REALISIERUNG_AB sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-IEP_FLAECHE sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-IEP_FEINS sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-KZ_AN sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-BUKRS_AN sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-SWENR sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-ANLN1 sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-ANLN2 sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-ANLKL sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-TXK50 sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FLAECHE_AN sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FEINS_AN sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-KANSW_HR sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-WAERS_HR sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-KANSW_SB sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-WAERS_SB sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-KANSW_KO sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-WAERS_KO sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-KANSW_S1 sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-WAERS_S1 sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-KANSW_S2 sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-WAERS_S2 sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FLAECHE_ART sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-XFLAECHE_ART sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FLAECHE_SN sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FEINS_SN sy-vline
WA_RELS_FLURST_HIERARCHIE_STR-FLURSTKZ sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.