I_EngSnpshtIDVH

DDL: I_ENGSNPSHTIDVH SQL: IENGSNPIDVH Type: view COMPOSITE Package: VDM_MPE_PLAN_ENG_SNPSHT
6 Fields 1 Associations

Engineering Snapshot ID

I_EngSnpshtIDVH is a Composite CDS View that provides data about "Engineering Snapshot ID" in SAP S/4HANA. It has 1 association to related views. Part of development package VDM_MPE_PLAN_ENG_SNPSHT.

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_EngSnpshtTypeText _EngSnpshtTypeText Header.EngSnapshotType = _EngSnpshtTypeText.EngSnapshotType

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IENGSNPIDVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
Search.searchable true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey EngSnapshotID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Consumption.ranked true view
EndUserText.label Engineering Snapshot ID view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY EngSnapshotID Header EngSnapshotID
EngSnapshotName Header EngSnapshotName
EngSnapshotTypeText
Material Header Material Vehicle Model
Plant Header Plant Valuation Area
BillOfMaterialVariantUsage Header BillOfMaterialVariantUsage Usage

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_EngSnpshtIDVH.
-- 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: IENGSNPIDVH

CREATE VIEW I_EngSnpshtIDVH AS
SELECT
  Header.EngSnapshotID AS EngSnapshotID,
  Header.EngSnapshotName AS EngSnapshotName,
  _EngSnpshtTypeText[1: Language = $session.system_language ].EngSnapshotTypeText AS EngSnapshotTypeText,
  Header.Material AS Material,
  Header.Plant AS Plant,
  Header.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage
LEFT OUTER JOIN I_EngSnpshtTypeText AS _EngSnpshtTypeText ON Header.EngSnapshotType = _EngSnpshtTypeText.EngSnapshotType  -- association [0..*]
;

Learn More