Data, Analytics & AI Platform

Page tree


Versions Compared

Old Version 10

changes.mady.by.user NATTATH-ext, Jayaram

Saved on

compared with

New Version Current

changes.mady.by.user NATTATH-ext, Jayaram

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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>

Data is extracted from the PRS system (PF1_050) using generic DataSources based on View/Table directly in to ADSOs to have master data information related with Companies, Enterprise, Sites, Establishments, Address, Headcount, Shareholder and Management organization. Minimal transformations are applied, primarily one-to-one mappings with lookups on text data and determination of key components like PRS and SAP companies. for enrichment (e.g., status and update type descriptions). The transformed data is loaded into Advanced Data Store Objects (ADSOs). Reporting is enabled through queries on CompositeProvider - CPPRS01, with text lookups managed via InfoObjects containing descriptive data.

Data Flow

Image Added

Additionally, there are text data that is being looked in corresponding transformations 

APMD005 (PRS Site texts) , used in Image Added RSDS ZZRSITEV PRS_020 -> ADSO APMD004

APMD007 (PRS Enterprise texts) , used in Image Added RSDS ZZRENTR PRS_020 -> ADSO APMD008

APMD010 (PRS Establishment texts) , used in Image Added RSDS DTS_ZZRETAB_0001 PRS_020 -> ADSO APMD011

APMD012 (PRS Shareholder texts) , used in Image Added RSDS ZZRACT PRS_020 -> ADSO APMD013

Roles

New authorization role - ZP2_RCS_MD_A02 , to be assigned to users to have access to queries on CPPRS01

New Menu role - ZR_RCS_CA_M86 , contains the PRS  workbook and queries 

Image Added

Image Added



Corporate PRS Master data workbook

WorkbookSheet NameQuery NameQuery Technical Name

BW_WBK_CPPRS_0001

Company Code
Image Added Company Code PRS Master data (Core Query)
BW_QRY_CPPRS01_0003

Headcount
Image Added Headcount PRS Master data (Core Query)
BW_QRY_CPPRS01_0002

ENTR
Image Added Enterprise PRS Master data (Core Query)
BW_QRY_CPPRS01_0004

SITE
Image Added Site PRS Master data (Core Query)
BW_QRY_CPPRS01_0001

Shareholder
Image Added Shareholder PRS Master data (Core Query)
BW_QRY_CPPRS01_0007

Management Organization
Image Added Management Organization PRS Master data (Core Query)
BW_QRY_CPPRS01_0009

ADDR
Image Added Address PRS Master data (Core Query)
BW_QRY_CPPRS01_0006

ETAB
Image Added Establishment PRS Master data (Core Query)
BW_QRY_CPPRS01_0005

Statistics of Enterprise
Image Added Statistics of Enterprise PRS Master data (Core Query)
BW_QRY_CPPRS01_0008



Rules for determination of PRS and SAP company


PRS COMPANY - It is based on the enterprise information in PRS.

We have a possibility to maintain a global filter variable to assign enterprises to PRS companies where the assignment does not exists in PRS, see section "Procedures" for more information.


SELECT /bic/c_rule /bic/c_low
      FROM /bic/pc_glbfilt
      INTO TABLE it_c_glbfilt_prs
     WHERE /bic/c_stream = 'PRS_ECOMP' AND
           /bic/c_active = 'Y'         AND
           objvers       = 'A'.

Select /BIC/C_COMPPRS /BIC/C_ENTRP from /BIC/AAPMD0032 INTO TABLE
IT_COMPPRS
  FOR ALL ENTRIES IN RESULT_PACKAGE[] WHERE /BIC/C_ENTRP =
  RESULT_PACKAGE-/BIC/C_ENTRP.

 READ TABLE IT_COMPPRS INTO WA_COMPPRS WITH TABLE KEY
    C_ENTRP = <result_fields>-/BIC/C_ENTRP.
    IF SY-SUBRC = 0.
      <result_fields>-/BIC/C_COMPPRS = WA_COMPPRS-C_COMPPRS.
    ELSE.
      READ TABLE it_c_glbfilt_prs INTO WA_c_glbfilt_PRS WITH TABLE KEY
      /BIC/C_RULE = <result_fields>-/BIC/C_ENTRP.
      IF SY-SUBRC = 0.
       <result_fields>-/BIC/C_COMPPRS = WA_c_glbfilt_PRS-/BIC/C_LOW.
     ENDIF.
    ENDIF.


SAP CODE - It is based on the PRS company and landscape information, read on C_COMPPRS.

Select /BIC/C_COMPPRS /BIC/C_COMPCDE /BIC/C_LANDSCP from /BIC/PC_COMPCDE
INTO TABLE IT_COMPCDE
   FOR ALL ENTRIES IN RESULT_PACKAGE[] WHERE
  /BIC/C_COMPPRS = RESULT_PACKAGE-/BIC/C_COMPPRS AND
  /BIC/C_LANDSCP = RESULT_PACKAGE-LANDSCAPE AND
  OBJVERS = 'A'.

READ TABLE IT_COMPCDE INTO wa_compcde WITH TABLE KEY
    C_COMPPRS = <result_fields>-/BIC/C_COMPPRS
    C_LANDSCP = <result_fields>-LANDSCAPE.
      IF SY-SUBRC = 0.
        <result_fields>-BUKRS = wa_compcde-C_COMPCDE.




ADSO Technical information

Image Modified DataStore Object (advanced): PRS Company master data


InfoObject & Fields

Object Type

Name

Technical Name

is Field

Characteristics

Image Modified PRS Company code

C_COMPPRS



Image Modified Valid To

0VALIDTO



Valid From

DATAB

X


Image Modified 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

Image Modified RSDS ZZF_T001_MGT PRS_020 -> ADSO APMD003

09UQE2ICWJVO4HH8V7GMCRK3ANYFJ6TA


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


InfoObject & Fields

Object Type

Name

Technical Name

is Field

Characteristics

Image Modified PRS Company code

C_COMPPRS



Image Modified Site Code

C_ZZRCSIT



Image Modified 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

XValidity end. dateZZRDFVXUseridZZRWHOX
Image Removed Site status
C_ST_STAT
Image Removed Site update type
C_ST_UPD

X


Validity end. date

ZZRDFV

X


Userid

ZZRWHO

X


Image Added Site status

C_ST_STAT



Image Added 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

Image Added RSDS ZZRSITEV PRS_020 -> ADSO APMD004

0BEM2IWS9V07RHPFQDKT6DOC5455VIAR

Data Transfer Process

Image Added ZZRSITEV / PRS_020 -> APMD004

DTP_04B9BB0HZDMRFJT0PRXLVT5YQ


Image Added DataStore Object (advanced): PRS Headcount of Enterprise APMD006



InfoObject & Fields

Object Type

Name

Technical Name

is Field

Characteristics

Image Added Entreprise PRS

C_ENTRP



Image Added PRS Company code

C_COMPPRS


Key Figures

Image Added Headcount

C_REFF


Time Characteristics

Image Added Calendar Year

0CALYEAR

Site medium nameZZRLMSITEXSite nameZZRLLSITEXCountry codeZZRCPAYSAXSAP-R3 EuroZZRCSITR3X




Receives data from:

Object Type

Name

Technical Name

Transformation

Image Removed RSDS ZZRSITEV PRS_020 -> ADSO APMD004
0BEM2IWS9V07RHPFQDKT6DOC5455VIARData Transfer ProcessImage Removed ZZRSITEV /

Image Added RSDS ZZREENT PRS_020 ->

APMD004		DTP_04B9BB0HZDMRFJT0PRXLVT5YQ

...

ADSO APMD006

09T6XDZBZ3N13WOMKHEY8O82O2DSJIOC


Image Added DataStore Object (advanced): PRS

...

Enterprise

...

(APMD008)


InfoObject & Fields

Object Type

Name

Technical Name

is Field

Characteristics

Image Removed Entreprise PRS
C_ENTRP
Image Removed PRS Company code
C_COMPPRSKey Figures
Image Removed Headcount
C_REFFTime Characteristics
Image Removed Calendar Year
0CALYEAR
Receives data from:
Object TypeNameTechnical Name
Transformation
Image Removed RSDS ZZREENT PRS_020 -> ADSO APMD006
09T6XDZBZ3N13WOMKHEY8O82O2DSJIOC

Image Removed DataStore Object (advanced): PRS Enterprise (APMD008)

...

Image Removed PRS Company code

...

Image Removed Entreprise PRS

...

Image Removed Enterprise Update Type

...

Image Removed Enterprise Status

...

Image Removed Enterprise Activity Type

...

Image Removed Enterprise type

...

Image Removed Company Integration Rate

...

Image Removed Company Consol rate

...

Receives data from:
Object TypeNameTechnical Name
Transformation
Image Removed RSDS ZZRENTR PRS_020 -> ADSO APMD008
06Y33LQ3YKNJ8653GPBF1ISJCBRUBJM0

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

...

Image Added PRS Company code

C_COMPPRS



Image Added 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


Image Added Enterprise Update Type

C_EN_UPD



Image Added Enterprise Status

C_EN_STAT



Image Added Enterprise Activity Type

C_RSGACT



Image Added 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

Image Added Company Integration Rate

K_INTRAT



Image Added 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

Image Added RSDS ZZRENTR PRS_020 -> ADSO APMD008

06Y33LQ3YKNJ8653GPBF1ISJCBRUBJM0



Image Added 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


Image Added RSDS ZZRADRV PRS_020 -> ADSO APMD009


0TI679PSWJABCLHU4H502MJLP48F97S8


Image Added DataStore Object (advanced): PRS Establishment (APMD011)



InfoObject & Fields

Object Type

Name

Technical Name

is Field

Characteristics

Image Added PRS Company code

C_COMPPRS



Image Added Entreprise PRS

C_ENTRP



Image Added Establishment code

C_ZZRETAB



Comment

ZZRCOMETAB

X


Remark

ZZRREMETAB

X


Data administration

ZZRADMETAB

X


Image Added Establishment Status

C_ET_STAT



Image Added 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

Image Added RSDS DTS_ZZRETAB_0001 PRS_020 -> ADSO APMD011

0MJBCDRN2NZ6J7GL941BJCTY3SRSLO6Y


Image Added DataStore Object (advanced): PRS Shareholder (APMD013)



InfoObject & Fields

Object Type

Name

Technical Name

is Field

Characteristics

Image Added PRS Company code

C_COMPPRS



Image Added Entreprise PRS

C_ENTRP



Child enterprise code

ZZRCENTRF

X

Key Figures

Image Added Voting rigths percentage

C_CTTAUX



Image Added Solvay % held (4 decimals)

C_DTTAUX


Characteristics

Image Added Shareholder Status

C_SH_STAT

...

Receives data from:
Object TypeNameTechnical Name
Transformation

Image Removed RSDS ZZRADRV PRS_020 -> ADSO APMD009

0TI679PSWJABCLHU4H502MJLP48F97S8

Image Removed DataStore Object (advanced): PRS Establishment (APMD011)

InfoObject & Fields
Object TypeNameTechnical Nameis Field
Characteristics
Image Removed PRS Company code
C_COMPPRS
Image Removed Entreprise PRS
C_ENTRP
Image Removed Establishment code
C_ZZRETABCommentZZRCOMETABXRemarkZZRREMETABXData administrationZZRADMETABX
Image Removed Establishment Status
C_ET_STAT
Image Removed Establishment Update Type
C_ET_UPDSite codeZZRCSITEXEstablishment abbrev.ZZRLCETABXEnterprise name (1)ZZRLL2ENT1XEnterprise name (2)ZZRLL2ENT2XSite nameZZRLL2SITEXChemicalsZZRCHXPlasticsZZRPLXRhodiaZZRTRXOld SectorsZZRPHXAdministrative off.ZZRADMXMain officeZZRPRIXRegistered officeZZRSSOXRepresentation off.ZZRREPXCommercial officeZZRCOMXRegional officeZZRREGXProduct/Packing centerZZRCPRXIndustrial originZZRORIXResearch centreZZRRECXPilot plantZZRPILXWarehouseZZRDEPXR3 establishmentZZRCETAR3XPlantZZRPLANTXEuroventeZZREUROVXAddress codeZZRCADRXTelephone numberZZRPHONEXFax numberZZRFAXXTelex numberZZRTELEXXInternet addressZZREMAILXUpdate messageZZRMSGUPDXUpdated onZZRDUPDXExpiry dateZZRDEXPXAddress book outputZZRADROTXUpdating doneZZRFUPDR3XLast updateZZRDUPDR3XTimeZZRHUPDR3XUpdated byZZRUUPDR3XNo updatingZZRFNAUR3XNot diffusedZZRFNDIFFX



Creation date

ZZRDC

X


Validity beg. date

ZZRDDV

X


Modification date

ZZRDM

X


Validity end. date

ZZRDFV

X


Userid

ZZRWHO

XGPVAO siteZZRCGPVAOX
Receives data from:
Object TypeNameTechnical Name
Transformation
Image Removed RSDS DTS_ZZRETAB_0001 PRS_020 -> ADSO APMD011
0MJBCDRN2NZ6J7GL941BJCTY3SRSLO6Y

Image Removed DataStore Object (advanced): PRS Shareholder (APMD013)

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

Image Added RSDS ZZRACT PRS_020 -> ADSO APMD013

06TU7VZ98RN3INQBT3G8HBM54VMBN5SD


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


InfoObject & Fields

Object Type

Name

Technical Name

is Field

Characteristics

Image Added Entreprise PRS

C_ENTRP



Image Added PRS Company code

C_COMPPRS



Ending date

ZZRDFEX

X


Currency

ZZRCDEV

X

Key Figures

Image Added Net income

C_RNET



Image Added Total of Balance sheet

C_TOTBIL



Image Added Net Sales

C_NETV


Characteristics

Currency multiplier

ZZRCURMUL

InfoObject & Fields
Object TypeNameTechnical Nameis Field
Characteristics
Image Removed PRS Company code
C_COMPPRS
Image Removed Entreprise PRS
C_ENTRPChild enterprise codeZZRCENTRFXKey Figures
Image Removed Voting rigths percentage
C_CTTAUX
Image Removed Solvay % held (4 decimals)
C_DTTAUXCharacteristics
Image Removed Shareholder Status
C_SH_STATCreation dateZZRDCXValidity beg. dateZZRDDVXModification dateZZRDMXValidity end. dateZZRDFVXUseridZZRWHOXCommentZZRCOMACTXData administrationZZRADMACTXShareholder comment 1ZZRCMTACT1XShareholder comment 2ZZRCMTACT2XData admin. commentZZRCMTADM

X



Receives data from:

Object Type

Name

Technical Name

Transformation

Image Removed

Image Added RSDS

ZZRACT

ZZRSENT PRS_020 -> ADSO

APMD013

APMD014

06TU7VZ98RN3INQBT3G8HBM54VMBN5SD

05YI2PFNRRDXRLLXR55IQRRP8UJVF2QJ

...


Image Added DataStore Object (advanced): PRS

...

Management Organization (APMD0015)



InfoObject & Fields

Object Type

Name

Technical Name

is Field

Characteristics

Image Added PRS Company code

C_COMPPRS



Image Added

Image Removed

 Entreprise PRS

C_ENTRP

Image Removed PRS Company code
C_COMPPRSEnding dateZZRDFEXXCurrencyZZRCDEVXKey Figures
Image Removed Net income
C_RNET
Image Removed Total of Balance sheet
C_TOTBIL
Image Removed Net Sales
C_NETV
CharacteristicsCurrency multiplierZZRCURMULX
Receives data from:
Object TypeNameTechnical Name
Transformation
Image Removed RSDS ZZRSENT PRS_020 -> ADSO APMD014
05YI2PFNRRDXRLLXR55IQRRP8UJVF2QJ

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



Image Added Management organization type

C_TORGD



Image Added 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

Image Added RSDS ZZRORG PRS_020 -> ADSO APMD015

0Q1GOO3LRMIUQQ6VDKN85AG1HPYJ6X83

Query Technical information


Receives data from

 
 

Image Added 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
Image Added Authorization Scope (Selection option)
V_C_AUTHMA_0004

Image Added PRS Company code (Selection, option, Optional)
V_COMPPRS_0005
CompositeProvider
Image Added Corporate PRS Master data
CPPRS01
Relays data to
InfoObject & Fields
Object TypeNameTechnical Nameis Field
Characteristics
Image Removed PRS Company code
C_COMPPRS
Image Removed Entreprise PRS
C_ENTRP
Image Removed Management organization type
C_TORGD
Image Removed Management Organization Status
C_MO_STATOrderZZRCLODXTotal mandatesZZRTOTMDXCreation dateZZRDCXValidity beg. dateZZRDDVXModification dateZZRDMXValidity end. dateZZRDFVXUseridZZRWHOX
:
Object TypeNameTechnical Name
Transformation
Image Removed RSDS ZZRORG PRS_020 -> ADSO APMD015
0Q1GOO3LRMIUQQ6VDKN85AG1HPYJ6X83

Query Technical information

Role
Image Added Corporate PRS Data
ZR_RCS_CA_M86
Analysis Office Excel Workbook
Image Added Corporate PRS Master Data
BW_WBK_CPRS_0001


 

 Image Added Query: Headcount
  Image Removed Query: Site
PRS Master data (Core Query)

Technical Name:BW_QRY_CPPRS01_
0001
0002
Description (Short):
Site
Headcount PRS Master
data
Description (Long):
Site
Headcount PRS Master data (Core Query)
Object Version:Active Version
Last Changed On
14
05.11.2024
19
13:
13
43:
03
14
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
PRS Company code
Columns
Key Figures
- Headcount
- Headcount
Rows
Entreprise PRS
Calendar Year
Headcount
Site
PRS Master data (Core Query)
BW_QRY_CPPRS01_
0001
0002



Required Objects
Object TypeNameTechnical Name
Variable
Image Removed Authorization Scope
Image Added PRS Company code (Selection, option, Optional)
V_
C
COMPPRS_
AUTHMA_0004Image Removed PRS Company code
0005

Image Added Authorization Scope (Selection
,
option
, Optional
)
V_C_
COMPPRS
AUTHMA_
0005
0004
CompositeProvider
Image Removed
Image Added Corporate PRS Master data
CPPRS01
Relays data to:
Object TypeNameTechnical Name
Role
Image Removed
Image Added Corporate PRS Data
ZR_RCS_CA_M86
Analysis Office Excel Workbook
Image Removed
Image Added Corporate PRS Master Data
BW_WBK_CPRS_0001



 

 
Image Removed
Image Added Query:
Headcount
Company Code PRS Master data (Core Query)
Top of Page

Technical Name:BW_QRY_CPPRS01_
0002
0003
Description (Short):
Headcount
Company Code PRS
Master
Mas
Description (Long):
Headcount
Company Code PRS Master data (Core Query)
Object Version:Active Version
Last Changed On05.11.2024 13:
43
42:
14
48
Last Changed ByNATT9626


Free Characteristics
Columns
Rows
PRS Company code
ColumnsKey Figures- Headcount- Headcount
Country key
SAP Company Code
Company
Consolidation Method
Company Code
RowsEntreprise PRSCalendar YearHeadcount
PRS Master data (Core Query)
BW_QRY_CPPRS01_
0002
0003



Required Objects
Object TypeNameTechnical Name
Variable
Image Removed
Image Added PRS Company code (Selection, option, Optional)
V_COMPPRS_0005
Image Removed

Image Added Authorization Scope (Selection option)
V_C_AUTHMA_0004
CompositeProvider
Image Removed
Image Added Corporate PRS Master data
CPPRS01
Relays data to:
Object TypeNameTechnical Name
Role
Image Removed
Image Added Corporate PRS Data
ZR_RCS_CA_M86
Analysis Office Excel Workbook
Image Removed
Image Added Corporate PRS Master Data
BW_WBK_CPRS_0001



 

 
Image Removed
Image Added Query:
Company Code
Enterprise PRS Master data (Core Query)
Top of Page

Technical Name:BW_QRY_CPPRS01_
0003
0004
Description (Short):
Company Code
Enterprise PRS
Mas
Maste
Description (Long):
Company Code
Enterprise PRS Master data (Core Query)
Object Version:Active Version
Last Changed On05.11.2024 13:
42
43:
48
14
Last Changed By
NATT9626Free CharacteristicsColumnsRowsPRS Company codeCountry keySAP Company CodeCompanyConsolidation MethodCompany Code PRS Master data (Core Query)BW_QRY_CPPRS01_0003Required ObjectsObject TypeNameTechnical NameVariable
Image Removed PRS Company code (Selection, option, Optional)
V_COMPPRS_0005
Image Removed Authorization Scope (Selection option)
V_C_AUTHMA_0004CompositeProvider
Image Removed Corporate PRS Master data
CPPRS01
Relays data to:
Object TypeNameTechnical Name
Role
Image Removed Corporate PRS Data
ZR_RCS_CA_M86
Analysis Office Excel Workbook
Image Removed Corporate PRS Master Data
BW_WBK_CPRS_0001
 
 Image Removed Query: Enterprise PRS Master data (Core Query)
Top of PageTechnical Name:BW_QRY_CPPRS01_0004Description (Short):Enterprise PRS Maste
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
Description (Long):
Enterprise PRS Master data (Core Query)
Object Version:Active VersionLast Changed On05.11.2024 13:43:14Last Changed ByNATT9626Free CharacteristicsPRS Company codeColumnsKey Figures- Solvay % stake- Consolidation rateRowsEntreprise PRSEnterprise StatusEnterprise abbrev.Ent. medium nameCountry codeMother enterprise codeEnterprise standard nameEnterprise name (2)Ent. special name 3Ent. special name 4Enterprise typeGroup codeConsolidation typeCustomerVendorAgentCarrierForwarding agentManag. body memberOperational PerimeterEuropean VAT numberLeading enterpriseOrganization UnitUpdating doneLast updateTimeUpdated byNo updatingNot diffusedCurrencyCreation dateValidity beg. dateModification dateValidity end. dateCommentComment on OMActivity descriptionHistoricData administrationConso messageEnterprise ActivityEnterprise Update TyExpiry dateUpdated onUpdate messageUseridEnterprise PRS Master data (Core Query)BW_QRY_CPPRS01_0004Required ObjectsObject TypeNameTechnical NameVariable
Image Removed Authorization Scope (Selection option)
V_C_AUTHMA_0004
BW_QRY_CPPRS01_0004



Required Objects
Object TypeNameTechnical Name
Variable
Image Added Authorization Scope (Selection option)
V_C_AUTHMA_0004

Image Added PRS Company code (Selection, option, Optional)
V_COMPPRS_0005
CompositeProvider
Image Added Corporate PRS Master data
CPPRS01
Relays data to:
Object TypeNameTechnical Name
Role
Image Added Corporate PRS Data
ZR_RCS_CA_M86
Analysis Office Excel Workbook
Image Added Corporate PRS Master Data
BW_WBK_CPRS_0001



 

Image Removed PRS Company code (Selection, option, Optional)
V_COMPPRS_0005CompositeProvider
Image Removed Corporate PRS Master data
CPPRS01
Relays data to:
Object TypeNameTechnical Name
Role
Image Removed Corporate PRS Data
ZR_RCS_CA_M86
Analysis Office Excel Workbook
Image Removed Corporate PRS Master Data
BW_WBK_CPRS_0001
  Image Removed Query:
 Image Added 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
Technical Name:
Establishment PRS Master data (Core Query)
Top of Page
BW_QRY_CPPRS01_0005



Required Objects
Object TypeNameTechnical Name
Variable
Image Added Authorization Scope (Selection option)
V_C_AUTHMA_0004

Image Added PRS Company code (Selection, option, Optional)
V_COMPPRS_0005
CompositeProvider
Image Added Corporate PRS Master data
CPPRS01
Relays data to:
Object TypeNameTechnical Name
Role
Image Added Corporate PRS Data
ZR_RCS_CA_M86
Analysis Office Excel Workbook
Image Added Corporate PRS Master Data
BW_WBK_CPRS_0001



 

 Image Added 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
Description (Short):Establishment PRS MaDescription (Long):Establishment PRS Master data (Core Query)Object Version:Active VersionLast Changed On14.11.2024 19:13:32Last Changed ByNATT9626Free CharacteristicsPRS Company codeTelephone numberFax numberTelex numberInternet addressColumnsRowsEntreprise PRSEstablishment codeEstablishment StatusSite codeEstablishment abbrev.Enterprise name (1)Enterprise name (2)Site nameSolvaySyensqoEx-RhodiaOut of ScopeAdministrative off.Head QuartersRegistered officeRepresentation off.Commercial officeRegional officeProduct/Packing centerIndustrial originResearch centrePilot plantWarehouseR3 establishmentPlantAddress codeAddress book outputGPVAO siteEstablishment UpdateUpdate messageUpdated onExpiry dateUpdating doneLast updateTimeUpdated byNo updatingNot diffusedCreation dateValidity beg
. date
Modification date
Validity
end. dateUseridCommentRemarkData administrationEurovent
beg. date
Creation date
Address Status
Address
Establishment
PRS Master data (Core Query)
BW_QRY_CPPRS01_
0005
0006



Required Objects
Object TypeNameTechnical Name
Variable
Image Removed
Image Added Authorization Scope (Selection option)
V_C_AUTHMA_0004
Image Removed

Image Added PRS Company code (Selection, option, Optional)
V_COMPPRS_0005
CompositeProvider
Image Removed
Image Added Corporate PRS Master data
CPPRS01
Relays data to:
Object TypeNameTechnical Name
Role
Image Removed
Image Added Corporate PRS Data
ZR_RCS_CA_M86
Analysis Office Excel Workbook
Image Removed
Image Added Corporate PRS Master Data
BW_WBK_CPRS_0001



 

 
Image Removed
Image Added Query:
Address
Shareholder PRS Master data (Core Query)
Top of Page

Technical Name:BW_QRY_CPPRS01_
0006
0007
Description (Short):
Address
Shareholder PRS
Master d
Mast
Description (Long):
Address
Shareholder PRS Master data (Core Query)
Object Version:Active Version
Last Changed On14.11.2024 19:13:
32
08
Last Changed ByNATT9626


Free Characteristics
PRS Company codeEntreprise PRSColumnsRowsAddress CodeCountry KeyPostal codeCityDistrictRegion (Physical Address)Region (Postal Address)P.O. Box Postal CodePO boxStreetStreetPO Box CityGeo Location LatitudeGeo Location LongitudeUserid
PRS Company code
Columns
Key Figures
- Solvay % held (4 dec
- Voting rigths percen
Rows
Mother Entreprise code
Child Enterprise code
Creation date
Validity beg
Validity end
. date
Modification date
Validity
beg
end. date
Creation dateAddress Status
Userid
Shareholder Status
Remediation
Joint Arrangement
Shareholder comment 1
Shareholder comment 2
Data admin. comment
Shareholder
Address
PRS Master data (Core Query)
BW_QRY_CPPRS01_
0006
0007



Required Objects
Object TypeNameTechnical Name
Variable
Image Removed
Image Added Authorization Scope (Selection option)
V_C_AUTHMA_0004
Image Removed

Image Added PRS Company code (Selection, option, Optional)
V_COMPPRS_0005
CompositeProvider
Image Removed
Image Added Corporate PRS Master data
CPPRS01
Relays data to:
Object TypeNameTechnical Name
Role
Image Removed
Image Added Corporate PRS Data
ZR_RCS_CA_M86
Analysis Office Excel Workbook
Image Removed
Image Added Corporate PRS Master Data
BW_WBK_CPRS_0001



 

 
Image Removed
Image Added Query:
Shareholder
Statistics of Enterprise PRS Master data (Core Query)
Top of Page

Technical Name:BW_QRY_CPPRS01_
0007
0008
Description (Short):
Shareholder PRS Mast
Statistics of Enterp
Description (Long):
Shareholder
Statistics of Enterprise PRS Master data (Core Query)
Object Version:Active Version
Last Changed On14.11.2024 19:13:
08
10
Last Changed ByNATT9626


Free Characteristics
PRS Company
codeColumnsKey Figures- Solvay % held (4 dec- Voting rigths percenRowsMother Entreprise codeChild Enterprise codeCreation dateValidity beg. dateModification dateValidity end. dateUseridShareholder StatusRemediationJoint ArrangementShareholder comment 1Shareholder comment 2Data admin. comment
code
Columns
Key Figures
- Net Sales
- Total of Balance she
- Net income
Rows
Entreprise PRS
Ending date
Currency
Currency multiplier
Statistics of Enterprise
Shareholder
PRS Master data (Core Query)
BW_QRY_CPPRS01_
0007
0008



Required Objects
Object TypeNameTechnical Name
Variable
Image Removed Authorization Scope (Selection option)
V_C_AUTHMA_0004
Variable
Image Added
Image Removed
 PRS Company code (Selection, option, Optional)
V_COMPPRS_0005

Image Added Authorization Scope (Selection option)
V_C_AUTHMA_0004
CompositeProvider
Image Removed
Image Added Corporate PRS Master data
CPPRS01
Relays data to:
Object TypeNameTechnical Name
Role
Image Removed
Image Added Corporate PRS Data
ZR_RCS_CA_M86
Analysis Office Excel Workbook
Image Removed
Image Added Corporate PRS Master Data
BW_WBK_CPRS_0001



 

 
Image Removed Query: Statistics of Enterprise PRS Master data (Core Query)Top of PageTechnical Name:BW_QRY_CPPRS01_0008Description (Short):Statistics of EnterpDescription (Long):Statistics of Enterprise
Image Added Query: Management Organization PRS Master data (Core Query)
Object Version

Technical Name:
Active VersionLast Changed On14.11.2024 19:13:10Last Changed ByNATT9626Free CharacteristicsPRS Company codeColumnsKey Figures- Net Sales- Total of Balance she- Net income
BW_QRY_CPPRS01_0009
Description (Short):Management Organizat
Description (Long):Management Organization
RowsEntreprise PRSEnding dateCurrencyCurrency multiplierStatistics of Enterprise
PRS Master data (Core Query)
BW_QRY_CPPRS01_0008Required ObjectsObject TypeNameTechnical NameVariable
Image Removed PRS Company code (Selection, option, Optional)
V_COMPPRS_0005
Image Removed Authorization Scope (Selection option)
V_C_AUTHMA_0004CompositeProvider
Image Removed Corporate PRS Master data
CPPRS01
Relays data to:
Object TypeNameTechnical Name
Role
Image Removed Corporate PRS Data
ZR_RCS_CA_M86
Analysis Office Excel Workbook
Image Removed Corporate PRS Master Data
BW_WBK_CPRS_0001
  Image Removed 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
Technical Name:
Management Organization PRS Master data (Core Query)
Top of Page
BW_QRY_CPPRS01_0009
Description (Short):Management OrganizatDescription (Long):Management Organization PRS Master data (Core Query)Object Version:Active VersionLast Changed On14.11.2024 19:13:32Last Changed ByNATT9626Free CharacteristicsPRS Company codeColumnsRowsEntreprise PRSManagement organization typeMgmnt Org StatusTotal mandatesOrderUseridValidity end. dateModification dateValidity beg. dateCreation dateManagement Organization PRS Master data (Core Query)BW_QRY_CPPRS01_0009Required ObjectsObject TypeNameTechnical NameVariable
Image Removed PRS Company code (Selection, option, Optional)
V_COMPPRS_0005
Image Removed Authorization Scope (Selection option)
V_C_AUTHMA_0004CompositeProvider
Image Removed Corporate PRS Master data
CPPRS01
Relays data to:
Object TypeNameTechnical Name
Role
Image Removed Corporate PRS Data
ZR_RCS_CA_M86
Analysis Office Excel Workbook
Image Removed 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



Required Objects
Object TypeNameTechnical Name
Variable
Image Added PRS Company code (Selection, option, Optional)
V_COMPPRS_0005

Image Added Authorization Scope (Selection option)
V_C_AUTHMA_0004
CompositeProvider
Image Added Corporate PRS Master data
CPPRS01
Relays data to:
Object TypeNameTechnical Name
Role
Image Added Corporate PRS Data
ZR_RCS_CA_M86
Analysis Office Excel Workbook
Image Added Corporate PRS Master Data
BW_WBK_CPRS_0001


Procedures

For case in the table -"ZZF_T001_MGT" (PF1_050)  where the Enterprise is not assigned to a PRS company or no entries for the enterprise we can force the assignment in BW, using global filter.

Global filter attributes:

C_STREAM = PRS_ECOMP

C_ACTIVE  = Y

C_RULE = 'Enterprise to be assigned"

C_LOW = "Corresponding PRS"

Example:

Image Added


Scheduling

A new process chain has been created for loading the required infoproviders for Corporate PRS Master data = "PC_PRSMD_01" , this is added in to the daily master data chain - "ZPC_MD_ATTR_RCS"

Frequency - Daily, except Saturdays and public holidays

Time - 04:30 WBP system time.<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 (eeg. g. check the overall status, data quality controls, check 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 eg. error codes, description and respective resolution, when to alert users)>

Known Bugs

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

Roadmap

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



Powered by Atlassian Confluence and Brikit Theme Press