Fields in extractor with no values

[Former Member]

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

[former_member188080]

    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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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