Skip to Content

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

SQLScript Calculation View

Hi friends!

I'm trying a simple SQLscript calculation view on HANA but it doesn't work. I'm put in target  marc_MATNR, marc_WERKS, marc_STEUC with same type of DECLARE. How can I use VAR_OUT?

BEGIN

DECLARE marc_MATNR VARCHAR(18);

DECLARE marc_WERKS VARCHAR(4);

DECLARE marc_STEUC VARCHAR(16);

DECLARE CURSOR cMARC FOR

  SELECT matnr werks steuc

  FROM "SAPECD"."MARC"

  ORDER BY MATNR WERKS;

OPEN cMARC();

FETCH cMARC INTO marc_MATNR, marc_WERKS, marc_STEUC;

CLOSE cMARC;

VAR_OUT = marc_MATNR, marc_WERKS, marc_STEUC;

END /********* End Procedure Script ************/

Thanks for any help!

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