Skip to Content
0

Translating Start Routine in BW to AMDP

Oct 31, 2017 at 11:02 AM

87

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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

Share
10 |10000 characters needed characters left characters exceeded