ABAP Select data from SAP table ISCNSLDTNJRNLENTRYTP1 into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP ISCNSLDTNJRNLENTRYTP1 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 ISCNSLDTNJRNLENTRYTP1. 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 ISCNSLDTNJRNLENTRYTP1 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_ISCNSLDTNJRNLENTRYTP1 TYPE STANDARD TABLE OF ISCNSLDTNJRNLENTRYTP1,
      WA_ISCNSLDTNJRNLENTRYTP1 TYPE ISCNSLDTNJRNLENTRYTP1,
      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: <ISCNSLDTNJRNLENTRYTP1> TYPE ISCNSLDTNJRNLENTRYTP1.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ISCNSLDTNJRNLENTRYTP1
*  INTO TABLE @DATA(IT_ISCNSLDTNJRNLENTRYTP12).
*--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_ISCNSLDTNJRNLENTRYTP1 INDEX 1 INTO DATA(WA_ISCNSLDTNJRNLENTRYTP12).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_ISCNSLDTNJRNLENTRYTP1 ASSIGNING <ISCNSLDTNJRNLENTRYTP1>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<ISCNSLDTNJRNLENTRYTP1>-KEY = 1.
<ISCNSLDTNJRNLENTRYTP1>-PARENT_KEY = 1.
<ISCNSLDTNJRNLENTRYTP1>-ROOT_KEY = 1.
<ISCNSLDTNJRNLENTRYTP1>-FISCALYEAR = 1.
<ISCNSLDTNJRNLENTRYTP1>-CONSOLIDATIONDOCUMENTNUMBER = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONLEDGER, sy-vline,
WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONDIMENSION, sy-vline,
WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONLEDGERFOREDIT, sy-vline,
WA_ISCNSLDTNJRNLENTRYTP1-FISCALYEARFOREDIT, sy-vline,
WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONVERSION, sy-vline,
WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONUNIT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_ISCNSLDTNJRNLENTRYTP1 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_ISCNSLDTNJRNLENTRYTP1 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_ISCNSLDTNJRNLENTRYTP1 INTO WA_ISCNSLDTNJRNLENTRYTP1. *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 GJAHR, internal->external for field FISCALYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_ISCNSLDTNJRNLENTRYTP1-FISCALYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ISCNSLDTNJRNLENTRYTP1-FISCALYEAR.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit GJAHR, internal->external for field FISCALYEARFOREDIT CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_ISCNSLDTNJRNLENTRYTP1-FISCALYEARFOREDIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ISCNSLDTNJRNLENTRYTP1-FISCALYEARFOREDIT.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit AFIMC, internal->external for field CONSOLIDATIONUNIT CALL FUNCTION 'CONVERSION_EXIT_AFIMC_OUTPUT' EXPORTING input = WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONUNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AFIMC, internal->external for field CONSOLIDATIONGROUP CALL FUNCTION 'CONVERSION_EXIT_AFIMC_OUTPUT' EXPORTING input = WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONGROUP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONGROUP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AFIMC, internal->external for field CONSOLIDATIONUNIT1 CALL FUNCTION 'CONVERSION_EXIT_AFIMC_OUTPUT' EXPORTING input = WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONUNIT1 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONUNIT1.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AFIMC, internal->external for field CONSOLIDATIONUNIT2 CALL FUNCTION 'CONVERSION_EXIT_AFIMC_OUTPUT' EXPORTING input = WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONUNIT2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONUNIT2.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AFIMC, internal->external for field INVESTEECONSOLIDATIONUNIT CALL FUNCTION 'CONVERSION_EXIT_AFIMC_OUTPUT' EXPORTING input = WA_ISCNSLDTNJRNLENTRYTP1-INVESTEECONSOLIDATIONUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ISCNSLDTNJRNLENTRYTP1-INVESTEECONSOLIDATIONUNIT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit GJAHR, internal->external for field CONSOLIDATIONDOCREVERSALYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONDOCREVERSALYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ISCNSLDTNJRNLENTRYTP1-CONSOLIDATIONDOCREVERSALYEAR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CNSLDTNDOCUMENTNUMBERFOREDIT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ISCNSLDTNJRNLENTRYTP1-CNSLDTNDOCUMENTNUMBERFOREDIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ISCNSLDTNJRNLENTRYTP1-CNSLDTNDOCUMENTNUMBERFOREDIT.
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_ISCNSLDTNJRNLENTRYTP1_STR,
KEY TYPE STRING,
PARENT_KEY TYPE STRING,
ROOT_KEY TYPE STRING,
FISCALYEAR TYPE STRING,
CONSOLIDATIONDOCUMENTNUMBER TYPE STRING,
CONSOLIDATIONLEDGER TYPE STRING,
CONSOLIDATIONDIMENSION TYPE STRING,
CONSOLIDATIONLEDGERFOREDIT TYPE STRING,
FISCALYEARFOREDIT TYPE STRING,
CONSOLIDATIONVERSION TYPE STRING,
CONSOLIDATIONUNIT TYPE STRING,
FISCALPERIOD TYPE STRING,
CONSOLIDATIONCHARTOFACCOUNTS TYPE STRING,
POSTINGLEVEL TYPE STRING,
CONSOLIDATIONGROUP TYPE STRING,
CONSOLIDATIONDOCUMENTTYPE TYPE STRING,
DOCUMENTITEMTEXT TYPE STRING,
POSTINGDATE TYPE STRING,
CREATIONDATE TYPE STRING,
CREATIONTIME TYPE STRING,
USERID TYPE STRING,
CONSOLIDATIONUNIT1 TYPE STRING,
CONSOLIDATIONUNIT2 TYPE STRING,
INVESTEECONSOLIDATIONUNIT TYPE STRING,
INVESTMENTACTIVITYTYPE TYPE STRING,
INVESTMENTACTIVITY TYPE STRING,
REFCONSOLIDATIONDOCUMENTNUMBER TYPE STRING,
REVERSEDDOCUMENT TYPE STRING,
REVERSEDOCUMENT TYPE STRING,
CONSOLIDATIONDOCREVERSALYEAR TYPE STRING,
ISREVERSALDOCUMENT TYPE STRING,
ISCONSOLIDATIONTASKTESTRUN TYPE STRING,
CONSOLIDATIONTASKCATEGORY TYPE STRING,
CONSOLIDATIONTASK TYPE STRING,
CONSOLIDATIONJRNLENTRSOURCE TYPE STRING,
CONSOLIDATIONJRNLENTRDRAFTUUID TYPE STRING,
CNSLDTNDOCUMENTNUMBERFOREDIT TYPE STRING,
AMOUNTINTRANSCURRENCYISHIDDEN TYPE STRING,
AMOUNTINLOCALCURRENCYISHIDDEN TYPE STRING,
AMOUNTINGROUPCURRENCYISHIDDEN TYPE STRING,
QUANTITYINBASEUNITISHIDDEN TYPE STRING,
CNSLDTNUNIT1ISUSEDISHIDDEN TYPE STRING,
CONSOLIDATIONGROUPISHIDDEN TYPE STRING,
PARTNERCNSLDTNUNITISHIDDEN TYPE STRING,
CONSOLIDATIONUNITISHIDDEN TYPE STRING,
CONSOLIDATIONUNIT3ISHIDDEN TYPE STRING,
PARTNERCNSLDTNUNIT3ISHIDDEN TYPE STRING,
SUBITEMISHIDDEN TYPE STRING,
SUBITEMCATEGORYISHIDDEN TYPE STRING,
CNSLDTNGROUPJRNLENTRYBUNDLE TYPE STRING,
HASACTIVEENTITY TYPE STRING,
DRAFTENTITYCREATIONDATETIME TYPE STRING,
DRAFTENTITYLASTCHANGEDATETIME TYPE STRING,
DRAFTADMINISTRATIVEDATAUUID TYPE STRING,
DRAFTENTITYCONSISTENCYSTATUS TYPE STRING,
DRAFTENTITYOPERATIONCODE TYPE STRING,
ISACTIVEENTITY TYPE STRING,END OF T_EKKO_STR. DATA: WA_ISCNSLDTNJRNLENTRYTP1_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_ISCNSLDTNJRNLENTRYTP1_STR-KEY sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-PARENT_KEY sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-ROOT_KEY sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-FISCALYEAR sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONDOCUMENTNUMBER sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONLEDGER sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONDIMENSION sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONLEDGERFOREDIT sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-FISCALYEARFOREDIT sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONVERSION sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONUNIT sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-FISCALPERIOD sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONCHARTOFACCOUNTS sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-POSTINGLEVEL sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONGROUP sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONDOCUMENTTYPE sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-DOCUMENTITEMTEXT sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-POSTINGDATE sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CREATIONDATE sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CREATIONTIME sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-USERID sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONUNIT1 sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONUNIT2 sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-INVESTEECONSOLIDATIONUNIT sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-INVESTMENTACTIVITYTYPE sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-INVESTMENTACTIVITY sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-REFCONSOLIDATIONDOCUMENTNUMBER sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-REVERSEDDOCUMENT sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-REVERSEDOCUMENT sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONDOCREVERSALYEAR sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-ISREVERSALDOCUMENT sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-ISCONSOLIDATIONTASKTESTRUN sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONTASKCATEGORY sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONTASK sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONJRNLENTRSOURCE sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONJRNLENTRDRAFTUUID sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CNSLDTNDOCUMENTNUMBERFOREDIT sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-AMOUNTINTRANSCURRENCYISHIDDEN sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-AMOUNTINLOCALCURRENCYISHIDDEN sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-AMOUNTINGROUPCURRENCYISHIDDEN sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-QUANTITYINBASEUNITISHIDDEN sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CNSLDTNUNIT1ISUSEDISHIDDEN sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONGROUPISHIDDEN sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-PARTNERCNSLDTNUNITISHIDDEN sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONUNITISHIDDEN sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CONSOLIDATIONUNIT3ISHIDDEN sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-PARTNERCNSLDTNUNIT3ISHIDDEN sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-SUBITEMISHIDDEN sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-SUBITEMCATEGORYISHIDDEN sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-CNSLDTNGROUPJRNLENTRYBUNDLE sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-HASACTIVEENTITY sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-DRAFTENTITYCREATIONDATETIME sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-DRAFTENTITYLASTCHANGEDATETIME sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-DRAFTADMINISTRATIVEDATAUUID sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-DRAFTENTITYCONSISTENCYSTATUS sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-DRAFTENTITYOPERATIONCODE sy-vline
WA_ISCNSLDTNJRNLENTRYTP1_STR-ISACTIVEENTITY sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.