topic Re: dialog program in Application Development and Automation Discussions

dialog program

Former Member — Fri, 01 Feb 2008 05:59:53 GMT

Hi,

I am working on a module pool program.I have created ascreen 2000 in which there are many fields taken from mvke,mara and marc.If the user wants to change values of some fields in the o/p in this screen,then he can change the values using the dropdown list and when he clicks on the chechbox besides that field,then the changed value should get stored in that particular table from where the field is taken.

How can i capture only checked fields and how can i store the

changed values in the table?

Can anyone help me solve this problem.Its very urgent!!

Regards,

Radha

Re: dialog program

Former Member — Fri, 01 Feb 2008 06:15:14 GMT

Hi Radha,

Once the user changes the values just check them against the values in table ,

if not same then using update Query update that entry in table.

Regards,

Vaibhav Modi.

******Reward Useful Replies.

Re: dialog program

Former Member — Fri, 01 Feb 2008 06:20:47 GMT

hi,

in ur top include give the sanme name to the check box as u have given in screen.

suppose ur check box name in screen is c1 for matnr from mara.

and u have named i/o field as fmatnr in screen.

then in ur top include.

data c1 type c,

fmatnr type mara-matnr.

in ur main program.

in pai module.

if c1 = 'X'.

then update ur database table.

update mara set matnr = fmatnr.

like this u can code for other fields also.

hope it is clear now.

Re: dialog program

Former Member — Fri, 01 Feb 2008 06:21:27 GMT

Can we use set parameter id for updating the changed values in the table

Re: dialog program

Former Member — Fri, 01 Feb 2008 06:23:17 GMT

set parameter id will store the value entered in the screen in sap memory .it will not update the database table automatically.

Re: dialog program

Former Member — Fri, 01 Feb 2008 06:29:54 GMT

Hi,

From your screen program

PROCESS AFTER INPUT.

*&SPWIZARD: PAI FLOW LOGIC FOR TABLECONTROL 'TC_B'

LOOP AT T_DISP.

CHAIN.

FIELD WA_DISP-CHKBOX MODULE CHKBOX.

FIELD WA_DISP-SNO.
FIELD WA_DISP-NAME.
FIELD WA_DISP-SELNM.
FIELD WA_DISP-PRICE.
FIELD WA_DISP-CONDN.

endchain.

ENDLOOP.

&----

*& Module CHKBOX INPUT

&----

text

----

MODULE CHKBOX INPUT.

MOVE-CORRESPONDING TC_B TO WA_DISP.

MODIFY T_DISP FROM WA_DISP INDEX TC_B-CURRENT_LINE.

READ TABLE T_DISP INTO WA_DISP WITH KEY CHKBOX = C_X. " index TC_B-CURRENT_LINE.

ENDMODULE. " CHKBOX INPUT

Then read the internal table

LOOP AT T_DISP INTO WA_DISP WHERE CHKBOX EQ C_X.

MODIFY ****************

ENDLOOP.

If it solve ur problem , Please award points.

Re: dialog program

Former Member — Fri, 01 Feb 2008 06:31:43 GMT

Set Parameter ID will store the values in the SAP memory and not in the ABAP memory. Please correct me if I am wrong.

Now if you are trying to update the databse tables you can use the statement such as UPDATE or MODIFY.

Re: dialog program

Former Member — Fri, 01 Feb 2008 06:32:29 GMT

Hi Radha,

U just use CASE statement or IF statements......

IF check1 = 'x'.

Update table tablename ......where fieldname = dd1.

dd1 is the dropdown list variable.

dd1 holds the value the user has changed.

I think this will work.....

Dont forget to reward points if useful.

Pavan.

Re: dialog program

Former Member — Fri, 01 Feb 2008 06:53:18 GMT

Hi Kamini,

I have declared all my checkboxes in my top include.

For example: I have given one of my checkbox name as DCHAIN_SPEC in the attributes window for screen 2000.

I have declared this as

Data: DCHAIN_SPEC TYPE C.

I am getting error as 'Field DCHAIN_SPEC is not defined.It is neither specified in one of the tables nor defined by a data statement'.

What would be the reason for this?

Regards,

Radha

Re: dialog program

Former Member — Fri, 01 Feb 2008 06:57:51 GMT

did u activate ur top include?

may be u have declared and saved .

and as u did not activate the top include ,it will give error when u perform syntax check on ur main program.

Re: dialog program

Former Member — Fri, 01 Feb 2008 07:01:52 GMT

hI,

There is no seperate top include.All the declaration is done in the main program itself.I have activated it.But still it is giving error

Re: dialog program

Former Member — Fri, 01 Feb 2008 07:04:19 GMT

Hi,

How can I assign a value to drop down list in the attribute window of the screen painter?

Re: dialog program

Former Member — Fri, 01 Feb 2008 07:08:57 GMT

to assign values in the drop down list.

u have to code in main program.

use type pools vrm.

copy this into a report program.and debug.

u will get an idea.

PARAMETERS P_PLANT TYPE STR AS LISTBOX VISIBLE LENGTH 10.

TYPE-POOLS: VRM.

DATA: T_PLANT type vrm_values.

INITIALIZATION.

APPEND '1000' TO T_PLANT.

APPEND '3200' TO T_PLANT.

CALL FUNCTION 'VRM_SET_VALUES'

EXPORTING

id = 'P_PLANT'

values = T_PLANT.

Re: dialog program

Former Member — Fri, 01 Feb 2008 07:12:36 GMT

Hi Kamini,

The values in the droplist are automatically coming in the o/p.

My doubt is,How can we know only the checked field and only the changed value will get updated in the database?

Re: dialog program

Former Member — Fri, 01 Feb 2008 08:42:15 GMT

Hi,

see suppose in ur screen :

field1 ________ |_| checkbox1.

field2 ________ |_| checkbox2.

in main program.

when u write

if checkbox1 = 'X'.

update <dbtab> set <field > = field1.

endif.

similarly for other fields.

"this statement will update the database table field with the value in field1. if checkbox1 is ticked.

whenever user checks the box the variable for checkbox (here checkbox1) will store the value X.

hope i made this clear.

Re: dialog program

Former Member — Fri, 01 Feb 2008 09:47:50 GMT

Hi,

Now the values are getting updated into the table.But if i check 2 or checkboxes and click on the execute button all the changed values should get updated into tables.But this is not happening.Only the first checked field value is getting uploaded into table.

Re: dialog program

Former Member — Fri, 01 Feb 2008 09:55:56 GMT

do like this

if c1 = 'X'.

update....

endif.

if c2 = 'X'.

update..

endif.

if u have included update statements in if....elseif...endif.

statements then it will execute only the first true condition.

Re: dialog program

Former Member — Fri, 01 Feb 2008 10:14:48 GMT

Hi,

Now the values are getting updated into the table.But if i check 2 or 3 checkboxes and click on the execute button all the changed values in all the checked fields should get updated into tables.But this is not happening.Only the first checked field value is getting uploaded into table.

Re: dialog program

Former Member — Fri, 01 Feb 2008 11:43:24 GMT

hi,

i think u have coded the full logic for all checkboxes in one if else.

u should have separate if for all checkboxes.

if c1 = 'X'.

text = 'check1'.

endif.

if c2 = 'X'.

text = 'check2'.

endif.

if c3 = 'X'.

text = 'check3'.

endif.

i executed a sample program for this and it was working fine.

u try debugging ur code and put a breakpoint where u are checking the values of checkboxes.

and see if the value of the check box is X then is it going inside that if stament or not.

i hope u understood the concept.

Regards,

Kamini

Re: dialog program

Former Member — Fri, 01 Feb 2008 12:30:38 GMT

Hi Kamini,

Thank you very much.

Now all the field values changed in the update screen and which are checked are getting updated in the database table.

But actually there is an o/p screen in which there are many records.If the user wants to change the values of a particular record,then he clicks on the checkbox placed besides that record and clicks on the execute button.Then the control goes to the update screen2000.

Here the changed values are getting updated in the database table.But the values are getting updated in all the records along with the record selected in the o/p screen.This should not happen.Only the selected record should get updated with the changed value.

How can this happen?