What is I_SuplrInvcItmAcctAssgmtAPI01 in SAP S/4HANA?

I_SuplrInvcItmAcctAssgmtAPI01 is a composite CDS view in SAP S/4HANA. Account Assignment for Supplier Invoice It contains 49 fields.

Which tables does I_SuplrInvcItmAcctAssgmtAPI01 read from?

I_SuplrInvcItmAcctAssgmtAPI01 reads data from: I_SupplierInvoiceAPI01, I_SupplierInvoiceItmAcctAssgmt.

What VDM layer is I_SuplrInvcItmAcctAssgmtAPI01?

I_SuplrInvcItmAcctAssgmtAPI01 is classified as a Composite view that combines data from multiple basic views.

I_SuplrInvcItmAcctAssgmtAPI01

DDL: I_SUPLRINVCITMACCTASSGMTAPI01 SQL: ISUINITACASAPI01 Type: view COMPOSITE Package: VDM_MM_IV_SI_API

49 Fields 2 Data Sources 2 Associations

Account Assignment for Supplier Invoice

I_SuplrInvcItmAcctAssgmtAPI01 (Composite)

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

Sourcing & Procurement

I_SuplrInvcItmAcctAssgmtAPI01 is a Composite CDS View that provides data about "Account Assignment for Supplier Invoice" in SAP S/4HANA. It reads from 2 data sources (I_SupplierInvoiceAPI01, I_SupplierInvoiceItmAcctAssgmt) and exposes 49 fields with key fields SupplierInvoice, FiscalYear, SupplierInvoiceItem, OrdinalNumber. It has 2 associations to related views. Part of development package VDM_MM_IV_SI_API.

SAP Help Documentation

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

Purpose
This CDS view enables you to get information about the account assignment data of supplier invoice items, for example the G/L account, amount, quantity, tax code and the cost center. This CDS view provides the prerequisites for answering the following business questions: To which accounts were the supplier invoices posted last year? To which cost centers were the supplier invoices posted last year?

Prerequisites
Users who want to run reports using this CDS view must have a role based on the business role template listed in the table above. In this role, the following restriction types must be set to read access: BURKS ( Company Code ) WERKS ( Plant ) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Object types This view relates to the following SAP object types: SupplierInvoice CostCenter ProfitCenter SalesOrder Main CDS parameters The main CDS parameters are: SUPPLIERINVOICE used to specify the supplier invoices FISCALYEAR used to specify the fiscal year SUPPLIERINVOICEITEM used to specify the supplier invoice item COSTCENTER used to specify the Cost Center CONTROLLINGAREA used to specify the Controlling Area BUSINESSAREA used to specify the Business Area PROFITCENTER used to specify the Profit Center FUNCTIONALAREA used to specify the functional area GLACCOUNT used to specify the G/L Account Number SALESORDER used to specify the sales order SALESORDERITEM used to specify the sales order item COSTOBJECT used to specify the cost object

View on SAP Help Portal →

SAP API Hub

Category	Composite
State	C1
Line of Business	Sourcing & Procurement
Application Component	MM-IV-LIV-2CL
Capabilities	Data Source for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Sourcing and Procurement for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view enables you to get information about the account assignment data of supplier invoice items, for example the G/L account, amount, quantity, tax code and the cost center.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>To which accounts were the supplier invoices posted last year?</p></li> <li> <p>To which cost centers were the supplier invoices posted last year?</p> </li> </ul>

Documentation

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

Data Sources (2)

Source	Alias	Join Type
I_SupplierInvoiceAPI01	I_SupplierInvoiceAPI01	inner
I_SupplierInvoiceItmAcctAssgmt	I_SupplierInvoiceItmAcctAssgmt	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_SupplierInvoiceAPI01	_SupplierInvoiceAPI01	`_SupplierInvoiceAPI01.SupplierInvoice = $projection.SupplierInvoice and _SupplierInvoiceAPI01.FiscalYear = $projection.FiscalYear`
[1..1]	I_SuplrInvcItemPurOrdRefAPI01	_SuplrInvcItemPurOrdRefAPI01	`_SuplrInvcItemPurOrdRefAPI01.SupplierInvoice = $projection.SupplierInvoice and _SuplrInvcItemPurOrdRefAPI01.FiscalYear = $projection.FiscalYear and _SuplrInvcItemPurOrdRefAPI01.SupplierInvoiceItem = $projection.SupplierInvoiceItem`

Annotations (13)

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

Fields (49)

Key	Field	Source Table	Source Field	Description
KEY	SupplierInvoice	I_SupplierInvoiceItmAcctAssgmt	SupplierInvoice	Document Number of an Accounting Document
KEY	FiscalYear	I_SupplierInvoiceItmAcctAssgmt	FiscalYear	G/L Fiscal Year
KEY	SupplierInvoiceItem		SupplierInvoiceItem	Document Item in Invoice Document
KEY	OrdinalNumber		OrdinalNumber	Four Character Sequential Number for Coding Block
	CostCenter		CostCenter	Cost Center
	ControllingArea		ControllingArea	Controlling Area
	BusinessArea		BusinessArea	Business Area
	ProfitCenter		ProfitCenter	Profit Center
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	GLAccount		GLAccount	G/L Account Number
	SalesOrder		SalesOrder	Sales and Distribution Document Number
	SalesOrderItem		SalesOrderItem	Sales document item
	CostObject		CostObject	Cost Object
	CostCtrActivityType		CostCtrActivityType	Activity Type
	BusinessProcess		BusinessProcess	Business Process
	WBSElementInternalID		WBSElementInternalID	Work Breakdown Structure Element (WBS Element)
	WBSElementInternalID_2		WBSElementInternalID_2	WBS Element
	DocumentCurrency	I_SupplierInvoiceItmAcctAssgmt	DocumentCurrency	Document Currency
	SupplierInvoiceItemAmount		SupplierInvoiceItemAmount	Amount in Document Currency
	PurchaseOrderQuantityUnit		PurchaseOrderQuantityUnit	Purchase Order Unit of Measure
	Quantity		Quantity	Quantity
	TaxCode		TaxCode	Tax on Sales/Purchases Code
	AccountAssignmentNumber		AccountAssignmentNumber	Sequential Number of Account Assignment
	AccountAssignmentIsUnplanned		AccountAssignmentIsUnplanned	Unplanned Account Assignment from Invoice Verification
	PersonnelNumber		PersonnelNumber	Personnel Number
	WorkItem		WorkItem	Work Item ID
	MasterFixedAsset		MasterFixedAsset	Main Asset Number
	FixedAsset		FixedAsset	Asset Subnumber
	DebitCreditCode		DebitCreditCode	Debit/Credit Indicator
	TaxJurisdiction		TaxJurisdiction	Tax Jurisdiction
	InternalOrder		InternalOrder	Order Number
	ProjectNetworkInternalID		ProjectNetworkInternalID	Routing Number of Operations in the Order
	NetworkActivityInternalID		NetworkActivityInternalID	Routing Number of Operations in the Order
	ProjectNetwork		ProjectNetwork	Network Number for Account Assignment
	NetworkActivity		NetworkActivity	Operation/Activity
	CommitmentItem		CommitmentItem	Commitment item
	FundsCenter		FundsCenter	Funds Center
	Fund		Fund	Sender Fund
	GrantID		GrantID	Sender Grant
	PartnerBusinessArea		PartnerBusinessArea	Trading Partner's Business Area
	TaxCountry	I_SupplierInvoiceItmAcctAssgmt	TaxCountry	Tax Reporting Country/Region
	ServiceDocument		ServiceDocument	Service Document ID
	ServiceDocumentItem		ServiceDocumentItem	Service Document Item ID
	ServiceDocumentType		ServiceDocumentType	Service Document Type
	_SupplierInvoiceAPI01		_SupplierInvoiceAPI01
	_SuplrInvcItemPurOrdRefAPI01		_SuplrInvcItemPurOrdRefAPI01
	_Currency	I_SupplierInvoiceItmAcctAssgmt	_Currency
	_UnitOfMeasure		_UnitOfMeasure
	_WBSElementBasicData		_WBSElementBasicData

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_SuplrInvcItmAcctAssgmtAPI01.
-- 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: ISUINITACASAPI01

CREATE VIEW I_SuplrInvcItmAcctAssgmtAPI01 AS
SELECT
  I_SupplierInvoiceItmAcctAssgmt.SupplierInvoice AS SupplierInvoice,
  I_SupplierInvoiceItmAcctAssgmt.FiscalYear AS FiscalYear,
  SupplierInvoiceItem,
  OrdinalNumber,
  CostCenter,
  ControllingArea,
  BusinessArea,
  ProfitCenter,
  FunctionalArea,
  GLAccount,
  SalesOrder,
  SalesOrderItem,
  CostObject,
  CostCtrActivityType,
  BusinessProcess,
  WBSElementInternalID,
  WBSElementInternalID_2,
  I_SupplierInvoiceItmAcctAssgmt.DocumentCurrency AS DocumentCurrency,
  SupplierInvoiceItemAmount,
  PurchaseOrderQuantityUnit,
  Quantity,
  TaxCode,
  AccountAssignmentNumber,
  AccountAssignmentIsUnplanned,
  PersonnelNumber,
  WorkItem,
  MasterFixedAsset,
  FixedAsset,
  DebitCreditCode,
  TaxJurisdiction,
  InternalOrder,
  ProjectNetworkInternalID,
  NetworkActivityInternalID,
  ProjectNetwork,
  NetworkActivity,
  CommitmentItem,
  FundsCenter,
  Fund,
  GrantID,
  PartnerBusinessArea,
  I_SupplierInvoiceItmAcctAssgmt.TaxCountry AS TaxCountry,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  I_SupplierInvoiceItmAcctAssgmt._Currency AS _Currency
FROM I_SupplierInvoiceItmAcctAssgmt
INNER JOIN I_SupplierInvoiceAPI01 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupplierInvoiceAPI01 AS _SupplierInvoiceAPI01 ON _SupplierInvoiceAPI01.SupplierInvoice = SupplierInvoice AND _SupplierInvoiceAPI01.FiscalYear = FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_SuplrInvcItemPurOrdRefAPI01 AS _SuplrInvcItemPurOrdRefAPI01 ON _SuplrInvcItemPurOrdRefAPI01.SupplierInvoice = SupplierInvoice AND _SuplrInvcItemPurOrdRefAPI01.FiscalYear = FiscalYear AND _SuplrInvcItemPurOrdRefAPI01.SupplierInvoiceItem = SupplierInvoiceItem  -- association [1..1]
;

Depth:

I_SuplrInvcItmAcctAssgmtAPI01 view

I_SupplierInvoiceItmAcctAssgmt view
I_SupplierInvoiceAPI01 view