{"id":7742,"date":"2025-09-03T01:20:01","date_gmt":"2025-09-02T19:50:01","guid":{"rendered":"https:\/\/www.sapewmhelp.com\/?question=what-is-eml-in-sap-rap"},"modified":"2025-09-03T01:20:01","modified_gmt":"2025-09-02T19:50:01","slug":"what-is-eml-in-sap-rap","status":"publish","type":"question","link":"https:\/\/www.sapewmhelp.com\/?question=what-is-eml-in-sap-rap","title":{"rendered":"What is EML in SAP RAP?"},"content":{"rendered":"

EML (Entity Manipulation Language<\/strong>) is a standardized way to interact with RAP business objects<\/strong> (BOs).
Instead of directly updating database tables, you manipulate entities of a business object<\/strong> using EML statements.<\/p>\n

It\u2019s similar to SQL but tailored for RAP-managed business objects (like CDS-based BOs).<\/p>\n<\/p>\n

Common EML Statements<\/h6>\n

You can use EML to perform:<\/p>\n

    \n
  • READ<\/strong> \u2192 retrieve data from BO entities<\/li>\n
  • CREATE<\/strong> \u2192 create new instances<\/li>\n
  • UPDATE<\/strong> \u2192 change existing instances<\/li>\n
  • DELETE<\/strong> \u2192 delete instances<\/li>\n
  • ACTION<\/strong> \u2192 call business actions<\/li>\n
  • FUNCTION<\/strong> \u2192 call determinations\/validations indirectly<\/li>\n<\/ul>\n

    Syntax Examples<\/strong><\/p>\n

    1. Read<\/strong><\/p>\n

    READ ENTITIES OF zi_travel
    \nENTITY travel
    \nFIELDS ( travel_id agency_id status )
    \nWITH VALUE #( ( travel_id = ‘0001’ ) )
    \nRESULT DATA(lt_travel).<\/p>\n

     <\/p>\n

    2. Create<\/strong><\/p>\n

    MODIFY ENTITIES OF zi_travel
    \nENTITY travel
    \nCREATE
    \nFIELDS ( travel_id agency_id customer_id )
    \nWITH VALUE #( ( travel_id = ‘1001’ agency_id = ‘7000’ customer_id = ‘C01’ ) )
    \nFAILED DATA(ls_failed)
    \nREPORTED DATA(ls_reported).<\/p>\n

     <\/p>\n

    3. Update<\/strong><\/p>\n

    MODIFY ENTITIES OF zi_travel
    \nENTITY travel
    \nUPDATE
    \nFIELDS ( status )
    \nWITH VALUE #( ( travel_id = ‘1001’ status = ‘X’ ) )
    \nFAILED DATA(ls_failed)
    \nREPORTED DATA(ls_reported).<\/p>\n

    4. Delete<\/strong><\/p>\n

    MODIFY ENTITIES OF zi_travel
    \nENTITY travel
    \nDELETE
    \nFROM VALUE #( ( travel_id = ‘1001’ ) )
    \nFAILED DATA(ls_failed)
    \nREPORTED DATA(ls_reported).<\/p>\n

    5. Action Execution<\/strong><\/p>\n

    MODIFY ENTITIES OF zi_travel
    \nENTITY travel
    \nEXECUTE action confirm
    \nFROM VALUE #( ( travel_id = ‘1001’ ) )
    \nFAILED DATA(ls_failed)
    \nREPORTED DATA(ls_reported).<\/p>\n

     <\/p>\n

    Key Points<\/h6>\n
      \n
    • \n

      Always executed against business objects (BOs)<\/strong>, not database tables.<\/p>\n<\/li>\n

    • \n

      Works inside ABAP classes (behavior implementations, service consumption, or test code)<\/strong>.<\/p>\n<\/li>\n

    • \n

      Returns:<\/p>\n

        \n
      • RESULT<\/strong> \u2192 successful data<\/li>\n
      • FAILED<\/strong> \u2192 failed instances<\/li>\n
      • REPORTED<\/strong> \u2192 messages\/warnings<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","question-category":[175],"question_tags":[201,200,177],"class_list":["post-7742","question","type-question","status-publish","hentry","question-category-rap","question_tags-btp","question_tags-rap","question_tags-sap"],"_links":{"self":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/question\/7742","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/question"}],"about":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7742"}],"wp:attachment":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7742"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fquestion-category&post=7742"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fquestion_tags&post=7742"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}