SLT/Datasphere Replication Dataype Issue

[S0024038793]

Hi,

Replicating MCH1 table as a replication flow from S4 by using SLT/Datasphere to ADLS

Source: S4

SLT/Datasphere - Replication flow (Init & Delta)

Target: ADLS

In S4 in MCH1 Table

Field - BATCH_ID

Data Element: BATCH_GUID

Data Type : RAW and Length:16

Data Example in S4

MATNR-SA1_047 and BATCH_ID = 0050568259ED1EEA9A9F59EEF9A0227D

Once the replication flow is completed data to ADLS transferred as below

MATNR-SA1_047 and BATCH_ID = 1686

In Datasphere replication flow data type of MACH1-BATCH_ID is showing as BINARY with length 16

[Martin_Kuma]

GUID - Global Unique ID. RAW 16, VARCHAR 32. seems you convert while moving to Azure. Check the value in DSP. 

Best is to convert to varchar32. Then no auto-conversion will take place

[S0024038793]

Hi Martin_Kuma - Thanks for the reply...Do you mean to convert the data type from BINARY to VARCHAR32 ? But in datasphere replication flow projection we dont have data type as VARCHAR

[Martin_Kuma]

Well, correct that one cannot re-type in RF - projection, but as far as I know, one can define the target objects. RF can auto-generate them (if target is DSP), but one can always adjust the tables. One also can create a wrapper on the source side and re-type the field there. Kind of basics for RF.