ABAP Select data from SAP table GRAC_S_CREATE_USER 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 GRAC_S_CREATE_USER 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 GRAC_S_CREATE_USER. 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 GRAC_S_CREATE_USER 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_GRAC_S_CREATE_USER TYPE STANDARD TABLE OF GRAC_S_CREATE_USER,
      WA_GRAC_S_CREATE_USER TYPE GRAC_S_CREATE_USER,
      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: <GRAC_S_CREATE_USER> TYPE GRAC_S_CREATE_USER.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM GRAC_S_CREATE_USER
*  INTO TABLE @DATA(IT_GRAC_S_CREATE_USER2).
*--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_GRAC_S_CREATE_USER INDEX 1 INTO DATA(WA_GRAC_S_CREATE_USER2).


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

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

ENDLOOP.

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

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


*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_GRAC_S_CREATE_USER-USTYP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_CREATE_USER-USTYP.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ALPHA, internal->external for field PERS_NO
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_GRAC_S_CREATE_USER-PERS_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_CREATE_USER-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_GRAC_S_CREATE_USER-ADDR_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_CREATE_USER-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_GRAC_S_CREATE_USER-LANGU_P
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_CREATE_USER-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_GRAC_S_CREATE_USER-CITY_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_CREATE_USER-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_GRAC_S_CREATE_USER-DISTRCT_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_CREATE_USER-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_GRAC_S_CREATE_USER-PBOXCIT_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_CREATE_USER-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_GRAC_S_CREATE_USER-STREET_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_CREATE_USER-STREET_NO.
WRITE:/ 'New Value:', ld_input.

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

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

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

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