3639366 - Master Data Lookup different result between ABAP and HANA runtime for initial date value

After the installation of the Note Firstly install the Note 3593750, the HANA and ABAP runtime of a transformation returns different results in the Master Data Lookup rule, in case the following rules apply:

• The lookup is performed for time dependent attributes.
• The time dependency is read from a source field.
• The source date field contains the initial value 00000000.

Prior to the installation of the Note 3593750 the initial date entries are NOT extracted. Therefore the installation of the Note must be performed first.

Let's take the following example, where the lookup object has the following values:

The source has the following records:

The lookup rule is defined like this:

Result of ABAP runtime:

Result of HANA runtime:

• SAP BW/4HANA

hana runtime, abap runtime, cartesian product, transformation issue, sap bw/4hana, hana execution, abap execution, transformation logic, sap note 3593750, data acquisition, hana database server, bw transformations, null, md lookup, lookup, dats , KBA , BW4-DM-TRFN , SAP HANA execution in Transformation and DTP , Problem