topic Re: At selection screen in Application Development and Automation Discussions

At selection screen

Former Member — Mon, 16 Oct 2006 09:43:12 GMT

Hi Friends,

I want to check the entries for the sales group.

vbak-vkgrp(Parameter).

can you pls write the statement.

Thanx in advance,

Venu

Re: At selection screen

rajeshkumar_kaveti — Mon, 16 Oct 2006 09:58:45 GMT

Hi,

tables: TVKGR.

select single * from TVKGR where VKGRP eq vbak-vkgrp.

if sy-subrc ne 0.

message i002(sy) with 'Sales group not exists'.

exit.

endif.

Regards,

Rajesh

Re: At selection screen

Former Member — Mon, 16 Oct 2006 10:03:56 GMT

Hi venu,

For checking the values in the selection screen..u need to check the check table associated with that field..for this it is TVBVK..so u write the select statement for this table....and put a message..

Cheers

Badri.

Re: At selection screen

Former Member — Mon, 16 Oct 2006 10:08:47 GMT

AT SELECTION-SCREEN.

IF not p_vkgrp is initial.

  select single vkgrp from <b>TVBVK</b> into vbak-vkgrp where
            vkgrp = p_vkgrp.
  if sy-subrc ne 0.
     *display error message her
  endif.

endif.

Message was edited by: Chandrasekhar Jagarlamudi

Re: At selection screen

Former Member — Mon, 16 Oct 2006 11:16:59 GMT

Hi Venu,

PARAMETERS : p_vkgrp type VKGRP.

data: ws_VKGRP type VKGRP.

select single VKGRP

into ws_VKGRP

from TVKGR

where VKGRP eq p_vkgrp.

if sy-subrc ne 0.

message s000 'Invalid Sales Group'.

exit.

endif.

Reward points if this helps.

Manish

Re: At selection screen

shishupalreddy — Mon, 16 Oct 2006 11:51:22 GMT

hi ,

hope this will help you out.

tables: TVKGR.

data : l_vkgrp.

select single vkgrp from TVKGR into l_vkgrp where VKGRP eq p_vkgrp.

if sy-subrc ne 0.

message e002(sy) with 'Sales group not exists'.

exit.

endif.

regards,

Re: At selection screen

Former Member — Tue, 17 Oct 2006 08:42:16 GMT

Hi,

Tables:vbak.

data:itab like vbak occurs 0.

parameters:p_vkgrp like vbak-vkgrp.

select * from vbak into table itab

where vkgrp = p_vkgrp.

if sy-subrc <> 0.

message e000(z) with 'sales group does not exist'.

endif.

Regards,

Sowjanya.

Re: At selection screen

Former Member — Tue, 17 Oct 2006 09:16:43 GMT

see, as it is a parameter,

u can check like below.

<b>at selection screen.

if <parameter> = '...'. / check not <parameter is initial/ write <parameter></b>

any of the above statement will check/ give param value.

if it is select-option,

u need to

check not <select-option>[] is initial.