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
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. VBF (Value Base Fee): Intercompany fee charged by Syensqo to other legal entities to remunerate purchasing services. Performance: Created such that the VBF / performance ratio is within an acceptable range at legal entity level.	Total Spend at LE, Service Company Spend, OpCo Spend, Service Company zone and country level spend, VBF, Performance & savings, VBF vs Performance

...

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.

...

Jira Requests Coverage

The models covered under this DDFS will cater towards requirements from the following Jira Requests -

Jira

server	Syensqo's Jira
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	d8efc1ef-48bd-3b4e-8714-ad827f4f059b
key	ERP-1052

Jira

server	Syensqo's Jira
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	d8efc1ef-48bd-3b4e-8714-ad827f4f059b
key	ERP-1861

Jira

server	Syensqo's Jira
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	d8efc1ef-48bd-3b4e-8714-ad827f4f059b
key	ERP-1873

Jira

server	Syensqo's Jira
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	d8efc1ef-48bd-3b4e-8714-ad827f4f059b
key	ERP-2049

Jira

server	Syensqo's Jira
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	d8efc1ef-48bd-3b4e-8714-ad827f4f059b
key	ERP-2061

Jira

server	Syensqo's Jira
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	d8efc1ef-48bd-3b4e-8714-ad827f4f059b
key	ERP-2070

Jira

server	Syensqo's Jira
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	d8efc1ef-48bd-3b4e-8714-ad827f4f059b
key	ERP-2071

Jira

server	Syensqo's Jira
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	d8efc1ef-48bd-3b4e-8714-ad827f4f059b
key	ERP-2062

Jira

server	Syensqo's Jira
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	d8efc1ef-48bd-3b4e-8714-ad827f4f059b
key	ERP-2076

Jira

server	Syensqo's Jira
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	d8efc1ef-48bd-3b4e-8714-ad827f4f059b
key	ERP-2077

Data Flow Diagram

Please note that there is no SAP delivered business content for procurement sourced from S4 system.

draw.io Diagram

border	true

diagramName	DDFS - S2PP2R
simpleViewer	false
width
links	auto
tbstyle	top
lbox	true
diagramWidth	2768
height	1419
revision	38

Table of Contents

maxLevel	2
exclude	Document Links\|Introduction\|Jira Requests Coverage\|Data Flow Diagram

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	1FR_S4HR_S2PP2R_DELTA_2	1FR_S4HC_S2PP2R_DELTA_2
/SYQ/I_PurOrdConfirmationDispute	1FR_S4HR_S2PP2R_DELTA_3	1FR_S4HR_S2PP2R_DELTA_3
/SYQ/I_PurOrdMessages	1FR_S4HR_S2PP2R_DELTA_3	1FR_S4HR_S2PP2R_DELTA_3
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	1FR_S4HR_S2PI2P_DELTA_1	1FR_S4HC_S2PI2P_DELTA_1

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_PurOrdAccountAssignmentDexbefore 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

...

Inbound Layer

No transformations to be applied in the inbound layer.

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.

2VR_S4HARM_C_PurchaseRequisitionItem

Join

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.

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

Filter

Before joining a filter will be applied on 2VR_S4HARM_I_PurReqnAcctAssgmtAPI01 to get only records with Profit Centre populated.

2VR_S4HARM_C_PurchaseOrderItem

Join

Purpose: Join PO Item data with PO Header to create a reusable view for reporting on Purchasing Orders.

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

Join

Purpose: Join PO Contract Item data with PO Contract Header to create a reusable view for reporting on Purchasing Contracts (outline agreements).

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.

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.

**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.

Propagation Layer

3VR_S2PP2R_PurchaseRequisitionItem

Calculation

Calculated measure: DCM_PRAmountEur = ItemNetAmount converted to EUR using the M rates, source currency as PurReqnItemCurrency and CreationDate as date for conversion

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

Calculation

Calculated measure: DCM_NetAmountEur = NetAmount converted to EUR using the M rates and PurchaseOrderDate as date for conversion

Calculated measure: DCM_NetPriceAmountEur = NetPriceAmount converted to EUR using the M rates and PurchaseOrderDate as date for conversion

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

Calculated measure: DCM_POAmountEUR = DCM_NetPriceAmountEUR * 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

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_S2PP2R_POHisAcc

Join

Purpose: etc

Join

Purpose: etc

Join

Purpose: etc

Calculation

Calculated measure: CM_DocItemValue = DocQuantity * CM_PRICE

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 fieldReport Field DescriptionSAP Table–Field NameComments / DescriptionsTime relevancy of dataMD SourceSYSTEMIDSource SystemDSP FieldConstant S4HC or S4HRNon-time dependent
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
PURCHASINGDOCUMENTPurchase order numberEBAN-EBELN

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
2VD

3VR_
S4HARM
S2PP2R_
PurchaseOrderItem
PurOrderScheduleLine
PURCHASINGDOCUMENTITEMPurchase order item numberEBAN-EBELP
SCHEDLINESTSCDELIVERYDATE Statistics-Relevant Delivery Date EKET-SLFDT
Non-time dependent
2VD

3VR_
S4HARM
S2PP2R_
PurchaseOrderItem
PurOrderScheduleLine
PURREQNRELEASESTATUSRequisition Processing State
SCHEDULELINEDELIVERYTIME Delivery Date Time-Spot EKET-UZEIT
EBAN-BANPR

Non-time dependent
PURCHASEREQUISITIONTYPEPurchase Requisition Document TypeEBAN-BSART

3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine BATCH Batch Number EKET-CHARG
Non-time dependent 2VD_S4HARM_
PurchaseDocumentTypePURCHASINGDOCUMENTSUBTYPEControl indicator for purchasing document typeEBAN-BSAKZNon-time dependent
Batch
3VR_S2PP2R_PurOrderScheduleLine PURCHASINGSCHDLNNROFREMINDERS No. of Reminders/Expediters for Schedule Line EKET-MAHNZ
PURCHASINGDOCUMENTITEMCATEGORYItem category in purchasing documentEBAN-PSTYP

Non-time dependent
2VD

3VR_
S4HARM
S2PP2R_
ItemCategoryForPurchasingDocument
PurOrderScheduleLine
PURCHASEREQUISITIONITEMTEXTShort Text
RESERVATION Number of reservation/dependent requirements EKET-RSNUM
EBAN-TXZ01

Non-time dependent
ACCOUNTASSIGNMENTCATEGORYAccount Assignment Category

3VR_S2PP2R_PurOrderScheduleLine SCHEDULELINEISFIXED Schedule Line is "Fixed" EKET-FIXKZ
EBAN-KNTTP

Non-time dependent
2VD

3VR_
S4HARM
S2PP2R_
AccountAssignmentCategory
PurOrderScheduleLine
MATERIAL
PRODUCTAVAILABILITYDATE Material
Number
Staging/Availability Date EKET-MBDAT
EBAN-MATNR

Non-time dependent
2VD

3VR_
S4HARM
S2PP2R_
Product
PurOrderScheduleLine
MATERIALGROUP
PRODUCTAVAILABILITYTIME Material
Group
Staging Time (Local, Relating to a Plant) EKET-MBUHR
EBAN-MATKL

Non-time dependent
2VD

3VR_
S4HARM
S2PP2R_
MaterialGroup
PurOrderScheduleLine
PURCHASINGDOCUMENTCATEGORYPurchasing Document CategoryEBAN-BSTYP
LOADINGDATE Loading Date EKET-LDDAT
Non-time dependent
2VD

3VR_
S4HARM
S2PP2R_
PurchasingDocumentCategory
PurOrderScheduleLine
MATERIALGOODSRECEIPTDURATIONGoods receipt processing time in days
LOADINGTIME Loading Time (Local Time Relating to a Shipping Point) EKET-LDUHR
EBAN-WEBAZ

Non-time dependent
RELEASECODERelease Indicator

3VR_S2PP2R_PurOrderScheduleLine TRANSPORTATIONPLANNINGDATE Transportation Planning Date EKET-TDDAT
EBAN-FRGKZ

Non-time dependent
PURCHASEREQUISITIONRELEASEDATEPurchase Requisition Release DateEBAN-FRGDTNon-time dependentPURCHASINGORGANIZATIONPurchasing OrganizationEBAN-EKORG

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
2VD

3VR_
S4HARM
S2PP2R_
PurchasingOrganization
PurOrderScheduleLine
PURCHASINGGROUPPurchasing GroupEBAN-EKGRP
GOODSISSUETIME Time of Goods Issue (Local, Relating to a Plant) EKET-WAUHR
Non-time dependent
2VD

3VR_
S4HARM
S2PP2R_
PurchasingGroup
PurOrderScheduleLine
PLANTPlantEBAN-WERKS
STOLATESTPOSSIBLEGRDATE Goods Receipt End Date EKET-ELDAT
Non-time dependent
2VD

3VR_
S4HARM
S2PP2R_
Plant
PurOrderScheduleLine
SOURCEOFSUPPLYISASSIGNEDAssigned Source of SupplyEBAN-ZUGBA
STOLATESTPOSSIBLEGRTIME Goods Receipt End Time (Local, Relating to a Plant) EKET-ELUHR
Non-time dependent
SUPPLYINGPLANTSupplying (issuing) plant in case of stock transport order

3VR_S2PP2R_SuplrCsgnmtPplineWthdrwl SUPLRCSGNMTPPLINEWTHDRWLSTATUS Status for RKWA entry RKWA-STATUS
EBAN-RESWK

Non-time dependent
2VD

3VR_
S4HARM
S2PP2R_
Plant
SuplrCsgnmtPplineWthdrwl
PURREQNLIMITCONSUMPTIONAMTConsumption Value for Limit ItemsEBAN-LIMIT_CONSUMPTION_VALUE
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
DELIVERYDATEItem Delivery DateEBAN-LFDATNon-time dependentCREATIONDATERequisition (request) dateEBAN-BADATNon-time dependentPROCESSINGSTATUSProcessing status of purchase requisitionEBAN-STATUNon-time dependentPURCHASINGINFORECORDNumber of purchasing info recordEBAN-INFNRNon-time dependentSUPPLIERDesired VendorEBAN-LIFNRNon-time dependent2VD_S4HARM_SupplierISDELETEDDeletion Indicator in Purchasing DocumentEBAN-LOEKZNon-time dependentFIXEDSUPPLIERFixed VendorEBAN-FLIEFNon-time dependent2VD_S4HARM_SupplierREQUISITIONERNAMEName of requisitioner/requesterEBAN-AFNAMNon-time dependentCREATEDBYUSERName of Person Responsible for Creating the ObjectEBAN-ERNAMNon-time dependentDELIVERYADDRESSIDAddressEBAN-ADRNRNon-time dependentMANUALDELIVERYADDRESSIDManual address number in purchasing document itemEBAN-ADRNRNon-time dependentPURREQNITEMCURRENCYCurrency KeyEBAN-WAERSNon-time dependentMATERIALPLANNEDDELIVERYDURNPlanned Delivery Time in DaysEBAN-PLIFZNon-time dependentDELIVDATECATEGORYCategory of delivery dateEBAN-LPEINNon-time dependentMULTIPLEACCTASSGMTDISTRIBUTIONDistribution Indicator for Multiple Account AssignmentEBAN-VRTKZNon-time dependentSTORAGELOCATIONStorage LocationEBAN-LGORTNon-time dependent2VD_S4HARM_StorageLocationPURREQNSSPREQUESTORRequestorEBAN-SC_REQUESTORNon-time dependentPURREQNSSPAUTHORAuthor of RequisitionEBAN-SC_AUTHORNon-time dependentPURCHASECONTRACTNumber of principal purchase agreementEBAN-KONNRNon-time dependentPURREQNSOURCEOFSUPPLYTYPEPurchasing Document CategoryEBAN-BSTYPNon-time dependent2VD_S4HARM_PurchasingDocumentCategoryPURCHASECONTRACTITEMItem Number of Principal Purchase AgreementEBAN-KTPNRNon-time dependentCONSUMPTIONPOSTINGConsumption postingEBAN-KZVBRNon-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

PURREQNORIGINCreation indicator (purchase requisition/schedule lines)EBAN-ESTKZNon-time dependentPURREQNSSPCATALOGITEMCatalog Item IdEBAN-SC_CATALOGITEMNon-time dependentPURREQNSSPCROSSCATALOGITEMCatalog Item KeyEBAN-SC_SR_ITEM_KEYNon-time dependentISPURREQNBLOCKEDPurchase Requisition BlockedEBAN-BLCKDNon-time dependentITEMDELIVERYADDRESSIDNumber of delivery addressEBAN-ADRN2Non-time dependentISCLOSEDPurchase requisition closedEBAN-EBAKZNon-time dependentRELEASEISNOTCOMPLETEDRelease Not Yet Completely EffectedEBAN-FRGRLNon-time dependentSERVICEPERFORMERService PerformerEBAN-SERVICEPERFORMERNon-time dependentPRODUCTTYPEProduct TypeEBAN-PRODUCTTYPENon-time dependent2VD_S4HARM_ProductTypePURCHASEREQUISITIONSTATUSRelease StateEBAN-FRGZUNon-time dependentRELEASESTRATEGYRelease strategy in the purchase requisitionEBAN-FRGSTNon-time dependentCOMPANYCODECompany CodeEBAN-BUKRSNon-time dependent2VD_S4HARM_CompanyCodeSUPPLIERMATERIALNUMBERMaterial Number Used by SupplierEBAN-IDNLFNon-time dependentBATCHBatch NumberEBAN-CHARGNon-time dependent2VD_S4HARM_BatchMINREMAININGSHELFLIFEMinimum Remaining Shelf LifeEBAN-MHDRZNon-time dependentGOODSRECEIPTISEXPECTEDGoods Receipt IndicatorEBAN-WEPOSNon-time dependentINVOICEISEXPECTEDInvoice Receipt IndicatorEBAN-REPOSNon-time dependentGOODSRECEIPTISNONVALUATEDGoods Receipt, Non-ValuatedEBAN-WEUNBNon-time dependentREQUIREMENTTRACKINGRequirement Tracking NumberEBAN-BEDNRNon-time dependentMRPCONTROLLERMRP ControllerEBAN-DISPONon-time dependentTAXCODETax on sales/purchases codeEBAN-MWSKZ
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_
TaxCode
PurchaseOrderItem
PURCHASEREQUISITIONISFIXEDPurchase requisition is fixedEBAN-FIXKZ
ISCOMPLETELYDELIVERED Delivery Completed Indicator EKPO-ELIKZ
Non-time dependent
ADDRESSIDManual address number in purchasing document item

MATERIAL Material Number EKPO-MATNR
EBAN-ADRNR

Non-time dependent
LASTCHANGEDATETIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
2VD_S4HARM_Product
PLANT Plant EKPO-WERKS
EBAN-LASTCHANGEDDATETIME

Non-time dependent
PROCUREMENTHUBSOURCESYSTEMConnected System IDEBAN-EXT_BE_SOURCE_SYS
2VD_S4HARM_Plant
PRICINGDOCUMENT Pricing Document EKPO-KNUMV
Non-time dependent
PROFITCENTER

TAXCODE
Profit Centre
Tax Code
EBAN
EKPO-
PRCTR
MWSKZ
Non-time dependent 2VD_S4HARM
_ProfitCenterBASEUNITPurchase requisition unit of measureEBAN-MEINSNon-time dependentISPURREQNCMPLTPurchase Requisition not yet Complete
_TaxCode
DOCUMENTDATE Document Date EKPO-BLDAT
EBAN-MEMORY

Non-time dependent
PURREQNITEMBLOCKINGREASONTEXTReason for Item Block
2VD_S4HARM_PurchastingDocumentItemCategory
MANUFACTURERMATERIAL Manufacturer Material EKPO-EMATNR
EBAN-BLCKT

Non-time dependent
INVENTORYSPECIALSTOCKTYPESpecial Stock Indicator

ORDERPRICEUNIT Order Price Unit EKPO-MEINS
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,


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

Union ViewDSP fieldReport Field DescriptionSAP Table–Field NameComments / DescriptionsTime relevancy of dataMD Source3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlSystemIDSource SystemDSP DerivedConstant S4HC or S4HRNon-time dependent3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLinePURCHASEORDERPurchasing Document NumberEKBE-EBELN, EKET-EBELNNon-time dependent2VD_S4HARM_PurchaseOrderItem3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLinePURCHASEORDERITEMPurchasing Document ItemEKBE-EBELP, EKET-EBELPNon-time dependent2VD_S4HARM_PurchaseOrderItem3VR_S2PP2R_PurOrderScheduleLinePURCHASEORDERSCHEDULELINEDelivery Schedule Line CounterEKET-EETENNon-time dependent3VR_S2PP2R_PurchaseOrderHistoryPURCHASINGHISTORYDOCUMENTTYPETransaction TypeEKBE-VGABEIndicates what kind of activity occurred for a purchase order, such as Goods Receipt or Invoice ReceiptNon-time dependent3VR_S2PP2R_PurchaseOrderHistory,
3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlPURCHASINGHISTORYDOCUMENTYEARMaterial Document YearEKBE-MJAHR
RKWA-MJAHRNon-time dependent3VR_S2PP2R_PurchaseOrderHistory,
3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlPURCHASINGHISTORYDOCUMENTNumber of Material DocumentEKBE-MBLNR
RKWA-MBLNRNon-time dependent3VR_S2PP2R_PurchaseOrderHistory,
3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlPURCHASINGHISTORYDOCUMENTITEMItem in Material DocumentEKBE-MBLPO
RKWA-MBLPONon-time dependent3VR_S2PP2R_PurchaseOrderHistoryPURCHASINGHISTORYCATEGORYPurchase Order History CategoryEKBE-BEWTPNon-time dependent3VR_S2PP2R_PurchaseOrderHistoryGOODSMOVEMENTTYPEMovement TypeEKBE-BWART

Non-time dependent 2VD_S4HARM_
MovementType
CompanyCode
3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlPOSTINGDATEPosting DateEKBE-BUDAT
RKWA-BUDAT
EKET-EINDT
DCD_TwoThreeWayMatch Two Three Way Match DSP Derived
Non-time dependent
3VR

DCD_
S2PP2R_PurchaseOrderHistoryCURRENCYCurrency KeyEKBE-WAERS, EKET-WAERS
POPRPriceMisMatch PO PR Price Mismatch DSP Derived
Non-time dependent
3VR_S2PP2R_PurchaseOrderHistory,
3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlDEBITCREDITCODEDebit /Credit IndicatorEKBE-SHKZG
RKWA-SHKZGNon-time dependent2VD_S4HARM_DebitCreditIndicator3VR_S2PP2R_PurchaseOrderHistoryREFERENCEDOCUMENTFISCALYEARReference Document Fiscal YearEKBE-LFBJANon-time dependent3VR_S2PP2R_PurchaseOrderHistoryREFERENCEDOCUMENTReference Document NumberEKBE-LFBNRNon-time dependent3VR_S2PP2R_PurchaseOrderHistoryREFERENCEDOCUMENTITEMReference Document ItemEKBE-LFPOSNon-time dependent3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlMATERIALMaterial NumberEKBE-MATNR, EKPO-MATNR
RKWA-MATNRNon-time dependent2VD_S4HARM_Product3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlPLANTPlantEKBE-WERKS, EKPO-WERKS
RKWA-WERKSNon-time dependent2VD_S4HARM_Plant3VR_S2PP2R_PurchaseOrderHistoryINVENTORYVALUATIONTYPEValuation TypeEKBE-BWTARNon-time dependent3VR_S2PP2R_PurchaseOrderHistoryDOCUMENTREFERENCEIDReference Document NumberEKBE-XBLNRNon-time dependent3VR_S2PP2R_PurchaseOrderHistoryDELIVERYQUANTITYUNITDelivery Note UoMEKBE-LSMEHNon-time dependent3VR_S2PP2R_PurchaseOrderHistoryACCOUNTINGDOCUMENTCREATIONDATEAccounting Document Created DateEKBE-CPUDTNon-time dependent3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlORDERPRICEUNITOrder Price UnitEKPO-MEINS
RKWA-MEINSNon-time dependent3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLinePURCHASEORDERQUANTITYUNITPurchase Order Unit of MeasureEKPO-BPRMENon-time dependent3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLineBASEUNITBase Unit of MeasureEKPO-LMEINNon-time dependent3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlDOCUMENTCURRENCYDocument CurrencyEKBE-WAERS, EKPO-WAERS
RKWA-WAERSNon-time dependent3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLinePURCHASEORDERITEMCATEGORYPO Item CategoryEKPO-PSTYPNon-time dependent2VD_S4HARM_PurchaseOrderItemCategory3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLinePRODUCTGROUPMaterial GroupEKPO-MATKLNon-time dependent2VD_S4HARM_ProductGroup3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlSUPPLIERSupplierEKKO-LIFNR
RKWA-LIFNRNon-time dependent2VD_S4HARM_Supplier3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLinePURCHASINGORGANIZATIONPurchasing Organization

Report Field ID	Report Field Description	SAP Table-Field Name / process	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
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

EKKO-EKORG

Non-time dependent 2VD_S4HARM_
PurchasingOrganization3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLinePURCHASINGGROUPPurchasing Group
StorageLocation
MATERIALGROUP Material Group EKPO-MATKL
EKKO-BKGRP

Non-time dependent 2VD_S4HARM_
PurchasingGroup3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLine, 3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlCOMPANYCODECompany Code
ProductGroup
MATERIAL Material EKPO-MATNR
EKBE-BUKRS, EKPO-BUKRS
RKWA-BUKRS

Non-time dependent 2VD_S4HARM_
CompanyCode3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLinePURCHASEREQUISITIONPurchase Requisition Number
Product
NETPRICEQUANTITY Price Unit EKPO-BPRME
EBAN-BANFN

Non-time dependent
3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLinePURCHASEREQUISITIONITEMItem number of purchase requisition

PURCHASINGDOCUMENTITEMCATEGORY Item Category EKPO-PSTYP
EBAN-BNFPO

Non-time dependent
3VR
2VD_
S2PP2R
S4HARM_
PurOrderScheduleLine
PurchastingDocumentItemCategory
DCD_TwoThreeWayMatchTwo Three Way MatchDSP DerivedDerived in 3VR_S2PP2R_PurchaseOrderItem
INVOICEISEXPECTED Invoice Receipt EKPO-REPOS
Non-time dependent
3VR_S2PP2R_PurOrderScheduleLineSCHEDULELINEDELIVERYDATEItem Delivery DateEKET-EINDT

PURCHASECONTRACTITEMTEXT Short Text EKPO-TXZ01
Non-time dependent
3VR_S2PP2R_PurOrderScheduleLineSCHEDLINESTSCDELIVERYDATEStatistics-Relevant Delivery Date

INVOICEISGOODSRECEIPTBASED GR-Based Inv. Verif. EKPO-WEBRE
EKET-SLFDT

Non-time dependent
3VR_S2PP2R_PurOrderScheduleLineSCHEDULELINEDELIVERYTIMEDelivery Date Time-SpotEKET-UZEIT

GOODSRECEIPTISEXPECTED Goods Receipt EKPO-WEPOS
Non-time dependent
3VR_S2PP2R_PurchaseOrderHistory, 3VR_S2PP2R_PurOrderScheduleLineBATCHBatch Number

PLANT Plant EKPO-WERKS
EKET-CHARG

Non-time dependent 2VD_S4HARM_
Batch3VR_S2PP2R_PurOrderScheduleLinePURCHASINGSCHDLNNROFREMINDERSNo. of Reminders/Expediters for Schedule Line
Plant
EVALDRCPTSETTLMTISALLOWED Eval. Receipt Sett. EKPO-XERSY
EKET-MAHNZ

Non-time dependent
3VR_S2PP2R_PurOrderScheduleLineRESERVATIONNumber of reservation/dependent requirements

PURCHASECONTRACTTYPE Purchasing Doc. Type EKKO-BSART
EKET-RSNUM

Non-time dependent
3VR
2VD_
S2PP2R
S4HARM_
PurOrderScheduleLine
PurchasingDocumentType
SCHEDULELINEISFIXEDSchedule Line is "Fixed"
PURCHASINGDOCUMENTCATEGORY Purch. Doc. Category EKKO-BSTYP
EKET-FIXKZ

Non-time dependent
3VR
2VD_
S2PP2R
S4HARM_
PurOrderScheduleLine
PurchasingDocumentCategory
PRODUCTAVAILABILITYDATEMaterial Staging/Availability Date
PURCHASINGGROUP Purchasing Group EKKO-BKGRP
EKET-MBDAT

Non-time dependent
3VR
2VD_
S2PP2R
S4HARM_
PurOrderScheduleLine
PurchasingGroup
PRODUCTAVAILABILITYTIMEMaterial Staging Time (Local, Relating to a Plant)
PURCHASINGORGANIZATION Purch. Organization EKKO-EKORG
EKET-MBUHR

Non-time dependent
3VR
2VD_
S2PP2R
S4HARM_
PurOrderScheduleLine
PurchasingOrganization
LOADINGDATELoading Date
VALIDITYSTARTDATE Validity Per. Start EKKO-KDATB
EKET-LDDAT

Non-time dependent
3VR_S2PP2R_PurOrderScheduleLineLOADINGTIMELoading Time (Local Time Relating to a Shipping Point)

VALIDITYENDDATE Validity Period End EKKO-KDATE
EKET-LDUHR

Non-time dependent
3VR_S2PP2R_PurOrderScheduleLineTRANSPORTATIONPLANNINGDATETransportation Planning Date

SUPPLIER Supplier EKKO-LIFNR
EKET-TDDAT

Non-time dependent
3VR
2VD_
S2PP2R
S4HARM_
PurOrderScheduleLine
Supplier
TRANSPORTATIONPLANNINGTIMETransp. Planning Time (Local, Relating to a Shipping Point)
INVOICINGPARTY Invoicing Party EKKO-LIFRE
EKET-TDUHR

Non-time dependent
3VR_S2PP2R_PurOrderScheduleLineGOODSISSUEDATE

SUPPLYINGSUPPLIER Goods
Issue Date
Supplier
EKET
EKKO-
WADAT
LLIEF
Non-time dependent
3VR
2VD_
S2PP2R
S4HARM_
PurOrderScheduleLine
Supplier
GOODSISSUETIMETime of Goods Issue (Local, Relating to a Plant)EKET-WAUHRNon-time dependent
CREATIONDATE Created On EKKO-ERDAT
Non-time dependent
LASTCHANGEDATETIME Last Changed EKKO-LASTCHANGEDATETIME
3VR_S2PP2R_PurOrderScheduleLineSTOLATESTPOSSIBLEGRDATEGoods Receipt End DateEKET-ELDAT

Non-time dependent
3VR_S2PP2R_PurOrderScheduleLineSTOLATESTPOSSIBLEGRTIMEGoods Receipt End Time (Local, Relating to a Plant)

EXCHANGERATE Exchange Rate EKKO-WKURS
EKET-ELUHR

Non-time dependent
3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlSUPLRCSGNMTPPLINEWTHDRWLSTATUSStatus for RKWA entry

ORDERPRICEUNIT Order Price Unit EKPO-PEINH
RKWA-STATUS

Non-time dependent
3VR_S2PP2R_SuplrCsgnmtPplineWthdrwlPROFITCENTERProfit CentreRKWA-BUKRSConsignment 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.

VOLUMEUNIT Volume Unit EKPO-VOLEH
Non-time dependent
CUSTOMER Customer EKPO-KUNNR
Non-time dependent 2VD_S4HARM_
ProfitCenterView
Customer
SUBCONTRACTOR 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)

...

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

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

EKPO-INSMKStockTypeEKPO-MWSKZTaxCodeEKPO-BEDNREKPO-KZABSEKPO-EVERSEKPO-WEUNBEKPO-SERVICEPERFORMEREKPO-PRODUCT_TYPEProductTypeEKPO-MTARTMaterialTypeEKKO-INCO1

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

Non-time dependent

2VD_S4HARM_

Product

TAXCODE

Tax Code

DEBITCREDITCODE

Debit/Credit Ind.

RKWA-SHKZG

Non-time dependent

2VD_S4HARM_

DebitCreditIndicator

REQUIREMENTTRACKING

Req. Tracking Number

BUSINESSAREA

Business Area

RKWA-GSBER

Non-time dependent

ISORDERACKNRQD

Acknowledgment Reqd.

2VD_S4HARM_BusinessArea

DOCUMENTCURRENCY

Currency

RKWA-WAERS

Non-time dependent

SHIPPINGINSTRUCTION

Shipping Instr.

SUPCSGNMTPPLINEWTHDRWLQTYUNIT

Unit of measure for settlement

RKWA-BSTME

Non-time dependent

GOODSRECEIPTISNONVALUATED

GR Non-Valuated

GLACCOUNT

G/L Account

RKWA-HKONT

Non-time dependent

SERVICEPERFORMER

Service Performer

2VD_S4HARM_GLAccount

TAXCODE

Tax Code

RKWA-MWSKZ

Non-time dependent

PRODUCTTYPECODE

Product Type Group

2VD_S4HARM_TaxCode

PROFITCENTER

Profit Center

RKWA-PRCTR

Non-time dependent

2VD_S4HARM_

ProfitCenter

MATERIALTYPE

Material Type

TAXCOUNTRY

Tax Country/Region

RKWA-TAX_COUNTRY

Non-time dependent

2VD_S4HARM_

Country

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

Report Field ID	Report Field Description	SAP Table-Field Name / process	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

EKKO-INCO2EKKO-ZTERMEKKO-ZBD1TCASHDISCOUNT2DAYSDays 2EKKOZBD2TNETPAYMENTDAYSDays NetEKKOZBD3TEKKO-ZBD1PEKKO-ZBD2PEKKO-KTWRTEKKO-FRGKECREATEDBYUSERCreated ByEKKOERNAMEKKO-LOEKZEKKO-KUFIXEKKO-IHRANEKKO-ANGNREKKO-IHREZEKKO-UNSEZEKKO-EVERKEKKO-TELFNINCOTERMSVERSIONIncoterms VersionEKKOINCOVEKKO-INCO2EKKO-INCO3EKKO-FRGRLSUPPLIERADDRESSIDAddress NumberEKKOADRNREKAB-EBELN
EKBE-EBELNEKAB-EBELP
EKBE-EBELPEKAB-BEDATEKAB-BSTMEEKAB-WAERS

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	INCOTERMSTRANSFERLOCATION	Incoterms (Part 2)
FISCALYEAR	Fiscal Year	RSEG-GJAHR			Non-time dependent	PAYMENTTERMS	Terms of Payment
SUPPLIERINVOICEITEM	Invoice Item	RSEG-RBLGP		Non-time dependent	2VD_S4HARM_PaymentTerms	CASHDISCOUNT1DAYS	Days 1
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	CASHDISCOUNT1PERCENT	CD Percentage 1	2VD_S4HARM_PurchaseOrder
PURCHASEORDERITEM	Item	RSEG-EBELP		Non-time dependent	CASHDISCOUNT2PERCENT	CD Percentage 2		2VD_S4HARM_PurchaseOrder
PRMTHBREFERENCEDOCUMENT	Reference Document	RSEG-LFBNR			Non-time dependent	PURCHASECONTRACTTARGETAMOUNT	Target Value
PRMTHBREFERENCEDOCUMENTFSCLYR	Year Current Period	RSEG-LFGJA		Non-time dependent	RELEASECODE	Release indicator
PRMTHBREFERENCEDOCUMENTITEM	Reference Doc. Item	RSEG-LFPOS			Non-time dependent
PURCHASEORDERITEMMATERIAL	Material	RSEG-	MATNR		Non-time dependent	PURCHASINGDOCUMENTDELETIONCODE	Deletion Indicator		2VD_S4HARM_Product
SUPLRINVCITMHASQUALITYVARIANCE	BlockReason:Quality	RSEG-SPGRC		Non-time dependent	EXCHANGERATEISFIXED	Fixed Exchange Rate
SUPLRINVCITEMHASORDPRCQTYVARC	Blocking Reason:OPQ	RSEG-SPGRG			Non-time dependent	QUOTATIONSUBMISSIONDATE	Quotation Date
SUPLRINVCITEMHASQTYVARIANCE	Blocking Reason: Qty	RSEG-SPGRM		Non-time dependent	SUPPLIERQUOTATION	Quotation
SUPLRINVCITEMHASPRICEVARIANCE	Blocking Reas. Price	RSEG-SPGRP			Non-time dependent	CORRESPNCEXTERNALREFERENCE	Your Reference
SUPLRINVCITEMHASOTHERVARIANCE	Manual Block. Reason	RSEG-SPGRQ		Non-time dependent	CORRESPNCINTERNALREFERENCE	Our Reference
SUPLRINVCITEMHASAMOUNTOUTSDTOL	Blkg Reason: Item Amount	RSEG-SPGRS			Non-time dependent	SUPPLIERRESPSALESPERSONNAME	Salesperson
SUPLRINVCITEMHASDATEVARIANCE	Block. Reason: Date	RSEG-SPGRT		Non-time dependent	SUPPLIERPHONENUMBER	Supplier Phone
ISSUBSEQUENTDEBITCREDIT	Subseq. Debit/Credit	RSEG-TBTKZ			Non-time dependent
PLANT	Plant	RSEG-	WERKS		Non-time dependent	INCOTERMSLOCATION1	Incoterms Location 1		2VD_S4HARM_Plant
DOCUMENTCURRENCY	Currency	RBKP-WAERS		Non-time dependent	INCOTERMSLOCATION2	Incoterms Location 2
DOCUMENTHEADERTEXT	Document Header Text	RBKP-BKTXT			Non-time dependent	RELEASEISNOTCOMPLETED	Subject to Release
DOCUMENTDATE	Invoice Date	RBKP-INVDT		Non-time dependent
POSTINGDATE	Posting Date	RBKP-	BUDAT		Non-time dependent	RELEASEORDER	Purchasing Document Number	dependent
COMPANYCODE	Company Code	RBKP-BUKRS			Non-time dependent	RELEASEORDERITEM	PO Item	2VD_S4HARM_CompanyCode
SUPPLIERINVOICEORIGIN	IV category	RBKP-IVTYP		Non-time dependent	RELEASEORDERDATE	Release Order Date	2VD_S4HARM_SupplierInvoiceOrigin
INVOICINGPARTY	Invoicing Party	RBKP-LIFRE			Non-time dependent	RELEASEORDERITEMQUANTITYUNIT	Order Unit		2VD_S4HARM_InvoicingParty
UNPLANNEDDELIVERYCOSTTAXCODE	Tax Code	RBKP-MWSKZ		Non-time dependent	RELEASEORDERCURRENCY	Currency	2VD_S4HARM_TaxCode
REVERSEDOCUMENT	Reversed by	RBKP-STBLG			Non-time dependent
REVERSEDOCUMENTFISCALYEAR	Year	RBKP-STJAH	TAKEORPAYCLAUSE	Take or Pay Clause	Custom Field		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

3VF_S2PP2R_SuplrCsgnmtPplineWithdrwl

This will be the fact table to be used in the Consignment Consumption Model

...


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

...

May 08, 2026	Actor	Type	Activity	Version
Revision in progress	DIGHE-ext, Shashank	Edit	updated the page at 10:11 am
Revision in progress	DIGHE-ext, Shashank	State	changed state to Revision in progress at 9:30 am	v62
Approved	DIGHE-ext, Shashank	Edit	updated the page at 9:30 am
Apr 29, 2026
	WENNINGER-ext, Sascha	State	changed state to Approved at 6:48 am	v61
Lead Approval	WENNINGER-ext, Sascha	State	gave POD Lead Review approval at 6:48 am
	SHEPHERD-ext, Robert	State	changed expiry date to '06 May, 2026 06:46 am' at 6:46 am
	SHEPHERD-ext, Robert	State	changed state to Lead Approval at 6:46 am	v61


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

Batch
3VR_S2PP2R_PurOrderScheduleLine	PURCHASINGSCHDLNNROFREMINDERS	No. of Reminders/Expediters for Schedule Line	EKET-MAHNZ


3VR_S2PP2R_PurOrderScheduleLine	SCHEDULELINEISFIXED	Schedule Line is "Fixed"	EKET-FIXKZ


3VR_S2PP2R_PurOrderScheduleLine	TRANSPORTATIONPLANNINGDATE	Transportation Planning Date	EKET-TDDAT


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

2VD_S4HARM_Plant
PRICINGDOCUMENT	Pricing Document	EKPO-KNUMV		Non-time dependent

2VD_S4HARM_PurchastingDocumentItemCategory
MANUFACTURERMATERIAL	Manufacturer Material	EKPO-EMATNR

Workflow history

Space shortcuts

Page tree

Page History

Versions Compared

Old Version 36

New Version Current

Key

Source System Extractors

Jira Requests Coverage

Data Flow Diagram

Source System Extractors

Inbound Layer

Replication Flows

Harmonisation Layer

2TL* Tables

1TL_CNTROL_POACTIVITIESMAPPING

Purpose

2VR_S4HARM_C_PurchaseRequisitionItem

Purpose

Join

Projection

Filter

Calculation

Filter

2VR_S4HARM_C_PurchaseOrderItem

Purpose

Join

Projection

Calculation

2VR_S4HARM_C_PurchaseContractItem

Purpose

Join

Projection

2VR_S4HARM_C_SupplierInvoiceItem

Purpose

Join

2VD_S4HARM_PurchaseOrderItem

Projection

Filter

Calculation

Filter

Other 2VR* Relational Views

Transformation Flows

Propagation Layer

3VR_S2PP2R_PurchaseRequisitionItem

3VR_S2PP2R_PurchaseOrderItem

Join

Join

Calculation

3VR_S2PP2R_PurchaseOrderHistory

3VR_S2PP2R_PurOrdScheduleLine

Join

Calculation

3VR_S2PS2C_PurchaseContractItem

Join 1

Join 2

Calculation

3VR_S2PP2R_SuplrCsgnmtPplineWithdrwl

Calculation

3VR_S2PI2P_SupplierInvoiceItem

Join

Calculation

3VF_S2PP2R_PurchaseRequisitionItem

List of Fields & Associations to master data

Calculated Measures (Pre-Aggregation Calculations)

3VF_S2PP2R_PurOrderItemSchdHist

Union

Inbound Layer

Harmonisation Layer

2TL* Tables

2VR_S4HARM_C_PurchaseRequisitionItem

Join

Filter

2VR_S4HARM_C_PurchaseOrderItem

Join

Projection

Calculation

2VR_S4HARM_C_PurchaseContractItem

Join

**Other 2VR* Relational Views**

**2TL* Tables**

**Other 2VR* Relational Views**