What is I_OIL_QtySchedBreakdownCodeVH in SAP S/4HANA?

I_OIL_QtySchedBreakdownCodeVH is a basic CDS view in SAP S/4HANA. Quantity Schedule Breakdown It contains 5 fields.

Which tables does I_OIL_QtySchedBreakdownCodeVH read from?

I_OIL_QtySchedBreakdownCodeVH reads data from: toia3.

What VDM layer is I_OIL_QtySchedBreakdownCodeVH?

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

I_OIL_QtySchedBreakdownCodeVH

DDL: I_OIL_QTYSCHEDBREAKDOWNCODEVH Type: view_entity BASIC

5 Fields 1 Data Sources 2 Associations

Quantity Schedule Breakdown

I_OIL_QtySchedBreakdownCodeVH is a Basic CDS View that provides data about "Quantity Schedule Breakdown" in SAP S/4HANA. It reads from 1 data source (toia3) and exposes 5 fields with key field QuantityScheduleBreakdown. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
toia3	toia3	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..*]	I_OIL_QtySchedBreakdownCodeTxt	_Text	`_Text.QuantityScheduleBreakdown = $projection.QuantityScheduleBreakdown`
[1..1]	I_OIL_ExchangeDurationUnitVH	_ExchangeDurationUnitVH	`_ExchangeDurationUnitVH.UnitOfDurationExchange = $projection.UnitOfDurationExchange`

Annotations (13)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
Analytics.internalName	#LOCAL	view
Analytics.technicalName	IOILQtySchedBreakdownCodeVH	view
EndUserText.label	Quantity Schedule Breakdown	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.dataCategory	#VALUE_HELP	view
ObjectModel.representativeKey	QuantityScheduleBreakdown	view
ObjectModel.sapObjectNodeType.name	OIL_ExchangeBreakdownIndicator	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
Search.searchable	true	view
VDM.viewType	#BASIC	view

Fields (5)

Key	Field	Source Field	Description
KEY	QuantityScheduleBreakdown	entlu	QS breakdown
	ExchangePeriodDuration	durat	Trsp. Duration
	UnitOfDurationExchange	durun	Unit/duration
	_Text	_Text
	_ExchangeDurationUnitVH	_ExchangeDurationUnitVH

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_OIL_QtySchedBreakdownCodeVH.
-- 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_OIL_QtySchedBreakdownCodeVH AS
SELECT
  entlu AS QuantityScheduleBreakdown,
  durat AS ExchangePeriodDuration,
  durun AS UnitOfDurationExchange
FROM toia3
LEFT OUTER JOIN I_OIL_QtySchedBreakdownCodeTxt AS _Text ON _Text.QuantityScheduleBreakdown = QuantityScheduleBreakdown  -- association [1..*]
LEFT OUTER JOIN I_OIL_ExchangeDurationUnitVH AS _ExchangeDurationUnitVH ON _ExchangeDurationUnitVH.UnitOfDurationExchange = UnitOfDurationExchange  -- association [1..1]
;

Depth:

I_OIL_QtySchedBreakdownCodeVH view_entity

toia3