| Status | |
|---|---|
| Owner | |
| Stakeholders | The business stakeholders involved in making, reviewing, and endorsing this decision. Type @ to mention people by name |
| Team Involved | Area |
| Metawat Sawasdee | Business |
| Umesh Mudri? | Technical |
| Shivang Dala? | Technical |
| Laura Santamarta | Functional |
| Functional |
The purpose of this document is to define the conversion approach to migrate Vendor Doc Attachments to S/4 HANA.
This allows to associate relevant documents, like contracts or certifications, with specific vendors.
Attachment Functionality in SAP ECC
- Storage Method: Attachments are typically stored using Generic Object Services (GOS), which allow users to link files to vendor documents (via transaction codes like ME21N, ME22N, ME23N).
- Technical Reference: The attachments are managed via the Business Object Repository (BOR) object. The Business Object Repository (BOR) in SAP is a central access point for SAP business object types and their corresponding Business Application Programming Interfaces (BAPIs). It provides an object-oriented view of data and processes within an SAP system and is crucial for integrating SAP with external applications. The BOR also plays a role in SAP Business Workflow, ArchiveLink, and output control.
Attachment Functionality at Syensqo
The GOS functionality is set up to store documents into an ECM (Enterprise Content Management) system. This is a separate system from ECC and S4/HANA, but is natively integrated to ECC.
KDD085 recommends the use of OpenText ECM for storage of documents attached to transactions in SAP, e.g. via GOS if supported. The KDD doesn't cover whether this should be a new instance of ECM, or reuse the existing ECM, or implement a totally new SaaS offering from OpenText; this is a more complex topic which also requires consideration of regulatory requirements and cybersecurity, which needs a separate design document.
However this determines what kind of migration is needed - for example do we leave the documents in-situ and only migrate the open items from ECC and their metadata links? Or do we also need to physically move the documents as well?
TBC
CLEAN UP
Key tables for Attachments are:
| Table | Name | What is the table for? | To be included in migration? |
| SRGBTBREL | Relationship Table for GOS Objects | This table links the GOS Object (like a vendor) to the actual attached document, storing the object type, instance ID, and document details. | YES |
| SOOD | Object definition | The SOOD table consists of various fields, each holding specific information or linking keys about SAPoffice: Object definition data available in SAP. These include OBJTP (Code for document class), OBJYR (Object: Year from ID), OBJNO (Object: Number from ID), OBJLA (Language in Which Document Is Created). | ? |
| TOJTB | Business object repository: Basic data | The TOJTB table consists of various fields, each holding specific information or linking keys about Business object repository: Basic data data available in SAP. These include ACTIVE (Object type generated), ACTIVELANG (Language Key), PARENT (Supertype), PROGNAME (Implementation program)... | ? |
| SOFFCONT1 | SOFF: Table for Document Contents (import/export) | The SOFFCONT1 table consists of various fields, each holding specific information or linking keys about SOFF: Table for Document Contents (import/export) data available in SAP. These include RELID (Region in IMPORT/EXPORT Data Table), PHIO_ID (Physical document), SRTF2 (Next record counter in EXPORT/IMPORT data tables), PH_CLASS (Physical document class) | ? |
| MDOBLREL | Model data: Relationship types | The MDOBLREL table consists of various fields, each holding specific information or linking keys about Model Data: Relationship Types data available in SAP. These include ROLEA (Role That an Object Takes in the Relationship), ROLEB (Role That an Object Takes in the Relationship), CARDA (Role Cardinality), CARDB (Role Cardinality) | ? |
| LFA1 | Vendor master (General Section) | GOS info is linked to this table | NO |
| LFB1 | Vendor master (Company Code) | GOS info is linked to this table | NO |
| LFM1 | Vendor master record purchasing organization data | GOS info is linked to this table | NO |
TABLE LINKS
Link between the SOOD and SRGBTREL tables.
SRGBTBREL's INSTID_B field, often by parsing it to extract the document type, year, and number, to then retrieve the corresponding record from the SOOD table.
Identify the Attachment Link:
In the SRGBTBREL table, the fieldsINSTID_A and TYPEID_A identify the business object (e.g., a sales order), and INSTID_B identifies the attachment. Parse the Attachment Information:
TheINSTID_B field in SRGBTBREL contains the key information for the SOOD table. This field needs to be parsed to extract the document's attributes, including: Link to SOOD:
Use the parsed values to find the corresponding record in the SOOD table.SOOD-OBJTY = SRGBTBREL-INSTID_B+17(3) SOOD-OBJYR = SRGBTBREL-INSTID_B+20(2) SOOD-OBJNO = SRGBTBREL-INSTID_B+22(12)Example
If you are looking for an attachment to a material, you might select from SRGBTBREL where RELTYPE = 'URL' and INSTID_A is the material number. The INSTID_B field will then hold the information to link to the document in SOOD.
OBJECT TYES RELEVANT (TBC - with Laura Santamarta)
LFA1
LFB1
LFM1
These would cover documents such as Bank account details, Qualification details, Registration details, etc.
The following list includes the objects can also be included. TBC
BUS2009 - Purchase Requisition Item
BUS2010 - Vendor Quotation Request
BUS2011 - Vendor Quotation
BUS2012 - Purchase Order
BUS2013 - Purchase Scheduling Agreement
BUS2014 - Purchase Contract
BUS2015 - Inbound Delivery
BUS2020 - Vendor Document
BUS2025 - Purchasing Contract
BUS2052 - Purchase Outline Agreement
BUS2105 - Purchase Requisition
BUS2125 - Vendor related Customer Billing Document
BUS2126 - Vendor Billing Document
BUS2126001 Single Vendor Billing Document
BUS3003 Purchasing information
BUS3008 - Vendor Account
Changes in SAP S/4HANA
- Attachments are linked using the Attachment List Service (also used in Fiori apps).
- Technically embedded in the Business Object Processing Framework (BOPF) or handled by Object Page Layout for Fiori views
- User Experience Enhancements: Drag-and-drop uploads via Fiori.
Attachment Types
Any type of document can be an attachment, and can be attached when the user creates a PO from the shopping cart.
In most cases this is a PDF type attachment, and includes Invoices, Specs, Emails....
The scope of this document covers the approach for converting active Attachments for Vendors from Legacy Source Systems into S/4HANA following the S2P Master Data Design Standard.
The data from legacy system includes:
The data from legacy system excludes:
| Source | Scope | Source Approx No. of Records | Target System | Target Approx No. of Records |
|---|---|---|---|---|
| WP2 | Attachment for Open Purchase orders | S4 Hana ROW | ||
| PF2 | Attachment for Open Purchase orders | S4 Hana ROW | ||
| WP2 | Attachment for Open Purchase orders | S4 Hana China | ||
| PF2 | Attachment for Open Purchase orders | S4 Hana China | ||
| WP2 | Attachment for Open Purchase orders | S4 Hana CUI | ||
| PF2 | Attachment for Open Purchase orders | S4 Hana CUI |
N/A
Generic Object Services (GOS) is a functionality that allows users to attach documents, notes, and other objects to business objects like purchase orders. It provides a standard way to manage and access these attachments within various SAP transactions, including those related to purchase orders.
The following are the key concepts for POs.
Attachment Management:
GOS enables users to add attachments (like PDFs, Word documents, etc.) to purchase orders, either directly within the transaction or through a separate DMS (Document Management System) if configured.Viewing Attachments:
GOS also allows users to view the attachments associated with a specific purchase order.Object Relationships:
GOS can also show relationships between the purchase order and other objects, like IDocs, workflows, or other related documents.Toolbar/Button:
The GOS functionality is typically accessed through a toolbar button or a menu option within the purchase order transaction (e.g., ME21N, ME22N, ME23N).Customization:
In some cases, the GOS button or functionality might need to be activated for specific transactions or user roles using customizing settings.
The Business Object Repository (BOR) in SAP is a central access point for SAP business object types and their corresponding Business Application Programming Interfaces (BAPIs). It provides an object-oriented view of data and processes within an SAP system and is crucial for integrating SAP with external applications. The BOR also plays a role in SAP Business Workflow, ArchiveLink, and output control.
Key aspects of the BOR and Purchase Orders:
Centralized Access:
The BOR acts as a single point of access for all business objects and their associated BAPIs.Object-Oriented View:
It provides an object-oriented perspective of business processes, allowing for modular and reusable components.Purchase Order Object:
The purchase order business object (type BUS2012) is a key object within the BOR, representing purchase order data and operations.BAPIs and Methods:
BAPIs, which are remote-enabled ABAP function modules, are used to implement the methods of business objects. For example, a BAPI might be used to change a purchase order item or retrieve purchase order details.Attributes and Parameters:
Business objects have attributes that store object properties (e.g., purchase order number, vendor) and methods use import/export parameters to pass data between different parts of the system.BOR Browser:
The Business Object Repository Browser (transaction code SWO1) allows users to browse, display, and maintain business objects and their components.Integration:
The BOR facilitates the integration of SAP with other systems, such as through middleware.Workflow and Other Services:
The BOR is used in SAP Business Workflow, ArchiveLink, output control, and other generic object services.
The DMS approach is elaborated in KDD "Document Management in the SyWay Solution".
CMMC 2.0 is a mandatory DoD cybersecurity certification for contractors handling Controlled Unclassified Information (CUI) and Federal Contract Information (FCI). CUI includes sensitive technical data (e.g., design specs, system info) related to U.S. military and space applications. The Composites Business handles CUI and is therefore within CMMC scope. Without certification, the business risks disqualification from existing and future DoD programs.
It is mandatory to implement CMMC-compliant systems and processes to for all the organizations that are dealing with CUI.
Therefore, there will be one SAP instance specifically for CUI related entities. The migration for CUI related entities will be covered by US based data consultant using separate tools.
Different SAP Instance Migration Approach - Separate document required
Due to compliance requirement, there will be one SAP instance for Rest of the World, one for China and one for CUI.
Please refer to the link for the entity mapping for each instance. In case the data object is applicable for multiples instances, what business rule to follow?
Cybersecurity - Separate document required
With Functional input, document the technical design of the target fields that are in the scope of this document.
The technical design of the target for this conversion approach.
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement | Format |
|---|---|---|---|---|---|---|---|
| SRGBTBREL | CLIENT | Client | C | 3 | Internal (Mandatory) | Three digit client number | |
| SRGBTBREL | BRELGUID | GUID | X | 16 | Internal (Mandatory) | RAW: Binary data — used here for GUID; generally used internally. | |
| SRGBTBREL | RELTYPE | Relationship type | C | 10 | Mandatory | Check table MDOBLREL (ensures only valid relationship types are used) | |
| SRGBTBREL | INSTID_A | Instance ID | C | 70 | Mandatory | Length 70 (CHAR) | |
| SRGBTBREL | TYPEID_A | Object Type | C | 32 | Mandatory | Length 32 (CHAR) | |
| SRGBTBREL | CATID_A | Object Category | C | 2 | Mandatory | Length 2 (CHAR) | |
| SRGBTBREL | INSTID_B | Instance ID | C | 70 | Internal (Mandatory) | Length 70 (CHAR) | |
| SRGBTBREL | TYPEID_B | Object Type | C | 32 | Internal (Mandatory) | Length 32 (CHAR) | |
| SRGBTBREL | CATID_B | Object Category | C | 2 | Internal (Mandatory) | Length 32 (CHAR) | |
| SRGBTBREL | LOGSYS_A | Logical System | C | 10 | Not in use | ||
| SRGBTBREL | ARCH_A | Object Archived | C | 1 | Not in use | ||
| SRGBTBREL | LOGSYS_B | Logical System | C | 10 | Not in use | ||
| SRGBTBREL | ARCH_B | Object Archived | C | 1 | Not in use | ||
| SRGBTBREL | UTCTIME | Short Time Stamp | P | 8 | Internal (Mandatory) | Format YYYYMMDDhhmmss | |
| SRGBTBREL | HOMESYS | Logical System | C | 10 | Not in use |
All data cleansing should take place in the data source system as defined in this document, unless system limitations prevent it.
If data cleansing is managed outside of the source system (e.g. Syniti Migrate, 3rd Party Vendor, DCT), the necessary documentation must be produced and appended to this deliverable for sign-off.
| ID | Criticality | Error Message/Report Description | Rule | Output | Source System |
|---|---|---|---|---|---|
| 1 | High | Review and remove the obsolete attachments from the load. | Exclude where Vendor Out of scope. | In-scope vendor attachments only | PF2/WP2 |
| 2 | High | Review and remove the OOS object types. | Exclude where object types not in "LIST". | Applicable Objects type only | PF2/WP2 |
| 3 | High | Only vendors with attachments | Exclude in-scope vendors with no attachments | Only vendors with attachments | PF2/WP2 |
SAP's document migration process involve three parts:
Various tools are used in the migration process, which are TBC.
The Rest of the World and China follows the process below, using Syniti ADMM.
The high-level process is represented by the diagram below:
Summarize High-Level Process. Include diagrams, where applicable. Include information supporting details of Extract, Transform and Load specific to the Data Object
For CUI instance, the ETL process will be similar, but it will not use Syniti tool.
Extract data from a source systems into ADMM:
All records need to be extracted but due to the high volumes, the agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads.
| Req # | Requirement Description | Team Responsible |
|---|---|---|
| - Identify the source systems and databases involved. | Syniti/Data | |
| - Define the data objects (tables, fields, records) to be extracted. | Syniti/Data | |
| - Specify the extraction approach (full, incremental, or delta extraction). | Syniti/Data | |
| - Determine the tools and technologies used. | Syniti/Data | |
| - Define data filtering criteria to exclude irrelevant records. | Syniti/Data | |
| - Establish execution timelines and batch processing schedules. | Syniti/Data | |
| - Assign responsibilities for extraction monitoring. | Syniti/Data | |
| - Document dependencies on other migration tasks. | Syniti/Data | |
| - Define error handling mechanisms for extraction failures. | Syniti/Data | |
Extraction Run Sheet (for files extraction portion)
| Req # | Requirement Description | Team Responsible |
|---|---|---|
| - Identify the source systems and databases involved. | S2P/GOS | |
| - Specify the extraction approach (full, incremental, or delta extraction). | S2P/GOS | |
| - Determine the tools and technologies used. | S2P/GOS | |
| - Define data filtering criteria to exclude irrelevant records. | S2P/GOS | |
| - Establish execution timelines and batch processing schedules. | S2P/GOS | |
| - Assign responsibilities for extraction monitoring. | S2P/GOS | |
| - Document dependencies on other migration tasks. | S2P/GOS | |
| - Define error handling mechanisms for extraction failures. | S2P/GOS |
| Selection Ref Screen | Parameter Name | Selection Type | Requirement | Value to be entered/set |
|---|---|---|---|---|
| N/A | ||||
<Object> DCT Rules
| Field Name | Field Description | Rule |
|---|---|---|
| N/A | ||
List the steps that need to occur before extraction can commence
| Item # | Step Description | Team Responsible |
|---|---|---|
Source Systems Availability
| Syensqo IT | |
Extraction Methodology
| ||
Data
| S2P | |
Performance and Scalability Considerations
| ||
Security and Compliance
|
The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow Syniti Migrate to make the data Target ready:
| Item # | Step Description | Team Responsible |
|---|---|---|
| 1 | Define Scope and transformation rules. Must be agreed and signed off by Business/Functionals Data Mapping and Standardization | |
| 2 | Discuss with Syniti team, who will be the implementers. Business Rule Application | |
| 3 | Agree extraction and processing parameters and execution Transformation Execution Plan | |
| 4 | Agree validation and put validation jobs in place to verify transforms have worked | Data/Syniti |
| 5 | Agree feedback sessions | Data/Syniti |
| 6 | Execute transforms | |
| 7 | Validate results | |
| 8 | Get signoff and go-ahead to progress |
Transformation Rules
| Rule # | Source system | Source Table | Source Field | Source Description | Add Info about field | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | PF2/WP2 | SRGBTBREL | CLIENT | Client | Internal (Mandatory) | S4H | SRGBTBREL | CLIENT | Client | System generated |
| 2 | PF2/WP2 | SRGBTBREL | BRELGUID | GUID | Internal (Mandatory) | S4H | SRGBTBREL | BRELGUID | GUID | System generated |
| 3 | PF2/WP2 | SRGBTBREL | RELTYPE | Relationship type | Mandatory | S4H | SRGBTBREL | RELTYPE | Relationship type | Copy (Standard Value = ATTA) |
| 4 | PF2/WP2 | SRGBTBREL | INSTID_A | Instance ID | Mandatory | S4H | SRGBTBREL | INSTID_A | Instance ID | Copy |
| 5 | PF2/WP2 | SRGBTBREL | TYPEID_A | Object Type | Mandatory | S4H | SRGBTBREL | TYPEID_A | Object Type | Copy Will include LFA1, LFB1, LFM1 |
| 6 | PF2/WP2 | SRGBTBREL | CATID_A | Object Category | Mandatory | S4H | SRGBTBREL | CATID_A | Object Category | Copy (Std value = BO) |
| 7 | PF2/WP2 | SRGBTBREL | INSTID_B | Instance ID | Internal (Mandatory) | S4H | SRGBTBREL | INSTID_B | Instance ID | Copy |
| 8 | PF2/WP2 | SRGBTBREL | TYPEID_B | Object Type | Internal (Mandatory) | S4H | SRGBTBREL | TYPEID_B | Object Type | Copy (Std value = MESSAGE) |
| 9 | PF2/WP2 | SRGBTBREL | CATID_B | Object Category | Internal (Mandatory) | S4H | SRGBTBREL | CATID_B | Object Category | Copy (Std value = BO) |
| 10 | PF2/WP2 | SRGBTBREL | LOGSYS_A | Logical System | Not in use | S4H | SRGBTBREL | LOGSYS_A | Logical System | N/A |
| 11 | PF2/WP2 | SRGBTBREL | ARCH_A | Object Archived | Not in use | S4H | SRGBTBREL | ARCH_A | Object Archived | N/A |
| 12 | PF2/WP2 | SRGBTBREL | LOGSYS_B | Logical System | Not in use | S4H | SRGBTBREL | LOGSYS_B | Logical System | N/A |
| 13 | PF2/WP2 | SRGBTBREL | ARCH_B | Object Archived | Not in use | S4H | SRGBTBREL | ARCH_B | Object Archived | N/A |
| 14 | PF2/WP2 | SRGBTBREL | UTCTIME | Short Time Stamp | Internal (Mandatory) | S4H | SRGBTBREL | UTCTIME | Short Time Stamp | System generated |
| 15 | PF2/WP2 | SRGBTBREL | HOMESYS | Logical System | Not in use | S4H | SRGBTBREL | HOMESYS | Logical System | N/A |
Transformation Mapping
Use the exact name and reference this section in the “Transformation rules” above| Mapping Table Name | Mapping Table Description |
|---|---|
| None | |
| Item # | Step Description | Team Responsible |
|---|---|---|
| 1 | Source Data Integrity - Ensure extracted data is complete, accurate, and consistent. - Validate that data types and formats align with transformation requirements. | Syniti / US Based Consultant for SAP CUI instance |
| 2 | Referential Integrity - Ensure dependent records are transformed together or in advance, such as CNV-3007 Business Partner General and DMS server migration | Syniti / US Based Consultant for SAP CUI instance |
| 3 | Transformation Logic and Mapping - Define data mapping rules between source and target schemas. | Data Team |
| 4 | Performance and Scalability Considerations - Optimize transformation processes for large datasets. - Ensure system resources can handle transformation workloads | Syniti / US Based Consultant for SAP CUI instance |
| 5 | Logging and Error Handling - Maintain detailed logs of transformation activities. - Define error-handling procedures for failed transformations | Syniti / US Based Consultant for SAP CUI instance |
| Task | Action |
|---|---|
| Compare Data Counts |
|
| Validate the mandatory fields | Validate there is value for all the mandatory fields |
| Validate Primary Keys and Unique Constraints |
|
| Test Referential Integrity | Confirm dependent records exist in related tables |
| Count and Completeness check | Verify that vendors with attachments still have the applicable attachments |
| Task | Action |
|---|---|
| Validate the transformation | Validate the fields which require transformation have the value after transformation instead of the original field value |
| Check Data Consistency |
|
| Task | Action |
|---|---|
Count and Completeness check | All fields required as per mapping template rules must be completed. Validity reports checking each field in ADMM must be built to help check. |
| Count and Completeness check | Verify that vendors with attachments still have the applicable attachments |
| Task | Action |
|---|---|
| Validate the transformation | Validate the fields which require transformation have the value after transformation instead of the original field value |
| Check Data Consistency |
|
The load process includes:
| Item # | Step Description | Team Responsible |
|---|---|---|
| 1 | Verify Attachment files are available in source system to be copied | Data Specialist/Functional - S2P/GOS |
| 2 | Verify copy tool & scripts are operational | Data Specialist/Functional - S2P/GOS |
| 3 | Verify Target System ready to receive files | Data Specialist/Functional - S2P/GOS |
| 4 | Verify file count. | Data Specialist/Functional - S2P/GOS |
| 5 | Approval to copy | Functional/Data Owner - S2P |
| 6 | Copy files | Data Specialist/Functional - S2P/GOS |
| 7 | Verify files copied in target | Data Specialist/Functional - S2P/GOS |
| 8 | Verify data extracted is ready - agree volume | Data Specialist/Functional - S2P |
| 9 | Verify Config is in the system TBC | Data Specialist/Functional - S2P |
| 10 | Verify other necessary data has been loaded int he system (TBC) | Data Specialist/Functional - S2P |
| 11 | Release - Load signoff and go-ahead by Functional/Data Owner | Functional/Data Owner - S2P |
| 12 | Approval to stage/Pre-stage steps | Functional/Data Owner - S2P |
| 13 | Extraction from source | Developer - Syniti or Data Specialist - S2P |
| 14 | Extraction from S4 where needed | Developer - Syniti or Data Specialist - S2P |
| 15 | Stage data for transformations | Developer - Syniti or Data Specialist - S2P |
| 16 | Run transforms | Developer - Syniti or Data Specialist - S2P |
| 17 | Execute pre-load report | Data Specialist/Functional - S2P |
| 18 | Validate preload report - release when signed off | Data Specialist - S2P |
| 19 | Pre-load verification and approval to load | Functional/Data Owner - S2P |
| 20 | Load to S4 | Data Specialist - S2P |
| 21 | Complete Jira steps, Volumes and Timings | All - where applicable |
| 22 | Execute post-load report | Developer - Syniti or Data Specialist - S2P |
| 23 | Post-load report verification/validation | Data Specialist/Functional/Data Owner - S2P |
| 24 | Object load completion approval | Data Owner - S2P |
Load Phase and Dependencies
Identify the phase as to “when” the load for this object will occur. <Pre-Cutover, Cutover, Post Cutover> and list the steps that need to occur before the load can commence
List the Configurations required before loading can commence
| Item # | Configuration Item |
|---|---|
| 1 | SRGBTBREL-RELTYPE: Relationship type. Check table MDOBLREL (E.g. ATTA) |
| 2 | SRGBTBREL-TYPEID_A: Object Type. Check table TOJTB (E.g. LFA1) |
| 3 | SRGBTBREL-CATID_A: Object category. (e.g. BO)* |
| 4 | SRGBTBREL-CATID_B: Object category. (e.g. BO)* |
| 5 | S4 GOs system config in place |
| BC | Instances of Business Classes (ABAP Objects) |
| BO | Instances of BOR Object Types |
| CL | Instances of ABAP Objects Classes - Internal Use Only! |
| NN | Category (still) Not Known - Internal use only!!! |
| Object # | Preceding Object Conversion Approach | Direct/Indirect |
|---|---|---|
| 1 | Bank master (1083) | Indirect |
| 2 | GL Account Operation COA at CCd | Indirect |
| 3 | Vendor Hierarchy (3024) | Indirect |
| 4 | Supplier Risk (3023) Supplier Segmentation (3030) Supplier Qualification (3029) Category Strategies (1096) | Indirect |
| 5 | Business Partners - General (3007) | Indirect |
| 6 | Business Partners - 3rd Party Supplier (FLVN01) (3026) | Direct |
| 7 | Vendor doc attachments (3031) |
The table below depicts some possible system errors for this data object during data load. All data load error is to be logged as defect and managed within the Defect Management
| Error Type | Error Description | Action Taken |
|---|---|---|
| Technical | GOS system not available | Contact standby GOS system support |
| Technical | Copy tool and scripts fails, due to access issues or volumes | Developers to fix the error |
| Data | Load fails | Fix and retry load |
| Data | Duplicates | Fix incorrect data or missing entries |
| Data | Transformation misses | Build transformation and retry. |
| Load | Authorization errors | Apply for the applicable authorization permission and retry |
| Load | Technical load failures - If using MC - Simulation errors, etc | Investigate error and rectify. Retry simulation and/or load |
| Load | Missing config | Set up config check validation jobs |
| Technical | Unable to create the link between attachment and object | Verify system is functional, data correct and access is valid. |
| Task | Action | Team |
|---|---|---|
| 1 | Execute post-load report | Developer - Syniti or Data Specialist - S2P |
| 2 | Post-load report verification/validation | Data Specialist/Functional/Data Owner - S2P |
| 3 | Object load completion approval | Data Owner - S2P |
| 4 | SIT & UAT test | S2P/Business |
| Task | Action |
|---|---|
Verify count | The number of records presented in the preload needs to be compared to the postload. – Syniti report |
| Field by field check | Compare source data to target data. |
| Verify count | Verify copied file count |
| Task | Action |
|---|---|
Conversion accuracy | Data team to verify that the data staged in the preload tables are correct in terms of the mapping rules. This will be done via Syniti reports/SAP reports |
| File quantity | Verify the quota quantities are correctly migrated |
Verify count | The number of records presented in the preload needs to be compared to the post load. – Syniti report |
| Missing data | Check missing data which was supposed to be loaded |
| Reconciliation | Participate in Post-load walkthroughs |
| Task | Action |
|---|---|
Conversion accuracy | Business team to verify that the data staged in the preload tables are correct in terms of the mapping rules. This will be done via Syniti reports/SAP reports |
| Load failures | Value presented for load must be in the system |
| Copy failures | Verify all files are copied and attachments available in target |
Any additional key assumptions.
Insert links and references to other documents which are relevant when trying to understand this decision and its implications. Other decisions are often impacted, so it's good to list them here with links. Attachments are also possible but dangerous as they are static documents and not updated by their authors.