ABAP EML READ ENTITY, ENTITIES, ASSOCIATIONS IN RAP

ABAP EML READ ENTITY, ENTITIES:

  • Used to perform read-only operations on RAP BO instances. 

----------------------------------------------Read entity---------------------------------------

READ ENTITY

  • Reads single instances by their keys.

            READ ENTITY <EntityName>
              FROM VALUE #( ( %keys ) )
              RESULT <result_table>
              FAILED DATA(<Failed table name>)
              REPORTED DATA(< Reported table name>).
Example:
    
Fetching the above record.
CLASS zcl_ab_eml_crea DEFINITION

PUBLIC

FINAL

CREATE PUBLIC .


PUBLIC SECTION.

INTERFACES if_oo_adt_classrun.

PROTECTED SECTION.

PRIVATE SECTION.

ENDCLASS.


CLASS zcl_ab_eml_crea IMPLEMENTATION.

METHOD if_oo_adt_classrun~main.

DATA: lt_students TYPE TABLE FOR CREATE ziv_ab_hdr_stu13 .

READ ENTITY ziv_ab_hdr_stu13

FROM VALUE #( ( %tky-StuId = '0EA662BBBE9E1FE097B4EF47C07168A9'

%control = VALUE #(

StuName = if_abap_behv=>mk-on

StuAge = if_abap_behv=>mk-on

StuCourse = if_abap_behv=>mk-on

StuCourDur = if_abap_behv=>mk-on

StuStatus = if_abap_behv=>mk-on

StuGender = if_abap_behv=>mk-on

StuDob = if_abap_behv=>mk-on

) ) )

RESULT DATA(lt_data)

FAILED DATA(lt_failed)

REPORTED DATA(lt_reported).

IF lt_failed IS INITIAL.

out->write( EXPORTING data = lt_data ).

ENDIF.


ENDMETHOD.

ENDCLASS.


Output


------------------------------------------------End of Read entity-------------------------------------

------------------------------------------------ Read entities------------------------------------------

READ ENTITIES

  • Reads multiple instances by their keys.
  • Can also read associated data (like to_Items).

        READ ENTITIES OF <RootEntityName>
          ENTITY <EntityName>
          ALL FIELDS
          WITH CORRESPONDING #( <keys_table> )
          RESULT <result_table>
          FAILED DATA(<Failed table name>)
          REPORTED DATA(< Reported table name>).

Example:

Fetching the above record.

CLASS zcl_ab_eml_crea DEFINITION

PUBLIC

FINAL

CREATE PUBLIC .


PUBLIC SECTION.

INTERFACES if_oo_adt_classrun.

PROTECTED SECTION.

PRIVATE SECTION.

ENDCLASS.



CLASS zcl_ab_eml_crea IMPLEMENTATION.

METHOD if_oo_adt_classrun~main.

DATA: lt_students TYPE TABLE FOR CREATE ziv_ab_hdr_stu13,

lt_keys TYPE TABLE FOR READ RESULT ziv_ab_hdr_stu13.


lt_keys = VALUE #( ( StuId = '0EA662BBBE9E1FE097B4EF47C07168A9' )

                       ( StuId = '0EA662BBBE9E1FE097B53C800EB768A9' ) ).

READ ENTITIES OF ziv_ab_hdr_stu13

ENTITY Student

ALL FIELDS WITH CORRESPONDING #( lt_keys )

RESULT DATA(lt_data)

FAILED DATA(lt_failed)

REPORTED DATA(lt_reported).

IF lt_failed IS INITIAL.

out->write( EXPORTING data = lt_data ).

ENDIF.

ENDMETHOD.

ENDCLASS.


Output:

-----------------------------------------------End of Read entities--------------------------------------

--------------------------------------------Read Associations-----------------------------------------

READ_ASSOCIATIONS

        READ ENTITIES OF <BOName>

          ENTITY <ParentEntity>

          BY ASSOCIATION <association_name>

          WITH CORRESPONDING #( <keys_table> )

          RESULT <result_table>

          FAILED DATA(<Failed table name>)

          REPORTED DATA(< Reported table name>).

Example(READ BOTH HEADER AND ITEM):

Fetching the above record.

CLASS zcl_ab_eml_crea DEFINITION

PUBLIC

FINAL

CREATE PUBLIC .


PUBLIC SECTION.

INTERFACES if_oo_adt_classrun.

PROTECTED SECTION.

PRIVATE SECTION.

ENDCLASS.



CLASS zcl_ab_eml_crea IMPLEMENTATION.

METHOD if_oo_adt_classrun~main.

DATA: lt_keys TYPE TABLE FOR READ RESULT ziv_ab_hdr_stu13.

lt_keys = VALUE #( ( StuId = '0EA662BBBE9E1FE097BDAE8EDE7348A9' ) )."( StuId = '0EA662BBBE9E1FE097B53C800EB768A9' ) ).


READ ENTITIES OF ziv_ab_hdr_stu13

ENTITY Student

ALL FIELDS WITH CORRESPONDING #( lt_keys )

RESULT DATA(lt_data)


ENTITY Student BY \_attach

ALL FIELDS WITH CORRESPONDING #( lt_keys )

RESULT data(lt_data1)

FAILED DATA(lt_failed)

REPORTED DATA(lt_reported).


IF lt_failed IS INITIAL.

out->write( EXPORTING data = lt_data ).

out->write( EXPORTING data = lt_data1 ).

ENDIF.

ENDMETHOD.

ENDCLASS.

Output(BOTH HEADER AND ITEM):


Example (READ ITEM only)

CLASS zcl_ab_eml_crea DEFINITION

PUBLIC

FINAL

CREATE PUBLIC .


PUBLIC SECTION.

INTERFACES if_oo_adt_classrun.

PROTECTED SECTION.

PRIVATE SECTION.

ENDCLASS.


CLASS zcl_ab_eml_crea IMPLEMENTATION.

METHOD if_oo_adt_classrun~main.

DATA: lt_keys TYPE TABLE FOR READ RESULT ziv_ab_hdr_stu13.

lt_keys = VALUE #( ( StuId = '0EA662BBBE9E1FE097BDAE8EDE7348A9' ) ).

READ ENTITIES OF ziv_ab_hdr_stu13

ENTITY Student BY \_attach

ALL FIELDS WITH CORRESPONDING #( lt_keys )

RESULT DATA(lt_data)

FAILED DATA(lt_failed)

REPORTED DATA(lt_reported).


IF lt_failed IS INITIAL.

out->write( EXPORTING data = lt_data ).

ENDIF.

ENDMETHOD.

ENDCLASS.


Output (ITEM only)

-------------------------------------------End of Read Association------------------------------------------


******************************Thank you***************************

Comments

Post a Comment

Popular posts from this blog

New syntax for append- VALUE (new syntax 7.4+) in ABAP

Image
* We use APPEND statement to insert the records at the last of the internal table. * In SAP ABAP new syntax, we can use VALUE expression instead of APPEND statement. * Value expression is a powerful mechanism to declare as well as initialize the internal tables. * It is a powerful utility where we can achieve the result with minimal coding. * Value expression is of 2 types.      -  Define the type before using it with VALUE keyword. The type defined is structure type  or table type.      -  Using # character for type and use it with VALUE keyword. Report REPORT  zab_rp_append_value . TYPES :  BEGIN  OF  ls_stu ,          st_id ( 10 )    TYPE  n ,          st_name ( 15 )  TYPE  c ,         END  OF  ls_stu . DATA :  lt_stu  TYPE  TABLE...
Read more

Read statement new syntax in ABAP. (7.4+).

Image
*  Before ABAP 7.4, we used READ TABLE statement to read the first matching record from the internal table  based upon key or index . * In SAP ABAP new syntax, instead of READ TABLE , we can use the table expressions. * We need to use the square bracket [ ], In the square bracket, we need to specify the key or index. * While using table expression, If the table entry does not exist, system throws the exception CX_SY_ITAB_LINE_NOT_FOUND. * Use line_exists statement to check the existence of a record. Report REPORT  zab_rp_read_new . TABLES :   vbak . SELECT-OPTIONS :   s_vbeln  FOR  vbak - vbeln . SELECT  vbeln , erdat , erzet , ernam , auart         FROM  vbak         INTO  TABLE  @DATA ( lt_vbak )          WHERE  vbeln  IN  @s_vbeln . WRITE :   'Index value'  COLOR  5 . READ  T...
Read more

Concatenation new syntax( 7.4+ ).

Image
  Report REPORT  zab_rp_concat_7_4 . DATA :   lv_str1    TYPE  string  VALUE  'ajay' ,       lv_str2    TYPE  string  VALUE  'babu' ,       lv_str3    TYPE  string  VALUE  'varikallu' ,       lv_final1  TYPE  string ,       lv_final2  TYPE  string . CONCATENATE  lv_str1 lv_str2 lv_str3  INTO  lv_final1  SEPARATED  BY  space . WRITE :   /  'Old syntax: '  ,  lv_final1  COLOR  4 . lv_final2  =  | { lv_str1 } { lv_str2 } { lv_str3 } | . WRITE :   /  'New syntax: '  ,  lv_final2  COLOR  5 . Output ****** *********** ******** Thank You ****** ******* *********
Read more