Data Conversion


The below gives an idea of what solutions can be proposed for Data Conversion.

Base assumptions

  1. Data Conversion approach is well defined and understood by all parties involved
  2. Mapping between legacy data and SAP structures has been completed
  3. Sample files are ready for performing unit testing
  4. One set of source structures is used1
  5. Analysis and Design correspond to the time required for reviewing the approach/mapping and proposing a solution
  6. Construction is the time necessary to build the LSMW object
  7. Unit Testing corresponds to the time necessary to load the set of sample files into the development client

Complexity factors

The complexity of a Data Conversion object depends on multiple criteria whose most important are:

  1. Data quality of source files
  2. Number of source files
  3. Existence of a standard LSMW method/object, BAPI or ALE message type
  4. Complexity of the mapping between the legacy data structures and the SAP data structures (complex algorithms…)

Estimation metrics

Estimation metrics are usually based on complexity factors (Low , Medium, High).
Figures below are purely indicative and should be adapted to customer’s requirements.

 

 Complexity / Phase

 

 Analysis & Design

 

 Construction

 

 Unit Testing

 

 Low

 

 0.5 day

 

 1 day

 

 2 days

 

 Medium

 

 1 day

 

 2 days

 

 3 days

 

 High

 

 2 days

 

 3 days

 

 5 days

Low

 

 Object

 

 Comments

 

 FI01 – G/L Account

 

 ALE method, creation+extension, 1 source structure

 

 FI02 – Secondary Cost Element

 

 ALE method, creation, 1 source structure

 

 FI03 – Activity Type

 

 ALE method, creation, 1 source structure

 

 FI05 – Profit Center

 

 ALE method, creation, 1 source structure

 

 FI06 – Cost Center

 

 ALE method, creation, 1 source structure

 

 FI07 – Bank Master

 

 Custom recording, creation, 1 source structure

 

 FI11 – Internal Order

 

 Custom recording, creation, 1 source structure

 

 MM06 – Storage Bin

 

 Custom recording, creation, 1 source structure

 

 MM10 – Control Cycle

 

 Custom recording, creation, 1 source structure

Medium

 

 Object

 

 Comments

 

 FI04 – Fixed Asset

 

 Standard DI method, creation, 1 source structure

 

 FI08 – G/L Opening Balance

 

 Standard BI method, creation, 1 source structure

 

 FI09 – A/P Open Item

 

 Standard BI method, creation, 1 source structure

 

 FI10 – A/R Open Item

 

 Standard BI method, creation, 1 source structure

 

 FI12 – Activity Price

 

 ALE method, creation, 1 source structure

 

 MM02 – Material Classification

 

 Standard BI method, creation, 1 source structure

 

 MM04 – Purchase Info Record

 

 Standard BI method, creation, 1 source structure

 

 MM07 – Inventory Stock

 

 Standard BI method, creation, 1 source structure

 

 MM08 – Warehouse Stock

 

 Standard BI method, creation, 1 source structure

 

 PP02 – Bill of Materials

 

 Standard BI method, creation, 1 source structure

 

 SD05 – Customer Material Info Record

 

 Standard BI method, creation, 1 source structure

 

 SD02 – Credit Master

 

 Custom recording, creation, 1 source structure

 

 SD03 – Customer Hierarchy

 

 <tbd>, creation, <tbd>

 

 SD04 – Pricing Condition Record

 

 <tbd>, creation, 1 source structure

 

 LE01 – Transportation Zone

 

 Custom program, creation, 1 source structure

 

 LE02 – Route

 

 Custom program, creation, 1 source structure

 

 LE04 – Route Stage

 

 Custom program, creation, 1 source structure

 

 PP01 – Work Center

 

 Standard DI method, creation, 1 source structure

 

 PP05 – Planning Data

 

 <tbd>, creation, <tbd>

High

 

 Object

 

 Comments

 

 MM01 – Material

 

 Standard DI method, creation+extension, 1 source structure

 

 MM03 – Vendor

 

 Standard BI method, creation+extension, 1 source structure

 

 MM05 – Open Purchase Order

 

 ALE method, creation, multiple source structures

 

 SD01 – Customer

 

 Standard BI method, creation+extension, 1 source structure

 

 SD08 – Open Sales Order

 

 ALE method, creation, multiple source structures

 

 SD07 – Rebate Agreement

 

 <tbd>, creation, <tbd>

 

 LE03 – Shipping Costs

 

 Custom program, creation, multiple source structures

 

 PP03 – Routing

 

 ALE method, creation, 1 source structure

 

 PP04 – Recipe and Formula

 

 <tbd>, creation, <tbd>

 

 PP06 – Open Production Order

 

 <tbd>, creation, <tbd>

Footnotes