1-Data Modify through module pool programming ....2- Auto Serial Number in Module pool Primary Key

[Former Member]

1-hi

I want to Modify the data  into the Z  data base through module pool programming. I am taking the fields  Primary  key   from Z table , of behalf of primary . I want to modify data  , I need sample code ,please help me

2- Hi ,  in module programming  I want want to SR. no is generated automatic in z table with all recodes  when we press SAVE button in module pool screen .

, I need sample code ,please help me

thanx

puneet

[Sijin_Chandran]

Hi Puneet ,

Regarding your first query do a bit of search on UPDATE and MODIFY command .

Take all your screen field's values in a Work Area ( fill respective fields ) of same type as that of table to be updated. And after that Call UPDATE or MODIFY table.

Now your second query .

I guess there may be  more than one technique to accomplish that task.

For eg ,

Use SELECT MAX statement to select the current entry of your SR No. and after that add 1 to get the next SR No.

eg :

IF VAR_REFSERVICEID  IS INITIAL.
               SELECT MAX( SERVICEID ) FROM ZSERVICEDET INTO TEMP_SERVICEID WHERE CUSTID = VAR_CUSTID
                                                                              AND DEVID  = VAR_DEVID.
               ZSERVICEDET-SERVICEID   = TEMP_SERVICEID + 1.
               ZSERVICEDET-CUSTID      = VAR_CUSTID.