Datasource Enhancement- LO Cockpit

Posted by on






Adding new fields to the communication structure is called Datasource enhancement.

We have to append the standard business content data source 2LIS_11_VAITM with a field MTART ( Material Type ) from MARA table .


First check if the field that you need to enhance is available in the communication structure. If it is there

1. Deactivate the datasource in LBWE & clear the delta queue (RSA7)
2. Drag the fields from the pool.
3. Activate the datasource..
This scenario requires no coding to populate the enhanced field.

But in our case the field MTART is not in MCVBAK and MCVBAP. So now the option is to append the extract structure and write a code to populate that.



Steps..

Goto Tcode SE11


MCVBAK is communication structure of VBAK table








Save and Activate



Field is added to the structure...

Now if look in communication structure from LBWE maintainace...





Now we have to write a code to populate that

Goto Tcode SE37


Transaction data                exit_saplrsap_001

 Attributes,                         exit_saplrsap_002

 Texts                                 exit_saplrsap_003

 Hierarchies                        exit_saplrsap_004

In our case we are dealing with transaction data . so select  exit_saplrsap_001


Click on display...



Double click on include



Insert the following code


Tables : MARA .

Data : L_S_VAITM LIKE MC11VA0ITM .         *MC11VA0ITM - extract structure of DS

case i_datasource.
When '2LIS_11_VAITM'.
Loop at C_T_DATA Into L_S_VAITM .
L_TABIX = SY-TABIX .
Select Single * From MARA where MATNR = L_S_VAITM-MATNR.
If sy-subrc = 0.
L_S_VAITM-MTART = MARA-MTART.
Modify C_T_DATA FROM L_S_VAITM INDEX L_TABIX.
Endif .
Endloop.

Save and Activate Code..


Goto Tcode LBWE and add the new field to extract structure










Field Only should always be checked for enhanced fields...





Now do the Statistical setup run( filling of setup tables) from SBIW

and check in RSA3 for data...




Material type ( MTART)... the Enhanced field is available


Best SAP training in Kerala
Best SAP training in Kochi
Best SAP training in Ernakulam
SAP FICO, SAP MM, SAP SD, SAP PP, SAP ABAP, SAP Basis, SAP SAC, S4Hana

Comments

  1. AnonymousNovember 5, 2013 at 7:21 AM

    Hi Aslam,
    As I'm new to SAP BI ... I have one question on Data Source Enhancement. Above you showed very effectively how we do the data source enhancement for "Standard DataSource" and I'm very much clear. Please tell us do we have enhancement for Generic DataSource?.If yes and its different from std.datasource enahance ment...please put this topic in your blog in your style...Its really helps.

    Thank you in advance,
    Prado...

    ReplyDelete
    Replies
    1. Mohamed AslamMarch 2, 2014 at 10:16 PM

      Generic datasources are build by us... we can enhance it as per our need.. use RSO2 Tcode for that

      In above example, I have showed to enhance a communication structure ...

      Delete
  2. UnknownFebruary 4, 2014 at 11:12 PM

    Hi Mohamed,

    I have a question like.. the above process is to enhance a field(MTART) to the Sructure(MCVBAK).So what ever the data sources built on the particular stucture(MACBAK) will get disturbed right..?? If we want to enhance a filed to particular only datasource waht we need to do..??

    Correct me if im wrong..!!

    ReplyDelete
    Replies
    1. Mohamed AslamMarch 2, 2014 at 10:14 PM

      we can enhance the extract structure of the datasource for your requirement..

      For example , extract structure of 2LIS_11_VAHDR is MC11VA0HDR..

      you can enhance MC11VA0HDR and addyour new fields into that structure..

      all procedure is same..

      Delete
  3. UnknownApril 22, 2014 at 8:42 AM

    Hi Mohamed,
    Thanks a lot for the good work. A question please: Working on CRM interactive reports and want to enhance the leads data source to include PRODUCT and AMOUNT fields.This doesn't work in the interactive reports enhancement workbench.Any work around?

    ReplyDelete
  4. amzeJuly 2, 2014 at 12:01 AM

    Hi Aslam,

    Will this work for delta of that field.......because mainly there is problem with delta data when we enhance the datasource.

    Also is there any document for Enhancing COPA datasource by User Exit and will it populate delta for the enhanced fields.

    ReplyDelete
  5. UnknownSeptember 2, 2015 at 10:18 PM

    Dear Aslam,
    I'm new to Bi .so when coming to enhancements their are 2 approaches USER EXIT & BADI can u explain them clearly please

    ReplyDelete
  6. AnonymousOctober 25, 2016 at 12:36 PM

    Great Document.

    ReplyDelete
  7. UnknownDecember 14, 2016 at 10:48 AM

    Hi,

    I have a small doubt which we faced recently for this type of Enhancement. We have done the enhancement but whatever the fields we are adding to append structure of that particular LO datasource, it will automatically revert back. Could you please us in this case. Why it is happened like that?

    ReplyDelete
  8. UnknownDecember 14, 2016 at 10:52 AM

    Hello Experts,

    Need your small help, I have done a small enhancement at LO data source using the append structure. But the problem is after some time changes will revert back automatically in ECC system.

    Could you please help to understand this?

    Thanks in Advance!!

    ReplyDelete
  9. UnknownOctober 19, 2018 at 9:01 PM

    what are prerequisites for extracting enhanced datasource in bw? If everything is working fine in ECC (the appended structure, rsa3 extraction, etc.)

    ReplyDelete

Post a Comment