cancel
Showing results for 
Search instead for 
Did you mean: 

Fields in extractor with no values

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi All,

Issue has been resolved.

I managed to find the field's (ASTTX) base table which is AUFK.

I wrote a DATA_TRANSFORM method at BADI to get the order no. and object no. from AUFK and match it with MC17I30OPR to get the User status value.

Thank you for all your helpful guidance.

Kind regards,

Rebekah

RamanKorrapati
Active Contributor
0 Kudos

finally you got succeed, Great effort keep it and up. put more efforts on tracking tricks. that's give you more confidence to track this kind of issue.

Thank you

Former Member
0 Kudos

Thank you

I could not have done it without the guidance and help given by you guys!!

Kind regards,

Rebekah

RamanKorrapati
Active Contributor
0 Kudos

Your welcome, keep it up. have gr8 day ahead

Answers (7)

Answers (7)

gurunathkumar_dadamu
Active Contributor
0 Kudos

Hi,

Please find the link http://scn.sap.com/message/14190163#14190163

Regards,

Gurunath Kumar D

former_member188080
Active Contributor
0 Kudos

    Hi Sunil,

Few questions and answering might resolve your queries.

Is this standard field or Z field

Standard field - check which table it is extracting data from or view from which it is extracting data. whether that table/view has data or not?

Z field - check whether this is also included in some table /view or not? if not see whether any SMOD/CMOD include where any coding is done to poulate this field.

Thanks and regards

KIran

Former Member
0 Kudos

Hi Kiran,

I do not know from where the datasource is extracting the data. I am trying to debug the FM MCEX_BW_LO_API to see if I can get the table name.

Do you know how else I will be able to find out the table or the view name of where the data is being extracted from?

I'm sorry I do not have any details on the SMOD/CMOD.

Thank you!

Rebekah

RamanKorrapati
Active Contributor
0 Kudos

Hi sunil,

For any data source which starts with 2LIS*, for them you can easily find out the base tables thru LBWE(at source system).

Go to ECC system Tx - LBWE, go to respective application(Pink colour), select your data source, click on maintanance(Blue color), from that pop up, right side pools list, you will names starts with MCXXXX(Green color), here XXXX - indicates base tabels for that data source.

For yoru data source base table - AFIH, HIVG and structure MCVGIH.

Thanks

former_member182470
Active Contributor
0 Kudos

Hi Raman,

The screen shot what you have shown is to see the source tables for the fields which are available in the reserved pool only. Suppose if the developer is trying to populate from the different DB tables or customized tables, then the developer has to check either in CMOD or BADI for the table information.

Else, he can debug the extractor and get the same.

Regards,

Suman

RamanKorrapati
Active Contributor
0 Kudos

Hi suman,

Yes, suman, Above step for only to know the base tables of data source only. not to specific to fields

sunil said as no idea from where extraction was pulling data, so that's i gave above hint to know base tables info.

Thanks

Former Member
0 Kudos

Hi below is the printscreen I got from LBWE...i've already checked table AFIH and I am not able to find both fields here.

Thanks,

Rebekah

Former Member
0 Kudos

Hi,

I placed a debugger in FM MCEX_BW_LO_API and executed RSA3 for 2LIS_17_I3OPER datasource.

But I am not able to find the table name. Could you advice on which section in the FM will I be able to find the source table name?

Please advice.

TQ

Rebekah

RamanKorrapati
Active Contributor
0 Kudos

Hi sunil,

for enhanced fileds you can't find  source table at LBWE. i just said to how to know base tables for data source.

Your fields are enhanced,no logic maintained. so you won't find thru debug also.

You need get from user/tl. no clue to find source tables for enhanced fields if no logic at CMOD.

Ask your TL respective Technical specs.

Thanks

former_member182470
Active Contributor
0 Kudos

Hi Sunil,

Hope you understood what i said in my last reply. If you are not using the fields from the reserved pool, then definitely your new fields are designed to populate by either CMOD code or BADI.

You need to debug CMOD or BADI actually to get table level information but not MCEX_BW_LO_API.

You must take an ABAPer's help to debug. Debugging is a different skill wherein we need to have looked it before to get an idea on How to do? We can't make you to understand How to debug? It is an exceptional ABAP skill.

Instead of investigating so much on this, why don't you start from the begining? Enhance your LO extractor and follow the docs to write the code to populate it.

Regards,

Suman

Former Member
0 Kudos

Hi,

Even if I start from the beginning, I will still need to know from which table the values of those 2 fields are being extracted from before I can write te code to populate it.

Please correct me if I am wrong.

Thank you!

Rebekah

RamanKorrapati
Active Contributor
0 Kudos

Hi sunil,

Where there is no code at cmod, Debug option also useless(if no BAPI used for enhancement).

Yes, what you said was correct.

Your two steps aways to resolve your issue.

Get the base table from user or TL. implement the logic at SE38 - ZXRSAU01.

Thanks

former_member182470
Active Contributor
0 Kudos

Hi,

To know the table where this information is getting stored, you should contact your functional team. We are all technical people. Without knowing the functionality, we cannot work in any project. Please ask your superiors on the functionality. SCN is to guide you, you should not completely depend on SCN.

It's better you to close this thread and start working as per the suggestions.

Regards,

Suman

Former Member
0 Kudos

hi,

i guess those two fields were newly added to the extractor and logiv written in user exit.

As said above, try to see the data source in the exit and alayse logic from which table it is being extracted. first try to find the source table for the wo enhanced fields and logic written exit.

hope this helps.

Regards

Konda Reddy

Former Member
0 Kudos

Hi,

I've already checked and there are not exits written.

Thank you!

Regards,

Rebekah

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

former_member182470
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi,

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

Prathish

Former Member
0 Kudos

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

please help.

Former Member
0 Kudos

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

Prathish

Former Member
0 Kudos

Is it a standard datasource or a custom one?

Prathish

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

its a custome datasource

Former Member
0 Kudos

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

Former Member
0 Kudos

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

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Its by a function module MCEX_BW_LO_API

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

please advice.

TQVM!

Former Member
0 Kudos

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

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Prathish

RamanKorrapati
Active Contributor
0 Kudos

Hi Kumar,

There is no issue with extrcator.

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

Thanks

Former Member
0 Kudos

Datasource :     2LIS_17_I3OPER (Plant Maintenance Order Process)

ExtractStruct.     MC17I30OPR

Former Member
0 Kudos

Fields which are affected : ASTTX - Field displaying user status

                                       ESTAT - User Status

Former Member
0 Kudos

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

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

former_member213275
Contributor
0 Kudos

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.

Former Member
0 Kudos

its in a view called MC17I30OPR

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Are you getting values for the fields PRIOK & STTXT?

Prathish

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

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

Thanks,

Rebekah

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Prathish

Former Member
0 Kudos

here u go...

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

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

Please advice.

Thank you!

Rebekah

Former Member
0 Kudos

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

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Prathish

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

none found

Former Member
0 Kudos

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

RamanKorrapati
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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

RamanKorrapati
Active Contributor
0 Kudos

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

former_member182470
Active Contributor
0 Kudos

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