Posts

Modify operation Code

  CLASS ycl_modify_practice DEFINITION PUBLIC FINAL CREATE PUBLIC . PUBLIC SECTION. INTERFACES if_oo_adt_classrun . PROTECTED SECTION. PRIVATE SECTION. ENDCLASS. CLASS ycl_modify_practice IMPLEMENTATION. METHOD if_oo_adt_classrun ~ main . *MODIFY ENTITY, ENTITIES, field_spec *1->... { FROM fields_tab } * CREATE, CREATE BY, UP☺DATE, DELETE, EXECUTE * For DELETE, EXECUTE we can use this option only * The %control structure must be filled explicitly in the internal table fields_tab for CREATE, CREATE BY and UPDATE * DATA : lt_book TYPE TABLE FOR CREATE yi_travel_tech_m\_Booking. * MODIFY ENTITY yi_travel_tech_m * CREATE FROM VALUE #( * ( % cid = 'cid1' * %data-BeginDate = '20240225' * %control-BeginDate = if_abap_behv=>mk-on * * ) ) * CREATE BY \_Booking * FROM VALUE #( ( %cid_ref = 'cid1' * %target = VALUE #( ( % cid = ...
Post a Comment
Read more

Read Operation with behavior definition language (BDL) RAP Sample Code

 Read Operation code:-  CLASS ycl_read_ptactice DEFINITION PUBLIC FINAL CREATE PUBLIC . PUBLIC SECTION. INTERFACES if_oo_adt_classrun . PROTECTED SECTION. PRIVATE SECTION. ENDCLASS. CLASS ycl_read_ptactice IMPLEMENTATION. METHOD if_oo_adt_classrun ~ main . *sort form read * READ ENTITY yi_travel_tech_m * FROM VALUE #( ( %key-TravelId = '0000004172' * %control = VALUE #( AgencyId = if_abap_behv=>mk-on * CUSTOMERID = if_abap_behv=>mk-on * BEGINDATE = if_abap_behv=>mk-on * ) * * ) * ) * RESULT DATA(lt_result_short) * FAILED DATA(lt_failed_sort). * * IF lt_failed_sort IS NOT INITIAL. * out->write( 'Read failed' ). * * ELSE. * out->write( lt_result_short ). * ENDIF. * READ ENTITY yi_travel_tech_m * by \_Booking * ALL FIELDS...
Post a Comment
Read more

Backup all ADT Objects & Other queries RAP Part 10.1

CLASS zcl_DATA_GENERATOR DEFINITION PUBLIC FINAL CREATE PUBLIC . PUBLIC SECTION. INTERFACES: if_oo_adt_classrun . PROTECTED SECTION. PRIVATE SECTION. ENDCLASS . CLASS zcl_DATA_GENERATOR IMPLEMENTATION. METHOD if_oo_adt_classrun ~ main . " delete existing entries in the database table DELETE FROM ztravel_tech_m . DELETE FROM zBOOKING_tech_m . DELETE FROM zbooksupp_tech_m . COMMIT WORK. " insert travel demo data INSERT ztravel_tech_m FROM ( SELECT * FROM /dmo/travel_m ). COMMIT WORK. " insert booking demo data INSERT zbooking_tech_m FROM ( SELECT * FROM /dmo/booking_m * JOIN ztravel_tech_m AS z * ON booking~travel_id = z~travel_id ). COMMIT WORK. INSERT zbooksupp_tech_m FROM ( SELECT * FROM /dmo/booksuppl_m * JOIN ztravel_tech_m AS z * ON booking~travel_id = z~travel_id ). ...
Post a Comment
Read more

Calling CDS in AMDP Part -3

Image
CLASS zcl_amdp_client DEFINITION PUBLIC FINAL CREATE PUBLIC . PUBLIC SECTION. INTERFACES if_amdp_marker_hdb . TYPES : tt_zcds_sample_01 TYPE TABLE OF zvsql_sample_01 . CLASS-METHODS get_data_cds AMDP OPTIONS CDS SESSION CLIENT iv_clnt IMPORTING VALUE( iv_clnt ) TYPE sy - mandt EXPORTING VALUE( et_so ) TYPE tt_zcds_sample_01 . PROTECTED SECTION. PRIVATE SECTION. ENDCLASS . CLASS zcl_amdp_client IMPLEMENTATION. METHOD get_data_cds BY DATABASE PROCEDURE FOR HDB LANGUAGE SQLSCRIPT USING zcds_sample_01 . et_so = select * from zcds_sample_01 WHERE mandt = : iv_clnt ; * Where mandt = session_context( 'CDS_CLIENT' ); ENDMETHOD. ENDCLASS. ********************************************************************** ********************************************************************** *AMDP does not support implicit clie...
Post a Comment
Read more

AMDP ( ABAP Managed Database Procedure ) Part - 1

Image
CLASS zcl_amdp_class DEFINITION PUBLIC FINAL CREATE PUBLIC . PUBLIC SECTION. INTERFACES if_amdp_marker_hdb . TYPES: BEGIN OF ty_cust , cust_name TYPE kna1 - name1 , netwr TYPE vbak - netwr , END OF ty_cust , tt_cust TYPE TABLE OF ty_cust . TYPES: BEGIN OF session_variables , client TYPE sy - mandt , cds_client TYPE sy - mandt , uname TYPE sy - uname , langu TYPE sy - langu , datum TYPE sy - datum , END OF session_variables . CLASS-METHODS get_session_variables_amdp AMDP OPTIONS READ-ONLY CDS SESSION CLIENT iv_clnt IMPORTING VALUE( iv_clnt ) TYPE sy - mandt EXPORTING VALUE( clnt ) TYPE session_variables - client VALUE( cds_clnt ) TYPE session_variables - cds_client VALUE( unam ) TYPE session_variables - uname VALUE( lang ) TYPE session_variables - langu ...
2 comments
Read more

From CDS View to OData Service: Simplifying the Process Part 23

Image
CRUD:- Create Read Update Delete Read -     /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet + GET =>  employeeset_get_entityset.     /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet(2) + GET => EMPLOYEESET_GET_ENTITY Create :-     /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet + POST + Payload => employeeset_create_entity Update     /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet(6) + PUT + Payload  => 'EMPLOYEESET_UPDATE_ENTITY'  Delete    /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet(6) + DELETE => 'EMPLOYEESET_DELETE_ENTITY'  ************************************************************************************************************ Access data through navigation    /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders('4969')/Items    /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderItems => salesorderitems_get_entityset Read with navigation path /sap/opu/odata/sap/Z...
Post a Comment
Read more

How To Master Media Handling with SAP OData Part 20

Image
Code detail :-  class ZCL_ZMEDIA_MPC_EXT definition public inheriting from ZCL_ZMEDIA_MPC create public . public section. METHODS: define REDEFINITION. protected section. private section. ENDCLASS . CLASS ZCL_ZMEDIA_MPC_EXT IMPLEMENTATION. METHOD DEFINE . super -> define ( ). * CATCH / iwbep /cx_mgw_med_exception. model -> get_entity_type ( iv_entity_name = 'Media' )-> get_property ( iv_property_name = 'Mimetype' )-> set_as_content_type ( ). * CATCH / iwbep /cx_mgw_med_exception.. * CATCH / iwbep /cx_mgw_med_exception.. * CATCH / iwbep /cx_mgw_med_exception. ENDMETHOD. ENDCLASS. ************************************************************** CLASS zcl_zmedia_dpc_ext DEFINITION PUBLIC INHERITING FROM zcl_zmedia_dpc CREATE PUBLIC . PUBLIC SECTION. METHODS : /iwbep/if_mgw_appl_srv_runtime ~ create_stream REDEFINITION. METHODS : /iwbep/if_mgw_appl_srv_runtime ~ get_stream REDEFINITION. METHODS :...
1 comment
Read more