What is I_SupplierInvoiceAPI01 in SAP S/4HANA?

I_SupplierInvoiceAPI01 is a basic CDS view in SAP S/4HANA. Supplier Invoice It contains 86 fields.

Which tables does I_SupplierInvoiceAPI01 read from?

I_SupplierInvoiceAPI01 reads data from: I_SupplierInvoice.

What VDM layer is I_SupplierInvoiceAPI01?

I_SupplierInvoiceAPI01 is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_SupplierInvoiceAPI01

DDL: I_SUPPLIERINVOICEAPI01 SQL: ISUPLRINVCAPI01 Type: view BASIC

86 Fields 1 Data Sources 12 Associations

Supplier Invoice

I_SupplierInvoiceAPI01 (Basic)

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

Sourcing & Procurement

I_SupplierInvoiceAPI01 is a Basic CDS View that provides data about "Supplier Invoice" in SAP S/4HANA. It reads from 1 data source (I_SupplierInvoice) and exposes 86 fields with key fields SupplierInvoice, FiscalYear. It has 12 associations to related views.

SAP Help Documentation

Category	CDS Views for Invoice Processing
Data Category	Basic (View Type)
Status	Released

Purpose
This CDS view provides the prerequisites for answering questions about supplier invoices, such as: How many supplier invoices with a specific status are in the system? How many supplier invoices were posted in the last 3 months? In which company codes were the supplier invoices created in the last year? Which are the most frequent entry types (origin) for supplier invoices?

Prerequisites
Users who want to run reports using this CDS view must have the authorization to display the following data: Supplier Invoice The following authorization objects are required: M_RECH_BUK

Structure
Object types This view relates to the following SAP object types: SupplierInvoice Main CDS parameters The main CDS parameters are: SUPPLIERINVOICE used to specify the supplier invoices FISCALYEAR used to specify the fiscal year COMPANYCODE used to specify the company code DOCUMENTDATE used to specify the document date POSTINGDATE used to specify the posting date SUPPLIERINVOICEIDBYINVCGPARTY used to specify the reference document number used by the invoicing party INVOICINGPARTY used to specify the invoicing party DOCUMENTCURRENCY used to specify the document currency INVOICEGROSSAMOUNT used to specify the invoice gross amount EXCHANGERATE used to specify the exchange rate ACCOUNTINGDOCUMENTTYPE used to specify the document type SUPPLIERINVOICESTATUS used to specify the supplier invoice status SUPPLIERINVOICEORIGIN used to specify the origin of the supplier invoice document INVOICEREFERENCE used to specify the document number for the invoice reference INVOICEREFERENCEFISCALYEAR used to specify the fiscal year of the referenced supplier invoice/credit memo

Example
If you want to display journal entries for a supplier invoice, you can use the view I_SupplierInvoiceAPI01 using the view I_JournalEntry ( join condition) as follows:

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Sourcing & Procurement
Application Component	MM-IV-LIV
Capabilities	Data Source for Defining CDS Entities, Data Source in SQL Select
Package	Sourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description	This CDS view provides the prerequisites for answering questions about supplier invoices, such as:<ul> <li><p>How many supplier invoices with a specific status are in the system?</p></li> <li><p>How many supplier invoices were posted in the last 3 months?</p></li> <li><p>In which company codes were the supplier invoices created in the last year?</p></li> <li><p>Which are the most frequent entry types (origin) for supplier invoices?</p></li> </ul>

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_SupplierInvoice	I_SupplierInvoice	from

Associations (12)

Cardinality	Target	Alias	Condition
[0..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[0..1]	I_Currency	_Currency	`$projection.DocumentCurrency = _Currency.Currency`
[1..*]	I_SuplrInvcItemPurOrdRefAPI01	_SuplrInvcItemPurOrdRefAPI01	`$projection.SupplierInvoice = _SuplrInvcItemPurOrdRefAPI01.SupplierInvoice and $projection.FiscalYear = _SuplrInvcItemPurOrdRefAPI01.FiscalYear`
[1..*]	I_SuplrInvoiceItemGLAcctAPI01	_SuplrInvoiceItemGLAcctAPI01	`$projection.SupplierInvoice = _SuplrInvoiceItemGLAcctAPI01.SupplierInvoice and $projection.FiscalYear = _SuplrInvoiceItemGLAcctAPI01.FiscalYear`
[1..*]	I_SupplierInvoiceTaxAPI01	_SupplierInvoiceTaxAPI01	`$projection.SupplierInvoice = _SupplierInvoiceTaxAPI01.SupplierInvoice and $projection.FiscalYear = _SupplierInvoiceTaxAPI01.FiscalYear`
[1..*]	I_SuplrInvcHeaderWhldgTaxAPI01	_SuplrInvcHeaderWhldgTaxAPI01	`$projection.SupplierInvoice = _SuplrInvcHeaderWhldgTaxAPI01.SupplierInvoice and $projection.FiscalYear = _SuplrInvcHeaderWhldgTaxAPI01.FiscalYear`
[1..*]	I_SuplrInvcSeldPurgDocAPI01	_SuplrInvcSeldPurgDocAPI01	`$projection.SupplierInvoice = _SuplrInvcSeldPurgDocAPI01.SupplierInvoice and $projection.FiscalYear = _SuplrInvcSeldPurgDocAPI01.FiscalYear`
[1..*]	I_SuplrInvcSeldDelivNoteAPI01	_SuplrInvcSeldDelivNoteAPI01	`$projection.SupplierInvoice = _SuplrInvcSeldDelivNoteAPI01.SupplierInvoice and $projection.FiscalYear = _SuplrInvcSeldDelivNoteAPI01.FiscalYear`
[1..*]	I_SuplrInvcSeldInbBOLAPI01	_SuplrInvcSeldInbBOLAPI01	`$projection.SupplierInvoice = _SuplrInvcSeldInbBOLAPI01.SupplierInvoice and $projection.FiscalYear = _SuplrInvcSeldInbBOLAPI01.FiscalYear`
[1..*]	I_SuplrInvcSeldSESLeanAPI01	_SuplrInvcSeldSESLeanAPI01	`$projection.SupplierInvoice = _SuplrInvcSeldSESLeanAPI01.SupplierInvoice and $projection.FiscalYear = _SuplrInvcSeldSESLeanAPI01.FiscalYear`
[0..*]	I_SupplierInvoiceBlockAPI01	_SupplierInvoiceBlockAPI01	`$projection.SupplierInvoice = _SupplierInvoiceBlockAPI01.SupplierInvoice and $projection.FiscalYear = _SupplierInvoiceBlockAPI01.FiscalYear`
[1..1]	E_SupplierInvoice	_HeaderExtension	`$projection.SupplierInvoice = _HeaderExtension.SupplierInvoice and $projection.FiscalYear = _HeaderExtension.FiscalYear and I_SupplierInvoice.SupplierInvoiceUUID = _HeaderExtension.SupplierInvoiceUUID`

Annotations (13)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.sqlViewName	ISUPLRINVCAPI01	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
EndUserText.label	Supplier Invoice	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.modelingPattern	#NONE	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (86)

Key	Field	Source Field	Description
KEY	SupplierInvoice	SupplierInvoice	Document Number of an Invoice Document
KEY	FiscalYear	FiscalYear	G/L Fiscal Year
	SupplierInvoiceWthnFiscalYear
	CompanyCode	CompanyCode	Receiver Company Code
	DocumentDate	DocumentDate	Invoice Date in Document
	PostingDate	PostingDate	Posting Date in the Document
	SupplierInvoiceIDByInvcgParty	SupplierInvoiceIDByInvcgParty	Reference Document Number
	InvoicingParty	InvoicingParty	Different Invoicing Party
	IsInvoice	IsInvoice	Indicator: post invoice
	DocumentCurrency	DocumentCurrency	Document Currency
	InvoiceGrossAmount	InvoiceGrossAmount	Gross Invoice Amount in Document Currency
	ExchangeRate	ExchangeRate	Exchange rate
	AccountingDocumentType	AccountingDocumentType	Journal Entry Type
	SupplierInvoiceStatus	SupplierInvoiceStatus	Invoice document status
	SupplierInvoiceOrigin	SupplierInvoiceOrigin	Origin of a Logistics Invoice Verification Document
	CreatedByUser	CreatedByUser	Name of the Processor Who Entered the Object
	LastChangedByUser	LastChangedByUser	User Name
	InvoiceReference	InvoiceReference	Invoice reference: Document number for invoice reference
	InvoiceReferenceFiscalYear	InvoiceReferenceFiscalYear	Fiscal Year of the Relevant Invoice (for Credit Memo)
	AssignmentReference	AssignmentReference	Assignment Reference
	TaxIsCalculatedAutomatically	TaxIsCalculatedAutomatically	Tax Is Automatically Calculated
	BusinessPlace	BusinessPlace	Business place
	CreationDate	CreationDate	Day On Which Accounting Document Was Entered
	CreationTime	CreationTime	Time of Change
	SuplrInvcTransactionCategory	SuplrInvcTransactionCategory	Transaction Type in AG08 (Internal Document Type)
	UnplannedDeliveryCost	UnplannedDeliveryCost	Unplanned Delivery Costs
	UnplannedDeliveryCostTaxCode	UnplannedDeliveryCostTaxCode	Tax Code
	UnplndDelivCostTaxJurisdiction	UnplndDelivCostTaxJurisdiction	Tax Jurisdiction
	DocumentHeaderText	DocumentHeaderText	Document Header Text
	SupplierPostingLineItemText	SupplierPostingLineItemText	Item Text
	PaymentTerms	PaymentTerms	Terms of Payment Key
	DueCalculationBaseDate	DueCalculationBaseDate	Baseline Date for Due Date Calculation
	CashDiscount1Percent	CashDiscount1Percent	Cash Discount Percentage 1
	CashDiscount1Days	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount2Percent	CashDiscount2Percent	Cash Discount Percentage 2
	CashDiscount2Days	CashDiscount2Days	Days from Baseline Date for Payment
	NetPaymentDays	NetPaymentDays	Net Payment Terms Period
	ManualCashDiscount	ManualCashDiscount	Cash Discount Amount in Document Currency
	FixedCashDiscount	FixedCashDiscount	Fixed Cash Discount
	StateCentralBankPaymentReason	StateCentralBankPaymentReason	State Central Bank Indicator
	SupplyingCountry	SupplyingCountry	Supplying Country/Region
	BPBankAccountInternalID	BPBankAccountInternalID	Partner bank type
	PaymentMethod	PaymentMethod	Payment Method
	PaymentReference	PaymentReference	Payment Reference
	PaytSlipWthRefSubscriber	PaytSlipWthRefSubscriber	ISR Subscriber Number
	PaytSlipWthRefCheckDigit	PaytSlipWthRefCheckDigit	ISR Check Digit
	PaytSlipWthRefReference	PaytSlipWthRefReference	ISR/QR Reference Number
	PaymentReason	PaymentReason	Payment Reason
	ReverseDocument	ReverseDocument	Reversal document number
	ReverseDocumentFiscalYear	ReverseDocumentFiscalYear	Fiscal year of reversal document
	SuplrInvcManuallyReducedAmount	SuplrInvcManuallyReducedAmount	Supplier Error (Exclusive of Tax)
	SuplrInvcAutomReducedAmount	SuplrInvcAutomReducedAmount	Automatic Invoice Reduction Amount (Net)
	TaxDeterminationDate	TaxDeterminationDate	Date for Determining Tax Rates
	TaxReportingDate	TaxReportingDate	Tax Reporting Date
	TaxFulfillmentDate	TaxFulfillmentDate	Tax Fulfillment Date
	TaxCountry	TaxCountry	Tax Reporting Country/Region
	UnplndDeliveryCostTaxCountry	UnplndDeliveryCostTaxCountry	Tax Reporting Country/Region
	DeliveryOfGoodsReportingCntry	DeliveryOfGoodsReportingCntry	Reporting Country/Region for Delivery of Goods Within the EU
	SupplierVATRegistration	SupplierVATRegistration	VAT Registration Number
	IsEUTriangularDeal	IsEUTriangularDeal	Indicator: Triangular Deal Within the EU
	SuplrInvcDebitCrdtCodeDelivery	SuplrInvcDebitCrdtCodeDelivery	Posting logic for delivery items (invoice/credit memo)
	SuplrInvcDebitCrdtCodeReturns	SuplrInvcDebitCrdtCodeReturns	Posting logic for returns items (invoice/credit memo)
	ElectronicInvoiceUUID	ElectronicInvoiceUUID	(obsolete) Mexico UUID
	JrnlEntryCntrySpecificRef1	JrnlEntryCntrySpecificRef1	Country/Region Specific Reference 1 in the Document
	JrnlEntryCntrySpecificDate1	JrnlEntryCntrySpecificDate1	Country/Region Specific Date 1 in the Document
	JrnlEntryCntrySpecificRef2	JrnlEntryCntrySpecificRef2	Country/Region Specific Reference 2 in the Document
	JrnlEntryCntrySpecificDate2	JrnlEntryCntrySpecificDate2	Country/Region Specific Date 2 in the Document
	JrnlEntryCntrySpecificRef3	JrnlEntryCntrySpecificRef3	Country/Region Specific Reference 3 in the Document
	JrnlEntryCntrySpecificDate3	JrnlEntryCntrySpecificDate3	Country/Region Specific Date 3 in the Document
	JrnlEntryCntrySpecificRef4	JrnlEntryCntrySpecificRef4	Country/Region Specific Reference 4 in the Document
	JrnlEntryCntrySpecificDate4	JrnlEntryCntrySpecificDate4	Country/Region Specific Date 4 in the Document
	JrnlEntryCntrySpecificRef5	JrnlEntryCntrySpecificRef5	Country/Region Specific Reference 5 in the Document
	JrnlEntryCntrySpecificDate5	JrnlEntryCntrySpecificDate5	Country/Region Specific Date 5 in the Document
	JrnlEntryCntrySpecificBP1	JrnlEntryCntrySpecificBP1	Country/Region specific Business Partner 1 in the Document
	JrnlEntryCntrySpecificBP2	JrnlEntryCntrySpecificBP2	Country/Region Specific Business Partner 2 in the Document
	_CompanyCode	_CompanyCode
	_Currency	_Currency
	_SuplrInvcItemPurOrdRefAPI01	_SuplrInvcItemPurOrdRefAPI01
	_SuplrInvoiceItemGLAcctAPI01	_SuplrInvoiceItemGLAcctAPI01
	_SupplierInvoiceTaxAPI01	_SupplierInvoiceTaxAPI01
	_SuplrInvcHeaderWhldgTaxAPI01	_SuplrInvcHeaderWhldgTaxAPI01
	_SuplrInvcSeldPurgDocAPI01	_SuplrInvcSeldPurgDocAPI01
	_SuplrInvcSeldDelivNoteAPI01	_SuplrInvcSeldDelivNoteAPI01
	_SuplrInvcSeldInbBOLAPI01	_SuplrInvcSeldInbBOLAPI01
	_SuplrInvcSeldSESLeanAPI01	_SuplrInvcSeldSESLeanAPI01
	_SupplierInvoiceBlockAPI01	_SupplierInvoiceBlockAPI01

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 I_SupplierInvoiceAPI01.
-- 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: ISUPLRINVCAPI01

CREATE VIEW I_SupplierInvoiceAPI01 AS
SELECT
  SupplierInvoice,
  FiscalYear,
  concat(SupplierInvoice , FiscalYear) AS SupplierInvoiceWthnFiscalYear,
  CompanyCode,
  DocumentDate,
  PostingDate,
  SupplierInvoiceIDByInvcgParty,
  InvoicingParty,
  IsInvoice,
  DocumentCurrency,
  InvoiceGrossAmount,
  ExchangeRate,
  AccountingDocumentType,
  SupplierInvoiceStatus,
  SupplierInvoiceOrigin,
  CreatedByUser,
  LastChangedByUser,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  AssignmentReference,
  TaxIsCalculatedAutomatically,
  BusinessPlace,
  CreationDate,
  CreationTime,
  SuplrInvcTransactionCategory,
  UnplannedDeliveryCost,
  UnplannedDeliveryCostTaxCode,
  UnplndDelivCostTaxJurisdiction,
  DocumentHeaderText,
  SupplierPostingLineItemText,
  PaymentTerms,
  DueCalculationBaseDate,
  CashDiscount1Percent,
  CashDiscount1Days,
  CashDiscount2Percent,
  CashDiscount2Days,
  NetPaymentDays,
  ManualCashDiscount,
  FixedCashDiscount,
  StateCentralBankPaymentReason,
  SupplyingCountry,
  BPBankAccountInternalID,
  PaymentMethod,
  PaymentReference,
  PaytSlipWthRefSubscriber,
  PaytSlipWthRefCheckDigit,
  PaytSlipWthRefReference,
  PaymentReason,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  SuplrInvcManuallyReducedAmount,
  SuplrInvcAutomReducedAmount,
  TaxDeterminationDate,
  TaxReportingDate,
  TaxFulfillmentDate,
  TaxCountry,
  UnplndDeliveryCostTaxCountry,
  DeliveryOfGoodsReportingCntry,
  SupplierVATRegistration,
  IsEUTriangularDeal,
  SuplrInvcDebitCrdtCodeDelivery,
  SuplrInvcDebitCrdtCodeReturns,
  ElectronicInvoiceUUID,
  JrnlEntryCntrySpecificRef1,
  JrnlEntryCntrySpecificDate1,
  JrnlEntryCntrySpecificRef2,
  JrnlEntryCntrySpecificDate2,
  JrnlEntryCntrySpecificRef3,
  JrnlEntryCntrySpecificDate3,
  JrnlEntryCntrySpecificRef4,
  JrnlEntryCntrySpecificDate4,
  JrnlEntryCntrySpecificRef5,
  JrnlEntryCntrySpecificDate5,
  JrnlEntryCntrySpecificBP1,
  JrnlEntryCntrySpecificBP2
FROM I_SupplierInvoice
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SuplrInvcItemPurOrdRefAPI01 AS _SuplrInvcItemPurOrdRefAPI01 ON SupplierInvoice = _SuplrInvcItemPurOrdRefAPI01.SupplierInvoice AND FiscalYear = _SuplrInvcItemPurOrdRefAPI01.FiscalYear  -- association [1..*]
LEFT OUTER JOIN I_SuplrInvoiceItemGLAcctAPI01 AS _SuplrInvoiceItemGLAcctAPI01 ON SupplierInvoice = _SuplrInvoiceItemGLAcctAPI01.SupplierInvoice AND FiscalYear = _SuplrInvoiceItemGLAcctAPI01.FiscalYear  -- association [1..*]
LEFT OUTER JOIN I_SupplierInvoiceTaxAPI01 AS _SupplierInvoiceTaxAPI01 ON SupplierInvoice = _SupplierInvoiceTaxAPI01.SupplierInvoice AND FiscalYear = _SupplierInvoiceTaxAPI01.FiscalYear  -- association [1..*]
LEFT OUTER JOIN I_SuplrInvcHeaderWhldgTaxAPI01 AS _SuplrInvcHeaderWhldgTaxAPI01 ON SupplierInvoice = _SuplrInvcHeaderWhldgTaxAPI01.SupplierInvoice AND FiscalYear = _SuplrInvcHeaderWhldgTaxAPI01.FiscalYear  -- association [1..*]
LEFT OUTER JOIN I_SuplrInvcSeldPurgDocAPI01 AS _SuplrInvcSeldPurgDocAPI01 ON SupplierInvoice = _SuplrInvcSeldPurgDocAPI01.SupplierInvoice AND FiscalYear = _SuplrInvcSeldPurgDocAPI01.FiscalYear  -- association [1..*]
LEFT OUTER JOIN I_SuplrInvcSeldDelivNoteAPI01 AS _SuplrInvcSeldDelivNoteAPI01 ON SupplierInvoice = _SuplrInvcSeldDelivNoteAPI01.SupplierInvoice AND FiscalYear = _SuplrInvcSeldDelivNoteAPI01.FiscalYear  -- association [1..*]
LEFT OUTER JOIN I_SuplrInvcSeldInbBOLAPI01 AS _SuplrInvcSeldInbBOLAPI01 ON SupplierInvoice = _SuplrInvcSeldInbBOLAPI01.SupplierInvoice AND FiscalYear = _SuplrInvcSeldInbBOLAPI01.FiscalYear  -- association [1..*]
LEFT OUTER JOIN I_SuplrInvcSeldSESLeanAPI01 AS _SuplrInvcSeldSESLeanAPI01 ON SupplierInvoice = _SuplrInvcSeldSESLeanAPI01.SupplierInvoice AND FiscalYear = _SuplrInvcSeldSESLeanAPI01.FiscalYear  -- association [1..*]
LEFT OUTER JOIN I_SupplierInvoiceBlockAPI01 AS _SupplierInvoiceBlockAPI01 ON SupplierInvoice = _SupplierInvoiceBlockAPI01.SupplierInvoice AND FiscalYear = _SupplierInvoiceBlockAPI01.FiscalYear  -- association [0..*]
LEFT OUTER JOIN E_SupplierInvoice AS _HeaderExtension ON SupplierInvoice = _HeaderExtension.SupplierInvoice AND FiscalYear = _HeaderExtension.FiscalYear AND I_SupplierInvoice.SupplierInvoiceUUID = _HeaderExtension.SupplierInvoiceUUID  -- association [1..1]
;

Depth:

I_SupplierInvoiceAPI01 view

I_SupplierInvoice view