topic Re: Select sinlge Problem in Application Development and Automation Discussions

Select sinlge Problem

former_member251546 — Wed, 31 Mar 2010 14:58:08 GMT

hi,

good day

I ve got problem with second single * from cost...


 SELECT SINGLE * FROM cssl INTO ls_cssl WHERE kokrs = '1000' AND     " Here iam getting the data
                                                   kostl = ls_crco-kostl AND
                                                   lstar = afrud_imp-learr.
if sy-subrc = 0.
 SELECT single * FROM cost INTO ls_cost WHERE gjahr = lv_gjahr AND    Here itsnot getting..
                                               objnr = ls_cssl-objnr AND
                                               versn = '0'.

Endif.

Values:

LS_CSSL-OBJNR = KL100010-60 CON

LV_GJAHR = 2009.

Even ive checked with values in COST table.. Data is in COST also but iam not getting the in ls_cost.. is there any wrong in Select single statement.

Plz any one have a look the code and guide me

Regards

Moderator message: please use a more meaningful subject line next time.

Edited by: Thomas Zloch on Mar 31, 2010 4:59 PM - tags added

Re: Select sinlge Problem

mrahhaoui — Wed, 31 Mar 2010 15:02:14 GMT

HI,

Maybe there is something wrong in your clause. Check them.

Regards,

Moh.

Edited by: rahhaoui mohamed on Mar 31, 2010 5:02 PM

Re: Select sinlge Problem

ThomasZloch — Wed, 31 Mar 2010 15:04:11 GMT

the problem is most likely versn = '0'.

navigate to the value table and find out what the correct value is.

Thomas

Re: Select sinlge Problem

RaymondGiuseppi — Wed, 31 Mar 2010 15:04:26 GMT

Try VERSN = '000'. (Conversion exit ALPHA strikes again and Thomas was faster)

Regards,

Raymond