What is C_SupplierInvoiceItemDEX in SAP S/4HANA?

C_SupplierInvoiceItemDEX is a consumption CDS view in SAP S/4HANA. Data Extraction for Supplier Invoice Item It contains 38 fields.

Which tables does C_SupplierInvoiceItemDEX read from?

C_SupplierInvoiceItemDEX reads data from: I_SuplrInvcItemPurOrdRefAPI01.

What VDM layer is C_SupplierInvoiceItemDEX?

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

C_SupplierInvoiceItemDEX

DDL: C_SUPPLIERINVOICEITEMDEX SQL: CMMSUPINVCITMDEX Type: view CONSUMPTION

38 Fields 1 Data Sources 1 Associations

Data Extraction for Supplier Invoice Item

C_SupplierInvoiceItemDEX (Consumption)

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

SupplierInvoiceItem · Sourcing & Procurement

C_SupplierInvoiceItemDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction for Supplier Invoice Item" in SAP S/4HANA. It reads from 1 data source (I_SuplrInvcItemPurOrdRefAPI01) and exposes 38 fields with key fields SupplierInvoice, FiscalYear, SupplierInvoiceItem. It has 1 association to related views.

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_SuplrInvcItemPurOrdRefAPI01	I_SuplrInvcItemPurOrdRefAPI01	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	E_OnlineSupplierInvoiceItem	_OnlineExtension	`$projection.SupplierInvoice = _OnlineExtension.SupplierInvoice and $projection.FiscalYear = _OnlineExtension.FiscalYear and $projection.SupplierInvoiceItem = _OnlineExtension.SupplierInvoiceItem`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	CMMSUPINVCITMDEX	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 Supplier Invoice Item	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
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
Analytics.dataCategory	#FACT	view
Analytics.dataExtraction.enabled	true	view

Fields (38)

Key	Field	Source Table	Source Field	Description
KEY	SupplierInvoice		SupplierInvoice	Document Number of an Accounting Document
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	SupplierInvoiceItem		SupplierInvoiceItem	Document Item in Invoice Document
	QtyInPurchaseOrderPriceUnit		QtyInPurchaseOrderPriceUnit	Quantity in Purchase Order Price Unit
	PurchaseOrderPriceUnit		PurchaseOrderPriceUnit	Order Price Unit (Purchasing)
	PurchaseOrderQuantityUnit		PurchaseOrderQuantityUnit	Purchase Order Unit of Measure
	PurchaseOrder		PurchaseOrder	Purchasing Document Number
	PurchaseOrderItem		PurchaseOrderItem	Item Number of Purchasing Document
	PrmtHbReferenceDocument		ReferenceDocument	Document No. of a Reference Document
	PrmtHbReferenceDocumentFsclYr		ReferenceDocumentFiscalYear	Fiscal Year of Current Period
	PrmtHbReferenceDocumentItem		ReferenceDocumentItem	Item of a Reference Document
	PurchaseOrderItemMaterial		PurchaseOrderItemMaterial	Material Number
	QuantityInPurchaseOrderUnit		QuantityInPurchaseOrderUnit	Quantity
	SuplrInvcItmHasQualityVariance		SuplrInvcItmHasQualityVariance	Blocking Reason: Quality
	SuplrInvcItemHasOrdPrcQtyVarc		SuplrInvcItemHasOrdPrcQtyVarc	Blocking Reason: Order Price Quantity
	SuplrInvcItemHasQtyVariance		SuplrInvcItemHasQtyVariance	Blocking Reason: Quantity
	SuplrInvcItemHasPriceVariance		SuplrInvcItemHasPriceVariance	Blocking Reason: Price
	SuplrInvcItemHasOtherVariance		SuplrInvcItemHasOtherVariance	Manual Blocking Reason
	SuplrInvcItemHasAmountOutsdTol		SuplrInvcItemHasAmountOutsdTol	Blocking Reason: Item Amount
	SuplrInvcItemHasDateVariance		SuplrInvcItemHasDateVariance	Blocking Reason: Date
	IsSubsequentDebitCredit		IsSubsequentDebitCredit	Indicator: Subsequent Debit/Credit
	Plant		Plant	Valuation Area
	DocumentCurrency		DocumentCurrency	Document Currency
	SupplierInvoiceItemAmount		SupplierInvoiceItemAmount	Amount in Document Currency
	SuplrInvcAutomReducedAmount	_SupplierInvoiceAPI01	SuplrInvcAutomReducedAmount	Automatic Invoice Reduction Amount (Net)
	UnplannedDeliveryCost	_SupplierInvoiceAPI01	UnplannedDeliveryCost	Unplanned Delivery Costs
	DocumentHeaderText	_SupplierInvoiceAPI01	DocumentHeaderText	Document Header Text
	DocumentDate	_SupplierInvoiceAPI01	DocumentDate	Invoice Date in Document
	PostingDate	_SupplierInvoiceAPI01	PostingDate	Posting Date in the Document
	CompanyCode	_SupplierInvoiceAPI01	CompanyCode	Receiver Company Code
	SupplierInvoiceOrigin	_SupplierInvoiceAPI01	SupplierInvoiceOrigin	Origin of a Logistics Invoice Verification Document
	InvoicingParty	_SupplierInvoiceAPI01	InvoicingParty	Different Invoicing Party
	UnplannedDeliveryCostTaxCode	_SupplierInvoiceAPI01	UnplannedDeliveryCostTaxCode	Tax Code
	ReverseDocument	_SupplierInvoiceAPI01	ReverseDocument	Reversal document number
	ReverseDocumentFiscalYear	_SupplierInvoiceAPI01	ReverseDocumentFiscalYear	Fiscal year of reversal document
	SupplierInvoiceIDByInvcgParty	_SupplierInvoiceAPI01	SupplierInvoiceIDByInvcgParty	Reference Document Number
	IsInvoice	_SupplierInvoiceAPI01	IsInvoice	Indicator: post invoice
	SupplierInvoiceStatus	_SupplierInvoiceAPI01	SupplierInvoiceStatus	Invoice document status

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_SupplierInvoiceItemDEX.
-- 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: CMMSUPINVCITMDEX

CREATE VIEW C_SupplierInvoiceItemDEX AS
SELECT
  SupplierInvoice,
  FiscalYear,
  SupplierInvoiceItem,
  QtyInPurchaseOrderPriceUnit,
  PurchaseOrderPriceUnit,
  PurchaseOrderQuantityUnit,
  PurchaseOrder,
  PurchaseOrderItem,
  ReferenceDocument AS PrmtHbReferenceDocument,
  ReferenceDocumentFiscalYear AS PrmtHbReferenceDocumentFsclYr,
  ReferenceDocumentItem AS PrmtHbReferenceDocumentItem,
  PurchaseOrderItemMaterial,
  QuantityInPurchaseOrderUnit,
  SuplrInvcItmHasQualityVariance,
  SuplrInvcItemHasOrdPrcQtyVarc,
  SuplrInvcItemHasQtyVariance,
  SuplrInvcItemHasPriceVariance,
  SuplrInvcItemHasOtherVariance,
  SuplrInvcItemHasAmountOutsdTol,
  SuplrInvcItemHasDateVariance,
  IsSubsequentDebitCredit,
  Plant,
  DocumentCurrency,
  SupplierInvoiceItemAmount,
  _SupplierInvoiceAPI01.SuplrInvcAutomReducedAmount AS SuplrInvcAutomReducedAmount,
  _SupplierInvoiceAPI01.UnplannedDeliveryCost AS UnplannedDeliveryCost,
  _SupplierInvoiceAPI01.DocumentHeaderText AS DocumentHeaderText,
  _SupplierInvoiceAPI01.DocumentDate AS DocumentDate,
  _SupplierInvoiceAPI01.PostingDate AS PostingDate,
  _SupplierInvoiceAPI01.CompanyCode AS CompanyCode,
  _SupplierInvoiceAPI01.SupplierInvoiceOrigin AS SupplierInvoiceOrigin,
  _SupplierInvoiceAPI01.InvoicingParty AS InvoicingParty,
  _SupplierInvoiceAPI01.UnplannedDeliveryCostTaxCode AS UnplannedDeliveryCostTaxCode,
  _SupplierInvoiceAPI01.ReverseDocument AS ReverseDocument,
  _SupplierInvoiceAPI01.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  _SupplierInvoiceAPI01.SupplierInvoiceIDByInvcgParty AS SupplierInvoiceIDByInvcgParty,
  _SupplierInvoiceAPI01.IsInvoice AS IsInvoice,
  _SupplierInvoiceAPI01.SupplierInvoiceStatus AS SupplierInvoiceStatus
FROM I_SuplrInvcItemPurOrdRefAPI01
LEFT OUTER JOIN E_OnlineSupplierInvoiceItem AS _OnlineExtension ON SupplierInvoice = _OnlineExtension.SupplierInvoice AND FiscalYear = _OnlineExtension.FiscalYear AND SupplierInvoiceItem = _OnlineExtension.SupplierInvoiceItem  -- association [0..1]
;

Depth:

C_SupplierInvoiceItemDEX view

I_SuplrInvcItemPurOrdRefAPI01 view