SAP S/4HANA
Setup, Master & Transactional Data Templates
Whitepaper
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.
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 S/4HANA, ECC, 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 S/4HANA. Using our Platform, our customers can migrate data from any Legacy application to SAP S/4HANA 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 S/4HANA application modules.
Value Propositions
Time Savings
Data Risk Eliminated
Improved quality in master data
Cost Savings
Test with your own data from
1st Test Cycle Improved Project Team
Morale and Collaboration
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
™Technical Details
dataZap Template Count SAP S/4 HANA Modules
dataZap Template Count by SAP S/4HANA Module
SD FI
MM PP CO WM HCM
25 50 75 100 125
Count of SAP Module 27.0%WM
4.4%CO HCM12.1%
10.5%FI
17.5%SD
14.1%MM 14.4%PP
No dataZap: SAP S/4HANA Template SAP Module
Partial SAP S/4HANA Setup, Master and Transactional Data Template List:
MAINTAIN CONTROLLING AREA MAINTAIN VERSIONS
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 BASES
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
Number Range Create 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
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 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 HCM 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
Open/Close posting period variant
Assignment of field Status Variant to Company Code Fiscal Year Variant
Assignment of fiscal year Variant to Company Code Sort Key
Tolerance Group For Employee Tolerance 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 EMPLOYEE GROUP
DEFINE DEDUCTION RULES FOR ABSENCE AND ATTENDANCE QUOTAS(V_556R_B)
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 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
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
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 EMPLOYEE SUBGROUP GROUPING
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
ASSIGN THE COUNTING RULE TO ABSENCE TYPE(V_554S_Q) M SET PERSONNEL SUB AREA GROUPING FOR TIME RECORDING 89
90
HCM HCM
91 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
DEFINE PAY SCALE TYPE CHECK PAY SCALE AREA Create Wage type
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 Organization 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 Vendor Account group
Number ranges for Vendor Account
Number ranges to Vendor Account Groups Planning groups
Terms of Payment key Incoterms
Payment block
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 MM
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 150 151 152
Special Movement indicators Partner roles
Permissible Partner to Account group Material types
Industry Loading Group Availability 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
Special Procurement Type Valuation Class
Item Category Group MRP Group
MRP Group for each Material Type
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
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 PP PP PP PP PP 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 181 182 183
Material Master Purchase info record Condition record Purchase requisition Purchase order Goods receipt Invoice verification
Business Partner - Vendor 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 CONTROL KEY SETUP TYPE WAGE GROUP SUITABILITY
CAPACITY CATEGORY
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 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 212 213 214
CAPACITY PLANNER ROUTING STATUSES USAGE OF TASK LIST PLANNER GROUP ORDER TYPES
ORDER TYPE - DEPENDENT PARAMETERS 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 PRODUCTION ORDER RELEASE
PRODUCTION ORDER HEADER CONFIRMATION PRODUCTION ORDER OPERATION CONFIRMATION GOODS ISSUE AGAINST PO
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 243 244 245
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
Maintain reserve fields in customer master Delivery priority
Define terms of payment Define inco terms
PP PP SD SD 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
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 274 275 276
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 Condition table
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 Assign Schedule line categories
Assign sales area to sales document types Business Partner - Customer
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
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 305 306 307
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 parameter 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 staging areas Define storage bin type Define blocking reason Define storage bin structure Define storage type indicators Define storage unit type
Define storage section indicators Define special movement indicators Define bulk storage indicators
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 WM WM WM
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 336 337 338
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 and SUNIT Define strategy for bulk storage: Define storage type control Define strategy for bulk storage: Block structure
Define strategy for near picking bin: putaway strategy Define strategy for near picking bin: storage type control Define strategy for near picking bin: scratch width per level Define strategy for near picking bin: row shelf
Define FIFO strategy
Define strategy for "stringent FIFO": Exception for inds types Define strategy for "stringent FIFO": stringent FIFO SLED mgmt..
Define LIFO strategy
Define strategy for partial pallet quantity
Define strategy for large and small quantity: Activate stock removal strategy Define strategy for large and small quantity: store type search
Define strategy for expiry date
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
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 367 368 369
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
Define print control : storage type Define print control : movement type Define print control : warehouse number
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
370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389
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
WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM WM
There is great value in automating your Data migrations for SAP S/4HANA Applications using dataZap.
The Platform is used during the Implementation/Rollouts of the SAP S/4HANA 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.
Conclusion
This is a great SAP certified solution for SAP S/4HANA Application releases.
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
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
Oracle HCM Cloud, SAP SuccessFactors, Workday, ICON, SAP APO and IBP, Oracle Taleo, Oracle Demantra, Oracle ASCP, Steelwedge
Oracle Primavera, Oracle Unifier, SAP PM, Procore, Ecosys,
Oracle EAM Cloud, Oracle Maintenance Cloud, JD Edwards EAM, IBM Maximo
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
mangoDB, Solr, CouchDB, Elasticsearch
PostgreSQL, Oracle Database, SAP HANA, SYBASE, DB2, SQL Server, MySQL, memsql
IBM MQ, Active MQ
Java, .Net, Oracle PaaS, Force.com, IBM, ChainSys Platform 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
Cloud
Applications
PLM, MES &
CRM
HCM & Supply Chain Planning
Project Management
& EAM
Enterprise Storage Systems
Big Data
No SQL Databases
Databases
Message Broker Development Enterprise Applications
One Platform for your
Data Management needs
End to End
www.chainsys.com Data Migration
Data Reconciliation Data Integaration
Data Quality Management Data Governance
Analytical MDM
Data Analytics Data Catalog
Data Security & Compliance
