fetching value

[Former Member]

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

[former_member386202]

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

[matt]

DATA: ls_CATSPM type CATSPM.

SELECT SINGLE blah FROM CATSPM INTO corresponding fields of ls_catspm.

[Former Member]

Hi,

Use like this

select single SKOSTL RAUFNR from CATSPM

into ( V_SKOSTL, V_RAUFNR)

)where PERNR = IT_COEP-PERNR

Regards

jana.

[RaymondGiuseppi]

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

[Former Member]

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.

[Former Member]

Tables:CATSPM.

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

than use CATSPM-SKOSTL

CATSPM-RAUFNR for use these values.

Amit.