cancel
Showing results for 
Search instead for 
Did you mean: 

Extracting texts which has its language field as blank?

Former Member
0 Kudos
85

Hi,

I am extracting texts for a characteristic from R/3 to BW.

In R/3, some of the texts for which langauge field ( Sprache ) values are blank.

And the respective texts which have some values ( say E and D ) in R/3

are extrated to BW with out any hassles! Problem is with the blank

language texts! They are not extracted to BW. i had made the texts

definition as language independent for the purpose in BW.

Is there any solution for this problem other than filling the blank

columns in R/3?

Thanks,

Ravi

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You may write a routine , in transfer rule of info object 0LANGU.

Decide for which language system should consider when it encounters blank language. Assuming the langugage should be English , following code should work for you.

If SPRAS = space.
SPRAS = 'E'. 
endif.

Hope that helps.

Regards

Mr Kapadia

Former Member
0 Kudos

Hi,

Thank you very much for your answer!

But, i am not sure whether blank language fields in R/3 have english language texts.

Also,What i should write in Result statement of the routine?

One of our co ordinator told me to write the code as

result = tran_structure-sprache .

And also suggested that i would get the 0langu field selection in infopackage.

But even that did not work as i am not getting those blank value language fields when i did not enter anything in infopackage selection

Thanks,

Ravi

Former Member
0 Kudos

Hi,

You Need to have some assumption when you load data records with blank language field.

And the exact code would look like this

  IF TRAN_STRUCTURE-SPRAS = SPACE.
    RESULT = 'E'.
  ELSE.
    RESULT = TRAN_STRUCTURE-SPRAS.
  ENDIF.

If you put language field blank in info package selection ideally it should bring data pertaining to all language.

Hope that helps.

Regards

Mr Kapadia

Former Member
0 Kudos

Hi,

i tried with your suggsted code!

Sadly, still the blank language fields values are not extracted.

how we would get the 0langu field values selection in infopackage?

I still cannot see the option in infopackage!

Thanks,

Ravi

Former Member
0 Kudos

Hi,

Just in case check data with blank language is extracted from the system (RSA3) and gets into PSA. I think in the case data with blank language has not come to PSA level.

Hope that helps.

Regards

Mr Kapadia

Former Member
0 Kudos

Hi,

In RSA3 no problems! i could see all the texts irrespective of whether langauge field value is a blank or has some value!

But in PSA i could only see those texts which has some values in 0langu field.

Problem is in BW side and not in R/3 side

Thanks,

Ravi