topic conversions program in Application Development and Automation Discussions

conversions program

Former Member — Thu, 27 Apr 2006 06:54:51 GMT

when i write below statement and activated am getting a error message as 'werks unknown'.

select single ekgrp from t024 into g_ekgrp where werks in p_werks.

can any one help how shoould i write above staament

thanks venkat

Re: conversions program

Former Member — Thu, 27 Apr 2006 06:58:41 GMT

Hi Venkat,

The table T024 does not have any field named "werks".

Hence the error.

Tell the exact requirement.

**Don't forget to reward points for useful replies

Re: conversions program

Former Member — Thu, 27 Apr 2006 06:59:33 GMT

Hi !!

There is no "werks " field in t024 table.

Check what filds are in that table using SE11 or SE16N tansaction

BR, Jacek

Re: conversions program

Former Member — Thu, 27 Apr 2006 07:13:59 GMT

hi venkat,

werks is not available is in the table,

do you have any append struture , if so try to check the table is active or not. try to adjust the table and activate it.

then check your select .

Regards

vijay

Re: conversions program

vinod_gunaware2 — Thu, 27 Apr 2006 07:16:58 GMT

There is no field werks so u have to get by using join on EKPO or EKKO.

regards

vinod

Re: conversions program

Former Member — Thu, 27 Apr 2006 07:20:25 GMT

Hai Venkat

Tables : T001W.

DATA : BEGIN OF TB_MATNR_WERKS OCCURS 0,

MATNR LIKE BSEG-MATNR, " Material Number

WERKS LIKE BSEG-WERKS, " Plant

END OF TB_MATNR_WERKS.

AT SELECTION-SCREEN.

PERFORM VALIDATE_SEL_SCREEN_INPUT .

FORM VALIDATE_SEL_SCREEN_INPUT .

Local varaibles

DATA:L_BUTXT(30), " For Name of the company code

L_WERKS TYPE WERKS. " For Plant

Validation for Plant

CLEAR L_WERKS.

SELECT SINGLE WERKS

INTO L_WERKS

FROM T001W

WHERE WERKS IN S_WERKS.

IF SY-SUBRC <> 0.

MESSAGE E899 WITH 'Enter valid Plant'(004).

ENDIF.

endform. " VALIDATE

Thanks & Regards

Sreenivasulu P

Message was edited by: Sreenivasulu Ponnadi

Re: conversions program

Lakshmant1 — Thu, 27 Apr 2006 07:23:53 GMT

Hi Venkat,

Check demo programs

DEMO_SELECT_SINGLE

DEMO_SELECT_SINGLE_FIELDS on how to use Select Single statement.

Hope this helps

Thanks

Lakshman