Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_JITOutbCommunicationGroupTP

DDL: C_JITOUTBCOMMUNICATIONGROUPTP SQL: CJITOUTBCMMGRP Type: view CONSUMPTION

Consumption view communication group

C_JITOutbCommunicationGroupTP is a Consumption CDS View that provides data about "Consumption view communication group" in SAP S/4HANA. It reads from 1 data source (I_JITOutbCommunicationGroupTP) and exposes 18 fields with key field JITOutbCommunicationGroupUUID. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Just-In-Time Processing
Data CategoryConsumption
StatusReleased
Corresponding DataSourceCJITOUTBCMMGRP
Purpose
This CDS view retrieves the communication groups based on the filters that you specify. This CDS view provides the prerequisites for answering the following business questions: What is the status of communication groups in the system? All the communication groups with suppliers in the system

Prerequisites
The following authorization object is required: JIT_S2P_CC: JIT Supply to Production: Authorization for Control Cycles

Structure
Object types This view relates to the following SAP object type: I_JITOutbCommunicationGroupTP Main parameters and filters of the CDS view The view does not have any input parameters The main filters are as follows: Plant is used to filter by plant JITOutbCommGrpStatus is used to filter by group status Supplier is used to filter by supplier BusinessPartner is used to filter by business partner

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_JITOutbCommunicationGroupTP I_JITOutbCommunicationGroupTP from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_JITOutbMessagePartnerTP _JITOutbMessagePartnerTP $projection.JITOutbCommunicationGroupUUID = _JITOutbMessagePartnerTP.JITOutbCommunicationGroupUUID
[0..1] C_JITOutbContactPersonOvw _JITOutbContactPersonOvw $projection.businesspartner = _JITOutbContactPersonOvw.BusinessPartner
[0..*] C_JITOutbControlCycleOvw _JITOutbControlCycleOvw $projection.JITOutbCommunicationGroup = _JITOutbControlCycleOvw.JITOutbCommunicationGroup

Annotations (26)

NameValueLevelField
AbapCatalog.sqlViewName CJITOUTBCMMGRP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption view communication group view
VDM.viewType #CONSUMPTION view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled false view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelCategory #BUSINESS_OBJECT view
Search.searchable true view
UI.headerInfo.typeName Communication Group view
UI.headerInfo.typeNamePlural Communication Groups view
UI.headerInfo.title.label Communication Group view
UI.headerInfo.title.value JITOutbCommunicationGroup view
UI.headerInfo.description.value JITOutbCommunicationGroupDesc view
VDM.lifecycle.status #DEPRECATED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY JITOutbCommunicationGroupUUID JITOutbCommunicationGroupUUID NodeID
JITOutbCommunicationGroup JITOutbCommunicationGroup Group Number
JITOutbCommunicationGroupDesc JITOutbCommunicationGroupDesc Group Description
Supplier Supplier Supplier Number
BusinessPartner Contact Person
JITOutbCommGrpStatus JITOutbCommGrpStatus Group Status
JITOutbCommGrpStatusText
JITOutbChangeCallDuration JITOutbChangeCallDuration Change Duration
SupplierName _Supplier SupplierName Supplier Name
CreationDateTime CreationDateTime Created Date
CreatedByUser CreatedByUser Created By (ID)
LastChangeDateTime LastChangeDateTime Last Changed At
LastChangedByUserName LastChangedByUserName Last Changed By (ID)
Plant Plant Plant
PlantName PlantName Plant Name
_JITOutbMessagePartnerTP _JITOutbMessagePartnerTP
_JITOutbContactPersonOvw _JITOutbContactPersonOvw
_JITOutbControlCycleOvw _JITOutbControlCycleOvw

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 C_JITOutbCommunicationGroupTP.
-- 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: CJITOUTBCMMGRP

CREATE VIEW C_JITOutbCommunicationGroupTP AS
SELECT
  JITOutbCommunicationGroupUUID,
  JITOutbCommunicationGroup,
  JITOutbCommunicationGroupDesc,
  Supplier,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  JITOutbCommGrpStatus,
  _JITOutbCommunicationGroupSts._Text[1: Language = $session.system_language].JITOutbCommGrpStatusText AS JITOutbCommGrpStatusText,
  JITOutbChangeCallDuration,
  _Supplier.SupplierName AS SupplierName,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUserName,
  Plant,
  PlantName
FROM I_JITOutbCommunicationGroupTP
LEFT OUTER JOIN C_JITOutbMessagePartnerTP AS _JITOutbMessagePartnerTP ON JITOutbCommunicationGroupUUID = _JITOutbMessagePartnerTP.JITOutbCommunicationGroupUUID  -- association [0..*]
LEFT OUTER JOIN C_JITOutbContactPersonOvw AS _JITOutbContactPersonOvw ON businesspartner = _JITOutbContactPersonOvw.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_JITOutbControlCycleOvw AS _JITOutbControlCycleOvw ON JITOutbCommunicationGroup = _JITOutbControlCycleOvw.JITOutbCommunicationGroup  -- association [0..*]
;