Posts

Showing posts from January, 2019

get address Detail Passing address Number

   CALL  FUNCTION  'ADDR_SELECT_ADRC_SINGLE'      EXPORTING       addrnumber         =  address_number      TABLES       et_adrc            =  xadrc      EXCEPTIONS       address_not_exist  =  1       parameter_error    =  2       internal_error     =  3        OTHERS             =  4 .

UseFull URL AND Reports Code in Smart forms

1. Open smartforms to word editor window: http://abaper-notes.blogspot.com/2018/01/turn-on-default-ms-word-editor-in.html 2. Long Test Program ## cumming in smartform print https://rkmsap.blogspot.com/2018/12/long-text-problems-and-problems-how-to.html Error Messages in Odata Services Send Mail as attachment sending mail Function Module sent mail as attachments    Get address Detail Passing address Number

Fetching purchase document header data and item data with CDS view with parameters

Below code help you to fething records with two table header and item data @AbapCatalog.sqlViewName: 'zekko_ekpo1' @AbapCatalog.compiler.compareFilter: true @AccessControl.authorizationCheck: #CHECK @EndUserText.label: 'CDS View with parameters' define view ZEKKO_EKPO     with parameters p_ebeln_low : ebeln ,                     p_ebeln_high : ebeln as select from ekko            join ekpo on ekko . ebeln = ekpo . ebeln {                       ekko . ebeln as purachsing_docu ,            ekko . ebeln ,            ekko . ernam ,            ekpo . ebelp ,            ekpo . aedat ,            ekpo . meins            }            where ekko . ebeln = : p_ebeln_low or ekko . ebeln between : p_ebeln_low                                                        and : p_ebeln_high ;

AMDP Methods for creating SQL Programming language

CLASS ZTEST_CALLS DEFINITION public. simpel amdp program we feths the records for mata table PUBLIC SECTION. types : tt_mara type table of mara. interfaces : if_amdp_marker_hdb. methods : my_method importing value(im_matnr) type mara-matnr exporting value(et_mara) type tt_mara. ENDCLASS. CLASS ZTEST_CALLS IMPLEMENTATION. method my_method by database procedure for HDB language sqlscript options read-only using MARA. et_mara=SELECT * from MARA where MATNR= IM_MATNR; endmethod. ENDCLASS.

try and catch methods in oo abap code

METHOD  materialset_create_entity .    DATA :  ls_request_input_data  TYPE  zcl_zmk_crude_mpc => ts_material .    DATA :  gs_table  TYPE  zcust_report . *        ls_userinfo TYPE zuserinfo. * Read Request Data * *    io_data_provider->read_entry_data( IMPORTING es_data = is_request_input_data ). * Fill workarea to be inserted    TRY .       io_data_provider -> read_entry_data (  IMPORTING  es_data  =  ls_request_input_data  ) .       gs_table - zzcust_no  =  ls_request_input_data - zzcust_no .       gs_table - zdno       =  ls_request_input_data - zdno .       gs_table - zcust_loc  =  ls_request_input_data - zcust_loc .       gs_table - zmatnum    =  ls_request_input_data - zmatnum .       gs_table - zmatdesc   =  ls_request_input_data - zmatdesc .       gs_table - ztbtln     =  ls_request_input_data - ztbtln .       gs_table - zdefct     =  ls_request_input_data - zdefct .       gs_table - zlinef     =  ls_request_input_data - zlinef .       gs_table