Finding data in a datasource/ Business Content Query

Advertisement
Hello,
can you help me with this one -- background to this problem is shown below:
Question:
1.
No data was found in my infocube so I went o R3 to see if the datasource had any data in it by running rsa3 but found no datasource 2LIS_02_S012, although rsa5 shows that it exists. What could be happening?
2.
Also, how do I see the queries which come with the InfoCube? When I go into BEx, I see the dimensions to create my own queries, but where are the ones which comes with the Business content for me to use?
Background to Questions----
I was experimenting with an MM InfoCube 0PUR_C01, and my research indicated that the datasource which supplies this this infocube with data is 2LIS_02_S012. The notes on this datasource indicates it could be extracted as a standard extraction or LO. I did standard, rsa5, rsa6, etc...replicated in BW, etc.
I later created and InfoCube zpur_c01 and copied from 0pur_co1, etc. ...then later created and infopackage and loaded data into the InfoCube for the purposes of reporting.
Advertisement

Replay

Hi Caud,
To answer your first question.
- The datasource 2lis_02_s012 that you have seen in rsa5 is in the delivered version you need to transfer this into the active version. Select the datasource in rsa5 and click the transfer datasource button. After you have done this you will see the datasource in rsa6.
Also since this datasource is a Logistics Info Structure the LIS reporting should have been activated and in use.
For your second question
- If you have already identified a standard business content query that you want to use through the metadata repository, you can activate the report through the business content tab in rsa1.
Hope this helps.
Regards,
Demetrius

Error While Installing the Business Content Query

Dear Friends, We are in BI 7.0 and trying to install a business content query "Balance Sheets Profit and Loss Statement" but while activating we are getting the error that some Particular Request has not been found or not suitable. we checked fo

Error in Business content Query

Hi, we have activated the business content for General Ledger (New). We have successfully executed all data loads. but, the standard query 0FIGL_V10_Q0001 which is activated, is not executing properly. It throws up a message "Value '0' is invalid for

How to find the standard queries in business content

hi pls explain how to find the standard queries in a business content assign full pointsHi, Incase you want to know details about the standard queries, then the best source would be the help documenations on BI content: http://help.sap.com/saphelp_nw

Error During Business Content Query Activation- Very Urgent

Hi All, I am trying to install few queries in business cube 0pur_c01, which is already in production and already lot many queries are running. As per requirement i have to install  New quries in the 0Pur_C01 0PUR_C01_Q0012 : Ordering Activities 0PUR_

Underlying tables of business Content data sources

Hello Exerts, Can anyone advice me finding the underlying tables of business Content data sources? Regards.Hi, I dont think that there is any standard tcode or table to find out the underlying base tables. But you can try the below mehtod to to find

MM Business content: Reservation

We are going live this month but user just raised a query. They want to do the analysis based on reservation and good issue (against reservation)items too. Pls advise, where we can find reservation information in MM Business content? AlokYes, I am ta

Documentation for Business Content Rapid Marts Reports for SAP R/3

Hi, As we have technical documentation for SAP BI business content BI reports on SAP HELP Portal, is there any link where we can find the technical documentation for business content reports supported by SAP BOBJ Rapid marts for R/3 solution like for

How to find information from a field in R3 to get it in Business Content

Hi all, my case is this: i want to learn how to get or struct a model in BW, for example, my task is make a query where the client wanna get information , and he told me the fields, ok, in R3 i got the name of the field (NODISCONCT), the struct (EANL

Enhance business content Data Source

Hello BW Gurus,   Please let me know step-by-step (Detailed) procedure on how to enhance the Business Content Data source Actual Time and Labor Times <b>0HR_PT_2</b> http://help.sap.com/saphelp_nw04/helpdata/en/4b/26c5394dbfef35e10000000a11402

How to change Selection Criteria for a Business Content Data Source

Hi Experts I am extracting data using 0CO_OM_CCA_9 Datasource. I would like to be able to select a range of Company Code (BUKRS) to pull in, but I cannot find a way to make certain fields available as selection criteria. When I go into "Change DataSo

Active transactional datasources not listed in business content collection

Dear experts, for SRM bidding engine i have activated the extractors in SRM through transaction RSA5 and put them on a transport. Replicated them in BW and their they are appearing correctly, activated them and provided infopackages. Now when i want

Business content 3.30: Datasources not available for installation

Hello, we have recently upgraded our business content from 3.10 to 3.30 in order to get new business content (e.g. datasource 2LIS_13_VDKON - billing item pricing conditions). Although the upgrade was successful, the new datasources cannot be found i

Can't find an InfoObject but it is activated from Business Content

Hi When I review the Business Content component on the left hand side for the objected type InfoObject 0HIER_NODE, it is activated. But when I try to find it from the InfoObject component on the left hand side or RSD1, it is saying that the 0HIER_NOD

Business Content and Data Sources automatic binding

Hi, I am not clear about the Data Sources and Business Content sync. If I transfer the datasources in SBIW(RSA5)  and replicate in BW, how it will automatically bind to the infosources and data targets when we activate the relevant infoobjects in BW

BOM (Bill of Material) Master Data  in Business Content?????

Hi all, Any idea about standard business content data source which contains the BOM - bill of materials data..... Best Regards, NavinHi Navin, Check these links: Re: Extract BOM data from R/3 to BW Re: Loading Bill of Material Bye DineshRead other 2

Adding a custom meta data field which lists out content id based on query

How can we add a custom meta data filed which lists out content id based on query like dDocType <matches> `AssociatedProduct`? Or other alternative would be to have a custom metadata field such that it allows selection of content id using link wizar

In which table in CRM can i find data in business activity details?

Hi In which table in CRM can i find data entered in business activity details in opportunity transaction. Please advice . Thanks, Vaishnavifound the table name CRMD_Activity_HRead other 2 answers

Unable to find data in RSA3 for particular fields2lis_04_p_arbpl datasource

I am working with datasource 2lis_04_p_arbpl to construct Yield Report. I have a field GAMNG(Target Quantity) in the table AFKO, so I added it to the communication structure and activated it. I also want the field IGMNG(confirmed quantity) which is a

Business content data source for  BP Product (De)Authorisations & Terminate

Hi Experts...... Good evening!!!.. I do have one requirement for which im not getting any business content ds. Could you pl help me out in that ? My requirement is like below. Report is extracting SAP CRM contracts data: u2022     This report lists t