Notes

1.What is order to cash?
sol:A multistep process encomapassing a sales order entry to cash receipt.Its a complete supply chain process.We keep supplying goods every day ,but we dont get cash every day.

Supply chain:A process relating to
Receiving of materials
Manufracturing-conversion
delivey of products to customers
Provision of support and services.

Only the service is provided,we can retain the customer.Every day gained imporves cassh flow,customer satisfaction,profitability,inventory turns,The reduction of lost product.We have to measure the profitablity.Inventory is all about storing that raw material.

order to cash CYCLE.
Suppliers PTP.(PROCURE TO PAY).
Manufracturing PTM(PLAN TO MAKE)
Order to cash OTC(ORDER TO CASH)
distribution of products LEX.(LOGISTICS AND EXECUTION).

We have built a pickle manufracturing plant.I want to manufracture 10 million pickle bottles everyday.
Order to cash helps us to do that.Every day we have orders and we can do that.Warehouse is the place where we store the rawmaterial.
This is the basic profiling.For Vendor we have two more source systems.I know that vendor has two source systems.We dont want to convert the same vendor twice.We can run redundancy check between duplicates.We have the vendor account number,man man system and also baan system.We can select a source table.
For LSMW we require abap guys and basis guys.It support data transfer for most important transactional and master data.Now we have seen the advanatages of LSMW.
sap aio best practice.
When we use sap best practice only 30 to 40 percent customization is required.It is more useful because it sppeeds up the implementation process.It provides a good base because there is always a prototype and proof of concept.We can quickly preview and understand application process.Later we have make every one understand quick preview and reference system and quickly set up a definition and how a sales process is built and it can accelerate blur printing and make up a good starting point.Add additional requirements to keep doing the project.This is a standard SAP implementation.It is very good that when we are implementing we can start with a new requirement.I have implemented in United states,we can implement that across the globe.We can implement the system through out the world.When we really acquire the company or start a company.We are going to see today practically,the tables from a source system.We will extract them,transform them and we are all the most important part of any migration.This will make a standard implementation process.Actual migration project step by step.

Important steps while doing SAP migration
By the time we pull up the steps involved in SAP data migration,let us talk about migration.This is the best practice part delivered by SAP.Golden target data map.Few of them come with system id with sap.We have a enriched data,data cleansing and data transformation.I am trying to take only couple of tables.These two tables are actually.If we have customer master data.

Master data governance.We have multiple interfaces we have the master data management.We have the final thing as transaction data.We will also be given the IDOC..We can find the source data,target data.We have the basic data,header data and master data and sales org data.
We have mandatory field,enriched field and we h

goto options
job server and in general
JB_DEMO is the job server.I have the instance sitting on the sql server instead of oracle.
When my repository had the problem,I had to drop and recreate the console.BI central management console.Let me recreate the table.

Order to cash:Pricing,contracts and quotes.
When you have pricing,we have a contract and quote.
Coca cola..has three different customers--we buy from walmart and we do lot of grocerry shop.We buy from a restaurant,we buy from walmart and we get it at different prices.There are different contracts,different pricing models.After the pricing contract is made,next comes order entry,approval and order fulfillment.Upto here is called supply chain planning process.

SUPPLY CHAIN EXECUTION.
Pricing contracts
order entry
approval
order fulfillment
service and support.
A business is an ongoing process.

Finally we send an invoice,we can make a payment.All the above process is termed as suply chain execution.oRDER TO CASH IS AN SUPPLY CHAIN EXECUTION PROCESS.wHY WE ARE IMPLEMENTION SAP.
Meet the demands of the customer.Why is sap popular in the market as an erp tool.When we use it for the existing business.Data migration road map.For the process of business to happen.

DATA MIGRATION ROAD MAP.
data preparation
we have to prepare the data for implementing SAP erp system.Identify the sources and profile and understand the data.
Prepare the data.How do we prepare the data.Because we look at the target ssystem.
Goback to step1 many times profile,profile,profile.
Identify the data,sources,profile and understand the data.This is a kind of cyclic repititive process.When we identifed the data we needed to move and go a mock load .We will extract,enrich the data and upload in the test system.We want the data to look better in the target system.Whether in the source we will see whether the converted data is same as that of the source.We have to reconcile the data.We have always an audit going on.Business tricks the government for mal practice.The converted data should be verified and goback to step 1 again and again.On the data we must be confident.The mock conversion is repetitive process in any implementation process.
Freeze and no more changes.AT the time of go live we have the cut over dry run under production conditions.Goto 9 only when step8 requires no further change.
Cutover into production system.
We will go into the production ssystem.Govern the data.No one directly load everything .We need to have a governance,that is MDM,MDG.
dATA GOVERNANCE is very important.DATA GOVERNANCE IS ONLY FOR MASTER DATA BUT NOT THE TRANSACTIONAL DATA.
Data migration architect.

We have the sap best practices for data migration
Legacy data environment---data staging annd test enviorment AND WE LOAD THE DATA TO THE TARGET.
LEGACY DATA ENVIRONMENT---DATA STAGING AND TEST ENVIRONMENT--LOADING.We need to have a standard for doing this process.We have to make the data from different sources look like same.We have to take the data from sap and start reconciling and do LSMW.
LSMW reads from flat files and loads into sap.
Vendor basic view,
vendor purchase view and
vendor sales view.Before we load the data into SAP,we need to extract the data .load the data and move the data into sap.If we have 100 products in sap.These are repititive steps,again and again before we go live.

Process of migration.
It is iteration.We extract the data,map the data and validate the data .All process takes place depending on months to years.Data i profiled,mapped,validated,enriched.We can understand the process regarding architecture.

We have an information steward tool;
A business process.How could an erp system help us plan business properly.The session is given by SAP migration tool kit.In the first half,we will undesrtand inbound/outbound business modules,segements,source analysis,data profiling,information steward,process of data migration.

SAP MIGRATION
USING LSMW TO LOAD SAP
EXTRACTING DATA FROM SAP APPLICATION
LOADING DATA TO SAP TARGET
ABAP DATA FLOWS.

BUSINESS
Why are all we in the market?
To get more return of investement.
We want to start a business,seelinng and manufracturing pickles.
Raj pickles.
The communication is very tough and hard.
We can understand business process.We can really make the business a friendly part.ERP stands for enterprise resource planning.
We donot where have to initialize.Defenitely business needs all this process.ERP is more for manufracturing companies.It measn inventory,purchasing and production planning.Finally we have to see the business intelligence reports.
Baan is one of the best ERP s in the market.There were several of them.The first important thing is there are different modules in the business.Start an end to end process;
LEX is a ware house management system.
ORDER TO CASH---we need to procure the goods.
The following are the end to end processes cut through LEX-WM
Order to cash
procure to pay
Plan to make
OTC business process hierarchy
contracts and pricing.
order management
billings and account receivable.
Global trade services.

We have to procure goods before we start doing anything
When we call rawmaterial.What is all the raw material we require.
Manual requirement
Determination of requirements.
Source determination.
Where can we procure these raw materials.
A vendor is the key person we require.We have a vendor selection process or criteria.
A have to raise a purchase order and do order processing.
Order follow up
There are definitely some terms and conditions.
Next comes the goods receipt and logitics and invoice verification

1.determination of requirements
2.Source determiation
3.Vendor selection
4.Order processing
5.Order follow up
6.Goods receipt
7.Invoice verification

The main important thing in procurement cycle is goods receipt and logistics and invoice verification.

We have seen the outbound process.
Sales and disstribution cycle

1.Customer gives a call.
QUOTATION
SALES ORDER
ORDER PROCESSING
PICKING AND PACKING
DELIVERY
POSST GOODS ISSUE
FINALLY WE BILL THE CUSTOMER AND WE MAKE THE PAYMENT.

Key decisions related to this process
1.How can your processes work with in the core VM functionality
2.What current processes are managed as exceptions
What external programs databases software support your operation
What forms and documents are needed for your operation?
What reports are generated and from what sourcesS>
Do you currently use physical inventory process
Do you have knitting processs?
Do you utilize material handling ecquipmentIs is integrated with a stand alone ssytem
?
Is the product barcoded?



We store the data in SAP system

To load the data into sap using data services,we should have a basis admin.
ON sap,we set of transaction codes.Each transaction code for a different purpose.This is SAP LOGON.We have the same logon jut like sap system.
tcode SE16
TABLE MARA
mY MAIN PART IS LOADING THE DATA AND GIVE THE DATA TO THE OTHER TEAM THAT IS SAP TEM WHO ARE RESPONSIBLE FOR BOBJFTR SETTINGS.
Information steward tool sitting on the remote machine.
Sooner or later we will install on the machine.
This is basically called as information steward tool for profile,profile and profile.We can DS_STAGING
.add and get the data store and add it
We can add the same data store or we can use a different data store.We have already extracted the customer data.First we extract the data and then we inscope them and we have to scope them.
Before we scope the data.we have to understand the data.We have all the tables under ds_staging.
If we click on profile tab and ordinary tab.This is more for data service enginerr.It will distinct null max,min.Right now we have a business analyst.We wanted to see column profile.When we run we have the column profiling,time stamp.
This will help you to actually get the data what we are looking at.It can be there from 4 character to 20 character.This is the baan system,We have the name,rule,.NAMa FIELD HAS O FIELDS,O BLANKS.There are several other profiling tasks.2425 records are non unique.We have to fix all these issues before we go into SAP.We have to check and rerun what is the data and we have to profile the data where it is.
A data insight project is a colloborative to monitor the quality of data of a speci


EIM_DM_ERP_V01_20110926.ZIP
DOWNLOAD THIS PACKAGE AND UNZIP TO MIGRATION FOLDER.
DATA SERVICES ATL FILES
IDOC MAPPING TEMPLATE
DATA MIGRATION INSTALLATION WIZARD
MIGRATION SERVICES
REPORTING
LOKK UP FILES AND LOOKUP CONTENT
ERP TEST DATA

PREPARE TO INSTALL AIO PACKAGES:
INSTALLATION OF PACKAGES
INSTALL MICROSOFT SQL SERVER 2008 R2
CREATE DATABSES AND LOGINS DM_REPO_ERP AND DM_STG_ERP.
IN ORACLE WE CREATE TWO SCHEMAS.
CREATE ODBC DATA SOURCES
IMPORT DATA SERVICES ATL CODE FILES
CREATE NEW DATASTORE CONFIGURATION FOR NON SQL SERVEL
INSTALL MIGRATION SERVICES TOOL
CONFIGURE IDOC SETTINGS ON SAP ECC-SAP BASIS ADMIN
THERE ARE AROUND 64 OBJECTS.
wE MIGHT RUN THE OWN PROGRAM .

cREATE A REPOSITORY with dm_repo_erp.
1.Import datastores_MSSQL2008.ATL
2.dm_repo_lookup_jobs.atl
3.dm_repo_idoc_A_to_M without datastore
4.DM_REPO_IDOC_NTO_Z WITHOUT DATSTORE
5.DM_REPO_IDOC_IDOCSTATUS
6.DM_REPO_PROJECT_IDOC

aFTER WE IMPORTED THE ATL,EACH TIME EXIT AND LOGIN BACK TO THE REPO AND THEN COME BACK TO THE REPO.
dm_bpfdm_idoc
dm_bpfdm_lookup-
dm_bpfdm_reconciliation

Configure the datastore
Default configuration to yes.
When we have imported the data stores.We have to create the third configuration.Right click on the configuration.Put oracle 11g .create new data store.Create new configuration.Several data flows get updated.Click ok ,new configuration gets Created.
We hve to create the data store.All the datastores get created.
Configure DS
DS_DM_REPO_IDOC to use DM_REPO_ERP.
Data store for non SQL server
How can a data store connect to the data base.Its a logical entity and gets the meta data from the particular database.We have multiple configurations,we can switch the job to different databases.We have to create the configuration.

SAP migration services tool.
Install migration services tool.
It is the tool for SME'S.SAP has its own way of configuring the look up table.At that time we have the same material manufractured from three different places.But the item must have unique number for all that is manufractured from three different places.

If we go couple of pages back.When we first install Idoc OBJECTS IN DS.We have material,QM inspection types.When we first install,we can install and atl file.Second ATL file


How to configure the migration services tool used to manage the mapping of legacy values to their SAP equivalent.Without using migration services.We will map the legacy to sap.This is how we configure for non sql environment.In every environment,the schema name should be different.
DM_STG_ERP.This is the schema we have created.We have set up and configured data services AIO package.

Migration tool---This is the file we pupt for keeping this up and running.We see a small file under migration services tool.We have to go into data services folder.
PUT THIS MIGRATION SERVICES UNDER SAP BO/TOMCAT6/WEBAPPS
Currently we are saying it as a localhost,because we are local to the machine,we can see the dataservices tool.After we configure,what will happen??

We have to run a job and see if it populates the migration services.
Run JB_DM_LOOKUP_Initialize
when we run the jobs we have to see what is getting created.This job We have the BODS 4.0.The screen right now what we are seeing is migration services powered by sap best practice.
JB_DM_LOOKUP_INITIALIZE.
All these look up tables are created.
This is the look up tables when we kick off the initialize job.When we run this job,This is the job that will get created we run the job.In the migration services we have to import files to stage area.This is how we get the look up tables.SME is the person who will see in the value here.Thiss could be the legacy material number for bill of material.

JB_DM_LOOKUP_SAPTOFILE.
JB_DM_LOOKUP_FILETOAPP.

Export files to local.After all these text files are created.Currenlty they have given a POC.Customer number range key.
All the look ups are configured.We will have to do the prep work for this.
AIO packages are very much popular.Information steward can be used to analyze the source system.
ANALYSIS
EXTRACTION
CLEANSING
VALIDATION
LOADING OF DATA.
RECONCILIATION
Reconciliation reportss are useful to check whether the same data is present in the target as the source.

Transperance via predefined.

Migration content 1.40v
We use the IDOC technology to cleanse and standardise the data.Documentation (Quick guides for ERP,HCM AND CRM).
SAP BODS PROJECT FILES
IDOC ACTIVATION PROGRAM
MAPPING AND LOOK UP TEMPLATES
MIGRATION SERVICES TOOL
UNIVERSES FOR ERP,HCM AND CRM BUSINESS OBJECTS
PREBUILT IDOC STATUS CHECKING AND RECONCILIATION JOBS
MIGRATION FROM SAP BUSINESS ONE TO SAP ERP.

DEPLOYMENT MODEL
1.SME MODEL(small and medium scale)
2.LE MODEL

WHEN IMPLEMENTING SAP,ERP,CRM AND HCM.SEPERATE DEPLOYMENT FOR ERP,CRM AND HCM.

LE deployment model:Two data stores exist for look up and management tables.They wanted to maintain the look ups in a common place.We have two deployments.

JB_DM_LOOKUPS_Initialize
JB_DM_Lookups_saptofile
JB_DM_LOOKUPS_FILETOAPP
JB_DM_Lookups_saptoapp
DM_BPFDM_IDCO
DM_BPFDM_RECONCILIATION

when we work on implementation