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

Former Member — Mon, 11 Mar 2013 06:05:09 GMT

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

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

Sijin_Chandran — Tue, 12 Mar 2013 06:18:13 GMT

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.

topic Re: 1-Data Modify through module pool programming ....2- Auto Serial Number in Module pool Primary Key in Application Development and Automation Discussions

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

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 .

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