I_DraftReportCommunicationData

DDL: I_DRAFTREPORTCOMMUNICATIONDATA Type: view_entity BASIC

DRR Communication Data

I_DraftReportCommunicationData is a Basic CDS View that provides data about "DRR Communication Data" in SAP S/4HANA. It reads from 1 data source (drr_comm) and exposes 6 fields with key fields StatryRptActivityUUID, StatryRptDocumentID.

Data Sources (1)

SourceAliasJoin Type
drr_comm drr_comm from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label DRR Communication Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY StatryRptActivityUUID activity_key NodeID
KEY StatryRptDocumentID document_id Snapshot ID
DrftRptCommProcessID process_id Process Instance ID
DrftRptRecnclnDocName document_name Document Name
DrftRptRecnclnExtFileReqSts file_request_status Communication Status
DrftRptRecnclnFetchDteTme timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

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 I_DraftReportCommunicationData.
-- 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 I_DraftReportCommunicationData AS
SELECT
  activity_key AS StatryRptActivityUUID,
  document_id AS StatryRptDocumentID,
  process_id AS DrftRptCommProcessID,
  document_name AS DrftRptRecnclnDocName,
  file_request_status AS DrftRptRecnclnExtFileReqSts,
  timestamp AS DrftRptRecnclnFetchDteTme
FROM drr_comm
;