Overview

When a company that operates in one of Syensqo main SAP ERP systems is sold or liquidated, Finance team updates specific tables linked to the Company Code maintenance in SAP PRS system PF2_050, with information acting the Company exit.

Refer to this procedure for more information : ZZF_T001_MGT_V - Company codes table maintenance

One of these tables is the ZZF_T001_MGT which is used as a source to BW, to update the authorization scope accordingly into the PRS Company Code master data C_COMPPRS, and other dependent master data.

Refer to BW - Authorization scope management

In certain M&A projects, where it has been agreed with buyers that Syensqo will provide a Transitional Service Agreement (TSA) for some reporting tools, it is necessary to keep in BW an authorization scope and consolidation method allowing this Company to be displayed properly in reporting.

Therefore, the information from table ZZF_T001_MGT must not be used in BW to set the Company as sold, preventing any display in reporting.

A new table ZZF_BW_TSA is maintained by Finance in SAP PRS system PF2_050, with the Company information to use to overwrite authorization scope and consolidation method in BW, as long as the Company data must be displayed in reporting.

Once the TSA period is over, the Company information is deleted from table ZZF_BW_TSA, and the Company exit information is taken again from table ZZF_T001_MGT.

Refer to this procedure for more information : 

This page is explaining how this table is used in the BW data flow, and what is the procedure to follow for any new carve-out.


Contacts 



BW data flow 

The BW model is enhanced as below to consider the information coming from table ZZF_BW_TSA in SAP PRS system PF2_050.


How to update the BW scope 

There are several steps to process to update the relevant Master Data used to set authorization scope and consolidation method in BW.

1- Table  ZZF_BW_TSA

Check in SAP PRS system PF2_050 that table ZZF_BW_TSA is properly populated with the Company information to push in BW.

This information will overwrite the data coming from table ZZF_T001_MGT.


ClientSAP system on which
the company is running		Scope CodeCompany CodeConsolidation methodConsolidation %BFC ConsoCredit control area
MANDTSNDPRNSCOPEBUKRSMETHODCONTROLCONSOKKBER
050WP2_40021640210100X0143
050WP2_40021640310100X0143
050WP2_40021641610100X0143
050WP2_40021781010100X0143

2- Update Master Data C_T001MGT 

The content of table ZZF_BW_TSA must be populated into the Master Data C_T001MGT (Sold Company setting) in BW.

This master data C_T001MGT is not used in any transactional structure in BW, which means that the content can be fully replaced without impact.


  1. Delete the content of Master Data C_T001MGT
  2. Execute the Full DTP to extract data from Datasource DTS_ZZF_BW_TSA into master data C_T001MGT and activate it.
  3. Check master data C_T001MGT content.


3- Load relevant Master Data 

Now the sequence of reloading below can be processed to take the master data C_T001MGT information into account.


  1. Load Master Data C_COMPPRS from Datasource ZZR_0COMP_CODE_ATTR_PRS (IP + DTP) + Activate
  2. Load Master Data C_COMPCDE from Datasource ZZR_0COMP_CODE_ATTR (IP + DTP) + Activate
  3. Load Master Data C_COMPCDE from Datasource DTS_0COMP_CODE_ATTR (IP + DTP) + Activate
  4. Load Master Data C_COMPCDE from Datasource C_COMPCDE + Activate
  5. Load Master Data 0COMP_CODE from Datasource DTS_0COMP_CODE_ATTR + Activate
  6. Load Master Data 0COMP_CODE from Datasource 0COMP_CODE + Activate
  7. Load Master Data 0PLANT from Datasource 0PLANT + Activate
  8. Load Master Data C_PLANT from Datasource C_PLANT + Activate
  9. Load Master Data C_CST_CA2 from Datasource 0FI_AR_9 (IP with dynamic Credit Area + DTP) + Activate
  10. Load Master Data C_CST_CA2 from Datasource 0CUSTOMER_TEXT (IP + DTP)
  11. Load Master Data C_CUSTPRS from Datasource 0CUSTOMER_ATTR (IP + DTP) + Activate
  12. Load Master Data C_CUSTID from Datasource 0CUSTOMER_ATTR (IP + DTP) from both source systems + Activate

Authorization Analysis & Role


Main SCO Authorization analysis    ZP2SCOP00

Main SCO Role    ZP2_SCO_P00


BW Query updates