cancel
Showing results for 
Search instead for 
Did you mean: 

Output issue after data source modification

amine_lamkaissi
Active Contributor
0 Kudos

Hi experts,

I modified a flat file datasource by reducing the number of fields used.

Now, when i load data to DSO, i have the value of a field showed with 20 char but before only 3 chars were showed, and also 3 chars are shown in the other environments.

I'm afraid of this output modification because we have some abap tests on this field. So what can i do to show the values as before.

Thanks.

Amine

Accepted Solutions (0)

Answers (2)

Answers (2)

amine_lamkaissi
Active Contributor
0 Kudos

Hi guys,

i checked in debug mode, all the values are on 3 chars.

I will let things as they are today.

I will let you know if i face a problem in the future.

Thanks to all.

Amine

RamanKorrapati
Active Contributor
0 Kudos

Hi,

What are the source and target objects you used?

is it direct mapping from flat file data source to DSO?

at PSA how the data look like ?

Thanks

amine_lamkaissi
Active Contributor
0 Kudos

Hi Raman,

What are source and target objects yoy used?

Source is a flat file, target is a DSO

is it direct mapping from flat file data source to DSO?

Yes

at PSA how the data look like ?

At PSA Level it looks fine on 3 chars.

I just understood something, On DSO level, when the values are numbers it's displayed on 20 chars with 0 before. But when the values are chars, they are displayed on 3 chars.

What can i do, to display then always on 3 chars (even numbers or chars)?

Thanks.

Amine

mohd_abdullah
Contributor
0 Kudos

Hi,

Go to that particular Infoobject and in the general tab check does it have any  conversion routine (specifically ALPHA ) . If yes then remove that conversion routine and then load the data again .

This should hopefully resolve your issue .

Regards.

amine_lamkaissi
Active Contributor
0 Kudos

Hi Mohammed,

Thanks for you answer.

In fact it has it, the most important for me is that the test has to be done on 3 chars.

I tested in debug mode, in fact the program is interpreting the value as 3 chars.

Can you confirm me that the 0 before in the DSO are only a display issue?

Thanks.

Amine

RamanKorrapati
Active Contributor
0 Kudos

I think you got idea what settings need to about 3 digits display.


0 before in the DSO - mean have you got any issue?

or are you expecting an issue at DSO while displaying data.


in general if we use  ALPHA conversion then it prefix 0 as per the info object length at empty spaces.

if there is no conversion routine the it shows same data as source(PSA/flat file).

mohd_abdullah
Contributor
0 Kudos

Hi,

No ! Its not just a display issue .

Basically what you need to understand about alpha conversion is that for example, if the length of Infoobject say CUSTOMER is 10, and you have an ALPHA conversion routine, a CUSTOMER value of 1 is stored as 0000000001, so is a CUSTOMER value of 0001, 001, and so on.

Without the conversion routine, the system would treat CUSTOMER value = 1 and BW_CUST value = 0001 as two different customers.

Regards.