NEWS_R_ARTICLE_D

DDL: NEWS_R_ARTICLE_D Type: view_entity Package: SUI_FLP_EXT_CUX_NWS_ODATA

Draft Query View - News Article

NEWS_R_ARTICLE_D is a CDS View that provides data about "Draft Query View - News Article" in SAP S/4HANA. It reads from 1 data source (news_article_d) and exposes 22 fields with key field Newsid. Part of development package SUI_FLP_EXT_CUX_NWS_ODATA.

Data Sources (1)

SourceAliasJoin Type
news_article_d news_article_d from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Draft Query View - News Article view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY Newsid newsid
Priority priority Workflow priority
Mandatory mandatory Yes/No
Bgimageid bgimageid
Publishstartdate publishstartdate
Publishenddate publishenddate
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
Draftentitycreationdatetime draftentitycreationdatetime Draft Created On
Draftentitylastchangedatetime draftentitylastchangedatetime Draft Last Changed On
Draftadministrativedatauuid draftadministrativedatauuid UUID
Draftentityoperationcode draftentityoperationcode Draft - Operation Code
Hasactiveentity hasactiveentity TRUE
Draftfieldchanges draftfieldchanges Field Changes

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_R_ARTICLE_D.
-- 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_R_ARTICLE_D AS
SELECT
  Newsid,
  Priority,
  Mandatory,
  Bgimageid,
  Publishstartdate,
  Publishenddate,
  Langu,
  Title,
  Subtitle,
  Description,
  FooterText,
  Createdby,
  Createdat,
  Lastchangedby,
  Lastchangedat,
  Locallastchangedat,
  Draftentitycreationdatetime,
  Draftentitylastchangedatetime,
  Draftadministrativedatauuid,
  Draftentityoperationcode,
  Hasactiveentity,
  Draftfieldchanges
FROM news_article_d
;