ROOSFIELD: standard SAP DataSource 0MAT_PLANT_ATTR several fields are hidde

[Ebret]

Hello,

In standard SAP DataSource 0MAT_PLANT_ATTR several fields are hidden in ROOSFIELD:

- BSTMI

- BSTFE

- BSTRF

- MINBE

How can we remove the field attribute "A" of the field name SELECTION?

Have we to ask SAP key to allow maintenance on table ROOSFIELD?

I could find OSS SAP Note Number: 944039 (Export DataSource is not adjusted (cube))

-The field list of an export DataSource is not extended if InfoObjects are added to the source cube. The new fields are not displayed (SELECTION = 'A'), even though they are located in the metadata tables (ROOSFIELD).

-Solution: Implement the note and regenerate the export DataSource. The new InfoObjects are then available for extraction.

This support package is already installed in this system.

Have we to regenerate the export DataSource to solve this issue?

Thank you

Best Regards,

Emmanuel Bret

[Former Member]

Kindly check your system whether its maintained as content system. Check with transaction RSAO and choose the checkbox so that the system will be set as content system. After that what changes you do it will accept and not hide the fields.

[former_member195940]

Hi

Below is the step by step document... you have a sample ABAP program also..

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/c008cd97-ef00-2d10-d1ad-867b9c3f063c

Hope this helps

Thanks

Kalyan

[Former Member]

HI

Here is the sample code:

REPORT ZBI_ROOSFIELD NO STANDARD PAGE HEADING .

tables ROOSFIELD.

Update ROOSFIELD set SELECTION = 'X' where

OLTPSOURCE = '0CUST_SALES_ATTR' and

FIELD = 'FAKSD '.

U need to change accordingly.

Thanks & Regards

Deepak Chavan

[Former Member]

You can do that using a small ABAP code.

Just check the belwo stuff...................

When a field added to the Data Source is not visible during data source enhancement.

Notes:

Properties of a Data Source Field:

If a request for a Data Source is scheduled in the BIW, selection conditions are specified across certain fields. The property that determines whether a selection in BW using a field is possible or required is established in the Data Source in the Source System.

In addition, the visibility of the field in BW can be set.

A field that is not visible (or that is hidden) cannot be transferred into the transfer structure.

Definition of the individual values:

u2018Au2019: Field is hidden in OLTP & BW, property cannot be changed by the customer.

u2018Mu2019: The Data Source requires a selection across this field before it is able to extract data (required field for the generation of a request); property cannot be changed by the customer.

u2018Xu2019: The Data Source can select across this filed. The customer can change selections & visibility (the filed is currently visible & selectable, compare with u2018Pu2019, u20183u2019)

u20181u2019: Pure selection field for the Data Source. The customer can change the selection, but not the visibility (the field is currently selectable, compare with u20182u2019).

u20182u2019: Pure selection field for the Data Source. The customer can change the selection, but not the visibility (field is currently no selectable, compare with u20181u2019).

u20183u2019: The Data Source can select across this field. The customer can change selection & visibility (the field is currently not visible, not selectable, compare with u2018Pu2019, u2018Xu2019).

u20184u2019: The Data Source cannot select across this field. The customer can change visibility (the field is currently not visible).

Procedure to make a field visible:

In SE11, execute the table ROOSFIELD. Give the Data Source name and the field name which is not visible. Execute and see. The status in the output will be displayed as u2018Au2019.

Now create a custom program in SE38.

Write the following code.

REPORT ZTEST_ROOSFIELD.

TABLES: ROOSFIELD.

UPDATE ROOSFIELD CLIENT SPECIFIED SET SELECTION = u2018Pu2019

WHERE OLTPSOURCE = u2018<Data Source name>u2019

AND OBJVERS = u2018Au2019

AND FIELD = u2018<Field to be made visible>u2019.

WRITE SY-SUBRC.

After executing this program, you once again execute to see the out put of the table ROOSFIELD by giving the Data Source and field name. Check the status of the field. It must be changed from u2018Au2019.

Now go to the Data Source and the field should be visible.

Notes:

u2018Au2019 u2013 Field is not visible in the data source maintenance even after addition of the field in the extract structure. (Field in OLTP and BW hidden by SAP).

u2018Mu2019 u2013 Field is selected by default and cannot be hidden. Example: Object version. (Selection Required, Visible)

u2018 u2018 u2013 Cannot select or hidden (No selection possible, visibility set)

u2018Pu2019 u2013 Both the selection and hide check boxes are enabled (Selection adjustable, visibility set).

u2018Xu2019 u2013 At first the selection box is selected. The check box can be removed and saved. Then returning to the data source will enable selection and hide check boxes (Selection adjustable, visibility set).

u20181u2019- Pure selection field, selection set. Can uncheck the selection field but cannot be hidden.(Pure Selection field, selection set)

u20182u2019 u2013 Same as above

u20183u2019 u2013 Selection Adjustable, visibility adjustable, by default hidden will be selected.

u20184u2019 u2013 No selection possible, Visibility Adjustable.

[Former Member]

Hi Venkat,

If you update SAP table ROOSFIELD using program...

Will there be any problem for Delta extraction of that Datasource??? Or it will be taken care automatically by SAP???

Or Is there any need to write some user exits to fill up the fields for which we have changed the Properties of a DataSource Field from 'A' to blank or something else???

Is this applicable for transaction data sources as well???

Thanks in Advance!!!

Regards,

Rangz