Home > Default > Steps to Extract data from Source System

Steps to Extract data from Source System

November 30Hits: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.

Answers

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

Read other 6 answers

Tags:

Related Articles

  • Steps to Extract data from Source SystemNovember 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 systemOctober 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 systemOctober 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

  • Problem in extracting data from source systemNovember 30

    HI    I am comparing source system and data in bW for a particular datasource.In this process in source system transaction RSA3 when i am trying to extract data its not showing the exact count.I couldnt able to understand the setting options like Dat

  • No data in source systemOctober 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

  • Error during extraction data from APO systemNovember 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.0November 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.0October 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 bwOctober 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 fileOctober 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

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.635 s.