You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Status

  Revision in Progress

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach to create WBS - CAPEX/OPEX Settlement Rule in S/4 HANA.

Settlement rule is a set of parameters that defines how costs are transferred from a project's sender like a WBS element to receivers, such as a General Ledger account, Cost Centre, Asset Under Construction, fixed Asset, Profitability Segment, Superior WBS element.


Conversion Scope

The scope of this document covers the approach for converting applicable active WBS - CAPEX/OPEX Settlement Rule from Legacy Source Systems into S/4HANA following the WBS - CAPEX/OPEX Settlement Rule Master Data Design Standard.

The data being sourced using DCT (Data Collection Template).

Relevancy criteria

The data from legacy system includes:

  1. Settlement rules for Migrated WBS as per the scope of object 1026 - WBS - CAPEX, OPEX, Statistical.

The data from legacy system excludes:

  1. Capex WBS Settlement Rule for AUC generation - Rule generated automatically
  2. Settlement rule to superior WBS - Rule generated automatically
  3. Settlement rule to fixed asset - Rule generated automatically
  4. Recharged Project (with project profile ZPS0004) WBS - No settlement required
  5. Capex / Opex WBS workorder - Rule generated automatically
  6. Settlement Rule to PSG - Rule generated automatically
  7. Opex IT ?? 


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

DCTAll Records
S/4HANATBD

Additional Information

Multi-language Requirement


Document Management

Not applicable

Legal Requirement

Not applicable

Special Requirements

Not applicable


Target Design

The technical design of the target for this conversion approach.

TableFieldData ElementField DescriptionData TypeLengthRequirement
COBRBOBJNRJ_OBJNRWBS elementCHAR22Mandatory
COBRBKONTY

KONTY

Account Assignment CategoryCHAR2Mandatory
DKOBREMPGEABR_EMPSettlement ReceiverCHAR40
COBRBPROZSBRGPROZSPercentDEC5
COBRBAQZIFAQZIFEquivalence No.DEC10
COBRBBETRRBETRRAmountCURR23
COBRBBRTYP

BRTYP

Amount Rule TypeCHAR2
COBRBPERBZ

PERBZ_LD

Settlement TypeCHAR3
COBRBEXTNRCOBR_EXTNRDistribution Rule No.NUMC7
COBRBSRSTRATSR_STRATStrategyCHAR3
COBRBGABPEGABPEFrom Period- Valid From PeriodNUMC3
COBRBGABJAGABJAFrom Fiscal Year- Valid From YearNUMC4
COBRBGBISJGBISJTo Period- Valid ToNUMC4
COBRBGBISPGBISPTo Fiscal Year- Valid to YearNUMC3
COBRAAPROF
Settlement Profile


COBRB-KOSTL

BRGKOSTL

Settlement Receiver- Cost CenterCHAR10
COBRBPAOBJNRRKEOBJNRSettlement Receiver- Profitability SegmentCHAR10
COBRBHKONTSAKNRSettlement Receiver- G/L AccountCHAR10


Data Cleansing

Data object WBS - Capex, Opex, Settlement Rule will be collected specifically for data migration. 


IDCriticalityError Message/Report DescriptionRuleOutputSource System


Not applicable



Conversion Process

The high-level process is represented by the diagram below:


Data Privacy and Sensitivity

Not applicable

Extraction

The data is manually collected by the business directly in Syniti Migrate. This is to be conducted using DCT (Data Collection Template) in Syniti Migrate. The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads

The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads

Extraction Run Sheet

Req #Requirement DescriptionTeam Responsible
1Ensure DCT is collected Data Team
2Perform preliminary completeness check, data quality check.Data Team
3

Raise issues as defects if Req # 1 to 2 are not met

Data Team
4

Repeat Req # 1 to 3 if required

Data Team

Selection Screen


Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set
Not Applicable




Data Collection Template (DCT)

Target Ready Data Collection Template will be created for WBS - Capex, Opex, Settlement Rule data with exception of some fields which require transformation as mentioned in the transformation rule.

WBS - Capex, Opex, Settlement Rule DCT Rules

Field NameField DescriptionRule












Extraction Dependencies

No Dependencies for Extract

Item #Step DescriptionTeam Responsible

Not applicable


Transformation

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 to make the data Target ready:

  1. Perform value mapping and data transformation rules.
    1. Legacy values are mapped to the to-be values (this could include a default value)
    2. Values are transformed according to the rules defined in
  2. Prepare target-ready data in the structure and format that is required for loading via prescribed Load Tool. This step also produces the load data ready for business to perform Pre-load Data Validation

Transformation Run Sheet

Item #Step DescriptionTeam Responsible

1

Obtain DCT Sign-off from Business

Data Team

2

Execute and Load and perform Transformation 

Data Team

3

Monitor the transformation progress and ensure performance and completion is within allowed timeframe

Data team

4

Review and Validate Error and Preload Reports

Data Team

5

Generate data load count.

Data team

6

Generate Load Files

Data Team

7

Log errors as defects, if any and address resolutions. Close defects.Data team
8Re-transform and re-validate the Pre-load reports if necessary.Data team
9Validate the transformed file as part of pre-load validation, raise data defects or provide the pre-load sign-off.Business
10Analyze and resolve any pre-load defects logged by business.Data team
11Repeat steps 7 to 10 if necessaryData team
12Proceed to pre-load validationsData team


Transformation Rules

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic









































Transformation Mapping


Mapping Table NameMapping Table Description
Not applicable

Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible

Not applicable


Pre-Load Validation

Project Team

Completeness

TaskAction

Verify Record Count

SyWay I2M Data Team to verify that the total number of relevant records from the DCT is equal to the total number of records in the Preload and Load Sheets.


Accuracy

TaskAction

Conversion Accuracy

SyWay I2M Data Team to verify that all fields below meet pass the checks:

  1. Mandatory Fields
  2. Field and Value Mapping Correctness
  3. Null Checks
  4. Text Length 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 (DCT) data.

Business

Completeness

TaskAction

Verify Record Count

Business Data Owner/s to verify that the total number of relevant records from the DCT is equal to the total number of records in the Preload and Load Sheets.


Accuracy

TaskAction

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 (and signed-off DCT data).


Load

The load process includes:

  1. Execute the automated data load into target system using load tool or product the load file if the load must be done manually
  2. Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation

Load Run Sheet

Item #Step DescriptionTeam Responsible

1

Load using transaction custom upload / custom fiori app

Data Team

2

Load 3 records for < > to validate if data is loaded successfully without errors

Data Team

3

Load 3 records for < > to validate if data is loaded successfully without errors

Data Team

4

Proceed with full load if steps 2 and 3 are validated

Data Team

5

Validate few records loaded by accessing

Data Team

6

Generate post load report if step 5 is validated

Data Team


Load Phase and Dependencies

Configuration

Item #Configuration Item






Conversion Objects

Object #Preceding Object Conversion Approach

list the exact title of the conversion object of only the immediate predecessor – this will then confirm the DDD (Data Dependency Diagram)




Error Handling

Error TypeError DescriptionAction Taken










Post-Load Validation

Project Team

Completeness

TaskAction

Verify Count

SyWay I2M Data Team to verify the record count created in target S/4 HANA by accessing post load reports from S/4 HANA.

Verify Logs

Check if there is data that failed to load and perform the necessary actions (e.g. register as post load issue or attempt to load the record again, etc.).


Accuracy

TaskAction

Conversion Accuracy

Verify that the tables in target S/4 HANA were loaded correctly via SE16 download


Business

Completeness

TaskAction
Verify CountExtract data in S/4 Hana via fiori tile and verify the count

Accuracy

TaskAction
Verify CountExtract data in S/4 Hana via fiori tile and verify the count


Key Assumptions

  • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
  • WBS - Capex, Opex, Settlement Rule is in scope based on data design and any exception requested by business.


See also

Change log

Version Published Changed By Comment
CURRENT (v. 2) Mar 05, 2026 09:56 NADAR-ext, Parvati
v. 37 Dec 12, 2025 11:09 NADAR-ext, Parvati
v. 36 Dec 12, 2025 11:09 NADAR-ext, Parvati
v. 35 Dec 10, 2025 14:19 NADAR-ext, Parvati
v. 34 Nov 28, 2025 14:08 NADAR-ext, Parvati
v. 33 Nov 28, 2025 00:54 AGGARWAL-ext, Vikhyat
v. 32 Nov 27, 2025 16:24 NADAR-ext, Parvati
v. 31 Nov 27, 2025 16:23 BIDALIA-ext, Kuldeep
v. 30 Nov 26, 2025 16:16 NADAR-ext, Parvati
v. 29 Nov 24, 2025 16:09 NADAR-ext, Parvati

Go to Page History

  • No labels