Enhance the Standard LO(logistics) Extractor.

This article explains about Enhancing the standard LO Extractor. There may be client’s requirement to add some of the fields to the LO Extractor. This document is intend to explain the steps in R/3 and not in BI.


Let me explain this with a scenario. Customer has requested to add Field ZBIDAT to BI Cube ZSD_C01. This field needs to be extracted from R/3 table VBAK field ZDATE. This cube is loaded using the standard extractor 2lis_11_vascl, but this extractor does not have ZDATE field in it.

In R/3 this field ZDATE in table VBAK is populated while creating or changing the sales order using the Standard sales order user Exit. Being this is a custom Field in table VBAK it cannot be pulled into Standard extractor 2lis_11_vascl using LBWE.

We need to add this field to the extract structure and use the SAP extraction user exit to populate the values and then map this to the new field ZBIDAT in Cube ZSD_C01.

There are some Steps which need to be followed before making Enhancements to the standard LO extractors. Click HERE to check.

Goto RSA6 Navigate to extract structure 2LIS_11_VASCL. On Double click on this Extract Structure.

 

 
 
 
 
 
 
 
 
 
 
 
 
 
Now Double Click on ExtractStruct ‘MC11VA0SCL’ to append the new fields.
 
 

Below is the screen showing the Structure of Data source 2LIS_11_VASCL.
 
 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Now Hit on Append Structure and create a new append structure called ‘ZBIAPPEND’ (Any name) as shown in below screen.
 
 

 
 
Add/Create fields to the structure.
 
 
 

 
Save and Activate the append structure. Now again come back to RSA6 and now get into changed mode of the Data source. Here you will find the newly created field. Make sure to uncheck the ‘Hide Field’ and select ‘Field Only’ and generate the data source using the menu button Datasource  Genarate.
 
 

 
 
Now you need to write logic to populate this newly created field.
You do this in the SAP user Exit.
Go to Program ZXRSAU01 ( In function module EXIT_SAPLRSAP_002) write below logic to populate the values.

 

 
 
You can check the new field values in RSA3 t-code. Enter the data source name and hit on Execute.
 
 

 
 
 
Once the records are extracted you need to hit on Display List and then select any single packet to list the values. Below is the screen showing the values populated in ZDATE.
 
 

This is how we can add a custom field to the LO extraction.
 
Thanks,
Chindam Praveen Kumar,
Blue Marlin Systems,
www.bluemarlinsys.com/bi