Extracting data from MARA table....

[Former Member]

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;

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

[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

[Former Member]

how about using standard DataSource 0MATERIAL_ATTR???

[Former Member]

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.

[Former Member]

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)