topic Re: Problem in table control wizard in module pool programming in Application Development and Automation Discussions

Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 09:14:39 GMT

Hi All,

i have created a Screen having two subscreens, one having a table control wizards, whenever user puts any entries in it and presses enter button, it is creating a blank lines before that line, i need to stop it as i wants that when user enters any values in the table fields, and presses ENTER button, it should not create a blank line.

I am doing some stuffs in PAI , but not getting desired result, please tell me where should i code for the desired result. Here is the code of my PAI of that subscreen.

PROCESS AFTER INPUT.

LOOP AT G_ZTBC_2014_ITAB.
     CHAIN.
       FIELD ZPAYMENTS1-SNO.
       FIELD ZPAYMENTS1-CDATE.
       FIELD ZPAYMENTS1-CHEKNO.
       FIELD ZPAYMENTS1-AMOUNT.
       FIELD ZPAYMENTS1-BANKKEY.

       MODULE ZTBC_2014_MODIFY ON CHAIN-REQUEST.
     ENDCHAIN.

   ENDLOOP.

One more problem what i am getting is that i have a drop down list which i have called from VRM_SET_VALUES, it has two values to be displayed, but each time i am using it, it increases my list , but it should be only two always, please tell me what can i do. My code is

MODULE DISPLAY_LIST OUTPUT.
   wa_values-key = '1'.
   wa_values-text = 'Direct'.
   APPEND wa_values TO i_values.

   wa_values-key = '2'.
   wa_values-text = 'Indirect'.
   APPEND wa_values TO i_values.

id_name = 'ZSDPROJECT1-TYPE'.
   CALL FUNCTION 'VRM_SET_VALUES'
     EXPORTING
       ID              = id_name
       VALUES          = i_values
     EXCEPTIONS
       ID_ILLEGAL_NAME = 1
       OTHERS          = 2.
   IF SY-SUBRC <> 0.
* Implement suitable error handling here
   ENDIF.

ENDMODULE.

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 09:21:40 GMT

Shweta,

MODULE ZTBC_2014_MODIFY ON CHAIN-REQUEST.

in module one append line.

comment that and check.

Regrding drop down list,

http://scn.sap.com/thread/1960601

regards,

Sandeep.

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 09:31:34 GMT

Hi ,

if i will comment the module ztbc_2014_modify on chain-request, it will disappeared the values entered on the screen-field, i am not getting your points, please clear it.

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 09:35:36 GMT

double click on that module.

then inside that one append line , comment that line.

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 09:38:09 GMT

hi shweta,

your first query need more information to understand..

as per your second query kindly clear the work area.. or I Would suggest to use your fix value for drop down in the domain (value range) level.

hope it will help

regards,

vikas

Re: Problem in table control wizard in module pool programming

hiriyappa_myageri — Mon, 07 Jul 2014 09:44:15 GMT

Hi Sweatha,

use .

if i_values[] is initial .

start append the i_values.

endif.

this code will reduce increasing entries in list box.

for second thing u should debug the logic written by the standard code.

Regards,

Hiriyappa

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 09:53:09 GMT

Hi Sandeep,

i have already changes my code in that , please look at this code

MODULE ZTBC_2014_MODIFY INPUT.
   MOVE-CORRESPONDING ZPAYMENTS1 TO G_ZTBC_2014_WA.
* MODIFY G_ZTBC_2014_ITAB
*    FROM G_ZTBC_2014_WA
*    INDEX ZTBC_2014-CURRENT_LINE.

APPEND G_ZTBC_2014_WA TO G_ZTBC_2014_ITAB.
CLEAR : G_ZTBC_2014_WA.
ENDMODULE.

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 09:57:36 GMT

Hi Vikas,

when i cleared the work area nothing changes.

i have fixed two values to show in output as Direct and Indirect, and for the same i have written the above mentioned code, but it repeats the values.

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 10:03:07 GMT

1st thing is dont press each and every cell enter button, last cell press only.

and when you press save button that time use delete query to delete blank line from internal table.

Regards,

Sandeep

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 10:08:56 GMT

Hi,

Instead of clearing work area, refresh value table i,e

MODULE DISPLAY_LIST OUTPUT.

Refresh i_values[].

....

Regards

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 10:09:33 GMT

your second query,

add this line to start.

REFRESH Table_name .

MODULE DISPLAY_LIST OUTPUT.

REFRESH i_values.

wa_values-key = '1'.

wa_values-text = 'Direct'.

APPEND wa_values TO i_values.

wa_values-key = '2'.

wa_values-text = 'Indirect'.

APPEND wa_values TO i_values.

id_name = 'ZSDPROJECT1-TYPE'.

CALL FUNCTION 'VRM_SET_VALUES'

EXPORTING

ID = id_name

VALUES = i_values

EXCEPTIONS

ID_ILLEGAL_NAME = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

* Implement suitable error handling here

ENDIF.

ENDMODULE.

hope it will helps.

regards,

Sandeep

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 10:18:43 GMT

Hi Sandeep,

we can't restrict user for any activities, we can't force them to do that, anyhow if i make a change as shown below, then i can restrict it for one entries

IF ZPAYMENTS1 IS NOT INITIAL.

MOVE-CORRESPONDING ZPAYMENTS1 TO G_ZTBC_2014_WA.
* MODIFY G_ZTBC_2014_ITAB
* FROM G_ZTBC_2014_WA
* INDEX ZTBC_2014-CURRENT_LINE.

APPEND G_ZTBC_2014_WA TO G_ZTBC_2014_ITAB.
ENDIF.
CLEAR : G_ZTBC_2014_WA.

but i want the sane for all the five fields, please tell me how could i achieve it for all table fields.

Re: Problem in table control wizard in module pool programming

hiriyappa_myageri — Mon, 07 Jul 2014 10:19:03 GMT

make use of get cursor line and set cursor line.

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 10:22:05 GMT

Hi Sandeep,

thanks one of my problem get resolved but again the problem of table control wizards still persist,

please tell me the required solution.

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 10:57:03 GMT

try this one,

IF ZPAYMENTS1-BANKKEY IS NOT INITIAL.

Regards,

Sandeep

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 11:35:04 GMT

Hi,

as i told you this will not work, as according to you if a user puts sno and cdate and presses ENTER

then the values will be disappeared, according to you , you have put checked on bankkey, but the user can press enter after any field.

IF ZPAYMENTS1-BANKKEY IS NOT INITIAL.

MOVE-CORRESPONDING ZPAYMENTS1 TO G_ZTBC_2014_WA.

APPEND G_ZTBC_2014_WA TO G_ZTBC_2014_ITAB.
ENDIF.

CLEAR : G_ZTBC_2014_WA.

when i have written this, then when i put sno and cdate, it disappears from my table field.

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 11:44:45 GMT

hi Shweta,

simple coding for that.

use sel field in your internal table

put logic in PAI part

loop at itab.

module insert_data.

under this put code

( if itab-sel is initial.

itab-sel = 'x'.

append itab.

else.

modify itab index tc_current-line.

endif.)

endloop

note :- sel field should be the part of internal table

hope it helps.

with regards,

vikas

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 11:45:26 GMT

Hi Myageri,

please elaborate at some extent what are you saying, i am not getting properly. Here is the code i have written, please tell me the required changes i have to make.

MODULE ZTBC_2014_MODIFY INPUT.

IF ZPAYMENTS1-BANKKEY IS NOT INITIAL.

MOVE-CORRESPONDING ZPAYMENTS1 TO G_ZTBC_2014_WA.

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 11:50:47 GMT

Hi,

I think you have another " APPEND wa_values TO i_values " anywhere else (maybe in ZTBC_2014_MODIFY ON CHAIN-REQUEST or in any other places),

you have to put an IF conditien that if your WA is not initial, then appending happens.

Regards,

Farzin

Re: Problem in table control wizard in module pool programming

Former Member — Mon, 07 Jul 2014 12:12:14 GMT

Hi Vikas,

while creating my table control wizard, i haven't used SEL, so how could i use it.