Document Links
ERP-1040 - Getting issue details... STATUS
Introduction
The DDFS covers the end to end datasphere data flows for S2P area. The sub area it covers include the standard ones, S2C - Source to Contract, P2R - Procure to Report and I2P - Invoice to Pay as well as custom ones BYP - Buyer Performance. Below are the details on each sub area and KPIS it will cover:
| Sub-Area | Details | Example KPIs | Comments |
|---|---|---|---|
| S2C - Source to Contract | 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 | |
| P2R - Procure to Report | The Procure-to-Report (P2R) covers the activities involved in procurement execution and starts with the creation of purchase requisitions and purchase orders, continues through goods receipt and invoice processing. It will also cover consignment withdrawals and pipeline information. Reporting enables to analyze procurement performance, supplier activity, and spend patterns. | PR, PO, GR and Invoice quantities and amounts, PO cycle time, PR to PO conversion rate, spend management, on time delivery rates, GR processing time. 2way /3way match ratio, consignment withdrawal qty and values | |
| I2P - Invoice to Pay | The Invoice-to-Pay (I2P) covers all activities from the receipt and verification of supplier invoices through to the final payment to the supplier. The process typically includes invoice receipt, invoice verification, exception handling, approval workflows, posting to accounts payable, and payment processing. | Invoice amount & quantities, payment terms, on time vs late payment rate, DPO, actual spend | |
| BYP - Buyer Performance | The Buyer Performance (BYP) is a custom sub area which covers the process of buyer performance and VBF.
| Total Spend at LE, Service Company Spend, OpCo Spend, Service Company zone and country level spend, VBF, Performance & savings, VBF vs Performance |
Jira Requests Coverage
The models covered under this DDFS will cater towards requirements from the following Jira Requests -
- ERP-1052 - Getting issue details... STATUS
- ERP-1861 - Getting issue details... STATUS
- ERP-1873 - Getting issue details... STATUS
- ERP-2049 - Getting issue details... STATUS
- ERP-2061 - Getting issue details... STATUS
- ERP-2070 - Getting issue details... STATUS
- ERP-2071 - Getting issue details... STATUS
- ERP-2062 - Getting issue details... STATUS
- ERP-2076 - Getting issue details... STATUS
- ERP-2077 - Getting issue details... STATUS
Data Flow Diagram
Please note that there is no SAP delivered business content for procurement sourced from S4 system.
Source System Extractors
Standard extractors are listed in the data flow diagram (above) and are not documented here unless extended.
Where custom extractors / extensions are required, reference the FSD for that enhancement.
| Extractor Name | Details | Build Jira Ref For Extension Information |
|---|---|---|
| /SYQ/I_PurReqnAcctAssgmtAPI01 | Wrapper CDS View for SAP delivered CDS view I_PurReqnAcctAssgmtAPI01 to enable data extraction | |
| /SYQ/E_C_PurchaseContractDex_01 | Extension for CDS view C_PurhcaseContractDex to add the custom fields for Take or Pay | |
| /SYQ/I_PurOrdConfirmationDispute | New CDS view on top of a custom table (name tbc) to get all the fields. It will be delta enabled based on changed on timestamp | |
| /SYQ/I_PurOrdMessages | New CDS view (delta enabled) on top of table NAST to fetch PO messages sent to vendors. Filter KAPPL = 'EF' and PARVW = 'LF' |
Inbound Layer
No transformations to be applied in the inbound layer.
Replication Flows
Below is the list of Replication Flows corresponding to the CDS views from both ROW and China S4 systems:
| CDS View Name (Source) | RoW | China |
|---|---|---|
| C_PurchaseOrderDEX | 1FR_S4HR_S2PP2R_DELTA_1 | 1FR_S4HC_S2PP2R_DELTA_1 |
| C_PurchaseOrderItemDEX | ||
| C_PurOrdScheduleLineDEX | ||
| C_POSupplierConfirmationDEX | ||
| C_PurchaseOrderHistoryDEX | ||
| C_PurOrdAccountAssignmentDEX | ||
| C_PurchaseRequisitionItemDEX | 1FR_S4HR_S2PP2R_DELTA_2 | 1FR_S4HC_S2PP2R_DELTA_2 |
| /SYQ/I_PurReqnAcctAssgmtAPI01 | ||
| /SYQ/I_PurOrdConfirmationDispute | 1FR_S4HR_S2PP2R_DELTA_3 | 1FR_S4HR_S2PP2R_DELTA_3 |
| /SYQ/I_PurOrdMessages | ||
| C_PurchaseContractDEX | 1FR_S4HR_S2PS2C_DELTA_1 | 1FR_S4HC_S2PS2C_DELTA_1 |
| C_PurchaseContractItemDEX | ||
| C_PurchaseContractHistoryDEX | ||
| C_SupplierInvoiceDEX | 1FR_S4HR_S2PI2P_DELTA_1 | 1FR_S4HC_S2PI2P_DELTA_1 |
| C_SupplierInvoiceItemDEX |
Harmonisation Layer
2TL* Tables
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.
1TL_CNTROL_POACTIVITIESMAPPING
Purpose
This table will list all in-scope activities and indicate their relevance for rework, automation, SBS scope, and changes. Each activity will be mapped to the corresponding PO DB field to enable tagging and tracking using data from the change log table.
The data in the table will be maintained by uploading csv file. The following is the list of fields on the table,
- DB Field - Field to track an activity on the PO (usually on table EKKO or EKPO)
- Activity - Name of the PO activity
- Rework - In scope for rework
- Automation - In scope for automation
- Changes - In scope for changes
- SBS Scope - In scope for SBS
2VR_S4HARM_C_PurchaseRequisitionItem
Purpose
Join PR Item data with PR Account Assignment to create a reusable view for reporting on Purchasing Requisitions. Profit Centre from Account Assignment will be picked which is needed for GBU derivation.
Join
LHS: 2TL_S4HARM_C_PurchaseRequisitionItemDex
RHS: 2TL_S4HARM_I_PurReqnAcctAssgmtAPI01
Join Field: PurchaseRequisition to PurchaseRequisition and PurchaseRequisitionItem to PurchaseRequisitionItem
Join type: Left outer join
Cardinality: 1:1
Projection
Before joining a projection will be applied 2VR_S4HARM_I_PurReqnAcctAssgmtAPI01 to get only PurchaseRequistion, PurchaseRequistionItem, ProfitCenter fields
Filter
Post projection a filter will be applied on to get only records with Profit Centre populated.
Calculation
Calculated Column DCD_SequenceNumber = ROW_NUMBER() OVER (PARTITION BY PurchaseRequisition, PurchaseRequisitionItem ORDER BY PurchaseRequisition, PurchaseRequisitionItem)
Calculated Column DCD_SequenceNumberFilter = DCD_SequenceNumber
Filter
DCD_SequenceNumberFilter = 1
2VR_S4HARM_C_PurchaseOrderItem
Purpose
Join PO Item data with PO Header to create a reusable view for reporting on Purchasing Orders.
Join
LHS: 2TL_S4HARM_C_PurchaseOrderItemDex
RHS: 2TL_S4HARM_C_PurchaseOrderDex
Join Field: PurchaseOrder and PurchaseOrder
Join type: Inner join
Cardinality: 1:1
Projection
Remove all the duplicate fields from 2TL_S4HARM_C_PurchaseOrderDex.
Calculation
Calculated Dimension - DCD_TwoThreeWayMatch (Two Three Way PO Match). Formula: When WEPOS is null then 2-Way Match else When WEPOS is not null and WEUNB is null then 3-Way Match
2VR_S4HARM_C_PurchaseContractItem
Purpose
Join PO Contract Item data with PO Contract Header to create a reusable view for reporting on Purchasing Contracts (outline agreements).
Join
LHS: 2TL_S4HARM_C_PurchaseContractItemDex
RHS: 2TL_S4HARM_C_PurchaseContractDex
Join Field: PurchaseContract and PurchaseContract
Join type: Inner join
Cardinality: 1:1
Projection
Remove all the duplicate fields from 2TL_S4HARM_C_PurchaseContractDex.
2VR_S4HARM_C_SupplierInvoiceItem
Purpose
Join Supplier Invoice Item data with Supplier Invoice Header to create a reusable view for reporting on Supplier Invoices.
Join
LHS: 2TL_S4HARM_C_SupplierInvoiceItemDex
RHS: 2TL_S4HARM_C_SupplierInvoiceDex
Join Field: SupplierInvoice and SupplierInvoice
Join type: Inner join
Cardinality: 1:1
2VD_S4HARM_PurchaseOrderItem
A dimension view will be created on top of 2VR_S4HARM_C_PurchaseOrderItemDex. A left outer join will be added with 2VR_S4HARM_C_PurOrdAccountAssignmentDex to get the Profit Centre. Master data associations to the attributes will be done in this dimension view.
Below rules will be applied on 2VR_S4HARM_C_PurOrdAccountAssignmentDex before the join
Projection
A projection will be applied to get only PurchaseOrder, PurchaseOrderItem, ProfitCenter fields
Filter
Post projection a filter will be applied on to get only records with Profit Centre populated.
Calculation
Calculated Column DCD_SequenceNumber = ROW_NUMBER() OVER (PARTITION BY PurchaseOrder, PurchaseOrderItem ORDER BY PurchaseOrder, PurchaseOrderItem)
Calculated Column DCD_SequenceNumberFilter = DCD_SequenceNumber
Filter
DCD_SequenceNumberFilter = 1
Other 2VR* Relational Views
Remaining 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.
Transformation Flows
Below is a list of transformation flows that will be used to load data from inbound spaces to harmonisation space.
| Transformation Flow | Source | Target |
|---|---|---|
| 2FT_S4HARM_C_PurchaseOrderDex_S4HR | 1TL_S4HR_C_PURCHASEORDERDEX | 2TL_S4HARM_C_PurchaseOrderDex |
| 2FT_S4HARM_C_PurchaseOrderItem_S4HR | 1TL_S4HR_C_PURCHASEORDERITEMDEX | 2TL_S4HARM_C_PurchaseOrderItemDex |
| 2FT_S4HARM_C_PurOrdScheduleLine_S4HR | 1TL_S4HR_C_PURORDSCHEDULELINEDEX | 2TL_S4HARM_C_PurOrdScheduleLineDex |
| 2FT_S4HARM_C_POSupplierConfirmation_S4HR | 1TL_S4HR_C_POSUPPLIERCONFIRMATIONDEX | 2TL_S4HARM_C_POSupplierConfirmationDex |
| 2FT_S4HARM_C_PurchaseOrderHistory_S4HR | 1TL_S4HR_C_PURCHASEORDERHISTORYDEX | 2TL_S4HARM_C_PurchaseOrderHistoryDex |
| 2FT_S4HARM_C_PurOrdAccountAssignment_S4HR | 1TL_S4HR_C_PURORDACCOUNTASSIGNMENTDEX | 2TL_S4HARM_C_PurOrdAccountAssignmentDex |
| 2FT_S4HARM_C_PurchaseRequisitionItem_S4HR | 1TL_S4HR_C_PURCHASEREQUISITIONITEMDEX | 2TL_S4HARM_C_PurchaseRequisitionItemDex |
| 2FT_S4HARM_SYQI_PurReqnAcctAssgmtAPI01_S4HR | 1TL_S4HR_SYQI_PURREQNACCTASSGMTAPI01 | 2TL_S4HARM_SYQI_PurReqnAcctAssgmtAPI01 |
| 2FT_S4HARM_C_PurchaseContract_S4HR | 1TL_S4HR_C_PURCHASECONTRACTDEX | 2TL_S4HARM_C_PurchaseContractDex |
| 2FT_S4HARM_C_PurchaseContractItem_S4HR | 1TL_S4HR_C_PURCHASECONTRACTITEMDEX | 2TL_S4HARM_C_PurchaseContractItemDex |
| 2FT_S4HARM_C_PurchaseContractHistory_S4HR | 1TL_S4HR_C_PURCHASECONTRACTHISTORYDEX | 2TL_S4HARM_C_PurchaseContractHistoryDex |
| 2FT_S4HARM_C_SupplierInvoice_S4HR | 1TL_S4HR_C_SUPPLIERINVOICEDEX | 2TL_S4HARM_C_SupplierInvoiceDex |
| 2FT_S4HARM_C_SupplierInvoiceItem_S4HR | 1TL_S4HR_C_SUPPLIERINVOICEITEMDEX | 2TL_S4HARM_C_SupplierInvoiceItemDex |
| 2FT_S4HARM_SYQI_PurOrdConfirmationDispute_S4HR | 1TL_S4HR_SYQI_PURORDCONFIRMATIONDISPUTE | 2TL_S4HARM_SYQI_PurOrdConfirmationDispute |
| 2FT_S4HARM_SYQI_PurOrdMessages_S4HR | 1TL_S4HR_SYQI_PURORDMESSAGES | 2TL_S4HARM_SYQI_PurOrdMessages |
| 2FT_S4HARM_C_PurchaseOrderDex_S4HC | 1TL_S4HC_C_PURCHASEORDERDEX | 2TL_S4HARM_C_PurchaseOrderDex |
| 2FT_S4HARM_C_PurchaseOrderItem_S4HC | 1TL_S4HC_C_PURCHASEORDERITEMDEX | 2TL_S4HARM_C_PurchaseOrderItemDex |
| 2FT_S4HARM_C_PurOrdScheduleLine_S4HC | 1TL_S4HC_C_PURORDSCHEDULELINEDEX | 2TL_S4HARM_C_PurOrdScheduleLineDex |
| 2FT_S4HARM_C_POSupplierConfirmation_S4HC | 1TL_S4HC_C_POSUPPLIERCONFIRMATIONDEX | 2TL_S4HARM_C_POSupplierConfirmationDex |
| 2FT_S4HARM_C_PurchaseOrderHistory_S4HC | 1TL_S4HC_C_PURCHASEORDERHISTORYDEX | 2TL_S4HARM_C_PurchaseOrderHistoryDex |
| 2FT_S4HARM_C_PurOrdAccountAssignment_S4HC | 1TL_S4HC_C_PURORDACCOUNTASSIGNMENTDEX | 2TL_S4HARM_C_PurOrdAccountAssignmentDex |
| 2FT_S4HARM_C_PurchaseRequisitionItem_S4HC | 1TL_S4HC_C_PURCHASEREQUISITIONITEMDEX | 2TL_S4HARM_C_PurchaseRequisitionItemDex |
| 2FT_S4HARM_SYQI_PurReqnAcctAssgmtAPI01_S4HC | 1TL_S4HC_SYQI_PURREQNACCTASSGMTAPI01 | 2TL_S4HARM_SYQI_PurReqnAcctAssgmtAPI01 |
| 2FT_S4HARM_C_PurchaseContract_S4HC | 1TL_S4HC_C_PURCHASECONTRACTDEX | 2TL_S4HARM_C_PurchaseContractDex |
| 2FT_S4HARM_C_PurchaseContractItem_S4HC | 1TL_S4HC_C_PURCHASECONTRACTITEMDEX | 2TL_S4HARM_C_PurchaseContractItemDex |
| 2FT_S4HARM_C_PurchaseContractHistory_S4HC | 1TL_S4HC_C_PURCHASECONTRACTHISTORYDEX | 2TL_S4HARM_C_PurchaseContractHistoryDex |
| 2FT_S4HARM_C_SupplierInvoice_S4HC | 1TL_S4HC_C_SUPPLIERINVOICEDEX | 2TL_S4HARM_C_SupplierInvoiceDex |
| 2FT_S4HARM_C_SupplierInvoiceItem_S4HC | 1TL_S4HC_C_SUPPLIERINVOICEITEMDEX | 2TL_S4HARM_C_SupplierInvoiceItemDex |
| 2FT_S4HARM_SYQI_PurOrdConfirmationDispute_S4HC | 1TL_S4HC_SYQI_PURORDCONFIRMATIONDISPUTE | 2TL_S4HARM_SYQI_PurOrdConfirmationDispute |
| 2FT_S4HARM_SYQI_PurOrdMessages_S4HC | 1TL_S4HC_SYQI_PURORDMESSAGES | 2TL_S4HARM_SYQI_PurOrdMessages |
Propagation Layer
3VR_S2PP2R_PurchaseRequisitionItem
Mapped 1:1 with 2VR_S4HARM_PurchaseRequisitionItem
3VR_S2PP2R_PurchaseOrderItem
Join
Purpose: Join PO Item data with PR Item to fetch requisition related measures, PR Qty, PR Net Amount and PR Net Amount in EUR
LHS: 2VR_S4HARM_C_PurchaseOrderItemDex
RHS: 3VR_S4HARM_C_PurchaseRequisitionItem
Join Field: PurchaseRequisition to PurchaseRequisition and PurchaseRequisitionItem to PurchaseRequisitionItem
Join type: Left Outer Join
Cardinality: 1:1
Join
Purpose: Join PO Item data with PO Confirmation Dispute data to identify whether the PO item has been disputed based on confirmation from the vendor
LHS: 2VR_S4HARM_C_PurchaseOrderItemDex
RHS: 2VR_S4HARM_C_PurOrdConfirmationDispute
Join Field: PurchaseOrder to PurchaseOrder and PurchaseOrderItem to PurchaseOrderItem
Join type: Left Outer Join
Cardinality: 1:1
Calculation
Calculated measure: DCM_Counter = Constant 1
Calculated measure: DCM_POPRPriceDifference = If PurchaseRequisition is not null or '' then NetPriceAmount - PurchaseRequisitionPrice
Calculated dimension: DCD_POPRPriceMisMatch = If PurchaseRequisition is not null or '' and NetPriceAmount = PurchaseRequisitionPrice then 'X'
3VR_S2PP2R_PurchaseOrderHistory
All fields mapped 1:1 with 2VR_S4HARM_PurchaseOrderHistory
3VR_S2PP2R_PurOrdScheduleLine
Join
Purpose: Join PO Item data with Schedule Line data to fetch item price to enable amount calculations. Also fetch PR related measures
LHS: 2VR_S4HARM_C_PurOrdScheduleLine
RHS: 3VR_S2PP2R_C_PurchaseOrderItem
Join Field: PurchaseOrder to PurchaseOrder and PurchaseOrderItem to PurchaseOrderItem
Join type: Left Outer Join
Cardinality: 1:1
Calculation
Calculated measure: DCM_POAmount = NetPriceAmount * ScheduleLineOrderQuantity
3VR_S2PS2C_PurchaseContractItem
Join 1
Purpose: Join PO Contract Item data with PO Contract History data to fetch release orders (PO & PO Item) associated to a contract.
LHS: 2VR_S4HARM_C_PurchaseContractItem
RHS: 2VR_S4HARM_C_PurchaseContractHistory
Join Field: PurchaseContract to PurchaseContract and PurchaseContractItem to PurchaseContractItem
Join type: Left Outer Join
Cardinality: 1:n
Join 2
Purpose: Next join the view with 3VR_S2PP2R_PurchaseOrderHistory to get invoiced spend for the PO Item
LHS: Join 1
RHS: 3VR_S2PP2R_PurchaseOrderHistory
Join Field: ReleaseOrder to PurchaseOrder and ReleaseOrderItem to PurchaseOrderItem
Join type: Left Outer Join
Cardinality: 1:1
Calculation
Before joining 3VR_S2PP2R_PurchaseOrderHistory, below steps need to performed to get data at required granularity which is PO and PO item,
- Filter on PURCHASINGHISTORYDOCUMENTTYPE = 2, 3 or 9 as well as filter on PURCHASINGHISTORYCATEGORY = Q, N, P or D
- Calculated Measure - DCM_InvoicedValuePOCur - Formula: If DEBITCREDITCODE = H, then INVOICEAMTINPURORDTRANSACCRCY * -1 else INVOICEAMTINPURORDTRANSACCRCY
- Calculated Measure - DCM_InvoicedQtyPOUnit - Formula: If DEBITCREDITCODE = H, then QUANTITY * -1 else QUANTITY
- Aggregate above measures at PurchaseOrder and PurchaseOrderItem
Calculated Measure: DCM_ReleaseOrderNetPrice = RELEASEORDERITEMNETAMOUNT / RELEASEORDERITEMORDERQUANTITY
Calculated Measure: DCM_Counter = Constant 1
Calculate Measure: DCM_POContPriceMistMatch = If ReleaseOrder is not null or '' then DCM_ReleaseOrderNetPrice - ContractNetPriceAmount
Calculated Dimension: DCD_POContPriceMisMatch = If ReleaseOrder is not null or '' and DCM_ReleaseOrderNetPrice = ContractNetPriceAmount then 'X'
3VR_S2PP2R_SuplrCsgnmtPplineWithdrwl
Calculation
The source object 2VR* is defined in the P2F DDFS. Use Formula component to modify the expression of below measures.
- SuplrcsgnmtPplineWithdrwlAmount - When DebitCreditCode = H then SuplrcsgnmtPplineWithdrwlAmount else SuplrcsgnmtPplineWithdrwlAmount * -1
- SuplrcsgnmtPplineWithdrwlQty - When DebitCreditCode = H then SuplrcsgnmtPplineWithdrwlQty else SuplrcsgnmtPplineWithdrwlQty * -1
- NonDeductibleInputTaxAmount - When DebitCreditCode = H then NonDeductibleInputTaxAmount else NonDeductibleInputTaxAmount * -1
3VR_S2PI2P_SupplierInvoiceItem
Join
Purpose: Join Supplier Invoice Item data with PO Item data to get document date.
LHS: 2VR_S4HARM_C_SupplierInvoiceItem
RHS: 3VR_S2PP2R_C_PurchaseOrderItem
Join Field: PurchaseOrder to PurchaseOrder and PurchaseOrderItem to PurchaseOrderItem
Join type: Left Outer Join
Cardinality: 1:1
Calculation
Calculated dimension: DCD_LatePO (Late PO Creation) = If PODOCUMENTDATE is null or blank or > DOCUMENTDATE then X else ''
3VF_S2PP2R_PurchaseRequisitionItem
This will be the fact table to be used in the Purchase Requisition Analytical Model.
List of Fields & Associations to master data
| DSP field | Report Field Description | SAP Table–Field Name | Comments / Descriptions | Time relevancy of data | MD Source |
|---|---|---|---|---|---|
| SYSTEMID | Source System | DSP Field | Constant S4HC or S4HR | Non-time dependent | |
| PURCHASEREQUISITION | Purchase Requisition Number | EBAN-BANFN | Non-time dependent | ||
| PURCHASEREQUISITIONITEM | Item number of purchase requisition | EBAN-BNFPO | Non-time dependent | ||
| PURCHASINGDOCUMENT | Purchase order number | EBAN-EBELN | Non-time dependent | 2VD_S4HARM_PurchaseOrderItem | |
| PURCHASINGDOCUMENTITEM | Purchase order item number | EBAN-EBELP | Non-time dependent | 2VD_S4HARM_PurchaseOrderItem | |
| PURREQNRELEASESTATUS | Requisition Processing State | EBAN-BANPR | Non-time dependent | ||
| PURCHASEREQUISITIONTYPE | Purchase Requisition Document Type | EBAN-BSART | Non-time dependent | 2VD_S4HARM_PurchaseDocumentType | |
| PURCHASINGDOCUMENTSUBTYPE | Control indicator for purchasing document type | EBAN-BSAKZ | Non-time dependent | ||
| PURCHASINGDOCUMENTITEMCATEGORY | Item category in purchasing document | EBAN-PSTYP | Non-time dependent | 2VD_S4HARM_ItemCategoryForPurchasingDocument | |
| PURCHASEREQUISITIONITEMTEXT | Short Text | EBAN-TXZ01 | Non-time dependent | ||
| ACCOUNTASSIGNMENTCATEGORY | Account Assignment Category | EBAN-KNTTP | Non-time dependent | 2VD_S4HARM_AccountAssignmentCategory | |
| MATERIAL | Material Number | EBAN-MATNR | Non-time dependent | 2VD_S4HARM_Product | |
| MATERIALGROUP | Material Group | EBAN-MATKL | Non-time dependent | 2VD_S4HARM_MaterialGroup | |
| PURCHASINGDOCUMENTCATEGORY | Purchasing Document Category | EBAN-BSTYP | Non-time dependent | 2VD_S4HARM_PurchasingDocumentCategory | |
| MATERIALGOODSRECEIPTDURATION | Goods receipt processing time in days | EBAN-WEBAZ | Non-time dependent | ||
| RELEASECODE | Release Indicator | EBAN-FRGKZ | Non-time dependent | ||
| PURCHASEREQUISITIONRELEASEDATE | Purchase Requisition Release Date | EBAN-FRGDT | Non-time dependent | ||
| PURCHASINGORGANIZATION | Purchasing Organization | EBAN-EKORG | Non-time dependent | 2VD_S4HARM_PurchasingOrganization | |
| PURCHASINGGROUP | Purchasing Group | EBAN-EKGRP | Non-time dependent | 2VD_S4HARM_PurchasingGroup | |
| PLANT | Plant | EBAN-WERKS | Non-time dependent | 2VD_S4HARM_Plant | |
| SOURCEOFSUPPLYISASSIGNED | Assigned Source of Supply | EBAN-ZUGBA | Non-time dependent | ||
| SUPPLYINGPLANT | Supplying (issuing) plant in case of stock transport order | EBAN-RESWK | Non-time dependent | 2VD_S4HARM_Plant | |
| PURREQNLIMITCONSUMPTIONAMT | Consumption Value for Limit Items | EBAN-LIMIT_CONSUMPTION_VALUE | Non-time dependent | ||
| DELIVERYDATE | Item Delivery Date | EBAN-LFDAT | Non-time dependent | ||
| CREATIONDATE | Requisition (request) date | EBAN-BADAT | Non-time dependent | ||
| PROCESSINGSTATUS | Processing status of purchase requisition | EBAN-STATU | Non-time dependent | ||
| PURCHASINGINFORECORD | Number of purchasing info record | EBAN-INFNR | Non-time dependent | ||
| SUPPLIER | Desired Vendor | EBAN-LIFNR | Non-time dependent | 2VD_S4HARM_Supplier | |
| ISDELETED | Deletion Indicator in Purchasing Document | EBAN-LOEKZ | Non-time dependent | ||
| FIXEDSUPPLIER | Fixed Vendor | EBAN-FLIEF | Non-time dependent | 2VD_S4HARM_Supplier | |
| REQUISITIONERNAME | Name of requisitioner/requester | EBAN-AFNAM | Non-time dependent | ||
| CREATEDBYUSER | Name of Person Responsible for Creating the Object | EBAN-ERNAM | Non-time dependent | ||
| DELIVERYADDRESSID | Address | EBAN-ADRNR | Non-time dependent | ||
| MANUALDELIVERYADDRESSID | Manual address number in purchasing document item | EBAN-ADRNR | Non-time dependent | ||
| PURREQNITEMCURRENCY | Currency Key | EBAN-WAERS | Non-time dependent | ||
| MATERIALPLANNEDDELIVERYDURN | Planned Delivery Time in Days | EBAN-PLIFZ | Non-time dependent | ||
| DELIVDATECATEGORY | Category of delivery date | EBAN-LPEIN | Non-time dependent | ||
| MULTIPLEACCTASSGMTDISTRIBUTION | Distribution Indicator for Multiple Account Assignment | EBAN-VRTKZ | Non-time dependent | ||
| STORAGELOCATION | Storage Location | EBAN-LGORT | Non-time dependent | 2VD_S4HARM_StorageLocation | |
| PURREQNSSPREQUESTOR | Requestor | EBAN-SC_REQUESTOR | Non-time dependent | ||
| PURREQNSSPAUTHOR | Author of Requisition | EBAN-SC_AUTHOR | Non-time dependent | ||
| PURCHASECONTRACT | Number of principal purchase agreement | EBAN-KONNR | Non-time dependent | ||
| PURREQNSOURCEOFSUPPLYTYPE | Purchasing Document Category | EBAN-BSTYP | Non-time dependent | 2VD_S4HARM_PurchasingDocumentCategory | |
| PURCHASECONTRACTITEM | Item Number of Principal Purchase Agreement | EBAN-KTPNR | Non-time dependent | ||
| CONSUMPTIONPOSTING | Consumption posting | EBAN-KZVBR | Non-time dependent | ||
| PURREQNORIGIN | Creation indicator (purchase requisition/schedule lines) | EBAN-ESTKZ | Non-time dependent | ||
| PURREQNSSPCATALOGITEM | Catalog Item Id | EBAN-SC_CATALOGITEM | Non-time dependent | ||
| PURREQNSSPCROSSCATALOGITEM | Catalog Item Key | EBAN-SC_SR_ITEM_KEY | Non-time dependent | ||
| ISPURREQNBLOCKED | Purchase Requisition Blocked | EBAN-BLCKD | Non-time dependent | ||
| ITEMDELIVERYADDRESSID | Number of delivery address | EBAN-ADRN2 | Non-time dependent | ||
| ISCLOSED | Purchase requisition closed | EBAN-EBAKZ | Non-time dependent | ||
| RELEASEISNOTCOMPLETED | Release Not Yet Completely Effected | EBAN-FRGRL | Non-time dependent | ||
| SERVICEPERFORMER | Service Performer | EBAN-SERVICEPERFORMER | Non-time dependent | ||
| PRODUCTTYPE | Product Type | EBAN-PRODUCTTYPE | Non-time dependent | 2VD_S4HARM_ProductType | |
| PURCHASEREQUISITIONSTATUS | Release State | EBAN-FRGZU | Non-time dependent | ||
| RELEASESTRATEGY | Release strategy in the purchase requisition | EBAN-FRGST | Non-time dependent | ||
| COMPANYCODE | Company Code | EBAN-BUKRS | Non-time dependent | 2VD_S4HARM_CompanyCode | |
| SUPPLIERMATERIALNUMBER | Material Number Used by Supplier | EBAN-IDNLF | Non-time dependent | ||
| BATCH | Batch Number | EBAN-CHARG | Non-time dependent | 2VD_S4HARM_Batch | |
| MINREMAININGSHELFLIFE | Minimum Remaining Shelf Life | EBAN-MHDRZ | Non-time dependent | ||
| GOODSRECEIPTISEXPECTED | Goods Receipt Indicator | EBAN-WEPOS | Non-time dependent | ||
| INVOICEISEXPECTED | Invoice Receipt Indicator | EBAN-REPOS | Non-time dependent | ||
| GOODSRECEIPTISNONVALUATED | Goods Receipt, Non-Valuated | EBAN-WEUNB | Non-time dependent | ||
| REQUIREMENTTRACKING | Requirement Tracking Number | EBAN-BEDNR | Non-time dependent | ||
| MRPCONTROLLER | MRP Controller | EBAN-DISPO | Non-time dependent | ||
| TAXCODE | Tax on sales/purchases code | EBAN-MWSKZ | Non-time dependent | 2VD_S4HARM_TaxCode | |
| PURCHASEREQUISITIONISFIXED | Purchase requisition is fixed | EBAN-FIXKZ | Non-time dependent | ||
| ADDRESSID | Manual address number in purchasing document item | EBAN-ADRNR | Non-time dependent | ||
| LASTCHANGEDATETIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | EBAN-LASTCHANGEDDATETIME | Non-time dependent | ||
| PROCUREMENTHUBSOURCESYSTEM | Connected System ID | EBAN-EXT_BE_SOURCE_SYS | Non-time dependent | ||
| PROFITCENTER | Profit Centre | EBAN-PRCTR | Non-time dependent | 2VD_S4HARM_ProfitCenter | |
| BASEUNIT | Purchase requisition unit of measure | EBAN-MEINS | Non-time dependent | ||
| ISPURREQNCMPLT | Purchase Requisition not yet Complete | EBAN-MEMORY | Non-time dependent | ||
| PURREQNITEMBLOCKINGREASONTEXT | Reason for Item Block | EBAN-BLCKT | Non-time dependent | ||
| INVENTORYSPECIALSTOCKTYPE | Special Stock Indicator | EBAN-SOBKZ | Non-time dependent |
Calculated Measures (Pre-Aggregation Calculations)
None
3VF_S2PP2R_PurOrderItemSchdHist
This will be the fact table to be used in the Purchase Order Schedule Line Analytical Model. The PO line schedule line data will be also in union with PO history data and consignment withdrawal data to get a combined view of KPIs like PO Value, GR Value, Invoice Value etc,
Union
3VR_S2PP2R_PurOrdScheduleLine and 3VR_S2PP2R_PurchaseOrderHistory and 3VR_S2PP2R_SuplrCsgnmtPplineWithdrwl will be in union. Below table shows the union fields from the three views along with associations,
| Union View | DSP field | Report Field Description | SAP Table–Field Name | Comments / Descriptions | Time relevancy of data | MD Source |
|---|---|---|---|---|---|---|
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | SystemID | Source System | DSP Derived | Constant S4HC or S4HR | Non-time dependent | |
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine | PURCHASEORDER | Purchasing Document Number | EKBE-EBELN, EKET-EBELN | Non-time dependent | 2VD_S4HARM_PurchaseOrderItem | |
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine | PURCHASEORDERITEM | Purchasing Document Item | EKBE-EBELP, EKET-EBELP | Non-time dependent | 2VD_S4HARM_PurchaseOrderItem | |
| 3VR_S2PP2R_PurOrderScheduleLine | PURCHASEORDERSCHEDULELINE | Delivery Schedule Line Counter | EKET-EETEN | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory | PURCHASINGHISTORYDOCUMENTTYPE | Transaction Type | EKBE-VGABE | Indicates what kind of activity occurred for a purchase order, such as Goods Receipt or Invoice Receipt | Non-time dependent | |
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | PURCHASINGHISTORYDOCUMENTYEAR | Material Document Year | EKBE-MJAHR RKWA-MJAHR | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | PURCHASINGHISTORYDOCUMENT | Number of Material Document | EKBE-MBLNR RKWA-MBLNR | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | PURCHASINGHISTORYDOCUMENTITEM | Item in Material Document | EKBE-MBLPO RKWA-MBLPO | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory | PURCHASINGHISTORYCATEGORY | Purchase Order History Category | EKBE-BEWTP | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory | GOODSMOVEMENTTYPE | Movement Type | EKBE-BWART | Non-time dependent | 2VD_S4HARM_MovementType | |
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | POSTINGDATE | Posting Date | EKBE-BUDAT RKWA-BUDAT EKET-EINDT | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory | CURRENCY | Currency Key | EKBE-WAERS, EKET-WAERS | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | DEBITCREDITCODE | Debit /Credit Indicator | EKBE-SHKZG RKWA-SHKZG | Non-time dependent | 2VD_S4HARM_DebitCreditIndicator | |
| 3VR_S2PP2R_PurchaseOrderHistory | REFERENCEDOCUMENTFISCALYEAR | Reference Document Fiscal Year | EKBE-LFBJA | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory | REFERENCEDOCUMENT | Reference Document Number | EKBE-LFBNR | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory | REFERENCEDOCUMENTITEM | Reference Document Item | EKBE-LFPOS | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | MATERIAL | Material Number | EKBE-MATNR, EKPO-MATNR RKWA-MATNR | Non-time dependent | 2VD_S4HARM_Product | |
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | PLANT | Plant | EKBE-WERKS, EKPO-WERKS RKWA-WERKS | Non-time dependent | 2VD_S4HARM_Plant | |
| 3VR_S2PP2R_PurchaseOrderHistory | INVENTORYVALUATIONTYPE | Valuation Type | EKBE-BWTAR | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory | DOCUMENTREFERENCEID | Reference Document Number | EKBE-XBLNR | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory | DELIVERYQUANTITYUNIT | Delivery Note UoM | EKBE-LSMEH | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory | ACCOUNTINGDOCUMENTCREATIONDATE | Accounting Document Created Date | EKBE-CPUDT | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | ORDERPRICEUNIT | Order Price Unit | EKPO-MEINS RKWA-MEINS | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine | PURCHASEORDERQUANTITYUNIT | Purchase Order Unit of Measure | EKPO-BPRME | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine | BASEUNIT | Base Unit of Measure | EKPO-LMEIN | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | DOCUMENTCURRENCY | Document Currency | EKBE-WAERS, EKPO-WAERS RKWA-WAERS | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine | PURCHASEORDERITEMCATEGORY | PO Item Category | EKPO-PSTYP | Non-time dependent | 2VD_S4HARM_PurchaseOrderItemCategory | |
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine | PRODUCTGROUP | Material Group | EKPO-MATKL | Non-time dependent | 2VD_S4HARM_ProductGroup | |
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | SUPPLIER | Supplier | EKKO-LIFNR RKWA-LIFNR | Non-time dependent | 2VD_S4HARM_Supplier | |
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine | PURCHASINGORGANIZATION | Purchasing Organization | EKKO-EKORG | Non-time dependent | 2VD_S4HARM_PurchasingOrganization | |
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine | PURCHASINGGROUP | Purchasing Group | EKKO-BKGRP | Non-time dependent | 2VD_S4HARM_PurchasingGroup | |
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | COMPANYCODE | Company Code | EKBE-BUKRS, EKPO-BUKRS RKWA-BUKRS | Non-time dependent | 2VD_S4HARM_CompanyCode | |
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine | PURCHASEREQUISITION | Purchase Requisition Number | EBAN-BANFN | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine | PURCHASEREQUISITIONITEM | Item number of purchase requisition | EBAN-BNFPO | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | DCD_TwoThreeWayMatch | Two Three Way Match | DSP Derived | Derived in 3VR_S2PP2R_PurchaseOrderItem | Non-time dependent | |
| 3VR_S2PP2R_PurOrderScheduleLine | SCHEDULELINEDELIVERYDATE | Item Delivery Date | EKET-EINDT | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | SCHEDLINESTSCDELIVERYDATE | Statistics-Relevant Delivery Date | EKET-SLFDT | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | SCHEDULELINEDELIVERYTIME | Delivery Date Time-Spot | EKET-UZEIT | Non-time dependent | ||
| 3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine | BATCH | Batch Number | EKET-CHARG | Non-time dependent | 2VD_S4HARM_Batch | |
| 3VR_S2PP2R_PurOrderScheduleLine | PURCHASINGSCHDLNNROFREMINDERS | No. of Reminders/Expediters for Schedule Line | EKET-MAHNZ | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | RESERVATION | Number of reservation/dependent requirements | EKET-RSNUM | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | SCHEDULELINEISFIXED | Schedule Line is "Fixed" | EKET-FIXKZ | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | PRODUCTAVAILABILITYDATE | Material Staging/Availability Date | EKET-MBDAT | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | PRODUCTAVAILABILITYTIME | Material Staging Time (Local, Relating to a Plant) | EKET-MBUHR | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | LOADINGDATE | Loading Date | EKET-LDDAT | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | LOADINGTIME | Loading Time (Local Time Relating to a Shipping Point) | EKET-LDUHR | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | TRANSPORTATIONPLANNINGDATE | Transportation Planning Date | EKET-TDDAT | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | TRANSPORTATIONPLANNINGTIME | Transp. Planning Time (Local, Relating to a Shipping Point) | EKET-TDUHR | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | GOODSISSUEDATE | Goods Issue Date | EKET-WADAT | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | GOODSISSUETIME | Time of Goods Issue (Local, Relating to a Plant) | EKET-WAUHR | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | STOLATESTPOSSIBLEGRDATE | Goods Receipt End Date | EKET-ELDAT | Non-time dependent | ||
| 3VR_S2PP2R_PurOrderScheduleLine | STOLATESTPOSSIBLEGRTIME | Goods Receipt End Time (Local, Relating to a Plant) | EKET-ELUHR | Non-time dependent | ||
| 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | SUPLRCSGNMTPPLINEWTHDRWLSTATUS | Status for RKWA entry | RKWA-STATUS | Non-time dependent | ||
| 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | PROFITCENTER | Profit Centre | RKWA-BUKRS | Consignment has PC on the view. For PO it is derived from the PO master data dimension. To bring it togeter in the union, it will need to derived in the view. | Non-time dependent | 2VD_S4HARM_ProfitCenter |
| View | Measure ID | Measure Description | SAP Table-Field Name / process |
|---|---|---|---|
| 3VR_S2PP2R_PurchaseOrderHistory | QUANTITY | Quantity in PO UoM | EKBE-MENGE |
| 3VR_S2PP2R_PurchaseOrderHistory | PURORDAMOUNTINCOMPANYCODECRCY | Amount in Local Currency | EKBE-DMBTR |
| 3VR_S2PP2R_PurchaseOrderHistory | PURCHASEORDERAMOUNT | Amount in Document Currency | EKBE-WRBTR |
| 3VR_S2PP2R_PurchaseOrderHistory | DCM_POGRAmount_CC | PO GR Amount (CC) | |
| 3VR_S2PP2R_PurchaseOrderHistory | QTYINPURCHASEORDERPRICEUNIT | Quantity in PO Price Unit | EKBE-BPMNG |
| 3VR_S2PP2R_PurchaseOrderHistory | GRIRACCTCLRGAMTINCOCODECRCY | GR/IR Clearing value in Local Currency | EKBE-AREWR |
| 3VR_S2PP2R_PurchaseOrderHistory | INVOICEAMTINCOCODECRCY | Invoice Value in Local Currency | EKBE-REEWR |
| 3VR_S2PP2R_PurchaseOrderHistory | INVOICEAMOUNTINFRGNCURRENCY | Invoice Value in Foreign Currency | EKBE-REFWR |
| 3VR_S2PP2R_PurchaseOrderHistory | QUANTITYINDELIVERYQTYUNIT | Quantity in Delivery UoM | EKBE-LSMNG |
| 3VR_S2PP2R_PurchaseOrderHistory | GRIRACCTCLRGAMTINTRANSACCRCY | GR/IR Clearing value in Transaction Currency | EKBE-AREWW |
| 3VR_S2PP2R_PurchaseOrderHistory | QUANTITYINBASEUNIT | Quantity in Base UoM | EKBE-BAMNG |
| 3VR_S2PP2R_PurchaseOrderHistory | GRIRACCTCLRGAMTINORDTRNSACCRCY | GR/IR Clearing value in PO Currency | EKBE-AREWB |
| 3VR_S2PP2R_PurchaseOrderHistory | INVOICEAMTINPURORDTRANSACCRCY | Invoice Value in PO Currency | EKBE-REWRB |
| 3VR_S2PP2R_PurOrderScheduleLine | REQUESTEDQUANTITY | PR Requested Quantity | EBAN-BAMNG |
| 3VR_S2PP2R_PurOrderScheduleLine | ITEMNETAMOUNT | PR Net Amount | EBAN-NETWR |
| 3VR_S2PP2R_PurOrderScheduleLine | DCM_PRAmountEUR | PR Net Amount in EUR | Derived in DSP |
| 3VR_S2PP2R_PurOrderScheduleLine | SCHEDULELINEORDERQUANTITY | PO Quantity | EKET-MENGE |
| 3VR_S2PP2R_PurOrderScheduleLine | ORDERITEMQTYTOBASEQTYDNMNTR | Denominator for Conversion of Order Unit to Base Unit | EKPO-UMREN |
| 3VR_S2PP2R_PurOrderScheduleLine | ORDERITEMQTYTOBASEQTYNMRTR | Numerator for Conversion of Order Unit to Base Unit | EKPO-UMREZ |
| 3VR_S2PP2R_PurOrderScheduleLine | PREVDELIVQTYOFSCHEDULELINE | Previous Quantity (Delivery Schedule Lines) | EKET-AMENG |
| 3VR_S2PP2R_PurOrderScheduleLine | ROUGHGOODSRECEIPTQTY | Quantity of Goods Received | EKET-WEMNG |
| 3VR_S2PP2R_PurOrderScheduleLine | SCHEDULELINEISSUEDQUANTITY | Issued Quantity | EKET-WAMNG |
| 3VR_S2PP2R_PurOrderScheduleLine | STOCKTRANSFERDELIVEREDQUANTITY | Quantity Delivered (Stock Transfer) | EKET-GLMNG |
| 3VR_S2PP2R_PurOrderScheduleLine | SCHEDULELINECOMMITTEDQUANTITY | Committed Quantity | EKET-MNG02 |
| 3VR_S2PP2R_PurOrderScheduleLine | SCHEDULELINEOPENQUANTITY | Quantity Column | CDS Dervied |
| 3VR_S2PP2R_PurOrderScheduleLine | NetPriceAmount | Net Price Amount in Doc Currency | EKPO-NETPR |
| 3VR_S2PP2R_PurOrderScheduleLine | DCM_NetPriceAmountEUR | PO Net Price in EUR | Derived in DSP |
| 3VR_S2PP2R_PurOrderScheduleLine | DCM_POAmount | PO Amount in Doc Currency | Derived in DSP |
| 3VR_S2PP2R_PurOrderScheduleLine | DCM_POAmountEUR | PO Amount in EUR | Derived in DSP |
| 3VR_S2PP2R_PurOrderScheduleLine | DOWNPAYMENTAMOUNT | Down Payment Amount | EKKO-DPAMT |
| 3VR_S2PP2R_PurOrderScheduleLine | DOWNPAYMENTPERCENTAGEOFTOTAMT | Down Payment Percentage | EKKO-DPPCT |
| 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | SUPLRCSGNMTPPLINEWTHDRWLAMOUNT | Consignment Amount Document Currency | RKWA-WRBTR |
| 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl | SUPLRCSGNMTPPLINEWTHDRWLQTY | Consignment Quantity PO Unit | RKWA-BSTMG |
Calculated Measures (Pre-Aggregation Calculations)
| Measure ID | Description | SAP Table-Field Name / process | Comments / Calculation / Formula / Restriction dimensions and values | Aggregation of data | Example SAP field data |
|---|---|---|---|---|---|
| DCM_Counter | Counter | Counter to count records | Constant 1 | SUM | 34 |
3VF_S2PP2R_PurchaseOrderItem
This will be the fact table to be used in the Purchase Order Item Analytical Model.
List of Fields & Associations to master data
| DSP field | Report Field Description | SAP Table–Field Name | Comments / Descriptions | Time relevancy of data | MD Source |
|---|---|---|---|---|---|
| SystemID | Source System | DSP Derived | Constant S4HC or S4HR | Non-time dependent | |
| PURCHASEORDER | Purchasing Document Number | EKPO-EBELN | Non-time dependent | 2VD_S4HARM_PurchaseOrderItem | |
| PURCHASEORDERITEM | Purchasing Document Item | EKPO-EBELP | Non-time dependent | 2VD_S4HARM_PurchaseOrderItem | |
| ISCOMPLETELYDELIVERED | Delivery Completed Indicator | EKPO-ELIKZ | Non-time dependent | ||
| MATERIAL | Material Number | EKPO-MATNR | Non-time dependent | 2VD_S4HARM_Product | |
| PLANT | Plant | EKPO-WERKS | Non-time dependent | 2VD_S4HARM_Plant | |
| PRICINGDOCUMENT | Pricing Document | EKPO-KNUMV | Non-time dependent | ||
| TAXCODE | Tax Code | EKPO-MWSKZ | Non-time dependent | 2VD_S4HARM_TaxCode | |
| DOCUMENTDATE | Document Date | EKPO-BLDAT | Non-time dependent | 2VD_S4HARM_PurchastingDocumentItemCategory | |
| MANUFACTURERMATERIAL | Manufacturer Material | EKPO-EMATNR | Non-time dependent | ||
| ORDERPRICEUNIT | Order Price Unit | EKPO-MEINS | Non-time dependent | ||
| PURCHASEORDERQUANTITYUNIT | Purchase Order Unit of Measure | EKPO-BPRME | Non-time dependent | ||
| BASEUNIT | Base Unit of Measure | EKPO-LAGME | Non-time dependent | ||
| DOCUMENTCURRENCY | Document Currency | EKPO-WAERS | Non-time dependent | 2VD_S4HARM_Plant | |
| COMPANYCODECURRENCY | Company Code Currency | T001-WAERS | Non-time dependent | ||
| PRODUCTTYPECODE | Product Type Group | EKPO-PRODUCTTYPE | Non-time dependent | 2VD_S4HARM_ProductType | |
| ISSTATISTICALITEM | Item is statistical | EKPO-STAPO | Non-time dependent | ||
| ISRETURNSITEM | Returns Item | EKPO-RETPO | Non-time dependent | ||
| GOODSRECEIPTISEXPECTED | Goods Receipt Indicator | EKPO-WEPOS | Non-time dependent | ||
| GOODSRECEIPTISNONVALUATED | Goods Receipt, Non-Valuated | EKPO-WEUNB | Non-time dependent | ||
| ISFINALLYINVOICED | Final Invoice Indicator | EKPO-EREKZ | Non-time dependent | ||
| INVOICEISEXPECTED | Invoice Receipt Indicator | EKPO-REPOS | Non-time dependent | ||
| ACCOUNTASSIGNMENTCATEGORY | Account Assignment Category | EKPO-KNTTP | Non-time dependent | ||
| PURCHASEORDERITEMCATEGORY | PO Item Category | EKPO-PSTYP | Non-time dependent | 2VD_S4HARM_PurchasingItemCategory | |
| PRODUCTGROUP | Material Group | EKPO-MATKL | Non-time dependent | 2VD_S4HARM_ProductGroup | |
| PURGDOCUMENTITEMDELETIONCODE | PO Deletion Indicator | EKPO-ELOEK | Non-time dependent | ||
| SUPPLIER | Supplier | EKKO-LIFNR | Non-time dependent | 2VD_S4HARM_Supplier | |
| PURCHASINGORGANIZATION | Purchasing Organization | EKKO-EKORG | Non-time dependent | 2VD_S4HARM_PurchasingOrganization | |
| PURCHASINGGROUP | Purchasing Group | EKKO-BKGRP | Non-time dependent | 2VD_S4HARM_PurchasingGroup | |
| COMPANYCODE | Company Code | EKPO-BUKRS | Non-time dependent | 2VD_S4HARM_CompanyCode | |
| DCD_TwoThreeWayMatch | Two Three Way Match | DSP Derived | Non-time dependent | ||
| DCD_POPRPriceMisMatch | PO PR Price Mismatch | DSP Derived | Non-time dependent |
| Report Field ID | Report Field Description | SAP Table-Field Name / process | Comments / Calculation / Formula / Restriction dimensions and values | Aggregation of data |
|---|---|---|---|---|
| REQUESTEDQUANTITY | PR Requested Quantity | EBAN-BAMNG | SUM | |
| PURCHASEREQUISITIONPRICE | Price in Purchase Requisition | BAPRE | SUM | |
| ITEMNETAMOUNT | PR Net Amount | EBAN-NETWR | SUM | |
| DCM_PRAmountEUR | PR Net Amount in EUR | Derived in DSP | SUM | |
| OrderQuantity | Quantity in PO Unit | EKPO-MENGE | SUM | |
| NetPriceAmount | Net Price Amount in Doc Currency | EKPO-NETPR | SUM | |
| NetAmount | Net Amount in Doc Currency | EKPO-NETWR | SUM | |
| OrderItemQtyToBaseQtyDnmntr | Denominator | EKPO-UMREN | SUM | |
| OrderItemQtyToBaseQtyNmrtr | Numerator | EKPO-UMREZ | SUM | |
| DOWNPAYMENTAMOUNT | Down Payment Amount | EKKO-DPAMT | SUM | |
| DOWNPAYMENTPERCENTAGEOFTOTAMT | Down Payment Percentage | EKKO-DPPCT | SUM | |
| DCM_NetAmountEUR | PO Net Amount in EUR | Derived in DSP | SUM | |
| DCM_NetPriceAmountEUR | PO Net Price in EUR | Derived in DSP | SUM | |
| DCM_Counter | Counter | Derived in DSP | SUM | |
| DCM_PRPOPriceDifference | PR PO Price Difference | Derived in DSP | SUM |
3VF_S2PS2C_PurchaseContractItem
This will be the fact table to be used in the Purchase Contract Analytical Model.
List of Fields & Associations to master data
| DSP field | Report Field Description | SAP Table–Field Name | Comments / Descriptions | Time relevancy of data | MD Source |
|---|---|---|---|---|---|
| SystemID | Source System | DSP Derived | Constant S4HC or S4HR | Non-time dependent | |
| PURCHASECONTRACT | Purchase Contract | EKPO-EBELN EKAB-KONNR | Non-time dependent | ||
| PURCHASECONTRACTITEM | Item | EKPO-EBELP EKAB-KTPNR | Non-time dependent | ||
| DOCUMENTCURRENCY | Currency | EKPO-WAERS | Non-time dependent | ||
| ORDERQUANTITYUNIT | Order Unit | EKPO-BSTME | Non-time dependent | ||
| STORAGELOCATION | Storage Location | EKPO-LGORT | Non-time dependent | 2VD_S4HARM_StorageLocation | |
| MATERIALGROUP | Material Group | EKPO-MATKL | Non-time dependent | 2VD_S4HARM_ProductGroup | |
| MATERIAL | Material | EKPO-MATNR | Non-time dependent | 2VD_S4HARM_Product | |
| NETPRICEQUANTITY | Price Unit | EKPO-BPRME | Non-time dependent | ||
| PURCHASINGDOCUMENTITEMCATEGORY | Item Category | EKPO-PSTYP | Non-time dependent | 2VD_S4HARM_PurchastingDocumentItemCategory | |
| INVOICEISEXPECTED | Invoice Receipt | EKPO-REPOS | Non-time dependent | ||
| PURCHASECONTRACTITEMTEXT | Short Text | EKPO-TXZ01 | Non-time dependent | ||
| INVOICEISGOODSRECEIPTBASED | GR-Based Inv. Verif. | EKPO-WEBRE | Non-time dependent | ||
| GOODSRECEIPTISEXPECTED | Goods Receipt | EKPO-WEPOS | Non-time dependent | ||
| PLANT | Plant | EKPO-WERKS | Non-time dependent | 2VD_S4HARM_Plant | |
| EVALDRCPTSETTLMTISALLOWED | Eval. Receipt Sett. | EKPO-XERSY | Non-time dependent | ||
| PURCHASECONTRACTTYPE | Purchasing Doc. Type | EKKO-BSART | Non-time dependent | 2VD_S4HARM_PurchasingDocumentType | |
| PURCHASINGDOCUMENTCATEGORY | Purch. Doc. Category | EKKO-BSTYP | Non-time dependent | 2VD_S4HARM_PurchasingDocumentCategory | |
| PURCHASINGGROUP | Purchasing Group | EKKO-BKGRP | Non-time dependent | 2VD_S4HARM_PurchasingGroup | |
| PURCHASINGORGANIZATION | Purch. Organization | EKKO-EKORG | Non-time dependent | 2VD_S4HARM_PurchasingOrganization | |
| VALIDITYSTARTDATE | Validity Per. Start | EKKO-KDATB | Non-time dependent | ||
| VALIDITYENDDATE | Validity Period End | EKKO-KDATE | Non-time dependent | ||
| SUPPLIER | Supplier | EKKO-LIFNR | Non-time dependent | 2VD_S4HARM_Supplier | |
| INVOICINGPARTY | Invoicing Party | EKKO-LIFRE | Non-time dependent | ||
| SUPPLYINGSUPPLIER | Goods Supplier | EKKO-LLIEF | Non-time dependent | 2VD_S4HARM_Supplier | |
| CREATIONDATE | Created On | EKKO-ERDAT | Non-time dependent | ||
| LASTCHANGEDATETIME | Last Changed | EKKO-LASTCHANGEDATETIME | Non-time dependent | ||
| EXCHANGERATE | Exchange Rate | EKKO-WKURS | Non-time dependent | ||
| ORDERPRICEUNIT | Order Price Unit | EKPO-PEINH | Non-time dependent | ||
| VOLUMEUNIT | Volume Unit | EKPO-VOLEH | Non-time dependent | ||
| CUSTOMER | Customer | EKPO-KUNNR | Non-time dependent | 2VD_S4HARM_Customer | |
| SUBCONTRACTOR | Supplier | EKPO-EMLIF | Non-time dependent | 2VD_S4HARM_Supplier | |
| REFERENCEDELIVERYADDRESSID | Reference Delivery Address | EKPO-ADRN2 | Non-time dependent | ||
| MANUALDELIVERYADDRESSID | Address | CDS Derived | Non-time dependent | ||
| DELIVERYADDRESSID | Address | CDS Derived | Non-time dependent | ||
| ACCOUNTASSIGNMENTCATEGORY | Acct Assignment Cat. | EKPO-KNTTP | Non-time dependent | 2VD_S4HARM_AccountAssignmentCategory | |
| MULTIPLEACCTASSGMTDISTRIBUTION | Distrib. Indicator | EKPO-VRTKZ | Non-time dependent | ||
| ORDPRICEUNITTOORDERUNITDNMNTR | Quantity Conversion | EKPO-BPUMN | Non-time dependent | ||
| ORDERPRICEUNITTOORDERUNITNMRTR | Quantity Conversion Numerator | EKPO-BPUMZ | Non-time dependent | ||
| SUPPLIERMATERIALNUMBER | Supplier Mat. No. | EKPO-IDNLF | Non-time dependent | ||
| UNDERDELIVTOLRTDLMTRATIOINPCT | Underdel. Tolerance | EKPO-UNTTO | Non-time dependent | ||
| PRICEISTOBEPRINTED | Print Price | EKPO-PRSDR | Non-time dependent | ||
| SUPPLIERCONFIRMATIONCONTROLKEY | Confirmation Control | EKPO-BSTAE | Non-time dependent | ||
| OVERDELIVTOLRTDLMTRATIOINPCT | Overdeliv. Tolerance | EKPO-UEBTO | Non-time dependent | ||
| UNLIMITEDOVERDELIVERYISALLOWED | Unltd Overdelivery | EKPO-UEBTK | Non-time dependent | ||
| PURGDOCPRICEDATE | Price Date | EKPO-PREDT | Non-time dependent | ||
| PURCHASINGINFORECORDUPDATECODE | Info Record Update | EKPO-SPINF | Non-time dependent | ||
| PURGDOCORDERACKNNUMBER | Order Acknowledgment | EKPO-LABNR | Non-time dependent | ||
| PURCHASINGPRICEISESTIMATED | Estimated Price | EKPO-SCHPR | Non-time dependent | ||
| ISINFOATREGISTRATION | Info At Registration | EKPO-BORGR_MISS | Non-time dependent | ||
| NODAYSREMINDER1 | 1st Reminder/Exped. | EKPO-MAHN1 | Non-time dependent | ||
| NODAYSREMINDER2 | 2nd Reminder/Exped. | EKPO-MAHN2 | Non-time dependent | ||
| NODAYSREMINDER3 | 3rd Reminder/Exped. | EKPO-MAHN3 | Non-time dependent | ||
| STOCKTYPE | Stock Type | EKPO-INSMK | Non-time dependent | 2VD_S4HARM_StockType | |
| TAXCODE | Tax Code | EKPO-MWSKZ | Non-time dependent | 2VD_S4HARM_TaxCode | |
| REQUIREMENTTRACKING | Req. Tracking Number | EKPO-BEDNR | Non-time dependent | ||
| ISORDERACKNRQD | Acknowledgment Reqd. | EKPO-KZABS | Non-time dependent | ||
| SHIPPINGINSTRUCTION | Shipping Instr. | EKPO-EVERS | Non-time dependent | ||
| GOODSRECEIPTISNONVALUATED | GR Non-Valuated | EKPO-WEUNB | Non-time dependent | ||
| SERVICEPERFORMER | Service Performer | EKPO-SERVICEPERFORMER | Non-time dependent | ||
| PRODUCTTYPECODE | Product Type Group | EKPO-PRODUCT_TYPE | Non-time dependent | 2VD_S4HARM_ProductType | |
| MATERIALTYPE | Material Type | EKPO-MTART | Non-time dependent | 2VD_S4HARM_MaterialType | |
| PURCHASECONTRACTITEMFORMATTED | Char15 | EKPO- | Non-time dependent | ||
| PURCHASINGCONTRACTDELETIONCODE | Deletion Indicator | EKKO-LOEKZ | Non-time dependent | ||
| PURCHASECONTRACTITEMUNIQUEID | Document Item | EKPO-UNIQUEID | Non-time dependent | ||
| PURCHASINGCATEGORY | Purchasing Category | /srmsmc/d_puc_rt-ID | Non-time dependent | 2VD_S4HARM_PurchasingCategory | |
| PURGCATNAME | Purchasing Category Name | /srmsmc/d_puc_rt-NAME | Non-time dependent | ||
| COMPANYCODE | Company Code | EKKO-BUKRS | Non-time dependent | 2VD_S4HARM_CompanyCode | |
| INCOTERMSCLASSIFICATION | Incoterms | EKKO-INCO1 | Non-time dependent | ||
| INCOTERMSTRANSFERLOCATION | Incoterms (Part 2) | EKKO-INCO2 | Non-time dependent | ||
| PAYMENTTERMS | Terms of Payment | EKKO-ZTERM | Non-time dependent | 2VD_S4HARM_PaymentTerms | |
| CASHDISCOUNT1DAYS | Days 1 | EKKO-ZBD1T | Non-time dependent | ||
| CASHDISCOUNT2DAYS | Days 2 | EKKO-ZBD2T | Non-time dependent | ||
| NETPAYMENTDAYS | Days Net | EKKO-ZBD3T | Non-time dependent | ||
| CASHDISCOUNT1PERCENT | CD Percentage 1 | EKKO-ZBD1P | Non-time dependent | ||
| CASHDISCOUNT2PERCENT | CD Percentage 2 | EKKO-ZBD2P | Non-time dependent | ||
| PURCHASECONTRACTTARGETAMOUNT | Target Value | EKKO-KTWRT | Non-time dependent | ||
| RELEASECODE | Release indicator | EKKO-FRGKE | Non-time dependent | ||
| CREATEDBYUSER | Created By | EKKO-ERNAM | Non-time dependent | ||
| PURCHASINGDOCUMENTDELETIONCODE | Deletion Indicator | EKKO-LOEKZ | Non-time dependent | ||
| EXCHANGERATEISFIXED | Fixed Exchange Rate | EKKO-KUFIX | Non-time dependent | ||
| QUOTATIONSUBMISSIONDATE | Quotation Date | EKKO-IHRAN | Non-time dependent | ||
| SUPPLIERQUOTATION | Quotation | EKKO-ANGNR | Non-time dependent | ||
| CORRESPNCEXTERNALREFERENCE | Your Reference | EKKO-IHREZ | Non-time dependent | ||
| CORRESPNCINTERNALREFERENCE | Our Reference | EKKO-UNSEZ | Non-time dependent | ||
| SUPPLIERRESPSALESPERSONNAME | Salesperson | EKKO-EVERK | Non-time dependent | ||
| SUPPLIERPHONENUMBER | Supplier Phone | EKKO-TELFN | Non-time dependent | ||
| INCOTERMSVERSION | Incoterms Version | EKKO-INCOV | Non-time dependent | ||
| INCOTERMSLOCATION1 | Incoterms Location 1 | EKKO-INCO2 | Non-time dependent | ||
| INCOTERMSLOCATION2 | Incoterms Location 2 | EKKO-INCO3 | Non-time dependent | ||
| RELEASEISNOTCOMPLETED | Subject to Release | EKKO-FRGRL | Non-time dependent | ||
| SUPPLIERADDRESSID | Address Number | EKKO-ADRNR | Non-time dependent | ||
| RELEASEORDER | Purchasing Document Number | EKAB-EBELN EKBE-EBELN | Non-time dependent | ||
| RELEASEORDERITEM | PO Item | EKAB-EBELP EKBE-EBELP | Non-time dependent | ||
| RELEASEORDERDATE | Release Order Date | EKAB-BEDAT | Non-time dependent | ||
| RELEASEORDERITEMQUANTITYUNIT | Order Unit | EKAB-BSTME | Non-time dependent | ||
| RELEASEORDERCURRENCY | Currency | EKAB-WAERS | Non-time dependent | ||
| TAKEORPAYCLAUSE | Take or Pay Clause | Custom Field | Non-time dependent | ||
| DCD_POContPriceMisMatch | PO Contract Price Mismatch | DSP Derived | Non-time dependent |
| Report Field ID | Report Field Description | SAP Table-Field Name / process | Comments / Calculation / Formula / Restriction dimensions and values | Aggregation of data |
|---|---|---|---|---|
| RELEASEORDERITEMORDERQUANTITY | Order Quantity | EKAB-BSTMG | SUM | |
| RELEASEORDERITEMNETAMOUNT | Net Order Value | EKAB-BWERT | SUM | |
| DCM_InvoicedValuePOCur | Invoiced Value in PO Currency | Calculated in DSP | Exception Aggregation - MAX - Release Order & Release Order Item | MAX |
| DCM_InvoicedQtyPOUnit | Invoiced Qty in PO Unit | Calculated in DSP | Exception Aggregation - MAX - Release Order & Release Order Item | MAX |
| TARGETQUANTITY | Target Quantity | EKPO-KTMNG | Exception Aggregation - MAX - Contract and Contract Item | SUM |
| CONTRACTNETPRICEAMOUNT | Net Order Price | EKPO-BPREI | Exception Aggregation - MAX - Contract and Contract Item | SUM |
| TARGETAMOUNT | OA Target Value | EKPO-ZWERT | Exception Aggregation - MAX - Contract and Contract Item | SUM |
| PURGDOCRELEASEORDERQUANTITY | Stand.Rel.Order.Qty. | EKPO-NORAM | Exception Aggregation - MAX - Contract and Contract Item | SUM |
| TAKEORPAYAMOUNT | Take or Pay Amount | Custom Field | Field details not yet available Exception Aggregation - SUM - Contract ID | SUM |
| DCM_ReleaseOrderNetPrice | Release Order Net Price | DSP Derived | SUM | |
| DCM_Counter | Counter | DSP Derived | SUM | |
| DCM_POContPriceDifference | PO Contract Price Difference | Derived in DSP | SUM |
3VF_S2PP2R_SuplrCsgnmtPplineWithdrwl
This will be the fact table to be used in the Consignment Consumption Model
List of Fields & Associations to master data
| DSP field | Report Field Description | SAP Table–Field Name | Comments / Descriptions | Time relevancy of data | MD Source |
|---|---|---|---|---|---|
| SystemID | Source System | DSP Derived | Constant S4HC or S4HR | Non-time dependent | |
| MATERIALDOCUMENT | Material Document | RKWA-MBLNR | Non-time dependent | ||
| MATERIALDOCUMENTYEAR | Material Doc. Year | RKWA-MJAHR | Non-time dependent | ||
| MATERIALDOCUMENTITEM | Material Doc.Item | RKWA-MBLPO | Non-time dependent | ||
| SUPLRCSGNMTPPLINEWTHDRWLSTATUS | Status for RKWA entry | RKWA-STATUS | Non-time dependent | ||
| DOCUMENTDATE | Document Date | RKWA-BLDAT | Non-time dependent | ||
| POSTINGDATE | Posting Date | RKWA-BUDAT | Non-time dependent | ||
| COMPANYCODE | Company Code | RKWA-BUKRS | Non-time dependent | 2VD_S4HARM_CompanyCode | |
| ISSGORRCVGSTKIDFGSPCLSTKTYPE | Special Stock | RKWA-SOBKZ | Non-time dependent | ||
| CONSIGNMENTPIPELINESUPPLIER | Supplier | RKWA-LIFNR | Non-time dependent | 2VD_S4HARM_Supplier | |
| PLANT | Plant | RKWA-WERKS | Non-time dependent | 2VD_S4HARM_Plant | |
| MATERIAL | Material | RKWA-MATNR | Non-time dependent | 2VD_S4HARM_Product | |
| DEBITCREDITCODE | Debit/Credit Ind. | RKWA-SHKZG | Non-time dependent | 2VD_S4HARM_DebitCreditIndicator | |
| BUSINESSAREA | Business Area | RKWA-GSBER | Non-time dependent | 2VD_S4HARM_BusinessArea | |
| DOCUMENTCURRENCY | Currency | RKWA-WAERS | Non-time dependent | ||
| SUPCSGNMTPPLINEWTHDRWLQTYUNIT | Unit of measure for settlement | RKWA-BSTME | Non-time dependent | ||
| GLACCOUNT | G/L Account | RKWA-HKONT | Non-time dependent | 2VD_S4HARM_GLAccount | |
| TAXCODE | Tax Code | RKWA-MWSKZ | Non-time dependent | 2VD_S4HARM_TaxCode | |
| PROFITCENTER | Profit Center | RKWA-PRCTR | Non-time dependent | 2VD_S4HARM_ProfitCenter | |
| TAXCOUNTRY | Tax Country/Region | RKWA-TAX_COUNTRY | Non-time dependent | 2VD_S4HARM_Country |
| Report Field ID | Report Field Description | SAP Table-Field Name / process | Comments / Calculation / Formula / Restriction dimensions and values | Aggregation of data |
|---|---|---|---|---|
| SUPLRCSGNMTPPLINEWTHDRWLAMOUNT | Amount | WRBTR_CS | SUM | |
| SUPLRCSGNMTPPLINEWTHDRWLQTY | Quantity withdrawn for settlement | MR_BSTMG | SUM | |
| NONDEDUCTIBLEINPUTTAXAMOUNT | Non-deductible | NAVNW | SUM |
3VF_S2PI2P_SupplierInvoiceItem
This will be the fact table to be used in the Supplier Invoice Model
List of Fields & Associations to master data
| DSP field | Report Field Description | SAP Table–Field Name | Comments / Descriptions | Time relevancy of data | MD Source |
|---|---|---|---|---|---|
| SystemID | Source System | DSP Derived | Constant S4HC or S4HR | Non-time dependent | |
| SUPPLIERINVOICE | Document Number | RSEG-BELNR | Non-time dependent | ||
| FISCALYEAR | Fiscal Year | RSEG-GJAHR | Non-time dependent | ||
| SUPPLIERINVOICEITEM | Invoice Item | RSEG-RBLGP | Non-time dependent | ||
| PURCHASEORDERPRICEUNIT | Order Price Unit | RSEG-BPRME | Non-time dependent | ||
| PURCHASEORDERQUANTITYUNIT | Order Unit | RSEG-BSTME | Non-time dependent | ||
| PURCHASEORDER | Purchasing Document | RSEG-EBELN | Non-time dependent | 2VD_S4HARM_PurchaseOrder | |
| PURCHASEORDERITEM | Item | RSEG-EBELP | Non-time dependent | 2VD_S4HARM_PurchaseOrder | |
| PRMTHBREFERENCEDOCUMENT | Reference Document | RSEG-LFBNR | Non-time dependent | ||
| PRMTHBREFERENCEDOCUMENTFSCLYR | Year Current Period | RSEG-LFGJA | Non-time dependent | ||
| PRMTHBREFERENCEDOCUMENTITEM | Reference Doc. Item | RSEG-LFPOS | Non-time dependent | ||
| PURCHASEORDERITEMMATERIAL | Material | RSEG-MATNR | Non-time dependent | 2VD_S4HARM_Product | |
| SUPLRINVCITMHASQUALITYVARIANCE | BlockReason:Quality | RSEG-SPGRC | Non-time dependent | ||
| SUPLRINVCITEMHASORDPRCQTYVARC | Blocking Reason:OPQ | RSEG-SPGRG | Non-time dependent | ||
| SUPLRINVCITEMHASQTYVARIANCE | Blocking Reason: Qty | RSEG-SPGRM | Non-time dependent | ||
| SUPLRINVCITEMHASPRICEVARIANCE | Blocking Reas. Price | RSEG-SPGRP | Non-time dependent | ||
| SUPLRINVCITEMHASOTHERVARIANCE | Manual Block. Reason | RSEG-SPGRQ | Non-time dependent | ||
| SUPLRINVCITEMHASAMOUNTOUTSDTOL | Blkg Reason: Item Amount | RSEG-SPGRS | Non-time dependent | ||
| SUPLRINVCITEMHASDATEVARIANCE | Block. Reason: Date | RSEG-SPGRT | Non-time dependent | ||
| ISSUBSEQUENTDEBITCREDIT | Subseq. Debit/Credit | RSEG-TBTKZ | Non-time dependent | ||
| PLANT | Plant | RSEG-WERKS | Non-time dependent | 2VD_S4HARM_Plant | |
| DOCUMENTCURRENCY | Currency | RBKP-WAERS | Non-time dependent | ||
| DOCUMENTHEADERTEXT | Document Header Text | RBKP-BKTXT | Non-time dependent | ||
| DOCUMENTDATE | Invoice Date | RBKP-INVDT | Non-time dependent | ||
| POSTINGDATE | Posting Date | RBKP-BUDAT | Non-time dependent | ||
| COMPANYCODE | Company Code | RBKP-BUKRS | Non-time dependent | 2VD_S4HARM_CompanyCode | |
| SUPPLIERINVOICEORIGIN | IV category | RBKP-IVTYP | Non-time dependent | 2VD_S4HARM_SupplierInvoiceOrigin | |
| INVOICINGPARTY | Invoicing Party | RBKP-LIFRE | Non-time dependent | 2VD_S4HARM_InvoicingParty | |
| UNPLANNEDDELIVERYCOSTTAXCODE | Tax Code | RBKP-MWSKZ | Non-time dependent | 2VD_S4HARM_TaxCode | |
| REVERSEDOCUMENT | Reversed by | RBKP-STBLG | Non-time dependent | ||
| REVERSEDOCUMENTFISCALYEAR | Year | RBKP-STJAH | Non-time dependent | ||
| SUPPLIERINVOICEIDBYINVCGPARTY | Reference | RBKP-XBLNR | Non-time dependent | 2VD_S4HARM_Supplier | |
| ISINVOICE | Invoice | RBKP-XRECH | Non-time dependent | ||
| SUPPLIERINVOICESTATUS | Invoice doc. status | RBKP-RBSTAT | Non-time dependent | 2VD_S4HARM_SupplierInvoiceStatus | |
| PODOCUMENTDATE | Document Date | EKPO-BLDAT | Non-time dependent | ||
| DCD_LatePO | Late PO Creation | DSP Derived | Non-time dependent |
| Report Field ID | Report Field Description | SAP Table-Field Name / process | Comments / Calculation / Formula / Restriction dimensions and values | Aggregation of data |
|---|---|---|---|---|
| INVOICEGROSSAMOUNT | Gross Invoice Amount | RBKP-RMWWR | SUM | |
| SUPLRINVCMANUALLYREDUCEDAMOUNT | Supplier Error (net) | RBKP-LIEFFN | SUM | |
| QTYINPURCHASEORDERPRICEUNIT | Qty in OPUn | RSEG-BPMNG | SUM | |
| QUANTITYINPURCHASEORDERUNIT | Quantity | RSEG-MENGE | SUM | |
| SUPPLIERINVOICEITEMAMOUNT | Amount | RSEG-WRBTR | SUM | |
| SUPLRINVCAUTOMREDUCEDAMOUNT | Autom.invoice reduct. | RSEG-RKUEN | SUM | |
| UNPLANNEDDELIVERYCOST | Unplanned Del. Costs | RSEG-BEZNK | SUM |
Reporting Layer
4MA_S2PP2R_PurchaseRequisitionItem
Link to FSD (Each Analytic model should have its own FSD).
Include technical details for:
Distinct Count Measures
| 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 |
Calculated Measures
| 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 |
Restricted Measures
| 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 |
Currency Conversions
| Measure ID | Description | SAP Table-Field Name / process | Comments / Calculation / Formula / Restriction dimensions and values | Aggregation of data | Example SAP field data |
| DCM_PRAmount_CC | PR Amount (CC) | Currency Conversion - Source Measure - ITEMNETAMOUNT, Time Reference - CreationDate, Target Currency - Input Parameter (IP_TargetCurr) | SUM | 4500000.45 |
Variables
| 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 | |
| vRTargetCurr | Currency | Mandatory | Single Value | EUR | Restricted measure variable for input parameter IP_TARGETCURR used for currency conversion |
Data access controls
TBD
Outbound Layer
NA