Skip to Content
avatar image
Former Member

AMDP BW tables

Hello friends ,

I am kind of struck writing a basic AMDP to fetch data from BW tables .
I am getting SQLscript syntax error without any further explanations. I was able to do the similar logic with regulat tables like sflight , but if I wanted to fetch anything from BW tables then I am getting this error. Most of BW table start with "/BIC/". Error is highlighted at " / ".

Can you please advise how to bypass this or any workaround ?

Message was edited by: ST Reddy code is attached et_count = select count(*) from /BI0/PCOMP_CODE where currency = :lv_curr and mandt = :lv_mandt ;

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 30, 2014 at 08:41 AM

    try to put quotes around the table name like "/BI0/PCOMP_CODE"

    Regards, Thomas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Thomas Gauweiler

      Thank you . When I used two double quotes it worked fine 😊 . Single double quote gives a pause and greys out everything as if it is commenting out in ABAP