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 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 for creating settlement rule for the migrated WBS 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. 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 7930010Settlement rules for Migrated WBS as per the scope of object 1026 - WBS - CAPEX, OPEX, Statistical.

The data from legacy system excludes:

  1. Capex WBS (with project profile ZPS0001) Settlement Rule for AUC generation - Rule generated automatically
  2. Settlement rule to superior WBS - Rule generated automatically
  3. once Capex WBS (account assigned and having investment profile) is released and first settlement run is done.    
  4.  WBS Settlement rule to fixed asset - Rule generated automatically.
  5. Statistical Recharged Project (with project profile ZPS0004ZPS0003) WBS - No settlement required
  6. Capex / Opex WBS workorder - Rule generated automatically
  7. Settlement Rule to PSG - Rule generated automatically
  8. 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)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

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 CategoryCHAR2MandatoryDKOBREMPGEABR_EMPSettlement ReceiverCHAR40
COBRBPROZSBRGPROZSPercentDEC5COBRBAQZIFAQZIFEquivalence No.DECConditional
10COBRBBETRRBETRRAmountCURR23COBRBBRTYPConditional

BRTYP

Amount Rule TypeCHAR2COBRBPERBZ

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 below:diagram 

N/AImage Removed

Data Privacy and Sensitivity

Not applicable

Extraction

The data is manually

collected by the business directly in

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

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 DescriptionRulenot 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 is a 3-way activity involving the Business , Functional team and Data team. This identifies the transformation activity required to allow 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

1Obtain DCT Sign-off from Business

Data Team

2

Execute and Load and perform Transformation 

Data Team

32

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

Data team

43

Review and Validate Error and Preload Reports

Data Team

54

Generate data load count.

Data team

65

Generate Load Files

Data Team

76

Log errors as defects, if any and address resolutions. Close defects.Data team
87Re-transform and re-validate the Pre-load reports if necessary.Data team
98Validate the transformed file as part of pre-load validation, raise data defects or provide the pre-load sign-off.Business
109Analyze and resolve any pre-load defects logged by business.Data team
1110Repeat steps 7 to 10 if necessaryData team
1211Proceed 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


Not applicable
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 TeamNot 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 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 ChecksText 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 is validated

Data Team

54

Validate few records loaded by accessing

Data Team

65

Generate post load report if step 5 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, Statisticallist 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
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 SE16 downloadreport CNSETTLRULE - Project Settlement Rule 

Business

Completeness

TaskAction
Verify CountExtract data from PS report CNSETTLRULE - Project Settlement Rule in S/4 Hana via fiori tile and verify the count

Accuracy

TaskAction
Verify CountExtract data from PS report CNSETTLRULE - Project Settlement Rule 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.
  • For WBS automatic settlement rule generation, required enhancement that will be in place.


See also

Change log

Change History
limit10