Skip to Content
Author's profile photo Former Member

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

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.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      How do you populate this field? As per SAP if any field is not visible in RSA6 and available in extract structure then there is no code written by SAP to populate such field and that is the reason it's not visible. By making it visible may not serve the purpose completely..

      Author's profile photo Former Member
      Former Member

      Hi Mohan,

      As it is a standard field we dont have to code for it the values will get populated for that.



      Author's profile photo Former Member
      Former Member

      How would you transport a change like that to your other environments (QA, prod, etc)? Would you have to run the program and change the ROOSFIELD table entry?

      Author's profile photo Former Member
      Former Member

      In the Select Single, as your parameter "change_p" is the value you want the field to take, it should not be part of the select single, because the field "SELECTION" has not that value yet, no? (In your example the initial value is `A` and you turn it to `P` ).

      But I might be wrong...

      Author's profile photo raju gudikandula
      raju gudikandula

      Thanks for sharing the solution 🙂