What is FNDEI_mmpur_ses_ITEM_FILTER in SAP S/4HANA?

FNDEI_mmpur_ses_ITEM_FILTER is a cds CDS view in SAP S/4HANA. Filter View for table mmpur_ses_item It contains 14 fields.

Which tables does FNDEI_mmpur_ses_ITEM_FILTER read from?

FNDEI_mmpur_ses_ITEM_FILTER reads data from: FNDEI_MMPUR_SES_ITEM_BLOCKINGI, mmpur_ses_item.

FNDEI_mmpur_ses_ITEM_FILTER

DDL: FNDEI_MMPUR_SES_ITEM_FILTER SQL: FNDEIFMM_SES_ITM Type: view

14 Fields 2 Data Sources

Filter View for table mmpur_ses_item

FNDEI_mmpur_ses_ITEM_FILTER is a CDS View that provides data about "Filter View for table mmpur_ses_item" in SAP S/4HANA. It reads from 2 data sources (FNDEI_MMPUR_SES_ITEM_BLOCKINGI, mmpur_ses_item) and exposes 14 fields with key field mandt.

Data Sources (2)

Source	Alias	Join Type
FNDEI_MMPUR_SES_ITEM_BLOCKINGI	FNDEI_MMPUR_SES_ITEM_BLOCKINGI	inner
mmpur_ses_item	mmpur_ses_item	from

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	FNDEIFMM_SES_ITM	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#AUTOMATED	view
EndUserText.label	Filter View for table mmpur_ses_item	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.serviceQuality	#B	view
VDM.lifecycle.status	#DEPRECATED	view

Fields (14)

Key	Field	Source Table	Source Field	Description
KEY	mandt	mmpur_ses_item	mandt	Editing Client
	crea_uname	mmpur_ses_item	crea_uname	User Name
	lchg_uname	mmpur_ses_item	lchg_uname	User Name
	deletioncode	mmpur_ses_item	deletioncode	Del. Indicator
	service	mmpur_ses_item	service	Service Type
	description	mmpur_ses_item	description	Well Code Des.
	unit	mmpur_ses_item	unit	UoM
	quantity	mmpur_ses_item	quantity	Value
	originobject	mmpur_ses_item	originobject	Reference Document
	workitem	mmpur_ses_item	workitem	Work Item ID
	netamount	mmpur_ses_item	netamount	Stated Amount
	netprice	mmpur_ses_item	netprice	Price per Unit
	productgroup	mmpur_ses_item	productgroup	Product Sold Group
	plant	mmpur_ses_item	plant	Valuation Area

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 FNDEI_mmpur_ses_ITEM_FILTER.
-- 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: FNDEIFMM_SES_ITM

CREATE VIEW FNDEI_mmpur_ses_ITEM_FILTER AS
SELECT
  mmpur_ses_item.mandt AS mandt,
  mmpur_ses_item.crea_uname AS crea_uname,
  mmpur_ses_item.lchg_uname AS lchg_uname,
  mmpur_ses_item.deletioncode AS deletioncode,
  mmpur_ses_item.service AS service,
  mmpur_ses_item.description AS description,
  mmpur_ses_item.unit AS unit,
  mmpur_ses_item.quantity AS quantity,
  mmpur_ses_item.originobject AS originobject,
  mmpur_ses_item.workitem AS workitem,
  mmpur_ses_item.netamount AS netamount,
  mmpur_ses_item.netprice AS netprice,
  mmpur_ses_item.productgroup AS productgroup,
  mmpur_ses_item.plant AS plant
FROM mmpur_ses_item
INNER JOIN FNDEI_MMPUR_SES_ITEM_BLOCKINGI ON /* join condition not captured in parsed metadata */
;

Depth:

FNDEI_mmpur_ses_ITEM_FILTER view