What is I_ProdnVersMRPDistrKey in SAP S/4HANA?

I_ProdnVersMRPDistrKey is a basic CDS view in SAP S/4HANA. MRP Distribution Key It contains 6 fields.

Which tables does I_ProdnVersMRPDistrKey read from?

I_ProdnVersMRPDistrKey reads data from: t437v.

What VDM layer is I_ProdnVersMRPDistrKey?

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

I_ProdnVersMRPDistrKey

DDL: I_PRODNVERSMRPDISTRKEY SQL: IPVDISTRKEY Type: view BASIC

6 Fields 1 Data Sources 2 Associations

MRP Distribution Key

I_ProdnVersMRPDistrKey is a Basic CDS View that provides data about "MRP Distribution Key" in SAP S/4HANA. It reads from 1 data source (t437v) and exposes 6 fields with key fields Plant, DistributionKey. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
t437v	t437v	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	I_ProdnVersMRPDistrKeyText	_DistrKeyTxt	`$projection.DistributionKey = _DistrKeyTxt.DistributionKey`
[0..1]	I_Plant	_Plant	`$projection.Plant = _Plant.Plant`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	IPVDISTRKEY	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	MRP Distribution Key	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Search.searchable	true	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	I_MRPQuantityDistributionKey	view

Fields (6)

Key	Field	Source Table	Source Field	Description
KEY	Plant	t437v	werks	Receiving Plant
KEY	DistributionKey	t437v	vertl	Int. dist. key
	DistributionFunction	t437v	funct	Function
	DistributionType	t437v	fnart	Distrib. Type
	_DistrKeyTxt		_DistrKeyTxt
	_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 I_ProdnVersMRPDistrKey.
-- 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: IPVDISTRKEY

CREATE VIEW I_ProdnVersMRPDistrKey AS
SELECT
  t437v.werks AS Plant,
  t437v.vertl AS DistributionKey,
  t437v.funct AS DistributionFunction,
  t437v.fnart AS DistributionType
FROM t437v
LEFT OUTER JOIN I_ProdnVersMRPDistrKeyText AS _DistrKeyTxt ON DistributionKey = _DistrKeyTxt.DistributionKey  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;

Depth:

I_ProdnVersMRPDistrKey view

t437v