Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Query the table CUFD

Hi All,

I'm facing a difficulty while trying to get record from table CUFD with column 'TableID' in the where clause. I think the '@' sign cause the issue where I can filter this table with other column fields.

SELECT "TableID", "AliasID" FROM "CUFD" WHERE "TableID" ='@MyTable'

Is there anyway to avoid the 'at' sign or the problem occurs due to other cause? Your help will be highly appreciate.


Thank in advance and Best Regards,
J S L Geeganage

Tags:
Former Member
Former Member replied

Hi,

Sorry to bother you all. Today morning when I try to do the same, it worked. No additional step has except running the bellow query. I don't believe this fixed the problem.

SELECT "TableID" FROM "CUFD" WHERE "TableID" = (SELECT "TableID" FROM "CUFD" WHERE "CUFD"."AliasID" = 'Variant')

May be there was a kind of a latency to update the changes that I have made Or may be I mixed up with upper and lower cases. Not sure though, but now it is working fine.


Best Regards,
J S L Geeganage

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question