| Status | |
|---|---|
| Owner | |
| Stakeholders | The business stakeholders involved in making, reviewing, and endorsing this decision. Type @ to mention people by name |
The purpose of this document is to define the conversion approach to create GTS Classifications in S/4 HANA GTS Edition.
Product classification in SAP GTS (Global Trade Services) is the process of assigning standardized codes to products for international trade. These codes are essential for complying with customs regulations, export controls, and trade agreements.
As part of the Syway program, OGP- will be upgraded to SAP S/4 GTS E4H Edition. For this master data object, the data must be extracted from the current system and loaded into the new GTS E4H system with minimal transformations.
The scope of this document covers the approach for converting active GTS Classification from Legacy Source Systems into S/4HANA following the GTS Classifications Master Data Design Standard.
The data from legacy system includes:
List of source systems and approximate number of records
| Source | Scope | Source Approx No. of Records | Target System | Target Approx No. of Records |
|---|---|---|---|---|
| OGP | TBD | TBD |
NA
NA
NA
NA
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 |
|---|---|---|---|---|---|---|
| /SAPSLL/PRCLS | GUID_PRCLS | /SAPSLL/GUID_PRCLS | UUID PRCLS | RAW | 16 | System Generated |
| /SAPSLL/PRCLS | GUID_PR | /SAPSLL/GUID_PR | Product UUID | RAW | 16 | System Generated |
| /SAPSLL/PRCLS | STCTS | /SAPSLL/STCTS_N | Numbering Scheme | CHAR | 10 | Mandatory |
| /SAPSLL/PRCLS | ENDUSE | /SAPSLL/ENDUSE | End Use | CHAR | 5 | Conditional |
| /SAPSLL/PRCLS | DATAB | /SAPSLL/DATAB_N | Valid From | DATS | 8 | Mandatory |
| /SAPSLL/PRCLS | DATBI | /SAPSLL/DATBI_N | Valid To | DATS | 8 | Mandatory |
| /SAPSLL/PRCLS | CCNGN | /SAPSLL/CCNGN_N | Number | CHAR | 30 | Mandatory |
| /SAPSLL/PRCLS | CTSCO | /SAPSLL/CTSCO | Remarks | CHAR | 500 | Conditional |
| /SAPSLL/PNTPR | GRVSY | /SAPSLL/GRVSY | Logical System Group | CHAR | 10 | System Generated |
| /SAPSLL/PNTPR | PRVSY | /SAPSLL/PRVSY | Product | CHAR | 40 | Mandatory |
| /SAPSLL/PNTPR | PRTYP | /SAPSLL/PRTYP | Prod. Cat. fr. Backend System for Legal and Logistics Serv. | CHAR | 2 | Mandatory |
| /SAPSLL/PNTPR | GUID_PR | /SAPSLL/GUID_16 | GUID 16 | RAW | 16 | System Generated |
| /SAPSLL/PNTPR | PRNUM | /SAPSLL/PRNUM | Internal Product Number | CHAR | 20 | System Generated |
| /SAPSLL/PNTPR | DATAB | /SAPSLL/RPTST | Valid-From Date | DEC | 15 | System Generated |
| /SAPSLL/PNTPR | DATBI | /SAPSLL/RPTET | Valid -To Date | DEC | 15 | System Generated |
| /SAPSLL/PNTPR | GUID_PRVSY | /SAPSLL/GUID_16 | GUID 16 | RAW | 16 | System Generated |
| /SAPSLL/PRLRG | GUID_PRLRG | /SAPSLL/GUID_PRLRG | UUID PRLRG | RAW | 16 | System Generated |
| /SAPSLL/PRLRG | GUID_PR | /SAPSLL/GUID_PR | Product UUID | RAW | 16 | System Generated |
| /SAPSLL/PRLRG | LGREG | /SAPSLL/LGREG_N | Legal Regulation | CHAR | 5 | Mandatory |
| /SAPSLL/PRLRG | DATAB | /SAPSLL/DATAB_N | Valid From | DATS | 8 | Mandatory |
| /SAPSLL/PRLRG | DATBI | /SAPSLL/DATBI_N | Valid To | DATS | 8 | Mandatory |
| /SAPSLL/PRLRG | SECGK | /SAPSLL/SECGK | Peculiarity Code | CHAR | 10 | Conditional |
| /SAPSLL/PRLRG | FOCON | /SAPSLL/FOCON | No Control | CHAR | 1 | Conditional |
| /SAPSLL/PRLRG | PMAST | /SAPSLL/PMAST | Individual Maintenance | CHAR | 1 | Conditional |
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 |
|---|---|---|---|---|---|
| NA | NA | NA | NA | NA | NA |
The high-level process is represented by the diagram below:

Extract data from a source into Syniti Migrate. There are 2 possibilities:
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 |
|---|---|---|
| 1 | Legacy System Extraction (OGP) based on the Relevancy Rules from Table: /SAPSLL/PRCLS, /SAPSLL/PNTPR & /SAPSLL/PRLRG | Syniti |
| Selection Ref Screen | Parameter Name | Selection Type | Requirement | Value to be entered/set |
|---|---|---|---|---|
| NA |
<Object> DCT Rules
| Field Name | Field Description | Rule |
|---|---|---|
| NA | NA | NA |
| Item # | Step Description | Team Responsible |
|---|---|---|
| 1 | Extract data from source systems OGP | Syniti |
| 2 | Populate in a report in a Downloadable format | Syniti |
| 3 | Data is validated in ADMM Tool | SyWay Data Team |
| 5 | The data which has passed validation will be used for transformation/further processing | Business/Data Owners |
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 | Obtain Transformation Rules Sign-off from Business. | SCM Data Team |
2 | In dspMigrate, select the wave – S4/HANA – INT-GTS | Syniti |
3 | Go to Process Area Launch and Process the Object – GTS Classifications | Syniti |
4 | Review and Validate Error and Preload Reports | Syniti |
5 | Execute the transformation to prepare the target tables | Syniti |
6 | Validate data from pre-load and error reports | Business/Data owner |
7 | Generate load files | Syniti |
Transformation Rules
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | OGP | /SAPSLL/PRCLS | GUID_PRCLS | UUID PRCLS | S/4 HANA GTS | /SAPSLL/PRCLS | GUID_PRCLS | UUID PRCLS | System Generated |
| 2 | OGP | /SAPSLL/PRCLS | GUID_PR | Product UUID | S/4 HANA GTS | /SAPSLL/PRCLS | GUID_PR | Product UUID | System Generated Need to link the Legacy product number and S/4 product number. Find the GUID_PR from table /SAPSLL/PNTPR and map it here |
| 3 | OGP | /SAPSLL/PRCLS | STCTS | Numbering Scheme | S/4 HANA GTS | /SAPSLL/PRCLS | STCTS | Numbering Scheme | Direct Mapping |
| 4 | OGP | /SAPSLL/PRCLS | ENDUSE | End Use | S/4 HANA GTS | /SAPSLL/PRCLS | ENDUSE | End Use | Direct Mapping |
| 5 | OGP | /SAPSLL/PRCLS | DATAB | Valid From | S/4 HANA GTS | /SAPSLL/PRCLS | DATAB | Valid From | Direct Mapping |
| 6 | OGP | /SAPSLL/PRCLS | DATBI | Valid To | S/4 HANA GTS | /SAPSLL/PRCLS | DATBI | Valid To | Direct Mapping |
| 7 | OGP | /SAPSLL/PRCLS | CCNGN | Number | S/4 HANA GTS | /SAPSLL/PRCLS | CCNGN | Number | Direct Mapping |
| 8 | OGP | /SAPSLL/PRCLS | CTSCO | Remarks | S/4 HANA GTS | /SAPSLL/PRCLS | CTSCO | Remarks | Direct Mapping |
| 9 | OGP | /SAPSLL/PNTPR | GRVSY | Logical System Group | S/4 HANA GTS | /SAPSLL/PNTPR | GRVSY | Logical System Group | System Generated |
| 10 | OGP | /SAPSLL/PNTPR | PRVSY | Product | S/4 HANA GTS | /SAPSLL/PNTPR | PRVSY | Product | Need to derive the new S/4 HANA Materials from Cross Reference Tables |
| 11 | OGP | /SAPSLL/PNTPR | PRTYP | Prod. Cat. fr. Backend System for Legal and Logistics Serv. | S/4 HANA GTS | /SAPSLL/PNTPR | PRTYP | Prod. Cat. fr. Backend System for Legal and Logistics Serv. | Direct Mapping Should always have fixed value of '01' |
| 12 | OGP | /SAPSLL/PNTPR | GUID_PR | GUID 16 | S/4 HANA GTS | /SAPSLL/PNTPR | GUID_PR | GUID 16 | System Generated |
| 13 | OGP | /SAPSLL/PNTPR | PRNUM | Internal Product Number | S/4 HANA GTS | /SAPSLL/PNTPR | PRNUM | Internal Product Number | System Generated |
| 14 | OGP | /SAPSLL/PNTPR | DATAB | Valid-From Date | S/4 HANA GTS | /SAPSLL/PNTPR | DATAB | Valid-From Date | System Generated |
| 15 | OGP | /SAPSLL/PNTPR | DATBI | Valid -To Date | S/4 HANA GTS | /SAPSLL/PNTPR | DATBI | Valid -To Date | System Generated |
| 16 | OGP | /SAPSLL/PNTPR | GUID_PRVSY | GUID 16 | S/4 HANA GTS | /SAPSLL/PNTPR | GUID_PRVSY | GUID 16 | System Generated |
| 17 | OGP | /SAPSLL/PRLRG | GUID_PRLRG | UUID PRLRG | S/4 HANA GTS | /SAPSLL/PRLRG | GUID_PRLRG | UUID PRLRG | System Generated |
| 18 | OGP | /SAPSLL/PRLRG | GUID_PR | Product UUID | S/4 HANA GTS | /SAPSLL/PRLRG | GUID_PR | Product UUID | System Generated |
| 19 | OGP | /SAPSLL/PRLRG | LGREG | Legal Regulation | S/4 HANA GTS | /SAPSLL/PRLRG | LGREG | Legal Regulation | Direct Mapping |
| 20 | OGP | /SAPSLL/PRLRG | DATAB | Valid From | S/4 HANA GTS | /SAPSLL/PRLRG | DATAB | Valid From | Direct Mapping |
| 21 | OGP | /SAPSLL/PRLRG | DATBI | Valid To | S/4 HANA GTS | /SAPSLL/PRLRG | DATBI | Valid To | Direct Mapping |
| 22 | OGP | /SAPSLL/PRLRG | SECGK | Peculiarity Code | S/4 HANA GTS | /SAPSLL/PRLRG | SECGK | Peculiarity Code | Direct Mapping |
| 23 | OGP | /SAPSLL/PRLRG | FOCON | No Control | S/4 HANA GTS | /SAPSLL/PRLRG | FOCON | No Control | Direct Mapping |
| 24 | OGP | /SAPSLL/PRLRG | PMAST | Individual Maintenance | S/4 HANA GTS | /SAPSLL/PRLRG | PMAST | Individual Maintenance | Direct Mapping |
Transformation Mapping
| Mapping Table Name | Mapping Table Description |
|---|---|
| zLegacyMatnumber | New Material Numbers |
1 | Ensure Legacy System tables completeness | Syniti |
2 | Ensure Classification file must be uploaded from data provider both compliance and customs. | SyWay-Functional. |
2 | Ensure all Transformation mappings are up to date. | Syniti |
Verify Consent | Verify the appropriate consents for the records have been obtained by the business/Data Owners and properly recorded |
| Task | Action |
|---|---|
Conversion Accuracy | SCM Data team to verify that all the data in the load table/file is accurate as contents and transformation rules with below checks:
|
| Review Error Reports | Review and correct the errors. Achieve a zero-error record count as much as possible. Raise defects for data remediated and requiring a correction in the source data. |
| Task | Action |
|---|---|
| Verify Record Count | Business Data Owner/s to verify that the total number of relevant records in Syniti tool equal to the total number of records in the Preload and Load Sheets. |
Verify Consent | Verify that the appropriate consents for the records have been obtained by the business and properly recorded |
| Task | Action |
|---|---|
Conversion Accuracy | Business Data Owner/s to verify that all the data in the load table/file is accurate as per endorsed transformation/mapping rules. |
The load process includes:
| Item # | Step Description | Team Responsible |
|---|---|---|
1 | Ensure Pre-load sign-offs are obtained. | SCM Data team |
2 | Go to the load tool and select the correct load Program. | SCM Data team |
3 | Proceed with Data load. | SCM Data team |
4 | Validate few records loaded by accessing standard transactions. | SCM Data team |
5 | Generate the post load reports in the tool. | SCM Data team |
6 | Log errors as defects, if any and address resolutions. Close defects. | SCM Data team |
7 | Resolve defects by re-upload and re-generate post load reports if necessary. | SCM Data team |
8 | Business to validate the post load files as part of post-load validation, raise data defects or provide the post-load sign-off. | Business |
9 | Repeat steps 5 to 7 if necessary. | SCM Data team |
Load Phase and Dependencies
Pre Cutover
List the Configurations required before loading can commence
| Item # | Configuration Item |
|---|---|
| NA | NA |
| Object # | Preceding Object Conversion Approach |
|---|---|
| 2019 | Materials - Basic View |
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 |
|---|---|---|
| Configuration | <configuration> is not valid/missing | If it is a missing configuration item, then engage Functional team to expedite and fix the error in the system. |
Invalid Data | <parameter> is not valid. | The parameter entry needs to be reviewed If it is an invalid data, business needs to review and correct the source of the data either in OGP or if it’s mapped in DCT. |
Technical Setup | Interface / Connection issue within target system’s landscape | N/A – the data will be loaded directly to S/4HANA GTS System environment |
| Task | Action |
|---|---|
| Verify the count | Verify that the record count in the post-load file is the same as the record count based on the relevancy (including any deduplication) results |
| Task | Action |
|---|---|
Data Accuracy | SCM Data team to verify that all the data in the post load table/file is accurate as per signed-off transformation rules |
Error Reports | Verify that all necessary error reports have been validated, and that errors have been addressed. |
Data Consistency | Verify that the data loaded is correctly reflected in Table: /SAPSLL/PRCLS, /SAPSLL/PNTPR & /SAPSLL/PRLRG |
| Task | Action |
|---|---|
Verify Count | Verify that the record count in the post load file is the same as the record count based on the relevancy (including deduplication) results |
Validate Loaded Data | Validate, as per the load files signed-off, that all records were created |
| Task | Action |
|---|---|
Data Accuracy | Verify that all the data in the S/4HANA GTS table is accurate as per signed-off transform |
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.