ABAP Select data from SAP table TBINTCHK1 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 TBINTCHK1 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 TBINTCHK1. 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 TBINTCHK1 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_TBINTCHK1 TYPE STANDARD TABLE OF TBINTCHK1,
      WA_TBINTCHK1 TYPE TBINTCHK1,
      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: <TBINTCHK1> TYPE TBINTCHK1.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM TBINTCHK1
*  INTO TABLE @DATA(IT_TBINTCHK12).
*--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_TBINTCHK1 INDEX 1 INTO DATA(WA_TBINTCHK12).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<TBINTCHK1>-SAH_SPACE = 1.
<TBINTCHK1>-SAH_LENGTH = 1.
<TBINTCHK1>-SAH_CSPACE = 1.
<TBINTCHK1>-SAH_HYPHEN = 1.
<TBINTCHK1>-SAH_1CHBAZ = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_TBINTCHK1-SAH_1CHUYZ, sy-vline,
  WA_TBINTCHK1-SAH_ALPHAN, sy-vline,
  WA_TBINTCHK1-SAH_2O3PC_, sy-vline,
  WA_TBINTCHK1-SAH_TRESE, sy-vline,
  WA_TBINTCHK1-SAH_QCM, sy-vline,
  WA_TBINTCHK1-SAH_POINT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_TBINTCHK1 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_TBINTCHK1 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_TBINTCHK1 INTO WA_TBINTCHK1.


*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.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_TBINTCHK1_STR, 
SAH_SPACE TYPE STRING,
SAH_LENGTH TYPE STRING,
SAH_CSPACE TYPE STRING,
SAH_HYPHEN TYPE STRING,
SAH_1CHBAZ TYPE STRING,
SAH_1CHUYZ TYPE STRING,
SAH_ALPHAN TYPE STRING,
SAH_2O3PC_ TYPE STRING,
SAH_TRESE TYPE STRING,
SAH_QCM TYPE STRING,
SAH_POINT TYPE STRING,
SAH_LPOS_ TYPE STRING,
SAH_LANSI TYPE STRING,
EXISTSNAME TYPE STRING,
MINLENGTH TYPE STRING,
TYPEPOOL TYPE STRING,
HDSLASH TYPE STRING,
CLASSEXIST TYPE STRING,
SQLTBFILL TYPE STRING,
SQLTBAPP TYPE STRING,
TYPEEXISTS TYPE STRING,
POCLACTIVE TYPE STRING,
CLUSTREST TYPE STRING,
DELIVERYCL TYPE STRING,
TYPEVALUE TYPE STRING,
CLIDEP TYPE STRING,
BUFFERED TYPE STRING,
COMPRFLAG TYPE STRING,
ACTFLAG TYPE STRING,
MAINFLAG TYPE STRING,
IS_GTT_VAL TYPE STRING,
PK_IS_INVHASH_VAL TYPE STRING,
AUTHCLASS TYPE STRING,
NTABCMP TYPE STRING,
NTABNOEX TYPE STRING,
AGGRUSE TYPE STRING,
EXPAND TYPE STRING,
POINTCHG TYPE STRING,
APPUSE2 TYPE STRING,
APPDEVC TYPE STRING,
CENTRALBS TYPE STRING,
AUTHCHK TYPE STRING,
MXCNV TYPE STRING,
EXCLCHK TYPE STRING,
CNVACT TYPE STRING,
PACKAGECHK TYPE STRING,
REPLACE TYPE STRING,
PK_IS_INVHASH TYPE STRING,
CNV_HISTTAB_CHK TYPE STRING,
ROWORCOLST_CHK TYPE STRING,
EXTENSIBILITY_CONSISTENCY TYPE STRING,
EXTENSIBILITY_CONTRACT TYPE STRING,
ABAP_LANG_VERS_HEADER_CHECK TYPE STRING,
FIELDEX TYPE STRING,
FLDCNTMAX TYPE STRING,
FLDRES TYPE STRING,
SAA_SPACE TYPE STRING,
SAA_LENGTH TYPE STRING,
SAA_CSPACE TYPE STRING,
SAA_HYPHEN TYPE STRING,
SAA_1CHBAZ TYPE STRING,
SAA_1CHUYZ TYPE STRING,
SAA_ALPHAN TYPE STRING,
SAA_2O3PC_ TYPE STRING,
SAA_TRESE TYPE STRING,
SAA_QCM TYPE STRING,
SAA_POINT TYPE STRING,
SAA_LPOS_ TYPE STRING,
SAA_LANSI TYPE STRING,
SAA_PREFIX TYPE STRING,
SAA_CASESENS TYPE STRING,
NOCUSTFLD TYPE STRING,
NOBRANCHN TYPE STRING,
NOSAPFLD TYPE STRING,
KEY_EXIST TYPE STRING,
KEY_NUMB TYPE STRING,
KEY_CON TYPE STRING,
KEY_BEGIN TYPE STRING,
KEY_LEN TYPE STRING,
KEY_TRANS TYPE STRING,
KEY_TTYP TYPE STRING,
KEY_CLIRF TYPE STRING,
KEY_STRING TYPE STRING,
KEY_TYPES TYPE STRING,
KEY_DECFLOAT TYPE STRING,
KEY_INVHASH TYPE STRING,
KEYCHK_CTRL TYPE STRING,
DUPFIELD TYPE STRING,
EXISTDODE TYPE STRING,
TYPECHECK TYPE STRING,
MANDANT TYPE STRING,
DATATYPE TYPE STRING,
KEYCHANGE TYPE STRING,
EXISTVARC TYPE STRING,
TYPE_VARC TYPE STRING,
TYPE_LCHR TYPE STRING,
TYPE_LRAW TYPE STRING,
LONGTYPENR TYPE STRING,
TABLENGTH TYPE STRING,
TABLENGTH_CHK_CTRL TYPE STRING,
STRUCTURELENGTH TYPE STRING,
DOMALENGTH TYPE STRING,
CURRLENGTH TYPE STRING,
EXISTREF TYPE STRING,
INTREF TYPE STRING,
OUTREF TYPE STRING,
OUTPUTSTYLE TYPE STRING,
CHECKREF TYPE STRING,
CHECKAGGR TYPE STRING,
CHECKLOBEX TYPE STRING,
KEYFLAG TYPE STRING,
MANDATORY TYPE STRING,
ADMINFIELD TYPE STRING,
NOTNULLFLG TYPE STRING,
LANGUFLAG TYPE STRING,
KEYTYPE TYPE STRING,
KEYLENGTH TYPE STRING,
DATALENGTH TYPE STRING,
MAXPLENG TYPE STRING,
FLDTYPE TYPE STRING,
DECFLOATEX TYPE STRING,
CLUSTERCHK TYPE STRING,
FNOT_NULL TYPE STRING,
NNLONGFLD TYPE STRING,
SAA_TRESEM TYPE STRING,
IDBACHK TYPE STRING,
NDEFTYPES TYPE STRING,
DDPREFIX TYPE STRING,
CIRCLE TYPE STRING,
TYPECORR TYPE STRING,
TYPEACT TYPE STRING,
TYPEACTCI TYPE STRING,
DEEPFLDLG TYPE STRING,
INCLKIND TYPE STRING,
FDSLASH TYPE STRING,
TTYPGEN TYPE STRING,
FLATSTRUC TYPE STRING,
ADDSTRUC TYPE STRING,
DATATYCHG TYPE STRING,
REFRES TYPE STRING,
TYPEUSAGE TYPE STRING,
GROUPDUPL TYPE STRING,
GREQUALFLD TYPE STRING,
MAXSTRGNR TYPE STRING,
PROXYTYPE TYPE STRING,
ABAP_LANG_VERS_FIELDS_CHECK TYPE STRING,
LANGFLCHK TYPE STRING,
SPSTRUCHG TYPE STRING,
DECFLOATSCALE TYPE STRING,
STREAMORLOC TYPE STRING,
LOBBASETAB_CHG TYPE STRING,
VIEWREF_USAGE TYPE STRING,
SRS_ID_VALID TYPE STRING,
EXTENSIBILITY_INCLUDES TYPE STRING,END OF T_EKKO_STR.
DATA: WA_TBINTCHK1_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_TBINTCHK1_STR-SAH_SPACE sy-vline 
WA_TBINTCHK1_STR-SAH_LENGTH sy-vline 
WA_TBINTCHK1_STR-SAH_CSPACE sy-vline 
WA_TBINTCHK1_STR-SAH_HYPHEN sy-vline 
WA_TBINTCHK1_STR-SAH_1CHBAZ sy-vline 
WA_TBINTCHK1_STR-SAH_1CHUYZ sy-vline 
WA_TBINTCHK1_STR-SAH_ALPHAN sy-vline 
WA_TBINTCHK1_STR-SAH_2O3PC_ sy-vline 
WA_TBINTCHK1_STR-SAH_TRESE sy-vline 
WA_TBINTCHK1_STR-SAH_QCM sy-vline 
WA_TBINTCHK1_STR-SAH_POINT sy-vline 
WA_TBINTCHK1_STR-SAH_LPOS_ sy-vline 
WA_TBINTCHK1_STR-SAH_LANSI sy-vline 
WA_TBINTCHK1_STR-EXISTSNAME sy-vline 
WA_TBINTCHK1_STR-MINLENGTH sy-vline 
WA_TBINTCHK1_STR-TYPEPOOL sy-vline 
WA_TBINTCHK1_STR-HDSLASH sy-vline 
WA_TBINTCHK1_STR-CLASSEXIST sy-vline 
WA_TBINTCHK1_STR-SQLTBFILL sy-vline 
WA_TBINTCHK1_STR-SQLTBAPP sy-vline 
WA_TBINTCHK1_STR-TYPEEXISTS sy-vline 
WA_TBINTCHK1_STR-POCLACTIVE sy-vline 
WA_TBINTCHK1_STR-CLUSTREST sy-vline 
WA_TBINTCHK1_STR-DELIVERYCL sy-vline 
WA_TBINTCHK1_STR-TYPEVALUE sy-vline 
WA_TBINTCHK1_STR-CLIDEP sy-vline 
WA_TBINTCHK1_STR-BUFFERED sy-vline 
WA_TBINTCHK1_STR-COMPRFLAG sy-vline 
WA_TBINTCHK1_STR-ACTFLAG sy-vline 
WA_TBINTCHK1_STR-MAINFLAG sy-vline 
WA_TBINTCHK1_STR-IS_GTT_VAL sy-vline 
WA_TBINTCHK1_STR-PK_IS_INVHASH_VAL sy-vline 
WA_TBINTCHK1_STR-AUTHCLASS sy-vline 
WA_TBINTCHK1_STR-NTABCMP sy-vline 
WA_TBINTCHK1_STR-NTABNOEX sy-vline 
WA_TBINTCHK1_STR-AGGRUSE sy-vline 
WA_TBINTCHK1_STR-EXPAND sy-vline 
WA_TBINTCHK1_STR-POINTCHG sy-vline 
WA_TBINTCHK1_STR-APPUSE2 sy-vline 
WA_TBINTCHK1_STR-APPDEVC sy-vline 
WA_TBINTCHK1_STR-CENTRALBS sy-vline 
WA_TBINTCHK1_STR-AUTHCHK sy-vline 
WA_TBINTCHK1_STR-MXCNV sy-vline 
WA_TBINTCHK1_STR-EXCLCHK sy-vline 
WA_TBINTCHK1_STR-CNVACT sy-vline 
WA_TBINTCHK1_STR-PACKAGECHK sy-vline 
WA_TBINTCHK1_STR-REPLACE sy-vline 
WA_TBINTCHK1_STR-PK_IS_INVHASH sy-vline 
WA_TBINTCHK1_STR-CNV_HISTTAB_CHK sy-vline 
WA_TBINTCHK1_STR-ROWORCOLST_CHK sy-vline 
WA_TBINTCHK1_STR-EXTENSIBILITY_CONSISTENCY sy-vline 
WA_TBINTCHK1_STR-EXTENSIBILITY_CONTRACT sy-vline 
WA_TBINTCHK1_STR-ABAP_LANG_VERS_HEADER_CHECK sy-vline 
WA_TBINTCHK1_STR-FIELDEX sy-vline 
WA_TBINTCHK1_STR-FLDCNTMAX sy-vline 
WA_TBINTCHK1_STR-FLDRES sy-vline 
WA_TBINTCHK1_STR-SAA_SPACE sy-vline 
WA_TBINTCHK1_STR-SAA_LENGTH sy-vline 
WA_TBINTCHK1_STR-SAA_CSPACE sy-vline 
WA_TBINTCHK1_STR-SAA_HYPHEN sy-vline 
WA_TBINTCHK1_STR-SAA_1CHBAZ sy-vline 
WA_TBINTCHK1_STR-SAA_1CHUYZ sy-vline 
WA_TBINTCHK1_STR-SAA_ALPHAN sy-vline 
WA_TBINTCHK1_STR-SAA_2O3PC_ sy-vline 
WA_TBINTCHK1_STR-SAA_TRESE sy-vline 
WA_TBINTCHK1_STR-SAA_QCM sy-vline 
WA_TBINTCHK1_STR-SAA_POINT sy-vline 
WA_TBINTCHK1_STR-SAA_LPOS_ sy-vline 
WA_TBINTCHK1_STR-SAA_LANSI sy-vline 
WA_TBINTCHK1_STR-SAA_PREFIX sy-vline 
WA_TBINTCHK1_STR-SAA_CASESENS sy-vline 
WA_TBINTCHK1_STR-NOCUSTFLD sy-vline 
WA_TBINTCHK1_STR-NOBRANCHN sy-vline 
WA_TBINTCHK1_STR-NOSAPFLD sy-vline 
WA_TBINTCHK1_STR-KEY_EXIST sy-vline 
WA_TBINTCHK1_STR-KEY_NUMB sy-vline 
WA_TBINTCHK1_STR-KEY_CON sy-vline 
WA_TBINTCHK1_STR-KEY_BEGIN sy-vline 
WA_TBINTCHK1_STR-KEY_LEN sy-vline 
WA_TBINTCHK1_STR-KEY_TRANS sy-vline 
WA_TBINTCHK1_STR-KEY_TTYP sy-vline 
WA_TBINTCHK1_STR-KEY_CLIRF sy-vline 
WA_TBINTCHK1_STR-KEY_STRING sy-vline 
WA_TBINTCHK1_STR-KEY_TYPES sy-vline 
WA_TBINTCHK1_STR-KEY_DECFLOAT sy-vline 
WA_TBINTCHK1_STR-KEY_INVHASH sy-vline 
WA_TBINTCHK1_STR-KEYCHK_CTRL sy-vline 
WA_TBINTCHK1_STR-DUPFIELD sy-vline 
WA_TBINTCHK1_STR-EXISTDODE sy-vline 
WA_TBINTCHK1_STR-TYPECHECK sy-vline 
WA_TBINTCHK1_STR-MANDANT sy-vline 
WA_TBINTCHK1_STR-DATATYPE sy-vline 
WA_TBINTCHK1_STR-KEYCHANGE sy-vline 
WA_TBINTCHK1_STR-EXISTVARC sy-vline 
WA_TBINTCHK1_STR-TYPE_VARC sy-vline 
WA_TBINTCHK1_STR-TYPE_LCHR sy-vline 
WA_TBINTCHK1_STR-TYPE_LRAW sy-vline 
WA_TBINTCHK1_STR-LONGTYPENR sy-vline 
WA_TBINTCHK1_STR-TABLENGTH sy-vline 
WA_TBINTCHK1_STR-TABLENGTH_CHK_CTRL sy-vline 
WA_TBINTCHK1_STR-STRUCTURELENGTH sy-vline 
WA_TBINTCHK1_STR-DOMALENGTH sy-vline 
WA_TBINTCHK1_STR-CURRLENGTH sy-vline 
WA_TBINTCHK1_STR-EXISTREF sy-vline 
WA_TBINTCHK1_STR-INTREF sy-vline 
WA_TBINTCHK1_STR-OUTREF sy-vline 
WA_TBINTCHK1_STR-OUTPUTSTYLE sy-vline 
WA_TBINTCHK1_STR-CHECKREF sy-vline 
WA_TBINTCHK1_STR-CHECKAGGR sy-vline 
WA_TBINTCHK1_STR-CHECKLOBEX sy-vline 
WA_TBINTCHK1_STR-KEYFLAG sy-vline 
WA_TBINTCHK1_STR-MANDATORY sy-vline 
WA_TBINTCHK1_STR-ADMINFIELD sy-vline 
WA_TBINTCHK1_STR-NOTNULLFLG sy-vline 
WA_TBINTCHK1_STR-LANGUFLAG sy-vline 
WA_TBINTCHK1_STR-KEYTYPE sy-vline 
WA_TBINTCHK1_STR-KEYLENGTH sy-vline 
WA_TBINTCHK1_STR-DATALENGTH sy-vline 
WA_TBINTCHK1_STR-MAXPLENG sy-vline 
WA_TBINTCHK1_STR-FLDTYPE sy-vline 
WA_TBINTCHK1_STR-DECFLOATEX sy-vline 
WA_TBINTCHK1_STR-CLUSTERCHK sy-vline 
WA_TBINTCHK1_STR-FNOT_NULL sy-vline 
WA_TBINTCHK1_STR-NNLONGFLD sy-vline 
WA_TBINTCHK1_STR-SAA_TRESEM sy-vline 
WA_TBINTCHK1_STR-IDBACHK sy-vline 
WA_TBINTCHK1_STR-NDEFTYPES sy-vline 
WA_TBINTCHK1_STR-DDPREFIX sy-vline 
WA_TBINTCHK1_STR-CIRCLE sy-vline 
WA_TBINTCHK1_STR-TYPECORR sy-vline 
WA_TBINTCHK1_STR-TYPEACT sy-vline 
WA_TBINTCHK1_STR-TYPEACTCI sy-vline 
WA_TBINTCHK1_STR-DEEPFLDLG sy-vline 
WA_TBINTCHK1_STR-INCLKIND sy-vline 
WA_TBINTCHK1_STR-FDSLASH sy-vline 
WA_TBINTCHK1_STR-TTYPGEN sy-vline 
WA_TBINTCHK1_STR-FLATSTRUC sy-vline 
WA_TBINTCHK1_STR-ADDSTRUC sy-vline 
WA_TBINTCHK1_STR-DATATYCHG sy-vline 
WA_TBINTCHK1_STR-REFRES sy-vline 
WA_TBINTCHK1_STR-TYPEUSAGE sy-vline 
WA_TBINTCHK1_STR-GROUPDUPL sy-vline 
WA_TBINTCHK1_STR-GREQUALFLD sy-vline 
WA_TBINTCHK1_STR-MAXSTRGNR sy-vline 
WA_TBINTCHK1_STR-PROXYTYPE sy-vline 
WA_TBINTCHK1_STR-ABAP_LANG_VERS_FIELDS_CHECK sy-vline 
WA_TBINTCHK1_STR-LANGFLCHK sy-vline 
WA_TBINTCHK1_STR-SPSTRUCHG sy-vline 
WA_TBINTCHK1_STR-DECFLOATSCALE sy-vline 
WA_TBINTCHK1_STR-STREAMORLOC sy-vline 
WA_TBINTCHK1_STR-LOBBASETAB_CHG sy-vline 
WA_TBINTCHK1_STR-VIEWREF_USAGE sy-vline 
WA_TBINTCHK1_STR-SRS_ID_VALID sy-vline 
WA_TBINTCHK1_STR-EXTENSIBILITY_INCLUDES sy-vline      INTO ld_text SEPARATED BY SPACE.

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