Data, Analytics & AI Platform

Page tree


You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

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)


InfoObject & Fields

Object Type

Name

Technical Name

is Field

Characteristics

Country Key

LAND1

X


Postal code

PSTLZ

X


City

ORT01

X


District

ORT02

X


Region

REGIO

X


Region2

REGIO2

X


P.O. Box Postal Code

PSTL2

X


PO box

PFACH

X


Street

STRAS

X


Street

STRS2

X


PO Box City

PFORT

X


Creation date

ZZRDC

X


Validity beg. date

ZZRDDV

X


Modification date

ZZRDM

X


Validity end. date

ZZRDFV

X


Userid

ZZRWHO

X


Address Status

C_AD_STAT



Geo Location Latitude

ZLATITUDE

X


Geo Location Longitude

ZLONGITUDE

X


 PRS Company code

C_COMPPRS



 Entreprise PRS

C_ENTRP



 Address Code

C_ZZADRR



Receives data from:

Object Type

Name

Technical Name

Transformation


 RSDS ZZRADRV PRS_020 -> ADSO APMD009


0TI679PSWJABCLHU4H502MJLP48F97S8


 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 On14.11.2024 19:13:03
Last Changed ByNATT9626

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

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 On05.11.2024 13:43:14
Last Changed ByNATT9626


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

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 On05.11.2024 13:42:48
Last Changed ByNATT9626


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

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 On05.11.2024 13:43:14
Last Changed ByNATT9626


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

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 On14.11.2024 19:13:32
Last Changed ByNATT9626


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

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 On14.11.2024 19:13:32
Last Changed ByNATT9626


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

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 On14.11.2024 19:13:08
Last Changed ByNATT9626


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

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 On14.11.2024 19:13:10
Last Changed ByNATT9626


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

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 On14.11.2024 19:13:32
Last Changed ByNATT9626


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


Powered by Atlassian Confluence and Brikit Theme Press