I_JITCallCompMatlRefTextEnhcd

DDL: I_JITCALLCOMPMATLREFTEXTENHCD Type: view_entity COMPOSITE
21 Fields 1 Data Sources

JIT CompMaterial Reference Enhancement

I_JITCallCompMatlRefTextEnhcd is a Composite CDS View that provides data about "JIT CompMaterial Reference Enhancement" in SAP S/4HANA. It reads from 1 data source (I_JITCallCompMaterialBasic) and exposes 21 fields with key field JITObjectUUID.

Data Sources (1)

SourceAliasJoin Type
I_JITCallCompMaterialBasic JITCallComponent from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label JIT CompMaterial Reference Enhancement view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY JITObjectUUID I_JITCallCompMaterialBasic JITCallComponentUUID NodeID
JITHeaderUUID I_JITCallCompMaterialBasic JITHeaderUUID NodeID
InternalJITCallNumber I_JITCallCompMaterialBasic InternalJITCallNumber JIT Call Number
CompGrpNumber I_JITCallCompMaterialBasic CompGrpNumber Component Group No.
JITCallCompGrpUUID I_JITCallCompMaterialBasic JITCallCompGrpUUID NodeID
FirstCompMatlRefType ReferenceText_1 JITRefType Reference Type
FirstCompMatlRefText ReferenceText_1 JITRefText
FirstCompMatlRefTypeDesc
SecondCompMatlRefType ReferenceText_2 JITRefType Reference Type
SecondCompMatlRefText ReferenceText_2 JITRefText
SecondCompMatlRefTypeDesc
ThirdCompMatlRefType ReferenceText_3 JITRefType Reference Type
ThirdCompMatlRefText ReferenceText_3 JITRefText
ThirdCompMatlRefTypeDesc
FourthCompMatlRefType ReferenceText_4 JITRefType Reference Type
FourthCompMatlRefText ReferenceText_4 JITRefText
FourthCompMatlRefTypeDesc
FifthCompMatlRefType ReferenceText_5 JITRefType Reference Type
FifthCompMatlRefText ReferenceText_5 JITRefText
FifthCompMatlRefTypeDesc
_JITCallCompGroupBasic I_JITCallCompMaterialBasic _JITCallCompGroupBasic

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_JITCallCompMatlRefTextEnhcd.
-- 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_JITCallCompMatlRefTextEnhcd AS
SELECT
  JITCallComponent.JITCallComponentUUID AS JITObjectUUID,
  JITCallComponent.JITHeaderUUID AS JITHeaderUUID,
  JITCallComponent.InternalJITCallNumber AS InternalJITCallNumber,
  JITCallComponent.CompGrpNumber AS CompGrpNumber,
  JITCallComponent.JITCallCompGrpUUID AS JITCallCompGrpUUID,
  ReferenceText_1.JITRefType AS FirstCompMatlRefType,
  ReferenceText_1.JITRefText AS FirstCompMatlRefText,
  ReferenceText_1._JITReferenceType._JITReferenceTypeDesc[1: Language = $session.system_language ].JITReferenceTypeDescription AS FirstCompMatlRefTypeDesc,
  ReferenceText_2.JITRefType AS SecondCompMatlRefType,
  ReferenceText_2.JITRefText AS SecondCompMatlRefText,
  ReferenceText_2._JITReferenceType._JITReferenceTypeDesc[1: Language = $session.system_language ].JITReferenceTypeDescription AS SecondCompMatlRefTypeDesc,
  ReferenceText_3.JITRefType AS ThirdCompMatlRefType,
  ReferenceText_3.JITRefText AS ThirdCompMatlRefText,
  ReferenceText_3._JITReferenceType._JITReferenceTypeDesc[1: Language = $session.system_language ].JITReferenceTypeDescription AS ThirdCompMatlRefTypeDesc,
  ReferenceText_4.JITRefType AS FourthCompMatlRefType,
  ReferenceText_4.JITRefText AS FourthCompMatlRefText,
  ReferenceText_4._JITReferenceType._JITReferenceTypeDesc[1: Language = $session.system_language ].JITReferenceTypeDescription AS FourthCompMatlRefTypeDesc,
  ReferenceText_5.JITRefType AS FifthCompMatlRefType,
  ReferenceText_5.JITRefText AS FifthCompMatlRefText,
  ReferenceText_5._JITReferenceType._JITReferenceTypeDesc[1: Language = $session.system_language ].JITReferenceTypeDescription AS FifthCompMatlRefTypeDesc,
  JITCallComponent._JITCallCompGroupBasic AS _JITCallCompGroupBasic
FROM I_JITCallCompMaterialBasic AS JITCallComponent
;

Learn More