C
ATALOG
V
ALIDATION
&
I
NTEGRATION
E
NGINE
A
GENDA
Business Challenge
Our Solution – CVI
Your Benefit
References
Our Offer
Content (XLS) Content (XML) Content (XLS)
B
USINESS
P
ROCESS
Content receiver Agent Local data handling
Supply of content in most cases by e-mail or hand-over of files
Data supply at varying times
(contacting with agent on receiver’s side)
Manual screening and verification of content
Content upload
Manual import analysis
Consultation with supplier
Content supplier (in-house)
Content supplier (external)
Content supplier (external)
Typical situation on cross-system interface processes with transfer between different environments
SAP® SRM-MDM, SAP® MDM,
SAP® ERP, …
Content (XLS) Content (XML) Content (XLS)
B
USINESS
P
ROCESS
Content receiverContent supplier (in-house)
Content supplier (external)
Content supplier (external)
Agent Interface SAP® SRM-MDM, SAP® MDM, SAP® ERP, …
3
1
2
High data volume
Erroneous and insecure data
Deficient error log
Numerous check runs
No configurable rule settings
No on-board tools for generating an import template
3
1
2
High, often unclear data volumes
No verified set of rules on data quality No generation of templates
Erroneous import data caused by
B
USINESS
C
HALLENGE
Correction is hindered by missing logs
Many check runs necessary
Effort of adjustment between sender and receiver Increased costs caused by
A
GENDA
Business Challenge
Our Solution – CVI
Your Benefit
References
Our Offer
Simplification of content management
Verification of content according to system configuration before import
Online validation of data with / without test run
Correction of errors by the content supplier
Online provision of content templates Image upload
Support of Your Content Management
O
UR
S
OLUTION
Content supplier
P
ROCESS OF THE SOLUTION
Datafile (XLS, XML) Ok? Yes No6a
CVI sends check report Content supplier Upload of data to CVI CVI transfers validated content Content receiver Content7
6b
Supplier correctsdata Import interface
SRM-MDM MDM ERP SAP® CVI extracts parameter of validation Template Generates template
3
Generates data file Check Report CVI checks data5
CVI Configuration CVI Server CVI Validation CVI Integration4
2
1
Field types of the MDM items / business partner table
Field types of the MDM lookup tables
Contents of the MDM lookup tables Validation rules are based on
S
CENARIO
„C
ATALOG
V
ALIDATION
“
FOR
SRM-MDM
Structure of the data
Mandatory fields
Uniqueness of key fields
Conformity to the specified data types
Correct usage of values from the lookup tables
Conformity to regular expressions Types of validations
Error report is sent via email
Validated data is save in a target folder
(e.g. the „Ready“- folder of a MDM import port)
E
XAMPLE
C
HECKS
Value help checks:
Product categories
Currency codes
Units of measure
Supplier names / numbers
VAT rate
Type checks:
Length of description
Number of decimal places
Key Fields check:
Supplier
Supplier part number
Scale price amount Examples
Guided content upload process at supplier’s side. Example
Setting up of a set of validation rules by the content receiver. Example
Field types of the MDM items / business partner table
Field types of the MDM lookup tables
Contents of the MDM lookup tables Validation rules are based on
S
CENARIO
„B
USINESS
P
ARTNER
/M
ATERIAL
M
ASTER
V
ALIDATION
“
FOR
MDM
Structure of the data
Mandatory fields
Uniqueness of key fields
Conformity to the specified data types
Correct usage of values from the lookup tables
Conformity to regular expressions Types of validations
Error report is sent via email
Validated data is save in a target folder
(e.g. the „Ready“- folder of a MDM import port)
• Field types of the SAP table
• SAP value helps
• Fixed domain values
• Value table for foreign key fields Validation rules are based on
S
CENARIO
„ERP S
ALES
O
RDER VALIDATION
“
Types of validations
• Error report is sent via e-mail
• Validated data is imported as CSV file via Asapio import interface
Integration
Structure of the data
Mandatory fields
Uniqueness of key fields
Conformity to the specified data types
Correct usage of values from the lookup tables
A
GENDA
Business Challenge
Our Solution – CVI
Your Benefit
References
Our Offer
U
SER
-B
ENEFIT
Instant content delivery by
the content supplier
Useful error logs enable fast
correction of content
Provision of templates
for data generation
(online-download)
Configuration of rule sets
on the basis of active
master and transaction data
Validation by using the
defined set of rules reduces
correction effort
Only upload of validated
data in a SAP® system via
defined interfaces (report,
BAPI®)
Improved security at data
import. No direct access to
the SAP® system by the
content supplier
E
CONIMIC
B
ENEFITS
Fast integration of new content to the process
Minimum effort of communication
Increased data integrity
Improved data quality
Speed-up the process
A
GENDA
Business Challenge
Our Solution – CVI
Your Benefit
References
Our Offer
R
EFERENCES
International Foods Company Europe & Asia
Catalog Validation ~60 suppliers
Fresenius Netcare
Catalog Validation ~20 suppliers
Claas
Catalog Validation ~ 20 suppliers
DPD
Sales Order Validation
A
GENDA
Business Challenge
Our Solution – CVI
Your Benefit
References
Our Offer
Transport CVI Install CVI Server Configurat ion Customizi ng
Service
The price for our solution depends on the following elements: Number of included content suppliers Number of integration scenarios
Our services included in this solution are:
Installation of the CVI server in collaboration with your SAP basis team
Configuration
Installation Guide
Configuration User Guide
User Guide
If required SAP-transport for special interfaces
If required customer-specific enhancements
Please contact us to get your own company-specific offer.
We would be pleased to give you an individual demonstration of all the features of CVI or any other of our solutions.
Our Offer
O
UR
O
FFER
Customizing
Validation and integration of supplier catalogs for SAP® SRM-MDM
catalog (e.g. Fresenius Netcare, Claas, DPD)
CVI – Catalog Validation & Integration Engine
ASAPIO S
OLUTIONS
Structured handling of workitems in folders incl. sent workitems and resubmissions (e.g. Airbus)
XWI – Extended Workflow Inbox
Local handling of SRM documents in Excel® (e.g. Nokia, Ontario
Power)
PDUD – Purchasing Documents Up- and Download
Replacement of free text or material master items in the SRM purchasing process with catalog items (e.g. WDR, Bank Hapoalim, EADS)
ICR – Item Catalog Replacement
Business card catalog for SAP® SRM using SAP® Interactive Forms
by Adobe® (e.g. ERGO)
A
GENDA
Business Challenge
Our Solution – CVI
Your Benefit
References
Our Offer
Contact
Agnes-Pockels-Bogen 1 80992 Munich Germany +49 (0) 89-4520 744 0 [email protected] www.asapio.com Lothar SteinrückenD
ISCLAIMER
Restriction on Disclosure and Use of Data
The data in this document contains trade secrets and confidential or proprietary information of Asapio GmbH & Co. KG, the disclosure of which would provide a competitive advantage to others. As a result, this document shall not be disclosed, used or duplicated, in whole or in part, for any purpose other than to evaluate Asapio GmbH & Co. KG. The data subject to this restriction are contained in the entire document.
Copyright: © 2010 Asapio GmbH & Co. KG. All rights reserved. Image Source: © 2009 iStockPhoto
SAP® and SAP NetWeaver® are brands or registered brands of SAP AG
Germany and other countries.
Excel ® is either registered trademark or trademark of Microsoft Corporation in
the United States and/or other countries.
Adobe® is either registered trademark or trademark of Adobe Systems