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
  3. Settlement rules for Migrated WBS as per the scope of object 1026 - WBS - CAPEX, OPEX, Statistical.
  4. Capex WBS Settlement rule to fixed asset - AUC cost to fixed asset
  5. WBS Settlement Rule to PSG (Opex -  R&I & Industrial WBS)  - Rule generated automatically on execution of standard t-code (CJB1) mass generation of settlement rules   
  6. WBS Settlement Rule to Cost Centre (Opex - IT) - Rule generated automatically ?
  7. WBS Settlement Rule to Cost Centre (Opex - Expense WBS budget managed) - Rule generated automatically on execution of standard t-code (CJB1) mass generation of settlement rules. Settlement receiver is the responsible Cost Centre as maintained in the WBS. 
  8. Provision WBS (with project profile ZPS0005) - Settlement rule to BG/S GL 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 superior WBS - Rule generated automatically on on execution of standard t-code (CJB1) mass generation of settlement rules (SAP Note 211324 implemented)    
  3. Capex / Opex WBS with assigned workorder - Rule generated automatically 
  4. Recharged Project (with project profile ZPS0004) WBS - No settlement required
  5. fixed asset.
  6. 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)Statistical Project (with project profile ZPS0003) WBS - Not applicable

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
DKOBREMPGEABR_EMPSettlement ReceiverCHAR40Mandatory
COBRBPROZSBRGPROZSPercentDEC5Conditional
COBRBBETRRBETRRAmountCURR23Conditional
COBRBBRTYP

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 DescriptionRuleOBJNRWBS element

Sender WBS element that will have its costs settled. 

Account assignment to be active. 

KONTYAccount Assignment Category

Account assignment category determine the type of settlement receiver type.  

a. FXA- Asset - Account assignment category FXA specifies a receiver category of "Fixed Asset". Required for AUC cost on Capex WBS to Settled to fixed asset. 

Rule:

For WBS elements governed by CAPEX project profile ZPS0001, Account assignment element PRPS-BELKZ = active, WBS level PRPS-STUFE=3, with investment profile PRPS-IMPRF not blank and Capex flag PRPS-ZX01 not blank.

It is a Required Field: Preload Check to be done to confirm that this is field in the Data Collection Template.

b. G/L- G/L account - Account assignment category G/L specifies a receiver category of "G/L Account'. 

Rule:

Provision WBS with project profile ZPS0005, WBS level PRPS-STUFE=2, Account assignment element PRPS-BELKZ = active

It is a Required Field: Preload Check to be done to confirm that this is field in the Data Collection Template.

Note: Account assignment category, CTR- Cost Center, PSG- Profitability Segment, WBS- WBS element are applicable for Automatic settlement rule

not required, as pre-load file be created based on the transformation logic.


EMPGESettlement Receiver

Settlement receiver based on the account assignment category selected.

For account assignment category - FXA- Asset, Capex WBS with project profile ZPS0001 as per rule defined above.

For account assignment category - G/L- G/L account -Provision WBS with project profile ZPS0005 as per rule defined above. 

It is a Required Field: Preload Check to be done to confirm that this is field in the Data Collection Template.

PROZSPercent

This field specifies the percentage, at which costs collected in the sender object are distributed to the specified settlement receiver. 

Conditional field

BETRRAmount

Fixed amount to be settled to settlement receiver.

Rule:

Capex WBS with project profile ZPS0001 as per rule defined above for settlement of WBS AUC cost to fixed asset.

BRTYPAmount Rule Type

??

GABPEValid From Period

Period value from which a distribution rule is applied to limit the validity duration of a distribution rule.

Conditional field

GABJAValid From Year

Year value from which a distribution rule is applied to limit the validity duration of a distribution rule.

Conditional field

GBISJTo Period- Valid To

Period value up to which a distribution rule is applied to limit the validity duration of a distribution rule

Conditional field

GBISPTo Fiscal Year- Valid to Year

Year value up to which a distribution rule is applied to limit the validity duration of a distribution rule.

Conditional field

ANLN1Settlement Receiver- Fixed Asset

For account assignment category - FXA- Asset, Capex WBS with project profile ZPS0001 as per rule defined above.

It is a Required Field: Preload Check to be done to confirm that this is field in the Data Collection Template.

HKONTSettlement Receiver- G/L Account

For account assignment category - G/L- G/L account -Provision WBS with project profile ZPS0005 as per rule defined above. 

It is a Required Field: Preload Check to be done to confirm that this is field in the Data Collection Template.

Instance

Instance where the WBS Settlement Rule is to be loaded.

(Field required in DCT)

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

1

Obtain 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
1
DCT
S/4 HanaPRPS
COBRB
 OBJNRWBS elementS/4 HanaCOBRB OBJNRWBS element

Copy from source to target

system

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
2DCTCOBRBKONTYAccount Assignment Category




S/4 HanaCOBRBKONTYAccount Assignment Category
Copy from source to target system

Default = G/L (G/L Account)


3
DCTDKOBR
S/4 HanaCOBRB

HKONT

EMPGE



Settlement ReceiverS/4 Hana
DKOBR
COBRB
EMPGE
HKONTSettlement Receiver

Value Mapping: Old to new Fixed Asset

Value Mapping: Old to new G/L Account

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
4DCTCOBRBBETRRAmount




S/4 HanaCOBRB
BETRR
PERBZ
AmountCopy from source to target system5DCTCOBRBBRTYPAmount Rule Type
Settlement Type

System generated 'Full - Full Settlement'

5



S/4 HanaCOBRB
BRTYP
EXTNR 
Amount
Distribution Rule
Type
No.System Generated
Copy from source to target system
6
DCTCOBRBGABPEFrom Period- Valid From Period



Settlement Profile S/4 Hana
COBRB
COBRA
GABPEFrom Period- Valid From PeriodCopy from source to target system7DCTCOBRBGABJAFrom Fiscal Year- Valid From Year
APROFSettlement Profile 

Default from project profile

7


Allocation Structure for Settlement/AssessmentS/4 Hana
COBRB8DCTCOBRBGBISJTo Period- Valid To
COBRA
GABJAFrom Fiscal Year- Valid From YearCopy from source to target system
ABSCHAllocation Structure for Settlement/Assessment

Default from Settlement profile

8


Controlling area of receiver
S/4 HanaCOBRB
GBISJTo Period- Valid ToCopy from source to target system9DCTCOBRBGBISPTo Fiscal Year- Valid to Year
KOKRSControlling area of receiver

Default

WBS controlling area PRPS-PKOKR

9


Company CodeS/4 HanaCOBRBBUKRSCompany Code
GBISPTo Fiscal Year- Valid to YearCopy from source to target system

Default

WBS company code PRPS-PBUKR

Transformation Mapping


Controlling Area
Mapping Table NameMapping Table DescriptionValue Mapping:  Old to New Controlling Area
Cost CentreValue Mapping:  Old to New Cost Centre
Fixed AssetValue Mapping:  Old to New Fixed Asset

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 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 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 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
1070Fixed Asset
1026WBS - Capex, Opex, Statistical

Error Handling


Error TypeError DescriptionAction Taken
1
Maintain settlement rule not allowed
Receiver missing for distribution rule

Correct upload data, 

Enter the missing receiver

2WBS element does not existCorrect upload data

Flag WBS as account assignment

4G/L Account not in chart of accountCorrect upload data
2


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