C_SupCsgnmtPplineInvcHistDEX

DDL: C_SUPCSGNMTPPLINEINVCHISTDEX SQL: CSUPCSGINVHDEX Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
13 Fields 1 Data Sources 5 Associations

Consignment and Pipeline History of Supplier Invoice

C_SupCsgnmtPplineInvcHistDEX (Consumption)

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

SuplrCsgnmtPplineSettlmtHist · Sourcing & Procurement

C_SupCsgnmtPplineInvcHistDEX is a Consumption CDS View (Fact) that provides data about "Consignment and Pipeline History of Supplier Invoice" in SAP S/4HANA. It reads from 1 data source (I_SupCsgnmtPplineInvcHistAPI01) and exposes 13 fields with key fields MaterialDocument, MaterialDocumentYear, MaterialDocumentItem, SupplierInvoice, FiscalYear. It has 5 associations to related views. Part of development package ODATA_MM_ANALYTICS.

SAP API Hub

CategoryConsumption
StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-ANA-2CL
CapabilitiesData Source for Data Extraction
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSourcing and Procurement for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SupCsgnmtPplineInvcHistAPI01 I_SupCsgnmtPplineInvcHistAPI01 from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_SuplrCsgnmtPplineWthdrwlDEX _SuplrCsgnmtPplineWthdrwlDEX $projection.MaterialDocument = _SuplrCsgnmtPplineWthdrwlDEX.MaterialDocument and $projection.MaterialDocumentYear = _SuplrCsgnmtPplineWthdrwlDEX.MaterialDocumentYear and $projection.MaterialDocumentItem = _SuplrCsgnmtPplineWthdrwlDEX.MaterialDocumentItem
[1..1] C_SupplierInvoiceDEX _SupplierInvoiceDEX $projection.SupplierInvoice = _SupplierInvoiceDEX.SupplierInvoice and $projection.FiscalYear = _SupplierInvoiceDEX.FiscalYear
[1..1] C_SupplierInvoiceItemDEX _SupplierInvoiceItemDEX $projection.SupplierInvoice = _SupplierInvoiceItemDEX.SupplierInvoice and $projection.FiscalYear = _SupplierInvoiceItemDEX.FiscalYear and $projection.SupplierInvoiceItem = _SupplierInvoiceItemDEX.SupplierInvoiceItem
[1..1] I_CompanyCode _CompanyCode $projection.companycode = _CompanyCode.CompanyCode
[1..1] I_Plant _Plant $projection.plant = _Plant.Plant

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CSUPCSGINVHDEX view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.modelingPattern #ANALYTICAL_FACT 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
ObjectModel.sapObjectNodeType.name SuplrCsgnmtPplineSettlmtHist view
EndUserText.label Consignment and Pipeline History of Supplier Invoice view
ObjectModel.compositionRoot true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument Number of Material Document
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocumentItem MaterialDocumentItem Item in Material Document
KEY SupplierInvoice SupplierInvoice Document Number of an Accounting Document
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY SupplierInvoiceItem SupplierInvoiceItem Document Item in Invoice Document
CompanyCode _SupCsgnmtPplineWthdrwlAPI01 CompanyCode Receiver Company Code
Plant _SupCsgnmtPplineWthdrwlAPI01 Plant Valuation Area
_SuplrCsgnmtPplineWthdrwlDEX _SuplrCsgnmtPplineWthdrwlDEX
_SupplierInvoiceDEX _SupplierInvoiceDEX
_SupplierInvoiceItemDEX _SupplierInvoiceItemDEX
_CompanyCode _CompanyCode
_Plant _Plant

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_SupCsgnmtPplineInvcHistDEX.
-- 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: CSUPCSGINVHDEX

CREATE VIEW C_SupCsgnmtPplineInvcHistDEX AS
SELECT
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  SupplierInvoice,
  FiscalYear,
  SupplierInvoiceItem,
  _SupCsgnmtPplineWthdrwlAPI01.CompanyCode AS CompanyCode,
  _SupCsgnmtPplineWthdrwlAPI01.Plant AS Plant
FROM I_SupCsgnmtPplineInvcHistAPI01
LEFT OUTER JOIN C_SuplrCsgnmtPplineWthdrwlDEX AS _SuplrCsgnmtPplineWthdrwlDEX ON MaterialDocument = _SuplrCsgnmtPplineWthdrwlDEX.MaterialDocument AND MaterialDocumentYear = _SuplrCsgnmtPplineWthdrwlDEX.MaterialDocumentYear AND MaterialDocumentItem = _SuplrCsgnmtPplineWthdrwlDEX.MaterialDocumentItem  -- association [1..1]
LEFT OUTER JOIN C_SupplierInvoiceDEX AS _SupplierInvoiceDEX ON SupplierInvoice = _SupplierInvoiceDEX.SupplierInvoice AND FiscalYear = _SupplierInvoiceDEX.FiscalYear  -- association [1..1]
LEFT OUTER JOIN C_SupplierInvoiceItemDEX AS _SupplierInvoiceItemDEX ON SupplierInvoice = _SupplierInvoiceItemDEX.SupplierInvoice AND FiscalYear = _SupplierInvoiceItemDEX.FiscalYear AND SupplierInvoiceItem = _SupplierInvoiceItemDEX.SupplierInvoiceItem  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON companycode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON plant = _Plant.Plant  -- association [1..1]
;

Learn More