'PLACEHOLDER' = ('$$IP_SOR_DATE$$', '2016-07-07') vs PLACEHOLDER."$$IP_SOR_DATE$$'" => '2016-07-07'

[former_member305041]

Dear, collegues.

My answer is what differencies between two versions of PLACEHOLDER in SELECT statement?

My task is get data from Calculation View CV_UOR_SOR_AVAILABILITY using ABAP Database Procedure and I need pass values of two Input Parameters. After creating the procedure, importing it in ABAP dictionary and writing the ABAP program. I am executing this programm and getting Memory allocation error.

I made investigation an see that if use 'PLACEHOLDER' = ('$$IP_SOR_DATE$$', '2016-07-07') in my SELECT statement it succesfully ending after 10 seconds. But if use PLACEHOLDER."$$IP_SOR_DATE$$'"   => '2016-07-07' I get memory error.

Please sorry for my English. You can understand me better from attached pictures.

SELECT
  "ZBPC_CFO",
  "ZSUPERVIS",
  "PLANT",
  "MATERIAL",
  "ZMATGR1",
  "ZMATGR2",
  "ZMATGR3",
  "ZMATGR4",
  "NDAY",
  "NWEEKDAY",
  "NWEEK",
  "NMONTH",
  "NYEAR",
  "NHOUR",
   "QTY_A",
   "QTY_P",
  "PLU_PRICE",
   "QTY_NEG",
   "QTY_MIS"
/* FROM "_SYS_BIC"."uor.sor.availability/CV_UOR_SOR_AVAILABILITY"('PLACEHOLDER' = ('$$IP_SOR_DATE$$', '2016-07-07'),
                                                                                                                       'PLACEHOLDER' = ('$$IP_SOR_VERSION$$', '000')) */
FROM "_SYS_BIC"."uor.sor.availability/CV_UOR_SOR_AVAILABILITY"(PLACEHOLDER."$$IP_SOR_DATE$$'"   => '2016-07-07', 
                                                                                                                     PLACEHOLDER."$$IP_SOR_VERSION$$" => '000') 
ORDER BY
  "PLANT",
  "NDAY",
  to_int("NHOUR")

[former_member305041 · Accepted solution]

Problem solved by using Native SQL from ABAP.

[rindia · Accepted solution]

Hi Marat,

PLACEHOLDER."$$IP_SOR_DATE$$'"   => '2016-07-07'

It is used when you want to call view(which has input parametr on IP_SOR_DATE) say CV1 from another view, say CV2.

Example CV2:

VAR_OUT =

SELECT * FROM "_SYS_BIC"."a.b.c/CV1"

  (PLACEHOLDER."$$IP_SOR_DATE$$" => :$$IP_SOR_DATE$$);

Regards

Raj