Steps to Extract data from Source System

11-30  Source: Network gathering  Views:0 

Advertisement
Hi,
I want to use business content object 0PA_C01. I have implemented it in the SAP BW system wanted to know how t=do I extract the data from R/3 system now to the cube. I am new to extraction so kindly help me out in this.
Thanks.
Hi SAPBILearner,
Genric Extraction Steps:
1) In R/3 side Create a Data source by use of RSO2 tcode
Select datasource type here, Give datasource name click create button
2) Specify description
Specify your table name
Choose the Application Component(like SD, MM, PP)
Click SAVE it takes to next screen
3) Choose the fields for visible and hidden
SAVE it.
Your datasource has been created
4) In RSA3 (Extract Checker) you can check your datasource it contains data or not
IN BW SIDE
1) First Replicate your datasource
2) Create InfoArea--> Info objects and all
3) Create InfoSource and assign this R/3 Datasource
4) Create info package to load data.
LO EXTRACTION STEPS
===================
1) In R/3 side, First delete the setup table (LBWG)
2) RSA5 --> transfer datasource
3) RSA6 --> Verify transferred datasource available or not
4) LBWE --> Maintain datasource
5) OLI*BW --> Fill setup table
6) RSA3 --> Extract checker
In BW side
1) Replicate datasorce
2) Asssign Infosource , activate datasource
3) Create infopackage to load data
Thanks
Mrityunjay
Related articles
  • Steps to Extract data from Source System 11-30

    Hi, I want to use business content object 0PA_C01. I have implemented it in the SAP BW system wanted to know how t=do I extract the data from R/3 system now to the cube. I am new to extraction so kindly help me out in this. Thanks.Hi SAPBILearner, Ge

  • Error in Process Chain while extracting data from source system 10-11

    Hi All, Dail we are facing problem while retrieving the data from source system for the data source 0TB_AMOUNT1 in the process chain, it is giving error "Function module BANK_TMC_API_SIM_GET does not exist Furnction module". when I repeat the st

  • Error occured in the data selection while extract data from Source system 10-11

    Hello Friends i am facing Problem while extracting data to Biw System from SAP R/3 system The error mesage is 'Error occured in the data selection ' i.e. Monitoring - Details tab - Extraction - With errorHi The delta wil take the Last init selection

  • Error during extraction data from APO system 11-30

    HI Gurus, We are extracting data from APO system at regular intervals. As poart of business requirement, we enhanced the data existing data source in APO dev system and replicated the same in BW dev system and activated the Tx structure and Tx rules.

  • How to  upload Transaction data from source system to BI 7.0 11-30

    Dear friends, I want to know how to  upload Transaction data from source system to BI 7.0. if anybody having step by step material for this process ,please send it to my mail id. [email protected] [email protected] Thanks, D.prabhuHi, it works in the

  • BO DI for extracting data from legacy system to SAP BW 7.0 10-11

    Hi, Has anyone worked on scenario where BO Data Integrator is being used as ETL tool for extracting data from legacy systems to SAP BW 7.0 ? Please share your experience on such a landscpae or related documents any of you had come across. Regards, Pr

  • Steps to extract data from teradata to bw 10-11

    steps to extract data from teradata to bwThank you Roberto and Jerome! 1.as per my knowledge my client has teradata datawarehouse on oracle database is it possible. and also can he use cognos for reporting? 2. now teradata data can be only extracted

  • How to extract data from legacy system to source file 10-11

    Hi can anyone tell me the procedute to copy data from legacy system to source files....this data needs to be moved to base tables can any one tell me the procedure and any sample code i,e any example Thanks & Regards KrishYou should post your thread

  • Error Occures while loading data from Source system to Target ODS 11-30

    Hi.. I started loading Records From source system to target ODS.while i running the job i got the following errors. Record 18211 :ERROR IN HOLIDAY_GET 20011114 00000000 Record 18212 :ERROR IN HOLIDAY_GET 20011114 00000000 sp Please help me in these f

  • File-File - Need to extract data from source file name??? 10-11

    Hello Experts, I have a unique situation. In my file to file scenario, the source file name is of the format XYZ_yymmddHHMM.dat. there is field in the target file which has to filled with the date that is there in the file name of the source file (yy

  • Transfering data from source system to bw 10-11

    I am sending data from two source systems into single data target in bw. For ex:- think that there are KPI's in the first source system & another 4 in the second source system.When i load it into bw i should see the 8 KPI's in a single record is it p

  • Extract data from source table in ODI 10-11

    Hi, I am using ODI to transfer data between Oracle table to a flat file. Source database is very huge and has many partitions within that. In ODI can we extract the data using the partitions ? I want to have data from some partitions of that table, i

  • How to extract data from Oracle system 11-30

    Hello, I have a project to load data from an external Oracle system. (I familiar with loading data from SAP source systems). Can anybody explain to me what is the procedure to load data directly from Oracle or to send me some links and explanations a

  • Extracting data from SAP system using Shared directory 11-30

    Hi, sapian.        I need the detail steps about creation of data store for a sap system in BODS for extraction of data in Direct download method.Can any of you suggest me the steps about it. I need the details about Application server: Working direc

  • How to extract data from a remote system 10-11

    Hi, I want to extract data from another system and map it with a target table in my local machine. what is the procedure to do that? I tried to create another module specifying location of that remote system I could extract the table but when I am ma

  • No data in source system 10-11

    Hi at all, I extrakted initial data from source system and get a      warning "No data in source system". I checked the system and it is ok. Plz help meHi Yep ,,, if u do and delta after Init ...the records it will fetch is 0records IF there are

  • Different aspect to extract data from SAP retail. 11-30

    Hi Gurus,       I will working on SAP retail system , including SAP retail/POSDM,  please tell me how to extract data from those systems, is it different from  the way to extract data from SAP ECC , eg SD/FICO etc? Many Thanks,Hello , Retail will use

  • How to extract data from generic view and function module 10-11

    hi experts, can anybody give me the steps to extract data from generic view and  functon modules. thanks and regards venkathttps://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a0f46157-e1c4-2910-27aa-e3f4a9c8df33 https://websmp103.sap-

  • Regarding extract data from r/3 to BW3.5 10-11

    Hi, Before i extracted data from flat file to BW. Now i am extracting data from r/3 to bw.This is the first time to extract. Please give steps to extract data from r/3 to bw using LO's and please give some directions for generic also. Please do the n

  • BO DI for extracting data from legacy to SAP BW 7.0 11-30

    Hi, Has anyone worked on scenario where BO Data Integrator is being used as ETL tool for extracting data from legacy systems to SAP BW 7.0 ? Please share your experience on such a landscpae or related documents any of you had come across. Regards, Pr