What is I_GLAccountLineItemStdVH in SAP S/4HANA?

I_GLAccountLineItemStdVH is a composite CDS view in SAP S/4HANA. G/L Account Line Item It contains 50 fields.

Which tables does I_GLAccountLineItemStdVH read from?

I_GLAccountLineItemStdVH reads data from: I_GLAccountLineItem.

What VDM layer is I_GLAccountLineItemStdVH?

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

I_GLAccountLineItemStdVH

DDL: I_GLACCOUNTLINEITEMSTDVH Type: view COMPOSITE

50 Fields 1 Data Sources

G/L Account Line Item

I_GLAccountLineItemStdVH (Composite)

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

Accounting and Financial Close

I_GLAccountLineItemStdVH is a Composite CDS View (Dimension) that provides data about "G/L Account Line Item" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItem) and exposes 50 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

SAP Help Documentation

Category	CDS Views for Master Data
Data Category	Dimension

Purpose
This CDS view is designed to provide a value help for G/L account line items. It serves as a dimension in analytics, offering a structured way to access and utilize data related to general ledger line items. The view is intended to be used as a value help provider, facilitating the selection and association of G/L account line items in various business processes. This view provides value help for LedgerGLLineItem . This view should be used for value help purposes only. This CDS view provides the data to answer the following business questions: What are the available G/L account line items for a specific ledger and fiscal year? How can I retrieve the key identifiers for G/L account line items, such as Source Ledger, Company Code, Fiscal Year, Accounting Document, and Ledger? What are the associations between G/L account line items and other financial dimensions like cost centers, profit centers, and controlling areas? How can I access hidden attributes related to G/L account line items for internal processing or reporting purposes? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: Restriction Type ID Restriction Type A_B_ANLKL Asset Postings: Company Code/Asset Class BEGRU_BKPF_BEK Authorization Group for Supplier-Related Journal Entries BEGRU_BKPF_BED Authorization Group for Customer Related Journal Entries SEGMENT_GLRRCTY Segment for Segmental Reporting/Record Type BUKRS_GLRLDNR_GLRRCTY_GLRVERS Company Code/Ledger/Record Type/Version BUKRS_PRCTR_KSTAR Company Code/ Profit Center / Cost Element SALES_AREA_OFFICE_GROUP Sales Area / Sales Office / Sales Group BEGRU_BKPF_BLA Authorization Groups for Journal Entry Document Type KOART Account Type COMPANYCODE_HIERARCHY Company Code Hierarchies BWKEY Valuation Area AUART Sales Document Type DATE Due Date for Authority Check KOSTL_KSTAR Cost Center/Cost Element FKBER Functional Area F_BKPF_ORD Order Category / Order Type for Journal Entries SALES_AREA Sales Area BUKRS Company Code You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-FIO-GL-IS
Capabilities	Data Provider for Value Help
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition

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 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_GLAccountLineItem	I_GLAccountLineItem	from

Annotations (18)

Name	Value	Level
AbapCatalog.sqlViewName	IFIGLALI__VH	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
Analytics.dataCategory	#DIMENSION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	G/L Account Line Item	view
ObjectModel.dataCategory	#VALUE_HELP	view
ObjectModel.representativeKey	LedgerGLLineItem	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.modelingPattern	#VALUE_HELP_PROVIDER	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#COMPOSITE	view

Fields (50)

Key	Field	Source Field	Description
KEY	SourceLedger	SourceLedger	Source Ledger
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	FiscalYear	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	LedgerGLLineItem	General Ledger Journal Entry Line Item
KEY	Ledger	Ledger	Ledger in General Ledger Accounting
	AccountingDocumentType	AccountingDocumentType	Journal Entry Type
	ControllingArea	ControllingArea	Controlling Area
	CostCenter	CostCenter	Cost Center
	ProfitCenter	ProfitCenter	Profit Center
	Customer	Customer	Customer Number
	MasterFixedAsset	MasterFixedAsset	Fixed Asset
	FixedAsset	FixedAsset	Asset Subnumber
	GLAccount	GLAccount	General Ledger
	Supplier	Supplier	Supplier
	BusinessArea	BusinessArea	Business Area
	DistributionChannel	DistributionChannel	Distribution Channel
	FinancialAccountType	FinancialAccountType	Fin. Account Type
	OrderType	OrderType	Order Type
	OrganizationDivision	OrganizationDivision	Org. Division
	Plant	Plant	Valuation Area
	SalesOrderType	SalesOrderType	Sales Document Type
	SalesOrganization	SalesOrganization	Sales Organization
	Segment	Segment	Segment for Segmental Reporting
	ValuationArea	ValuationArea	Valuation Area
	SalesDocument	SalesDocument	Sales Document
	OrderID	OrderID	Order ID
	ServiceDocumentType	ServiceDocumentType	Service Document Type
	ServiceDocument	ServiceDocument	Service Document ID
	AssetClass	AssetClass	Asset Class
	PostingDate	PostingDate	Posting Date for GR
	FunctionalArea	FunctionalArea	Sendr Fctl Area
	_CostCenter	_CostCenter
	_ProfitCenter	_ProfitCenter
	_SourceLedger	_SourceLedger
	_CompanyCode	_CompanyCode
	_FiscalYear	_FiscalYear
	_JournalEntry	_JournalEntry
	_Ledger	_Ledger
	_AccountingDocumentType	_AccountingDocumentType
	_ControllingArea	_ControllingArea
	_CurrentCostCenter	_CurrentCostCenter
	_CurrentProfitCenter	_CurrentProfitCenter
	_Customer	_Customer
	_FixedAsset	_FixedAsset
	_GLAccountInCompanyCode	_GLAccountInCompanyCode
	_Supplier	_Supplier
	_SalesDocument	_SalesDocument
	_ServiceDocument	_ServiceDocument
	_Order	_Order

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

CREATE VIEW I_GLAccountLineItemStdVH AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  AccountingDocumentType,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  Customer,
  MasterFixedAsset,
  FixedAsset,
  GLAccount,
  Supplier,
  BusinessArea,
  DistributionChannel,
  FinancialAccountType,
  OrderType,
  OrganizationDivision,
  Plant,
  SalesOrderType,
  SalesOrganization,
  Segment,
  ValuationArea,
  SalesDocument,
  OrderID,
  ServiceDocumentType,
  ServiceDocument,
  AssetClass,
  PostingDate,
  FunctionalArea
FROM I_GLAccountLineItem
;

Depth:

I_GLAccountLineItemStdVH view

I_GLAccountLineItem view_entity