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


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.

...

_____________________________________________________________________________________________________________________________________

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.

...

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.

...

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 0366
PlantMTP
Business Area7360
Controlling AreaCHEF
Profit CenterF6519XXXT2   (From Material Plant)
=> Sub Activity 7650

...

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


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)

...