Target data were not extracted into SAP BW,but they could be found in RSA3?

[Former Member]

Dear SAP BW expert,

I found some problems loading data from SAP R/3 into SAP BW.

Situation

[SAP R/3]

- added fields in data source (SAP R/3)

- could be extracted in RSA3

[SAP BW]

- replicate data source

- added fields in InfoProvider

- modified & activated communication structure

- modified & activated transfer structure and transfer rules

- modified & activated update rules

Problem

- after I executed infopackage, all data were loaded successfully.

- unfortunately, data for a new fields could not be extracted.

- there was no data in PSA as well.

Any suggestion would be appreciated.

Thank you very much.

-WJ-

Edited by: Wachira Jaritsakul on May 7, 2009 7:27 AM

[shanthi_bhaskar]

able to see the data for added fields in RSA3 ???

[Former Member]

Yes. Data in the new field could be seen in RSA3.

[shanthi_bhaskar]

wachira,

try to replicate DS once agian activate ths DS, Trules once again and check data comes to PSA or not..

[Former Member]

I did it many times. There was no data yet.

[shanthi_bhaskar]

Did you mapping is ok in Transfer rules...PSA will have same structure of T.rules

[Former Member]

Hi,

Could you please tell us what datasource it is?

chk if the data type and length of the added field and mapped infoobjects matches.

Ramesh

[Former Member]

Hi Ramesh,

> Could you please tell us what datasource it is?

The data source is a customized data source.

> chk if the data type and length of the added field and mapped infoobjects matches.

Data type and length are matched.

[Former Member]

Hi,

If the datasource is generic DS, then directly chk the item level table contents for number of records.this would give you the exact count of the number of records.

On what basis you determine the 270 records are old? if you know the codition for 250 new records, give the same in the infopack selection and trigger upto PSA and chk.

Ramesh

[Former Member]

Hi Ramesh,

I did not quite understand what you meant in the previous messages.

Would you mind clarifying a bit more?

Could this problem possibly be authorization issue?

-WJ-

[Former Member]

This issue has been resolved by ABAPer from my project.

He found that if the code referred to text symbol, data will not be able to be seen on SAP BW.

Here are some original ABAP code:

if p_stat-tsabr ne space and p_stat -lrmdt ne 0.

write text-545 to part2.

endif.

Here are some modified ABAP code:

• Constant for call status*

constants: p_520(9) type c value 'New start',

p_545(8) type c value 'Complete'.

if p_stat-tsabr ne space and p_stat-lrmdt ne 0.

write p_545 to part2. "Termin r?ckgemeldet

endif.

That's all I'd like to share.

-WJ-

[Former Member]

I have the same problem. Where have you changed ABAP code ?

[Former Member]

Birute,

I'm not sure that I understand your point or not.

I did change the ABAP code from transaction SE38.

- select program name

- select option "Text elements"

- check tab "Text symbols"

The sample code I already posted on my latest thread.

-WJ-

Edited by: Wachira Jaritsakul on Jul 16, 2009 7:26 AM