I_DrftRptComparisonHeaderBasic

DDL: I_DRFTRPTCOMPARISONHEADERBASIC Type: view_entity BASIC
13 Fields 1 Data Sources

Comparison Data for Reconcile Report

I_DrftRptComparisonHeaderBasic is a Basic CDS View that provides data about "Comparison Data for Reconcile Report" in SAP S/4HANA. It reads from 1 data source (drr_comprn) and exposes 13 fields with key fields StatryRptActivityUUID, StatryRptDocumentID.

Data Sources (1)

SourceAliasJoin Type
drr_comprn comparisonHeader from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Comparison Data for Reconcile Report view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY StatryRptActivityUUID drr_comprn activity_key NodeID
KEY StatryRptDocumentID drr_comprn document_id Snapshot ID
DrftRptRecnclnRunUUID drr_comprn run_uuid Scheduling Worklist Run UUID
DrftRptRecnclnSubmsnRunUUID drr_comprn submission_uuid Submission UUID
DrftRptCommFileID drr_comprn file_id UUID
DraftReportComparisonStatus drr_comprn comparison_status Comparison Status
DrftRptComprnRunDteTme drr_comprn timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
DrftRptRecnclnLgHandle drr_comprn loghandle LogsHandle
PhysDocFileName drr_comprn file_name Uploaded File Name
CreatedOnDateTime drr_comprn created_on Variant created on
StatryRptRunStatus drr_comprn report_run_status Report Run Status
DraftReportRequestedByUserID drr_comprn requested_by
DraftReportGeneratedByUserID drr_comprn generated_by

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_DrftRptComparisonHeaderBasic.
-- 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_DrftRptComparisonHeaderBasic AS
SELECT
  comparisonHeader.activity_key AS StatryRptActivityUUID,
  comparisonHeader.document_id AS StatryRptDocumentID,
  comparisonHeader.run_uuid AS DrftRptRecnclnRunUUID,
  comparisonHeader.submission_uuid AS DrftRptRecnclnSubmsnRunUUID,
  comparisonHeader.file_id AS DrftRptCommFileID,
  comparisonHeader.comparison_status AS DraftReportComparisonStatus,
  comparisonHeader.timestamp AS DrftRptComprnRunDteTme,
  comparisonHeader.loghandle AS DrftRptRecnclnLgHandle,
  comparisonHeader.file_name AS PhysDocFileName,
  comparisonHeader.created_on AS CreatedOnDateTime,
  comparisonHeader.report_run_status AS StatryRptRunStatus,
  comparisonHeader.requested_by AS DraftReportRequestedByUserID,
  comparisonHeader.generated_by AS DraftReportGeneratedByUserID
FROM drr_comprn AS comparisonHeader
;

Learn More