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

Compare with Current View Page History

« Previous Version 2 Next »

Status

60%

Owner

GANESAN-ext, Shivkumar

StakeholdersPILLAY-ext, Lawrence 

Purpose

The purpose of this document is to define the conversion approach to create conversion for Object 1111 – Activity Rates in S/4 HANA.

Activity Rates are the current active rates for different activities performed either for production, plant maintenance, HR etc. The activity rates capture the planned cost for a certain activity over a period of time. E.g. Factory overhead is charged to production orders via relevant activity types maintained for absorbing factory overheads. The activity rates are maintained for a combination of activity types and cost centre combination.

The document details out the field list, extraction criteria, scoping, mapping, transformation logic, generation of the pre-load file and loading of the same with respect to the object 1111- Activity Rate.

Key tables and fields: 

The table mentioned below is the main table used for Activity Rates in S4.

COEJT - This table stores the year related line items for activity prices. It holds data about the planned and actual costs associated with activities within an internal order/ work centre for a specific fiscal year.

  • KOKRS – This field stores the controlling area information.
  • BELNR – This field stores the document number once the activity price is updated through KP27 or uploaded through a program. This is autogenerated by the system.
  • BUZEI – This field stores the posting row information. This is auto generated by the system.
  • PERBL – This field stores the period block information.
  • GJAHR – Fiscal year for which the planned prices are being maintained
  • TKG001 – This field holds the total price per UOM in CO area currency for period 1
  • TKG002 – This field holds the total price per UOM in CO area currency for period 2
  • TKG003 – This field holds the total price per UOM in CO area currency for period 3
  • TKG004 – This field holds the total price per UOM in CO area currency for period 4
  • TKG005 – This field holds the total price per UOM in CO area currency for period 5
  • TKG006 – This field holds the total price per UOM in CO area currency for period 6
  • TKG007 – This field holds the total price per UOM in CO area currency for period 7
  • TKG008 – This field holds the total price per UOM in CO area currency for period 8
  • TKG009 – This field holds the total price per UOM in CO area currency for period 9
  • TKG010 – This field holds the total price per UOM in CO area currency for period 10
  • TKG011 – This field holds the total price per UOM in CO area currency for period 11
  • TKG012 – This field holds the total price per UOM in CO area currency for period 12
  • TKG013 – This field holds the total price per UOM in CO area currency for period 13
  • TKG014 – This field holds the total price per UOM in CO area currency for period 14
  • TKG015 – This field holds the total price per UOM in CO area currency for period 15
  • TKG016 – This field holds the total price per UOM in CO area currency for period 16
  • TKF001 – This field holds the Fixed price per UOM in CO area currency for period 1
  • TKF002 – This field holds the Fixed price per UOM in CO area currency for period 2
  • TKF003 – This field holds the Fixed price per UOM in CO area currency for period 3
  • TKF004 – This field holds the Fixed price per UOM in CO area currency for period 4
  • TKF005 – This field holds the Fixed price per UOM in CO area currency for period 5
  • TKF006 – This field holds the Fixed price per UOM in CO area currency for period 6
  • TKF007 – This field holds the Fixed price per UOM in CO area currency for period 7
  • TKF008 – This field holds the Fixed price per UOM in CO area currency for period 8
  • TKF009 – This field holds the Fixed price per UOM in CO area currency for period 9
  • TKF010 – This field holds the Fixed price per UOM in CO area currency for period 10
  • TKF011 – This field holds the Fixed price per UOM in CO area currency for period 11
  • TKF012 – This field holds the Fixed price per UOM in CO area currency for period 12
  • TKF013 – This field holds the Fixed price per UOM in CO area currency for period 13
  • TKF014 – This field holds the Fixed price per UOM in CO area currency for period 14
  • TKF015 – This field holds the Fixed price per UOM in CO area currency for period 15
  • TKF016 – This field holds the Fixed price per UOM in CO area currency for period 16
  • TKE001 – This field holds the Price Unit in CO area currency for period 1
  • TKE002 – This field holds the Price Unit in CO area currency for period 2
  • TKE003 – This field holds the Price Unit in CO area currency for period 3
  • TKE004 – This field holds the Price Unit in CO area currency for period 4
  • TKE005 – This field holds the Price Unit in CO area currency for period 5
  • TKE006 – This field holds the Price Unit in CO area currency for period 6
  • TKE007 – This field holds the Price Unit in CO area currency for period 7
  • TKE008 – This field holds the Price Unit in CO area currency for period 8
  • TKE009 – This field holds the Price Unit in CO area currency for period 9
  • TKE010 – This field holds the Price Unit in CO area currency for period 10
  • TKE011 – This field holds the Price Unit in CO area currency for period 11
  • TKE012 – This field holds the Price Unit in CO area currency for period 12
  • TKE013 – This field holds the Price Unit in CO area currency for period 13
  • TKE014 – This field holds the Price Unit in CO area currency for period 14
  • TKE015 – This field holds the Price Unit in CO area currency for period 15
  • TKE016 – This field holds the Price Unit in CO area currency for period 16
  • TOG001 – This field holds Fixed and Variable Price per UOM in Object Currency for period 1
  • TOG002 – This field holds Fixed and Variable Price per UOM in Object Currency for period 2
  • TOG003 – This field holds Fixed and Variable Price per UOM in Object Currency for period 3
  • TOG004 – This field holds Fixed and Variable Price per UOM in Object Currency for period 4
  • TOG005 – This field holds Fixed and Variable Price per UOM in Object Currency for period 5
  • TOG006 – This field holds Fixed and Variable Price per UOM in Object Currency for period 6
  • TOG007 – This field holds Fixed and Variable Price per UOM in Object Currency for period 7
  • TOG008 – This field holds Fixed and Variable Price per UOM in Object Currency for period 8
  • TOG009 – This field holds Fixed and Variable Price per UOM in Object Currency for period 9
  • TOG010 – This field holds Fixed and Variable Price per UOM in Object Currency for period 10
  • TOG011 – This field holds Fixed and Variable Price per UOM in Object Currency for period 11
  • TOG012 – This field holds Fixed and Variable Price per UOM in Object Currency for period 12
  • TOG013 – This field holds Fixed and Variable Price per UOM in Object Currency for period 13
  • TOG014 – This field holds Fixed and Variable Price per UOM in Object Currency for period 14
  • TOG015 – This field holds Fixed and Variable Price per UOM in Object Currency for period 15
  • TOG016 – This field holds Fixed and Variable Price per UOM in Object Currency for period 16
  • TOF001 – This field holds Fixed Price per UOM in Object Currency for period 1
  • TOF002 – This field holds Fixed Price per UOM in Object Currency for period 2
  • TOF003 – This field holds Fixed Price per UOM in Object Currency for period 3
  • TOF004 – This field holds Fixed Price per UOM in Object Currency for period 4
  • TOF005 – This field holds Fixed Price per UOM in Object Currency for period 5
  • TOF006 – This field holds Fixed Price per UOM in Object Currency for period 6
  • TOF007 – This field holds Fixed Price per UOM in Object Currency for period 7
  • TOF008 – This field holds Fixed Price per UOM in Object Currency for period 8
  • TOF009 – This field holds Fixed Price per UOM in Object Currency for period 9
  • TOF010 – This field holds Fixed Price per UOM in Object Currency for period 10
  • TOF011 – This field holds Fixed Price per UOM in Object Currency for period 11
  • TOF012 – This field holds Fixed Price per UOM in Object Currency for period 12
  • TOF013 – This field holds Fixed Price per UOM in Object Currency for period 13
  • TOF014 – This field holds Fixed Price per UOM in Object Currency for period 14
  • TOF015 – This field holds Fixed Price per UOM in Object Currency for period 15
  • TOF016 – This field holds Fixed Price per UOM in Object Currency for period 16
  • TOE001 – This field holds Price Units in Object Currency for period 1
  • TOE002 – This field holds Price Units in Object Currency for period 2
  • TOE003 – This field holds Price Units in Object Currency for period 3
  • TOE004 – This field holds Price Units in Object Currency for period 4
  • TOE005 – This field holds Price Units in Object Currency for period 5
  • TOE006 – This field holds Price Units in Object Currency for period 6
  • TOE007 – This field holds Price Units in Object Currency for period 7
  • TOE008 – This field holds Price Units in Object Currency for period 8
  • TOE009 – This field holds Price Units in Object Currency for period 9
  • TOE010 – This field holds Price Units in Object Currency for period 10
  • TOE011 – This field holds Price Units in Object Currency for period 11
  • TOE012 – This field holds Price Units in Object Currency for period 12
  • TOE013 – This field holds Price Units in Object Currency for period 13
  • TOE014 – This field holds Price Units in Object Currency for period 14
  • TOE015 – This field holds Price Units in Object Currency for period 15
  • TOE016 – This field holds Price Units in Object Currency for period 16
  • TXG001 – This field holds Total Price per UOM in User Selected Currency for period 1
  • TXG002 – This field holds Total Price per UOM in User Selected Currency for period 2
  • TXG003 – This field holds Total Price per UOM in User Selected Currency for period 3
  • TXG004 – This field holds Total Price per UOM in User Selected Currency for period 4
  • TXG005 – This field holds Total Price per UOM in User Selected Currency for period 5
  • TXG006 – This field holds Total Price per UOM in User Selected Currency for period 6
  • TXG007 – This field holds Total Price per UOM in User Selected Currency for period 7
  • TXG008 – This field holds Total Price per UOM in User Selected Currency for period 8
  • TXG009 – This field holds Total Price per UOM in User Selected Currency for period 9
  • TXG010 – This field holds Total Price per UOM in User Selected Currency for period 10
  • TXG011 – This field holds Total Price per UOM in User Selected Currency for period 11
  • TXG012 – This field holds Total Price per UOM in User Selected Currency for period 12
  • TXG013 – This field holds Total Price per UOM in User Selected Currency for period 13
  • TXG014 – This field holds Total Price per UOM in User Selected Currency for period 14
  • TXG015 – This field holds Total Price per UOM in User Selected Currency for period 15
  • TXG016 – This field holds Total Price per UOM in User Selected Currency for period 16
  • TXF001 – This field holds Fixed Price per UOM in User Selected Currency for period 1
  • TXF002 – This field holds Fixed Price per UOM in User Selected Currency for period 2
  • TXF003 – This field holds Fixed Price per UOM in User Selected Currency for period 3
  • TXF004 – This field holds Fixed Price per UOM in User Selected Currency for period 4
  • TXF005 – This field holds Fixed Price per UOM in User Selected Currency for period 5
  • TXF006 – This field holds Fixed Price per UOM in User Selected Currency for period 6
  • TXF007 – This field holds Fixed Price per UOM in User Selected Currency for period 7
  • TXF008 – This field holds Fixed Price per UOM in User Selected Currency for period 8
  • TXF009 – This field holds Fixed Price per UOM in User Selected Currency for period 9
  • TXF010 – This field holds Fixed Price per UOM in User Selected Currency for period 10
  • TXF011 – This field holds Fixed Price per UOM in User Selected Currency for period 11
  • TXF012 – This field holds Fixed Price per UOM in User Selected Currency for period 12
  • TXF013 – This field holds Fixed Price per UOM in User Selected Currency for period 13
  • TXF014 – This field holds Fixed Price per UOM in User Selected Currency for period 14
  • TXF015 – This field holds Fixed Price per UOM in User Selected Currency for period 15
  • TXF016 – This field holds Fixed Price per UOM in User Selected Currency for period 16
  • TXE001 – This field holds Unit Prices in in User Selected Currency for period 1
  • TXE002 – This field holds Unit Prices in in User Selected Currency for period 2
  • TXE003 – This field holds Unit Prices in in User Selected Currency for period 3
  • TXE004 – This field holds Unit Prices in in User Selected Currency for period 4
  • TXE005 – This field holds Unit Prices in in User Selected Currency for period 5
  • TXE006 – This field holds Unit Prices in in User Selected Currency for period 6
  • TXE007 – This field holds Unit Prices in in User Selected Currency for period 7
  • TXE008 – This field holds Unit Prices in in User Selected Currency for period 8
  • TXE009 – This field holds Unit Prices in in User Selected Currency for period 9
  • TXE010 – This field holds Unit Prices in in User Selected Currency for period 10
  • TXE011 – This field holds Unit Prices in in User Selected Currency for period 11
  • TXE012 – This field holds Unit Prices in in User Selected Currency for period 12
  • TXE013 – This field holds Unit Prices in in User Selected Currency for period 13
  • TXE014 – This field holds Unit Prices in in User Selected Currency for period 14
  • TXE015 – This field holds Unit Prices in in User Selected Currency for period 15
  • TXE016 – This field holds Unit Prices in in User Selected Currency for period 16
  • LEDNR – Leger number for controlling objects
  • OBJNR – This field will be auto generated by the system.
  • WRTTP – Value Type
  • VERSN – This field holds the version against which the planned prices are maintained.
  • VRGNG – This field holds the CO Business Transaction.
  • REFBZ – This field holds the posting row of reference document information.
  • TARKZ - This field holds the price indicator, to calculate allocation price
  • ZLENR – This field holds the document item number.

The requirement is to migrate planned activity rates. The actual activity rates would be performed within the S4 system as a part of the month end activity.

The activity prices can be extracted from the legacy SAP system and loaded to S4 Hana. Migration object Cost rate i.e. “S4_CO_ACTIVITY_PRICE” can be used for migrating the planned activity prices. SAP has also provided function module “BAPI_COSTACTPLN_POSTACTOUTPUT” for migration of activity prices. Some activity prices will be extracted from ECC, while others will be provided by the business in the DCT page.

Conversion Scope

The scope of this document covers the approach for migration of planned activity prices.

The data from legacy system needs to be confirmed by the business.  

List of source systems and approximate number of records <number of company codes to be confirmed relevant for activity rates needs to be confirmed>

SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2Activity Rate1763S4HANA1763
WP2Activity Rate663S4HANA663

Additional Information

Multi-language Requirement

None

Document Management

Not Applicable

Legal Requirement

Not Applicable

Special Requirements

Not Applicable

Target Design

The Target design of the object 1111 – Activity rates is as below

Table

Field

Data Element

Field Description

Data Type

Length

Requirement

COEJT

KOKRS

KOKRS

Controlling area

CHAR

4

Mandatory

COEJT

BELNR

CO_BELNR

Document Number

CHAR

10

System Generated

COEJT

BUZEI

CO_BUZEI

Posting Row

NUMC

3

System Generated

COEJT

PERBL

PERBL

Period Block

NUMC

3

Mandatory

COEJT

TKG001

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional

COEJT

TKG002

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 & 2 Decimals

Optional

COEJT

TKG003

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 & 2 Decimals

Optional

COEJT

TKG004

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 & 2 Decimals

Optional

COEJT

TKG005

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 & 2 Decimals

Optional

COEJT

TKG006

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 & 2 Decimals

Optional

COEJT

TKG007

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 & 2 Decimals

Optional


COEJT

TKG008

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 & 2 Decimals

Optional


COEJT

TKG009

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 & 2 Decimals

Optional


COEJT

TKG010

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 & 2 Decimals

Optional


COEJT

TKG011

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 & 2 Decimals

Optional


COEJT

TKG012

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 & 2 Decimals

Optional


COEJT

TKG013

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:22 & 2 Decimals

Optional


COEJT

TKG014

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 & 2 Decimals

Optional


COEJT

TKG015

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKG016

TKGXXX

Total Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF001

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF002

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF003

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF004

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF005

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF006

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF007

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF008

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF009

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF010

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF011

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF012

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF013

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF014

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF015

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TKF016

TKFXXX

Fixed Price per Activity Price in CO Area Currency

CURR

Length:23 and 2 Decimals

Optional

COEJT

TKE001

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE002

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE003

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE004

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE005

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE006

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE007

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE008

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE009

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE010

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE011

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE012

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE013

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE014

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE015

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional

COEJT

TKE016

TKEXXX

Price Unit in CO Area Currency

NUMC

5

Optional


COEJT

TOG001

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG002

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG003

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG004

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG005

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG006

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG007

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG008

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG009

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG010

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG011

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG012

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG013

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG014

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG015

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOG016

TOGXXX

Fixed and Variable Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF001

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF002

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF003

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF004

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF005

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF006

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF007

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF008

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF009

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF010

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF011

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF012

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF013

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF014

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF015

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOF016

TOFXXX

Fixed Price per UoM in Object Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TOE001

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE002

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE003

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE004

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE005

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE006

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE007

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE008

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE009

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE010

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE011

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE012

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE013

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE014

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE015

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TOE016

TOEXXX

Price Units in Object Currency

NUMC

5

Optional


COEJT

TXG001

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG002

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG003

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG004

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG005

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG006

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG007

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG008

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG009

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG010

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG011

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG012

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG013

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG014

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG015

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXG016

TXGXXX

Total Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF001

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF002

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF003

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF004

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF005

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF006

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF007

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF008

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF009

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF010

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF011

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF012

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF013

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF014

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF015

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXF016

TXFXXX

Fixed Price per Activity Price in User-Selected Currency

CURR

Length:23 and 2 Decimals

Optional


COEJT

TXE002

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE003

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE004

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE005

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE006

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE007

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE008

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE009

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE010

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE011

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE012

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE013

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE014

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE015

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

TXE016

TXEXXX

Unit of Prices in User-Selected Currency

NUMC

5

Optional


COEJT

LEDNR

LEDNR

Ledger for Controlling Objects

CHAR

2

Optional

COEJT

OBJNR

J_OBJNR

Object Number

CHAR

22

Optional

COEJT

GJAHR

GJAHR

Fiscal Year

NUMC

4

Mandatory

COEJT

WRTTP

CO_WRTTP

Value Type

CHAR

2

Mandatory

COEJT

VERSN

VERSN

Version

CHAR

3

Mandatory

COEJT

TARKZ

TARKZ

Price Indicator: Calculate Allocation Price

CHAR

3

Mandatory

COEJT

VRGNG

CO_VORGANG

CO Business Transaction

CHAR

4

System Generated

COEJT

SGTXT

CO_SGTXT

Segment text

CHAR

50

Not Used

COEJT

REFBZ

CO_REFBZ

Posting Row of Reference Document

NUMC

3

System Generated

Data Cleansing

For the purpose of the Object 1111- Activity rates, it is expected that only the relevant data will be extracted to the S4 system. Activity rates for some activities will be provided by the business in the DCT page (refer to relevancy section for details). Data cleansing is not relevant for extraction. The data will be extracted based on the signed off relevancy criteria.

Conversion Process 

The generic high-level process steps for the conversion are as below:

  1. Extraction:
    1. Extract from the source systems: Apply the selection parameters and data relevancy as mentioned in this specification, from the relevant tables
  2. Transform 
    1. Transform fields by applying the fields and value mapping in the Syniti 
    2. Generate and validate Pre-load files
  3. Load
    1. Load the validated Pre-load file using migration object “Cost rate” i.e. “S4_CO_ACTIVITY_PRICE” for migrating the planned activity prices. SAP has also provided function module “BAPI_COSTACTPLN_POSTACTOUTPUT” for migration of activity prices.

Data Privacy and Sensitivity

None

Extraction

Extract data from a source into. There are 2 possibilities:

  1. The data exists. connects to the source and loads the data into. There are 2 methods:
    1. Perform full data extraction from relevant tables in the source system(s).
    2. Perform extraction through the application layer.
  2. The data does not exist (or cannot be converted from its current state). The data is manually collected by the business directly in the DCT (Data Collection Template) page. There are some activity prices for which the business will provide data in the DCT page.
  3. The extraction will be based on the signed off extraction rules.
  4. The relevancy criteria for activity rates would include (Source Conv Spec Relevancy criteria)
    • The latest activity rates as on the date of cutover will be used for migration. E.g. Year = cutover year, period = cutover period i.e. the activity rates as on the date of cutover e.g. if the cutover is 31st Aug 2026, then the activity rates as existing in ECC as on 31st Aug 2026 will be considered. All active activity type where the activity rate is greater than "0" will need to be migrated.
    • Activity rates of active activity types (i.e. valid activity types and corresponding cost centres) would be considered for migration
    • The activity rates should correspond and align to the Activity Price, quantity and technical specifications as maintained in the legacy system.
    • Any changes or adjustments to the activity rates, required for harmonisation will need to be approved by the business.
  1. The source for activity rates as agreed with business will be as mentioned below (source: Conv Spec Relevancy Criteria)
    • Activity rates for production activities will be provided in DCT by business
    • Activity rates for Maintenance. IT. Engineering and R&D will be takeover values i.e. will be extracted from ECC
    • Activity rates for employee cost will be takeover values these will be extracted from ECC.
    • Activity rates for Plant Maintenance will be take over values i.e. will be extracted from ECC.
    • Activity rates for contingency workers will be provided in DCT by business.

Extraction Run Sheet

Req #

Requirement Description

Team Responsible

01

Activities for which data is to be provided in the DCT page, the relevant data will be extracted from the ECC tables and they will be provided in the DCT page.

Business

Selection Screen

Not Applicable

Data Collection Template (DCT)

Target Ready Data Collection Template will be created for1111- Activity Rates data with exception of some fields which require transformation as mentioned in the transformation rule.

1111 – Activity Rates Data DCT Rules

 The source for activity rates as agreed with business will be as mentioned below (source: Conv Spec Relevancy Criteria)

  • Activity rates for production activities will be provided in DCT by business
  • Activity rates for Maintenance. IT. Engineering and R&D will be takeover values i.e. will be extracted from ECC
  • Activity rates for employee cost will be takeover values these will be extracted from ECC.
  • Activity rates for Plant Maintenance will be take over values i.e. will be extracted from ECC.

Activity rates for contingency workers will be provided in DCT by business.

The latest activity rates as on the date of cutover will be used for migration. E.g.  year = cutover year, period = cutover period i.e. the active rates as on the date of cutover e.g. if the cutover is 31st Aug 2026, then the activity rates as existing in ECC as on 31st Aug 2026 will be considered. All active activity type where the activity rate is > “0” will need to be migrated.

Field Name

Field Description

Rule

KOKRS

Controlling area

As per DCT - Mandatory

BELNR

Document Number

System Generated

BUZEI

Posting Row

System Generated

PERBL

Period Block

As per DCT - Mandatory

TKG001

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG002

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG003

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG004

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG005

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG006

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG007

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG008

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG009

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG010

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG011

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG012

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG013

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG014

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG015

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKG016

Total Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF001

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF002

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF003

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF004

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF005

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF006

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF007

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF008

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF009

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF010

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF011

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF012

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF013

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF014

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF015

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKF016

Fixed Price per Activity Price in CO Area Currency

As per DCT - Optional

TKE001

Price Unit in CO Area Currency

As per DCT - Optional

TKE002

Price Unit in CO Area Currency

As per DCT - Optional

TKE003

Price Unit in CO Area Currency

As per DCT - Optional

TKE004

Price Unit in CO Area Currency

As per DCT - Optional

TKE005

Price Unit in CO Area Currency

As per DCT - Optional

TKE006

Price Unit in CO Area Currency

As per DCT - Optional

TKE007

Price Unit in CO Area Currency

As per DCT - Optional

TKE008

Price Unit in CO Area Currency

As per DCT - Optional

TKE009

Price Unit in CO Area Currency

As per DCT - Optional

TKE010

Price Unit in CO Area Currency

As per DCT - Optional

TKE011

Price Unit in CO Area Currency

As per DCT - Optional

TKE012

Price Unit in CO Area Currency

As per DCT - Optional

TKE013

Price Unit in CO Area Currency

As per DCT - Optional

TKE014

Price Unit in CO Area Currency

As per DCT - Optional

TKE015

Price Unit in CO Area Currency

As per DCT - Optional

TKE016

Price Unit in CO Area Currency

As per DCT - Optional

TOG001

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG002

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG003

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG004

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG005

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG006

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG007

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG008

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG009

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG010

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG011

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG012

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG013

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG014

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG015

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOG016

Fixed and Variable Price per UoM in Object Currency

As per DCT - Optional

TOF001

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF002

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF003

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF004

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF005

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF006

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF007

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF008

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF009

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF010

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF011

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF012

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF013

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF014

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF015

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOF016

Fixed Price per UoM in Object Currency

As per DCT - Optional

TOE001

Price Units in Object Currency

As per DCT - Optional

TOE002

Price Units in Object Currency

As per DCT - Optional

TOE003

Price Units in Object Currency

As per DCT - Optional

TOE004

Price Units in Object Currency

As per DCT - Optional

TOE005

Price Units in Object Currency

As per DCT - Optional

TOE006

Price Units in Object Currency

As per DCT - Optional

TOE007

Price Units in Object Currency

As per DCT - Optional

TOE008

Price Units in Object Currency

As per DCT - Optional

TOE009

Price Units in Object Currency

As per DCT - Optional

TOE010

Price Units in Object Currency

As per DCT - Optional

TOE011

Price Units in Object Currency

As per DCT - Optional

TOE012

Price Units in Object Currency

As per DCT - Optional

TOE013

Price Units in Object Currency

As per DCT - Optional

TOE014

Price Units in Object Currency

As per DCT - Optional

TOE015

Price Units in Object Currency

As per DCT - Optional

TOE016

Price Units in Object Currency

As per DCT - Optional

TXG001

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG002

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG003

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG004

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG005

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG006

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG007

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG008

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG009

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG010

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG011

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG012

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG013

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG014

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG015

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXG016

Total Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF001

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF002

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF003

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF004

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF005

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF006

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF007

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF008

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF009

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF010

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF011

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF012

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF013

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF014

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF015

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXF016

Fixed Price per Activity Price in User-Selected Currency

As per DCT - Optional

TXE002

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE003

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE004

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE005

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE006

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE007

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE008

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE009

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE010

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE011

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE012

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE013

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE014

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE015

Unit of Prices in User-Selected Currency

As per DCT - Optional

TXE016

Unit of Prices in User-Selected Currency

As per DCT - Optional

LEDNR

Ledger for Controlling Objects

As per DCT – Leave it blank

OBJNR

Object Number

System Generated

GJAHR

Fiscal Year

As per DCT - Mandatory

WRTTP

Value Type

As per DCT - Mandatory

VERSN

Version

As per DCT - Mandatory

TARKZ

Price Indicator: Calculate Allocation Price

As per DCT - Mandatory

VRGNG

CO Business Transaction

System Generated

SGTXT

Segment text

System Generated

REFBZ

Posting Row of Reference Document

As per DCT


Extraction Dependencies

Item #

Step Description

Team Responsible

01

Any period / year end close activities have been fully completed

Business

02

Active and relevant activity rate records have been identified

Business

03

Activity types are configured and are ready to use

Functional team

Transformation

The Target fields are mapped to the relevant Legacy fields 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 the value mappings.

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 Description

Team Responsible

1

Ensure all the fields that require value mapping, as stipulated Mapping tables, have the latest signed-off mapping files imported into Syniti

Data team

2

Ensure that signed off value mappings have been maintained in the Syniti 

Syniti team

3

Confirm the value mappings are maintained in Syniti

Data team

4

Ensure that the relevancy rules for extraction are signed off by all relevant business stakeholders. If a DCT page is to be used then, ensure that Signed off DCT from business has been received and maintained in Syniti 

Syniti/Data team

5

Execute transformation for the object 

Syniti team

6   

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

Syniti/Data team

7.      

Generate Pre-Load reports.

Syniti team

8.      

Generate data load count.

Syniti team

9.      

Log errors as defects, if any and address resolutions. Close defects.

Syniti/Data team

10.      

Re-transform and re-validate the Pre-load reports if necessary.

Syniti/Data team

11.   

Validate the transformed file as part of pre-load validation, raise data defects or provide the pre-load sign-off.

Business

12.   

Analyse and resolve any pre-load defects logged by business.

Syniti/Data team

13.   

Repeat steps 5 to 11 if necessary

Syniti/Data team

14.   

Proceed to pre-load validations

Data team

Transformation Rules

Activity rates from some activity type will be extracted from ECC (WP2 and PF2 system) while for others these will be provided in the DCT page by business. The guidance as agreed in relevancy meeting are as below.

  • Activity rates for production activities will be provided in DCT by business
  • Activity rates for Maintenance. IT. Engineering and R&D will be takeover values i.e. will be extracted from ECC
  • Activity rates for employee cost will be takeover values these will be extracted from ECC.
  • Activity rates for Plant Maintenance will be taken over values i.e. will be extracted from ECC.
  • Activity rates for contingency workers will be provided in DCT by business.

Rule #

Source system

Source Table

Source Field

Source Description

Target System

Target Table

Target Field

Target Description

Transformation Logic

01

WP2/PF2/DCT

COEJT

KOKRS

DCT / Legacy

S4HANA

COEJT

KOKRS

Controlling Area

From Value mapping

02

WP2/PF2/DCT

COEJT

BELNR

DCT / Legacy

S4HANA

COEJT

BELNR

Document Number

System Generated

03

WP2/PF2/DCT

COEJT

BUZEI

DCT / Legacy

S4HANA

COEJT

BUZEI

Posting Row

System Generated 

04

WP2/PF2/DCT

COEJT

PERBL

DCT / Legacy

S4HANA

COEJT

PERBL

Period Block

Copy As is  

05

WP2/PF2/DCT

COEJT

TKG001

DCT / Legacy

S4HANA

COEJT

TKG001

Total Price per UoM in CO Area Currency

Copy As Is 

06

WP2/PF2/DCT

COEJT

TKG002

DCT / Legacy

S4HANA

COEJT

TKG002

Total Price per UoM in CO Area Currency

Copy As Is 

07

WP2/PF2/DCT

COEJT

TKG003

DCT / Legacy

S4HANA


COEJT

TKG003

Total Price per UoM in CO Area Currency

Copy As Is 

08

WP2/PF2/DCT

COEJT

TKG004

DCT / Legacy

S4HANA

COEJT

TKG004

Total Price per UoM in CO Area Currency

Copy As Is 

09

WP2/PF2/DCT

COEJT

TKG005

DCT / Legacy

S4HANA

COEJT

TKG005

Total Price per UoM in CO Area Currency

Copy As Is 

10

WP2/PF2/DCT

COEJT

TKG006

DCT / Legacy

S4HANA

COEJT

TKG006

Total Price per UoM in CO Area Currency

Copy As Is 

11

WP2/PF2/DCT

COEJT

TKG007

DCT / Legacy

S4HANA

COEJT

TKG007

Total Price per UoM in CO Area Currency

Copy As Is 

12

WP2/PF2/DCT

COEJT

TKG008

DCT / Legacy

S4HANA

COEJT

TKG008

Total Price per UoM in CO Area Currency

Copy As Is 

13

WP2/PF2/DCT

COEJT

TKG009

DCT / Legacy

S4HANA

COEJT

TKG009

Total Price per UoM in CO Area Currency

Copy As Is 

14

WP2/PF2/DCT

COEJT

TKG010

DCT / Legacy

S4HANA

COEJT

TKG010

Total Price per UoM in CO Area Currency

Copy As Is 

15

WP2/PF2/DCT

COEJT

TKG011

DCT / Legacy

S4HANA

COEJT

TKG011

Total Price per UoM in CO Area Currency

Copy As Is 

16

WP2/PF2/DCT

COEJT

TKG012

DCT / Legacy

S4HANA

COEJT

TKG012

Total Price per UoM in CO Area Currency

Copy As Is 

17

WP2/PF2/DCT

COEJT

TKG013

DCT / Legacy

S4HANA

COEJT

TKG013

Total Price per UoM in CO Area Currency

Copy As Is 

18

WP2/PF2/DCT

COEJT

TKG014

DCT / Legacy

S4HANA

COEJT

TKG014

Total Price per UoM in CO Area Currency

Copy As Is 

19

WP2/PF2/DCT

COEJT

TKG015

DCT / Legacy

S4HANA

COEJT

TKG015

Total Price per UoM in CO Area Currency

Copy As Is 

20

WP2/PF2/DCT

COEJT

TKG016

DCT / Legacy

S4HANA

COEJT

TKG016

Total Price per UoM in CO Area Currency

Copy As Is 

21

WP2/PF2/DCT

COEJT

TKF001

DCT / Legacy

S4HANA

COEJT

TKF001

Fixed Price per UoM in CO Area Currency

Copy As Is 

22

WP2/PF2/DCT

COEJT

TKF002

DCT / Legacy

S4HANA

COEJT

TKF002

Fixed Price per UoM in CO Area Currency

Copy As Is 

23

WP2/PF2/DCT

COEJT

TKF003

DCT / Legacy

S4HANA

COEJT

TKF003

Fixed Price per UoM in CO Area Currency

Copy As Is 

24

WP2/PF2/DCT

COEJT

TKF004

DCT / Legacy

S4HANA

COEJT

TKF004

Fixed Price per UoM in CO Area Currency

Copy As Is 

25

WP2/PF2/DCT

COEJT

TKF005

DCT / Legacy

S4HANA

COEJT

TKF005

Fixed Price per UoM in CO Area Currency

Copy As Is 

26

WP2/PF2/DCT

COEJT

TKF006

DCT / Legacy

S4HANA

COEJT

TKF006

Fixed Price per UoM in CO Area Currency

Copy As Is 

27

WP2/PF2/DCT

COEJT

TKF007

DCT / Legacy

S4HANA

COEJT

TKF007

Fixed Price per UoM in CO Area Currency

Copy As Is 

28

WP2/PF2/DCT

COEJT

TKF008

DCT / Legacy

S4HANA

COEJT

TKF008

Fixed Price per UoM in CO Area Currency

Copy As Is 

29

WP2/PF2/DCT

COEJT

TKF009

DCT / Legacy

S4HANA

COEJT

TKF009

Fixed Price per UoM in CO Area Currency

Copy As Is 

30

WP2/PF2/DCT

COEJT

TKF010

DCT / Legacy

S4HANA

COEJT

TKF010

Fixed Price per UoM in CO Area Currency

Copy As Is 

31

WP2/PF2/DCT

COEJT

TKF011

DCT / Legacy

S4HANA

COEJT

TKF011

Fixed Price per UoM in CO Area Currency

Copy As Is 

32

WP2/PF2/DCT

COEJT

TKF012

DCT / Legacy

S4HANA

COEJT

TKF012

Fixed Price per UoM in CO Area Currency

Copy As Is 

33

WP2/PF2/DCT

COEJT

TKF013

DCT / Legacy

S4HANA

COEJT

TKF013

Fixed Price per UoM in CO Area Currency

Copy As Is 

34

WP2/PF2/DCT

COEJT

TKF014

DCT / Legacy

S4HANA

COEJT

TKF014

Fixed Price per UoM in CO Area Currency

Copy As Is 

35

WP2/PF2/DCT

COEJT

TKF015

DCT / Legacy

S4HANA

COEJT

TKF015

Fixed Price per UoM in CO Area Currency

Copy As Is 

36

WP2/PF2/DCT

COEJT

TKF016

DCT / Legacy

S4HANA

COEJT

TKF016

Fixed Price per UoM in CO Area Currency

Copy As Is 

37

WP2/PF2/DCT

COEJT

TKE001

DCT / Legacy

S4HANA

COEJT

TKE001

Price Unit in CO Area Currency

Copy As Is 

38

WP2/PF2/DCT

COEJT

TKE002

DCT / Legacy

S4HANA

COEJT

TKE002

Price Unit in CO Area Currency

Copy As Is 

39

WP2/PF2/DCT

COEJT

TKE003

DCT / Legacy

S4HANA

COEJT

TKE003

Price Unit in CO Area Currency

Copy As Is 

40

WP2/PF2/DCT

COEJT

TKE004

DCT / Legacy

S4HANA

COEJT

TKE004

Price Unit in CO Area Currency

Copy As Is 

41

WP2/PF2/DCT

COEJT

TKE005

DCT / Legacy

S4HANA

COEJT

TKE005

Price Unit in CO Area Currency

Copy As Is 

42

WP2/PF2/DCT

COEJT

TKE006

DCT / Legacy

S4HANA

COEJT

TKE006

Price Unit in CO Area Currency

Copy As Is 

43

WP2/PF2/DCT

COEJT

TKE007

DCT / Legacy

S4HANA

COEJT

TKE007

Price Unit in CO Area Currency

Copy As Is 

44

WP2/PF2/DCT

COEJT

TKE008

DCT / Legacy

S4HANA

COEJT

TKE008

Price Unit in CO Area Currency

Copy As Is 

45

WP2/PF2/DCT

COEJT

TKE009

DCT / Legacy

S4HANA

COEJT

TKE009

Price Unit in CO Area Currency

Copy As Is 

46

WP2/PF2/DCT

COEJT

TKE010

DCT / Legacy

S4HANA

COEJT

TKE010

Price Unit in CO Area Currency

Copy As Is 

47

WP2/PF2/DCT

COEJT

TKE011

DCT / Legacy

S4HANA

COEJT

TKE011

Price Unit in CO Area Currency

Copy As Is 

48

WP2/PF2/DCT

COEJT

TKE012

DCT / Legacy

S4HANA

COEJT

TKE012

Price Unit in CO Area Currency

Copy As Is 

49

WP2/PF2/DCT

COEJT

TKE013

DCT / Legacy

S4HANA

COEJT

TKE013

Price Unit in CO Area Currency

Copy As Is 

50

WP2/PF2/DCT

COEJT

TKE014

DCT / Legacy

S4HANA

COEJT

TKE014

Price Unit in CO Area Currency

Copy As Is 

51

WP2/PF2/DCT

COEJT

TKE015

DCT / Legacy

S4HANA

COEJT

TKE015

Price Unit in CO Area Currency

Copy As Is 

52

WP2/PF2/DCT

COEJT

TKE016

DCT / Legacy

S4HANA

COEJT

TKE016

Price Unit in CO Area Currency

Copy As Is 

53

WP2/PF2/DCT

COEJT

TOG001

DCT / Legacy

S4HANA

COEJT

TOG001

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

54

WP2/PF2/DCT

COEJT

TOG002

DCT / Legacy

S4HANA

COEJT

TOG002

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

55

WP2/PF2/DCT

COEJT

TOG003

DCT / Legacy

S4HANA

COEJT

TOG003

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

56

WP2/PF2/DCT

COEJT

TOG004

DCT / Legacy

S4HANA

COEJT

TOG004

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

57

WP2/PF2/DCT

COEJT

TOG005

DCT / Legacy

S4HANA

COEJT

TOG005

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

58

WP2/PF2/DCT

COEJT

TOG006

DCT / Legacy

S4HANA

COEJT

TOG006

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

59

WP2/PF2/DCT

COEJT

TOG007

DCT / Legacy

S4HANA

COEJT

TOG007

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

60

WP2/PF2/DCT

COEJT

TOG008

DCT / Legacy

S4HANA

COEJT

TOG008

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

61

WP2/PF2/DCT

COEJT

TOG009

DCT / Legacy

S4HANA

COEJT

TOG009

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

62

WP2/PF2/DCT

COEJT

TOG010

DCT / Legacy

S4HANA

COEJT

TOG010

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

63

WP2/PF2/DCT

COEJT

TOG011

DCT / Legacy

S4HANA

COEJT

TOG011

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

64

WP2/PF2/DCT

COEJT

TOG012

DCT / Legacy

S4HANA

COEJT

TOG012

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

65

WP2/PF2/DCT

COEJT

TOG013

DCT / Legacy

S4HANA

COEJT

TOG013

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

66

WP2/PF2/DCT

COEJT

TOG014

DCT / Legacy

S4HANA

COEJT

TOG014

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

67

WP2/PF2/DCT

COEJT

TOG015

DCT / Legacy

S4HANA

COEJT

TOG015

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

68

WP2/PF2/DCT

COEJT

TOG016

DCT / Legacy

S4HANA

COEJT

TOG016

Fixed and Variable Price per UoM in Object Currency

Copy As Is 

69

WP2/PF2/DCT

COEJT

TOF001

DCT / Legacy

S4HANA

COEJT

TOF001

Fixed Price per UoM in Object Currency

Copy As Is 

70

WP2/PF2/DCT

COEJT

TOF002

DCT / Legacy

S4HANA

COEJT

TOF002

Fixed Price per UoM in Object Currency

Copy As Is 

71

WP2/PF2/DCT

COEJT

TOF003

DCT / Legacy

S4HANA

COEJT

TOF003

Fixed Price per UoM in Object Currency

Copy As Is 

72

WP2/PF2/DCT

COEJT

TOF004

DCT / Legacy

S4HANA

COEJT

TOF004

Fixed Price per UoM in Object Currency

Copy As Is 

73

WP2/PF2/DCT

COEJT

TOF005

DCT / Legacy

S4HANA

COEJT

TOF005

Fixed Price per UoM in Object Currency

Copy As Is 

74

WP2/PF2/DCT

COEJT

TOF006

DCT / Legacy

S4HANA

COEJT

TOF006

Fixed Price per UoM in Object Currency

Copy As Is 

75

WP2/PF2/DCT

COEJT

TOF007

DCT / Legacy

S4HANA

COEJT

TOF007

Fixed Price per UoM in Object Currency

Copy As Is 

76

WP2/PF2/DCT

COEJT

TOF008

DCT / Legacy

S4HANA

COEJT

TOF008

Fixed Price per UoM in Object Currency

Copy As Is 

77

WP2/PF2/DCT

COEJT

TOF009

DCT / Legacy

S4HANA

COEJT

TOF009

Fixed Price per UoM in Object Currency

Copy As Is 

78

WP2/PF2/DCT

COEJT

TOF010

DCT / Legacy

S4HANA

COEJT

TOF010

Fixed Price per UoM in Object Currency

Copy As Is 

79

WP2/PF2/DCT

COEJT

TOF011

DCT / Legacy

S4HANA

COEJT

TOF011

Fixed Price per UoM in Object Currency

Copy As Is 

80

WP2/PF2/DCT

COEJT

TOF012

DCT / Legacy

S4HANA

COEJT

TOF012

Fixed Price per UoM in Object Currency

Copy As Is 

81

WP2/PF2/DCT

COEJT

TOF013

DCT / Legacy

S4HANA

COEJT

TOF013

Fixed Price per UoM in Object Currency

Copy As Is 

82

WP2/PF2/DCT

COEJT

TOF014

DCT / Legacy

S4HANA

COEJT

TOF014

Fixed Price per UoM in Object Currency

Copy As Is 

83

WP2/PF2/DCT

COEJT

TOF015

DCT / Legacy

S4HANA

COEJT

TOF015

Fixed Price per UoM in Object Currency

Copy As Is 

84

WP2/PF2/DCT

COEJT

TOF016

DCT / Legacy

S4HANA

COEJT

TOF016

Fixed Price per UoM in Object Currency

Copy As Is 

85

WP2/PF2/DCT

COEJT

TOE001

DCT / Legacy

S4HANA

COEJT

TOE001

Price Units in Object Currency

Copy As Is 

86

WP2/PF2/DCT

COEJT

TOE002

DCT / Legacy

S4HANA

COEJT

TOE002

Price Units in Object Currency

Copy As Is 

87

WP2/PF2/DCT

COEJT

TOE003

DCT / Legacy

S4HANA

COEJT

TOE003

Price Units in Object Currency

Copy As Is 

88

WP2/PF2/DCT

COEJT

TOE004

DCT / Legacy

S4HANA

COEJT

TOE004

Price Units in Object Currency

Copy As Is 

89

WP2/PF2/DCT

COEJT

TOE005

DCT / Legacy

S4HANA

COEJT

TOE005

Price Units in Object Currency

Copy As Is 

90

WP2/PF2/DCT

COEJT

TOE006

DCT / Legacy

S4HANA

COEJT

TOE006

Price Units in Object Currency

Copy As Is 

91

WP2/PF2/DCT

COEJT

TOE007

DCT / Legacy

S4HANA

COEJT

TOE007

Price Units in Object Currency

Copy As Is 

92

WP2/PF2/DCT

COEJT

TOE008

DCT / Legacy

S4HANA

COEJT

TOE008

Price Units in Object Currency

Copy As Is 

93

WP2/PF2/DCT

COEJT

TOE009

DCT / Legacy

S4HANA

COEJT

TOE009

Price Units in Object Currency

Copy As Is 

94

WP2/PF2/DCT

COEJT

TOE010

DCT / Legacy

S4HANA

COEJT

TOE010

Price Units in Object Currency

Copy As Is 

95

WP2/PF2/DCT

COEJT

TOE011

DCT / Legacy

S4HANA

COEJT

TOE011

Price Units in Object Currency

Copy As Is 

96

WP2/PF2/DCT

COEJT

TOE012

DCT / Legacy

S4HANA

COEJT

TOE012

Price Units in Object Currency

Copy As Is 

97

WP2/PF2/DCT

COEJT

TOE013

DCT / Legacy

S4HANA

COEJT

TOE013

Price Units in Object Currency

Copy As Is 

98

WP2/PF2/DCT

COEJT

TOE014

DCT / Legacy

S4HANA

COEJT

TOE014

Price Units in Object Currency

Copy As Is 

99

WP2/PF2/DCT

COEJT

TOE015

DCT / Legacy

S4HANA

COEJT

TOE015

Price Units in Object Currency

Copy As Is 

100

WP2/PF2/DCT

COEJT

TOE016

DCT / Legacy

S4HANA

COEJT

TOE016

Price Units in Object Currency

Copy As Is 

101

WP2/PF2/DCT

COEJT

TXG001

DCT / Legacy

S4HANA

COEJT

TXG001

Total Price per UoM in User-Selected Currency

Copy As Is 

102

WP2/PF2/DCT

COEJT

TXG002

DCT / Legacy

S4HANA

COEJT

TXG002

Total Price per UoM in User-Selected Currency

Copy As Is 

103

WP2/PF2/DCT

COEJT

TXG003

DCT / Legacy

S4HANA

COEJT

TXG003

Total Price per UoM in User-Selected Currency

Copy As Is 

104

WP2/PF2/DCT

COEJT

TXG004

DCT / Legacy

S4HANA

COEJT

TXG004

Total Price per UoM in User-Selected Currency

Copy As Is 

105

WP2/PF2/DCT

COEJT

TXG005

DCT / Legacy

S4HANA

COEJT

TXG005

Total Price per UoM in User-Selected Currency

Copy As Is 

106

WP2/PF2/DCT

COEJT

TXG006

DCT / Legacy

S4HANA

COEJT

TXG006

Total Price per UoM in User-Selected Currency

Copy As Is 

107

WP2/PF2/DCT

COEJT

TXG007

DCT / Legacy

S4HANA

COEJT

TXG007

Total Price per UoM in User-Selected Currency

Copy As Is 

108

WP2/PF2/DCT

COEJT

TXG008

DCT / Legacy

S4HANA

COEJT

TXG008

Total Price per UoM in User-Selected Currency

Copy As Is 

109

WP2/PF2/DCT

COEJT

TXG009

DCT / Legacy

S4HANA

COEJT

TXG009

Total Price per UoM in User-Selected Currency

Copy As Is 

110

WP2/PF2/DCT

COEJT

TXG010

DCT / Legacy

S4HANA

COEJT

TXG010

Total Price per UoM in User-Selected Currency

Copy As Is 

111

WP2/PF2/DCT

COEJT

TXG011

DCT / Legacy

S4HANA

COEJT

TXG011

Total Price per UoM in User-Selected Currency

Copy As Is 

112

WP2/PF2/DCT

COEJT

TXG012

DCT / Legacy

S4HANA

COEJT

TXG012

Total Price per UoM in User-Selected Currency

Copy As Is 

113

WP2/PF2/DCT

COEJT

TXG013

DCT / Legacy

S4HANA

COEJT

TXG013

Total Price per UoM in User-Selected Currency

Copy As Is 

114

WP2/PF2/DCT

COEJT

TXG014

DCT / Legacy

S4HANA

COEJT

TXG014

Total Price per UoM in User-Selected Currency

Copy As Is 

115

WP2/PF2/DCT

COEJT

TXG015

DCT / Legacy

S4HANA

COEJT

TXG015

Total Price per UoM in User-Selected Currency

Copy As Is 

116

WP2/PF2/DCT

COEJT

TXG016

DCT / Legacy

S4HANA

COEJT

TXG016

Total Price per UoM in User-Selected Currency

Copy As Is 

117

WP2/PF2/DCT

COEJT

TXF001

DCT / Legacy

S4HANA

COEJT

TXF001

Fixed Price per UoM in User-Selected Currency

Copy As Is 

118

WP2/PF2/DCT

COEJT

TXF002

DCT / Legacy

S4HANA

COEJT

TXF002

Fixed Price per UoM in User-Selected Currency

Copy As Is 

119

WP2/PF2/DCT

COEJT

TXF003

DCT / Legacy

S4HANA

COEJT

TXF003

Fixed Price per UoM in User-Selected Currency

Copy As Is 

120

WP2/PF2/DCT

COEJT

TXF004

DCT / Legacy

S4HANA

COEJT

TXF004

Fixed Price per UoM in User-Selected Currency

Copy As Is 

121

WP2/PF2/DCT

COEJT

TXF005

DCT / Legacy

S4HANA

COEJT

TXF005

Fixed Price per UoM in User-Selected Currency

Copy As Is 

122

WP2/PF2/DCT

COEJT

TXF006

DCT / Legacy

S4HANA

COEJT

TXF006

Fixed Price per UoM in User-Selected Currency

Copy As Is 

123

WP2/PF2/DCT

COEJT

TXF007

DCT / Legacy

S4HANA

COEJT

TXF007

Fixed Price per UoM in User-Selected Currency

Copy As Is 

124

WP2/PF2/DCT

COEJT

TXF008

DCT / Legacy

S4HANA

COEJT

TXF008

Fixed Price per UoM in User-Selected Currency

Copy As Is 

125

WP2/PF2/DCT

COEJT

TXF009

DCT / Legacy

S4HANA

COEJT

TXF009

Fixed Price per UoM in User-Selected Currency

Copy As Is 

126

WP2/PF2/DCT

COEJT

TXF010

DCT / Legacy

S4HANA

COEJT

TXF010

Fixed Price per UoM in User-Selected Currency

Copy As Is 

127

WP2/PF2/DCT

COEJT

TXF011

DCT / Legacy

S4HANA

COEJT

TXF011

Fixed Price per UoM in User-Selected Currency

Copy As Is 

128

WP2/PF2/DCT

COEJT

TXF012

DCT / Legacy

S4HANA

COEJT

TXF012

Fixed Price per UoM in User-Selected Currency

Copy As Is 

129

WP2/PF2/DCT

COEJT

TXF013

DCT / Legacy

S4HANA

COEJT

TXF013

Fixed Price per UoM in User-Selected Currency

Copy As Is 

130

WP2/PF2/DCT

COEJT

TXF014

DCT / Legacy

S4HANA

COEJT

TXF014

Fixed Price per UoM in User-Selected Currency

Copy As Is 

131

WP2/PF2/DCT

COEJT

TXF015

DCT / Legacy

S4HANA

COEJT

TXF015

Fixed Price per UoM in User-Selected Currency

Copy As Is 

132

WP2/PF2/DCT

COEJT

TXF016

DCT / Legacy

S4HANA

COEJT

TXF016

Fixed Price per UoM in User-Selected Currency

Copy As Is 

133

WP2/PF2/DCT

COEJT

TXE002

DCT / Legacy

S4HANA

COEJT

TXE002

Unit of Prices in User-Selected Currency

Copy As Is 

134

WP2/PF2/DCT

COEJT

TXE003

DCT / Legacy

S4HANA

COEJT

TXE003

Unit of Prices in User-Selected Currency

Copy As Is 

135

WP2/PF2/DCT

COEJT

TXE004

DCT / Legacy

S4HANA

COEJT

TXE004

Unit of Prices in User-Selected Currency

Copy As Is 

136

WP2/PF2/DCT

COEJT

TXE005

DCT / Legacy

S4HANA

COEJT

TXE005

Unit of Prices in User-Selected Currency

Copy As Is 

137

WP2/PF2/DCT

COEJT

TXE006

DCT / Legacy

S4HANA

COEJT

TXE006

Unit of Prices in User-Selected Currency

Copy As Is 

138

WP2/PF2/DCT

COEJT

TXE007

DCT / Legacy

S4HANA

COEJT

TXE007

Unit of Prices in User-Selected Currency

Copy As Is 

139

WP2/PF2/DCT

COEJT

TXE008

DCT / Legacy

S4HANA

COEJT

TXE008

Unit of Prices in User-Selected Currency

Copy As Is 

140

WP2/PF2/DCT

COEJT

TXE009

DCT / Legacy

S4HANA

COEJT

TXE009

Unit of Prices in User-Selected Currency

Copy As Is 

141

WP2/PF2/DCT

COEJT

TXE010

DCT / Legacy

S4HANA

COEJT

TXE010

Unit of Prices in User-Selected Currency

Copy As Is 

142

WP2/PF2/DCT

COEJT

TXE011

DCT / Legacy

S4HANA

COEJT

TXE011

Unit of Prices in User-Selected Currency

Copy As Is 

143

WP2/PF2/DCT

COEJT

TXE012

DCT / Legacy

S4HANA

COEJT

TXE012

Unit of Prices in User-Selected Currency

Copy As Is 

144

WP2/PF2/DCT

COEJT

TXE013

DCT / Legacy

S4HANA

COEJT

TXE013

Unit of Prices in User-Selected Currency

Copy As Is 

145

WP2/PF2/DCT

COEJT

TXE014

DCT / Legacy

S4HANA

COEJT

TXE014

Unit of Prices in User-Selected Currency

Copy As Is 

146

WP2/PF2/DCT

COEJT

TXE015

DCT / Legacy

S4HANA

COEJT

TXE015

Unit of Prices in User-Selected Currency

Copy As Is 

147

WP2/PF2/DCT

COEJT

TXE016

DCT / Legacy

S4HANA

COEJT

TXE016

Unit of Prices in User-Selected Currency

Copy As Is 

148

WP2/PF2/DCT

COEJT

LEDNR

DCT / Legacy

S4HANA

COEJT

LEDNR

Ledger for Controlling Objects

Blank if no explicit ledger is provided.

149

WP2/PF2/DCT

COEJT

OBJNR

DCT / Legacy

S4HANA

COEJT

OBJNR

Object Number

System Generated

150

WP2/PF2/DCT

COEJT

GJAHR

DCT / Legacy

S4HANA

COEJT

GJAHR

Fiscal Year

Copy As Is

151

WP2/PF2/DCT

COEJT

WRTTP

DCT / Legacy

S4HANA

COEJT

WRTTP

Value Type

Copy As Is 

152

WP2/PF2/DCT

COEJT

VERSN

DCT / Legacy

S4HANA

COEJT

VERSN

Version

Copy As Is 

153

WP2/PF2/DCT

COEJT

TARKZ

DCT / Legacy

S4HANA

COEJT

TARKZ

Price Indicator: Calculate Allocation Price

Copy As Is 

154

WP2/PF2/DCT

COEJT

VRGNG

DCT / Legacy

S4HANA

COEJT

VRGNG

CO Business Transaction

System Generated 

155

WP2/PF2/DCT

COEJT

SGTXT

DCT / Legacy

S4HANA

COEJT

SGTXT

Segment text

Not used 

156

WP2/PF2/DCT

COEJT

REFBZ

DCT / Legacy

S4HANA

COEJT

REFBZ

Posting Row of Reference Document

System Generated 

Transformation Mapping

Below value mapping tables should be constructed in Syniti 

Mapping Table Name

Mapping Table Description

Controlling Area

Controlling area should be configured and be available in value mapping or as default if only one controlling area is being used

Ledger

Ledger(s) should be configured and should be available.

Version

Version should be configured and should be available.

Transformation Dependencies

List the steps that need to occur before transformation can commence

Item #

Step Description

Team Responsible

1

Ensure all the fields that require value mapping, as stipulated Mapping tables, have the latest signed-off mapping files imported into Syniti

Data team

2

Ensure that signed off value mappings have been maintained in the Syniti 

Syniti team

3

Confirm the value mappings as maintained in the Syniti

Data team

4

Ensure that Signed off DCT from business has been received and maintained in Syniti

Syniti/Data team

5

Confirm on the extracted values

Syniti, Data and business


Pre-Load Validation

Project Team

The Pre Load validations are performed by Project Team

Completeness

Task

Action

Generation of
Pre-load reports

Mandatory field check.

  • Check if the fiscal year and period is correctly maintained
  • Check if the version is correct
  • Check if the activity types and corresponding cost centre are correct.
  • Check the Price unit
  • Check the controlling area

Record Count

Record Count

Confirm the record counts in preload summary report

  • Total Records: 
  • Valid Records:

Invalid Records:

Business Confirmation

Data team after the initial validation of Pre-Load validation based on the pre agreed validation checklist

To send the Pre-Load file to the Business Representatives for all plants/valuation area in scope for conversion

Business Representatives to validate the pre-load file

Agree with data team on the next steps for erroneous records


Accuracy

Task

Action

Mandatory field mapping and transformation

Obtain a list of the fields to be populated with values from mapping files and ensure all these fields contain S/4HANA values. 
Mandatory field check.

  • Check if the fiscal year and period is correctly maintained
  • Check if the version is correct
  • Check if the activity types and corresponding cost centre are correct.
  • Check the Price unit
  • Check the controlling area

Business Value Checks

The total values as per the relevancy /DCT and pre-load value are matching for the fields containing the limit amounts

Records in Errors

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.

Business

The following pre-load validations will be performed by business.

Completeness

TaskAction

Check Data load register count

Business Data Owner/s to verify that the total number of relevant records to be converted as per relevancy / DCT is equal to the total number of records in the Preload file.

Accuracy

TaskAction

Conversion accuracy

To check and validate the load files with all the transformation and mapping rules, to be signed off.


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
  3. Execute the automated data load into target system using load tool or produce the load file if the loading of records to be done using LTMC cockpit object of Activity Price (Limit Products)
  4. Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation with side by side check of each fields in scope of the objects with fields to be displayed as XXXX_ECC, XXXX_S4HANA, XXXX_MATCH ( As TRUE or FALSE) with an additional column denoting fields not matching and status of loading in S/4HANA as LOADED_IN_S4HANA ( As TRUE or FALSE) 

Load Run Sheet

Item #

Step Description

Team Responsible

1

Go to load file and pick 5 data records, load manually without any tool. See what happens. If all okay, proceed with the next step.

Data team

2

Go to load file and pick 10 records and load them with the tool. No action if the previous step has fallen. If not, then continue to load 10 records with the tool. Check if everything went okay.

Data team

3

Proceed with the full load if steps one and two were succeed else fix the issue with records

Data team

4

Validate few records loaded by accessing standard transactions from S/4HNA e.g. KP27 to check the activity prices.

Data team

5

Generate post load report if step 5 is validated

Data team

6

Log errors as defects, if any and address resolutions. Close defects.

Data team

7

Resolve defects by reupload and re-generate post load reports if necessary.

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 1 to 5 if necessary.

Data team


Load Phase and Dependencies

The load phase for this object is ideally relevant for pre-cutover Phase 4

Configuration

Below configurations must exist to facilitate the conversion of this object.

Item #

Configuration Item

01

Controlling Area

02

Company code

03

Activity types (Master Data)

04

Version

05

Ledger(s)

 Conversion Objects

Object #

Preceding Object Conversion Approach

CNV-1074

Cost Centre(s)

CNV-1071

Activity types

CNV-1072

Exchange Rates

Error Handling

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

Activity price 

Activity price wrong conversion with regards to price unit

Ensure that the price unit is correctly picked

Fiscal Year

Enter correct fiscal year

Correct fiscal year

Activity type

Cost centre and activity type combination does not match

Ensure to maintain the correct cost centre and activity type match.


Post-Load Validation

Project Team

The following post load validations will be done by Project Team

Completeness

TaskAction

Reconciliation of Record Count

Record Count - Count and check how many records were loaded vs. Records in the load file (Each mock has its own data record count)

Check for logs from Load and fix erroneous records, if any.

Accuracy

TaskAction

Check values in key fields for accuracy

Post-load reports will have the same structure as the load file and some additional columns as required to facilitate the post load validation.

Leverage on tool to create a Post Load report that reports S/4HANA loaded records along with the legacy values side-by-side to allow for 100% check of all these fields in the shortest possible time.

Any mismatch will be reported under the Post Load - Error report.

Business

The following post load validations will be done by business.

Completeness

TaskAction

Record Count Check

Review the record count report from the Data Team and ensure it is correct by cross-checking with the record count confirmed during Pre-load Business Validations

Business may also run transaction code KP27 to cross check the Activity Prices 


Accuracy

TaskAction

Field Checks

Check the fields to ensure that Activity Prices have been properly maintained

Value Check

Check the activity prices against activity types and corresponding cost centres.


Key Assumptions

  • Relevancy rules has been thoroughly validated and signed off by business.
  • Activity types and cost centre combination has been validated.

Change log

Version Published Changed By Comment
CURRENT (v. 2) Jan 13, 2026 10:12 GANESAN-ext, Shivkumar
v. 15 Jan 12, 2026 19:31 GANESAN-ext, Shivkumar
v. 14 Jan 12, 2026 14:28 GANESAN-ext, Shivkumar
v. 13 Jan 12, 2026 13:36 GANESAN-ext, Shivkumar
v. 12 Jan 09, 2026 15:57 GANESAN-ext, Shivkumar
v. 11 Jan 09, 2026 15:14 GANESAN-ext, Shivkumar
v. 10 Jan 09, 2026 10:05 GANESAN-ext, Shivkumar
v. 9 Jan 07, 2026 11:33 GANESAN-ext, Shivkumar
v. 8 Jan 07, 2026 11:14 GANESAN-ext, Shivkumar
v. 7 Dec 18, 2025 16:37 GANESAN-ext, Shivkumar

Go to Page History

Workflow history

Title Last Updated By Updated Status  
There are no pages at the moment.

  • No labels