ABAP Select data from SAP table GRAC_S_USER_DETAIL 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_USER_DETAIL 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_USER_DETAIL. 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_USER_DETAIL 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_USER_DETAIL TYPE STANDARD TABLE OF GRAC_S_USER_DETAIL,
      WA_GRAC_S_USER_DETAIL TYPE GRAC_S_USER_DETAIL,
      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_USER_DETAIL> TYPE GRAC_S_USER_DETAIL.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM GRAC_S_USER_DETAIL
*  INTO TABLE @DATA(IT_GRAC_S_USER_DETAIL2).
*--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_USER_DETAIL INDEX 1 INTO DATA(WA_GRAC_S_USER_DETAIL2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<GRAC_S_USER_DETAIL>-PARAMETER0 = 1.
<GRAC_S_USER_DETAIL>-PROFILES = 1.
<GRAC_S_USER_DETAIL>-ROLES = 1.
<GRAC_S_USER_DETAIL>-ADDTEL = 1.
<GRAC_S_USER_DETAIL>-ADDFAX = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_GRAC_S_USER_DETAIL-ADDTTX, sy-vline,
  WA_GRAC_S_USER_DETAIL-ADDTLX, sy-vline,
  WA_GRAC_S_USER_DETAIL-ADDSMTP, sy-vline,
  WA_GRAC_S_USER_DETAIL-ADDRML, sy-vline,
  WA_GRAC_S_USER_DETAIL-ADDX400, sy-vline,
  WA_GRAC_S_USER_DETAIL-ADDRFC, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_GRAC_S_USER_DETAIL 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_USER_DETAIL 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_USER_DETAIL INTO WA_GRAC_S_USER_DETAIL.


*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_USER_DETAIL-USTYP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-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_USER_DETAIL-SPLD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-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_USER_DETAIL-LANGU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-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_USER_DETAIL-PERS_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-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_USER_DETAIL-ADDR_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-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_USER_DETAIL-LANGU_P
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-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_USER_DETAIL-CITY_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-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_USER_DETAIL-DISTRCT_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-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_USER_DETAIL-PBOXCIT_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-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_USER_DETAIL-STREET_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-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_USER_DETAIL-LANGU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-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_USER_DETAIL-E_MAIL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-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_USER_DETAIL-HOMECITYNO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-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_USER_DETAIL-LANGU_CR_P
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-LANGU_CR_P.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit SXIDN, internal->external for field MEMAIL
CALL FUNCTION 'CONVERSION_EXIT_SXIDN_OUTPUT'
  EXPORTING
    input =                      WA_GRAC_S_USER_DETAIL-MEMAIL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_GRAC_S_USER_DETAIL-MEMAIL.
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_USER_DETAIL_STR, 
PARAMETER0 TYPE STRING,
PROFILES TYPE STRING,
ROLES TYPE STRING,
ADDTEL TYPE STRING,
ADDFAX TYPE STRING,
ADDTTX TYPE STRING,
ADDTLX TYPE STRING,
ADDSMTP TYPE STRING,
ADDRML TYPE STRING,
ADDX400 TYPE STRING,
ADDRFC TYPE STRING,
ADDPRT TYPE STRING,
ADDSSF TYPE STRING,
ADDURI TYPE STRING,
ADDPAG TYPE STRING,
ADDCOMREM TYPE STRING,
PARAMETER1 TYPE STRING,
GROUPS TYPE STRING,
UCLASSSYS TYPE STRING,
EXTIDHEAD TYPE STRING,
EXTIDPART TYPE STRING,
SYSTEMS TYPE STRING,
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,
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,
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,
COMPANY TYPE STRING,
COMPANY TYPE STRING,
SNC TYPE STRING,
GUIFLAG TYPE STRING,
PNAME TYPE STRING,
REF_USER TYPE STRING,
REF_USER TYPE STRING,
ALIAS0 TYPE STRING,
USERALIAS TYPE STRING,
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,
LASTMODIFIED TYPE STRING,
MODDATE TYPE STRING,
MODTIME TYPE STRING,
ISLOCKED TYPE STRING,
WRNG_LOGON TYPE STRING,
LOCAL_LOCK TYPE STRING,
GLOB_LOCK TYPE STRING,
NO_USER_PW TYPE STRING,
MANAGER_ID TYPE STRING,
ISHRDATA TYPE STRING,
BNAME TYPE STRING,
PERNR TYPE STRING,
NAME_FIRST TYPE STRING,
NAME_LAST TYPE STRING,
EMAIL TYPE STRING,
NATIONALITY TYPE STRING,
PERS_AREA TYPE STRING,
STELEPHONE TYPE STRING,
TELEPHONE TYPE STRING,
FAX TYPE STRING,
VALID_FROM TYPE STRING,
VALID_TO TYPE STRING,
COST_CENTER TYPE STRING,
ORG_UNIT TYPE STRING,
ORG_DESC TYPE STRING,
POSITION TYPE STRING,
JOB TYPE STRING,
EMP_GROUP TYPE STRING,
BUS_AREA TYPE STRING,
COMP_CODE TYPE STRING,
PERS_AREA_DESC TYPE STRING,
MPERNR TYPE STRING,
MBNAME TYPE STRING,
MFNAME TYPE STRING,
MLNAME TYPE STRING,
MEMAIL TYPE STRING,
MSTELEPHONE TYPE STRING,
MTELEPHONE TYPE STRING,
SPRAS TYPE STRING,
IS_CUSTOM_FIELD TYPE STRING,
CUSTOM_FIELD TYPE STRING,END OF T_EKKO_STR.
DATA: WA_GRAC_S_USER_DETAIL_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_USER_DETAIL_STR-PARAMETER0 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PROFILES sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ROLES sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDTEL sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDFAX sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDTTX sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDTLX sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDSMTP sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDRML sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDX400 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDRFC sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDPRT sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDSSF sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDURI sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDPAG sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDCOMREM sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PARAMETER1 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-GROUPS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-UCLASSSYS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-EXTIDHEAD sy-vline 
WA_GRAC_S_USER_DETAIL_STR-EXTIDPART sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SYSTEMS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LOGONDATA sy-vline 
WA_GRAC_S_USER_DETAIL_STR-GLTGV sy-vline 
WA_GRAC_S_USER_DETAIL_STR-GLTGB sy-vline 
WA_GRAC_S_USER_DETAIL_STR-USTYP sy-vline 
WA_GRAC_S_USER_DETAIL_STR-CLASS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ACCNT sy-vline 
WA_GRAC_S_USER_DETAIL_STR-TZONE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LTIME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-BCODE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-CODVN sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PASSCODE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-CODVC sy-vline 
WA_GRAC_S_USER_DETAIL_STR-KOSTL sy-vline 
WA_GRAC_S_USER_DETAIL_STR-DEFAULTS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-STCOD sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SPLD sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SPLG sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SPDB sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SPDA sy-vline 
WA_GRAC_S_USER_DETAIL_STR-DATFM sy-vline 
WA_GRAC_S_USER_DETAIL_STR-DCPFM sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LANGU sy-vline 
WA_GRAC_S_USER_DETAIL_STR-CATTKENNZ sy-vline 
WA_GRAC_S_USER_DETAIL_STR-KOSTL sy-vline 
WA_GRAC_S_USER_DETAIL_STR-START_MENU sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDRESS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PERS_NO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADDR_NO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-TITLE_P sy-vline 
WA_GRAC_S_USER_DETAIL_STR-FIRSTNAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LASTNAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-BIRTH_NAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-MIDDLENAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SECONDNAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-FULLNAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-FULLNAME_X sy-vline 
WA_GRAC_S_USER_DETAIL_STR-TITLE_ACA1 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-TITLE_ACA2 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PREFIX1 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PREFIX2 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-TITLE_SPPL sy-vline 
WA_GRAC_S_USER_DETAIL_STR-NICKNAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-INITIALS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-NAMEFORMAT sy-vline 
WA_GRAC_S_USER_DETAIL_STR-NAMCOUNTRY sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LANGU_P sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LANGUP_ISO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SORT1_P sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SORT2_P sy-vline 
WA_GRAC_S_USER_DETAIL_STR-DEPARTMENT sy-vline 
WA_GRAC_S_USER_DETAIL_STR-FUNCTION sy-vline 
WA_GRAC_S_USER_DETAIL_STR-BUILDING_P sy-vline 
WA_GRAC_S_USER_DETAIL_STR-FLOOR_P sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ROOM_NO_P sy-vline 
WA_GRAC_S_USER_DETAIL_STR-INITS_SIG sy-vline 
WA_GRAC_S_USER_DETAIL_STR-INHOUSE_ML sy-vline 
WA_GRAC_S_USER_DETAIL_STR-COMM_TYPE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-TITLE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-NAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-NAME_2 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-NAME_3 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-NAME_4 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-C_O_NAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-CITY sy-vline 
WA_GRAC_S_USER_DETAIL_STR-DISTRICT sy-vline 
WA_GRAC_S_USER_DETAIL_STR-CITY_NO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-DISTRCT_NO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-CHCKSTATUS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-POSTL_COD1 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-POSTL_COD2 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-POSTL_COD3 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PO_BOX sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PO_BOX_CIT sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PBOXCIT_NO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-DELIV_DIS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-TRANSPZONE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-STREET sy-vline 
WA_GRAC_S_USER_DETAIL_STR-STREET_NO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-STR_ABBR sy-vline 
WA_GRAC_S_USER_DETAIL_STR-HOUSE_NO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-HOUSE_NO2 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-STR_SUPPL1 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-STR_SUPPL2 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-STR_SUPPL3 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LOCATION sy-vline 
WA_GRAC_S_USER_DETAIL_STR-BUILDING sy-vline 
WA_GRAC_S_USER_DETAIL_STR-FLOOR sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ROOM_NO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-COUNTRY sy-vline 
WA_GRAC_S_USER_DETAIL_STR-COUNTRYISO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LANGU sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LANGU_ISO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-REGION sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SORT1 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SORT2 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-TIME_ZONE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-TAXJURCODE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ADR_NOTES sy-vline 
WA_GRAC_S_USER_DETAIL_STR-TEL1_NUMBR sy-vline 
WA_GRAC_S_USER_DETAIL_STR-TEL1_EXT sy-vline 
WA_GRAC_S_USER_DETAIL_STR-FAX_NUMBER sy-vline 
WA_GRAC_S_USER_DETAIL_STR-FAX_EXTENS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-E_MAIL sy-vline 
WA_GRAC_S_USER_DETAIL_STR-BUILD_LONG sy-vline 
WA_GRAC_S_USER_DETAIL_STR-REGIOGROUP sy-vline 
WA_GRAC_S_USER_DETAIL_STR-HOME_CITY sy-vline 
WA_GRAC_S_USER_DETAIL_STR-HOMECITYNO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PCODE1_EXT sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PCODE2_EXT sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PCODE3_EXT sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PO_W_O_NO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PO_BOX_REG sy-vline 
WA_GRAC_S_USER_DETAIL_STR-POBOX_CTRY sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PO_CTRYISO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-DONT_USE_S sy-vline 
WA_GRAC_S_USER_DETAIL_STR-DONT_USE_P sy-vline 
WA_GRAC_S_USER_DETAIL_STR-HOUSE_NO3 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LANGU_CR_P sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LANGUCPISO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-COMPANY sy-vline 
WA_GRAC_S_USER_DETAIL_STR-COMPANY sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SNC sy-vline 
WA_GRAC_S_USER_DETAIL_STR-GUIFLAG sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PNAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-REF_USER sy-vline 
WA_GRAC_S_USER_DETAIL_STR-REF_USER sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ALIAS0 sy-vline 
WA_GRAC_S_USER_DETAIL_STR-USERALIAS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-UCLASS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LIC_TYPE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SPEC_VERS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-COUNTRY_SURCHARGE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SUBSTITUTE_FROM sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SUBSTITUTE_UNTIL sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SYSID sy-vline 
WA_GRAC_S_USER_DETAIL_STR-CLIENT sy-vline 
WA_GRAC_S_USER_DETAIL_STR-BNAME_CHARGEABLE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LASTMODIFIED sy-vline 
WA_GRAC_S_USER_DETAIL_STR-MODDATE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-MODTIME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ISLOCKED sy-vline 
WA_GRAC_S_USER_DETAIL_STR-WRNG_LOGON sy-vline 
WA_GRAC_S_USER_DETAIL_STR-LOCAL_LOCK sy-vline 
WA_GRAC_S_USER_DETAIL_STR-GLOB_LOCK sy-vline 
WA_GRAC_S_USER_DETAIL_STR-NO_USER_PW sy-vline 
WA_GRAC_S_USER_DETAIL_STR-MANAGER_ID sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ISHRDATA sy-vline 
WA_GRAC_S_USER_DETAIL_STR-BNAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PERNR sy-vline 
WA_GRAC_S_USER_DETAIL_STR-NAME_FIRST sy-vline 
WA_GRAC_S_USER_DETAIL_STR-NAME_LAST sy-vline 
WA_GRAC_S_USER_DETAIL_STR-EMAIL sy-vline 
WA_GRAC_S_USER_DETAIL_STR-NATIONALITY sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PERS_AREA sy-vline 
WA_GRAC_S_USER_DETAIL_STR-STELEPHONE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-TELEPHONE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-FAX sy-vline 
WA_GRAC_S_USER_DETAIL_STR-VALID_FROM sy-vline 
WA_GRAC_S_USER_DETAIL_STR-VALID_TO sy-vline 
WA_GRAC_S_USER_DETAIL_STR-COST_CENTER sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ORG_UNIT sy-vline 
WA_GRAC_S_USER_DETAIL_STR-ORG_DESC sy-vline 
WA_GRAC_S_USER_DETAIL_STR-POSITION sy-vline 
WA_GRAC_S_USER_DETAIL_STR-JOB sy-vline 
WA_GRAC_S_USER_DETAIL_STR-EMP_GROUP sy-vline 
WA_GRAC_S_USER_DETAIL_STR-BUS_AREA sy-vline 
WA_GRAC_S_USER_DETAIL_STR-COMP_CODE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-PERS_AREA_DESC sy-vline 
WA_GRAC_S_USER_DETAIL_STR-MPERNR sy-vline 
WA_GRAC_S_USER_DETAIL_STR-MBNAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-MFNAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-MLNAME sy-vline 
WA_GRAC_S_USER_DETAIL_STR-MEMAIL sy-vline 
WA_GRAC_S_USER_DETAIL_STR-MSTELEPHONE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-MTELEPHONE sy-vline 
WA_GRAC_S_USER_DETAIL_STR-SPRAS sy-vline 
WA_GRAC_S_USER_DETAIL_STR-IS_CUSTOM_FIELD sy-vline 
WA_GRAC_S_USER_DETAIL_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.