C_JITOutbCommunicationGroupVH

DDL: C_JITOUTBCOMMUNICATIONGROUPVH SQL: CJITOUTBCMMGRPVH Type: view CONSUMPTION Package: NJIT_MODEL_O
9 Fields 1 Data Sources 1 Associations

JIT outbound Communication Group Value Help

C_JITOutbCommunicationGroupVH is a Consumption CDS View that provides data about "JIT outbound Communication Group Value Help" in SAP S/4HANA. It reads from 1 data source (C_JITOutbCommunicationGroupTP) and exposes 9 fields with key field JITOutbCommunicationGroup. It has 1 association to related views. Part of development package NJIT_MODEL_O.

Data Sources (1)

SourceAliasJoin Type
C_JITOutbCommunicationGroupTP C_JITOutbCommunicationGroupTP from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_JITOutbContactPersonOvw _JITOutbContactPersonOvw $projection.BusinessPartner = _JITOutbContactPersonOvw.BusinessPartner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CJITOUTBCMMGRPVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label JIT outbound Communication Group Value Help view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY JITOutbCommunicationGroup JITOutbCommunicationGroup Communication Group ID
JITOutbCommunicationGroupDesc JITOutbCommunicationGroupDesc Communication Group Description
Supplier Supplier Supplier Identification Number
SupplierName SupplierName Supplier Name
BusinessPartner BusinessPartner Business Partner Number
FirstName _JITOutbContactPersonOvw FirstName Business Partner First Name
LastName _JITOutbContactPersonOvw LastName Business Partner Last Name
JITOutbCommGrpStatus JITOutbCommGrpStatus Communication Group Status
JITOutbCommGrpStatusText JITOutbCommGrpStatusText Communication Group Status Description

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_JITOutbCommunicationGroupVH.
-- 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: CJITOUTBCMMGRPVH

CREATE VIEW C_JITOutbCommunicationGroupVH AS
SELECT
  JITOutbCommunicationGroup,
  JITOutbCommunicationGroupDesc,
  Supplier,
  SupplierName,
  BusinessPartner,
  _JITOutbContactPersonOvw.FirstName AS FirstName,
  _JITOutbContactPersonOvw.LastName AS LastName,
  JITOutbCommGrpStatus,
  JITOutbCommGrpStatusText
FROM C_JITOutbCommunicationGroupTP
LEFT OUTER JOIN C_JITOutbContactPersonOvw AS _JITOutbContactPersonOvw ON BusinessPartner = _JITOutbContactPersonOvw.BusinessPartner  -- association [0..1]
;

Learn More