Deprecated NONE
This CDS view is deprecated in S/4HANA. Use C_SupplierInvoiceListActvInvc instead. View all deprecated CDS views →

C_SupInvListActiveInvoices

DDL: C_SUPINVLISTACTIVEINVOICES SQL: CSIACTIVEINV Type: view CONSUMPTION
27 Fields 1 Data Sources 6 Associations

Active Supplier Invoices

C_SupInvListActiveInvoices is a Consumption CDS View that provides data about "Active Supplier Invoices" in SAP S/4HANA. It reads from 1 data source (I_SupplierInvoiceEnh) and exposes 27 fields with key fields SupplierInvoice, FiscalYear. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SupplierInvoiceEnh I_SupplierInvoiceEnh from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_SupplierInvoiceStatus _SupplierInvoiceStatus $projection.SupplierInvoice = _SupplierInvoiceStatus.SupplierInvoiceStatus
[0..1] I_SupplierInvoiceStatusText _SupplierInvoiceStatusText $projection.SupplierInvoiceStatus = _SupplierInvoiceStatusText.SupplierInvoiceStatus and _SupplierInvoiceStatusText.Language = $session.system_language
[0..1] I_SupplierInvoiceOriginText _SupplierInvoiceOriginText $projection.SupplierInvoiceOrigin = _SupplierInvoiceOriginText.SupplierInvoiceOrigin and _SupplierInvoiceOriginText.Language = $session.system_language
[1..1] I_SupplierInvoiceStsAndOrign _SupplierInvoiceStsAndOrign $projection.SupplierInvoice = _SupplierInvoiceStsAndOrign.SupplierInvoice and $projection.FiscalYear = _SupplierInvoiceStsAndOrign.FiscalYear
[0..1] I_SupplierInvoiceStsOriginText _SupplierInvoiceStsOriginText $projection.invoicestatusandorigin = _SupplierInvoiceStsOriginText.InvoiceStatusAndOrigin and _SupplierInvoiceStsOriginText.Language = $session.system_language
[0..1] I_Currency _Currency $projection.DocumentCurrency = _Currency.Currency

Annotations (14)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
AbapCatalog.sqlViewName CSIACTIVEINV view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Active Supplier Invoices view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_SupplierInvoiceListActvInvc view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice I_SupplierInvoiceEnh SupplierInvoice
KEY FiscalYear I_SupplierInvoiceEnh FiscalYear G/L Fiscal Year
SupplierInvoiceUUID I_SupplierInvoiceEnh SupplierInvoiceUUID
InvoicingParty I_SupplierInvoiceEnh InvoicingParty Supplier
CompanyCode I_SupplierInvoiceEnh CompanyCode Receiver Company Code
DocumentDate I_SupplierInvoiceEnh DocumentDate Journal Entry Date
PostingDate I_SupplierInvoiceEnh PostingDate Posting Date for GR
DocumentCurrency I_SupplierInvoiceEnh DocumentCurrency Document Currency
SupplierInvoiceOrigin I_SupplierInvoiceEnh SupplierInvoiceOrigin IV category
DueCalculationBaseDate I_SupplierInvoiceEnh DueCalculationBaseDate Due Calculation Base Date
CashDiscount1Days I_SupplierInvoiceEnh CashDiscount1Days Days from Baseline Date for Payment
CashDiscount1Percent I_SupplierInvoiceEnh CashDiscount1Percent Disc. Percent 1
SupplierInvoiceIDByInvcgParty I_SupplierInvoiceEnh SupplierInvoiceIDByInvcgParty Reference
CreatedByUser I_SupplierInvoiceEnh CreatedByUser User Name
DocumentHeaderText I_SupplierInvoiceEnh DocumentHeaderText Doc.Header Text
CashDiscount1DueDate
SupplierInvoiceStatus I_SupplierInvoiceEnh SupplierInvoiceStatus Inv. status
SupplierInvoiceStatusDesc _SupplierInvoiceStatusText SupplierInvoiceStatusDesc
SupplierInvoiceOriginDesc _SupplierInvoiceOriginText SupplierInvoiceOriginDesc
InvoiceStatusAndOrigin _SupplierInvoiceStsAndOrign InvoiceStatusAndOrigin
IsEndOfPurposeBlocked I_SupplierInvoiceEnh IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
_SupplierInvoiceStsAndOrign _SupplierInvoiceStsAndOrign
_SupplierInvoiceStsOriginText _SupplierInvoiceStsOriginText
_SupplierInvoiceStatus _SupplierInvoiceStatus
_SupplierInvoiceStatusText _SupplierInvoiceStatusText
_SupplierInvoiceOriginText _SupplierInvoiceOriginText
_Currency _Currency

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_SupInvListActiveInvoices.
-- 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: CSIACTIVEINV

CREATE VIEW C_SupInvListActiveInvoices AS
SELECT
  I_SupplierInvoiceEnh.SupplierInvoice AS SupplierInvoice,
  I_SupplierInvoiceEnh.FiscalYear AS FiscalYear,
  I_SupplierInvoiceEnh.SupplierInvoiceUUID AS SupplierInvoiceUUID,
  I_SupplierInvoiceEnh.InvoicingParty AS InvoicingParty,
  I_SupplierInvoiceEnh.CompanyCode AS CompanyCode,
  I_SupplierInvoiceEnh.DocumentDate AS DocumentDate,
  I_SupplierInvoiceEnh.PostingDate AS PostingDate,
  I_SupplierInvoiceEnh.DocumentCurrency AS DocumentCurrency,
  I_SupplierInvoiceEnh.SupplierInvoiceOrigin AS SupplierInvoiceOrigin,
  I_SupplierInvoiceEnh.DueCalculationBaseDate AS DueCalculationBaseDate,
  I_SupplierInvoiceEnh.CashDiscount1Days AS CashDiscount1Days,
  I_SupplierInvoiceEnh.CashDiscount1Percent AS CashDiscount1Percent,
  I_SupplierInvoiceEnh.SupplierInvoiceIDByInvcgParty AS SupplierInvoiceIDByInvcgParty,
  I_SupplierInvoiceEnh.CreatedByUser AS CreatedByUser,
  I_SupplierInvoiceEnh.DocumentHeaderText AS DocumentHeaderText,
  cast('' as abap.dats) AS CashDiscount1DueDate,
  I_SupplierInvoiceEnh.SupplierInvoiceStatus AS SupplierInvoiceStatus,
  _SupplierInvoiceStatusText.SupplierInvoiceStatusDesc AS SupplierInvoiceStatusDesc,
  _SupplierInvoiceOriginText.SupplierInvoiceOriginDesc AS SupplierInvoiceOriginDesc,
  _SupplierInvoiceStsAndOrign.InvoiceStatusAndOrigin AS InvoiceStatusAndOrigin,
  I_SupplierInvoiceEnh.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM I_SupplierInvoiceEnh
LEFT OUTER JOIN I_SupplierInvoiceStatus AS _SupplierInvoiceStatus ON SupplierInvoice = _SupplierInvoiceStatus.SupplierInvoiceStatus  -- association [1..1]
LEFT OUTER JOIN I_SupplierInvoiceStatusText AS _SupplierInvoiceStatusText ON SupplierInvoiceStatus = _SupplierInvoiceStatusText.SupplierInvoiceStatus AND _SupplierInvoiceStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoiceOriginText AS _SupplierInvoiceOriginText ON SupplierInvoiceOrigin = _SupplierInvoiceOriginText.SupplierInvoiceOrigin AND _SupplierInvoiceOriginText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoiceStsAndOrign AS _SupplierInvoiceStsAndOrign ON SupplierInvoice = _SupplierInvoiceStsAndOrign.SupplierInvoice AND FiscalYear = _SupplierInvoiceStsAndOrign.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_SupplierInvoiceStsOriginText AS _SupplierInvoiceStsOriginText ON invoicestatusandorigin = _SupplierInvoiceStsOriginText.InvoiceStatusAndOrigin AND _SupplierInvoiceStsOriginText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [0..1]
;

Learn More