Skip to Content

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

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 ;

Former Member
replied

But the quote " does not start a comment in SQL Script.

Now I see another problem: You are selecting a single value and not a table. In this case you cannot use the construct: <table> = select ...

Please try the following

select count(*) into ev_count  from "/BI0/PCOMP_CODE" where currency = :lv_curr and mandt = :lv_mandt ;

Regards, Thomas

0 View this answer in context

Helpful Answer

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