Question Re: data source for MBEW in Technology Q&A

data source for MBEW

Former Member — Mon, 24 Aug 2009 11:45:20 GMT

hi,

is there any data source for TABLE : MBEW ? or do i have to create a generic data source for this

Re: data source for MBEW

Former Member — Mon, 24 Aug 2009 14:42:36 GMT

Dear,

It is data source of Inventory management... This table data we can extract through 3 datasources... please check it out your individual fields going in system......

2LIS_03_BX: stock tables, MCHA, MARA, T001, T001W, CALCULATED FROM MBEW, EBEW, QBEW.

2LIS_03_BF: MSEG, MBEW, MKPF.

2LIS_03_UM: BKPF, MBEW, QBEW, EBEW, BSEG.

Regards,

Mahesh

Re: data source for MBEW

Former Member — Mon, 24 Aug 2009 16:05:01 GMT

Hi,

Inventory management datasources(2LIS_03_BX,2LIS_03_BF,2LIS_03_UM,0RT_RMA_MBEW_TRAN) are extracting data from this table.

refer these help.sap links- http://help.sap.com/saphelp_nw70/helpdata/en/ed/16c29a27db6e4d81a015be8673eb80/frameset.htm

http://help.sap.com/saphelp_nw70/helpdata/en/ed/16c29a27db6e4d81a015be8673eb80/frameset.htm

Re: data source for MBEW

Former Member — Tue, 25 Aug 2009 02:19:56 GMT

Hi ,

We use this talbe data to calcualte MAP or WAC in BW.

for this we created a generic extractor based on view. we created a view on top of MBEW and a Ztable (for units ).

Hope this helps.

Praveen

Re: data source for MBEW

Former Member — Fri, 16 Oct 2009 09:47:03 GMT

Hi,

in my ECC6 system, datasource 2LIS_03_BX, 2LIS_03_UM, 2LIS_03_BF are empty.

How can i activate them ?

Thanks,

Karol

Re: data source for MBEW

Former Member — Fri, 16 Oct 2009 09:58:12 GMT

Hi,

The DataSources delivered by SAP with the BI Content and any DataSources delivered by partners or customers in their own namespace are available in the delivery version (D version) in the SAP source system. If you want to transfer data from an SAP source system to a BI system using a DataSource, you must first copy the data from the D version to the active version (A version) and make it known in the BI system.

Use these steps to activate standard data sources.

1.To transfer and activate a DataSource delivered by SAP with Business Content, in transaction SBIW in the source system choose Business Information Warehouse à Business Content DataSources or Activating SAP Business Content àTransfer Business Content DataSources.

In The following figure displays the DataSources in an overview according to the application component.

2.Select the nodes in the application component hierarchy for which you want to transfer DataSources into the active version. Do so by positioning the cursor on the node and choosing Highlight Subtree.

The DataSources lying under the subtree and other subtrees are selected.

3. To check for differences between the active and delivery versions of the DataSources, choose Select Delta.

DataSources for which differences were found in the check (for example, due to changes to the extractor) are highlighted in yellow.

4.To analyze the differences between active and delivered versions of a particular DataSource, select the DataSource and choose Version Comparison. The application log contains further information regarding the version comparison.

5.To transfer a DataSource from the delivery version into the active version, select it in the overview tree using the button Highlight Subtree and choose Transfer DataSources.

If an error occurs, the error log appears.

Regardless of whether data has been successfully transferred into the active version, you can call the log by choosing Display Log.

6.To provide the active version of the DataSource in the connected BI systems and to enable data extraction and transfer, replicate the DataSource(s) with a metadata upload to the BI system.

Regards,

Shiva.

Re: data source for MBEW

Former Member — Fri, 16 Oct 2009 10:29:37 GMT

Hello!

you need only 0CO_PC_ACT_05 datasource with 0CO_PC_01 ODS from business content.

Re: data source for MBEW

Former Member — Fri, 16 Oct 2009 10:37:14 GMT

Hi,

The table MBEW is Article Valuation and there is no particular datasource with this table. In general standard datasources are combination of tables.

If you want to get only data from the table MBEW, you have to go for generic datasource in RSO2 only.

Regards,

Rama Murthy.