Skip to Content
avatar image
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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    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 comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 08:31 PM

    Hello Jeewan,

    what error message do you get?

    Best Regards,

    Florian

    Add 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