ABAP Select data from SAP table SIAG_S_CREATE_USR into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP SIAG_S_CREATE_USR 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 SIAG_S_CREATE_USR. 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 SIAG_S_CREATE_USR 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_SIAG_S_CREATE_USR TYPE STANDARD TABLE OF SIAG_S_CREATE_USR,
      WA_SIAG_S_CREATE_USR TYPE SIAG_S_CREATE_USR,
      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: <SIAG_S_CREATE_USR> TYPE SIAG_S_CREATE_USR.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM SIAG_S_CREATE_USR
*  INTO TABLE @DATA(IT_SIAG_S_CREATE_USR2).
*--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_SIAG_S_CREATE_USR INDEX 1 INTO DATA(WA_SIAG_S_CREATE_USR2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_SIAG_S_CREATE_USR ASSIGNING <SIAG_S_CREATE_USR>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<SIAG_S_CREATE_USR>-IV_IS_GEN_PASSWORD = 1.
<SIAG_S_CREATE_USR>-IV_USERNAME = 1.
<SIAG_S_CREATE_USR>-IS_NAME_IN = 1.
<SIAG_S_CREATE_USR>-BAPIBNAME = 1.
<SIAG_S_CREATE_USR>-IS_LOGONDATA = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_SIAG_S_CREATE_USR-GLTGV, sy-vline,
  WA_SIAG_S_CREATE_USR-GLTGB, sy-vline,
  WA_SIAG_S_CREATE_USR-USTYP, sy-vline,
  WA_SIAG_S_CREATE_USR-CLASS, sy-vline,
  WA_SIAG_S_CREATE_USR-ACCNT, sy-vline,
  WA_SIAG_S_CREATE_USR-TZONE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_SIAG_S_CREATE_USR 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_SIAG_S_CREATE_USR 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_SIAG_S_CREATE_USR INTO WA_SIAG_S_CREATE_USR.


*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 USTYP, internal->external for field USTYP
CALL FUNCTION 'CONVERSION_EXIT_USTYP_OUTPUT'
  EXPORTING
    input =                      WA_SIAG_S_CREATE_USR-USTYP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SIAG_S_CREATE_USR-USTYP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SPDEV, internal->external for field SPLD
CALL FUNCTION 'CONVERSION_EXIT_SPDEV_OUTPUT'
  EXPORTING
    input =                      WA_SIAG_S_CREATE_USR-SPLD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SIAG_S_CREATE_USR-SPLD.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

*Conversion exit SXIDN, internal->external for field E_MAIL
CALL FUNCTION 'CONVERSION_EXIT_SXIDN_OUTPUT'
  EXPORTING
    input =                      WA_SIAG_S_CREATE_USR-E_MAIL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SIAG_S_CREATE_USR-E_MAIL.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field IV_NEW_SYSTEM
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_SIAG_S_CREATE_USR-IV_NEW_SYSTEM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SIAG_S_CREATE_USR-IV_NEW_SYSTEM.
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_SIAG_S_CREATE_USR_STR, 
IV_IS_GEN_PASSWORD TYPE STRING,
IV_USERNAME TYPE STRING,
IS_NAME_IN TYPE STRING,
BAPIBNAME TYPE STRING,
IS_LOGONDATA TYPE STRING,
GLTGV TYPE STRING,
GLTGB TYPE STRING,
USTYP TYPE STRING,
CLASS TYPE STRING,
ACCNT TYPE STRING,
TZONE TYPE STRING,
LTIME TYPE STRING,
BCODE TYPE STRING,
CODVN TYPE STRING,
PASSCODE TYPE STRING,
CODVC TYPE STRING,
PWDSALTEDHASH TYPE STRING,
CODVS TYPE STRING,
SECURITY_POLICY TYPE STRING,
IS_PASSWORD TYPE STRING,
BAPIPWD TYPE STRING,
IS_DEFAULTS TYPE STRING,
STCOD TYPE STRING,
SPLD TYPE STRING,
SPLG TYPE STRING,
SPDB TYPE STRING,
SPDA TYPE STRING,
DATFM TYPE STRING,
DCPFM TYPE STRING,
LANGU TYPE STRING,
CATTKENNZ TYPE STRING,
KOSTL TYPE STRING,
START_MENU TYPE STRING,
TIMEFM TYPE STRING,
IS_ADDRESS TYPE STRING,
PERS_NO TYPE STRING,
ADDR_NO TYPE STRING,
TITLE_P TYPE STRING,
FIRSTNAME TYPE STRING,
LASTNAME TYPE STRING,
BIRTH_NAME TYPE STRING,
MIDDLENAME TYPE STRING,
SECONDNAME TYPE STRING,
FULLNAME TYPE STRING,
FULLNAME_X TYPE STRING,
TITLE_ACA1 TYPE STRING,
TITLE_ACA2 TYPE STRING,
PREFIX1 TYPE STRING,
PREFIX2 TYPE STRING,
TITLE_SPPL TYPE STRING,
NICKNAME TYPE STRING,
INITIALS TYPE STRING,
NAMEFORMAT TYPE STRING,
NAMCOUNTRY TYPE STRING,
LANGU_P TYPE STRING,
LANGUP_ISO TYPE STRING,
SORT1_P TYPE STRING,
SORT2_P TYPE STRING,
DEPARTMENT TYPE STRING,
FUNCTION TYPE STRING,
BUILDING_P TYPE STRING,
FLOOR_P TYPE STRING,
ROOM_NO_P TYPE STRING,
INITS_SIG TYPE STRING,
INHOUSE_ML TYPE STRING,
COMM_TYPE TYPE STRING,
TITLE TYPE STRING,
NAME TYPE STRING,
NAME_2 TYPE STRING,
NAME_3 TYPE STRING,
NAME_4 TYPE STRING,
C_O_NAME TYPE STRING,
CITY TYPE STRING,
DISTRICT TYPE STRING,
CITY_NO TYPE STRING,
DISTRCT_NO TYPE STRING,
CHCKSTATUS TYPE STRING,
POSTL_COD1 TYPE STRING,
POSTL_COD2 TYPE STRING,
POSTL_COD3 TYPE STRING,
PO_BOX TYPE STRING,
PO_BOX_CIT TYPE STRING,
PBOXCIT_NO TYPE STRING,
DELIV_DIS TYPE STRING,
TRANSPZONE TYPE STRING,
STREET TYPE STRING,
STREET_NO TYPE STRING,
STR_ABBR TYPE STRING,
HOUSE_NO TYPE STRING,
HOUSE_NO2 TYPE STRING,
STR_SUPPL1 TYPE STRING,
STR_SUPPL2 TYPE STRING,
STR_SUPPL3 TYPE STRING,
LOCATION TYPE STRING,
BUILDING TYPE STRING,
FLOOR TYPE STRING,
ROOM_NO TYPE STRING,
COUNTRY TYPE STRING,
COUNTRYISO TYPE STRING,
LANGU TYPE STRING,
LANGU_ISO TYPE STRING,
REGION TYPE STRING,
SORT1 TYPE STRING,
SORT2 TYPE STRING,
TIME_ZONE TYPE STRING,
TAXJURCODE TYPE STRING,
ADR_NOTES TYPE STRING,
TEL1_NUMBR TYPE STRING,
TEL1_EXT TYPE STRING,
FAX_NUMBER TYPE STRING,
FAX_EXTENS TYPE STRING,
E_MAIL TYPE STRING,
BUILD_LONG TYPE STRING,
REGIOGROUP TYPE STRING,
HOME_CITY TYPE STRING,
HOMECITYNO TYPE STRING,
PCODE1_EXT TYPE STRING,
PCODE2_EXT TYPE STRING,
PCODE3_EXT TYPE STRING,
PO_W_O_NO TYPE STRING,
PO_BOX_REG TYPE STRING,
POBOX_CTRY TYPE STRING,
PO_CTRYISO TYPE STRING,
DONT_USE_S TYPE STRING,
DONT_USE_P TYPE STRING,
HOUSE_NO3 TYPE STRING,
LANGU_CR_P TYPE STRING,
LANGUCPISO TYPE STRING,
PO_BOX_LOBBY TYPE STRING,
DELI_SERV_TYPE TYPE STRING,
DELI_SERV_NUMBER TYPE STRING,
COUNTY_CODE TYPE STRING,
COUNTY TYPE STRING,
TOWNSHIP_CODE TYPE STRING,
TOWNSHIP TYPE STRING,
XPCPT TYPE STRING,
IS_COMPANY TYPE STRING,
COMPANY TYPE STRING,
TEMPLATE_ORGTYPE TYPE STRING,
IS_SNC TYPE STRING,
GUIFLAG TYPE STRING,
PNAME TYPE STRING,
IS_REF_USER TYPE STRING,
REF_USER TYPE STRING,
IS_ALIAS TYPE STRING,
USERALIAS TYPE STRING,
IV_PERS_NO TYPE STRING,
IS_UCLASS TYPE STRING,
LIC_TYPE TYPE STRING,
SPEC_VERS TYPE STRING,
COUNTRY_SURCHARGE TYPE STRING,
SUBSTITUTE_FROM TYPE STRING,
SUBSTITUTE_UNTIL TYPE STRING,
SYSID TYPE STRING,
CLIENT TYPE STRING,
BNAME_CHARGEABLE TYPE STRING,
IV_FORCE_SYSTEM_ASSIGNMENT TYPE STRING,
IV_PASSWORD_LENGTH TYPE STRING,
IT_ADDTEL TYPE STRING,
IT_ADDFAX TYPE STRING,
IT_ADDTTX TYPE STRING,
IT_ADDTLX TYPE STRING,
IT_ADDSMTP TYPE STRING,
IT_ADDRML TYPE STRING,
IT_ADDX400 TYPE STRING,
IT_ADDRFC TYPE STRING,
IT_ADDPRT TYPE STRING,
IT_ADDSSF TYPE STRING,
IT_ADDURI TYPE STRING,
IT_ADDPAG TYPE STRING,
IT_ADDCOMREM TYPE STRING,
IT_PARAMETER TYPE STRING,
IT_GROUPS TYPE STRING,
IV_NEW_SYSTEM TYPE STRING,END OF T_EKKO_STR.
DATA: WA_SIAG_S_CREATE_USR_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_SIAG_S_CREATE_USR_STR-IV_IS_GEN_PASSWORD sy-vline 
WA_SIAG_S_CREATE_USR_STR-IV_USERNAME sy-vline 
WA_SIAG_S_CREATE_USR_STR-IS_NAME_IN sy-vline 
WA_SIAG_S_CREATE_USR_STR-BAPIBNAME sy-vline 
WA_SIAG_S_CREATE_USR_STR-IS_LOGONDATA sy-vline 
WA_SIAG_S_CREATE_USR_STR-GLTGV sy-vline 
WA_SIAG_S_CREATE_USR_STR-GLTGB sy-vline 
WA_SIAG_S_CREATE_USR_STR-USTYP sy-vline 
WA_SIAG_S_CREATE_USR_STR-CLASS sy-vline 
WA_SIAG_S_CREATE_USR_STR-ACCNT sy-vline 
WA_SIAG_S_CREATE_USR_STR-TZONE sy-vline 
WA_SIAG_S_CREATE_USR_STR-LTIME sy-vline 
WA_SIAG_S_CREATE_USR_STR-BCODE sy-vline 
WA_SIAG_S_CREATE_USR_STR-CODVN sy-vline 
WA_SIAG_S_CREATE_USR_STR-PASSCODE sy-vline 
WA_SIAG_S_CREATE_USR_STR-CODVC sy-vline 
WA_SIAG_S_CREATE_USR_STR-PWDSALTEDHASH sy-vline 
WA_SIAG_S_CREATE_USR_STR-CODVS sy-vline 
WA_SIAG_S_CREATE_USR_STR-SECURITY_POLICY sy-vline 
WA_SIAG_S_CREATE_USR_STR-IS_PASSWORD sy-vline 
WA_SIAG_S_CREATE_USR_STR-BAPIPWD sy-vline 
WA_SIAG_S_CREATE_USR_STR-IS_DEFAULTS sy-vline 
WA_SIAG_S_CREATE_USR_STR-STCOD sy-vline 
WA_SIAG_S_CREATE_USR_STR-SPLD sy-vline 
WA_SIAG_S_CREATE_USR_STR-SPLG sy-vline 
WA_SIAG_S_CREATE_USR_STR-SPDB sy-vline 
WA_SIAG_S_CREATE_USR_STR-SPDA sy-vline 
WA_SIAG_S_CREATE_USR_STR-DATFM sy-vline 
WA_SIAG_S_CREATE_USR_STR-DCPFM sy-vline 
WA_SIAG_S_CREATE_USR_STR-LANGU sy-vline 
WA_SIAG_S_CREATE_USR_STR-CATTKENNZ sy-vline 
WA_SIAG_S_CREATE_USR_STR-KOSTL sy-vline 
WA_SIAG_S_CREATE_USR_STR-START_MENU sy-vline 
WA_SIAG_S_CREATE_USR_STR-TIMEFM sy-vline 
WA_SIAG_S_CREATE_USR_STR-IS_ADDRESS sy-vline 
WA_SIAG_S_CREATE_USR_STR-PERS_NO sy-vline 
WA_SIAG_S_CREATE_USR_STR-ADDR_NO sy-vline 
WA_SIAG_S_CREATE_USR_STR-TITLE_P sy-vline 
WA_SIAG_S_CREATE_USR_STR-FIRSTNAME sy-vline 
WA_SIAG_S_CREATE_USR_STR-LASTNAME sy-vline 
WA_SIAG_S_CREATE_USR_STR-BIRTH_NAME sy-vline 
WA_SIAG_S_CREATE_USR_STR-MIDDLENAME sy-vline 
WA_SIAG_S_CREATE_USR_STR-SECONDNAME sy-vline 
WA_SIAG_S_CREATE_USR_STR-FULLNAME sy-vline 
WA_SIAG_S_CREATE_USR_STR-FULLNAME_X sy-vline 
WA_SIAG_S_CREATE_USR_STR-TITLE_ACA1 sy-vline 
WA_SIAG_S_CREATE_USR_STR-TITLE_ACA2 sy-vline 
WA_SIAG_S_CREATE_USR_STR-PREFIX1 sy-vline 
WA_SIAG_S_CREATE_USR_STR-PREFIX2 sy-vline 
WA_SIAG_S_CREATE_USR_STR-TITLE_SPPL sy-vline 
WA_SIAG_S_CREATE_USR_STR-NICKNAME sy-vline 
WA_SIAG_S_CREATE_USR_STR-INITIALS sy-vline 
WA_SIAG_S_CREATE_USR_STR-NAMEFORMAT sy-vline 
WA_SIAG_S_CREATE_USR_STR-NAMCOUNTRY sy-vline 
WA_SIAG_S_CREATE_USR_STR-LANGU_P sy-vline 
WA_SIAG_S_CREATE_USR_STR-LANGUP_ISO sy-vline 
WA_SIAG_S_CREATE_USR_STR-SORT1_P sy-vline 
WA_SIAG_S_CREATE_USR_STR-SORT2_P sy-vline 
WA_SIAG_S_CREATE_USR_STR-DEPARTMENT sy-vline 
WA_SIAG_S_CREATE_USR_STR-FUNCTION sy-vline 
WA_SIAG_S_CREATE_USR_STR-BUILDING_P sy-vline 
WA_SIAG_S_CREATE_USR_STR-FLOOR_P sy-vline 
WA_SIAG_S_CREATE_USR_STR-ROOM_NO_P sy-vline 
WA_SIAG_S_CREATE_USR_STR-INITS_SIG sy-vline 
WA_SIAG_S_CREATE_USR_STR-INHOUSE_ML sy-vline 
WA_SIAG_S_CREATE_USR_STR-COMM_TYPE sy-vline 
WA_SIAG_S_CREATE_USR_STR-TITLE sy-vline 
WA_SIAG_S_CREATE_USR_STR-NAME sy-vline 
WA_SIAG_S_CREATE_USR_STR-NAME_2 sy-vline 
WA_SIAG_S_CREATE_USR_STR-NAME_3 sy-vline 
WA_SIAG_S_CREATE_USR_STR-NAME_4 sy-vline 
WA_SIAG_S_CREATE_USR_STR-C_O_NAME sy-vline 
WA_SIAG_S_CREATE_USR_STR-CITY sy-vline 
WA_SIAG_S_CREATE_USR_STR-DISTRICT sy-vline 
WA_SIAG_S_CREATE_USR_STR-CITY_NO sy-vline 
WA_SIAG_S_CREATE_USR_STR-DISTRCT_NO sy-vline 
WA_SIAG_S_CREATE_USR_STR-CHCKSTATUS sy-vline 
WA_SIAG_S_CREATE_USR_STR-POSTL_COD1 sy-vline 
WA_SIAG_S_CREATE_USR_STR-POSTL_COD2 sy-vline 
WA_SIAG_S_CREATE_USR_STR-POSTL_COD3 sy-vline 
WA_SIAG_S_CREATE_USR_STR-PO_BOX sy-vline 
WA_SIAG_S_CREATE_USR_STR-PO_BOX_CIT sy-vline 
WA_SIAG_S_CREATE_USR_STR-PBOXCIT_NO sy-vline 
WA_SIAG_S_CREATE_USR_STR-DELIV_DIS sy-vline 
WA_SIAG_S_CREATE_USR_STR-TRANSPZONE sy-vline 
WA_SIAG_S_CREATE_USR_STR-STREET sy-vline 
WA_SIAG_S_CREATE_USR_STR-STREET_NO sy-vline 
WA_SIAG_S_CREATE_USR_STR-STR_ABBR sy-vline 
WA_SIAG_S_CREATE_USR_STR-HOUSE_NO sy-vline 
WA_SIAG_S_CREATE_USR_STR-HOUSE_NO2 sy-vline 
WA_SIAG_S_CREATE_USR_STR-STR_SUPPL1 sy-vline 
WA_SIAG_S_CREATE_USR_STR-STR_SUPPL2 sy-vline 
WA_SIAG_S_CREATE_USR_STR-STR_SUPPL3 sy-vline 
WA_SIAG_S_CREATE_USR_STR-LOCATION sy-vline 
WA_SIAG_S_CREATE_USR_STR-BUILDING sy-vline 
WA_SIAG_S_CREATE_USR_STR-FLOOR sy-vline 
WA_SIAG_S_CREATE_USR_STR-ROOM_NO sy-vline 
WA_SIAG_S_CREATE_USR_STR-COUNTRY sy-vline 
WA_SIAG_S_CREATE_USR_STR-COUNTRYISO sy-vline 
WA_SIAG_S_CREATE_USR_STR-LANGU sy-vline 
WA_SIAG_S_CREATE_USR_STR-LANGU_ISO sy-vline 
WA_SIAG_S_CREATE_USR_STR-REGION sy-vline 
WA_SIAG_S_CREATE_USR_STR-SORT1 sy-vline 
WA_SIAG_S_CREATE_USR_STR-SORT2 sy-vline 
WA_SIAG_S_CREATE_USR_STR-TIME_ZONE sy-vline 
WA_SIAG_S_CREATE_USR_STR-TAXJURCODE sy-vline 
WA_SIAG_S_CREATE_USR_STR-ADR_NOTES sy-vline 
WA_SIAG_S_CREATE_USR_STR-TEL1_NUMBR sy-vline 
WA_SIAG_S_CREATE_USR_STR-TEL1_EXT sy-vline 
WA_SIAG_S_CREATE_USR_STR-FAX_NUMBER sy-vline 
WA_SIAG_S_CREATE_USR_STR-FAX_EXTENS sy-vline 
WA_SIAG_S_CREATE_USR_STR-E_MAIL sy-vline 
WA_SIAG_S_CREATE_USR_STR-BUILD_LONG sy-vline 
WA_SIAG_S_CREATE_USR_STR-REGIOGROUP sy-vline 
WA_SIAG_S_CREATE_USR_STR-HOME_CITY sy-vline 
WA_SIAG_S_CREATE_USR_STR-HOMECITYNO sy-vline 
WA_SIAG_S_CREATE_USR_STR-PCODE1_EXT sy-vline 
WA_SIAG_S_CREATE_USR_STR-PCODE2_EXT sy-vline 
WA_SIAG_S_CREATE_USR_STR-PCODE3_EXT sy-vline 
WA_SIAG_S_CREATE_USR_STR-PO_W_O_NO sy-vline 
WA_SIAG_S_CREATE_USR_STR-PO_BOX_REG sy-vline 
WA_SIAG_S_CREATE_USR_STR-POBOX_CTRY sy-vline 
WA_SIAG_S_CREATE_USR_STR-PO_CTRYISO sy-vline 
WA_SIAG_S_CREATE_USR_STR-DONT_USE_S sy-vline 
WA_SIAG_S_CREATE_USR_STR-DONT_USE_P sy-vline 
WA_SIAG_S_CREATE_USR_STR-HOUSE_NO3 sy-vline 
WA_SIAG_S_CREATE_USR_STR-LANGU_CR_P sy-vline 
WA_SIAG_S_CREATE_USR_STR-LANGUCPISO sy-vline 
WA_SIAG_S_CREATE_USR_STR-PO_BOX_LOBBY sy-vline 
WA_SIAG_S_CREATE_USR_STR-DELI_SERV_TYPE sy-vline 
WA_SIAG_S_CREATE_USR_STR-DELI_SERV_NUMBER sy-vline 
WA_SIAG_S_CREATE_USR_STR-COUNTY_CODE sy-vline 
WA_SIAG_S_CREATE_USR_STR-COUNTY sy-vline 
WA_SIAG_S_CREATE_USR_STR-TOWNSHIP_CODE sy-vline 
WA_SIAG_S_CREATE_USR_STR-TOWNSHIP sy-vline 
WA_SIAG_S_CREATE_USR_STR-XPCPT sy-vline 
WA_SIAG_S_CREATE_USR_STR-IS_COMPANY sy-vline 
WA_SIAG_S_CREATE_USR_STR-COMPANY sy-vline 
WA_SIAG_S_CREATE_USR_STR-TEMPLATE_ORGTYPE sy-vline 
WA_SIAG_S_CREATE_USR_STR-IS_SNC sy-vline 
WA_SIAG_S_CREATE_USR_STR-GUIFLAG sy-vline 
WA_SIAG_S_CREATE_USR_STR-PNAME sy-vline 
WA_SIAG_S_CREATE_USR_STR-IS_REF_USER sy-vline 
WA_SIAG_S_CREATE_USR_STR-REF_USER sy-vline 
WA_SIAG_S_CREATE_USR_STR-IS_ALIAS sy-vline 
WA_SIAG_S_CREATE_USR_STR-USERALIAS sy-vline 
WA_SIAG_S_CREATE_USR_STR-IV_PERS_NO sy-vline 
WA_SIAG_S_CREATE_USR_STR-IS_UCLASS sy-vline 
WA_SIAG_S_CREATE_USR_STR-LIC_TYPE sy-vline 
WA_SIAG_S_CREATE_USR_STR-SPEC_VERS sy-vline 
WA_SIAG_S_CREATE_USR_STR-COUNTRY_SURCHARGE sy-vline 
WA_SIAG_S_CREATE_USR_STR-SUBSTITUTE_FROM sy-vline 
WA_SIAG_S_CREATE_USR_STR-SUBSTITUTE_UNTIL sy-vline 
WA_SIAG_S_CREATE_USR_STR-SYSID sy-vline 
WA_SIAG_S_CREATE_USR_STR-CLIENT sy-vline 
WA_SIAG_S_CREATE_USR_STR-BNAME_CHARGEABLE sy-vline 
WA_SIAG_S_CREATE_USR_STR-IV_FORCE_SYSTEM_ASSIGNMENT sy-vline 
WA_SIAG_S_CREATE_USR_STR-IV_PASSWORD_LENGTH sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_ADDTEL sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_ADDFAX sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_ADDTTX sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_ADDTLX sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_ADDSMTP sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_ADDRML sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_ADDX400 sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_ADDRFC sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_ADDPRT sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_ADDSSF sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_ADDURI sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_ADDPAG sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_ADDCOMREM sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_PARAMETER sy-vline 
WA_SIAG_S_CREATE_USR_STR-IT_GROUPS sy-vline 
WA_SIAG_S_CREATE_USR_STR-IV_NEW_SYSTEM sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.