Question Re: Extracting data from MARA table.... in Technology Q&A

Extracting data from MARA table....

Former Member — Mon, 14 Mar 2011 10:07:03 GMT

Dear Expert,

I am trying to extract data from MARA table by creating a view ZLAB to pull the data of LAB / OFFICE . But LAB/ OFFICE is available in MARA table only in 1st VIEW.

I am confused about the 1st VIEW of MARA table.

The Functional team told me to pull this data .

Is there any different procedure to Pull such data ?

Kindly suggest.

Thanks,

Sanjana.

Re: Extracting data from MARA table....

Former Member — Mon, 14 Mar 2011 13:38:56 GMT

how about using standard DataSource 0MATERIAL_ATTR???

Re: Extracting data from MARA table....

Former Member — Mon, 14 Mar 2011 17:23:18 GMT

Hi RB,

We are already using 0Material_ATTR data sources. I need particular 0LABOR from Material Master to add in a report. But its not visible directly. Its available in 1st view of MARA table ..

Any ided ??

Please suggest..

Thanks,

Sanjana.

Re: Extracting data from MARA table....

Former Member — Mon, 14 Mar 2011 18:55:02 GMT

by default it's part of 0MATERIAL_ATTR... I assume with 1st view of MARA, they mean the 1st view (Basic Data 1) of the material master (and 0LABOR is on that view)

Re: Extracting data from MARA table....

Former Member — Mon, 14 Mar 2011 19:13:59 GMT

Hello;

Use 0MATERIAL_ATTR datasource to pull data from MARA.

Check table ROOSFIELD for 0MATERIAL_ATTR is order to check if Labor is visible or not.

If not change the content of this table and make it visible.

Regards;

Ricardo

Re: Extracting data from MARA table....

Former Member — Tue, 15 Mar 2011 06:57:46 GMT

Hi Ricardo,

If I use 0MATERIAL_ATTR , won't there be any problem in old data as I will change the 0MATERIAL structer in BW side too.

I checked table ROOSFIELD for 0MATERIAL_ATTR , I found 2 entries

OLTPSOURCE OBJVERS FIELD SELECTION UNIFIELDNM STORNO F4TYPE F4EXTRAKTNOTEXRELKEYFLAG_DS

0MATERIAL_ATTR A LABOR Y 0

0MATERIAL_ATTR D LABOR 0

How to change the content, and what will be its effect over the old data in BW .

Thanks,

Sanjana.

Re: Extracting data from MARA table....

Former Member — Tue, 15 Mar 2011 11:07:24 GMT

as far as I can interprete that information it means that in the active version of 0MATERIAL_ATTR the field LABOR is actually already sent through this DataSource... as I wrote already before, it's default

Re: Extracting data from MARA table....

Former Member — Tue, 15 Mar 2011 12:40:32 GMT

Hello;

Usually to change this datasource I use this table.

Run &SAP_EDIT and you can change the content of the table (of course you need to transport the content of this table to the other systems to assume the differences).

Do this change:

OLTPSOURCE = 0MATERIAL_ATTR

OBJVERS = A

FIELD = LABOR

SELECTION = ' ' (blank).

With this your datasource will have already available the labor.

The consequences: If you want to upload historical labor you need to do a new init.

Advantage: If the customer change the labor to one material it will trigger a delta.

Regards;

Ricardo