Skip to Content
avatar image
Former Member

Translating Start Routine in BW to AMDP

Hi,

Need help with below translation of ABAP-START ROUTINE to AMDP in BW Transformation.

Scenario:

Current ABAP - Start routine is written in order to update an field by doing lookup on the DSO .

i.e., one of the Field(TXT) in the SOURCE_PACKAGE will be update based on the conditions looked up on the Active table of the DSO.,

The join is between the SOURCE_PACKAGE and DSO.

I need to translate it to the AMDP.

I could achieve only below code, but how to update particular column of the outtab.

Outab =

SELECT * FROM "/BIC/AXXX" INNER JOIN :INTAB ON

"/BIC/AXXX"."/BIC/FIELD1" = :INTAB.OBJ1 AND

"/BIC/AXXX"."/BIC/FIELD2" = :INTAB.OBJ2 AND

"/BIC/AXXX"."/BIC/FIELD3" = :INTAB.OBJ3 AND

"/BIC/A/BIC/AXXX".FIELD4 != ' ';

The Source is Datasource. Target is ADSO.

Thanks for the help in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 15, 2017 at 01:35 PM

    Issue is resolved. The solution was using the CAST statement. There was difference between the data types of the fields used for comparision.

    Add comment
    10|10000 characters needed characters exceeded