Document Links
ERP-2921 - Getting issue details... STATUS
Introduction
This document describes the data flow for objects in the technical space.
| Sub-Area | Details | Example KPIs | Comments |
|---|---|---|---|
| Pro - Signavio Process Manager | The Source-to-Contract (S2C) covers all activities involved in identifying suppliers, sourcing goods or services, negotiating terms, and establishing legally binding contracts before purchasing transactions occur. The process typically includes supplier identification and qualification, sourcing events, bid evaluation, negotiations, contract creation, approval, and contract lifecycle management. Once contracts are finalized, they serve as the basis for downstream procurement activities in the Procure-to-Pay (P2P) process, ensuring purchases are made under agreed commercial terms. | Contract Target & Release Values, Take or Pay Values, Contract Compliance & Efficiency |
Jira Request Coverage
The models covered under this DDFS will cater for the requirements raised though the following Jira Requests:
ERP-1107 - Getting issue details... STATUS
Data Flow Diagram
Source System Extractors
Standard extractors do not need to be documented unless extended.
Where custom extractors / extensions are required, reference the FSD for that enhancement.
| Extractor Name | Build Jira Ref For Extension Information |
|---|---|
| Signavio Report | ERP-2408 - Getting issue details... STATUS |
Inbound Layer
Inbound layer objects only need documentation if some field adjustment is made (over and above the standard load date / time and source system stamp).
1TL_TECPRO_SignavioProcessChanges_01
Field XYZ converted to date.
Field ABC converted from BIGINT to...
Harmonisation Layer
Every table will have it's own harmonization view. This only needs to be documented if field adjustments are required. E.g. Conversion of data field / type.
Where actions are performed to improve reusability, e.g. joining header and item tables, details of the join (left outer, which is left, which is right, fields to join with, cardinality etc) should listed.
Each node inside the view will appear as a heading 3 in this document detailing what it does and, if not obvious, why.
2TL_TECPRO_SignavioProcessChanges_01
Calculation
Calculated dimension CD_PLANT to change length of field 'Plant' from 4 to 5 to align with WHM plant. (Ubiquitously true, reusable change made at lowest level possible).
2VR_TECPRO_SignavioProcessHistory_01
Calculation
Calculated measure: CM_PRICE = Value / Quantity. (Ubiquitously true, reusable change made at lowest level possible).
2VR_TECPRO_SignavioProcessMostRecent_01
Join
Purpose: Join PO header and item to create reusable view at item level that contains all fields from PO header
LHS: 2VR_S4H_C_PurchaseOrderDex
RHS: 2VR_S4H_C_PurchaseOrderItemDex
Join Field: POHeader to POHeader
Join type: Left outer join
Cardinality: 1: Many
Projection
Remove fields that occur in both PO Header and Item views leaving fields from PO Header side.
Propagation Layer
3VR_TECPRO_SignavioSwimLaneChanges_02
Calculation
A line item level calculation which applies specific business rules that are owned by the POD would be added here.
3VR_TECPRO_SignavioProcessUnion_01
Join
Purpose: etc
3VR_TECPRO_SignavioProcessLinkAppToSys_01
Join
Purpose: etc
3VF_TECPRO_SignavioProcessUnion_01
Union
Purpose: To bring in values from PO level alongside lower level granularity documents
| Target Field | Source1-Field | Source2-Field |
|---|---|---|
| PO | PO | PO |
| POItem | POItem | POItem |
| MaterialDocument | - | MaterialDocument |
Associations to master data
List objects where material master associations are to be made.
Calculated Measures (Pre-Aggregation Calculations)
3VF_TECPRO_SignavioSwimLaneChanges_02
Union
Purpose: To bring in values from PO level alongside lower level granularity documents
Reporting Layer
4MA_TECPRO_SignavioProcessUnion_01
Link to FSD (Each Analytic model should have its own FSD).
Include technical details for:
Calculated Measures (Post Aggregation Calculations / exception aggregation etc)
Restricted Measures
Detail restrictions
Currency Conversions
Detail rate type, from currency
Variables
Data access controls
4MA_TECPRO_SignavioSwimLaneChanges_02
Link to FSD (Each Analytic model should have its own FSD).
Include technical details for:
Calculated Measures (Post Aggregation Calculations / exception aggregation etc)
Restricted Measures
Detail restrictions
Currency Conversions
Detail rate type, from currency