Adding the SAP BW Hidden Field in the Extractor with help of Sample ABAP Code

[Former Member]

Adding the SAP Hidden Field in the Extractor with help of Sample ABAP Code (Cannot be done through RSA6 or RSO2

1 .I have taken an e.g. of an extractor name as 0FILA_002 in which I have to add the Field name as BP_USAGE (Billing Plan). I am not able to see the field in the Extractor as shown below

2.The Field is present in the Extract Structure as shown in below screen shot but not visible in RSO2 or RSA6.

3.  So we can go to ROOSFIELD table and check the Field for Information

4.Here in below screen shot the value is 'A' for field SELECTION means it is SAP BW Hidden so we can update the field with 'SPACE' or 'P' with help of ABAP Code so that it can get reflected in RSO2 or RSA6.

5.Below is a sample code which we can create in SE38 as Executable program to update the SELECTION field as 'SAPCE' or 'P' by replacing 'A'.

6.After activating the code we can press F8 to execute it and the following screen will occurred. Please fill the required entries in  CHANGE_P which is SELECTION Field which we have to update as ‘SPACE’ or’ P ‘as shown in F4 help.

7.Click the Watch or press F8 then it will display the ‘Successfully Updated ‘message as shown below. Here we have Set CHANGE_P(SELECTION) to ‘P’ .

8.Now we can see the required field name ‘BP_USAGE’ has been visible in RSO2 or RSA6 as shown below.

9.Below screen shows that in ROOSFIELD the value of SELECTION Field of BP_USAGE has updated to ‘P’ from ‘A’ through ABAP code.

Conclusion : So we can add the SAP BW Fields which are Hidden through ABAP Code as per the procedure for any datasource and then we can just replicate the data source in BW then the respected field will get avaiable in the particular extractor in BW side.