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

At selection screen

Former Member — Mon, 16 Oct 2006 10:30:24 GMT

Hi Friends,

I want to check the entries for Sales organisation in the selection screen p_vkorg (parameters)<b>vbak-vkorg.</b>

Can you pls tell me how to do it.

Thanx in advance

Venu.

Re: At selection screen

Former Member — Mon, 16 Oct 2006 10:33:26 GMT

What exactly the requirement is? Do you want to just read the values or you also want to check whether those are present in the master data table?

To read the value from selection screen you can use FM DYNP_VALUES_READ.

Best Regards,

Vibha

*Please mark all the helpful answers

Re: At selection screen

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

AT SELECTION-SCREEN.

  IF NOT P_VKORG IS INITIAL.
     SELECT SINGLE VKORG FROM TVKO INTO VBAK-VKORG WHERE VKORG = P_VKORG.
  IF SY-SUBRC NE 0.
        *DISPLAY ERROR MESSAGE HER
  ENDIF.
ENDIF.

Reward points if ur problem solved , for the previous thread also

Re: At selection screen

Former Member — Mon, 16 Oct 2006 10:34:24 GMT

hi Venu,

Do this way ..

at selection-screen.


select * from vbak where vkorg = p_vkorg.

if sy-subrc = 0.

< do something>
endif.

Regards,

santosh

Re: At selection screen

Former Member — Mon, 16 Oct 2006 10:34:58 GMT

Hi,

I also want to check whether the values present in the database table.

Thanx,

Venu

Re: At selection screen

Former Member — Mon, 16 Oct 2006 10:35:40 GMT

Hello VENU,

Use this code.

<b>AT SELECTION-SCREEN ON P_VKORG.

SELECT SINGLE * FROM TVKO where VKORG = P_VKORG.

IF SY-SUBRC NE 0.

Message E000(SU) with the 'The Sales Org is not found'.

endif.</b>

If useful reward.

Vasanth

Re: At selection screen

Manohar2u — Mon, 16 Oct 2006 10:36:10 GMT

REPORT YTEST_100 .

tables vbak.

parameter p_vkorg like vbak-vkorg.

at selection-screen.

select single * from vbak into vbak where vkorg = p_vkorg.

if sy-subrc ne 0.

message s000(eo) with 'No data found'.

exit.

endif.

start-of-selection.

Regds

Manohar

Re: At selection screen

Former Member — Mon, 16 Oct 2006 10:36:24 GMT

Hi Venu,

I think you want to get the possible values for the sale Organization at the selection screen.

try: PARAMETERS : p_org type VKORG.

this will return only those values which are available in DB.

Hope this helps.

Reward points if this helps.

Manish

Message was edited by: Manish Kumar

Re: At selection screen

shishupalreddy — Mon, 16 Oct 2006 10:43:49 GMT

hI ,

Use the following code hope it will help you to resolve u r issue.

data : r_vkorg LIKE vbak-vkorg.

AT SELECTION-SCREEN.

IF NOT p_vkorg IS INITIAL.

select single vkorg from vbak INTO r_vkorg WHERE VKORG = p_vkorg.

IF SY-SUBRC <> 0.

MESSAGE 'nodata' TYPE 'E'.

endif.

regards,