I_DigitalVehicleProduct

DDL: I_DIGITALVEHICLEPRODUCT Type: view_entity COMPOSITE Package: ISAUTO_VLC_LEAN
9 Fields 2 Data Sources 1 Associations

Digital Vehicle Product

I_DigitalVehicleProduct is a Composite CDS View that provides data about "Digital Vehicle Product" in SAP S/4HANA. It reads from 2 data sources (I_Material, I_ProductPlantBasic) and exposes 9 fields with key fields Material, Plant. It has 1 association to related views. Part of development package ISAUTO_VLC_LEAN.

Data Sources (2)

SourceAliasJoin Type
I_Material _Material inner
I_ProductPlantBasic _ProductPlant from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaterialTypeText _MaterialTypeText $projection.MaterialType = _MaterialTypeText.MaterialType and _MaterialTypeText.Language = $session.system_language

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Digital Vehicle Product view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
Search.searchable true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Material I_Material Material Vehicle Model
KEY Plant I_ProductPlantBasic Plant Valuation Area
MaterialName
PlantName
ProductGroupText
MaterialType I_Material MaterialType Material Type
MaterialTypeName
UnitOfMeasure
UnitOfMeasureText

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_DigitalVehicleProduct.
-- 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_DigitalVehicleProduct AS
SELECT
  _Material.Material AS Material,
  _ProductPlant.Plant AS Plant,
  _Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  _ProductPlant._Plant.PlantName AS PlantName,
  _ProductPlant._Product._ProductGroupText[1: Language = $session.system_language].MaterialGroupText AS ProductGroupText,
  _Material.MaterialType AS MaterialType,
  _MaterialTypeText[1: Language = $session.system_language].MaterialTypeName AS MaterialTypeName,
  _ProductPlant._ProdControlTemperatureUnit.UnitOfMeasure AS UnitOfMeasure,
  _ProductPlant._ProdCtrlTemperatureUnitText[ 1: Language = $session.system_language].UnitOfMeasureName AS UnitOfMeasureText
FROM I_ProductPlantBasic AS _ProductPlant
INNER JOIN I_Material AS _Material ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialTypeText AS _MaterialTypeText ON MaterialType = _MaterialTypeText.MaterialType AND _MaterialTypeText.Language = $session.system_language  -- association [0..1]
;

Learn More