topic Re: validate a field in Application Development and Automation Discussions

validate a field

Former Member — Tue, 10 Mar 2009 06:51:48 GMT

Hi Gurus,

I have to validate a paticular field which hold the table name .ie

PARAMETERS : p_table(10) TYPE C. "getting the table name frm the user

FIELD-SYMBOLS: <t_itab> TYPE ANY TABLE.

w_tabname = p_table.

i need to validate the p_table ....... How to validate it .Can any one help to do it .

Advance Congrats

Regards

Abeehs

Re: validate a field

keerthy_k — Tue, 10 Mar 2009 06:54:06 GMT

Hi,

What kind of validation u want.?..if u want to see if the table exists then check if this exists in DD02L table . This table holds the SAP Tables name.

keerthi

Re: validate a field

amit_khare — Tue, 10 Mar 2009 06:57:33 GMT

Write a SELECT query with P_TABLE on table DD02L (Please confirm in SE11).

Re: validate a field

Sm1tje — Tue, 10 Mar 2009 07:02:52 GMT

could that be any table (or even structure) in SAP? If so, table names can be up to 16 characters long (and structures even more).

Try to use the same type as in SE11 for your parameter, would be nicer (better) for the user for selecting a table (structure) from data dictionary.

Re: validate a field

Former Member — Tue, 10 Mar 2009 07:27:08 GMT

you can go for.

AT SELECTION-SCREEN ON p_table.

*select statement for that parameter. e.g:

SELECT SINGLE lifnr FROM lfa1 INTO p_lifnr

WHERE lifnr = p_lifnr.

Regards

Re: validate a field

Former Member — Tue, 10 Mar 2009 08:36:48 GMT

Hi,

thanks for all your reply.. I need to check the table entered in the p_table ..whether the given table name is valid or not if not the nthrought the error message

Re: validate a field

Former Member — Tue, 10 Mar 2009 08:49:55 GMT

validate against dd02l

select single tabname

from dd02l into l_v_file where tabname = p_file.

If sy-subrc ne 0.

Print ur error message.

Endif.

Re: validate a field

Former Member — Tue, 10 Mar 2009 10:24:31 GMT

you can go for.

AT SELECTION-SCREEN ON p_table.

*select statement for that parameter. e.g:

SELECT SINGLE lifnr FROM lfa1 INTO p_lifnr

WHERE lifnr = p_lifnr.

if sy-subrc <> o.

message 'text mesage here' type 'E'.

endif.

Regards

Re: validate a field

Former Member — Tue, 10 Mar 2009 10:24:46 GMT

you can go for.

AT SELECTION-SCREEN ON p_table.

*select statement for that parameter. e.g:

SELECT SINGLE lifnr FROM lfa1 INTO p_lifnr

WHERE lifnr = p_lifnr.

if sy-subrc <> o.

message 'text mesage here' type 'E'.

endif.

Regards

Re: validate a field

Former Member — Fri, 13 Mar 2009 13:37:54 GMT

Hi,

Check to see if the table entered on the selection screen is available in the DD02L table.

The database table DD02L holds all the dictionary tables in SAP.

The pseudocode would look like below.

AT SELECTION-SCREEN on p_table.

Select single <tablename> into (g_tabname) from DD02L

where <tablename> = p_table.

If sy-subrc <> 0.

Return Error message.

endif.

Regards,

Vamsee