C_PPSExtPubgSystActnHistoryTP

DDL: C_PPSEXTPUBGSYSTACTNHISTORYTP Type: view_entity CONSUMPTION
14 Fields 1 Data Sources

External publishing action history - TP

C_PPSExtPubgSystActnHistoryTP is a Consumption CDS View that provides data about "External publishing action history - TP" in SAP S/4HANA. It reads from 1 data source (R_PPSExtPubgSystActnHistoryTP) and exposes 14 fields with key fields PPSExtPubgSystActnHistoryUUID, PPSExtPubgSystemRelationUUID.

Data Sources (1)

SourceAliasJoin Type
R_PPSExtPubgSystActnHistoryTP R_PPSExtPubgSystActnHistoryTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label External publishing action history - TP view
Feature SW:PPS_NG_EPS view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey PPSExtPubgSystActnHistoryUUID view
ObjectModel.sapObjectNodeType.name PPSExtPubgSystemActionHistory view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PPSExtPubgSystActnHistoryUUID PPSExtPubgSystActnHistoryUUID
KEY PPSExtPubgSystemRelationUUID PPSExtPubgSystemRelationUUID
PPSExtPubgSystAction PPSExtPubgSystAction
PPSExtPubgSystTrigger PPSExtPubgSystTrigger
PPSExtPubgSystStatus PPSExtPubgSystStatus
PPSExtPubgSystActionText
PPSExtPubgSystStatusText
PPSExtPubgSystTrggrText _PPSExtPubgSystTriggerText PPSExtPubgSystTrggrText
PPSExtPubgSystLogHandle PPSExtPubgSystLogHandle Handle
PPSExtPubgSystReportedDateTime PPSExtPubgSystReportedDateTime
CreatedByUser CreatedByUser User Name
CreatedAtDateTime CreatedAtDateTime Created On
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp

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_PPSExtPubgSystActnHistoryTP.
-- 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 C_PPSExtPubgSystActnHistoryTP AS
SELECT
  PPSExtPubgSystActnHistoryUUID,
  PPSExtPubgSystemRelationUUID,
  PPSExtPubgSystAction,
  PPSExtPubgSystTrigger,
  PPSExtPubgSystStatus,
  _PPSExtPubgSystemRelation._PPSExtPubgSystActionText[1:PPSExtPubgSystAction = ppsextpubgsystaction].PPSExtPubgSystActionText AS PPSExtPubgSystActionText,
  _PPSExtPubgSystemRelation._PPSExtPubgSystStatusText[1:PPSExtPubgSystStatus = ppsextpubgsyststatus].PPSExtPubgSystStatusText AS PPSExtPubgSystStatusText,
  _PPSExtPubgSystTriggerText.PPSExtPubgSystTrggrText AS PPSExtPubgSystTrggrText,
  PPSExtPubgSystLogHandle,
  PPSExtPubgSystReportedDateTime,
  CreatedByUser,
  CreatedAtDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM R_PPSExtPubgSystActnHistoryTP
;

Learn More