I_JITCallCompSrlNmbrEnhcd

DDL: I_JITCALLCOMPSRLNMBRENHCD Type: view_entity COMPOSITE

JIT Serial Number Display

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

Data Sources (1)

SourceAliasJoin Type
I_JITInbCallComponent I_JITInbCallComponent from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_JITCallCompSrlNmbrInfo _JITCallCompSrlNmbrInfo $projection.JITCallComponentUUID = _JITCallCompSrlNmbrInfo.JITCallComponentUUID
[0..1] I_JITCallCompSrlNmbrRef _JITCallCompSrlNmbrRef $projection.JITCallComponentUUID = _JITCallCompSrlNmbrRef.JITCallComponentUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label JIT Serial Number Display view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY JITCallComponentUUID JITCallComponentUUID NodeID
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_JITCallCompSrlNmbrEnhcd.
-- 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_JITCallCompSrlNmbrEnhcd AS
SELECT
  JITCallComponentUUID,
  JITCallCompGrpUUID
FROM I_JITInbCallComponent
LEFT OUTER JOIN I_JITCallCompSrlNmbrInfo AS _JITCallCompSrlNmbrInfo ON JITCallComponentUUID = _JITCallCompSrlNmbrInfo.JITCallComponentUUID  -- association [1..1]
LEFT OUTER JOIN I_JITCallCompSrlNmbrRef AS _JITCallCompSrlNmbrRef ON JITCallComponentUUID = _JITCallCompSrlNmbrRef.JITCallComponentUUID  -- association [0..1]
;