Solved: Fields in extractor with no values

Read only

5,250

SAP Managed Tags
BW (SAP Business Warehouse)

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

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

Prathish

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

please help.

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

Prathish

Is it a standard datasource or a custom one?

Prathish

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

its a custome datasource

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

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

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

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...

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

Its by a function module MCEX_BW_LO_API

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

please advice.

TQVM!

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

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

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

Prathish

Hi Kumar,

There is no issue with extrcator.

For custom data source, How you added fields? tell me the steps

Thanks

Datasource : 2LIS_17_I3OPER (Plant Maintenance Order Process)

ExtractStruct. MC17I30OPR

Fields which are affected : ASTTX - Field displaying user status

ESTAT - User Status

Hi,

I did not add the fields...these is an ongoing enhancement...I was looped in to check on the issue when the datasource was not populating any data for these 2 fields.

Therefore I really do not know where I should start checking.

Thanks,

Rebekah

hi rsk,

Always post exact information when you open thread.

Your data source was LO Data source.

First tell me is this data source already in use??? before this day??

if yes then 2 fields how you included?? who added??

LO data source have Setup table concept,

you need to delete and refill setup tables when you want historical data for added fields.

Are you in dev system? now?

Thanks

Yes it is already in use before this. I don't know the history of this datasource.

All I know is I am assigned to find out which no data is being populated for these 2 fields when I execute the datasource in RSA3.

I do not know if the setup table has been configured. How do I check that?

Yes I am in the development systems.

Let me know if you require any further details.

Thank you very much!

Kind regards,

Rebekah

HI RSK,

Every thing fine, you will get data.

This is LO data source, added fields are visible at RSA3 but no data. ok fine.

Just do 2 steps.

1. Delete setup tables Tx - LBWG application component - 17, execute.

2. Refill set up tables Tx - OLIIBW, enter the name of the run - ZRUN and future date - 20-07-2013.

After the filling of set up tables, you can see data at RSA3 or setup tables.

Once you see the data. thats it. Don't load this data further. it leads duplicate.

My suggestion to chekc data at RSA3 only. Because no idea what steps did for this data source at bw side.

Careful.

Thanks

Hi,

I completed both steps but still unable to view data in RSA3 for both fields...the rest of the fields have data populated.

Please advice.

Thank you very much!

Kind regards,

Rebekah

Hi Sunil,

Can you check where the effected fields ESTAT are in? I mean are they placed in append structure "MCAFIH_DFPS"? If yes then these fields are not filled during data extraction.

If you require an update of these fields, create a customer-defined
implementation for the Business Add-In (BAdI) RSU5_SAPI_BADI, which will run
after the extractor MCEX_BW_LO_API.

For more info on this you can refer to SAP Note: Note 1313689 - DFPS append fields in
LIS extraction structures not filled

Srikanth.

its in a view called MC17I30OPR

Hi rsk,

Then that two fields may be enhanced. if you know how to find, its enhanced or not.

Go to SE11, enter table name as MC17I30OPR, display

on components tab, scroll down(Ctrl+pagedown) or click red mark circle on pic

you may see like this way below. (3 last rows)

.APPENDXXXXX

ASTTX - Field displaying user status

ESTAT - User

please share your screen shot.

Thanks

The fields ASTXX & ESTAT are included separately in the extract structure and the datasource has been enhanced in your system, the original extract structure does not hold these fields, just check if there is an exit available by searching with the datasource name in the exit

T-code - SE37

EXIT_SAPLRSAP_001 for transaction data, include ZXRSAU01 as stated below by RK.

Prathish

Hi Prathish,

I've checked SE37 and there are not exits available for both transaction data and master data.

Please advice.

PS: Sorry for the delay in reply as I was away for the weekend.

Regards,

Rebekah

Hi,

This is my screenshot as per your instructions.

My fields are found at position as highlighted below:

Please advice.

PS: Sorry for the delay in reply as I was away during the weekend.

Thank you very much!

Regards,

Rebekah

Hi Sunil,

As i said earlier reply's, its enhanced fields.

Without thinking, Go to RSA6, change mode, select "Fields known in exit only" for that two fields and save.

Delete setup tables and refill. later you can check at RSA3.

Thanks

Are you getting values for the fields PRIOK & STTXT?

Prathish

Fields are still blank

Should I revert my changes on "Fields know in exit only" for the 2 fields and redo the delete and refill setup, since it's not working?

Please advice.

Thank you!

Rebekah

Hi,

I am getting value for PRIOK but no value for STTXT.

Thanks,

Rebekah

Hi RSK,

When the fields are unselected for Fields only in known exit, Then colleague may not be enhanced these fields. Just he added to extract structure and didn't maintained CMOD code for this two ASTTX and ESTAT..

Go SE38 - ZXRSAU01, Find(CTRL+F) - 2LIS_17_I3OPER.

if you won't find that data source with select ASTTX and ESTAT, you may need to look at BAPI part enhancement.

As my guess, code may not be maintained for two fields,so you are not getting data for added fields.

For LO data source enhancement :

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60cc14a4-8b48-2d10-6cba-f2b11ba95...

There is no anything issue. CMOD code may not be maintained. your colleague may left this project in middle of this work.

So maintain code at CMOD and try to check it later. Selection for Field known in exit only. keep it. there is no issue with that. for enhanced fields always need to select. its mandatory for enhanced fields.

You can check for field PRIOK, its enhanced field and may be selected for field only know in exit.

Thanks

Can you provide me the screenshot of the entries in ROOSFIELD table for the datasource 2LIS_17_I3OPER

Prathish

here u go...

In the above screenshots you find that the fields ASTTX & ESTAT with entry as "N - Field not passed on to extractor" for the field NOTEXREL, this is the reason why you are not receiving values for the fields.It shoudl be set yo Y and then you will get the values for it

Prathish

Hi,

How do I correct this? Just /h to debug and change the value to Y?

Please advice.

Thank you!

Rebekah

Hi,

I've changed the value of NOTEXTREL to Y for both fields but I am still unable to view values for both fields in RSA3. I've even deleted the entry for 17 in LBWG and recreated in OLIIBW.

Please advice.

Thank you!

Rebekah

Hi Pratish,

No, its not an issue.

that field value "N" indicates that respective field was not part of the data source mean its not predefined field of data source defination. its enahnced one.

I chekced on my system for recenlty enhanced field, value as N and i can see the data at RSA3.

if posible please check at your and let me know.

Thanks

If it is urgent you can try that, or if it is not urgent I will check & let you know the standard procedure

Prathish

Hi RSK,

Go SE38 at ecc system,

name : ZXRSAU01 , go to display mode and find your data source 2LIS_17_I3OPER

Statements like CASE or WHEN.

if you see your data source name in that program, please share code part.

Thanks

Hi,

In se38, ZXRSAU01 codes are all commented and there is no coding for this particular datasource or any other datasource.

Please advice.

TQ.

Rebekah

Ok in that case they should have gone for a generic approach for all the datasources, do you find any other coding in the exit.

Prathish

Thats it.

As i said, your collegue just added fields and code may not be maintained.

You need to maintain requried logic at ZXRSAU01, change mode and write the required logic and save, activate. at RSA6, select field known only in exit.

Delete and refill setup tables. Check the data at RSA3.

is this data source was in live(production). its look like scrap kind work done by your team mate

Thanks

none found

Yes the guy who was working on this enhancement just added the field and left the company without any proper handover.

I just joined a week ago and I was told to investigate on why the values are not being populated.

Can you please advice on the logic that I should write in ZXRSAU01? I did check the documentation given by you earlier but it was retrieving data from a database table for that newly added field. I am afraid my conditions are not such.

No this has not gone live yet. It is in UAT environment now.

Please advice on the logic to be written.

Thank you very much!

Rebekah

Without knowing the source table of that field, no help from us. You can check with your TL or PM, get them the source table.

once you got the source table and find relation between data source base tables and that fileds source table.

After that you can think about logic.

Mean while when you got help/suggestions form expert there is way to say thanks rather than using"THANKS". so follow the same and respect the scn culture.

Hope you understand.

I believe you are reffering to me awarding the "helpful answer" stars. Sorry I overlooked that as I was too concentrated trying to understand the explanation and suggestions given as I am quite new to SAP BI. I've not added fields via RSA6 to datasource before therefore all these are foreign to me.

I will speak to the user to find the source table name.

Let me know if you require any further action on my side and many thanks for all your helpful pointers.

Apologize if I have unintentionally offended anyone along the way in this forum thread.

Kind regards,

Rebekah

Added fields are clearly enhanced by seeing from your screen shot(.APPEND).

once you know the added fields source tables, its easy for us to sugest outline CMOD code.

or Even you can get from ABAP forum also.

Thanks

Hi,

Do not uncheck Exit box in rSA6 for the enhanced fields. That is the key step to take those fields to BW side.

Hope you tried so many things as per other experts suggestions.

After refilling your Set-up tables, go to RSA3.

In RSA3-->Enter your datasource and press Enter

You may select Target system client

Update mode : F for Full and D for Delta

You can increase data extraction/calls as 10000 and below as 10

You may enter data selection also.

You should get some data and try to analyze whether all the fields are getting populated or not? Hope you get some idea..

If you do not get any benefit, then I suggest you to start from the scratch again. This will avoid all your confusions what your other colleague did before. Start freshly...

Regards,

Suman

Ask a Question

Top Q&A Solution Author

User

Count

By Category

Related Content

Activity Groups

Industry Groups

Influence and Feedback Groups

Interest Groups

Location Groups

Customer Only Groups

Forums

Related Resources

Products

Learning and Support

About

My Account

My Account

Fields in extractor with no values

Know the answer?

Need more details?