Current Position:Home > Modifying Standard Data Source

Modifying Standard Data Source

Update:11-30Source: network consolidation
Advertisement
Hi All,
           I am using standard data sources in CRM (0crm_oppt_i and 0crm_oppt_h).I need to modify these standard DS by adding some field in Extract structure.Can any one please provide me detailed step by step approach for doing this.If there is any code to be written can anyone send a skeleton of that code .Please provide detailed approach as I am new to this BW aspect.Thanks in advance.
Regards
Souresh

The Best Answer

Advertisement
Hi sarkar
yes you have to write an ABAP code to fill the data in the newly added field in the extract structure.
1)Go to RSA6 and find the data source you need to enhance.--> Display
2)Double click on the Extract structure.
3)Now click on the append structure button to add the required field on to the existing structure.
4) add your required fields with ZZ appended to your field.
5) Save & Activate the append structure. Then go back and make sure you activate the extract structure also.
6) Now again go back to RSA6 and select your Data Source. But this time go to change Data Source to remove the hide option to the enhanced fields. By default they’ll be in hide mode. If you don’t remove the hide field then this field will not be seen in BW side.
7) Now go to SE38 to write the logic to populate the data into the enhanced field. Program name to write the logic is ZXRSAU01.
8) Check + Save + Activate.
9) Check in RSA3 if data is populated as per your requirement.
10) Replicate your Data Source.
11) Now go to Data Source/ Trans. Structure screen. Now you can see the enhanced field on the right hand side.
Go to CMOD.
1. To  Save give Description  createcreate new project—give the project name
2. Select the radio button Enhancement Assignment and give the Enhancement name you want and press Enter.
3. If the Enhancement is already assigned to some other project it will display the same message saying it is already assigned it some other project.
Click on4. If the Enhancement is not assigned to any project save.
5. Give RSR00001 (For Variable Exits)
6. Activate the Project.
7.  and click on the components button.Now go to Display
8. Now Double click on EXIT_SAPLRRS0_001. In that you can see an include ZXRSRU01.
9. Double click on that include, it will say program name ZX…… are reserved for includes of exit Functions groups.
10. Just Press Enter.
11. It’ll Pop-Up a window  Create Object.saying Include ZX…. Does not exits
modify according to your requirements.
Hope it will help u.
Thanks & Regards
KK
  • Modifying Standard Data Source Update:11-30

    Hi All,            I am using standard data sources in CRM (0crm_oppt_i and 0crm_oppt_h).I need to modify these standard DS by adding some field in Extract structure.Can any one please provide me detailed step by step approach for doing this.If there

  • ABAP code to enhance a standard data source Update:11-30

    Hi BW experts, I am a novice in BW and I need to append a standard datasource <b>0DAT_SRC</b> with a field <b>FLD1</b> from table <b>TABL1</b>.Extract structure: <b>EX0001</b>. Can anybody please suggest how

  • Standard Data Source for FMGLFLEXT Table Update:10-11

    Hello Friends, The standard data source for the Financials New Legder is 0FI_GL_10 General Ledger: Leading Ledger Balances, which fetches the data from the FAGLFLEXT Table using the Extract Structure FAGL_EXTSTRUCT_LEAD. However there has been a migr

  • What is a Standard Data Source for table T006A? Update:10-11

    Dear Experts, As a part of one requirement I need to pull the data from Table T006A which is available in BW as well. I did many search on forums before posting the same but didnt get clear idea. I am aware how Units are being updated withing BW but

  • Single Standard data source which extracts material master and vendor master data Update:10-11

    Hi all, I have a client requirement where user wants to view material master and vendor master in a single report. Is there any standard data source which extracts both the data together.. Thanks! ArvindHi, Two are different master info objects and c

  • Standard data sources for Delivery and Purchase order quantity. Update:10-11

    Hi gurus , Are there any standard data sources available for Delivery and Purchase Order quantity in Purchasing area . Thanks in advance .Hi, If you are looking for SD Scenario: Check this : https://websmp201.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_

  • STANDARD DATA SOURCE 2LIS_11_VAHDR NOT GETING DATA Update:11-30

    RESPECTED GURUS I AM A NEW BI USER. I AM TRYING TO EXTRACT DATA FROM 2LIS_11_VAHDR WHICH IS A STANDARD DATASOURCE THROUGH RSA3, BUT I AM GETTING A MESSAGE "0 RECORD FOUND" BUT THERE ARE PLENTY OF DATA. I WAS TRIED WITH THE OTHER STANDARD DATA SO

  • Not able to Find  Some BOM Related  Standard Data Sources in  PP. Update:11-30

    Dear Gurus,      I am not able to find the Standard Data Sources for Loading the Master Data for the Following Standard Info Objects 1. 0BOM 2. 0COMPONENT 3. 0HG_LV_ITEM      I have activated the objects in BW side, but not able to find the data sour

  • Need Standard Data Source Name Update:11-30

    Hi Experts, I am very new to this Technology...... Anyone pls tell the Standard Data Source Name Which is having fileds like Shipping Address, Shipping City, Shipping State....... Thanks in Advance. Thanks; SrinivasSrinivas, I believe this informatio

  • Modifying ALDSP data source end points programmatically Update:11-30

    I can see how to manually modify ALDSP data source end points through the ldconsole: http://edocs.bea.com/aldsp/docs21/admin/server.html#1042064 but is there any programmatic way to do this? For my purpose, it would be adequate if there were some Ant