Posts

Range Table , How to create range table using and internal table SAP ABAP

Image
  Sometimes there is an issue with creating a range table and passing range selections on the screen. For this, we can create a range table.    DATA  :  s_vbeln5  TYPE  /iwbep/t_cod_select_options .   s_vbeln5  =  VALUE  # (  FOR  s_vbeln1  IN  s_vbeln[]                       LET s  =  s_vbeln1 - sign                            o  =  s_vbeln1 - option                        IN  sign  =  s                        ...

cds view with po parameters

 @AbapCatalog.sqlViewName: 'ZMY_CDS_VIEW' @AbapCatalog.compiler.compareFilter: true @EndUserText.label: 'Rohini Kumar po' define view ZMyCdsView with parameters p_erdat : aedat as select from ekko as h inner join ekpo as i on h.ebeln = i.ebeln   inner join mara as m on i.matnr = m.matnr   inner join makt as t on m.matnr = t.matnr   left outer join adr6 as a on h.lifnr = a.addrnumber {   h.ebeln,   h.aedat,   i.ebelp,   h.bukrs,   i.matnr,   i.menge,   i.netpr,   m.mtart,   t.maktx,   a.smtp_addr } where h.aedat = :p_erdat ********************************ROHINI KUMAR*********************************                                 Please support my work : sap.rohini988@gmail.com                                LinkedIn Link  :  https://www.linkedin...

CDS View from using table ekko ekpo mara and makt adr6

 @AbapCatalog.sqlViewName: 'ZMY_CDS_VIEW' @AbapCatalog.compiler.compareFilter: true @EndUserText.label: 'My CDS View' define view ZMyCdsView as select from ekko as h inner join ekpo as i on h.ebeln = i.ebeln   inner join mara as m on i.matnr = m.matnr   inner join makt as t on m.matnr = t.matnr   left outer join adr6 as a on h.lifnr = a.addrnumber {   h.ebeln,   i.ebelp,   h.bukrs,   i.matnr,   i.menge,   i.netpr,   m.mtart,   t.maktx,   a.smtp_addr } ********************************ROHINI KUMAR*********************************                                 Please support my work : sap.rohini988@gmail.com                                LinkedIn Link  :  https://www.linkedin.com/in/rohini-kumar-14647a13a/ *********************************************...

Add messages in Odata services

  *1. Instatiate the Message Container DATA: lo_message_container TYPE REF TO /iwbep/if_message_container. CALL METHOD me->/iwbep/if_mgw_conv_srv_runtime~get_message_container RECEIVING ro_message_container = lo_message_container. CALL METHOD lo_message_container->add_message EXPORTING iv_msg_type = /iwbep/cl_cos_logger=>warning iv_msg_id = 'ZTEST' iv_msg_number = '000' iv_add_to_response_header = abap_true. "add the message to the header ********************************ROHINI KUMAR*********************************                                 Please support my work : sap.rohini988@gmail.com                                LinkedIn Link  :  https://www.linkedin.com/in/rohini-kumar-14647a13a/ *...

Calling set in Program

  DATA :  t_set   TYPE  TABLE  OF  rgsb4 ,       wa_set  TYPE  rgsb4 . DATA :  v_check  TYPE  c  VALUE  ' ' . CALL  FUNCTION  'G_SET_MAINTENANCE'    EXPORTING      function       =  'MODIFY'     set_name_mask  =  '0000ZOMEGACUST'     table_mask     =  'KNA1' .  "RGSBS-TABLE. we can call set and also create T-code for set  ********************************ROHINI KUMAR*********************************                                 Please support my work : sap.rohini988@gmail.com                                LinkedIn Link  :  https://www.linkedin.com/in/r...

Backgrond job in sap abap programming Langague

 Some time requirements to post a job in the background this purpose we have to post the query    DATA :  rsparams  TYPE  TABLE  OF  rsparams  WITH  HEADER  LINE ,          number    TYPE  btcjobcnt ,         name      TYPE  btcjob .    CONCATENATE  'ZMMGATEENTRY'  sy - datum sy - uzeit    INTO  name  SEPARATED  BY  '_' .   rsparams - selname  =  'S_TRNO' .   rsparams - kind  =  'S' .   rsparams - sign  =  'I' .   rsparams - option  =  'EQ' .   rsparams - low  =  zp2pdetrno .    APPEND  rsparams .    CALL  FUNCTION  'JOB_OPEN'      EXPORTING       jobname  ...

Group by example

  CLASS lcl_class_name DEFINITION CREATE PRIVATE FINAL. PUBLIC SECTION. CLASS-METHODS: create RETURNING VALUE(ro_obj) TYPE REF TO lcl_class_name. METHODS: run. PROTECTED SECTION. PRIVATE SECTION. ENDCLASS. CLASS lcl_class_name IMPLEMENTATION. METHOD create. ro_obj = NEW lcl_class_name( ). ENDMETHOD. METHOD run. SELECT * FROM spfli INTO TABLE @DATA(lt_spfli). DATA members LIKE lt_spfli.      LOOP AT lt_spfli INTO DATA(ls_spfli) GROUP BY ( carrier = ls_spfli-carrid city_from = ls_spfli-cityfrom )     ASCENDING     ASSIGNING FIELD-SYMBOL(<lfs_group>).      CLEAR members.     LOOP AT GROUP <...