Q
Problem solve Get help with specific problems with your technologies, process and projects.

What is the procedure for extracting data from CRM to a flat file?

Expert Srinivasa Katta shares the benefits of using the legacy systems migration workbench for transferring flat files.

What is the procedure for extracting data from CRM to a flat file?
It is difficult give a straight answers without having details about the data volume and data type (master data and transactional data).
  1. You can use LSMW (Legacy Systems Migration Workbench) for transferring data from a flat file into SAP CRM systems.
  2. You can load the data from legacy flat files into staging tables in SAP CRM for further data cleansing and implementing data integrity rules. Staging tables are temporary Ztables created in the SAP CRM system to work as a short-term data repository.
  3. The data from staging tables can be loaded into SAP CRM data dictionary tables using SAP provided BAPIs (Business Application Programming Interface).
This was last published in May 2007

Dig Deeper on SAP CRM software

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close