Transcription

Carving out multipleJDE and SAP systems intoSAP S/4HANAS/4HANA on-premise editionWhitepaperwww.chainsys.comApplications

Client OverviewOur client is a leading pharmaceutical company operating globallythat was spun off from its parent, as part of a divestiture.Our client has a wide breadth of solutions that will continue totransform the anatomical pathology market and improve patientoutcomes by providing groundbreaking technologies.Thiyagarajan RathinamDelivery LeaderChainSys CorporationThiyagu is a true delivery leader with a balanced experiencein Functional and Technology. He has over 25 years ofprofessional experience with a great focus on processimprovements and data management, he has been a leaderof ChainSys product implementations for over 20 years.Managed independently many Fortune 500 clients,he brings innovation effectively for each project's success.

Project ScopeClient was using JD Edwards, SAP ECC and other Legacy applications. Client implemented SAP S4/Hanasystem for its ERP operations, post divestiture and had approached ChainSys to provide data migrationservices as part of dataZap offering.The scope of the project was to migrate more than 45 master and transaction objects in P2P, O2C, R2R,Manufacturing, Inventory and warehouse management, etc. from JDE into SAP S4/Hana applicationsbased on data specification requirements, consolidation, transformation rules and other validations thatwere to be executed with right precision in short timeframe, and in compliance with their regulated datavalidation requirements. Multiple rounds of data migration were executed, performing ETL as per thedata specification and providing pre and post load execution reports that were reviewed and signed offby the business.Business SituationClient’s legacy data in JDE wasn’t consistent and complete. Migration specification and transformationrequirements needed to address SAP functional design needs being implemented. Business team hadto have the required SAP domain knowledge to review and approve the pre and post load executionreports provided by ChainSys, so that they could understand how the functional specification was usedto extract and transform source data into the SAP target instance.Technical SolutionChainSys deployed appMigrate (part of the offering from DataZap). Connectivity was established directlywith the JDE/SAP ECC systems (source) and the required ETL performed as per the data specification andtransformation rules. After performing the ETL, preload and post load report (in excel format) was providedto the client to review the data and approve. After the actual data load into SAP, the post load report(in excel format) was sent for reconciliation.

End to End Holistic Data Migration ourceData MartConfigureExtracts/ LoadersPreload Process(Transformation /Cleansing)ManualExtract DataRunExtractionCorrect missingsetups in TargetCorrect the Datain Data MartSetupError sinessReview theData Errors andProvide SolutionSuccess RecordsProcessLoadingPre-ValidationError TrackerError DataChainSysPost LoadReportPostLoadVerificationin S/4EndGPO/SME/SI

Object ListS.NoObject 4445Bank MasterCharacteristicsClassCost CenterInspection MethodStorage BinWork CenterCustomerMaterialVendorHR Mini MasterMaterial Classification - BatchProduct Master (For EWM)BatchCustomer Credit LimitsCustomer Material Info RecordEmployee as VendorPurchase Info RecordEquipmentSource ListMaster Inspection CharacteristicMaterial BOMRoutingPricing condition (sales)Quality Info RecordFixed AssetsPrice BookProduct Classification - Commodity CodeMaterial Listing (Inclusion & Exclusion)SerialInspection PlanPurchasing Scheduling AgreementSales BOMMaterial Inventory Balance - WMProduction VersionBOM Condition Record - RecipientBOM Condition Record - SenderComponent AllocationMaterial ConsumptionFI – G/L account balance and open/line itemFI-Accounts PayableFI-Accounts ReceivableMaterial Inventory Balance - IMPurchase OrderSales DEWMD2DD2DD2DD2DD2DR2RR2RR2RP2PP2PO2C

SolutionsBenefitsChainSys deployed dataZap for migrating data fromJDE / SAP ECC to SAP S4/Hana.The exercise was to migrate the master and transaction objects,as defined in the scope and the requirement specification document.The key benefit to the client was leveraging the prebuilt templatesthat ChainSys had delivered for extraction, transformation and load(ETL) processes using the mapping of JDE source fields to theSAP S4/Hana target fields and executing them through the BAPIwithout starting to build them from scratch. The client wassuccessfully able to migrate through testing in iterative rounds,in compliance with their data validation and compliance needs.As part of ETL, data was cleansed, enriched and deduped, resultingin improved data quality of the migrated data.Products and Services used for theExtraction,Transformation,Cleansing & Load of setups,Masters & Transaction.

Supported Endpoints ( Partial )Oracle Sales Cloud, Oracle Marketing Cloud, Oracle Engagement Cloud,Oracle CRM On Demand, SAP C/4HANA, SAP S/4HANA, SAP BW,SAP Concur, SAP SuccessFactors, Salesforce, Microsoft Dynamics 365,Workday, Infor Cloud, Procore, Planview Enterprise OneCloudApplicationsOracle E-Business Suite, Oracle ERP Cloud, Oracle JD Edwards,Oracle PeopleSoft, SAP S/4HANA, SAP ECC, IBM Maximo, Workday,Microsoft Dynamics, Microsoft Dynamics GP, Microsoft Dynamics Nav,Microsoft Dynamics Ax, Smart ERP, Infor, BaaN, Mapics, BPICSEnterpriseApplicationsWindchill PTC, Orale Agile PLM, Oracle PLM Cloud, Teamcenter, SAP PLM,SAP Hybris, SAP C/4HANA, Enovia, Proficy, Honeywell OptiVision,Salesforce Sales, Salesforce Marketing, Salesforce CPQ, Salesforce Service,Oracle Engagement Cloud, Oracle Sales Cloud, Oracle CPQ Cloud,Oracle Service Cloud, Oracle Marketing Cloud, Microsoft Dynamics CRMPLM, MES &CRMOracle HCM Cloud, SAP SuccessFactors, Workday, ICON, SAP APO and IBP,Oracle Taleo, Oracle Demantra, Oracle ASCP, SteelwedgeHCM & SupplyChain PlanningOracle Primavera, Oracle Unifier, SAP PM, Procore, Ecosys,Oracle EAM Cloud, Oracle Maintenance Cloud, JD Edwards EAM, IBM MaximoProject Management& EAMOneDrive, Box, SharePoint, File Transfer Protocol (FTP), Oracle Webcenter,Amazon S3Enterprise StorageSystemsHIVE, Apache Impala, Apache Hbase, Snowflake, mongoDB, Elasticsearch,SAP HANA, Hadoop, Teradata, Oracle Database, Redshift, BigQueryBig DatamangoDB, Solr, CouchDB, ElasticsearchNo SQL DatabasesPostgreSQL, Oracle Database, SAP HANA, SYBASE, DB2, SQL Server,MySQL, memsqlDatabasesIBM MQ, Active MQMessage BrokerJava, .Net, Oracle PaaS, Force.com, IBM, ChainSys PlatformDevelopmentPlatform

One Platform for yourEnd to EndData MigrationData ReconciliationData IntegarationData Management needsData Quality ManagementData GovernanceAnalytical MDMwww.chainsys.comData AnalyticsData CatalogData Security & Compliance

JDE and SAP systems into Carving out multiple SAP S/4HANA . Whitepaper. Client Overview Our client is a leading pharmaceutical company operating globally that was spun off from its parent, as part of a divestiture. Our client has a wide breadth of solutions that will continue to . SAP HANA