What is I_Materialledgercube_Lit in SAP S/4HANA?

I_Materialledgercube_Lit is a composite CDS view in SAP S/4HANA. Line Item for Material Ledger - Cube It contains 76 fields.

Which tables does I_Materialledgercube_Lit read from?

I_Materialledgercube_Lit reads data from: P_Materialledger_Cube_Lit.

What VDM layer is I_Materialledgercube_Lit?

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

I_Materialledgercube_Lit

DDL: I_MATERIALLEDGERCUBE_LIT SQL: IMLCUBELIT Type: view COMPOSITE

76 Fields 1 Data Sources 3 Associations

Line Item for Material Ledger - Cube

I_Materialledgercube_Lit (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_Materialledgercube_Lit is a Composite CDS View (Cube) that provides data about "Line Item for Material Ledger - Cube" in SAP S/4HANA. It reads from 1 data source (P_Materialledger_Cube_Lit) and exposes 76 fields with key fields SourceLedger, CompanyCode, Ledger, GLAccount, FiscalYear. It has 3 associations to related views.

SAP Help Documentation

Category	CDS Views for Inventory Accounting
Data Category	Cube

Purpose
This CDS view provides material inventory relevant journal entry items per company code, ledger and G/L account. This CDS view provides the data to answer the following business questions: What are the quantities and values per journal entry item that were posted to a material inventory account? 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: BUKRS_GLRLDNR_GLRRCTY_GLRVERS (Company Code/Ledger/Record Type/Version) BWKEY (Valuation Area) BUKRS (Company Code) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description SourceLedger Source Ledger CompanyCode Company Code Ledger Ledger GLAccount G/L Account FiscalYear Fiscal Year AccountingDocument Journal Entry LedgerGLLineItem Journal Entry Item Material Material

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 Source in SQL Select, Data Provider for Analytical Queries, Data Source for Defining CDS Entities
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
P_Materialledger_Cube_Lit	P_Materialledger_Cube_Lit	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	E_JournalEntryItem	_Extension	`$projection.SourceLedger = _Extension.SourceLedger and $projection.CompanyCode = _Extension.CompanyCode and $projection.FiscalYear = _Extension.FiscalYear and $projection.AccountingDocument = _Extension.AccountingDocument and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem`
[0..1]	I_MaterialGroup	_MaterialGroup	`$projection.MaterialGroup = _MaterialGroup.MaterialGroup`
[0..1]	I_ProductPlant	_ProductPlant	`$projection.Material = _ProductPlant.Product and $projection.Plant = _ProductPlant.Plant`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	IMLCUBELIT	view
AbapCatalog.compiler.compareFilter	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#CUBE	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
Search.searchable	true	view
EndUserText.label	Line Item for Material Ledger - Cube	view

Fields (76)

Key	Field	Source Field	Description
KEY	SourceLedger	SourceLedger	Source Ledger
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	Ledger	Ledger	Ledger
KEY	GLAccount	GLAccount	General Ledger
KEY	FiscalYear	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	LedgerGLLineItem	General Ledger Journal Entry Line Item
KEY	Material	Material	Material Number
	ChartOfAccounts	ChartOfAccounts	Chart of Accounts
	AccountingDocumentType	AccountingDocumentType	Journal Entry Type
	ValuationArea	ValuationArea	Valuation Area
	InventoryValuationType	InventoryValuationType	Valuation Type
	FiscalPeriod	FiscalPeriod	Fiscal Period
	LedgerFiscalYear	LedgerFiscalYear	Fiscal Year of Ledger
	PostingDate	PostingDate	Posting Date for GR
	MatlDocLatestPostgDate	MatlDocLatestPostgDate	Posting Date
	ReferenceDocument	ReferenceDocument	Reference Doc. Number
	BusinessTransactionType	BusinessTransactionType	Business Transaction Category
	BusinessTransactionTypeName		Business Transaction Type Name
	DocumentDate	DocumentDate	Journal Entry Date
	ProfitCenter	ProfitCenter	Profit Center
	CostCenter	CostCenter	Cost Center
	Segment	Segment	Segment for Segmental Reporting
	AccountingDocCreatedByUser	AccountingDocCreatedByUser	User which created overhead document
	LastChangeDateTime	LastChangeDateTime	Time Stamp of Creation
	FiscalYearPeriod	FiscalYearPeriod	Fiscal Year Period
	ReferenceDocumentType	ReferenceDocumentType	Reference Document Type
	PurchasingDocument	PurchasingDocument	Purchasing Document
	ProductionOrder	ProductionOrder	Order ID
	TransactionTypeDetermination	TransactionTypeDetermination	Transaction Key
	MaterialGroup	MaterialGroup	Material Group
	MaterialGroupName		Product Group Description
	MaterialValuationClass	MaterialValuationClass	Valuation Class
	InventoryValuationCategory	InventoryValuationCategory	Valuation Category
	ControllingArea	ControllingArea	Controlling Area
	Plant	Plant	Valuation Area
	MaterialLedgerProcessType	MaterialLedgerProcessType	Original Process Category
	MaterialLedgerCategory	MaterialLedgerCategory	Category in Material Update Structure
	CompanyCodeCurrency	CompanyCodeCurrency	Company Code Currency
	AmountInCompanyCodeCurrency	AmountInCompanyCodeCurrency	Amount in Company Code Currency
	SlsPriceAmountInCoCodeCrcy	SlsPriceAmountInCoCodeCrcy	Value at Sales Price in Local Currency
	GroupCurrency	GroupCurrency	Global Currency
	AmountInGroupCurrency	AmountInGroupCurrency	Amount in Global Currency
	FreeDefinedCurrency1	FreeDefinedCurrency1	Freely Defined Currency 1
	AmountInFreeDefinedCurrency1	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FreeDefinedCurrency2	FreeDefinedCurrency2	Freely Defined Currency 2
	AmountInFreeDefinedCurrency2	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FreeDefinedCurrency3	FreeDefinedCurrency3	Freely Defined Currency 3
	AmountInFreeDefinedCurrency3	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FreeDefinedCurrency4	FreeDefinedCurrency4	Freely Defined Currency 4
	AmountInFreeDefinedCurrency4	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FreeDefinedCurrency5	FreeDefinedCurrency5	Freely Defined Currency 5
	AmountInFreeDefinedCurrency5	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FreeDefinedCurrency6	FreeDefinedCurrency6	Freely Defined Currency 6
	AmountInFreeDefinedCurrency6	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FreeDefinedCurrency7	FreeDefinedCurrency7	Freely Defined Currency 7
	AmountInFreeDefinedCurrency7	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FreeDefinedCurrency8	FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInFreeDefinedCurrency8	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	BaseUnit	BaseUnit	Cost Source Unit
	InventoryQty	InventoryQty	Inventory Quantity
	_GLAccountInChartOfAccounts	_GLAccountInChartOfAccounts
	_ChartOfAccounts	_ChartOfAccounts
	_Segment	_Segment
	_Material	_Material
	_CompanyCode	_CompanyCode
	_Ledger	_Ledger
	_ProfitCenter	_ProfitCenter
	_CostCenter	_CostCenter
	_CompanyCodeCurrency	_CompanyCodeCurrency
	_CostSourceUnit	_CostSourceUnit
	_ControllingArea	_ControllingArea
	_BusinessTransactionType	_BusinessTransactionType
	_Plant	_Plant
	_MaterialGroup	_MaterialGroup
	_ProductPlant	_ProductPlant

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_Materialledgercube_Lit.
-- 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: IMLCUBELIT

CREATE VIEW I_Materialledgercube_Lit AS
SELECT
  SourceLedger,
  CompanyCode,
  Ledger,
  GLAccount,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Material,
  ChartOfAccounts,
  AccountingDocumentType,
  ValuationArea,
  InventoryValuationType,
  FiscalPeriod,
  LedgerFiscalYear,
  PostingDate,
  MatlDocLatestPostgDate,
  ReferenceDocument,
  BusinessTransactionType,
  _BusinessTransactionType._Text[1:Language = $session.system_language].BusinessTransactionTypeName AS BusinessTransactionTypeName,
  DocumentDate,
  ProfitCenter,
  CostCenter,
  Segment,
  AccountingDocCreatedByUser,
  LastChangeDateTime,
  FiscalYearPeriod,
  ReferenceDocumentType,
  PurchasingDocument,
  ProductionOrder,
  TransactionTypeDetermination,
  MaterialGroup,
  _MaterialGroup._Text[1:Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  MaterialValuationClass,
  InventoryValuationCategory,
  ControllingArea,
  Plant,
  MaterialLedgerProcessType,
  MaterialLedgerCategory,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  SlsPriceAmountInCoCodeCrcy,
  GroupCurrency,
  AmountInGroupCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  BaseUnit,
  InventoryQty
FROM P_Materialledger_Cube_Lit
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [0..1]
;

Depth:

I_Materialledgercube_Lit view

P_Materialledger_Cube_Lit view