--- description: Step 1) Creating a Generic Data Source for Text InfoObject Right click on the BI Source System -> Customizing Extractors. In next screen, click on Maintain Generic DataSources title: How to Load Master Data From ECC in SAP BI/BW image: https://www.guru99.com/images/load-master-data-from-ecc-in-sap-bi-bw.png --- [Skip to content](#main) **⚡ Smart Summary** Loading master data from ECC into SAP BW creates a generic DataSource for the text, attribute, or hierarchy, builds a transformation to the target InfoObject, and runs an InfoPackage and data transfer process to load the records. * 🏷️ **Master Data:** Texts, attributes, and hierarchies that describe characteristics are loaded from ECC. * 🔧 **Generic DataSource:** A generic DataSource on a table or view extracts the master data from ECC. * 🔁 **Transformation:** A transformation maps the DataSource fields to the target InfoObject. * 📦 **InfoPackage to PSA:** An InfoPackage loads the data into the PSA staging layer. * ➡️ **Data Transfer Process:** A DTP moves the data from PSA into the InfoObject text or attribute. * 🤖 **AI Assistance:** AI improves master data quality by detecting duplicates and inconsistencies. [ Read More ](javascript:void%280%29;) ![Load Master Data from ECC in SAP BI/BW](https://www.guru99.com/images/load-master-data-from-ecc-in-sap-bi-bw.png) ## What is Master Data Loading from ECC? Master data describes business entities such as customers, materials, and cost centers through attributes, texts, and hierarchies. Loading master data from ECC into SAP BW creates a generic DataSource for the data, builds a transformation to the target InfoObject, and runs an InfoPackage and data transfer process to load the records. ## Step 1: Create a Generic DataSource for the Text InfoObject Right click on the BI Source System -> Customizing Extractors. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F1.jpg) In the next screen, click on Maintain Generic DataSources. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F2.jpg) In the next screen: 1. Type a technical name for the text. 2. Click the Create button. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F3.jpg) In the next screen: 1. Enter the Short, Medium, and Long Description. 2. Enter the View/Table name. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F4.jpg) Press the Enter button. The below screen is displayed. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F5.jpg) Now: 1. Go to transaction code RSA1. 2. Click the OK button. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F6.jpg) In the next screen: 1. Go to the DataSource tab. 2. Click Find. 3. Type the DataSource technical name. 4. Click the Search button. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F7.jpg) Next, from the DataSource **ZGR24CC\_TEXT**, right click Replicate Metadata as shown below. Activate the DataSource. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F8.jpg) ### RELATED ARTICLES * [SAP BI Architecture Diagram: Overview Tutorial ](https://www.guru99.com/overview-of-sap-bi-architecture.html "SAP BI Architecture Diagram: Overview Tutorial") * [SAP BW InfoObject, Infoarea, InfoObject Catalogue & Types ](https://www.guru99.com/all-about-infoobject-infoarea-infoobject-catalog.html "SAP BW InfoObject, Infoarea, InfoObject Catalogue & Types") * [SAP InfoSet Tutorial: What is, Create, Joins ](https://www.guru99.com/what-is-infoset.html "SAP InfoSet Tutorial: What is, Create, Joins") * [What Is an Infocube in SAP BI/BW? How To Create One? ](https://www.guru99.com/what-is-an-infocube-how-to-create-one.html "What Is an Infocube in SAP BI/BW? How To Create One?") ## Step 2: Create a Transformation (DataSource to InfoObject Text) 1. Go to transaction code RSA1. 2. Click the OK button. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F9.jpg) In the next screen, right click on the DataSource -> Create Transformation. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F10.jpg) In the next screen: 1. Enter the Target Object Type. 2. Enter the Target Object Name. 3. Enter the SubType. Choose Text. 4. Click Continue. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F11.jpg) The transformation is created with automatic mapping of the source fields to the target fields. ## Step 3: Create an InfoPackage and Schedule the Load to PSA 1. Go to transaction code RSA1. 2. Click the OK button. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F12.jpg) 1. Navigate to the Modeling tab -> DataSources. 2. Right click on the DataSource -> Create InfoPackage. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F13.jpg) 1. Enter the InfoPackage description. 2. Click Save. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F14.jpg) 1. Click on the Schedule tab. 2. Click the Start button to start the load to the DataSource (PSA). [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F15.jpg) ## Step 4: Create a Data Transfer Process Right click on the DTP folder and choose the option “Create Data Transfer Process” from the context menu. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F16.jpg) The below screen shows the DTP created. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F17.jpg) ## Step 5: Load Data to the InfoObject Text 1. Click the Execute tab in the DTP. 2. Click the Execute button to start the data load from the DataSource (PSA) to the InfoObject Text. [](https://www.guru99.com/images/sap/SAP%5FBI/sap%5Fbi%5F16%5F18.jpg) ## FAQs 🆚 What is the difference between master data and transaction data? Master data describes business entities and changes rarely, such as customer names, material attributes, and hierarchies. Transaction data records business events over time, such as orders and goods movements. Master data gives context to transaction data in reports. 🔧 What is a generic DataSource in SAP? A generic DataSource, created in transaction RSO2, extracts data from a database table, view, SAP query, or function module when no standard business content DataSource exists. It is commonly used to load custom master data attributes and texts into BW. 🗂️ What are the three types of master data in SAP BW? Master data in BW has three types: attributes (additional properties of a characteristic), texts (short, medium, and long descriptions), and hierarchies (parent-child structures). Each type can be loaded separately from ECC or a flat file. 🤖 Can AI assist with master data management in SAP? Yes. AI in SAP Master Data Governance detects duplicates, validates records, and proposes corrections, while the SAP Joule AI copilot answers configuration questions. This intelligent support improves master data accuracy before it is loaded into BW. 🧠 How does AI improve master data quality? Machine learning matches similar records to flag duplicates, fills missing attributes from patterns, and detects outliers that suggest errors. This intelligent cleansing raises the consistency and trust of master data used across reports. #### 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]() 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/load-master-data-from-ecc-in-sap-bi-bw.png","url":"https://www.guru99.com/images/load-master-data-from-ecc-in-sap-bi-bw.png","width":"700","height":"250","caption":"Load Master Data From ECC in SAP BI/BW","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/how-to-load-master-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-master-data-from-ecc.html","name":"How to Load Master Data From ECC in SAP BI/BW"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/how-to-load-master-data-from-ecc.html#webpage","url":"https://www.guru99.com/how-to-load-master-data-from-ecc.html","name":"How to Load Master Data From ECC in SAP BI/BW","dateModified":"2026-06-26T18:23:29+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/load-master-data-from-ecc-in-sap-bi-bw.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/how-to-load-master-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":"How to Load Master Data From ECC in SAP BI/BW","description":"Step 1) Creating a Generic Data Source for Text InfoObject Right click on the BI Source System -> Customizing Extractors. In next screen, click on Maintain Generic DataSources","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:23:29+05:30","image":{"@id":"https://www.guru99.com/images/load-master-data-from-ecc-in-sap-bi-bw.png"},"copyrightYear":"2026","name":"How to Load Master Data From ECC in SAP BI/BW","subjectOf":[{"@type":"HowTo","name":"How to Load Master Data From ECC in SAP BI/BW","description":"There are many steps to Load Master Data From ECC","step":[{"@type":"HowToStep","name":"Creating a Generic Data Source for Text InfoObject","text":"Right click on the BI Source System -> Customizing Extractors.","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_16_1.jpg","url":"https://www.guru99.com/how-to-load-master-data-from-ecc.html#step1"},{"@type":"HowToStep","name":"Create transformation between Data Source(Source) and InfoObject Text(Target).","text":"Go to transaction code RSA1","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_16_9.jpg","url":"https://www.guru99.com/how-to-load-master-data-from-ecc.html#step2"},{"@type":"HowToStep","name":"Create Infopackage and Schedule Dataload to the DataSource(PSA).","text":"Navigate to Modeling tab->DataSources.","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_16_13.jpg","url":"https://www.guru99.com/how-to-load-master-data-from-ecc.html#step3"},{"@type":"HowToStep","name":"Create Data Transfer Process.","text":"Right-Click on DTP folder and choose the option 'Create Data Transfer Process' from the context menu","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_16_16.jpg","url":"https://www.guru99.com/how-to-load-master-data-from-ecc.html#step3"},{"@type":"HowToStep","name":"Load Data to the InfoObject Text.","text":"Click Execute tab in the DTP.","image":"https://www.guru99.com/images/sap/SAP_BI/sap_bi_16_18.jpg","url":"https://www.guru99.com/how-to-load-master-data-from-ecc.html#step3"}]},{"@type":"FAQPage","mainEntity":[{"@type":"Question","name":"What is the difference between master data and transaction data?","acceptedAnswer":{"@type":"Answer","text":"Master data describes business entities and changes rarely, such as customer names, material attributes, and hierarchies. Transaction data records business events over time, such as orders and goods movements. Master data gives context to transaction data in reports."}},{"@type":"Question","name":"What is a generic DataSource in SAP?","acceptedAnswer":{"@type":"Answer","text":"A generic DataSource, created in transaction RSO2, extracts data from a database table, view, SAP query, or function module when no standard business content DataSource exists. It is commonly used to load custom master data attributes and texts into BW."}},{"@type":"Question","name":"What are the three types of master data in SAP BW?","acceptedAnswer":{"@type":"Answer","text":"Master data in BW has three types: attributes (additional properties of a characteristic), texts (short, medium, and long descriptions), and hierarchies (parent-child structures). Each type can be loaded separately from ECC or a flat file."}},{"@type":"Question","name":"Can AI assist with master data management in SAP?","acceptedAnswer":{"@type":"Answer","text":"Yes. AI in SAP Master Data Governance detects duplicates, validates records, and proposes corrections, while the SAP Joule AI copilot answers configuration questions. This intelligent support improves master data accuracy before it is loaded into BW."}},{"@type":"Question","name":"How does AI improve master data quality?","acceptedAnswer":{"@type":"Answer","text":"Machine learning matches similar records to flag duplicates, fills missing attributes from patterns, and detects outliers that suggest errors. This intelligent cleansing raises the consistency and trust of master data used across reports."}}]}],"@id":"https://www.guru99.com/how-to-load-master-data-from-ecc.html#schema-558558","isPartOf":{"@id":"https://www.guru99.com/how-to-load-master-data-from-ecc.html#webpage"},"publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/how-to-load-master-data-from-ecc.html#webpage"}}]} ```