SAP ECC Applications Setup, Master and Transactions Templates

1. SAP ECC Setup, Master & Transactional Data Templates Whitepaper www.chainsys.com

2. Introduction Oracle Cloud Application data migrations of setup, master and transactional data are complex. For the past two-decade, SAP customers have taken advantage of our dataZap Platform to automate Data migrations for SAP ECC, S/4HANA, C/4HANA and SuccessFactors Applications from any Legacy systems. ChainSys proudly offers a complete innovative templated approach for migrating Setup, Master and Transactional Data for SAP ECC. Using our Platform, our customers can migrate data from any Legacy application to SAP ECC Application Instances and also, we offer ready to use data migration mappings from leading applications such as Oracle EBS/JDE/Peoplesoft, Microsoft, Workday, Salesforce, IBM and Infor to SAP ECC application modules. Value Propositions Improved quality in master data Time Savings Cost Savings Test with your own data from 1st Test Cycle Improved Project Team Morale and Collaboration Data Risk Eliminated Charlie Massoglia VP & CIO, Chain-Sys Corporation. ChainSys Corporation Former CIO for Dawn Food Products For 13+ years. 25+ years experience with a variety of ERP systems. Extensive experience in system migrations & conversions. Participated in 9 acquisitions ranging from a single US location to 14 sites in 11 countries. Author of numerous technical books, articles, presentations, and seminars globally. 2

3. ™ Use Cases Migrate Master and Transactional data (Open and Historical) from Oracle Applications (Oracle Cloud, Peoplesoft, JD Edwards, Siebel and EBS), SAP ECC, Microsoft, Workday, Salesforce, IBM, Infor and other Legacy Applications to SAP ECC application modules Re-engineering of SAP ECC Applications – LE, Company or Plant restructuring Handle all your mergers and acquisition needs very timely and cost effective. Create a templated approach to your growth strategy. Mass load master and transactional data into SAP ECC Applications from Excel, Google Sheets and MS Office 365. Report the Masters and Transactions existing in the Legacy Source applications. Slice and dice the data for assessments and data cleanup. Report the data quality and data incompleteness issues to prepare the data well in advance. Create an auditable release Mgmt. process for Data Maintenance activities in SAP ECC Application modules. Accelerate Data Migrations in SAP ECC Applications for Merger and acquisitions / Divestitures / Carve outs Accelerate Data Migrations in SAP ECC Applications for Instance consolidations Compare Data across SAP ECC Applications and incremental data can be migrated from source to target and vice versa for Test data preparations. Reconciliations for Data Migrations – Flexible layouts and formats available for your dynamic view of data migration results pre and post migrations. Smart Data Platform™ 3

4. Technical Details dataZap Template Count SAP ECC Module CO 4.6% FI 10.5% WM 27.0% HCM 12.1% MM 14.4% SD 17.2% PP 14.1% Count of SAP Module CO FI HCM MM PP SD WM 25 50 75 100 125 Count of SAP Module 4

5. Partial SAP ECC Setup, Master and Transactional Data Template List: No 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 dataZap: SAP ECC Template Maintain Controlling Area Maintain Versions Creation of Cost Center Groups Define Order Types Assign Controlling Area to Operating Concern Define Valuation Strategy Define Access to Standard Cost Estimate Assign Costing Key to Products Assign Costing Key to Material Types Define Overheads Keys Define Overheads Groups Define Calculation Basis Define Percentage Overhead Rates Define Credits Define Costing Sheets Define Cost Component Structure Define Settlement Profile Define Origin Groups Company Company Code Business Area Chart Of Accounts Account Group Assign Company code to Company Assign COA to Company Code Retained Earning Accounts Posting Period Variant Assignment of Posting period Variant to Company Code Document Type Create SAP Module CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO FI FI FI FI FI FI FI FI FI FI FI 5

6. Number Range Create Open/Close posting period varient Assignment of field Status Variant to Company Code Fiscal Year Variant Assignment of fiscal year Variant to Company Code Sort Key Tolernce Group For Employee Tolernce Group For G/L Statistical Key Figure Internal Order Profit center Cost center Bank Asset Master(AS01) Asset Master(AS91) GL Master Activity Type Business Process Open GL Open AP Open AR Assign chart of depreciation to Company code Specify Account determination Create Screen layouts Define Asset class Define Base methods Define declining balance method Define multilevel method Maintain period control method Maintain depreciation key Personnel Sub Area 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI FI HCM 6

7. EMPLOYEE GROUP EMPLOYEE SUB GROUP ASSIGN EMPLOYEE SUB GROUP TO EMPLOYEE GROUP USER GROUP DEPENDENCY ON MENU AND INFO GROUP INFO GROUP CREATE REASONS FOR PERSONNEL ACTIONS CHANGE ACTION MENU MAINTAIN NUMBER RANGE INTERVAL FOR PERSONNEL NUMBER DEFINE EMPLOYEE ATTRIBUTES CREATE PAYROLL AREA CREATE CONTROL RECORD DEFINE PUBLIC HOLIDAYS(FIXED HOLIDAY) DEFINE PUBLIC HOLIDAYS(FLOATING HOLIDAY) GROUP PERSONAL SUB AREA FOR THE WORK SCHEDULE CREATE FACTORY CALENDAR DEFINE BREAK SCHEDULES DEFINE DAILY WORK SCHEDULES PERIOD WORK SCHEDULES DEFINE GROUPING FOR THE PUBLIC HOLIDAY CALENDAR SET WORK SCHEDULE RULES AND WORK SCHEDULES GENERATE WORK SCHEDULES MANUALLY GROUP PERSONNEL SUBAREAS FOR ATTENDANCE AND ABSENCES DEFINE ABSENCE TYPES DETERMINE ENTRY SCREEN AND TIME CONSTRAINT CLASSES GROUP EMPLOYEE SUBGROUPS FOR TIME QUOTAS GROUP PERSONNEL SUBAREA FOR TIME QUOTAS DEFINE ABSENCE QUOTA TYPES SET BASE ENTITLEMENT DEFINE DEDUCTION RULES FOR ABSENCE AND ATTENDANCE QUOTAS(V_556R_B) ASSIGN THE COUNTING RULE TO ABSENCE TYPE(V_554S_Q) M SET PERSONNEL SUB AREA GROUPING FOR TIME RECORDING 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM 89 HCM 90 91 HCM HCM 7

8. DEFINE PAY SCALE TYPE CHECK PAY SCALE AREA CHANGE WAGE TYPE TEXT CHECK WAGE TYPE TEXT CHECK ENTRY PERMISSIBILITY PER INFOTYPE CHECK WAGE TYPE CHARACTERISTICS(V_T511) EMPLOYEE SUBGROUPS FOR PRIMARY WAGE TYPES DEFINE PAY SCALE SALARY RANGE(3000) REVISE PAY SCALE GROUPS AND LEVELS REVISE DEFAULT WAGE TYPES(V_T539A) DEFINE PERIOD MODIFIERS DEFINE DATE MODIFIERS CREATE JOB CREATE POSITIONS CREATE ORG UNIT Plant Purchasing Organisation Storage Location Purchasing group Warehouse number Plant to Company code Purchasing org to company code Purchasing org to plant Warehouse number to plant / storage location Assign Business Area to Plant/Valuation Area and Division Vendor Account group Number ranges for Vendor Account Number ranges to Vendor Account Groups Planning groups Terms of Payment key Incoterms 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM 8

9. Number ranges to Vendor Account Groups Planning groups Terms of Payment key Incoterms Payment block Special Movement indicators Partner roles Permissible Partner to Account group Material types Industry Loading Group Availablity check Material Groups Division Material Statuses Lab / Office Basic Materials Storage Conditions Temperature Conditions Container Requirements UOM Groups Product Hierarchy Sales Statuses Storage Type Indicators Purchasing Value Key MRP Type MRP Controller Lot Size Planning Calendar Coverage Profile Unit Of Measure 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM MM 9

10. 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 Special Procurement Type Valuation Class Item Category Group MRP Group MRP Group for each Material Type Material Master Purchase info record Conditon record Purchase requisation Purchase order Goods receipt Invoice verification Vendor Master MRP CONTROLLER MRP TYPE LOT SIZE MRP GROUPS MRP GROUP - MATERIAL TYPE SPECIAL PROCUREMENT TYPE REQUIREMNT CLASS REQUIREMENT TYPE STRATEGY FOR MRP STRATEGY GROUP BOM USAGES BOM STATUS ITEM CATEGORIES WORK CENTER CATEGORY TASK LIST USAGE STANDARD VALUE KEY PERSON RESPONSIBLE MOVE TIME MATRIX MM MM MM MM MM MM MM MM MM MM MM MM MM PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP 10

11. CONTROL KEY SETUP TYPE WAGE GROUP SUITABILITY CAPACITY CATEGORY CAPACITY PLANNER ROUTING STATUSES USAGE OF TASK LIST PLANNER GROUP ORDER TYPES PRODUCTION SUPERVISOR SHEDULING PARAMETER PRODUCTION SHEDULING PROFILE CHECKING GROUP CHECKING RULE SCOPE OF CHECK VALUATION FOR GOODS RECEIVED ORDER CONTROL DEFAULT VALUES FOR GENERATION OPERATION CONFIRMATION PARAMETERS DEFINE REPETITIVE MANUFACTURING PROFILE SORT STRING MACHINE TYPE CAPP PLANNER GROUP WORKCENTER LOCATION SUPPLY AREA WORK CENTER BOM ROUTING PRODUCTION VERSION PRODUCTION ORDER CREATE 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP PP 11

12. PRODUCTION ORDER RELEASE PRODUCTION ORDER HEADER CONFIRMATION PRODUCTION ORDER OPERATION CONFIRMATION GOODS ISSUE AGAINST PO GOODS RECEIPT AGAINST PO BATCH Sales Organization Distribution channel Division Sales office Sales group Storage location Shipping point Assign plant to company code Assign sales org to company code Assign distribution channel to sales org Assign division to sales org Set up sales area Assign sales office to sales area Assign sales group to sales office Assign sales org -distribution channel to plant Define rules by sales area Assign business area by sales area Assign shipping point to plant Define Transportation connecting point Define number range Assign number range to customer account group Define industry sector for customer Define customer classification Define customer group Define sales district 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 PP PP PP PP PP PP SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD 12

13. Maintain reserve fields in customer master Delivery priority Define terms of payment Define inco terms Define standard department Define contact person functions Define authority Define call frequency Define buying habit Define VIP indicator Define transportation zone Define transportation group Maintain country and transportation zone for shipping point Define route Maintain route determination Define Access sequence Define Condition type Define pricing procedure Pricing procedure determination Shipping point determination Picking location determination Define purchase order types Define order reason Define usage indicator Define item category group Define item category usage Assign item category Define rejection reason Define sales document type Define item categories Define Schedule line categories 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD SD 13

14. Assign Schedule line categories Assign sales area to sales document types Customer Master Customer Material info record - Cooper Condition record - Cooper Inquiry - SAPPHIRE Quotation - SAPPHIRE Sales order - SAPPHIRE Outbound Delivery - SAPPHIRE Post goods issue - SAPPHIRE Billing - SAPPHIRE Define, copy, delete, check warehouse number Assign warehouse number to plant storage location Define control paramenter for warehouse number Define number range for warehouse number NUMBER RANGE FOR TRANSFER REQUIREMENT Define number range for TRANSFER ORDER Define number range for QUANT Define number range for POST CHANGE NOTICE Define number range for GROUP Define number range for STORAGE UNIT Define storage type Define storage section Define picking area Define doors Define material sateging areas Define storage bin type Define blocking reason Define storage bin structure Define storage type indicators Define storage unit type 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 SD SD SD SD SD SD SD SD SD SD SD WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM 14

15. Define storage section indicators Define special movement indicators Define bulk storage indicators Activate storage type search: Define search sequence Activate storage type search: Movement type reference Activate storage type search Activate storage section search : define search sequence Activate storage section search Activate storage bin type search : storage type Activate storage bin type search : storage bin type Activate storage unit type check Define sort sequence for putaways (cross-line stock putway) Define sort sequence for stock removal (picking) Define strategy for fixed bins Define strategy for open storage Define strategy for addition existing stock Define strategy for empty storage bin Define strategy for pallets : putaway strategy Define strategy for pallets : define bin section Define strategy for pallets : Assign bin types ans SUNIT Define strategy for bulk storage : Define storage type control Define strategy for bulk storage : Block structure Define strategy for near picking bin : putaway sarategy Define strategy for near picking bin : storage type control Define strategy for near picking bin : scrch width per level Define strategy for near picking bin : row shelf Define FIFO strategy Define strategy for "stringent FIFO" : Exception for ind stypes Define strategy for "stringent FIFO" : stringent FIFO SLED mgmt Define LIFO strategy Define strategy for partial pallet quantityT 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM 15

16. Define strategy for large and small quanttity : Activate stock removal strategy Define strategy for large and small quanttity : stor typ search Define strategy for expiry date Define fixed bin strategy Define fir contaminent sections Define hazardous material warning Define hazardous material storage warning Define aggregate states Define region code Define storage class Activate hazardous material management : Assign region to W.NUMBER Activate hazardous material management : Storage class allowed Define requirement Type Define shipment type Define movement type Define stock transfer and replenishment control Set up autom.TO creation for TRs/posting change notice] : MAIL CONTROL Set up autom.TO creation for TRs/posting change notice] : Automatic TO CREATION Set up autom.TO creation for TRs/posting change notice] : MOVEMENTS Set up 2 step picking for transfer requirement : TR CONTROL Set up 2 step picking for transfer requirement : Transfer type control Confirmation : Difference indicators Confirmation : control W NUMBER Confirmation : control STORAGE TYPE Confirmation : control MOVT TPE Define print control : Spool code Define print control : printer lable Define print control : printer collc profile Define print control : print code Define print control : warehouse movement Define print control : picking area 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM 16

17. Define print control : storage type Define print control : movement type Define print control : warehouse number Define print control : multiple proc Define default values Define type per storage type Define difference and document limits Clear differences (interfaces to inventory management ) Maintain number range : Assign number ranges Maintain number range : intervals for inventory Activate storage unit management per warehouse number STORAGE UNIT : Define number range Define storage type control Define bulk storage area : Storage type control Define bulk storage area : define block strategy Supply area Control cycle Storage bin Mass storage bin Transfer order request Transfer order Transfer order wrt delivery Transfer order confirmation 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM Conclusion There is great value in automating your Data migrations for SAP ECC Applications using dataZap. The Platform is used during the Implementation/Rollouts of the SAP ECC Applications and also for every day mass data creation and update needs. Also, the Platform eliminates the need for creating manual reconciliation document and helps with identifying the mismatch in data (Pre and Post load reconciliations). Get the great data quality you deserve. This is a great SAP certified solution for SAP ECC Application releases. 17

18. 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 One Cloud Applications Oracle 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, BPICS Enterprise Applications Windchill 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 CRM PLM, MES & CRM HCM & Supply Chain Planning Oracle HCM Cloud, SAP SuccessFactors, Workday, ICON, SAP APO and IBP, Oracle Taleo, Oracle Demantra, Oracle ASCP, Steelwedge Project Management & EAM Oracle Primavera, Oracle Unifier, SAP PM, Procore, Ecosys, Oracle EAM Cloud, Oracle Maintenance Cloud, JD Edwards EAM, IBM Maximo Enterprise Storage Systems OneDrive, Box, SharePoint, File Transfer Protocol (FTP), Oracle Webcenter, Amazon S3 HIVE, Apache Impala, Apache Hbase, Snowflake, mongoDB, Elasticsearch, SAP HANA, Hadoop, Teradata, Oracle Database, Redshift, BigQuery Big Data No SQL Databases mangoDB, Solr, CouchDB, Elasticsearch PostgreSQL, Oracle Database, SAP HANA, SYBASE, DB2, SQL Server, MySQL, memsql Databases Message Broker IBM MQ, Active MQ Development Platform Java, .Net, Oracle PaaS, Force.com, IBM, ChainSys Platform 18

19. One Platform for your End to End Data Management needs Data Migration Data Reconciliation Data Integaration Data Quality Management Data Governance Analytical MDM Data Analytics Data Catalog Data Security & Compliance www.chainsys.com