topic Re: fetching value in Application Development and Automation Discussions

fetching value

Former Member — Tue, 26 Aug 2008 08:59:34 GMT

Hi All,

I want to select single SKOSTL RAUFNR from CATSPM where PERNR = IT_COEP-PERNR but do not want to declare internal table to store the SKOSTL RAUFNR..hw to do this plz help me out.

Thanks & Regards

Ashu SIngh

Re: fetching value

former_member386202 — Tue, 26 Aug 2008 09:02:11 GMT

Hi,

Declare variables n store values into that

refer below code

*--clear

CLEAR : g_contract,

g_revenue,

g_cogs.

*--Select contract value from table ZTKCO_RA

SELECT SINGLE contract

revenue

cogs

FROM ztkco_ra

INTO (g_contract ,g_revenue ,g_cogs)

WHERE zzprojectid EQ st_vbap1-zzprojectid.

Regards,

Prashant

Re: fetching value

matt — Tue, 26 Aug 2008 09:02:20 GMT

DATA: ls_CATSPM type CATSPM.

SELECT SINGLE blah FROM CATSPM INTO corresponding fields of ls_catspm.

Re: fetching value

Former Member — Tue, 26 Aug 2008 09:03:10 GMT

Hi,

Use like this

select single SKOSTL RAUFNR from CATSPM

into ( V_SKOSTL, V_RAUFNR)

)where PERNR = IT_COEP-PERNR

Regards

jana.

Re: fetching value

RaymondGiuseppi — Tue, 26 Aug 2008 09:05:49 GMT

You may try to use something like

SELECT DISTINCT skostl raufnr 
  INTO (wa_skostl, wa_raufnr)
  FROM catspm
  WHERE pernr = it_coep-pernr.
* do your processing
ENDSELECT.

Why don't you recover these data from COEP information. COEP-OBJNR and COEP-PAROB link to the order (AUFK-OBJNR) and the couple cost-center, activity type (CSSL-OBJNR). Your select will return all the orders on which the employee has worked.

Regards

Re: fetching value

Former Member — Tue, 26 Aug 2008 09:13:58 GMT

Hi Ashu,

Use this statement.

select single *

from CATSPM

where PERNR = IT_COEP-PERNR .

And then you can go for fetching the value for the fields using CATSPM-SKOSTL, CATSPM-RAUFNR.

Hope this helps.

Thanks.

Best Regards,

Arun Sankar.

Re: fetching value

Former Member — Tue, 26 Aug 2008 09:14:57 GMT

Tables:CATSPM.

select single * from CATSPM where PERNR = IT_COEP-PERNR .

than use CATSPM-SKOSTL

CATSPM-RAUFNR for use these values.

Amit.