What is I_SuplrInvoiceItemGLAcctAPI01 in SAP S/4HANA?

I_SuplrInvoiceItemGLAcctAPI01 is a basic CDS view in SAP S/4HANA. G/L Account Item of Supplier Invoice It contains 48 fields.

Which tables does I_SuplrInvoiceItemGLAcctAPI01 read from?

I_SuplrInvoiceItemGLAcctAPI01 reads data from: I_SupplierInvoiceAPI01, I_SupplierInvoiceItemGLAcct.

What VDM layer is I_SuplrInvoiceItemGLAcctAPI01?

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

I_SuplrInvoiceItemGLAcctAPI01

DDL: I_SUPLRINVOICEITEMGLACCTAPI01 SQL: ISINITGLACCAPI01 Type: view BASIC

48 Fields 2 Data Sources 1 Associations

G/L Account Item of Supplier Invoice

I_SuplrInvoiceItemGLAcctAPI01 (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_SuplrInvoiceItemGLAcctAPI01 is a Basic CDS View that provides data about "G/L Account Item of Supplier Invoice" in SAP S/4HANA. It reads from 2 data sources (I_SupplierInvoiceAPI01, I_SupplierInvoiceItemGLAcct) and exposes 48 fields with key fields SupplierInvoice, FiscalYear, SupplierInvoiceItem. It has 1 association to related views.

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 supplier invoice items that are posted directly to G/L accounts. This CDS view provides the prerequisites for answering the following business questions: Which supplier invoice items are posted directly to G/L accounts? Which G/L accounts were used for directly posting last year?

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 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

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	<p>This CDS view enables you to get information about supplier invoice items that are posted directly to G/L accounts.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which supplier invoice items are posted directly to G/L accounts?</p></li> <li><p>Which G/L accounts were used for directly posting last year?</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 (2)

Source	Alias	Join Type
I_SupplierInvoiceAPI01	I_SupplierInvoiceAPI01	inner
I_SupplierInvoiceItemGLAcct	I_SupplierInvoiceItemGLAcct	from

Associations (1)

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

Annotations (14)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.sqlViewName	ISINITGLACCAPI01	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
EndUserText.label	G/L Account Item of Supplier Invoice	view
ObjectModel.usageType.serviceQuality	#B	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
AbapCatalog.preserveKey	true	view

Fields (48)

Key	Field	Source Table	Source Field	Description
KEY	SupplierInvoice	I_SupplierInvoiceItemGLAcct	SupplierInvoice	Document Number of an Accounting Document
KEY	FiscalYear	I_SupplierInvoiceItemGLAcct	FiscalYear	G/L Fiscal Year
KEY	SupplierInvoiceItem		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
	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
	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_SupplierInvoiceItemGLAcct	DocumentCurrency	Document Currency
	SupplierInvoiceItemAmount		SupplierInvoiceItemAmount	Amount in Document Currency
	TaxCode		TaxCode	Tax on sales/purchases code
	PersonnelNumber		PersonnelNumber	Personnel Number
	WorkItem		WorkItem	Work Item ID
	DebitCreditCode		DebitCreditCode	Debit/Credit Indicator
	TaxJurisdiction		TaxJurisdiction	Tax Jurisdiction
	SupplierInvoiceItemText		SupplierInvoiceItemText	Item Text
	AssignmentReference	I_SupplierInvoiceItemGLAcct	AssignmentReference	Assignment Reference
	IsNotCashDiscountLiable		IsNotCashDiscountLiable	Indicator: Line Item Not Liable to Cash Discount?
	InternalOrder		InternalOrder	Order Number
	CommitmentItem		CommitmentItem	Commitment item
	FundsCenter		FundsCenter	Funds Center
	Fund		Fund	Sender Fund
	GrantID		GrantID	Sender Grant
	QuantityUnit		QuantityUnit	Base Unit of Measure
	Quantity		Quantity	Quantity
	PartnerBusinessArea		PartnerBusinessArea	Trading partner's business area
	FinancialTransactionType		FinancialTransactionType	Transaction type
	ServiceDocument		ServiceDocument	Service Document ID
	ServiceDocumentItem		ServiceDocumentItem	Service Document Item ID
	ServiceDocumentType		ServiceDocumentType	Service Document Type
	CompanyCode	I_SupplierInvoiceItemGLAcct	CompanyCode	Receiver Company Code
	TaxCountry	I_SupplierInvoiceItemGLAcct	TaxCountry	Tax Reporting Country/Region
	_SupplierInvoiceAPI01		_SupplierInvoiceAPI01
	_Currency	I_SupplierInvoiceItemGLAcct	_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_SuplrInvoiceItemGLAcctAPI01.
-- 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: ISINITGLACCAPI01

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

Depth:

I_SuplrInvoiceItemGLAcctAPI01 view

I_SupplierInvoiceItemGLAcct view
I_SupplierInvoiceAPI01 view