Enable the selection options for the data source fields (more than one field at a time) in the extract structure through customized program

Enable the selection options for the data source fields (more than one field at a time) in the extract structure through customized program

By Anusha Vupalapathi, Target India

Summary:

This document describes step by step procedure to enable the selection options of the data source fields in the extract structure using a custom program. The input variables are data source name and respective fields (more than one field at a time).  

Taking an Example:

Let us take data source 0CUST_SALES_ATTR as an example  

No. of Fields in the Extract structure BIW_KNVV_S is 61.

RSA6, Display of the data source 0CUST_SALES_ATTR as with the fields in present in it.

ROOSFIELD is the table where the data source fields are maintained. Depending on the value of the Field SELECTION we can identify whether a selection with a field is possible or not.  

The value for the field SELECTION of the table ROOSFIELD for the fields which are not visible in the

Data source is maintained as ‘A’.

 

If a request for a Datasource is scheduled in BI, selection conditions can be defined for certain fields. The property that defines whether a selection with a field is possible or necessary in BI is defined in the Datasource in the source system.

In addition, you can define the visibility of the field in BI: a field that is not visible (that is hidden) cannot be transferred to the transfer structure.

The field property also defines whether the customer can change the properties Selection and Transfer in Datasource post-processing.

Meaning of the values:

• 'A': Field hidden in OLTP and BI; property cannot be changed in Datasource post-processing

• 'M': Datasource needs a selection with this field in order to extract data (required field for generating a request); property cannot be changed in Datasource post-processing

• ' ': Datasource cannot select with this field; visibility can be changed in Datasource post-processing (field is currently visible, see '4')

• 'P': Datasource can select with this field; selection and visibility can be changed in Datasource post-processing (field is currently visible and cannot be selected, see 'X', '3')

• 'X': Datasource can select with this field; selection and visibility can be changed in Datasource post-processing (field is currently visible and can be selected, see 'P', '3')

• '1': Pure selection field of the Datasource; selection, but not visibility, can be changed in Datasource post-processing (field cannot currently be selected, see '2')

• '2': Pure selection field of the Datasource; selection, but not visibility, can be changed in Datasource post-processing (field cannot currently be selected, see '1').

• '3': Datasource can select with this field; selection and visibility can be changed in Datasource post-processing (field is currently not visible and cannot be selected, see 'P', 'X')

• '4': Datasource cannot select with this field; visibility can be changed in Datasource post-processing (field is currently not visible, see ' ')

Steps to enable the selection options for the data source fields (more than one field at a time) in the extract structure through customized program.  

We are going to enable the fields BEGRU (Authorization Group) &ERDAT (Date on Which Record Was Created) of the Datasource 0CUST_SALES_ATTR.  

Steps to be followed:

Create a program through the transaction SE38.

Program code

Write the below code in the program. Activate it and then execute.

Execute the program with the following input.

Datasource: 0CUST_SALES_ATTR

Fields: BEGRU and ERDAT.

Press F8.

 

After execution you would see that the value of the filed selection has been changed from ‘A’ to ‘P’.  

 

Go to RSA6 and find the data source 0CUST_SALES_ATTR and select Change.

  

Put a check in the checkbox Selection if you want it to be a part of the selection in RSA3 and in the Info package and Generate the data source.