What is C_PurchaseOrderHistoryDEX in SAP S/4HANA?

C_PurchaseOrderHistoryDEX is a consumption CDS view in SAP S/4HANA. Data Extraction for Purchase Order History It contains 80 fields.

Which tables does C_PurchaseOrderHistoryDEX read from?

C_PurchaseOrderHistoryDEX reads data from: I_PurchaseOrderHistoryAPI01.

What VDM layer is C_PurchaseOrderHistoryDEX?

C_PurchaseOrderHistoryDEX is classified as a Consumption view optimized for specific business scenarios and reporting.

C_PurchaseOrderHistoryDEX

DDL: C_PURCHASEORDERHISTORYDEX SQL: CMMPURORDHIST Type: view CONSUMPTION

80 Fields 1 Data Sources

Data Extraction for Purchase Order History

C_PurchaseOrderHistoryDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

PurchaseOrderHistory · Sourcing & Procurement

C_PurchaseOrderHistoryDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction for Purchase Order History" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderHistoryAPI01) and exposes 80 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber, PurchasingHistoryDocumentType, PurchasingHistoryDocumentYear.

SAP API Hub

State	C1
Line of Business	Sourcing & Procurement
Application Component	MM-PUR-ANA
Capabilities	Data Source for Data Extraction
Package	Sourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_PurchaseOrderHistoryAPI01	I_PurchaseOrderHistoryAPI01	from

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	CMMPURORDHIST	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
EndUserText.label	Data Extraction for Purchase Order History	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.supportedCapabilities	#EXTRACTION_DATA_SOURCE	view
VDM.viewType	#CONSUMPTION	view
Metadata.ignorePropagatedAnnotations	true	view
Analytics.dataCategory	#FACT	view
Analytics.dataExtraction.enabled	true	view

Fields (80)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseOrder		PurchaseOrder	Purchasing Document Number
KEY	PurchaseOrderItem		PurchaseOrderItem	Item Number of Purchase Order
KEY	AccountAssignmentNumber		AccountAssignmentNumber	Sequential Number of Account Assignment
KEY	PurchasingHistoryDocumentType		PurchasingHistoryDocumentType	Transaction/event type, purchase order history
KEY	PurchasingHistoryDocumentYear		PurchasingHistoryDocumentYear	Material Document Year
KEY	PurchasingHistoryDocument		PurchasingHistoryDocument	Number of Material Document
KEY	PurchasingHistoryDocumentItem		PurchasingHistoryDocumentItem	Item in Material Document
	PurchasingHistoryCategory		PurchasingHistoryCategory	Purchase Order History Category
	GoodsMovementType		GoodsMovementType	Movement Type (Inventory Management)
	PostingDate		PostingDate	Posting Date in the Document
	Currency		Currency	Valuation Crcy
	DebitCreditCode		DebitCreditCode	Debit/Credit Indicator
	IsCompletelyDelivered		IsCompletelyDelivered	"Delivery Completed" Indicator
	ReferenceDocumentFiscalYear		ReferenceDocumentFiscalYear	Fiscal Year of a Reference Document
	ReferenceDocument		ReferenceDocument	Document No. of a Reference Document
	ReferenceDocumentItem		ReferenceDocumentItem	Item of a Reference Document
	Material		Material	Material Number
	Plant		Plant	Valuation Area
	RvslOfGoodsReceiptIsAllowed		RvslOfGoodsReceiptIsAllowed	Reversal of GR allowed for GR-based IV despite invoice
	PricingDocument		PricingDocument	Number of the Document Condition
	TaxCode		TaxCode	Tax on sales/purchases code
	DocumentDate		DocumentDate	Document Date in Document
	InventoryValuationType		InventoryValuationType	Valuation Type
	DocumentReferenceID		DocumentReferenceID	Reference Document Number
	DeliveryQuantityUnit		DeliveryQuantityUnit	Unit of Measure From Delivery Note
	ManufacturerMaterial		ManufacturerMaterial	Material Number Corresponding to Manufacturer Part Number
	AccountingDocumentCreationDate		AccountingDocumentCreationDate	Day On Which Accounting Document Was Entered
	Quantity		Quantity	Quantity
	PurOrdAmountInCompanyCodeCrcy		PurOrdAmountInCompanyCodeCrcy	Amount in Local Currency
	PurchaseOrderAmount		PurchaseOrderAmount	Amount in Document Currency
	QtyInPurchaseOrderPriceUnit		QtyInPurchaseOrderPriceUnit	Quantity in purchase order price unit
	GRIRAcctClrgAmtInCoCodeCrcy		GRIRAcctClrgAmtInCoCodeCrcy	GR/IR account clearing value in local currency
	GdsRcptBlkdStkQtyInOrdQtyUnit		GdsRcptBlkdStkQtyInOrdQtyUnit	Goods Receipt Blocked Stock in Order Unit
	GdsRcptBlkdStkQtyInOrdPrcUnit		GdsRcptBlkdStkQtyInOrdPrcUnit	Quantity in GR blocked stock in order price unit
	InvoiceAmtInCoCodeCrcy		InvoiceAmtInCoCodeCrcy	Invoice Value Entered (in Local Currency)
	ShipgInstrnSupplierCompliance		ShipgInstrnSupplierCompliance	Compliance with Shipping Instructions
	InvoiceAmountInFrgnCurrency		InvoiceAmountInFrgnCurrency	Invoice Value in Foreign Currency
	QuantityInDeliveryQtyUnit		QuantityInDeliveryQtyUnit	Quantity in Unit of Measure from Delivery Note
	GRIRAcctClrgAmtInTransacCrcy		GRIRAcctClrgAmtInTransacCrcy	Clearing value on GR/IR clearing account (transac. currency)
	QuantityInBaseUnit		QuantityInBaseUnit	Quantity
	GRIRAcctClrgAmtInOrdTrnsacCrcy		GRIRAcctClrgAmtInOrdTrnsacCrcy	Clearing Value on GR/IR Account in PO Currency
	InvoiceAmtInPurOrdTransacCrcy		InvoiceAmtInPurOrdTransacCrcy	Invoice Amount in PO Currency
	VltdGdsRcptBlkdStkQtyInOrdUnit		VltdGdsRcptBlkdStkQtyInOrdUnit	Valuated Goods Receipt Blocked Stock in Order Unit
	VltdGdsRcptBlkdQtyInOrdPrcUnit		VltdGdsRcptBlkdQtyInOrdPrcUnit	Quantity in Valuated GR Blocked Stock in Order Price Unit
	IsToBeAcceptedAtOrigin		IsToBeAcceptedAtOrigin	Acceptance At Origin
	ExchangeRateDifferenceAmount		ExchangeRateDifferenceAmount	Exchange Rate Difference Amount
	ExchangeRate		ExchangeRate	Exchange rate
	DeliveryDocument		DeliveryDocument	Outbound Delivery
	DeliveryDocumentItem		DeliveryDocumentItem	Delivery Document Item
	OrderPriceUnit		OrderPriceUnit	Order Price Unit (Purchasing)
	PurchaseOrderQuantityUnit		PurchaseOrderQuantityUnit	Purchase Order Unit of Measure
	BaseUnit		BaseUnit	Base Unit of Measure
	DocumentCurrency		DocumentCurrency	Document Currency
	CompanyCodeCurrency		CompanyCodeCurrency	Company Code Currency
	ProductTypeCode	_PurchaseOrderItem	ProductType	Product Type Group
	IsStatisticalItem	_PurchaseOrderItem	IsStatisticalItem	Statisticl.Indicator
	IsReturnsItem	_PurchaseOrderItem	IsReturnsItem	Returns Item
	GoodsReceiptIsExpected	_PurchaseOrderItem	GoodsReceiptIsExpected	Goods Receipt Indicator
	GoodsReceiptIsNonValuated	_PurchaseOrderItem	GoodsReceiptIsNonValuated	Goods Receipt, Non-Valuated
	IsFinallyInvoiced	_PurchaseOrderItem	IsFinallyInvoiced	Final Invoice Indicator
	InvoiceIsExpected	_PurchaseOrderItem	InvoiceIsExpected	Invoice Receipt Indicator
	PurchaseContract	_PurchaseOrderItem	PurchaseContract	Number of principal purchase agreement
	PurchaseContractItem	_PurchaseOrderItem	PurchaseContractItem	Item Number of Principal Purchase Agreement
	AccountAssignmentCategory	_PurchaseOrderItem	AccountAssignmentCategory	Account Assignment Category
	PurchaseRequisition	_PurchaseOrderItem	PurchaseRequisition	Purchase Requisition Number
	PurchaseRequisitionItem	_PurchaseOrderItem	PurchaseRequisitionItem	Item number of purchase requisition
	PurchaseOrderItemCategory	_PurchaseOrderItem	PurchaseOrderItemCategory	Item category in purchasing document
	ServicePerformer	_PurchaseOrderItem	ServicePerformer	Service Performer
	ProductGroup	_PurchaseOrderItem	MaterialGroup	Material Group
	MultipleAcctAssgmtDistribution	_PurchaseOrderItem	MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment
	PurgDocumentItemDeletionCode	_PurchaseOrderItem	PurchasingDocumentDeletionCode	Deletion Indicator in Purchasing Document
	Supplier	_PurchaseOrder	Supplier	Supplier
	PurchasingOrganization	_PurchaseOrder	PurchasingOrganization	Purchasing Organization
	PurchasingGroup	_PurchaseOrder	PurchasingGroup	Purchasing Group
	CompanyCode	_PurchaseOrder	CompanyCode	Receiver Company Code
	PurchasingDocumentDeletionCode	_PurchaseOrder	PurchasingDocumentDeletionCode	Purchase Order Deletion Code
	ReleaseIsNotCompleted	_PurchaseOrder	ReleaseIsNotCompleted	Release Not Yet Completely Effected
	PurchasingCompletenessStatus	_PurchaseOrder	PurchasingCompletenessStatus	Purchase order not yet complete
	_PurchaseOrder		_PurchaseOrder
	_PurchaseOrderItem		_PurchaseOrderItem

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_PurchaseOrderHistoryDEX.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CMMPURORDHIST

CREATE VIEW C_PurchaseOrderHistoryDEX AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentNumber,
  PurchasingHistoryDocumentType,
  PurchasingHistoryDocumentYear,
  PurchasingHistoryDocument,
  PurchasingHistoryDocumentItem,
  PurchasingHistoryCategory,
  GoodsMovementType,
  PostingDate,
  Currency,
  DebitCreditCode,
  IsCompletelyDelivered,
  ReferenceDocumentFiscalYear,
  ReferenceDocument,
  ReferenceDocumentItem,
  Material,
  Plant,
  RvslOfGoodsReceiptIsAllowed,
  PricingDocument,
  TaxCode,
  DocumentDate,
  InventoryValuationType,
  DocumentReferenceID,
  DeliveryQuantityUnit,
  ManufacturerMaterial,
  AccountingDocumentCreationDate,
  Quantity,
  PurOrdAmountInCompanyCodeCrcy,
  PurchaseOrderAmount,
  QtyInPurchaseOrderPriceUnit,
  GRIRAcctClrgAmtInCoCodeCrcy,
  GdsRcptBlkdStkQtyInOrdQtyUnit,
  GdsRcptBlkdStkQtyInOrdPrcUnit,
  InvoiceAmtInCoCodeCrcy,
  ShipgInstrnSupplierCompliance,
  InvoiceAmountInFrgnCurrency,
  QuantityInDeliveryQtyUnit,
  GRIRAcctClrgAmtInTransacCrcy,
  QuantityInBaseUnit,
  GRIRAcctClrgAmtInOrdTrnsacCrcy,
  InvoiceAmtInPurOrdTransacCrcy,
  VltdGdsRcptBlkdStkQtyInOrdUnit,
  VltdGdsRcptBlkdQtyInOrdPrcUnit,
  IsToBeAcceptedAtOrigin,
  ExchangeRateDifferenceAmount,
  ExchangeRate,
  DeliveryDocument,
  DeliveryDocumentItem,
  OrderPriceUnit,
  PurchaseOrderQuantityUnit,
  BaseUnit,
  DocumentCurrency,
  CompanyCodeCurrency,
  _PurchaseOrderItem.ProductType AS ProductTypeCode,
  _PurchaseOrderItem.IsStatisticalItem AS IsStatisticalItem,
  _PurchaseOrderItem.IsReturnsItem AS IsReturnsItem,
  _PurchaseOrderItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  _PurchaseOrderItem.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  _PurchaseOrderItem.IsFinallyInvoiced AS IsFinallyInvoiced,
  _PurchaseOrderItem.InvoiceIsExpected AS InvoiceIsExpected,
  _PurchaseOrderItem.PurchaseContract AS PurchaseContract,
  _PurchaseOrderItem.PurchaseContractItem AS PurchaseContractItem,
  _PurchaseOrderItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  _PurchaseOrderItem.PurchaseRequisition AS PurchaseRequisition,
  _PurchaseOrderItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  _PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  _PurchaseOrderItem.MaterialGroup AS ProductGroup,
  _PurchaseOrderItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  _PurchaseOrderItem.PurchasingDocumentDeletionCode AS PurgDocumentItemDeletionCode,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrder.CompanyCode AS CompanyCode,
  _PurchaseOrder.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  _PurchaseOrder.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  _PurchaseOrder.PurchasingCompletenessStatus AS PurchasingCompletenessStatus
FROM I_PurchaseOrderHistoryAPI01
;

Depth:

C_PurchaseOrderHistoryDEX view

I_PurchaseOrderHistoryAPI01 view