HANA View different data type

[#1]

Could you please let me know if there is explanation on this behavior.

I have 2 views - Analytical view (ANV) and Attribute view (ATV) which is used by ANV. I've migrated both of them as copy into Calculation view (CAV). Now when I comparing those views I'm facing below issue.

There is one column 'PRODUCTCODE' originally coming from ATV which is data type NVARCHAR(20) all the way from source table till CAV:

But when I preview the data from CAV and check property of the column in preview pane of Available Attributes then it shows NVARCHAR(18):

Also when I compare data property of Original (ANT) and Migrated (CAV) from _SYS_BI.BIMC_DIMENSION_VIEW then I get different data types:

Any idea if possible to change somehow?

Thank you

Dusan

Technical details:

HANA version: 2.00.047.00.1586595995

Platform: SUSE Linux Enterprise Server 15 SP1

[dusan_smelcer]

Hello abhishek_hazra, thank you for suggestion.

Actually the root cause is that the PRODUCTCODE is field from left table joined in Star join node in migrated calculation view and is joined (Referential join, 1..1) to another table via field ARTNR which data type is NVARCHAR (18). I guess therefore it's showing also NVARCHAR (18) for PRODUCTCODE.

Other views behaves same way.

BR, Dusan