Skip to Content
author's profile photo Former Member
Former Member

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2015 at 05:38 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 16, 2015 at 08:31 PM

    Hello Jeewan,

    what error message do you get?

    Best Regards,

    Florian

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Florian Pfeffer

      Hi Folorian,

      Thank you very much. At this moment I couldn't have a way to see the column definitions of HANA database. But in SQL it is varchar(20) too.

      If you have SAP B1 Database with you could you please query the table 'CUFD'? I did using 'Query Genarator' (Tools > Queries > Query Genarator)


      Best Regards,
      J S L Geeganage

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.