Architecture

<High-level architecture schema illustrating the components and their interactions>

Data Flow

<Describe the Data Flow (e.g. data sources, extraction, transformations, data quality controls, data storage, visualization), Data Model and Data Mapping>

ADSO Technical information

 DataStore Object (advanced): PRS Company master data

InfoObject & Fields
Object Type	Name	Technical Name	is Field
Characteristics	PRS Company code	C_COMPPRS
	Valid To	0VALIDTO
	Valid From	DATAB	X
	Entreprise PRS	C_ENTRP
	SAP Company Code	BUKRS	X
	Consolidation meth.	METHOD	X
	System landscape	LANDSCAPE	X

Receives data from:
Object Type	Name	Technical Name
Transformation	RSDS ZZF_T001_MGT PRS_020 -> ADSO APMD003	09UQE2ICWJVO4HH8V7GMCRK3ANYFJ6TA

 DataStore Object (advanced): PRS Site master data (APMD004)

InfoObject & Fields
Object Type	Name	Technical Name	is Field
Characteristics	PRS Company code	C_COMPPRS
	Site Code	C_ZZRCSIT
	Entreprise PRS	C_ENTRP
	ZZRCMTSITE	ZZRCMTSITE	X
	Other comment	ZZRCOMSITE	X
	Data administration	ZZRADMSITE	X
	Update message	ZZRMSGUPD	X
	Updated on	ZZRDUPD	X
	Expiry date	ZZRDEXP	X
	Creation date	ZZRDC	X
	Validity beg. date	ZZRDDV	X
	Modification date	ZZRDM	X
	Validity end. date	ZZRDFV	X
	Userid	ZZRWHO	X
	Site status	C_ST_STAT
	Site update type	C_ST_UPD
	Site medium name	ZZRLMSITE	X
	Site name	ZZRLLSITE	X
	Country code	ZZRCPAYSA	X
	SAP-R3 Euro	ZZRCSITR3	X

Receives data from:
Object Type	Name	Technical Name
Transformation	RSDS ZZRSITEV PRS_020 -> ADSO APMD004	0BEM2IWS9V07RHPFQDKT6DOC5455VIAR
Data Transfer Process	ZZRSITEV / PRS_020 -> APMD004	DTP_04B9BB0HZDMRFJT0PRXLVT5YQ

 DataStore Object (advanced): PRS Headcount of Enterprise APMD006

InfoObject & Fields
Object Type	Name	Technical Name	is Field
Characteristics	Entreprise PRS	C_ENTRP
	PRS Company code	C_COMPPRS
Key Figures	Headcount	C_REFF
Time Characteristics	Calendar Year	0CALYEAR

Receives data from:
Object Type	Name	Technical Name
Transformation	RSDS ZZREENT PRS_020 -> ADSO APMD006	09T6XDZBZ3N13WOMKHEY8O82O2DSJIOC

 DataStore Object (advanced): PRS Enterprise (APMD008)

InfoObject & Fields
Object Type	Name	Technical Name	is Field
Characteristics	PRS Company code	C_COMPPRS
	Entreprise PRS	C_ENTRP
	Comment	ZZRCMTENTR	X
	Comment on OM	ZZRCOMENTR	X
	Activity description	ZZRDESENTR	X
	Historic	ZZRHISENTR	X
	Data administration	ZZRADMENTR	X
	Conso message	ZZRCONENTR	X
	Enterprise Update Type	C_EN_UPD
	Enterprise Status	C_EN_STAT
	Enterprise Activity Type	C_RSGACT
	Enterprise type	C_RTENTR
	Enterprise abbrev.	ZZRLCENTR	X
	Ent. medium name	ZZRLMENTR	X
	Country code	ZZRCPAYSA	X
	Mother enterprise code	ZZRCENTRP	X
	Enterprise name (1)	ZZRLLENTR1	X
	Enterprise name (2)	ZZRLLENTR2	X
	Ent. special name 3	ZZRLLENTR3	X
	Ent. special name 4	ZZRLLENTR4	X
	Group code	ZZRCGROUP	X
	Consolidation type	ZZRTCONS	X
Key Figures	Company Integration Rate	K_INTRAT
	Company Consol rate	K_CCRATE
Characteristics	Customer	ZZRCLI	X
	Vendor	ZZRFOU	X
	Agent	ZZRAGT	X
	Carrier	ZZRTRP	X
	Forwarding agent	ZZRTRS	X
	Manag. body member	ZZRMORG	X
	Operational Perimeter	ZZREUROV	X
	European VAT number	ZZRTVA	X
	Leading enterprise	ZZRPHARE	X
	Organization Unit	ZZRCUO	X
	Update message	ZZRMSGUPD	X
	Updated on	ZZRDUPD	X
	Expiry date	ZZRDEXP	X
	Updating done	ZZRFUPDR3	X
	Last update	ZZRDUPDR3	X
	Time	ZZRHUPDR3	X
	Updated by	ZZRUUPDR3	X
	No updating	ZZRFNAUR3	X
	Not diffused	ZZRFNDIFF	X
	Currency	ZZRCMONN	X
	Creation date	ZZRDC	X
	Validity beg. date	ZZRDDV	X
	Modification date	ZZRDM	X
	Validity end. date	ZZRDFV	X
	Userid	ZZRWHO	X

Receives data from:
Object Type	Name	Technical Name
Transformation	RSDS ZZRENTR PRS_020 -> ADSO APMD008	06Y33LQ3YKNJ8653GPBF1ISJCBRUBJM0

 DataStore Object (advanced): PRS Address master data (APMD009)

 DataStore Object (advanced): PRS Establishment (APMD011)

InfoObject & Fields
Object Type	Name	Technical Name	is Field
Characteristics	PRS Company code	C_COMPPRS
	Entreprise PRS	C_ENTRP
	Establishment code	C_ZZRETAB
	Comment	ZZRCOMETAB	X
	Remark	ZZRREMETAB	X
	Data administration	ZZRADMETAB	X
	Establishment Status	C_ET_STAT
	Establishment Update Type	C_ET_UPD
	Site code	ZZRCSITE	X
	Establishment abbrev.	ZZRLCETAB	X
	Enterprise name (1)	ZZRLL2ENT1	X
	Enterprise name (2)	ZZRLL2ENT2	X
	Site name	ZZRLL2SITE	X
	Chemicals	ZZRCH	X
	Plastics	ZZRPL	X
	Rhodia	ZZRTR	X
	Old Sectors	ZZRPH	X
	Administrative off.	ZZRADM	X
	Main office	ZZRPRI	X
	Registered office	ZZRSSO	X
	Representation off.	ZZRREP	X
	Commercial office	ZZRCOM	X
	Regional office	ZZRREG	X
	Product/Packing center	ZZRCPR	X
	Industrial origin	ZZRORI	X
	Research centre	ZZRREC	X
	Pilot plant	ZZRPIL	X
	Warehouse	ZZRDEP	X
	R3 establishment	ZZRCETAR3	X
	Plant	ZZRPLANT	X
	Eurovente	ZZREUROV	X
	Address code	ZZRCADR	X
	Telephone number	ZZRPHONE	X
	Fax number	ZZRFAX	X
	Telex number	ZZRTELEX	X
	Internet address	ZZREMAIL	X
	Update message	ZZRMSGUPD	X
	Updated on	ZZRDUPD	X
	Expiry date	ZZRDEXP	X
	Address book output	ZZRADROT	X
	Updating done	ZZRFUPDR3	X
	Last update	ZZRDUPDR3	X
	Time	ZZRHUPDR3	X
	Updated by	ZZRUUPDR3	X
	No updating	ZZRFNAUR3	X
	Not diffused	ZZRFNDIFF	X
	Creation date	ZZRDC	X
	Validity beg. date	ZZRDDV	X
	Modification date	ZZRDM	X
	Validity end. date	ZZRDFV	X
	Userid	ZZRWHO	X
	GPVAO site	ZZRCGPVAO	X

Receives data from:
Object Type	Name	Technical Name
Transformation	RSDS DTS_ZZRETAB_0001 PRS_020 -> ADSO APMD011	0MJBCDRN2NZ6J7GL941BJCTY3SRSLO6Y

 DataStore Object (advanced): PRS Shareholder (APMD013)

InfoObject & Fields
Object Type	Name	Technical Name	is Field
Characteristics	PRS Company code	C_COMPPRS
	Entreprise PRS	C_ENTRP
	Child enterprise code	ZZRCENTRF	X
Key Figures	Voting rigths percentage	C_CTTAUX
	Solvay % held (4 decimals)	C_DTTAUX
Characteristics	Shareholder Status	C_SH_STAT
	Creation date	ZZRDC	X
	Validity beg. date	ZZRDDV	X
	Modification date	ZZRDM	X
	Validity end. date	ZZRDFV	X
	Userid	ZZRWHO	X
	Comment	ZZRCOMACT	X
	Data administration	ZZRADMACT	X
	Shareholder comment 1	ZZRCMTACT1	X
	Shareholder comment 2	ZZRCMTACT2	X
	Data admin. comment	ZZRCMTADM	X

Receives data from:
Object Type	Name	Technical Name
Transformation	RSDS ZZRACT PRS_020 -> ADSO APMD013	06TU7VZ98RN3INQBT3G8HBM54VMBN5SD

 DataStore Object (advanced): PRS Statistics of Enterprise (APMD014)

InfoObject & Fields
Object Type	Name	Technical Name	is Field
Characteristics	Entreprise PRS	C_ENTRP
	PRS Company code	C_COMPPRS
	Ending date	ZZRDFEX	X
	Currency	ZZRCDEV	X
Key Figures	Net income	C_RNET
	Total of Balance sheet	C_TOTBIL
	Net Sales	C_NETV
Characteristics	Currency multiplier	ZZRCURMUL	X

Receives data from:
Object Type	Name	Technical Name
Transformation	RSDS ZZRSENT PRS_020 -> ADSO APMD014	05YI2PFNRRDXRLLXR55IQRRP8UJVF2QJ

 DataStore Object (advanced): PRS Management Organization (APMD0015)

InfoObject & Fields
Object Type	Name	Technical Name	is Field
Characteristics	PRS Company code	C_COMPPRS
	Entreprise PRS	C_ENTRP
	Management organization type	C_TORGD
	Management Organization Status	C_MO_STAT
	Order	ZZRCLOD	X
	Total mandates	ZZRTOTMD	X
	Creation date	ZZRDC	X
	Validity beg. date	ZZRDDV	X
	Modification date	ZZRDM	X
	Validity end. date	ZZRDFV	X
	Userid	ZZRWHO	X

Receives data from:
Object Type	Name	Technical Name
Transformation	RSDS ZZRORG PRS_020 -> ADSO APMD015	0Q1GOO3LRMIUQQ6VDKN85AG1HPYJ6X83

Query Technical information

Query: Site PRS Master data (Core Query) Technical Name: BW_QRY_CPPRS01_0001 Description (Short): Site PRS Master data Description (Long): Site PRS Master data (Core Query) Object Version: Active Version Last Changed On 14.11.2024 19:13:03 Last Changed By NATT9626 Free Characteristics PRS Company code Entreprise PRS Columns Rows Site Code Site medium name Site name Country code SAP-R3 Euro Site status Site update type Update message Updated on Expiry date Creation date Validity beg. date Modification date Validity end. date Userid Comment Other comment Data administration Site PRS Master data (Core Query) BW_QRY_CPPRS01_0001 Required Objects Object Type Name Technical Name Variable  Authorization Scope (Selection option) V_C_AUTHMA_0004  PRS Company code (Selection, option, Optional) V_COMPPRS_0005 CompositeProvider  Corporate PRS Master data CPPRS01 Relays data to: Object Type Name Technical Name Role  Corporate PRS Data ZR_RCS_CA_M86 Analysis Office Excel Workbook  Corporate PRS Master Data BW_WBK_CPRS_0001

Query: Headcount PRS Master data (Core Query) Top of Page Technical Name: BW_QRY_CPPRS01_0002 Description (Short): Headcount PRS Master Description (Long): Headcount PRS Master data (Core Query) Object Version: Active Version Last Changed On 05.11.2024 13:43:14 Last Changed By NATT9626 Free Characteristics PRS Company code Columns Key Figures - Headcount - Headcount Rows Entreprise PRS Calendar Year Headcount PRS Master data (Core Query) BW_QRY_CPPRS01_0002 Required Objects Object Type Name Technical Name Variable  PRS Company code (Selection, option, Optional) V_COMPPRS_0005  Authorization Scope (Selection option) V_C_AUTHMA_0004 CompositeProvider  Corporate PRS Master data CPPRS01 Relays data to: Object Type Name Technical Name Role  Corporate PRS Data ZR_RCS_CA_M86 Analysis Office Excel Workbook  Corporate PRS Master Data BW_WBK_CPRS_0001

Query: Company Code PRS Master data (Core Query) Top of Page Technical Name: BW_QRY_CPPRS01_0003 Description (Short): Company Code PRS Mas Description (Long): Company Code PRS Master data (Core Query) Object Version: Active Version Last Changed On 05.11.2024 13:42:48 Last Changed By NATT9626 Free Characteristics Columns Rows PRS Company code Country key SAP Company Code Company Consolidation Method Company Code PRS Master data (Core Query) BW_QRY_CPPRS01_0003 Required Objects Object Type Name Technical Name Variable  PRS Company code (Selection, option, Optional) V_COMPPRS_0005  Authorization Scope (Selection option) V_C_AUTHMA_0004 CompositeProvider  Corporate PRS Master data CPPRS01 Relays data to: Object Type Name Technical Name Role  Corporate PRS Data ZR_RCS_CA_M86 Analysis Office Excel Workbook  Corporate PRS Master Data BW_WBK_CPRS_0001

Query: Enterprise PRS Master data (Core Query) Top of Page Technical Name: BW_QRY_CPPRS01_0004 Description (Short): Enterprise PRS Maste Description (Long): Enterprise PRS Master data (Core Query) Object Version: Active Version Last Changed On 05.11.2024 13:43:14 Last Changed By NATT9626 Free Characteristics PRS Company code Columns Key Figures - Solvay % stake - Consolidation rate Rows Entreprise PRS Enterprise Status Enterprise abbrev. Ent. medium name Country code Mother enterprise code Enterprise standard name Enterprise name (2) Ent. special name 3 Ent. special name 4 Enterprise type Group code Consolidation type Customer Vendor Agent Carrier Forwarding agent Manag. body member Operational Perimeter European VAT number Leading enterprise Organization Unit Updating done Last update Time Updated by No updating Not diffused Currency Creation date Validity beg. date Modification date Validity end. date Comment Comment on OM Activity description Historic Data administration Conso message Enterprise Activity Enterprise Update Ty Expiry date Updated on Update message Userid Enterprise PRS Master data (Core Query) BW_QRY_CPPRS01_0004 Required Objects Object Type Name Technical Name Variable  Authorization Scope (Selection option) V_C_AUTHMA_0004  PRS Company code (Selection, option, Optional) V_COMPPRS_0005 CompositeProvider  Corporate PRS Master data CPPRS01 Relays data to: Object Type Name Technical Name Role  Corporate PRS Data ZR_RCS_CA_M86 Analysis Office Excel Workbook  Corporate PRS Master Data BW_WBK_CPRS_0001

Query: Establishment PRS Master data (Core Query) Top of Page Technical Name: BW_QRY_CPPRS01_0005 Description (Short): Establishment PRS Ma Description (Long): Establishment PRS Master data (Core Query) Object Version: Active Version Last Changed On 14.11.2024 19:13:32 Last Changed By NATT9626 Free Characteristics PRS Company code Telephone number Fax number Telex number Internet address Columns Rows Entreprise PRS Establishment code Establishment Status Site code Establishment abbrev. Enterprise name (1) Enterprise name (2) Site name Solvay Syensqo Ex-Rhodia Out of Scope Administrative off. Head Quarters Registered office Representation off. Commercial office Regional office Product/Packing center Industrial origin Research centre Pilot plant Warehouse R3 establishment Plant Address code Address book output GPVAO site Establishment Update Update message Updated on Expiry date Updating done Last update Time Updated by No updating Not diffused Creation date Validity beg. date Modification date Validity end. date Userid Comment Remark Data administration Eurovent Establishment PRS Master data (Core Query) BW_QRY_CPPRS01_0005 Required Objects Object Type Name Technical Name Variable  Authorization Scope (Selection option) V_C_AUTHMA_0004  PRS Company code (Selection, option, Optional) V_COMPPRS_0005 CompositeProvider  Corporate PRS Master data CPPRS01 Relays data to: Object Type Name Technical Name Role  Corporate PRS Data ZR_RCS_CA_M86 Analysis Office Excel Workbook  Corporate PRS Master Data BW_WBK_CPRS_0001

Query: Address PRS Master data (Core Query) Top of Page Technical Name: BW_QRY_CPPRS01_0006 Description (Short): Address PRS Master d Description (Long): Address PRS Master data (Core Query) Object Version: Active Version Last Changed On 14.11.2024 19:13:32 Last Changed By NATT9626 Free Characteristics PRS Company code Entreprise PRS Columns Rows Address Code Country Key Postal code City District Region (Physical Address) Region (Postal Address) P.O. Box Postal Code PO box Street Street PO Box City Geo Location Latitude Geo Location Longitude Userid Validity end. date Modification date Validity beg. date Creation date Address Status Address PRS Master data (Core Query) BW_QRY_CPPRS01_0006 Required Objects Object Type Name Technical Name Variable  Authorization Scope (Selection option) V_C_AUTHMA_0004  PRS Company code (Selection, option, Optional) V_COMPPRS_0005 CompositeProvider  Corporate PRS Master data CPPRS01 Relays data to: Object Type Name Technical Name Role  Corporate PRS Data ZR_RCS_CA_M86 Analysis Office Excel Workbook  Corporate PRS Master Data BW_WBK_CPRS_0001

Query: Shareholder PRS Master data (Core Query) Top of Page Technical Name: BW_QRY_CPPRS01_0007 Description (Short): Shareholder PRS Mast Description (Long): Shareholder PRS Master data (Core Query) Object Version: Active Version Last Changed On 14.11.2024 19:13:08 Last Changed By NATT9626 Free Characteristics PRS Company code Columns Key Figures - Solvay % held (4 dec - Voting rigths percen Rows Mother Entreprise code Child Enterprise code Creation date Validity beg. date Modification date Validity end. date Userid Shareholder Status Remediation Joint Arrangement Shareholder comment 1 Shareholder comment 2 Data admin. comment Shareholder PRS Master data (Core Query) BW_QRY_CPPRS01_0007 Required Objects Object Type Name Technical Name Variable  Authorization Scope (Selection option) V_C_AUTHMA_0004  PRS Company code (Selection, option, Optional) V_COMPPRS_0005 CompositeProvider  Corporate PRS Master data CPPRS01 Relays data to: Object Type Name Technical Name Role  Corporate PRS Data ZR_RCS_CA_M86 Analysis Office Excel Workbook  Corporate PRS Master Data BW_WBK_CPRS_0001

Query: Statistics of Enterprise PRS Master data (Core Query) Top of Page Technical Name: BW_QRY_CPPRS01_0008 Description (Short): Statistics of Enterp Description (Long): Statistics of Enterprise PRS Master data (Core Query) Object Version: Active Version Last Changed On 14.11.2024 19:13:10 Last Changed By NATT9626 Free Characteristics PRS Company code Columns Key Figures - Net Sales - Total of Balance she - Net income Rows Entreprise PRS Ending date Currency Currency multiplier Statistics of Enterprise PRS Master data (Core Query) BW_QRY_CPPRS01_0008 Required Objects Object Type Name Technical Name Variable  PRS Company code (Selection, option, Optional) V_COMPPRS_0005  Authorization Scope (Selection option) V_C_AUTHMA_0004 CompositeProvider  Corporate PRS Master data CPPRS01 Relays data to: Object Type Name Technical Name Role  Corporate PRS Data ZR_RCS_CA_M86 Analysis Office Excel Workbook  Corporate PRS Master Data BW_WBK_CPRS_0001

Query: Management Organization PRS Master data (Core Query) Top of Page Technical Name: BW_QRY_CPPRS01_0009 Description (Short): Management Organizat Description (Long): Management Organization PRS Master data (Core Query) Object Version: Active Version Last Changed On 14.11.2024 19:13:32 Last Changed By NATT9626 Free Characteristics PRS Company code Columns Rows Entreprise PRS Management organization type Mgmnt Org Status Total mandates Order Userid Validity end. date Modification date Validity beg. date Creation date Management Organization PRS Master data (Core Query) BW_QRY_CPPRS01_0009 Required Objects Object Type Name Technical Name Variable  PRS Company code (Selection, option, Optional) V_COMPPRS_0005  Authorization Scope (Selection option) V_C_AUTHMA_0004 CompositeProvider  Corporate PRS Master data CPPRS01 Relays data to: Object Type Name Technical Name Role  Corporate PRS Data ZR_RCS_CA_M86 Analysis Office Excel Workbook  Corporate PRS Master Data BW_WBK_CPRS_0001

Procedures

<Describe the manual procedures that may be needed to operate the application (e.g. start/pause/terminate/restart the app processes, manual data reload, encryption key rotation, renew passwords or other manual activities)>

Scheduling

<Describe the scheduling in place (e.g. existing jobs, trigger time/event based, dependencies)>

Monitoring

<Describe the monitoring checks to confirm the application is performing well (e.g. check the overall status, data quality controls, performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>

Error Handling

<Describe how to handle errors (e.g. common errors and respective resolution, when to alert users)>

Known Bugs

<List the existing bugs, its criticality, workarounds and resolution plan>

Roadmap

<List past & future evolution for the application (including links to MED/FSD/TSD)>