ABAP Select data from SAP table RJH_OP_PARTNER_OLD 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 RJH_OP_PARTNER_OLD 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 RJH_OP_PARTNER_OLD. 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 RJH_OP_PARTNER_OLD 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_RJH_OP_PARTNER_OLD TYPE STANDARD TABLE OF RJH_OP_PARTNER_OLD,
      WA_RJH_OP_PARTNER_OLD TYPE RJH_OP_PARTNER_OLD,
      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: <RJH_OP_PARTNER_OLD> TYPE RJH_OP_PARTNER_OLD.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RJH_OP_PARTNER_OLD
*  INTO TABLE @DATA(IT_RJH_OP_PARTNER_OLD2).
*--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_RJH_OP_PARTNER_OLD INDEX 1 INTO DATA(WA_RJH_OP_PARTNER_OLD2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_RJH_OP_PARTNER_OLD ASSIGNING <RJH_OP_PARTNER_OLD>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<RJH_OP_PARTNER_OLD>-MANDT = 1.
<RJH_OP_PARTNER_OLD>-GPNR = 1.
<RJH_OP_PARTNER_OLD>-XGPLOE = 1.
<RJH_OP_PARTNER_OLD>-XGPLOEKZ = 1.
<RJH_OP_PARTNER_OLD>-XGPSPE = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RJH_OP_PARTNER_OLD-ERFUSER, sy-vline,
WA_RJH_OP_PARTNER_OLD-ERFDATE, sy-vline,
WA_RJH_OP_PARTNER_OLD-ERFTIME, sy-vline,
WA_RJH_OP_PARTNER_OLD-AENUSER, sy-vline,
WA_RJH_OP_PARTNER_OLD-AENDATE, sy-vline,
WA_RJH_OP_PARTNER_OLD-AENTIME, sy-vline.
ENDLOOP. *Add any further fields from structure WA_RJH_OP_PARTNER_OLD 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_RJH_OP_PARTNER_OLD 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_RJH_OP_PARTNER_OLD INTO WA_RJH_OP_PARTNER_OLD. *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 GPNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RJH_OP_PARTNER_OLD-GPNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RJH_OP_PARTNER_OLD-GPNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

*Conversion exit JKWBZ, internal->external for field WBZKUNNR CALL FUNCTION 'CONVERSION_EXIT_JKWBZ_OUTPUT' EXPORTING input = WA_RJH_OP_PARTNER_OLD-WBZKUNNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RJH_OP_PARTNER_OLD-WBZKUNNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit JKWBZ, internal->external for field RECHZENTNR CALL FUNCTION 'CONVERSION_EXIT_JKWBZ_OUTPUT' EXPORTING input = WA_RJH_OP_PARTNER_OLD-RECHZENTNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RJH_OP_PARTNER_OLD-RECHZENTNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

*Conversion exit ISOLA, internal->external for field SPRAS CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT' EXPORTING input = WA_RJH_OP_PARTNER_OLD-SPRAS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RJH_OP_PARTNER_OLD-SPRAS.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit PARVW, internal->external for field JPARVW_REF CALL FUNCTION 'CONVERSION_EXIT_PARVW_OUTPUT' EXPORTING input = WA_RJH_OP_PARTNER_OLD-JPARVW_REF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RJH_OP_PARTNER_OLD-JPARVW_REF.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit JYTNF, internal->external for field NAME1_MACO CALL FUNCTION 'CONVERSION_EXIT_JYTNF_OUTPUT' EXPORTING input = WA_RJH_OP_PARTNER_OLD-NAME1_MACO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RJH_OP_PARTNER_OLD-NAME1_MACO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit JYTNF, internal->external for field NAME2_MACO CALL FUNCTION 'CONVERSION_EXIT_JYTNF_OUTPUT' EXPORTING input = WA_RJH_OP_PARTNER_OLD-NAME2_MACO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RJH_OP_PARTNER_OLD-NAME2_MACO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit JYTNF, internal->external for field STRAS_MACO CALL FUNCTION 'CONVERSION_EXIT_JYTNF_OUTPUT' EXPORTING input = WA_RJH_OP_PARTNER_OLD-STRAS_MACO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RJH_OP_PARTNER_OLD-STRAS_MACO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit JYTNF, internal->external for field ORT01_MACO CALL FUNCTION 'CONVERSION_EXIT_JYTNF_OUTPUT' EXPORTING input = WA_RJH_OP_PARTNER_OLD-ORT01_MACO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RJH_OP_PARTNER_OLD-ORT01_MACO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TELN2, internal->external for field ISPTELVWP CALL FUNCTION 'CONVERSION_EXIT_TELN2_OUTPUT' EXPORTING input = WA_RJH_OP_PARTNER_OLD-ISPTELVWP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RJH_OP_PARTNER_OLD-ISPTELVWP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TELN1, internal->external for field ISPTELP CALL FUNCTION 'CONVERSION_EXIT_TELN1_OUTPUT' EXPORTING input = WA_RJH_OP_PARTNER_OLD-ISPTELP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RJH_OP_PARTNER_OLD-ISPTELP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TELN2, internal->external for field ISPTELVWD CALL FUNCTION 'CONVERSION_EXIT_TELN2_OUTPUT' EXPORTING input = WA_RJH_OP_PARTNER_OLD-ISPTELVWD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RJH_OP_PARTNER_OLD-ISPTELVWD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TELN1, internal->external for field ISPTELD CALL FUNCTION 'CONVERSION_EXIT_TELN1_OUTPUT' EXPORTING input = WA_RJH_OP_PARTNER_OLD-ISPTELD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RJH_OP_PARTNER_OLD-ISPTELD.
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_RJH_OP_PARTNER_OLD_STR,
MANDT TYPE STRING,
GPNR TYPE STRING,
XGPLOE TYPE STRING,
XGPLOEKZ TYPE STRING,
XGPSPE TYPE STRING,
ERFUSER TYPE STRING,
ERFDATE TYPE STRING,
ERFTIME TYPE STRING,
AENUSER TYPE STRING,
AENDATE TYPE STRING,
AENTIME TYPE STRING,
JKTOKD TYPE STRING,
MAILN TYPE STRING,
BEGRU TYPE STRING,
BERUFSL TYPE STRING,
GFORM TYPE STRING,
BRSCH TYPE STRING,
BRAN1 TYPE STRING,
BRAN2 TYPE STRING,
BRAN3 TYPE STRING,
BRAN4 TYPE STRING,
BRAN5 TYPE STRING,
JGEBDAT TYPE STRING,
GESCH TYPE STRING,
JFAMST TYPE STRING,
GPHERK TYPE STRING,
XNATUR TYPE STRING,
XVERMSACH TYPE STRING,
XOHNE TYPE STRING,
XDEBI TYPE STRING,
KUNNR TYPE STRING,
FKUNNR TYPE STRING,
XKREDI TYPE STRING,
LIFNR TYPE STRING,
FLIFNR TYPE STRING,
XMITARB TYPE STRING,
PERNR TYPE STRING,
XNOWERB TYPE STRING,
GPKLA1 TYPE STRING,
GPKLA2 TYPE STRING,
GPKLA3 TYPE STRING,
GPKLA4 TYPE STRING,
GPKLA5 TYPE STRING,
KATR1 TYPE STRING,
KATR2 TYPE STRING,
KATR3 TYPE STRING,
KATR4 TYPE STRING,
KATR5 TYPE STRING,
KATR6 TYPE STRING,
KATR7 TYPE STRING,
KATR8 TYPE STRING,
KATR9 TYPE STRING,
KATR10 TYPE STRING,
XVSRVGES TYPE STRING,
XVSGLOEV TYPE STRING,
XVSGLOEKZ TYPE STRING,
XVSGSPE TYPE STRING,
XZUST TYPE STRING,
XZUSTLOEV TYPE STRING,
XZUSTLOEKZ TYPE STRING,
XZUSSPE TYPE STRING,
XVERMPROV TYPE STRING,
XVERMPROVV TYPE STRING,
XVERMPROKZ TYPE STRING,
XVERSPE TYPE STRING,
XVERB TYPE STRING,
XVEBLOEV TYPE STRING,
XVEBSPE TYPE STRING,
XINKASSO TYPE STRING,
XINKLOEV TYPE STRING,
XINKLOEKZ TYPE STRING,
XINKSPE TYPE STRING,
XRECHER TYPE STRING,
XRECHLOEV TYPE STRING,
XRECHLOEKZ TYPE STRING,
XRECHSPE TYPE STRING,
MAILNBETR TYPE STRING,
XKAHS TYPE STRING,
XKAHLOEV TYPE STRING,
XKAHSSPE TYPE STRING,
XSPEDI TYPE STRING,
XSPEDLOEV TYPE STRING,
XSPEDLOEKZ TYPE STRING,
XSPESPE TYPE STRING,
XVERTKUN TYPE STRING,
XVKUNLOEV TYPE STRING,
XVKUNLOEKZ TYPE STRING,
XVKUNSPE TYPE STRING,
XEUW TYPE STRING,
XEUWLOEV TYPE STRING,
XEUWLOEKZ TYPE STRING,
XEUWSPE TYPE STRING,
XINTERN TYPE STRING,
XINTLOEV TYPE STRING,
AUFORG TYPE STRING,
XINTSPE TYPE STRING,
XSOZIAL TYPE STRING,
XSOZLOEV TYPE STRING,
XSOZSPE TYPE STRING,
XPOST TYPE STRING,
XPOSLOEV TYPE STRING,
XPOSLOEKZ TYPE STRING,
XPOSSPE TYPE STRING,
XVERLAG TYPE STRING,
XVERLLOEV TYPE STRING,
XVERLSPE TYPE STRING,
XVERLEIG TYPE STRING,
VERLVKORG TYPE STRING,
ISPCVERL TYPE STRING,
XMEDIAK TYPE STRING,
XMEDIAKLV TYPE STRING,
XMEDIAKLKZ TYPE STRING,
XMEDIAKSP TYPE STRING,
XINSER TYPE STRING,
XINSERLV TYPE STRING,
XINSERLKZ TYPE STRING,
XINSERSP TYPE STRING,
XMVERM TYPE STRING,
XMVERMLV TYPE STRING,
XMVERMLKZ TYPE STRING,
XMVERMSP TYPE STRING,
XAGEN TYPE STRING,
XAGENLV TYPE STRING,
XAGENLKZ TYPE STRING,
XAGENLSP TYPE STRING,
AGEN_ART TYPE STRING,
AGEN_STR TYPE STRING,
AGEN_PLAN TYPE STRING,
AGEN_GRU TYPE STRING,
XDUB TYPE STRING,
GP_DUB TYPE STRING,
BON TYPE STRING,
KLIM_EINZ TYPE STRING,
KLIM_GES TYPE STRING,
KLIM_WAERS TYPE STRING,
WBZKUNNR TYPE STRING,
RECHZENTNR TYPE STRING,
JWBZKOMART TYPE STRING,
XWBZFIRMA TYPE STRING,
WBZZLSCH TYPE STRING,
REFBELEG TYPE STRING,
ADRNR TYPE STRING,
XISPCTEILN TYPE STRING,
ISPCTEILN TYPE STRING,
ISPCART TYPE STRING,
J_SOC_SECU TYPE STRING,
XHOUSEHOLD TYPE STRING,
ADDR_CONV TYPE STRING,
UVADR_ST TYPE STRING,
UVADR_PF TYPE STRING,
UVADR_GK TYPE STRING,
HERK TYPE STRING,
XADRLOE TYPE STRING,
ANRED TYPE STRING,
NAME1 TYPE STRING,
NAME2 TYPE STRING,
NAME3 TYPE STRING,
NAME4 TYPE STRING,
TITEL TYPE STRING,
NAMZU TYPE STRING,
VORSW TYPE STRING,
PSTLZ TYPE STRING,
PSTLZ_ADDON TYPE STRING,
ORT01 TYPE STRING,
ORT02 TYPE STRING,
PSTL2 TYPE STRING,
PSTL2_ADDON TYPE STRING,
PSTL3 TYPE STRING,
PSTL3_ADDON TYPE STRING,
PFACH TYPE STRING,
ORTPF TYPE STRING,
STRAS TYPE STRING,
HAUSN TYPE STRING,
HSNMR2 TYPE STRING,
ADRZUS2 TYPE STRING,
STOCK TYPE STRING,
LAND1 TYPE STRING,
PREDIRECTIONAL TYPE STRING,
POSTDIRECTIONAL TYPE STRING,
ADDRSECABBREV TYPE STRING,
ADDRSECNUMBER TYPE STRING,
STREET2 TYPE STRING,
ALIASNAME TYPE STRING,
ALIASPREDIRECTN TYPE STRING,
ALIASPOSTDIRECTN TYPE STRING,
ALIASDELADDRLOW TYPE STRING,
ALIASDELADDRHIGH TYPE STRING,
ALIASDELODDEVEN TYPE STRING,
SUCHFELDALIAS TYPE STRING,
POSTEINORT TYPE STRING,
ERSTADR TYPE STRING,
POSTEINSTR TYPE STRING,
PEINORTPF TYPE STRING,
LOCCO TYPE STRING,
NIELS TYPE STRING,
COUNC TYPE STRING,
CITYC TYPE STRING,
RPMKR TYPE STRING,
SORTL TYPE STRING,
SORT2 TYPE STRING,
SORT3 TYPE STRING,
SPRAS TYPE STRING,
REGIO TYPE STRING,
TELFP TYPE STRING,
TELFD TYPE STRING,
TELW1 TYPE STRING,
TELW2 TYPE STRING,
TELW3 TYPE STRING,
TELW4 TYPE STRING,
TELW5 TYPE STRING,
TELFX TYPE STRING,
TELF1 TYPE STRING,
TELF2 TYPE STRING,
TELF3 TYPE STRING,
TELTX TYPE STRING,
TELX1 TYPE STRING,
TELBX TYPE STRING,
DATLT TYPE STRING,
STDKO TYPE STRING,
GP_REF TYPE STRING,
VBELN_REF TYPE STRING,
POSNR_REF TYPE STRING,
JPARVW_REF TYPE STRING,
BEABLS_REF TYPE STRING,
TELFP_COD TYPE STRING,
TELFD_COD TYPE STRING,
NAME1_MACO TYPE STRING,
NAME2_MACO TYPE STRING,
STRAS_MACO TYPE STRING,
ORT01_MACO TYPE STRING,
ISPTELVWP TYPE STRING,
ISPTELP TYPE STRING,
ISPTELVWD TYPE STRING,
ISPTELD TYPE STRING,
ISPHANDY TYPE STRING,
ISPEMAIL TYPE STRING,
ISPADRBSND TYPE STRING,
TECHNUMZUG TYPE STRING,
XNOMESS TYPE STRING,
ALIASLFDNR TYPE STRING,
XNOCARPERMESS TYPE STRING,
TXJCD TYPE STRING,
ANI_TELNRP TYPE STRING,
ANI_TELNRD TYPE STRING,END OF T_EKKO_STR. DATA: WA_RJH_OP_PARTNER_OLD_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_RJH_OP_PARTNER_OLD_STR-MANDT sy-vline
WA_RJH_OP_PARTNER_OLD_STR-GPNR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XGPLOE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XGPLOEKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XGPSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ERFUSER sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ERFDATE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ERFTIME sy-vline
WA_RJH_OP_PARTNER_OLD_STR-AENUSER sy-vline
WA_RJH_OP_PARTNER_OLD_STR-AENDATE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-AENTIME sy-vline
WA_RJH_OP_PARTNER_OLD_STR-JKTOKD sy-vline
WA_RJH_OP_PARTNER_OLD_STR-MAILN sy-vline
WA_RJH_OP_PARTNER_OLD_STR-BEGRU sy-vline
WA_RJH_OP_PARTNER_OLD_STR-BERUFSL sy-vline
WA_RJH_OP_PARTNER_OLD_STR-GFORM sy-vline
WA_RJH_OP_PARTNER_OLD_STR-BRSCH sy-vline
WA_RJH_OP_PARTNER_OLD_STR-BRAN1 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-BRAN2 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-BRAN3 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-BRAN4 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-BRAN5 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-JGEBDAT sy-vline
WA_RJH_OP_PARTNER_OLD_STR-GESCH sy-vline
WA_RJH_OP_PARTNER_OLD_STR-JFAMST sy-vline
WA_RJH_OP_PARTNER_OLD_STR-GPHERK sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XNATUR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVERMSACH sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XOHNE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XDEBI sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KUNNR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-FKUNNR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XKREDI sy-vline
WA_RJH_OP_PARTNER_OLD_STR-LIFNR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-FLIFNR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XMITARB sy-vline
WA_RJH_OP_PARTNER_OLD_STR-PERNR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XNOWERB sy-vline
WA_RJH_OP_PARTNER_OLD_STR-GPKLA1 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-GPKLA2 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-GPKLA3 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-GPKLA4 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-GPKLA5 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KATR1 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KATR2 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KATR3 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KATR4 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KATR5 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KATR6 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KATR7 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KATR8 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KATR9 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KATR10 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVSRVGES sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVSGLOEV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVSGLOEKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVSGSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XZUST sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XZUSTLOEV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XZUSTLOEKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XZUSSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVERMPROV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVERMPROVV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVERMPROKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVERSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVERB sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVEBLOEV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVEBSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XINKASSO sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XINKLOEV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XINKLOEKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XINKSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XRECHER sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XRECHLOEV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XRECHLOEKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XRECHSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-MAILNBETR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XKAHS sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XKAHLOEV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XKAHSSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XSPEDI sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XSPEDLOEV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XSPEDLOEKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XSPESPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVERTKUN sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVKUNLOEV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVKUNLOEKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVKUNSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XEUW sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XEUWLOEV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XEUWLOEKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XEUWSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XINTERN sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XINTLOEV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-AUFORG sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XINTSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XSOZIAL sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XSOZLOEV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XSOZSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XPOST sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XPOSLOEV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XPOSLOEKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XPOSSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVERLAG sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVERLLOEV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVERLSPE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XVERLEIG sy-vline
WA_RJH_OP_PARTNER_OLD_STR-VERLVKORG sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ISPCVERL sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XMEDIAK sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XMEDIAKLV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XMEDIAKLKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XMEDIAKSP sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XINSER sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XINSERLV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XINSERLKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XINSERSP sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XMVERM sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XMVERMLV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XMVERMLKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XMVERMSP sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XAGEN sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XAGENLV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XAGENLKZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XAGENLSP sy-vline
WA_RJH_OP_PARTNER_OLD_STR-AGEN_ART sy-vline
WA_RJH_OP_PARTNER_OLD_STR-AGEN_STR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-AGEN_PLAN sy-vline
WA_RJH_OP_PARTNER_OLD_STR-AGEN_GRU sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XDUB sy-vline
WA_RJH_OP_PARTNER_OLD_STR-GP_DUB sy-vline
WA_RJH_OP_PARTNER_OLD_STR-BON sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KLIM_EINZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KLIM_GES sy-vline
WA_RJH_OP_PARTNER_OLD_STR-KLIM_WAERS sy-vline
WA_RJH_OP_PARTNER_OLD_STR-WBZKUNNR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-RECHZENTNR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-JWBZKOMART sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XWBZFIRMA sy-vline
WA_RJH_OP_PARTNER_OLD_STR-WBZZLSCH sy-vline
WA_RJH_OP_PARTNER_OLD_STR-REFBELEG sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ADRNR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XISPCTEILN sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ISPCTEILN sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ISPCART sy-vline
WA_RJH_OP_PARTNER_OLD_STR-J_SOC_SECU sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XHOUSEHOLD sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ADDR_CONV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-UVADR_ST sy-vline
WA_RJH_OP_PARTNER_OLD_STR-UVADR_PF sy-vline
WA_RJH_OP_PARTNER_OLD_STR-UVADR_GK sy-vline
WA_RJH_OP_PARTNER_OLD_STR-HERK sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XADRLOE sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ANRED sy-vline
WA_RJH_OP_PARTNER_OLD_STR-NAME1 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-NAME2 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-NAME3 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-NAME4 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TITEL sy-vline
WA_RJH_OP_PARTNER_OLD_STR-NAMZU sy-vline
WA_RJH_OP_PARTNER_OLD_STR-VORSW sy-vline
WA_RJH_OP_PARTNER_OLD_STR-PSTLZ sy-vline
WA_RJH_OP_PARTNER_OLD_STR-PSTLZ_ADDON sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ORT01 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ORT02 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-PSTL2 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-PSTL2_ADDON sy-vline
WA_RJH_OP_PARTNER_OLD_STR-PSTL3 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-PSTL3_ADDON sy-vline
WA_RJH_OP_PARTNER_OLD_STR-PFACH sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ORTPF sy-vline
WA_RJH_OP_PARTNER_OLD_STR-STRAS sy-vline
WA_RJH_OP_PARTNER_OLD_STR-HAUSN sy-vline
WA_RJH_OP_PARTNER_OLD_STR-HSNMR2 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ADRZUS2 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-STOCK sy-vline
WA_RJH_OP_PARTNER_OLD_STR-LAND1 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-PREDIRECTIONAL sy-vline
WA_RJH_OP_PARTNER_OLD_STR-POSTDIRECTIONAL sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ADDRSECABBREV sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ADDRSECNUMBER sy-vline
WA_RJH_OP_PARTNER_OLD_STR-STREET2 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ALIASNAME sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ALIASPREDIRECTN sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ALIASPOSTDIRECTN sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ALIASDELADDRLOW sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ALIASDELADDRHIGH sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ALIASDELODDEVEN sy-vline
WA_RJH_OP_PARTNER_OLD_STR-SUCHFELDALIAS sy-vline
WA_RJH_OP_PARTNER_OLD_STR-POSTEINORT sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ERSTADR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-POSTEINSTR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-PEINORTPF sy-vline
WA_RJH_OP_PARTNER_OLD_STR-LOCCO sy-vline
WA_RJH_OP_PARTNER_OLD_STR-NIELS sy-vline
WA_RJH_OP_PARTNER_OLD_STR-COUNC sy-vline
WA_RJH_OP_PARTNER_OLD_STR-CITYC sy-vline
WA_RJH_OP_PARTNER_OLD_STR-RPMKR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-SORTL sy-vline
WA_RJH_OP_PARTNER_OLD_STR-SORT2 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-SORT3 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-SPRAS sy-vline
WA_RJH_OP_PARTNER_OLD_STR-REGIO sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELFP sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELFD sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELW1 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELW2 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELW3 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELW4 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELW5 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELFX sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELF1 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELF2 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELF3 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELTX sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELX1 sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELBX sy-vline
WA_RJH_OP_PARTNER_OLD_STR-DATLT sy-vline
WA_RJH_OP_PARTNER_OLD_STR-STDKO sy-vline
WA_RJH_OP_PARTNER_OLD_STR-GP_REF sy-vline
WA_RJH_OP_PARTNER_OLD_STR-VBELN_REF sy-vline
WA_RJH_OP_PARTNER_OLD_STR-POSNR_REF sy-vline
WA_RJH_OP_PARTNER_OLD_STR-JPARVW_REF sy-vline
WA_RJH_OP_PARTNER_OLD_STR-BEABLS_REF sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELFP_COD sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TELFD_COD sy-vline
WA_RJH_OP_PARTNER_OLD_STR-NAME1_MACO sy-vline
WA_RJH_OP_PARTNER_OLD_STR-NAME2_MACO sy-vline
WA_RJH_OP_PARTNER_OLD_STR-STRAS_MACO sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ORT01_MACO sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ISPTELVWP sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ISPTELP sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ISPTELVWD sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ISPTELD sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ISPHANDY sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ISPEMAIL sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ISPADRBSND sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TECHNUMZUG sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XNOMESS sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ALIASLFDNR sy-vline
WA_RJH_OP_PARTNER_OLD_STR-XNOCARPERMESS sy-vline
WA_RJH_OP_PARTNER_OLD_STR-TXJCD sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ANI_TELNRP sy-vline
WA_RJH_OP_PARTNER_OLD_STR-ANI_TELNRD sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.