topic Re: Data was not getting saved to data base ? in Application Development and Automation Discussions

Data was not getting saved to data base ?

former_member456271 — Tue, 12 Sep 2017 07:32:59 GMT

METHOD save_employee.
  DATA : gs_empl TYPE yempl_details.
   DATA : lv_success TYPE abap_bool.
 FIELD-SYMBOLS: <empl_attr_n> LIKE LINE OF gt_employee.
   lv_success = 'X'.
READ TABLE gt_employee ASSIGNING <empl_attr_n> WITH
  KEY guid = cs_key-guid
 employee_id = cs_key-employee_id.
   CHECK sy-subrc = 0.
   CASE<empl_attr_n>-new.
     WHEN 'C' OR 'M'.
     MOVE-CORRESPONDING <empl_attr_n> TO gs_empl.
       MODIFY yempl_details FROM gs_empl.
     WHEN OTHERS.
   ENDCASE.
CALL FUNCTION 'DEQUEUE_EYEMPL_DETAILS'
 EXPORTING
   mode_yempl_details       = 'E'
   client                   = sy-mandt
   guid                     =  cs_key-guid
   employee_id              = cs_key-employee_id.
   CLEAR cs_key.
ENDMETHOD.

Hello Experts,

I have requirement that in sap crm web ui, when user click on 'new' button it was navigating to create view. The mobile no field was showing initially zeros. This should not be shown so for that particular field in domain level i kept conversion exit as ALPHA and also in create method i written a statement of 'delete leading zeros'. In web ui after giving all values and clicking on save the Mobile No. field which has conversion exit and leading zero that was not getting saved into data base custom table. Insted it was saving all zeros to data base.

When i debugged the API Custom class i got to know that there was problem in save_method.

Above is method for save employee details into data base.

Here data was successfully passing to <empl_attr_n>,but only one field i,e. mobile number field which was char format is not passing not to gs_empl.
So it was not saving to data base.

Please any suggestions.

Re: Data was not getting saved to data base ?

former_member302016 — Tue, 12 Sep 2017 08:11:55 GMT

Hi Harish,

Are you creating a new record or updating a row which already exist in table.

~Vky Veera

Re: Data was not getting saved to data base ?

former_member456271 — Tue, 12 Sep 2017 08:17:36 GMT

Hello Vignesh

I am Creating new record and Even it's not working for update also.

Re: Data was not getting saved to data base ?

sivakumar_mobility — Tue, 12 Sep 2017 08:36:28 GMT

Hi Harish,

You need to convert into internal formats for particular field using FM,

CONVERSION_EXIT_ALPHA_INPUT

Re: Data was not getting saved to data base ?

former_member456271 — Tue, 12 Sep 2017 08:40:31 GMT

Hello Shiva,

Yes i used it in domain, but still not working.

And in another method i,e. create_employee i placed a statement

SHIFT lv_data-employee_pcode LEFT DELETING LEADING '0'.

because in web crm ui no zeros should be displayed initially wlile click on create button.

Even if I delete the above statement, the data was not storing to data base.

Re: Data was not getting saved to data base ?

Sandra_Rossi — Tue, 12 Sep 2017 08:44:57 GMT

Please reformat your question (take your comments and question out of the ABAP code)

Re: Data was not getting saved to data base ?

former_member456271 — Tue, 12 Sep 2017 08:53:43 GMT

Hello Sandra Ross,

Thanks for suggestion and i done what you said.

Re: Data was not getting saved to data base ?

sivakumar_mobility — Tue, 12 Sep 2017 10:28:43 GMT

MODIFY yempl_details FROM gs_empl.
if sy-subrc = 0.
commit work.
endif.

Try above. Note: By using Modify you can not insert Duplicate records. If same data exist with key ,it will not insert any new data. Check that also.

Re: Data was not getting saved to data base ?

former_member456271 — Tue, 12 Sep 2017 11:37:53 GMT

Hello Shiva,

No i didn't gave it as key.

I used two fields in web ui, one is for pin code with data type NUMC and another one is mobile no. with data type NUMC.

Here data given in pin code field is getting saved but not the mobile no.

Data base table.

Because of using NUMC in web ui we will get initially zeros.

So i used a statements in create employee as shown below.

SHIFT lv_data-employee_moblie LEFT DELETING LEADING '0'.
SHIFT lv_data-employee_pcode LEFT DELETING LEADING '0'.

Re: Data was not getting saved to data base ?

sivakumar_mobility — Tue, 12 Sep 2017 11:48:37 GMT

Hi,

I think you are passing data from some external source.

So, Please use keyword condense <fieldname> no-gaps inside the abap program.

Re: Data was not getting saved to data base ?

former_member456271 — Tue, 12 Sep 2017 13:26:27 GMT

Hello Siva,

Thanks for reply can you explain still clearly where to add above keyword.

Re: Data was not getting saved to data base ?

sivakumar_mobility — Wed, 13 Sep 2017 11:01:18 GMT

Hi Harish,

SHIFT lv_data-employee_moblie LEFT DELETING LEADING '0'.

condense lv_data-employee_moblie.

SHIFT lv_data-employee_pcode LEFT DELETING LEADING '0'.

condense lv_data-employee_moblie.

You can do in final work area field .