on 07-07-2016 11:23 AM
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")
Problem solved by using Native SQL from ABAP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.