NEWS_C_ARTICLE

DDL: NEWS_C_ARTICLE Type: view_entity
23 Fields 1 Data Sources

News Article - consumption view

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

Data Sources (1)

SourceAliasJoin Type
NEWS_I_ARTICLE NEWS_I_ARTICLE projection

Annotations (4)

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

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY NewsId NewsId
Priority Priority Workflow priority
PriorityText _PriorityVh PriorityText Priority Description
BgImageId BgImageId Background Image
ImageName _NewsImage ImageName
FileName _NewsImage FileName URL or Filenam Path
MimeType _NewsImage MimeType MIMETYPE
BgImage _NewsImage BgImage
virtualStatuscux_nws_status_text Status
PublishStartDate PublishStartDate Publish Start
PublishEndDate PublishEndDate Publish End
Langu Langu Primary lang.
Title Title View Title
Subtitle Subtitle Subtitle
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
_NewsImage _NewsImage
_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_ARTICLE.
-- 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_ARTICLE AS
SELECT
  NewsId,
  Priority,
  _PriorityVh.PriorityText AS PriorityText,
  BgImageId,
  _NewsImage.ImageName AS ImageName,
  _NewsImage.FileName AS FileName,
  _NewsImage.MimeType AS MimeType,
  _NewsImage.BgImage AS BgImage,
  virtual Status : cux_nws_status_text AS virtualStatuscux_nws_status_text,
  PublishStartDate,
  PublishEndDate,
  Langu,
  Title,
  Subtitle,
  Description,
  FooterText,
  CreatedBy,
  CreatedAt,
  LastChangedBy,
  LastChangedAt,
  LocalLastChangedAt
FROM NEWS_I_ARTICLE
;

Learn More