on 08-06-2012 1:11 PM
We are using SLT to synchronise SAP tables from AFS and ECC6 into HANA. Currently the tables have just been created by the synchronisation process in HANA and SAP table date fields become NVARCHAR STRING in HANA.
For example, SAP table TBTCO (Batch Job Overview)
Field Type Length
----------------------------
SDLDATE DATS 8
SDLTIME TIMS 6
becomes in HANA
Field SQL DType CS DType Length
------------------------------------------
SDLDATE NVARCHAR STRING 8
SDLTIME NVARCHAR STRING 6
So, that we can make best use of the native date and time comparisons possible in HANA, we would like
these source fields to combine to be stored as native HANA DAYTIME. Is this possible when performing
simple synchronisation of tables using SLT, or do we have to use the full-on ETL facilities within SLT?
Regards
Guy
Hi,
In SLT, type mapping can be done using table IUUC_REPL_TYPMAP (in the SLT system). You can make an entry in this table specifying the source data type and the target HANA type.
Remember, it is done at a the mass transfer ID level which means the setting that you make here will affect all tables/columns involved.
Thanks,
Anooj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Excellent. Thank you Anooj.
Two more questions to complete my understanding of this question, if I may.
1) I can use this table to convert SAP DATS fields to HANA DATE and SAP TIMS fields to HANA TIME, but is it also supported to concatenate the SAP DATS and TIMS fields, where appropriate, to make a HANA DAYTIME timestamp or is that for a more complex ETL function?
2) Am I missing some documentation source other than help.sap.com/hana that would have told me about the IUUC_REPL_TYPMAP table and it's function?
Many thanks for your help.
Guy
Hi,
1. If you want to achieve this in SLT, I think you can achieve this by extending the target table structure with a new timestamp field - for this you will need to create a new target table structure (with this new field) either in source or the SLT system, maintain table IUUC_REPL_TABSTG, create ABAP include to define transformation rules and maintain table IUUC_ASS_RUL_MAP.
You can find the details in the SLT configuration guide - http://help.sap.com/hana/hana_slt_config_en.pdf
2. You are right, there is no information about this table in the help documents. I found this table mentioned in a SAP HANA Webinar I attented on SLT few months ago and I had a made a note of it then.
Hope that helps.
Thanks,
Anooj
Hi Anooj,
In SLT, if i want to do type mapping by using table IUUC_REPL_TYPMAP (in the SLT system), According to the previous information in the thread, it states that the change of the datatype will be at mass transfer level, So what if i have already replicated the tables into HANA where the date fields type is stored as Nvarchar ,SO does it mean that all the tables which are already replicated into HANA will have a change of datatype as well or do we need to re-replicate all the replicated tables in HANA(when i change the datatype of a field for a particular MT_ID)
Thanks,
Sneha
Hi Anooj,
What if I want to convert the Date type to NVARCHAR only for a particular Table. In my case I don't want this setting to be enabled global.
Do you have any suggestions ?
Regards,
HA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.