Skip to Content
0

BPC Characteristic Relastionships Procedure/Function not found in catalog!

Feb 21, 2017 at 03:12 AM

42

avatar image

Hi, I have created a CR in BPC of type class. The class is derived from

CL_RSPLS_CR_EXIT_BASE.

I then implemented method get_sqlscript_info and the derive method as follows:

 method if_rspls_cr_exit_hdb~get_sqlscript_info.
    e_procedure_name_derive = 'ZCL_CR_CPRC01_002=>AMDP_DERIVE2'.
  endmethod.

  method amdp_derive2 by database procedure
                   for hdb
                   language sqlscript
                   options read-only
                   using /bi0/pcust_sales.
    e_t_chas = SELECT cust."CUST_SALES" AS "SOLD_TO",
           cust."SALESORG",
           cust."DISTR_CHAN",
           cust."DIVISION",
           cust."CUST_GROUP",
           cust."SALES_OFF"
        FROM :i_t_chas AS IT
        INNER JOIN "/BI0/PCUST_SALES" AS cust
        ON  it."SOLD_TO"    = cust.CUST_SALES and
            it."SALESORG"      = cust."SALESORG" and
            it."DISTR_CHAN"    = cust."DISTR_CHAN" and
            it."DIVISION"      = cust."DIVISION";
  endmethod.

When executing the CR is RSPLAN, I get a short dump. On HANA trace, I get the following:

[22571]{400160}[75/291939343] 2017-02-21 04:26:31.309290 e pleCompile ple_command_srv.cpp(00199) : Invalidate the session '20170221022630_7360000' due to an exception. Session '20170221022630_7360000' not valid.

Last error: Condition 'fi' failed.

Procedure/Function 'SAPMAL'.'ZCL_CR_CPRC01_002=>AMDP_DERIVE2' not found in catalog!

What am I doing wrong, any help would be appreciated.
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers