ABAP Select data from SAP table ILIQD 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 ILIQD 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 ILIQD. 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 ILIQD 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_ILIQD TYPE STANDARD TABLE OF ILIQD,
      WA_ILIQD TYPE ILIQD,
      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: <ILIQD> TYPE ILIQD.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ILIQD
*  INTO TABLE @DATA(IT_ILIQD2).
*--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_ILIQD INDEX 1 INTO DATA(WA_ILIQD2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<ILIQD>-MANDT = 1.
<ILIQD>-COLLATERALLIQUIDATIONUUID = 1.
<ILIQD>-OBJECTREFERENCEUUID = 1.
<ILIQD>-LIQUIDATIONOBJECTREFSYSTEM = 1.
<ILIQD>-LIQUIDATIONTYPE = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ILIQD-LIQUIDATIONSTARTDATE, sy-vline,
  WA_ILIQD-LIQUIDATIONENDDATE, sy-vline,
  WA_ILIQD-LIQUIDATIONINITIATEDBY, sy-vline,
  WA_ILIQD-LIQUIDATIONAPPLICATIONDATE, sy-vline,
  WA_ILIQD-LIQUIDATIONCOURTORDERDATE, sy-vline,
  WA_ILIQD-LQDTNCOURTORDERRECEIVEDDATE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_ILIQD 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_ILIQD 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_ILIQD INTO WA_ILIQD.


*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_ILIQD_STR, 
MANDT TYPE STRING,
COLLATERALLIQUIDATIONUUID TYPE STRING,
OBJECTREFERENCEUUID TYPE STRING,
LIQUIDATIONOBJECTREFSYSTEM TYPE STRING,
LIQUIDATIONTYPE TYPE STRING,
LIQUIDATIONSTARTDATE TYPE STRING,
LIQUIDATIONENDDATE TYPE STRING,
LIQUIDATIONINITIATEDBY TYPE STRING,
LIQUIDATIONAPPLICATIONDATE TYPE STRING,
LIQUIDATIONCOURTORDERDATE TYPE STRING,
LQDTNCOURTORDERRECEIVEDDATE TYPE STRING,
LIQUIDATIONDECISIONCLOSEDDATE TYPE STRING,
LQDTNDECISIONCLOSERECEIVEDDATE TYPE STRING,
LQDTNGUARANTEECALLINGAMOUNT TYPE STRING,
LQDTNGUARANTEECALLINGCURRENCY TYPE STRING,
LQDTNGUARANTEECALLINGDATE TYPE STRING,
LQDTNGUARANTEEENFORCEABLEDATE TYPE STRING,
LQDTNENFRCMNTTITLEOBTAINED TYPE STRING,
LIQUIDATIONENFORCEABLEDESC TYPE STRING,
LIQUIDATIONAFFIDAVITDATE TYPE STRING,
LIQUIDATIONAFFIDAVITDESC TYPE STRING,
LIQUIDATIONAMICABLEDATE TYPE STRING,
LIQUIDATIONAMICABLEDESCRIPTION TYPE STRING,
LIQUIDATIONREGISTRATIONDATE TYPE STRING,
LIQUIDATIONADMINRCVRREQDTE TYPE STRING,
LIQUIDATIONATTACHMENTDATE TYPE STRING,
LQDTNENFRCMNTTTLRQDBFRDTE TYPE STRING,
LQDTNOUTOFCOURTSETTLMTDTE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_ILIQD_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_ILIQD_STR-MANDT sy-vline 
WA_ILIQD_STR-COLLATERALLIQUIDATIONUUID sy-vline 
WA_ILIQD_STR-OBJECTREFERENCEUUID sy-vline 
WA_ILIQD_STR-LIQUIDATIONOBJECTREFSYSTEM sy-vline 
WA_ILIQD_STR-LIQUIDATIONTYPE sy-vline 
WA_ILIQD_STR-LIQUIDATIONSTARTDATE sy-vline 
WA_ILIQD_STR-LIQUIDATIONENDDATE sy-vline 
WA_ILIQD_STR-LIQUIDATIONINITIATEDBY sy-vline 
WA_ILIQD_STR-LIQUIDATIONAPPLICATIONDATE sy-vline 
WA_ILIQD_STR-LIQUIDATIONCOURTORDERDATE sy-vline 
WA_ILIQD_STR-LQDTNCOURTORDERRECEIVEDDATE sy-vline 
WA_ILIQD_STR-LIQUIDATIONDECISIONCLOSEDDATE sy-vline 
WA_ILIQD_STR-LQDTNDECISIONCLOSERECEIVEDDATE sy-vline 
WA_ILIQD_STR-LQDTNGUARANTEECALLINGAMOUNT sy-vline 
WA_ILIQD_STR-LQDTNGUARANTEECALLINGCURRENCY sy-vline 
WA_ILIQD_STR-LQDTNGUARANTEECALLINGDATE sy-vline 
WA_ILIQD_STR-LQDTNGUARANTEEENFORCEABLEDATE sy-vline 
WA_ILIQD_STR-LQDTNENFRCMNTTITLEOBTAINED sy-vline 
WA_ILIQD_STR-LIQUIDATIONENFORCEABLEDESC sy-vline 
WA_ILIQD_STR-LIQUIDATIONAFFIDAVITDATE sy-vline 
WA_ILIQD_STR-LIQUIDATIONAFFIDAVITDESC sy-vline 
WA_ILIQD_STR-LIQUIDATIONAMICABLEDATE sy-vline 
WA_ILIQD_STR-LIQUIDATIONAMICABLEDESCRIPTION sy-vline 
WA_ILIQD_STR-LIQUIDATIONREGISTRATIONDATE sy-vline 
WA_ILIQD_STR-LIQUIDATIONADMINRCVRREQDTE sy-vline 
WA_ILIQD_STR-LIQUIDATIONATTACHMENTDATE sy-vline 
WA_ILIQD_STR-LQDTNENFRCMNTTTLRQDBFRDTE sy-vline 
WA_ILIQD_STR-LQDTNOUTOFCOURTSETTLMTDTE sy-vline      INTO ld_text SEPARATED BY SPACE.

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