I_JITCallCompGrpSrlNmbrEnhcd

DDL: I_JITCALLCOMPGRPSRLNMBRENHCD Type: view_entity COMPOSITE

JIT Serial Number Display

I_JITCallCompGrpSrlNmbrEnhcd is a Composite CDS View (Dimension) that provides data about "JIT Serial Number Display" in SAP S/4HANA. It reads from 1 data source (I_JITInbCallComponentGroup) and exposes 1 field with key field JITCallCompGrpUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITInbCallComponentGroup I_JITInbCallComponentGroup from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_JITCallCompGrpSrlNmbrInfo _JITCallCompGrpSrlNmbrInfo $projection.JITCallCompGrpUUID = _JITCallCompGrpSrlNmbrInfo.JITCallCompGrpUUID
[0..1] I_JITCallCompGrpSrlNmbrRef _JITCallCompGrpSrlNmbrRef $projection.JITCallCompGrpUUID = _JITCallCompGrpSrlNmbrRef.JITCallCompGrpUUID

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
EndUserText.label JIT Serial Number Display view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey JITCallCompGrpUUID view
VDM.viewType #COMPOSITE view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY JITCallCompGrpUUID JITCallCompGrpUUID NodeID

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_JITCallCompGrpSrlNmbrEnhcd.
-- 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_JITCallCompGrpSrlNmbrEnhcd AS
SELECT
  JITCallCompGrpUUID
FROM I_JITInbCallComponentGroup
LEFT OUTER JOIN I_JITCallCompGrpSrlNmbrInfo AS _JITCallCompGrpSrlNmbrInfo ON JITCallCompGrpUUID = _JITCallCompGrpSrlNmbrInfo.JITCallCompGrpUUID  -- association [1..1]
LEFT OUTER JOIN I_JITCallCompGrpSrlNmbrRef AS _JITCallCompGrpSrlNmbrRef ON JITCallCompGrpUUID = _JITCallCompGrpSrlNmbrRef.JITCallCompGrpUUID  -- association [0..1]
;