I_JITCallsForCommGroupBasic

DDL: I_JITCALLSFORCOMMGROUPBASIC SQL: IJITCALLSCOMMGRP Type: view COMPOSITE Package: NJIT_MODEL_O

Control cycles and JIT calls for Communication groups

I_JITCallsForCommGroupBasic is a Composite CDS View that provides data about "Control cycles and JIT calls for Communication groups" in SAP S/4HANA. It reads from 2 data sources (I_JITOutbCallCompGrp, I_JITControlCycle) and exposes 9 fields with key fields JITOutbCommunicationGroup, JITControlCycle, InternalJITCallNumber. It has 1 association to related views. Part of development package NJIT_MODEL_O.

Data Sources (2)

SourceAliasJoin Type
I_JITOutbCallCompGrp _JITOutbCallCompGrp inner
I_JITControlCycle I_JITControlCycle from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_JITOutbCallHeader _JITOutbCallHeader $projection.InternalJITCallNumber = _JITOutbCallHeader.InternalJITCallNumber

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IJITCALLSCOMMGRP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Control cycles and JIT calls for Communication groups view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY JITOutbCommunicationGroup JITOutbCommunicationGroup Communication Group
KEY JITControlCycle I_JITControlCycle JITControlCycle Control Cycle
KEY InternalJITCallNumber I_JITOutbCallCompGrp InternalJITCallNumber JIT Call Number
JITOutbCommunicationGroupUUID _JITCommunicationGroup JITOutbCommunicationGroupUUID NodeID
Supplier Supplier Supplier
Plant I_JITOutbCallCompGrp Plant Valuation Area
LastChangeDateTime _JITOutbCallHeader LastChangeDateTime Timestamp
JITLifecycleStatus _JITOutbCallHeader JITLifecycleStatus Life Cycle Status
_JITOutbCallHeader _JITOutbCallHeader

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_JITCallsForCommGroupBasic.
-- 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: IJITCALLSCOMMGRP

CREATE VIEW I_JITCallsForCommGroupBasic AS
SELECT
  JITOutbCommunicationGroup,
  I_JITControlCycle.JITControlCycle AS JITControlCycle,
  _JITOutbCallCompGrp.InternalJITCallNumber AS InternalJITCallNumber,
  _JITCommunicationGroup.JITOutbCommunicationGroupUUID AS JITOutbCommunicationGroupUUID,
  Supplier,
  _JITOutbCallCompGrp.Plant AS Plant,
  _JITOutbCallHeader.LastChangeDateTime AS LastChangeDateTime,
  _JITOutbCallHeader.JITLifecycleStatus AS JITLifecycleStatus
FROM I_JITControlCycle
INNER JOIN I_JITOutbCallCompGrp AS _JITOutbCallCompGrp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JITOutbCallHeader AS _JITOutbCallHeader ON InternalJITCallNumber = _JITOutbCallHeader.InternalJITCallNumber  -- association [0..*]
;