Trouble using Generic Extraction from table MBEW

[Former Member]

Hi all,

I need to extract Standard Price and Price unit from the MBEW table.

I tried creating a generic extractor to extract data from MBEW table. When I did that, I received an error stating " Invalid Extract Structure template MBEW of data source Z_generic_MBEW (this is the name I had given to my datasource".

I tried creating a view for the table. It did not help either. Could some one help me with this problem.

Regards,

Sumana

[Former Member · Accepted solution]

I did create the view for the table but did not include the unit of measure.

So this might be the reason why the datasource was giving me an error.

Thanks for your help Viren, A.H.P and all.

Regards,

Sumana

[former_member188975 · Accepted solution]

Hi Sumana,

See if this datasource is useful for you:

http://help.sap.com/saphelp_nw04/helpdata/en/22/1b383fdb800804e10000000a114084/content.htm

Hope this helps...

[Former Member]

Hello Sumana,

MBEW table does not have UOM. Standard Price is maintained on Base UOM. You may have to create a view of MBEW and MARA to get the BASE UOM too.

Hope it helps.

Viren

[Former Member]

Hai Sumana,

You should be able to create a view on this table. Do you have details of the error or can you explain details of what oyu did?

Did you do these?

1. Create a view with "database table" selection

2. In tables/conditions enter the table name MBEW

3. Slect the fields you want to select in view fileds tab.

4. Make sure you have a data fields if you want to go for delta.

5.then create a generic extractor with the view..

may be you did all the above... please give me some more information.

Thank you.

[edwin_harpino]

hi Sumana,

if you use quantity/amount with currency/unit of measurement, you have to included the currency/unit of measurement fields in your view, and put on table reference with the view itself with field the currency/unit.

hope this helps.

[Former Member]

Hi Sumana,

Probably you have inserted in DS some fields without the corresponding Unit of Measure. Look in Tab Unit of Measure the corresponding Unit you need for the field you want in the DS.

Hope this help.

Ciao.

Riccardo.