on 07-12-2013 4:54 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
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
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 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.
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 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 :
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
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
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
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
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.