on 12-16-2014 6:23 AM
Hi Gurus,
I am trying to make a report on info object 0CUSTOMER. I need to pull address and telephone no in report. But I am unable to get way to pull Data from 0CUSTOMER. I check it is pulling by Data source 0CUSTOMER_ATTR.
These fields in 0CUSTOMER_ATTRIBUTE but not 0CUSTOMER. Could some one suggest me how could I use attribute values in Bex Query.
Thanks in advance.
Regards
Devesh
Add the required fields as Nav. Attr and do the mapping from datasource. After that right click on the associated infoarea and click 'insert characteristic as infoprovider' and give 0customer.
Now you can generate a report on it, drag and drop required fields in the report.
Regards,
Dilip.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The difference between display and navigational attribute is:
- display (you can use only for display)
- navigational (you can use for display and filtering,aggregating and so on).
So you don't need to create any navigational attributr to display the data.
Remember ! A display attribute is much faster that navigational one.
Regards, Leszek
Hi Devesh,
I am not sure if I understand your question correctly, but from what I understand, you can do following.
1. Open transaction RSD1.
2. Open Info-object 0CUSTOMER in RSD1 and go to tab Attributes (its the 5th tab)
3. check if the attributes you need to display are available in that tab.
4. If yes, then check the nature of those attributes. for e.g. Nav(navigational), DIS (display) you can change the their nature here itself in change mode
5. If no, then go to change mode and add the required attributes in this tab and in transformation add mapping for them
Now you should be able to see the required attributes in your query designer.
Also, as for pulling data from datasource 0CUSTOMER_ATTR, are there other datasourced for 0CUSTOMER apart from 0CUSTOMER_ATTR in your system?
if there are other sources and values from same shall be updated in 0CUSTOMER then check if the data load was performed from that source and attribute change run was executed or not.
As Datasource 0CUSTOMER_ATTR is one of the sources for 0CUSTOMER it is obvious that data in 0CUSTOMER and 0CUSTOMER_ATTR will be same where direct mapping is used.
Hope this helps.
-Swati.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am not sure if I understand it correctly, but if you create a report on top of your 0CUSTOMER master data then in BEx you will see all the fields which are present in that master data and not the data-source.
Map those fields that you need from the data-source to the Customer master data and that should be it.
Thanks,
Arminder
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.