Skip to Content

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

XSJS select query from calculation view with input parameter

Dear friends,

       I am create an XSJS to select data form calculation view with input parameter. In this way ,it works:

var query1 = "SELECT TOP 200 \"SO\", \"ORDER_TYPE\", \"FISCAL\", \"SALE_AREA\", \"COMPANY_CODE\", \"PC\",\"AMOUNT\" " +

              "FROM \"_SYS_BIC\".\"Kevin_Demo.UI5_DEMO1/CAL_SO\" " +

              " ('PLACEHOLDER' = ('$$I_ORDER_TYPE$$', 'YBB1'), 'PLACEHOLDER' = ('$$I_FISCAL_YEAR$$', '2014')) " +

              "GROUP BY \"SO\", \"ORDER_TYPE\", \"FISCAL\", \"SALE_AREA\", \"COMPANY_CODE\", \"PC\",\"AMOUNT\" ";

        But now I want to get the input parameter form my UI5  textfield, then this values will as my placeholder value, how do I write my query ?

         Thanks for your sincerely answer.

Best Regards

Zhang

Tags:

Helpful Answer

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