I_DrftRptDetComprnDocDataBasic

DDL: I_DRFTRPTDETCOMPRNDOCDATABASIC Type: view_entity BASIC Package: GLO_FIN_DRR
12 Fields 1 Data Sources

Detail Comparison Data for Report

I_DrftRptDetComprnDocDataBasic is a Basic CDS View that provides data about "Detail Comparison Data for Report" in SAP S/4HANA. It reads from 1 data source (drr_comprn_rslt) and exposes 12 fields with key fields StatryRptActivityUUID, StatryRptDocumentID, DrftRptRecnclnDocDtaUUID. Part of development package GLO_FIN_DRR.

Data Sources (1)

SourceAliasJoin Type
drr_comprn_rslt comprnRslt from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Detail Comparison Data for 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 (12)

KeyFieldSource TableSource FieldDescription
KEY StatryRptActivityUUID drr_comprn_rslt activity_key NodeID
KEY StatryRptDocumentID drr_comprn_rslt document_id Snapshot ID
KEY DrftRptRecnclnDocDtaUUID drr_comprn_rslt document_data_uuid Document Data UUID
DrftRptRecnclnFileElementID drr_comprn_rslt element_id OAN Element ID
DrftRptRecnclnFileElementType drr_comprn_rslt element_type Element Type
DrftRptRecnclnFileParElmntID drr_comprn_rslt parent_element_id Parent Id
DrftRptRecnclnFileAttributeID drr_comprn_rslt attribute_id INT4
DrftRptRecnclnFileSqncNmbr drr_comprn_rslt sequence_no Sqnc No. in Ext File
DrftRptRecnclnFileParSqncNmbr drr_comprn_rslt parent_seq_no Sqnc No. in Par File
DrftRptRecnclnGnrtdFileVal drr_comprn_rslt generated_value Value
DrftRptRecnclnRcvdFileVal drr_comprn_rslt received_value Received Value
DrftRptRecnclnFileMtchgSts drr_comprn_rslt match_status Matching Status

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_DrftRptDetComprnDocDataBasic.
-- 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_DrftRptDetComprnDocDataBasic AS
SELECT
  comprnRslt.activity_key AS StatryRptActivityUUID,
  comprnRslt.document_id AS StatryRptDocumentID,
  comprnRslt.document_data_uuid AS DrftRptRecnclnDocDtaUUID,
  comprnRslt.element_id AS DrftRptRecnclnFileElementID,
  comprnRslt.element_type AS DrftRptRecnclnFileElementType,
  comprnRslt.parent_element_id AS DrftRptRecnclnFileParElmntID,
  comprnRslt.attribute_id AS DrftRptRecnclnFileAttributeID,
  comprnRslt.sequence_no AS DrftRptRecnclnFileSqncNmbr,
  comprnRslt.parent_seq_no AS DrftRptRecnclnFileParSqncNmbr,
  comprnRslt.generated_value AS DrftRptRecnclnGnrtdFileVal,
  comprnRslt.received_value AS DrftRptRecnclnRcvdFileVal,
  comprnRslt.match_status AS DrftRptRecnclnFileMtchgSts
FROM drr_comprn_rslt AS comprnRslt
;

Learn More