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

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

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

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


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
</SAPPO/STR_FA_FIELDS_FCAT>-FA_FIELD = 1.
</SAPPO/STR_FA_FIELDS_FCAT>-ROW_POS = 1.
</SAPPO/STR_FA_FIELDS_FCAT>-COL_POS = 1.
</SAPPO/STR_FA_FIELDS_FCAT>-FIELDNAME = 1.
</SAPPO/STR_FA_FIELDS_FCAT>-TABNAME = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SAPPO/STR_FA_FIELDS_FCAT-CURRENCY, sy-vline,
  WA_/SAPPO/STR_FA_FIELDS_FCAT-CFIELDNAME, sy-vline,
  WA_/SAPPO/STR_FA_FIELDS_FCAT-QUANTITY, sy-vline,
  WA_/SAPPO/STR_FA_FIELDS_FCAT-QFIELDNAME, sy-vline,
  WA_/SAPPO/STR_FA_FIELDS_FCAT-IFIELDNAME, sy-vline,
  WA_/SAPPO/STR_FA_FIELDS_FCAT-ROUND, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/SAPPO/STR_FA_FIELDS_FCAT 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_/SAPPO/STR_FA_FIELDS_FCAT 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_/SAPPO/STR_FA_FIELDS_FCAT INTO WA_/SAPPO/STR_FA_FIELDS_FCAT.


*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 DTYPE, internal->external for field DATATYPE
CALL FUNCTION 'CONVERSION_EXIT_DTYPE_OUTPUT'
  EXPORTING
    input =                      WA_/SAPPO/STR_FA_FIELDS_FCAT-DATATYPE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPPO/STR_FA_FIELDS_FCAT-DATATYPE.
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_/SAPPO/STR_FA_FIELDS_FCAT_STR, 
FA_FIELD TYPE STRING,
ROW_POS TYPE STRING,
COL_POS TYPE STRING,
FIELDNAME TYPE STRING,
TABNAME TYPE STRING,
CURRENCY TYPE STRING,
CFIELDNAME TYPE STRING,
QUANTITY TYPE STRING,
QFIELDNAME TYPE STRING,
IFIELDNAME TYPE STRING,
ROUND TYPE STRING,
EXPONENT TYPE STRING,
KEY TYPE STRING,
KEY_SEL TYPE STRING,
ICON TYPE STRING,
SYMBOL TYPE STRING,
CHECKBOX TYPE STRING,
JUST TYPE STRING,
LZERO TYPE STRING,
NO_SIGN TYPE STRING,
NO_ZERO TYPE STRING,
NO_CONVEXT TYPE STRING,
EDIT_MASK TYPE STRING,
EMPHASIZE TYPE STRING,
FIX_COLUMN TYPE STRING,
DO_SUM TYPE STRING,
NO_SUM TYPE STRING,
NO_OUT TYPE STRING,
TECH TYPE STRING,
OUTPUTLEN TYPE STRING,
CONVEXIT TYPE STRING,
SELTEXT TYPE STRING,
TOOLTIP TYPE STRING,
ROLLNAME TYPE STRING,
DATATYPE TYPE STRING,
INTTYPE TYPE STRING,
INTLEN TYPE STRING,
LOWERCASE TYPE STRING,
REPTEXT TYPE STRING,
HIER_LEVEL TYPE STRING,
REPREP TYPE STRING,
DOMNAME TYPE STRING,
SP_GROUP TYPE STRING,
HOTSPOT TYPE STRING,
DFIELDNAME TYPE STRING,
COL_ID TYPE STRING,
F4AVAILABL TYPE STRING,
AUTO_VALUE TYPE STRING,
CHECKTABLE TYPE STRING,
VALEXI TYPE STRING,
WEB_FIELD TYPE STRING,
HREF_HNDL TYPE STRING,
STYLE TYPE STRING,
STYLE2 TYPE STRING,
STYLE3 TYPE STRING,
STYLE4 TYPE STRING,
DRDN_HNDL TYPE STRING,
DRDN_FIELD TYPE STRING,
NO_MERGING TYPE STRING,
H_FTYPE TYPE STRING,
COL_OPT TYPE STRING,
NO_INIT_CH TYPE STRING,
DRDN_ALIAS TYPE STRING,
DECFLOAT_STYLE TYPE STRING,
PARAMETER0 TYPE STRING,
PARAMETER1 TYPE STRING,
PARAMETER2 TYPE STRING,
PARAMETER3 TYPE STRING,
PARAMETER4 TYPE STRING,
PARAMETER5 TYPE STRING,
PARAMETER6 TYPE STRING,
PARAMETER7 TYPE STRING,
PARAMETER8 TYPE STRING,
PARAMETER9 TYPE STRING,
REF_FIELD TYPE STRING,
REF_TABLE TYPE STRING,
TXT_FIELD TYPE STRING,
ROUNDFIELD TYPE STRING,
DECIMALS_O TYPE STRING,
DECMLFIELD TYPE STRING,
DD_OUTLEN TYPE STRING,
DECIMALS TYPE STRING,
COLTEXT TYPE STRING,
SCRTEXT_L TYPE STRING,
SCRTEXT_M TYPE STRING,
SCRTEXT_S TYPE STRING,
COLDDICTXT TYPE STRING,
SELDDICTXT TYPE STRING,
TIPDDICTXT TYPE STRING,
EDIT TYPE STRING,
TECH_COL TYPE STRING,
TECH_FORM TYPE STRING,
TECH_COMP TYPE STRING,
HIER_CPOS TYPE STRING,
H_COL_KEY TYPE STRING,
H_SELECT TYPE STRING,
DD_ROLL TYPE STRING,
DRAGDROPID TYPE STRING,
MAC TYPE STRING,
INDX_FIELD TYPE STRING,
INDX_CFIEL TYPE STRING,
INDX_QFIEL TYPE STRING,
INDX_IFIEL TYPE STRING,
INDX_ROUND TYPE STRING,
INDX_DECML TYPE STRING,
GET_STYLE TYPE STRING,
MARK TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/SAPPO/STR_FA_FIELDS_FCAT_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_/SAPPO/STR_FA_FIELDS_FCAT_STR-FA_FIELD sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-ROW_POS sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-COL_POS sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-FIELDNAME sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-TABNAME sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-CURRENCY sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-CFIELDNAME sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-QUANTITY sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-QFIELDNAME sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-IFIELDNAME sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-ROUND sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-EXPONENT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-KEY sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-KEY_SEL sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-ICON sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-SYMBOL sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-CHECKBOX sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-JUST sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-LZERO sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-NO_SIGN sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-NO_ZERO sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-NO_CONVEXT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-EDIT_MASK sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-EMPHASIZE sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-FIX_COLUMN sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DO_SUM sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-NO_SUM sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-NO_OUT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-TECH sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-OUTPUTLEN sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-CONVEXIT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-SELTEXT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-TOOLTIP sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-ROLLNAME sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DATATYPE sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-INTTYPE sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-INTLEN sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-LOWERCASE sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-REPTEXT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-HIER_LEVEL sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-REPREP sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DOMNAME sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-SP_GROUP sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-HOTSPOT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DFIELDNAME sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-COL_ID sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-F4AVAILABL sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-AUTO_VALUE sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-CHECKTABLE sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-VALEXI sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-WEB_FIELD sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-HREF_HNDL sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-STYLE sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-STYLE2 sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-STYLE3 sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-STYLE4 sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DRDN_HNDL sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DRDN_FIELD sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-NO_MERGING sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-H_FTYPE sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-COL_OPT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-NO_INIT_CH sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DRDN_ALIAS sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DECFLOAT_STYLE sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-PARAMETER0 sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-PARAMETER1 sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-PARAMETER2 sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-PARAMETER3 sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-PARAMETER4 sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-PARAMETER5 sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-PARAMETER6 sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-PARAMETER7 sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-PARAMETER8 sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-PARAMETER9 sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-REF_FIELD sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-REF_TABLE sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-TXT_FIELD sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-ROUNDFIELD sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DECIMALS_O sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DECMLFIELD sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DD_OUTLEN sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DECIMALS sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-COLTEXT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-SCRTEXT_L sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-SCRTEXT_M sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-SCRTEXT_S sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-COLDDICTXT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-SELDDICTXT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-TIPDDICTXT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-EDIT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-TECH_COL sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-TECH_FORM sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-TECH_COMP sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-HIER_CPOS sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-H_COL_KEY sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-H_SELECT sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DD_ROLL sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-DRAGDROPID sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-MAC sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-INDX_FIELD sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-INDX_CFIEL sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-INDX_QFIEL sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-INDX_IFIEL sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-INDX_ROUND sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-INDX_DECML sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-GET_STYLE sy-vline 
WA_/SAPPO/STR_FA_FIELDS_FCAT_STR-MARK sy-vline      INTO ld_text SEPARATED BY SPACE.

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