ADMP Routine in BW

[hari_edula]

Hi There,

I am trying to explore ADMP rotuines in BW/4HANA, can I write code like this?

Basically I want to fill the ZFLG with 'X' when ever AIRLINE = 'AA', but I am getting error

Thanks

James

[Jörg_Brandeis · Accepted solution]

Assuming the the fields are in the correct order for the OUTTAB, it shouldlook like this:

outtab = SELECT airline, 
                flightconnection, 
                flightdate, 
                CASE airline
                  WHEN 'AA' THEN 'X'
                  ELSE '' 
                END AS zfag
            FROM :intab;

Regards,
Jörg

[hari_edula · Accepted solution]

Hi Jörg,

Thank you very much for you help.

It worked .

I am sorry , I have one more question for you.

I am getting error message when I assigned like below

It_lookup = Select * from "BIC/AZSOURCE222";

Do I need to declare about It_lookup?

Regards

James.

[Jörg_Brandeis · Accepted solution]

What does the error message say? Please always post this in a question....

May be you have to declare the table in the USING Clause. And have you forgotten the first / in the table name?

Regards,
Jörg

[hari_edula]

Hi Jorg,

Thanks

I got it, what you mean by "USING" clause.

Thanks

James

[hari_edula]

Hi Jörg,

Thanks for your time.

Please see the screenshot , error says "SQLSCRIPT: sql syntax error: incorrect syntax near ":".

Please correct me if I delcare in wrong place.

Thanks

James