P_JITCallAlert

DDL: P_JITCALLALERT Type: view_entity COMPOSITE

P_JITCallAlert is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_JITCallApplicationLog, I_JITCallApplicationLog, I_JITCallApplicationLog) and exposes 25 fields with key field ApplicationLogHandle. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_JITCallApplicationLog _JITWithApplog from
I_JITCallApplicationLog _JITWithApplogOne union_all
I_JITCallApplicationLog _JITWithApplogTwo union_all

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_JITCallHeader _JITCallHeader $projection.JITCallProcessingLogID = _JITCallHeader.JITCallProcessingLogID

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ApplicationLogHandle I_JITCallApplicationLog ApplicationLogHandle Log Handle
ApplicationLogObject I_JITCallApplicationLog ApplicationLogObject TRFM Object
ApplicationLogSubobject I_JITCallApplicationLog ApplicationLogSubobject Triggering obj.
JITCallProcessingLogID I_JITCallApplicationLog JITCallProcessingLogID External ID
ApplicationLog I_JITCallApplicationLog ApplicationLog Log Number
JITHeaderUUID _JITCallHeader JITHeaderUUID NodeID
InternalJITCallNumber _JITCallHeader InternalJITCallNumber JIT Call Number
ExternalJITCallNumber _JITCallHeader ExternalJITCallNumber Ext. JIT Call Number
ApplicationLogHandle Log Handle
ApplicationLogObject I_JITCallApplicationLog ApplicationLogObject TRFM Object
ApplicationLogSubobject I_JITCallApplicationLog ApplicationLogSubobject Triggering obj.
JITCallProcessingLogID I_JITCallApplicationLog JITCallProcessingLogID External ID
ApplicationLog I_JITCallApplicationLog ApplicationLog Log Number
JITHeaderUUID _JITCallHeader JITHeaderUUID NodeID
InternalJITCallNumber _JITCallHeader InternalJITCallNumber JIT Call Number
ExternalJITCallNumber _JITCallHeader ExternalJITCallNumber Ext. JIT Call Number
ApplicationLogHandle Log Handle
ApplicationLogObject I_JITCallApplicationLog ApplicationLogObject TRFM Object
ApplicationLogSubobject I_JITCallApplicationLog ApplicationLogSubobject Triggering obj.
JITCallProcessingLogID I_JITCallApplicationLog JITCallProcessingLogID External ID
ApplicationLog I_JITCallApplicationLog ApplicationLog Log Number
JITHeaderUUID _JITCallHeader JITHeaderUUID NodeID
InternalJITCallNumber _JITCallHeader InternalJITCallNumber JIT Call Number
ExternalJITCallNumber _JITCallHeader ExternalJITCallNumber Ext. JIT Call Number
ShipToParty _JITCallHeader ShipToParty Ship-To Party (obsolete)

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 P_JITCallAlert.
-- 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 P_JITCallAlert AS
SELECT
  _JITWithApplog.ApplicationLogHandle AS ApplicationLogHandle,
  _JITWithApplog.ApplicationLogObject AS ApplicationLogObject,
  _JITWithApplog.ApplicationLogSubobject AS ApplicationLogSubobject,
  _JITWithApplog.JITCallProcessingLogID AS JITCallProcessingLogID,
  _JITWithApplog.ApplicationLog AS ApplicationLog,
  _JITCallHeader.JITHeaderUUID AS JITHeaderUUID,
  _JITCallHeader.InternalJITCallNumber AS InternalJITCallNumber,
  _JITCallHeader.ExternalJITCallNumber AS ExternalJITCallNumber,
  _JITCallHeader.ShipToParty AS ShipToParty
FROM I_JITCallApplicationLog AS _JITWithApplog
LEFT OUTER JOIN I_JITCallHeader AS _JITCallHeader ON JITCallProcessingLogID = _JITCallHeader.JITCallProcessingLogID  -- association [0..1]
-- UNION ALL with additional select branch(es): I_JITCallApplicationLog, I_JITCallApplicationLog
;