Skip to Content
0
Former Member
Nov 29, 2018 at 05:03 PM

SAP BW DataSource / internal vs. external format / alpha conversion

886 Views Last edit Nov 30, 2018 at 08:37 AM 2 rev

Dear all,

regarding datasource of SAP BWonHANA i have two questions. It would be great if someone can help me to answer the questions...

1 - for a certain field of the datasource (data type char 10, for instance) i have used the alpha conversion. I expected that after loading data to PSA (via executing the infopackage) i can see in that field of the loaded PSA table some 0 at the beginning of the loaded texts, as long as the texts contain only pure numbers and no space. But what i could see is only the number without any 0. This happened, no matter what type of data format (internal vs. external) is used in the datasource. Why?

2 - what is actually the difference of "external" and "internal" data format for data type char within a datasource? (i understand the difference for data type DATS and NUMC)? can you please give me an example?

Many thanks in advance

best regards