SQLScript error triying dynamic schema

naotoxxx — Thu, 20 Jun 2019 17:21:19 GMT

Hello! i'm triying to make a query from a different schema from default like this:

My class

definition of the method:  
methods BUSCA_BUKRS
    importing
      VALUE(I_FILTRO) type string " MANDT = '110' and BWKEY = '1000'
      VALUE(I_SCHEMA) type string "SLT_S4R
    exporting
      VALUE(O_BUKRS) type ZCL_TT_BUKRS .

implementation:
method BUSCA_BUKRS BY DATABASE PROCEDURE
                        FOR HDB
                        LANGUAGE SQLSCRIPT
                        OPTIONS READ-ONLY.
*     SQL script
      it_data = SELECT T001K.MANDT, T001K.BUKRS, T001K.BWKEY
                FROM "i_schema"."T001K";
      it_query = SELECT * FROM
                  :it_data AS A;
      O_BUKRS = APPLY_FILTER(:it_query, :I_FILTRO);
  endmethod.

as you can see i'm using i_schema to assing my schema but i get thie error:

So i can't activate my class, i tried to activate obligatory this and run my program but i get a dump

And if i try to write my query like this it works (hard code)

      it_data = SELECT T001K.MANDT, T001K.BUKRS, T001K.BWKEY
                FROM "SLT_S4R"."T001K";

if i debbug in my scenario where i'm facing the error: i_schema = SLT_S4R so it's the same but i don't know why i'm getting an error :c . I am specifying the schema be cause those tables are not in the default schema that's why and i noticed this when i transported to QAS the schema there it's like SLT_S4Q. Any idea or different way to do this ???

Re: SQLScript error triying dynamic schema

UweFetzer_se38 — Mon, 24 Jun 2019 13:43:29 GMT

I currently don't have a system to test, but I would try the following:

      it_data = SELECT T001K.MANDT, T001K.BUKRS, T001K.BWKEY
                  FROM :i_schema."T001K";

Re: SQLScript error triying dynamic schema

naotoxxx — Fri, 05 Jul 2019 19:08:38 GMT

Yes i tried like that but i get this error in this line:

FROM :i_schema."T001K";

Re: SQLScript error triying dynamic schema

DoanManhQuynh — Mon, 08 Jul 2019 03:25:29 GMT

you may check bellow blog:

how-to-access-database-schema-dynamically-using-amdp

topic Re: SQLScript error triying dynamic schema in Application Development and Automation Discussions

SQLScript error triying dynamic schema

Re: SQLScript error triying dynamic schema

Re: SQLScript error triying dynamic schema

Re: SQLScript error triying dynamic schema