Hi Guys,

I am working on dmcom010 table. i need to compare on field Target Oject Id. In table the value of this filed is like {"PUR008293"}.

Please help me out so that i can compare this id.

Thanks and Regards
Yogesh Kapil

Try this:-

select dmcom010.*
from dmcom010
where dmcom010.trid(3;9)="PUR008293"
selectdo
endselect

Hi bhushan,

thanks for your reply..

i also try the same but this is not working..

if you see this table in lnfp7 the value in this field is somthing different.

the value is start from {".

its not working ................

Hi Yogesh,

I have tried the same and it works.
Please post your script also let me know what exactly you want to print.

If its starting with {".

Then you can replace dmcom010.trid(3;9) with dmcom010.trid(4;9)

Hi bhushan,

Thanks for your reply..It's working very fine..

Good. By the way, may I ask why you want to query that table? Just for my information. :)

Hi bhushan,

In session inspection order ( qmptc1100m000) , we are attaching some file with inspection order.

Now user want when they print the inspection report they get to know which file is attached with inspection order.

i need to compare dmcom010.trid(3;9) with my Inspection Order so that i can print dmcom010.srid.

i write the query like this :-

select dmcom010.srid
from dmcom010
where dmcom010.trid(3;9)=tccom100.iorn

selectdo

Document Attachemnt No = dmcom010.sri

endselect


Regards
Yogesh Kapil

Ok thanks. I had this guess in mind.

You see, user requirement can be anything

;)