Skip to Content
-1

Select from intermediate table in HANA procedure

Hi All,

I have created a HANA stored procedure and was trying to do select on a calculation view as below

HANA procedure have input parameter IP_TXN-DATE as DATE .

DATA_SET = Select MAIN_MANDT, MAIN_SRCDOC_COMP, MAIN_SRCDOC_LOGSYS, MAIN_SRCDOC_TYPE, MAIN_SRCDOC_ID, MAIN_TIMESTAMP_UTC,

MAIN_HEADER_ID, MAIN_ITEM_ID, MAIN_REFERENCE_TYPE , MAIN_REFERENCE_ID,

MAIN_PARTNER,RGW_SUBSCRIPTION_ID

from"_SYS_BIC"."SL.COMMON/CA_MAIN_CONDITION_PREP_DAILY"(PLACEHOLDER."$$IP_TXN_DATE$$" => :IP_TXN_DATE);

In the debugger , I tried to do a data preview on DATA_SET for particular subscription Id(say 123) and it returned only one record where as expectation was to return two records.

If I execute the same query on SQL console ,could see two records for the Subscription ID.

Can anybody explain me what is going wrong here ?

Regards,

Ratheesh BS

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

0 Answers

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.