Below is the data flow diagram from S2P
Standard extractors do not need to be documented unless extended.
Where custom extractors / extensions are required, reference the FSD for that enhancement.
| Extractor Name | Details | Build Jira Ref For Extension Information |
|---|---|---|
| Z_I_PurReqnAcctAssgmtAPI01 | Wrapper CDS View for SAP delivered CDS view I_PurReqnAcctAssgmtAPI01 to enable data extraction | |
No transformations to be applied in the inbound layer.
Each 2TL* table in the Harmonisation layer will be populated from the corresponding 1TL* tables for each source system (RoW and China).
A Source System Identifier will be included as part of the primary key in the 2TL* tables to uniquely distinguish records originating from different source systems.
A dimension view will be created joining 2VR_S4HARM_C_PurchaseOrderDex and 2VR_S4HARM_C_PurchaseOrderItemDex. The join will be an inner join based PO Document Number and Source System Identifier. All unique and relevant attributes from both header and item views will be included in the output. A left outer join will be added with 2VR_S4HARM_C_PurOrdAccountAssignmentDex to get the Profit Centre.
Each 2VR* view in the Harmonisation layer will be built on corresponding 2TL* tables. These views will be used to harmonise the data before applying business rules.
Purpose: Join PR Item data with PR Account Assignment to create a reusable for reporting on Purchasing Requisitions. Profit Centre from Account Assignment will be picked which is needed for GBU derivation.
LHS: 2VR_S4HARM_C_PurchaseRequisitionItemDex
RHS: 2VR_S4HARM_I_PurReqnAcctAssgmtAPI01
Join Field: PurchaseRequisition to PurchaseRequisition and PurchaseRequisitionItem to PurchaseRequisitionItem
Join type: Left outer join
Cardinality: 1:1
Before joining a filter will be applied on 2VR_S4HARM_I_PurReqnAcctAssgmtAPI01 to get only records with Profit Centre populated.
Purpose: etc
Purpose: etc
Purpose: etc
Calculated measure: CM_DocItemValue = DocQuantity * CM_PRICE
This will be the fact table to be used in the Purchase Requisition Analytical Model.
List objects where material master associations are to be made.
None
Link to FSD (Each Analytic model should have its own FSD).
Include technical details for:
| Measure ID | Description | SAP Table-Field Name / process | Comments / Calculation / Formula / Restriction dimensions and values | Aggregation of data | Example SAP field data |
| DCM_PReqCount | Total Number of PREQs | Count distinct Purchase Requisition Items | Use Distinct Count measure with dimensions PurchaseRequisition and PurchaseRequisitionItem | SUM | 34 |
| Measure ID | Description | SAP Table-Field Name / process | Comments / Calculation / Formula / Restriction dimensions and values | Aggregation of data | Example SAP field data |
| DCM_PReqWoPORatio | Ratio of Preq Items without PO vs. all PREQ Items | DRM_PReqWoPOCount / DCM_PReqCount | SUM | 0.34 |
| Measure ID | Description | SAP Table-Field Name / process | Comments / Calculation / Formula / Restriction dimensions and values | Aggregation of data | Example SAP field data |
| DRM_PReqWoPOCount | Number of PREQ Items without PO | Count distinct Purchase Requisition Items for which Purchase Order has not been created or Purchase Order Created for is deleted or Processing Status does not equal to PO Created | Restricted Measure on DCM_PReqCount with criteria: PurchasingDocument is null or initial OR IsDeleted = L OR ProcessingStatus != B | SUM | 34 |
| DRM_NonConformPRRate | Non-Conformant PREQs % | Percentage non-conformant PREQs which fall into the category of EKGRP IN ('FQE', 'E02', 'E03','N01','N02','N03','N04','N05','N06','N07','N08','N09','N10','N11','N12','N13','N14','N15') | Restricted Measure on DCM_PReqCount with criteria: PurchasingGroup IN (see cell on the left) | AVG | 0.04 |
Detail rate type, from currency
| Variable ID | Description | Field | Required/Optional | Scope | Default | Comment |
| vPRCreatedDate | Preq Creation Date | PurReqCreationDate | Optional | Interval | No default | |
| vCompanyCode | Company Code | CompanyCode | Optional | Multiple Single Values | No default | |
| vGBU | GBU | GBU | Optional | Multiple Single Values | No default | |
| vPlant | Plant | Plant | Optional | Multiple Single Values | No default | |
| vPurGroup | Purchasing Group | PurchasingGroup | Optional | Multiple Single Values | No default | |
| VPurOrg | Purchasing Org | PurchasingOrganization | Optional | Multiple Single Values | No default | |
| vMatGrp | Material Group | MaterialGroup | Optional | Multiple Single Values | No default | |
| vFixedVendor | Fixed Vendor | FixedVendor | Optional | Multiple Single Values | No default | |
| vDesiredVendor | Desired Vendor | DesiredVendor | Optional | Multiple Single Values | No default | |
| vPROrigin | PReq Origin | PurReqnOrigin | Optional | Multiple Single Values | No default | |
| vSource | Source System | SystemID | Optional | Multiple Single Values | No default |
NA