on 10-08-2015 11:30 AM
Hi Gurus,
Getting problem while passing the input parameters in CV Sql Script...
The below is the code.
SQL Script
BEGIN
var_out =
SELECT MANDT, MATNR, BWKEY, STPRS, LFGJA
FROM "ECCSLTD50"."MBEW" ('PLACEHOLDER' = ('$$IN_BWKEY$$', 'US21'))
WHERE MANDT = '150' ;
END /********* End Procedure Script ************/
I am getting the the below error...
Cannot get the data provider outline
SAP DBTech JDBC: [257]: sql syntax error: [257] sql syntax error: incorrect syntax near "US22": line 2 col 97 (at pos 183)Please check lines: 4,
Attached the screen shot.
Hi Lalwanth,
Try like below.
SELECT MANDT, MATNR, BWKEY, STPRS, LFGJA
FROM "ECCSLTD50"."MBEW" (PLACEHOLDER."$$IN_BWKEY$$" => 'US21')
WHERE MANDT = '150'
Thanks
Siva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You are not referring to a view in this stored procedure/CV, but rather a physical table, which is why you are getting a syntax error. MBEW is a table sitting in a schema replicated with SLT. Tables cannot accept input parameters, you need to use a where clause...
SELECT MANDT, MATNR, BWKEY, STPRS, LFGJA
FROM "ECCSLTD50"."MBEW" (PLACEHOLDER."$$IN_BWKEY$$" => 'US21')
WHERE "BWKEY" = 'US21'
AND MANDT = '150'
Additionally, you likely don't need the MANDT restriction unless your SLT is replicating multiple clients to the same target (not typical).
Happy HANA,
Justin
Checked below blogs:
Tried both SYNTAX's : select ... from CV1( 'PLACEHOLDER' = ('$$var$$' = 'VAL1,VAL2,VAL3' )
SELECT field1, field2 FROM CALCVIEW1(‘PLACEHOLDER’ = (“INPUTPARAMETER1”, ‘” VAL1”,”VAL2”,”VAL3”’));
by Krishna,
by karthik
by Latha,
but Couldn't find the solution for my above SQL Script......
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.