Question Re: Fields in extractor with no values in Technology Q&A

Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 03:54:50 GMT

Hi,

There are 2 fields added to an extractor in BW which has no values in then when I view the PSA.

But users claim there is value in the ECC source system. I also can't view the data in these 2 fields via RSA3.

Can someone help me to trouble shoot how to view data in ECC source system and why the data is not flowing into the extractor?

Please advice a.s.a.p.

Let me know if you require any further details.

Thanks a million!!

Kind regards,

Rebekah

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 04:04:24 GMT

Hi,

In RSA6 just edit the datasource and uncheck the hide flags in the datasource

Prathish

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 04:07:57 GMT

the hide flag is already unchecked...I am afraid that is not the cause of the problem

please help.

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 04:10:56 GMT

Can you check if there are any exits for the datasource in CMOD - RSAP00001

Prathish

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 04:13:51 GMT

Is it a standard datasource or a custom one?

Prathish

Re: Fields in extractor with no values

RamanKorrapati — Fri, 12 Jul 2013 04:21:18 GMT

Hi RSK,

If you enhanced this 2 fields, check logic at Exits

EXIT_SAPLRSAP_001 for transaction data, include ZXRSAU01

EXIT_SAPLRSAP_002 masterd ata attributes include ZXRSAU02

Have you selected for field know only in exit, i think not.

Select that 2 fields Field known only in exit, at RSA6, change mode and do it.

next trigger RSA3 and you may see data.

Thanks

Re: Fields in extractor with no values

former_member182470 — Fri, 12 Jul 2013 05:18:41 GMT

The best way is to debug your extractor in RSA3 or in CMOD for your enhancement code.

You should take an ABAPer's help to debug it.

Regards,

SUman

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 05:27:17 GMT

its a custome datasource

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 05:35:06 GMT

In RSO2 T-code just provide the datasource and check if it is based on a view or function module or infoset.

If it is based on view, directly go & check if the particular record is available in the view in SE11

If it is a Function module get the function module name from it, put in se37 & check for the logic for populating the fields,, ensure that the fields are included in the extract structure (type declaration of e_t_data in the attributes tab).

if it is based on Infoset, check the Infoset in SQ02

Prathish

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 05:35:21 GMT

all the other fields do not have this option "field known only in exit" checked but they are still able to display data...why do I need to do this for these particular 2 fields only?

please advice.

Thank you!

Rebekah

Re: Fields in extractor with no values

RamanKorrapati — Fri, 12 Jul 2013 05:39:57 GMT

Hi RSK,

have you did enhancement for this 2 fields? if yes then you need select "field know in only exit"

if you enhanced that 2 fields, you need to select that options. then only CMOD code will execute and data will populate. otherwise won't.

Thanks

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 05:48:21 GMT

no i did not make any enhancement on the 2 fields...its standard fields brought in like all the others...but not able to retrieve data for these 2 fields...

Re: Fields in extractor with no values

RamanKorrapati — Fri, 12 Jul 2013 06:01:19 GMT

hi,

ok, as you said,custom data source then you may be know source tables. so check at source tables.

First take records which are blank for added fields from RSA3, check the same at base tables. if there also blank. its not problem.

if values are there for added field at base tables and RSA3 shows blank, need to debug.

your custom data source based table/view/function module/ info set query? have you idea.

As suggested by pratish, check at RSO2, give data source name and click on diplay and see.

Final option Debug. take abap expert and debug data source at RSA3, select debug option.

Thanks

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 06:04:52 GMT

Hi Sunil,

You need to debug in RSA3 with the abaper help. Surely u will get the problem why those two fields has not get the data...

Thanks,

Purushotham.

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 06:56:01 GMT

Its by a function module MCEX_BW_LO_API

how do I debug the FM? run the extractor in RSA3?

please advice.

TQVM!

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 06:57:47 GMT

unfortunately I dont have an abaper to debug with me...can someone guide on how can I debug the FM?

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 06:58:41 GMT

Can you guide on how to debug in RSA3? I don't have resources to do it for me.

Re: Fields in extractor with no values

RamanKorrapati — Fri, 12 Jul 2013 07:12:16 GMT

Hi RSK,

If your familiar with ABAP, you can check thru Tx - Function module - SE37 ., put some break points at function module and exute RSA3.

Data source debug at Tx - RSA3, select debug check box.

Take abap expert, he can help you.

Thanks

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 07:41:40 GMT

Hi Rebekesh Sunil kumar,

As per as my Understanding, when run the extractor in RSA3, you may not see the data in newly added records of Extractor as well as PSA.

Please find my suggestion below:

1) When you add fields whether Standard / Custom Extractor it just add the fields in template.

For example: ZXYZDATASOURCE is data source. You add the field YNEW.

2) If you want to view the data of YNEW in ZXYZDATASOURCE, you need to write exit. The exit will populate data from ECC table.

Regards,

Baskaran

Re: Fields in extractor with no values

Former Member — Fri, 12 Jul 2013 08:01:37 GMT

Cna you please provide the name of the datasource because the function module looks to be that of a standard datasource.

Prathish