Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 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 creating settlement rule for the migrated WBS from Legacy Source Systems into S/4HANA.

The data from legacy system includes:

  1. Provision WBS (with project profile ZPS0005) - Settlement rule to B/S GL account.
  2. Recharged Project (with project profile ZPS0004) - Settlement rule to G/L account 7930010.

The data from legacy system excludes:

  1. Capex WBS (with project profile ZPS0001) Settlement Rule for AUC generation - Rule generated automatically once Capex WBS (account assigned and having investment profile) is released and first settlement run is done.    
  2.  WBS Settlement rule to fixed asset.
  3. Statistical Project (with project profile ZPS0003) WBS - Not applicable

Note: For below scenarios, settlement rule is generated automatically (Mass Settlement rule generation - CJB1)

  1. WBS Settlement Rule to PSG 
  2. WBS Settlement Rule to Cost Centre (Jira - ERP-315)
  3. Settlement rule to superior WBS - (Pre-requisite SAP Note 211324 implemented as per FS ERP-315)

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

Not applicable

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
COBRBPROZSBRGPROZSPercentDEC5Conditional
COBRBBETRRBETRRAmountCURR23Conditional
COBRBPERBZ

PERBZ_LD

Settlement TypeCHAR3System Generated
COBRBEXTNRCOBR_EXTNRDistribution Rule No.NUMC7System Generated
COBRBSRSTRATSR_STRATStrategyCHAR3System Generated
COBRBGABPEGABPEFrom Period- Valid From PeriodNUMC3Conditional
COBRBGABJAGABJAFrom Fiscal Year- Valid From YearNUMC4Conditional
COBRBGBISJGBISJTo Period- Valid ToNUMC4Conditional
COBRBGBISPGBISPTo Fiscal Year- Valid to YearNUMC3Conditional
COBRAAPROFAPROFSettlement ProfileCHAR6System Generated
COBRAABSCH

BRGABSCH

Allocation Structure for Settlement/AssessmentCHAR6System Generated
COBRB-KOSTL

BRGKOSTL

Settlement Receiver- Cost CenterCHAR10System Generated
COBRBPAOBJNRRKEOBJNRSettlement Receiver- Profitability SegmentCHAR10System Generated
COBRBHKONTSAKNRSettlement Receiver- G/L AccountCHAR10Mandatory
COBRBPS_PSP_PNRPS_PSP_PNRWork Breakdown Structure Element (WBS Element)NUMC8System Generated
COBRBEXTNRCOBR_EXTNRDistribution Rule NumberNUMC3System Generated
COBRB BWAER

BRGBWAER

Currency for the amount in the amount rule CUKY5

System Generated

COBRBKOKRSBRGKOKRSControlling Area of ReceiverCHAR4System Generated
COBRBBUKRSBUKRSCompany CodeCHAR4System Generated
COBRBSRSTRATSR_STRATStrategy for automatic generation of settlement rulesCHAR3System Generated


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 

N/A

Data Privacy and Sensitivity

Not applicable

Extraction

The data is manually collected directly in the 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

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 not required, as pre-load file be created based on the transformation logic.


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 activity involving the Business 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

Execute and Load and perform Transformation 

Data Team

2

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

Data team

3

Review and Validate Error and Preload Reports

Data Team

4

Generate data load count.

Data team

5

Generate Load Files

Data Team

6

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


Transformation Rules

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1S/4 HanaPRPS OBJNRWBS elementS/4 HanaCOBRB OBJNRWBS element

Copy from source to target system 

Provision WBS with Project type PRPS-PRART = Restructuring Provision, Safety and Environment Provision, IAS19 Provision, Environmental Fines, Social Fines, Corruption Fines, PRPS-STUFE=2, project profile, PROJ-PROFL = ZPS0005

Recharged Project WBS, with Project type PRPS-PRART = 15 Intercompany Recharge PRPS-STUFE=2, project profile, PROJ-PROFL = ZPS0005

2



S/4 HanaCOBRBKONTYAccount Assignment Category

Default = G/L (G/L Account)


3S/4 HanaCOBRB

HKONT



Settlement ReceiverS/4 HanaCOBRBHKONTSettlement Receiver

Rule 1: Provision project WBS

Settlement receiver from target S/4 from template Project starting with code 'T-' and its level 2 WBS with project type = Restructuring Provision, Safety and Environment Provision, IAS19 Provision, Environmental Fines, Social Fines, Corruption Fines

Get WBS PRPS-OBJNR having code PRPS-PSPID = 'T-' with project type PRPS-PRART = 1Restructuring Provision, Safety and Environment Provision, IAS19 Provision, Environmental Fines, Social Fines, Corruption Fines, PRPS-STUFE=2 and pass in COBRB-OBJNR for Account Assignment Category COBRB-KONTY = G/L account, get 
Settlement Receiver = COBRB-HKONT 

Note: WBS with project type =IAS19 Provision multiple template WBS exist, lookup the WBS description PRPS-POST1 for all such template WBS and get the Gl account from COBRB for respective WBS as settlement receiver.

Rule 2: Recharged Project WBS

Settlement Receiver = 7930010 

4



S/4 HanaCOBRBPERBZSettlement Type

System generated 'Full - Full Settlement'

5



S/4 HanaCOBRBEXTNR Distribution Rule No.System Generated
6


Settlement Profile S/4 HanaCOBRAAPROFSettlement Profile 

Default from project profile

7


Allocation Structure for Settlement/AssessmentS/4 HanaCOBRAABSCHAllocation Structure for Settlement/Assessment

Default from Settlement profile

8


Controlling area of receiverS/4 HanaCOBRBKOKRSControlling area of receiver

Default

WBS controlling area PRPS-PKOKR

9


Company CodeS/4 HanaCOBRBBUKRSCompany Code

Default

WBS company code PRPS-PBUKR

Transformation Mapping


Mapping Table NameMapping Table Description

Transformation Dependencies

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

Ensure all the fields that require value mapping, as stipulated. Mapping tables, have the correct values mapped and imported into tool.Syway Data Team

For provision project WBS, template project WBS to have settlement rule maintainedSyway Data Team


Pre-Load Validation

Project Team

Completeness

TaskAction

Verify Record Count

SyWay I2M Data Team to verify that the total number of relevant 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

Review Error Reports

Review and correct the errors.  Achieve a zero-error record count as much as possible. 

Business

Completeness

TaskAction

Verify Record Count

Business Data Owner/s to verify that 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.


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

Proceed with full load if steps 2 is validated

Data Team

4

Validate few records loaded by accessing

Data Team

5

Generate post load report if step 4 is validated

Data Team


Load Phase and Dependencies

Configuration


Item #Configuration Item
1

Controlling Area

2Operating Concern
3Project Profile
4Determine Strategy for Settlement Rule
5Settlement Profile
6Assign Strategy to Project Profile
7Create Allocation Structure


Conversion Objects

Object #Preceding Object Conversion Approach
1067GL Operational
1026WBS - Capex, Opex, Statistical

Error Handling


Error TypeError DescriptionAction Taken
1Receiver missing for distribution rule

Correct upload data, 

Enter the missing receiver

2WBS element does not existCorrect upload data, 
4G/L Account not in chart of accountCorrect upload data


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. 

CNSETTLRULE - Project Settlement Rule 

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 report CNSETTLRULE - Project Settlement Rule 

Business

Completeness

TaskAction
Verify CountExtract data from PS report CNSETTLRULE - Project Settlement Rule in S/4 Hana

Accuracy

TaskAction
Verify CountExtract data from PS report CNSETTLRULE - Project Settlement Rule in S/4 Hana


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.
  • For WBS automatic settlement rule generation, required enhancement that will be in place.


See also

Change log

Change History
limit10