NEWS_C_GRP

DDL: NEWS_C_GRP Type: view_entity
23 Fields 1 Data Sources

News Groups - consumption view

NEWS_C_GRP is a CDS View that provides data about "News Groups - consumption view" in SAP S/4HANA. It reads from 1 data source (NEWS_I_GRP) and exposes 23 fields with key field GroupId.

Data Sources (1)

SourceAliasJoin Type
NEWS_I_GRP NEWS_I_GRP projection

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label News Groups - consumption view view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY GroupId GroupId Group name
Priority Priority Workflow priority
PriorityText _PriorityVh PriorityText Priority Description
Mandatory Mandatory Yes/No
MandatoryText _MandatoryVh MandatoryText
BgImageId BgImageId Background Image
ImageName _NewsImage ImageName
FileName _NewsImage FileName URL or Filenam Path
MimeType _NewsImage MimeType MIMETYPE
BgImage _NewsImage BgImage
Langu Langu Primary lang.
Title Title View Title
Description Description Well Code Des.
FooterText FooterText
CreatedBy CreatedBy User Name
CreatedAt CreatedAt Time Stamp
LastChangedBy LastChangedBy User Name
LastChangedAt LastChangedAt Time Stamp
LocalLastChangedAt LocalLastChangedAt Time Stamp
_NewsGroupAssignment _NewsGroupAssignment
_NewsImage _NewsImage
_MandatoryVh _MandatoryVh
_PriorityVh _PriorityVh

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 NEWS_C_GRP.
-- 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 NEWS_C_GRP AS
SELECT
  GroupId,
  Priority,
  _PriorityVh.PriorityText AS PriorityText,
  Mandatory,
  _MandatoryVh.MandatoryText AS MandatoryText,
  BgImageId,
  _NewsImage.ImageName AS ImageName,
  _NewsImage.FileName AS FileName,
  _NewsImage.MimeType AS MimeType,
  _NewsImage.BgImage AS BgImage,
  Langu,
  Title,
  Description,
  FooterText,
  CreatedBy,
  CreatedAt,
  LastChangedBy,
  LastChangedAt,
  LocalLastChangedAt
FROM NEWS_I_GRP
;

Learn More