--- description: Following are the steps to perform the data extraction from ECC into BW systems. We will take Logistics (Purchasing application module) in our example. Step 1) Login into ERP system Input the T title: RSA5 Tcode in SAP BW: Load ECC Transaction Data image: https://www.guru99.com/images/rsa5-tcode-in-sap-bw.png --- [Skip to content](#main) **⚡ Smart Summary** Loading transaction data from ECC into SAP BW uses transaction RSA5 to enhance and activate the DataSource, replicates its metadata in BW, and then loads the data through an InfoPackage into the PSA staging layer. * 🔄 **ECC to BW:** Transaction data flows from ECC DataSources into the BW staging layer. * 🔧 **Transaction RSA5:** RSA5 activates and enhances the business content DataSource in ECC. * ➕ **Add Fields:** Unselected fields such as EFFWR are checked to push extra data into BW. * 🔁 **Replicate Metadata:** The BW system replicates the DataSource definition after activation. * 📦 **InfoPackage to PSA:** An InfoPackage loads the data from ECC into the PSA staging layer. * 🤖 **AI Assistance:** AI and intelligent automation schedule extractions and flag load errors early. [ Read More ](javascript:void%280%29;) ![RSA5 Tcode in SAP BW Load Transaction Data from ECC](https://www.guru99.com/images/rsa5-tcode-in-sap-bw.png) ## What is Transaction Data Loading from ECC? Loading transaction data from ECC into SAP BW makes business transaction data, such as purchasing or sales documents, available for reporting. This example uses the Logistics (Purchasing) module to extract data from an ECC DataSource, enhance it, replicate it in BW, and load it into the PSA staging layer. ## Enhance and Activate the DataSource in ECC (RSA5) **Step 1)** Log into the [ERP system](https://www.guru99.com/erp-full-form.html). 1. Input the T-code RSA5. 2. Click the Continue button. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_1.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F1.jpg) **Step 2)** Click on the folder SAP R/3 as shown below. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_2.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F2.jpg) **Step 3)** Go to the folder MM (Materials Management) – MM-IO as shown below. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_3.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F3.jpg) **Step 4)** Choose the DataSource 2LIS\_02\_ITM, which is purchasing data at item level. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_4.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F4.jpg) **Step 5)** Choose the DataSource 2LIS\_02\_ITM, go to the DataSource tab, and click Change the DataSource. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_5.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F5.jpg) **Note:** This step is used when you need to add additional fields to push into BW. The same steps (1-5) can be repeated for fields you do not wish to populate in BW. After choosing the Change DataSource tab, you can see all the fields associated with this DataSource. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_6.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F6.jpg) **Step 6)** The field EFFWR (Effective value item) is unchecked in the selection field, which means it is not available in BW. To populate EFFWR in BW, check it in the selection field as shown below. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_7.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F7.jpg) **Step 7)** After checking the field EFFWR in the selection, save the DataSource as shown below. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_8.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F8.jpg) **Step 8)** Activate the DataSource as shown below. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_9.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F9.jpg) Now you are ready to push the changed DataSource 2LIS\_02\_ITM, with the field EFFWR, into BW. ### RELATED ARTICLES * [What is Write Optimized DSO in SAP? ](https://www.guru99.com/what-is-write-optimized-dso-how-to-create-one.html "What is Write Optimized DSO in SAP?") * [What is Direct Update DSO in SAP? How to Create One? ](https://www.guru99.com/what-is-direct-update-dso-how-to-create-one.html "What is Direct Update DSO in SAP? How to Create One?") * [SAP BEx Query Designer Tutorial ](https://www.guru99.com/introduction-to-bex-query-designer-and-query-elements.html "SAP BEx Query Designer Tutorial") * [SAP BW Characteristics & Key Figures ](https://www.guru99.com/learn-about-key-characteristics-settings-cfk-rfk-formulas.html "SAP BW Characteristics & Key Figures") ## Replicate the DataSource in BW **Step 9)** 1. Log into the BW system and go to the DataSource tab. 2. Click Find to search. 3. Type the DataSource technical name. 4. Click the Search button. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_10.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F10.jpg) **Step 10)** From the DataSource 2LIS\_02\_ITM, right click Replicate Metadata as shown below. ### RELATED ARTICLES * [What is Write Optimized DSO in SAP? ](https://www.guru99.com/what-is-write-optimized-dso-how-to-create-one.html "What is Write Optimized DSO in SAP?") * [What is Direct Update DSO in SAP? How to Create One? ](https://www.guru99.com/what-is-direct-update-dso-how-to-create-one.html "What is Direct Update DSO in SAP? How to Create One?") * [SAP BEx Query Designer Tutorial ](https://www.guru99.com/introduction-to-bex-query-designer-and-query-elements.html "SAP BEx Query Designer Tutorial") * [SAP BW Characteristics & Key Figures ](https://www.guru99.com/learn-about-key-characteristics-settings-cfk-rfk-formulas.html "SAP BW Characteristics & Key Figures") [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_11.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F11.jpg) After successful replication of the DataSource, the field EFFWR is available in BW. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_12.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F12.jpg) ## Load the Data with an InfoPackage **Step 11)** Load the data from ECC into BW to populate the field EFFWR with data. 1. Go to transaction code RSA1. 2. Click the OK button. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_13.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F13.jpg) 1. Navigate to the Modeling tab -> DataSources. 2. Right click on the DataSource -> Create InfoPackage. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_14.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F14.jpg) This InfoPackage loads the data from ECC into the BW system at the PSA level, which is an intermediate level. 1. Enter the InfoPackage description. 2. Click Save. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_15.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F15.jpg) 1. To trigger the data load from ECC into BW, go to the InfoPackage and click the Schedule tab. 2. Click the Start button to start the load. [![Load Transaction Data from ECC in SAP](https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_16.jpg)](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F17%5F16.jpg) ## FAQs 🆚 What is the difference between RSA5 and RSA6 in SAP? RSA5 activates SAP-delivered business content DataSources, moving them from a delivered to an active state. RSA6 maintains and post-processes those active DataSources, for example to hide fields or change extraction settings after activation. 🔁 What is metadata replication in SAP BW? Metadata replication copies the DataSource definition from the source ECC system into BW, so BW knows the available fields and structure. You replicate after activating or changing a DataSource, before building transformations and loading data. 📦 What is a 2LIS extractor in SAP? A 2LIS extractor is a standard Logistics (LO) cockpit DataSource that extracts transaction data from modules such as Purchasing, Sales, and Inventory. For example, 2LIS\_02\_ITM extracts purchasing data at item level for loading into BW. 🤖 Can AI automate data extraction from ECC to BW? Yes. Intelligent automation and the SAP Joule AI copilot can schedule extractions, monitor delta loads, and answer setup questions, while modern tools such as SAP Datasphere streamline ECC-to-BW pipelines with less manual configuration. 🧠 How does AI help resolve data load errors? Machine learning scans load logs to classify errors, suggest likely causes, and recommend reruns. This intelligent monitoring reduces the manual effort of analyzing failed InfoPackages and DTPs and speeds up recovery of nightly loads. #### Summarize this post with: ChatGPT Perplexity Grok Google AI **Stay Updated on AI** **Get Weekly AI Skills, Trends, Actionable Advice.** ##### Sign up for the newsletter Subscribe for Free You have successfully subscribed. Please check your inbox. ![AI-Newsletter](https://www.guru99.com/images/footer-email-avatar-imges-1.png) Chosen by over **350,000+** professionals [Scroll to top ](#wrapper)Scroll to top × Toggle Menu Close Search for: Search ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.guru99.com/#organization","name":"Guru99","sameAs":["https://www.facebook.com/Guru99Official","https://twitter.com/guru99com"],"logo":{"@type":"ImageObject","@id":"https://www.guru99.com/#logo","url":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","contentUrl":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","caption":"Guru99","inLanguage":"en-US"}},{"@type":"WebSite","@id":"https://www.guru99.com/#website","url":"https://www.guru99.com","name":"Guru99","publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https://www.guru99.com/images/rsa5-tcode-in-sap-bw.png","url":"https://www.guru99.com/images/rsa5-tcode-in-sap-bw.png","width":"700","height":"250","caption":"RSA5 Tcode in SAP BW","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":"1","item":{"@id":"https://www.guru99.com","name":"Home"}},{"@type":"ListItem","position":"2","item":{"@id":"https://www.guru99.com/sap-bi","name":"SAP - BI"}},{"@type":"ListItem","position":"3","item":{"@id":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html","name":"RSA5 Tcode in SAP BW: Load ECC Transaction Data"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html#webpage","url":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html","name":"RSA5 Tcode in SAP BW: Load ECC Transaction Data","dateModified":"2026-06-26T18:03:12+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/rsa5-tcode-in-sap-bw.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/jessica","name":"Jessica Blake","description":"I'm Jessica Blake, an SAP Consultant, dedicated to helping businesses achieve their goals with expert SAP guidance.","url":"https://www.guru99.com/author/jessica","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/jessica-blake-author.png","url":"https://www.guru99.com/images/jessica-blake-author.png","caption":"Jessica Blake","inLanguage":"en-US"},"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"articleSection":"SAP - BI","headline":"RSA5 Tcode in SAP BW: Load ECC Transaction Data","description":"Following are the steps to perform the data extraction from ECC into BW systems. We will take Logistics (Purchasing application module) in our example. Step 1) Login into ERP system Input the T","keywords":"sap-bi","speakable":{"@type":"SpeakableSpecification","cssSelector":[".entry-title",".summary"]},"@type":"Article","author":{"@id":"https://www.guru99.com/author/jessica","name":"Jessica Blake"},"dateModified":"2026-06-26T18:03:12+05:30","image":{"@id":"https://www.guru99.com/images/rsa5-tcode-in-sap-bw.png"},"copyrightYear":"2026","name":"RSA5 Tcode in SAP BW: Load ECC Transaction Data","subjectOf":[{"@type":"HowTo","name":"How to Load Transaction Data from ECC: SAP RSA5","description":"Following are the steps to perform the data extraction from ECC into BW systems. We will take Logistics (Purchasing application module) in our example.","step":[{"@type":"HowToStep","text":"Login into ERP system","name":"Input the T code- RSA5","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_1.jpg","url":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html"},{"@type":"HowToStep","text":"Choose the datasource 2LIS_02_ITM","name":"which is purchasing data at Item level.","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_4.jpg","url":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html"},{"@type":"HowToStep","text":"Choose the datasource 2LIS_02_ITM and","name":"go to the Datasource tab and click Change the datasource as shown in screenshot.","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_5.jpg","url":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html"},{"@type":"HowToStep","text":"Now, as per the above screenshot the Field EFFWR \u2013Effective value item is unchecked in selection field which means that it is not available in BW","name":"To populate the Field EFFWR in BW, we will have to check mark in selection field as shown below.","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_7.jpg","url":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html"},{"@type":"HowToStep","text":"Log into BW system, go to the Datasource tab","name":"Click Find to search.","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_10.jpg","url":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html"},{"@type":"HowToStep","text":"From the datasource 2LIS_02_ITM,","name":"right click Replicate Metadata as shown below.","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_11.jpg","url":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html"},{"@type":"HowToStep","text":"Load the data from ECC into BW to populate the filed EFFWR with some data.","name":"Go to transaction code RSA1","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_17_13.jpg","url":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html"}]},{"@type":"FAQPage","mainEntity":[{"@type":"Question","name":"What is the difference between RSA5 and RSA6 in SAP?","acceptedAnswer":{"@type":"Answer","text":"RSA5 activates SAP-delivered business content DataSources, moving them from a delivered to an active state. RSA6 maintains and post-processes those active DataSources, for example to hide fields or change extraction settings after activation."}},{"@type":"Question","name":"What is metadata replication in SAP BW?","acceptedAnswer":{"@type":"Answer","text":"Metadata replication copies the DataSource definition from the source ECC system into BW, so BW knows the available fields and structure. You replicate after activating or changing a DataSource, before building transformations and loading data."}},{"@type":"Question","name":"What is a 2LIS extractor in SAP?","acceptedAnswer":{"@type":"Answer","text":"A 2LIS extractor is a standard Logistics (LO) cockpit DataSource that extracts transaction data from modules such as Purchasing, Sales, and Inventory. For example, 2LIS_02_ITM extracts purchasing data at item level for loading into BW."}},{"@type":"Question","name":"Can AI automate data extraction from ECC to BW?","acceptedAnswer":{"@type":"Answer","text":"Yes. Intelligent automation and the SAP Joule AI copilot can schedule extractions, monitor delta loads, and answer setup questions, while modern tools such as SAP Datasphere streamline ECC-to-BW pipelines with less manual configuration."}},{"@type":"Question","name":"How does AI help resolve data load errors?","acceptedAnswer":{"@type":"Answer","text":"Machine learning scans load logs to classify errors, suggest likely causes, and recommend reruns. This intelligent monitoring reduces the manual effort of analyzing failed InfoPackages and DTPs and speeds up recovery of nightly loads."}}]}],"@id":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html#schema-558569","isPartOf":{"@id":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html#webpage"},"publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/how-to-load-transaction-data-from-ecc.html#webpage"}}]} ```