ABAP Select data from SAP table /SMISU/MD_CONTRACT_ACC_STR 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 /SMISU/MD_CONTRACT_ACC_STR 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 /SMISU/MD_CONTRACT_ACC_STR. 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 /SMISU/MD_CONTRACT_ACC_STR 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_/SMISU/MD_CONTRACT_ACC_STR TYPE STANDARD TABLE OF /SMISU/MD_CONTRACT_ACC_STR,
      WA_/SMISU/MD_CONTRACT_ACC_STR TYPE /SMISU/MD_CONTRACT_ACC_STR,
      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: </SMISU/MD_CONTRACT_ACC_STR> TYPE /SMISU/MD_CONTRACT_ACC_STR.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /SMISU/MD_CONTRACT_ACC_STR
  INTO TABLE IT_/SMISU/MD_CONTRACT_ACC_STR.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /SMISU/MD_CONTRACT_ACC_STR
*  INTO TABLE @DATA(IT_/SMISU/MD_CONTRACT_ACC_STR2).
*--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_/SMISU/MD_CONTRACT_ACC_STR INDEX 1 INTO DATA(WA_/SMISU/MD_CONTRACT_ACC_STR2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SMISU/MD_CONTRACT_ACC_STR ASSIGNING </SMISU/MD_CONTRACT_ACC_STR>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
</SMISU/MD_CONTRACT_ACC_STR>-MANDT = 1.
</SMISU/MD_CONTRACT_ACC_STR>-VKONT = 1.
</SMISU/MD_CONTRACT_ACC_STR>-GPART = 1.
</SMISU/MD_CONTRACT_ACC_STR>-VKBEZ = 1.
</SMISU/MD_CONTRACT_ACC_STR>-ERDAT = 1.
ENDLOOP.

LOOP AT IT_/SMISU/MD_CONTRACT_ACC_STR INTO WA_/SMISU/MD_CONTRACT_ACC_STR.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SMISU/MD_CONTRACT_ACC_STR-ERNAM, sy-vline,
WA_/SMISU/MD_CONTRACT_ACC_STR-AEDATP, sy-vline,
WA_/SMISU/MD_CONTRACT_ACC_STR-AENAMP, sy-vline,
WA_/SMISU/MD_CONTRACT_ACC_STR-FDZTG, sy-vline,
WA_/SMISU/MD_CONTRACT_ACC_STR-STOPD, sy-vline,
WA_/SMISU/MD_CONTRACT_ACC_STR-QSZDT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SMISU/MD_CONTRACT_ACC_STR 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_/SMISU/MD_CONTRACT_ACC_STR 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_/SMISU/MD_CONTRACT_ACC_STR INTO WA_/SMISU/MD_CONTRACT_ACC_STR. *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 VKONT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SMISU/MD_CONTRACT_ACC_STR-VKONT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SMISU/MD_CONTRACT_ACC_STR-VKONT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field ADDRCOMM CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SMISU/MD_CONTRACT_ACC_STR-ADDRCOMM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SMISU/MD_CONTRACT_ACC_STR-ADDRCOMM.
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_/SMISU/MD_CONTRACT_ACC_STR_STR,
MANDT TYPE STRING,
VKONT TYPE STRING,
GPART TYPE STRING,
VKBEZ TYPE STRING,
ERDAT TYPE STRING,
ERNAM TYPE STRING,
AEDATP TYPE STRING,
AENAMP TYPE STRING,
FDZTG TYPE STRING,
STOPD TYPE STRING,
QSZDT TYPE STRING,
GUID TYPE STRING,
DDLAM TYPE STRING,
DDLCU TYPE STRING,
DDLNM TYPE STRING,
INV_CYCLE_START TYPE STRING,
INV_CHGDISC_X TYPE STRING,
BPL_XPOCL TYPE STRING,
BPL_XADDL TYPE STRING,
BPL_FDATE TYPE STRING,
BPL_TDATE TYPE STRING,
INV_CURR TYPE STRING,
EXVKO TYPE STRING,
OPBUK TYPE STRING,
STDBK TYPE STRING,
ABWRE TYPE STRING,
ABWRA TYPE STRING,
ABWMA TYPE STRING,
EBVTY TYPE STRING,
ABVTY TYPE STRING,
EZAWE TYPE STRING,
EZASP TYPE STRING,
AZAWE TYPE STRING,
AZASP TYPE STRING,
EIGBV TYPE STRING,
VWNZA TYPE STRING,
LOEVM TYPE STRING,
ABWVK TYPE STRING,
IKEY TYPE STRING,
MAHNV TYPE STRING,
MANSP TYPE STRING,
MGRUP TYPE STRING,
FDGRP TYPE STRING,
VKPBZ TYPE STRING,
ADRNB TYPE STRING,
VKONV TYPE STRING,
GPARV TYPE STRING,
ADRRE TYPE STRING,
ADRRA TYPE STRING,
ADRMA TYPE STRING,
ABWRH TYPE STRING,
ADRRH TYPE STRING,
ADRJDC TYPE STRING,
BEGRU TYPE STRING,
TOGRU TYPE STRING,
STOPG TYPE STRING,
TXJCD TYPE STRING,
COPRC TYPE STRING,
VBUND TYPE STRING,
CCARD_ID TYPE STRING,
CCARD_OUT TYPE STRING,
UEBTR TYPE STRING,
DEF_REC TYPE STRING,
DEF_REC_IND TYPE STRING,
DEF_REC_ADRNR TYPE STRING,
QSSKZ_A TYPE STRING,
QSSKZ_E TYPE STRING,
QSZNR TYPE STRING,
CORR_MAHNV TYPE STRING,
FITYP TYPE STRING,
PROVINCE TYPE STRING,
COUNTY TYPE STRING,
VERTYP TYPE STRING,
AUGRS_DEF TYPE STRING,
LANDL TYPE STRING,
BUPLA TYPE STRING,
BPTAXTYPE1 TYPE STRING,
BPTAXTYPE2 TYPE STRING,
PERSR TYPE STRING,
INV_CATEGORY TYPE STRING,
DDLXG TYPE STRING,
CMGRP TYPE STRING,
STRAT TYPE STRING,
CPERS TYPE STRING,
BPCL_SUCC TYPE STRING,
INV_SCHEDULE TYPE STRING,
INV_CYCLE TYPE STRING,
INV_CYCLE_RULE TYPE STRING,
INV_CYCLE_DAY TYPE STRING,
INV_CYCLE_MONTH TYPE STRING,
MNDID TYPE STRING,
INV_FORM_DET_KEY TYPE STRING,
GPART_INV TYPE STRING,
VKONT_INV TYPE STRING,
GPART_INVLIST TYPE STRING,
VKONT_INVLIST TYPE STRING,
MAKEY TYPE STRING,
PTSRL TYPE STRING,
TRSLA TYPE STRING,
TAX_COUNTRY TYPE STRING,
ZAHLKOND TYPE STRING,
KOFIZ_SD TYPE STRING,
GSBER TYPE STRING,
IPA_CODE TYPE STRING,
IPA_BEGDA TYPE STRING,
IPA_CODE_LONG TYPE STRING,
/SAPCE/FKRU_FIS TYPE STRING,
/SAPCE/FKRU_FTD TYPE STRING,
/SAPCE/FKRU_FTDA TYPE STRING,
/SAPCE/FKRU_CTT TYPE STRING,
BCODE TYPE STRING,
DUMMY_FKKVKP_INCL_EEW_PS TYPE STRING,
CLIENT TYPE STRING,
PARTNER TYPE STRING,
TYPE TYPE STRING,
BPKIND TYPE STRING,
BU_GROUP TYPE STRING,
BPEXT TYPE STRING,
BU_SORT1 TYPE STRING,
BU_SORT2 TYPE STRING,
SOURCE TYPE STRING,
TITLE TYPE STRING,
XDELE TYPE STRING,
XBLCK TYPE STRING,
AUGRP TYPE STRING,
TITLE_LET TYPE STRING,
BU_LOGSYS TYPE STRING,
CONTACT TYPE STRING,
NOT_RELEASED TYPE STRING,
NOT_LG_COMPETENT TYPE STRING,
PRINT_MODE TYPE STRING,
BP_EEW_DUMMY TYPE STRING,
RATE TYPE STRING,
NAME_ORG1 TYPE STRING,
NAME_ORG2 TYPE STRING,
NAME_ORG3 TYPE STRING,
NAME_ORG4 TYPE STRING,
LEGAL_ENTY TYPE STRING,
IND_SECTOR TYPE STRING,
LEGAL_ORG TYPE STRING,
FOUND_DAT TYPE STRING,
LIQUID_DAT TYPE STRING,
LOCATION_1 TYPE STRING,
LOCATION_2 TYPE STRING,
LOCATION_3 TYPE STRING,
NAME_LAST TYPE STRING,
NAME_FIRST TYPE STRING,
NAME_LST2 TYPE STRING,
NAME_LAST2 TYPE STRING,
NAMEMIDDLE TYPE STRING,
TITLE_ACA1 TYPE STRING,
TITLE_ACA2 TYPE STRING,
TITLE_ROYL TYPE STRING,
PREFIX1 TYPE STRING,
PREFIX2 TYPE STRING,
NAME1_TEXT TYPE STRING,
NICKNAME TYPE STRING,
INITIALS TYPE STRING,
NAMEFORMAT TYPE STRING,
NAMCOUNTRY TYPE STRING,
LANGU_CORR TYPE STRING,
XSEXM TYPE STRING,
XSEXF TYPE STRING,
BIRTHPL TYPE STRING,
MARST TYPE STRING,
EMPLO TYPE STRING,
JOBGR TYPE STRING,
NATIO TYPE STRING,
CNTAX TYPE STRING,
CNDSC TYPE STRING,
PERSNUMBER TYPE STRING,
XSEXU TYPE STRING,
XUBNAME TYPE STRING,
BU_LANGU TYPE STRING,
GENDER TYPE STRING,
BIRTHDT TYPE STRING,
DEATHDT TYPE STRING,
PERNO TYPE STRING,
CHILDREN TYPE STRING,
MEM_HOUSE TYPE STRING,
BIRTHDT_STATUS TYPE STRING,
PARTGRPTYP TYPE STRING,
NAME_GRP1 TYPE STRING,
NAME_GRP2 TYPE STRING,
MC_NAME1 TYPE STRING,
MC_NAME2 TYPE STRING,
CRUSR TYPE STRING,
CRDAT TYPE STRING,
CRTIM TYPE STRING,
CHUSR TYPE STRING,
CHDAT TYPE STRING,
CHTIM TYPE STRING,
PARTNER_GUID TYPE STRING,
ADDRCOMM TYPE STRING,
TD_SWITCH TYPE STRING,
IS_ORG_CENTRE TYPE STRING,
DB_KEY TYPE STRING,
VALID_FROM TYPE STRING,
VALID_TO TYPE STRING,
XPCPT TYPE STRING,
NATPERS TYPE STRING,
MILVE TYPE STRING,
NUC_SEC TYPE STRING,
PAR_REL TYPE STRING,
BP_SORT TYPE STRING,
KBANKS TYPE STRING,
KBANKL TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SMISU/MD_CONTRACT_ACC_STR_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_/SMISU/MD_CONTRACT_ACC_STR_STR-MANDT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-VKONT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-GPART sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-VKBEZ sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ERDAT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ERNAM sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-AEDATP sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-AENAMP sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-FDZTG sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-STOPD sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-QSZDT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-GUID sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-DDLAM sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-DDLCU sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-DDLNM sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-INV_CYCLE_START sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-INV_CHGDISC_X sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BPL_XPOCL sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BPL_XADDL sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BPL_FDATE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BPL_TDATE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-INV_CURR sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-EXVKO sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-OPBUK sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-STDBK sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ABWRE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ABWRA sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ABWMA sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-EBVTY sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ABVTY sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-EZAWE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-EZASP sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-AZAWE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-AZASP sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-EIGBV sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-VWNZA sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-LOEVM sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ABWVK sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-IKEY sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-MAHNV sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-MANSP sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-MGRUP sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-FDGRP sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-VKPBZ sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ADRNB sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-VKONV sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-GPARV sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ADRRE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ADRRA sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ADRMA sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ABWRH sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ADRRH sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ADRJDC sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BEGRU sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-TOGRU sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-STOPG sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-TXJCD sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-COPRC sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-VBUND sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CCARD_ID sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CCARD_OUT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-UEBTR sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-DEF_REC sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-DEF_REC_IND sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-DEF_REC_ADRNR sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-QSSKZ_A sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-QSSKZ_E sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-QSZNR sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CORR_MAHNV sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-FITYP sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-PROVINCE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-COUNTY sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-VERTYP sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-AUGRS_DEF sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-LANDL sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BUPLA sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BPTAXTYPE1 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BPTAXTYPE2 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-PERSR sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-INV_CATEGORY sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-DDLXG sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CMGRP sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-STRAT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CPERS sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BPCL_SUCC sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-INV_SCHEDULE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-INV_CYCLE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-INV_CYCLE_RULE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-INV_CYCLE_DAY sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-INV_CYCLE_MONTH sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-MNDID sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-INV_FORM_DET_KEY sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-GPART_INV sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-VKONT_INV sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-GPART_INVLIST sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-VKONT_INVLIST sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-MAKEY sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-PTSRL sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-TRSLA sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-TAX_COUNTRY sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ZAHLKOND sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-KOFIZ_SD sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-GSBER sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-IPA_CODE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-IPA_BEGDA sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-IPA_CODE_LONG sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-/SAPCE/FKRU_FIS sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-/SAPCE/FKRU_FTD sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-/SAPCE/FKRU_FTDA sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-/SAPCE/FKRU_CTT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BCODE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-DUMMY_FKKVKP_INCL_EEW_PS sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CLIENT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-PARTNER sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-TYPE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BPKIND sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BU_GROUP sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BPEXT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BU_SORT1 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BU_SORT2 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-SOURCE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-TITLE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-XDELE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-XBLCK sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-AUGRP sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-TITLE_LET sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BU_LOGSYS sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CONTACT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NOT_RELEASED sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NOT_LG_COMPETENT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-PRINT_MODE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BP_EEW_DUMMY sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-RATE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAME_ORG1 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAME_ORG2 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAME_ORG3 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAME_ORG4 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-LEGAL_ENTY sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-IND_SECTOR sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-LEGAL_ORG sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-FOUND_DAT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-LIQUID_DAT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-LOCATION_1 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-LOCATION_2 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-LOCATION_3 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAME_LAST sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAME_FIRST sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAME_LST2 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAME_LAST2 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAMEMIDDLE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-TITLE_ACA1 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-TITLE_ACA2 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-TITLE_ROYL sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-PREFIX1 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-PREFIX2 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAME1_TEXT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NICKNAME sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-INITIALS sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAMEFORMAT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAMCOUNTRY sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-LANGU_CORR sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-XSEXM sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-XSEXF sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BIRTHPL sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-MARST sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-EMPLO sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-JOBGR sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NATIO sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CNTAX sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CNDSC sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-PERSNUMBER sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-XSEXU sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-XUBNAME sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BU_LANGU sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-GENDER sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BIRTHDT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-DEATHDT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-PERNO sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CHILDREN sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-MEM_HOUSE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BIRTHDT_STATUS sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-PARTGRPTYP sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAME_GRP1 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NAME_GRP2 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-MC_NAME1 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-MC_NAME2 sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CRUSR sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CRDAT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CRTIM sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CHUSR sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CHDAT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-CHTIM sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-PARTNER_GUID sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-ADDRCOMM sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-TD_SWITCH sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-IS_ORG_CENTRE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-DB_KEY sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-VALID_FROM sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-VALID_TO sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-XPCPT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NATPERS sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-MILVE sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-NUC_SEC sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-PAR_REL sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-BP_SORT sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-KBANKS sy-vline
WA_/SMISU/MD_CONTRACT_ACC_STR_STR-KBANKL sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.