I_DrftRptDetComprnDocData

DDL: I_DRFTRPTDETCOMPRNDOCDATA Type: view_entity COMPOSITE
14 Fields 1 Data Sources

Detail Comparison Data for Report

I_DrftRptDetComprnDocData is a Composite CDS View that provides data about "Detail Comparison Data for Report" in SAP S/4HANA. It reads from 1 data source (I_DrftRptDetComprnDocDataBasic) and exposes 14 fields with key fields StatryRptActivityUUID, StatryRptDocumentID, DrftRptRecnclnDocDtaUUID.

Data Sources (1)

SourceAliasJoin Type
I_DrftRptDetComprnDocDataBasic 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 #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY StatryRptActivityUUID I_DrftRptDetComprnDocDataBasic StatryRptActivityUUID NodeID
KEY StatryRptDocumentID I_DrftRptDetComprnDocDataBasic StatryRptDocumentID Snapshot ID
KEY DrftRptRecnclnDocDtaUUID I_DrftRptDetComprnDocDataBasic DrftRptRecnclnDocDtaUUID Document Data UUID
DrftRptRecnclnFileElementID I_DrftRptDetComprnDocDataBasic DrftRptRecnclnFileElementID OAN Element ID
DrftRptRecnclnFileParElmntID I_DrftRptDetComprnDocDataBasic DrftRptRecnclnFileParElmntID Parent Id
DrftRptRecnclnFileAttributeID I_DrftRptDetComprnDocDataBasic DrftRptRecnclnFileAttributeID INT4
DrftRptRecnclnFileSqncNmbr I_DrftRptDetComprnDocDataBasic DrftRptRecnclnFileSqncNmbr Sqnc No. in Ext File
DrftRptRecnclnFileParSqncNmbr I_DrftRptDetComprnDocDataBasic DrftRptRecnclnFileParSqncNmbr Sqnc No. in Par File
DrftRptRecnclnGnrtdFileVal I_DrftRptDetComprnDocDataBasic DrftRptRecnclnGnrtdFileVal Value
DrftRptRecnclnRcvdFileVal I_DrftRptDetComprnDocDataBasic DrftRptRecnclnRcvdFileVal Received Value
DrftRptRecnclnFileMtchgSts I_DrftRptDetComprnDocDataBasic DrftRptRecnclnFileMtchgSts Matching Status
StatryRptSchemaOrdinalNumber _elementData StatryRptSchemaOrdinalNumber
StatryRptSchemaXSDBuiltInType _typeData StatryRptSchemaXSDBuiltInType
StatryRptSchemaTypeNmbrOfDcml _typeData StatryRptSchemaTypeNmbrOfDcml

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_DrftRptDetComprnDocData.
-- 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_DrftRptDetComprnDocData AS
SELECT
  comprnRslt.StatryRptActivityUUID AS StatryRptActivityUUID,
  comprnRslt.StatryRptDocumentID AS StatryRptDocumentID,
  comprnRslt.DrftRptRecnclnDocDtaUUID AS DrftRptRecnclnDocDtaUUID,
  comprnRslt.DrftRptRecnclnFileElementID AS DrftRptRecnclnFileElementID,
  comprnRslt.DrftRptRecnclnFileParElmntID AS DrftRptRecnclnFileParElmntID,
  comprnRslt.DrftRptRecnclnFileAttributeID AS DrftRptRecnclnFileAttributeID,
  comprnRslt.DrftRptRecnclnFileSqncNmbr AS DrftRptRecnclnFileSqncNmbr,
  comprnRslt.DrftRptRecnclnFileParSqncNmbr AS DrftRptRecnclnFileParSqncNmbr,
  comprnRslt.DrftRptRecnclnGnrtdFileVal AS DrftRptRecnclnGnrtdFileVal,
  comprnRslt.DrftRptRecnclnRcvdFileVal AS DrftRptRecnclnRcvdFileVal,
  comprnRslt.DrftRptRecnclnFileMtchgSts AS DrftRptRecnclnFileMtchgSts,
  _elementData.StatryRptSchemaOrdinalNumber AS StatryRptSchemaOrdinalNumber,
  _typeData.StatryRptSchemaXSDBuiltInType AS StatryRptSchemaXSDBuiltInType,
  _typeData.StatryRptSchemaTypeNmbrOfDcml AS StatryRptSchemaTypeNmbrOfDcml
FROM I_DrftRptDetComprnDocDataBasic AS comprnRslt
;

Learn More