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

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

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

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


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/GRCPI/GRIA_S_CREATE_USR ASSIGNING </GRCPI/GRIA_S_CREATE_USR>.

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

ENDLOOP.

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

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