SAP BW4HANA SP07 - Problem with master data lookup in transformations (Any Source --> InfoSource)

[former_member730008]

Dear Experts,

We have recently updated our SAP BW4HANA from SP03 to SP07. After upgrade most of objects (after activation) are working as expected.

But We're experiencing a strange problem in the transformations for a master data lookup from Anysource to Infosource

Any Source (DS/ ADSO) ---(Master data look up in transformation)--------> Infosource ----> ADSO
---------------------------------------------------------------------
Category               ABAP programming error
Runtime Errors         GETWA_NOT_ASSIGNED
ABAP Program           CL_RSDHAM_TRANSFORMATION======CP
Application Component  BW4-DM-TRFN
Date and Time          17.02.2021 23:58:23
-----------------------------------------------------------------------
 Short Text
     Field symbol has not been assigned yet.

Information on where terminated

---------------------------------------------------
    The termination occurred in ABAP program or include
     "CL_RSDHAM_TRANSFORMATION======CP", in "P_PROCESS_FIELD_ERROR_VALUES". The
    main program was "SAPMSSY1".


    In the source code, the termination point is in line 172 of include
     "CL_RSDHAM_TRANSFORMATION======CM010".

Source Code Extract (Source code changed)
---------------------------------------------------

  IF <l_s_tgt_dta_pro> IS ASSIGNED AND <l_s_tgt_dta_pro>-s_dta_pro-iobjtp = rsd_c_objtp-ke
    AND <l_s_field_error_value>-error_value IS INITIAL .
    l_s_field_error_value-error_value = 0.
  ELSE.
   >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> l_s_field_error_value-error_value =
      me->p_convert_type_considering( i_value           = <l_s_field_error_value>-error_va
                                      i_s_field_dta_pro = <l_s_tgt_dta_pro> ).
  ENDIF.

Please find the screenshot for the detail information.

I didnt get relevant SAP note for this topic.

Could you please suggest any alternative solutions? Thanks in advance.

Regards,

Praveen Jelli

[TuncayKaraca]

Hi Praveen,

You can try to re-activate the transformation with program RSDG_TRFN_ACTIVATE. It may be a relief!

Thanks,
Tuncay

[Torsten_]

Hi,

sounds like an issue with SAP note:

2988607-SAP BW/4 HANA - SAP HANA Execution: Negative constant error values in lookup rules

Could you check if the note is implemented?

And if the class CL_RSDHAM_TRANSFORMATION is active without any error?

Open the class CL_RSDHAM_TRANSFORMATION in the class builder (SE24) and press the check button.

Torsten

[former_member730008]

Dear Torsten Kessler, Dear Tuncay Karaca,

Thank you so much for your support and for your valuable time!!

The transformation got activated without any errors after implementing the SAP Note: 2988607-SAP BW/4 HANA - SAP HANA Execution: Negative constant error values in lookup rules

Regards,

Praveen Jelli

[TuncayKaraca]

It's good to hear, Praveen - you resolved the issue!

[former_member667167]

Hi all,

We are also encountering this problem & the correction note says SP7 for SAPK-20007INDW4CORE. We are on SP7 still encountering this issue.

Thanks for any leads.

Regards,

Pragyesh Parekh

[former_member667167]

Hello all,

We were able to resolve this with SAP note : 2603241 (and cascaded notes)

Regards,

Pragyesh

[former_member758515]

Dear Experts,

We have recently updated to SAP BW4HANA and recently I am coming across with the below error .

An error occurred while executing the transformation rule: The actual error message: The database column ' ColumnX' is unknown The error was triggered at the following program location: CL_RSMD_RS_READ_MDATA=========CM01B 700.

ColumnX is based on a master data lookup in transformation. In SNOTE I found that 2988607 can be implemented.Please advice me if we have any other or alternative solution to resolve the error.

Thanks in advance.

Regards,

Neel.