Archived discussions are read-only. Learn more about SAP Q&A

Properties of datasource, ROOSFIELD-SELECTION difference between X and 3

Hi,

Can someone explain what P means when it is referred in comparison for the value X and 3 for field selection in the ROOSFIELD table?

Properties of a DataSource Field

If a request for a DataSource is scheduled in the Business Information Warehouse, 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 DataSource 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:

'A': Field is hidden in OLTP and BW, property cannot be changed the customer.

'M': The DataSource 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

'X': The Data Source can select across this field. The customer can change selections and visibility (the field is currently visible and selectable, compare with 'P', '3')

'1': Pure selection field for the DataSource. The customer can change the selection, but not the visibility (the field is currently selectable , compare with '2').

'2': Pure selection field for the DataSource. The customer can change the selection, but not the visibility (field is currently no selectable, compare with '1').

'3': The DataSource can select across this field. The customer can change selection and visibility (the field is currently not visible not selectable, compare with 'P', 'X')

'4': The DataSource cannot select across this field. The customer can change visibility (the field is currently not visible, compare with ' ')

Thanks,

raj

Not what you were looking for? View more on this topic or Ask a question