What is P_Materialledger_Cube_Lit in SAP S/4HANA?

P_Materialledger_Cube_Lit is a composite CDS view in SAP S/4HANA. It contains 89 fields.

Which tables does P_Materialledger_Cube_Lit read from?

P_Materialledger_Cube_Lit reads data from: I_Materialledger_Lit.

What VDM layer is P_Materialledger_Cube_Lit?

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

P_Materialledger_Cube_Lit

DDL: P_MATERIALLEDGER_CUBE_LIT SQL: PMLCUBELIT Type: view COMPOSITE

89 Fields 1 Data Sources

P_Materialledger_Cube_Lit is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_Materialledger_Lit) and exposes 89 fields with key fields SourceLedger, CompanyCode, Ledger, GLAccount, FiscalYear.

Data Sources (1)

Source	Alias	Join Type
I_Materialledger_Lit	I_Materialledger_Lit	from

Annotations (4)

Name	Value	Level
AbapCatalog.sqlViewName	PMLCUBELIT	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view

Fields (89)

Key	Field	Source Table	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	Journal Entry Item
KEY	Material		Material	Vehicle Model
KEY	CostEstimate		CostEstimate	Cost EstimateNo
	ChartOfAccounts		ChartOfAccounts	Node Class
	AccountingDocumentType		AccountingDocumentType	Journal Entry Type
	ValuationArea		ValuationArea	Valuation Area
	InventoryValuationType		InventoryValuationType	Valuation Type
	FiscalPeriod		FiscalPeriod	Tax period
	LedgerFiscalYear		LedgerFiscalYear	Ref. Year1
	PostingDate		PostingDate	Posting Date for GR
	MatlDocLatestPostgDate		MatlDocLatestPostgDate	Posting Date
	ReferenceDocument		ReferenceDocument	Reference Document
	BusinessTransactionType		BusinessTransactionType	Bus.transaction
	DocumentDate		DocumentDate	Journal Entry Date
	ProfitCenter		ProfitCenter	Profit Center
	CostCenter		CostCenter	Cost Center
	Segment		Segment	Segment number
	AccountingDocCreatedByUser		AccountingDocCreatedByUser	User which created overhead document
	LastChangeDateTime		LastChangeDateTime	Timestamp
	FiscalYearPeriod		FiscalYearPeriod	Period/Year
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	PurchasingDocument		PurchasingDocument	Purchasing Document
	ProductionOrder		ProductionOrder	Order
	TransactionTypeDetermination		TransactionTypeDetermination	Transaction Key
	MaterialGroup	_Material	MaterialGroup	Product Group
	MaterialValuationClass	_MaterialValuation	MaterialValuationClass	Valuation Class
	InventoryValuationCategory	_MaterialValuation	InventoryValuationCategory
	ControllingArea		ControllingArea	Controlling Area
	Plant		Plant	Valuation Area
	MaterialLedgerProcessType		MaterialLedgerProcessType	Orig. proc.cat.
	MaterialLedgerCategory		MaterialLedgerCategory	Category
	IsSupplierStockValuation		IsSupplierStockValuation	Vendor stk val.
	InventorySpecialStockValnType		InventorySpecialStockValnType	Valuation
	InventorySpclStkSalesDocument		InventorySpclStkSalesDocument	SD Doc of Inv.
	InventorySpclStkSalesDocItm		InventorySpclStkSalesDocItm	SD Item of Inv.
	WBSElementInternalID		WBSElementInternalID	WBS Internal ID
	InventorySpecialStockSupplier		InventorySpecialStockSupplier	Vendor of Inv.
	CompanyCodeCurrencyRole		CompanyCodeCurrencyRole	Field Name
	CurrencyRole		CurrencyRole	Curr./Val. Type
	FreeDefinedCurrency1Role		FreeDefinedCurrency1Role	FreeDef Crcy 1
	FreeDefinedCurrency2Role		FreeDefinedCurrency2Role	FreeDef Crcy 2
	FreeDefinedCurrency3Role		FreeDefinedCurrency3Role	FreeDef Crcy 3
	FreeDefinedCurrency4Role		FreeDefinedCurrency4Role	FreeDef Crcy 4
	FreeDefinedCurrency5Role		FreeDefinedCurrency5Role	FreeDef Crcy 5
	FreeDefinedCurrency6Role		FreeDefinedCurrency6Role	FreeDef Crcy 6
	FreeDefinedCurrency7Role		FreeDefinedCurrency7Role	FreeDef Crcy 7
	FreeDefinedCurrency8Role		FreeDefinedCurrency8Role	FreeDef Crcy 8
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency	Local Crcy Amt
	SlsPriceAmountInCoCodeCrcy		SlsPriceAmountInCoCodeCrcy	Sales Price Book Value
	GroupCurrency		GroupCurrency	Ledger curr.
	AmountInGroupCurrency		AmountInGroupCurrency	Amnt in GrpCrcy
	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	Unit of Measure
	InventoryQty		InventoryQty
	_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

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 P_Materialledger_Cube_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: PMLCUBELIT

CREATE VIEW P_Materialledger_Cube_Lit AS
SELECT
  SourceLedger,
  CompanyCode,
  Ledger,
  GLAccount,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Material,
  CostEstimate,
  ChartOfAccounts,
  AccountingDocumentType,
  ValuationArea,
  InventoryValuationType,
  FiscalPeriod,
  LedgerFiscalYear,
  PostingDate,
  MatlDocLatestPostgDate,
  ReferenceDocument,
  BusinessTransactionType,
  DocumentDate,
  ProfitCenter,
  CostCenter,
  Segment,
  AccountingDocCreatedByUser,
  LastChangeDateTime,
  FiscalYearPeriod,
  ReferenceDocumentType,
  PurchasingDocument,
  ProductionOrder,
  TransactionTypeDetermination,
  _Material.MaterialGroup AS MaterialGroup,
  _MaterialValuation.MaterialValuationClass AS MaterialValuationClass,
  _MaterialValuation.InventoryValuationCategory AS InventoryValuationCategory,
  ControllingArea,
  Plant,
  MaterialLedgerProcessType,
  MaterialLedgerCategory,
  IsSupplierStockValuation,
  InventorySpecialStockValnType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  WBSElementInternalID,
  InventorySpecialStockSupplier,
  CompanyCodeCurrencyRole,
  CurrencyRole,
  FreeDefinedCurrency1Role,
  FreeDefinedCurrency2Role,
  FreeDefinedCurrency3Role,
  FreeDefinedCurrency4Role,
  FreeDefinedCurrency5Role,
  FreeDefinedCurrency6Role,
  FreeDefinedCurrency7Role,
  FreeDefinedCurrency8Role,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  SlsPriceAmountInCoCodeCrcy,
  GroupCurrency,
  AmountInGroupCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  BaseUnit,
  InventoryQty
FROM I_Materialledger_Lit
;

Depth:

P_Materialledger_Cube_Lit view

I_Materialledger_Lit view

I_Materialledgercube_Lit view