I_JITOutbCommunicationGroup

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_JITOutbCommunicationGroup.
-- 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: IJITOUTBCMMGRP

CREATE VIEW I_JITOutbCommunicationGroup AS
SELECT
  JITOutbCommunicationGroupUUID,
  JITOutbCommunicationGroup,
  JITOutbCommunicationGroupDesc,
  Supplier,
  BusinessPartner,
  JITOutbCommGrpStatus,
  JITOutbChangeCallDuration,
  njit_comm_grp.creationdatetime AS CreationDateTime,
  njit_comm_grp.createdbyuser AS CreatedByUser,
  njit_comm_grp.lastchangedatetime AS LastChangeDateTime,
  njit_comm_grp.lastchangedbyusername AS LastChangedByUserName,
  Plant
FROM njit_comm_grp
LEFT OUTER JOIN I_JITOutbCommunicationGroupSts AS _JITOutbCommunicationGroupSts ON JITOutbCommGrpStatus = _JITOutbCommunicationGroupSts.JITOutbCommGrpStatus  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
;