cancel
Showing results for 
Search instead for 
Did you mean: 

Data (for new Zfield) in R/3-RSA3 but not in BW-PSA

Former Member
0 Kudos
86

we enhanced our zmaterial- DataSource with a "new" Z-field.

I checkt the DataSource with RSA3 and everything seemed to be fine (right data in Z-Field).

I loaded one record to BW and this new Z-Field is empty (I expected data!).

I allready:

- activated everything on BW

- deleted Source System Assignment and assigned it new

- Replicated the Data Source (twice)

- checked Transfer Rules

- checked the assignment of the z-field (Type is Ok, it is assigned)

- tried Delta and Full dtp

- searced with google and in this forum.

...

Monitor shows green light on DataLoading (no errors)

ST22 shows no shortdump (BW and R/3)

System BW 3.5

Why can i see data on RSA3 and BW can´t load values for this new Z-Field?

and this is my user exit

data :

wa_zmaterial type zoxztd0042,

when 'ZMATERIAL_M2_1'.

"mcekdemir

data: wa_mattab like standard table of bapi1003_alloc_values_char with header line,

wa_matcurr like standard table of bapi1003_alloc_values_curr with header line,

wa_matnum like standard table of bapi1003_alloc_values_num with header line,

wa_return like standard table of bapiret2 with header line,

lv_matnr like bapi1003_key-object.

*BREAK-POINT.

loop at i_t_data into wa_zmaterial.

lv_tabix = sy-tabix.

lv_matnr = wa_zmaterial-zzmatnr.

refresh wa_mattab.

clear wa_zmaterial-zzkalite.

call function 'BAPI_OBJCL_GETDETAIL'

exporting

objectkey = lv_matnr

objecttable = 'MARA'

classnum = 'ZZ_EV_TEKSTILI'

classtype = '001'

  • KEYDATE = SY-DATUM

  • UNVALUATED_CHARS = ' '

  • LANGUAGE = SY-LANGU

  • IMPORTING

  • STATUS =

  • STANDARDCLASS =

tables

allocvaluesnum = wa_matnum

allocvalueschar = wa_mattab

allocvaluescurr = wa_matcurr

return = wa_return

.

read table wa_mattab with key charact = 'ZZ_KALITE'.

if sy-subrc = 0 .

wa_zmaterial-zzkalite = wa_mattab-value_char.

modify i_t_data from wa_zmaterial index lv_tabix.

else.

call function 'BAPI_OBJCL_GETDETAIL'

exporting

objectkey = lv_matnr

objecttable = 'MARA'

classnum = 'YB_N_MAMUL_RAPOR'

classtype = '001'

  • KEYDATE = SY-DATUM

  • UNVALUATED_CHARS = ' '

  • LANGUAGE = SY-LANGU

  • IMPORTING

  • STATUS =

  • STANDARDCLASS =

tables

allocvaluesnum = wa_matnum

allocvalueschar = wa_mattab

allocvaluescurr = wa_matcurr

return = wa_return

.

read table wa_mattab with key charact = 'YB_KALITEKOD' .

if sy-subrc = 0.

wa_zmaterial-zzkalite = wa_mattab-value_char.

modify i_t_data from wa_zmaterial index lv_tabix.

endif.

endif.

endloop.

Edited by: mebanato on May 27, 2011 2:58 PM

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Experts,

We faced the same issue, and we have just solved changing the lenguage of the RFC connection, it was seted as 'EN' and we deleted it, it was seted empty, and now the field is being populated in PSA.

Regards.

cesarbe
Explorer
0 Kudos

Mauricio,

Your suggestion solved my issue!. Great support, thks!

Former Member
0 Kudos

Hi,

If data is seen in RSA3, then should not be any isuue in source. Must be something at BW side. This 3.5 flow right?

Former Member
0 Kudos

Hi Parth,

Bw System 7.01 !

Former Member
0 Kudos

I hope that the field is not hidden in the data source in R/3.

Normally, this comes into the picture while transfering data into BI.

Also, i see a *BREAK-POINT in your code.

So, did you debug the code? Is it picking the value for the field, in the code atleast?

I do not see any reason why as to the data is not getting filled for the particular field if its available in R/3.

Former Member
0 Kudos

Hi Vishal ,

İ checked 3 times ,the field is not hidden in the data source in R/3.

As you said i did debug(also whitout debug) , i see the data in rsa3 .

In R3 the zfiled picked the value that i expected , but my problem is i cant see it PSA , in PSA the zfield is empty.

Thanks anyway

Former Member
0 Kudos

another possibility is that the option "field only known in customerexit" is checked.

Former Member
0 Kudos

Hi Marco ,

I tried it , but not work. What kind of a mistake i make , i really have no idea.

i checked "field only known in customerexit"...

Former Member
0 Kudos

Is the datasource 'ZMATERIAL_M2_1' based on table/view/funtion module?

Former Member
0 Kudos

Hi Murali

'ZMATERIAL_M2_1' based on view