Versions Compared

Key

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

(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) 


Table of Contents

General presentation

Source 


Le The ERP Group of Activites des sales order est déterminé depuis la masterdata Activities (C_PFCTR2) on sales order flow is determined from the "Sub Activity 2, plusieurs etapes sont necessaires afin de determiner le bon business Area associé à la commande.  

Cela va nous permettre d'obtenir par la suite, la ERP Global Business Unit , la ERP Group of activities, la BFC Global Business Unit , la BFC Group of Activites , la BFC Activity 1 ...  

SCHEMA 

SCHEMA

SCHEMA

" 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 Les sources utilisées pour obtenir le Sub Activity sont la masterdata "Technical Profit Center - C_TECPCTR" et la master data and the "Technical Business Area - C_TECHBA" master data.

La sub Activity est déterminé dans les deux sources principales ci-dessous, ils sont maintenu par l’équipe Global Sales : 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).
  • DSO DBSDSO14 - SO Global: Deliveries (Solvay).

Pour la masterdata Technical Profit Center, nous avons besoin des informations ci-dessous :

SCHEMA

SCHEMA

SCHEMA


Pour la masterdata For the Technical Profit Center and Technical Business Area, nous avons besoin des informations ci-dessous :

SCHEMA

SCHEMA

SCHEMA

masterdata, we need the information below:

Image Added


_____________________________________________________________________________________________________________________________________

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


Explanation of the rule applied by Global sales in the Explication de la règle appliquée par Global sales dans le 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   Technical Profit Center Si les informations de la commande nous permettent d'obtenir un Sub Activity non null, alors la master data Technical Profit Center  est utilisée pour determiner le Sub Activity.

Exemple Example :Material : 198898

Company Code5726
Plant

...

5019

Company Code : 5726

Business Area

...

9CI0
Controlling Area

...

CHEF
Profit Center

...

FCHICA1XU1
=> Sub Activity 9CH0


Image Added


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

Image Added :  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

Image Added


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.

Image Added


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

Image Added


Sub Activity 2 - C_SUBACT2

Image Added


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

Image Added


Technical Business Area - C_TECHBA

Image Added


Sub Activity 2 - C_SUBACT2

Image Added


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

...