Extracting data from MARA table....

[#1]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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