Versions Compared

Old Version 9

changes.mady.by.user Ismail AMMOR

Saved on

compared with

New Version Current

changes.mady.by.user GIRAUD-ext, Mickael

Saved on

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


The ERP Group of Activities of the (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 order.This will also allow us to obtain, the ERP Global Business Unit, the ERP Group of activities, the BFC Global Business Unit, the BFC Group of Activities, the BFC Activity 1 ..sales order.

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

The Sub Activity is determined in the two 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).


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

Image RemovedImage Added


_____________________________________________________________________________________________________________________________________

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 :

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


Image RemovedImage Added


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

Image RemovedImage Added


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 the master data Technical Profit Center . so 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 RemovedImage Added


The profit center must be filled to be able to use the master data 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 master data masterdata as in Case 1.

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

...

Technical Profit Center : C_TECPCTR

Image RemovedImage Added


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" master data masterdata is used as a last resort based on the profit center, the plant and the company code.

...

Sub Activity 2 - C_SUBACT2

Image RemovedImage Added


2 ) List of DynaSys interfaces using the Group of Activities


InterfaceSource of Group of Activities 
Rule 
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.csv
DBSDSO11
DBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_DH_DELDAT.csv
DBSDSO11
DBSDSO11 (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.csv
DBSDSO11
DBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_OOB_GI.csv
DBSDSO11
DBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_OOB_CUSTDELDAT.csv
DBSDSO11
DBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_OOB_CUSTGIDAT.csv
DBSDSO11
DBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_M3_PARTNER_DATA.csv
DBSDSO11
DBSDSO11 (Look up from C_TECPCTR / C_TECHBA)
DYS_BW_M3_SD_DATA.csv
DBSDSO11
DBSDSO11 (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

...