(warning)     (warning)     (warning)     (warning)

The new wiki link for this data flow is here:

BW - DP - ERP Group of Activities - Sales Order (PF1 Only) 

Please update the new doc there and no longer here.

(warning)    (warning)     (warning)     (warning) 


General presentation


The ERP Group of Activities (C_PFCTR2) on sales order flow is determined from the "Sub Activity 2" master data, several steps are necessary to determine the correct business area associated with the sales order.

The sources used to obtain the Sub Activity are the "Technical Profit Center - C_TECPCTR" master data and the "Technical Business Area - C_TECHBA" master data.

The Sub Activity is determined in the main sources below, they are maintained by the Global Sales team:

  • DSO DBSDSO11 - SO Global: Sales Document Item Data (Solvay).


For the Technical Profit Center and Technical Business Area masterdata, we need the information below:


_____________________________________________________________________________________________________________________________________

1 ) ERP Group of Activities Rule - Sales Order Flow (PF1 Only) 


Explanation of the rule applied by Global sales in the DSO DBSDSO11:

Case 1 :  Technical Profit Center - C_TECPCTR

If the information from the sales order results in a Sub Activity, then the Technical Profit Center master data will be the only source to determine the Sub Activity.

Example :

Company Code5726
Plant5019
Business Area9CI0
Controlling AreaCHEF
Profit CenterFCHICA1XU1
=> Sub Activity 9CH0



Then we can get the Group of Activities associated with the Sub Activity 9CH0:


Case 2 :  Technical Profit Center (C_TECPCTR)+ Material Plant (C_MATPNT2)

If the order information is not complete. this case was observed on orders with an empty profit center or not supported by Technical Profit Center masterdata (profit center that does not start with F or D).
So in this case, we use the Material Plant masterdata to obtain the current profit center associated with the Material / Plant.

Example for Sales order :  #199056


The profit center must be filled to be able to use the Technical Profit Center masterdata. so we will add an additional step to get the current profit center available in the Material Plant masterdata.


Then we will use the Technical Profit Center masterdata + the Sub Activity masterdata as in Case 1.

Company Code 0366
PlantMTP
Business Area7360
Controlling AreaCHEF
Profit CenterF6519XXXT2   (From Material Plant)
=> Sub Activity 7650


Technical Profit Center : C_TECPCTR


Sub Activity 2 - C_SUBACT2


Case 3 : Technical Business Area - C_TECHBA

If the solutions listed below (Case 1 & Case 2) do not allow to get a Sub Activity. the "Technical Business Area" masterdata is used as a last resort based on the profit center, the plant and the company code.


Example for order :  #76050


Technical Business Area - C_TECHBA


Sub Activity 2 - C_SUBACT2


2 ) List of DynaSys interfaces using the Group of Activities


InterfaceSource of Group of Activities Note
DYS_BW_SKU_PW.csvC_MATPNT2 (Look up from C_TECPCTR / C_TECHBA)

this file is not based on sales orders. it is a DynaSys Material Plant referential.

The information necessary to determine the group of activities comes from the masterdata C_MATPNT2

DYS_BW_DFU.csvDBSDSO11 (Look up from C_TECPCTR / C_TECHBA)

This file is fed by 2 separate flows: Sales Orders and M3 Orders.

The Group of activities is defined with the information when the order is created.
If an M3 order dates from 2015, then it will have the group of activities that was associated with the order at that time.
However if there is a recent order for the same Material Shipto and the Profit center has been changed, then the group of activities may be different from that of the M3 order as it will be based on the new changes.
The concatenation of these flows (SO + M3) gives us 2 different Group of activities for the same Material / shipto.

DYS_BW_MATERIAL.csvC_MATPNT2 (Look up C_TECPCTR) for Material without Sales Order
DBSDSO11 (Look up C_TECPCTR / C_TECHBA) for material with Sales Order
DYS_BW_STDC.csvDBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_STGBU.csvDBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_SH_GI.csvDBSDSO14 (Look up from DBSDSO11)
DYS_BW_SH_DELDAT.csvDBSDSO14 (Look up from DBSDSO11)
DYS_BW_DH_GI.csvDBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_DH_DELDAT.csvDBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_MSS.csvDBSDSO11 (Look up C_TECPCTR / C_TECHBA)
+ DBSDSO14 (Look up from DBSDSO11 )
DYS_BW_OOB_DELDAT.csvDBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_OOB_GI.csvDBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_OOB_CUSTDELDAT.csvDBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_OOB_CUSTGIDAT.csvDBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_M3_PARTNER_DATA.csvDBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_M3_SD_DATA.csvDBSDSO11 (Look up from C_TECPCTR / C_TECHBA)


  • DSO DBSDSO11 - SO Global: Sales Document Item Data (Solvay).

  • DSO DBSDSO14 - SO Global: Deliveries (Solvay).

  • Master Data C_TECHBA - Technical Business Area

  • Master Data C_TECPCTR - Technical Profit Center









  • No labels