R_CmplRqRsltStorageClassTP

DDL: R_CMPLRQRSLTSTORAGECLASSTP Type: view_entity TRANSACTIONAL
25 Fields 1 Data Sources 2 Associations

Storage Class Assessment

R_CmplRqRsltStorageClassTP is a Transactional CDS View that provides data about "Storage Class Assessment" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRslt) and exposes 25 fields with key field CmplRqRsltUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRslt I_CmplRqRslt from

Associations (2)

CardinalityTargetAliasCondition
[0..1] R_CmplRqRsltStorageClassClfnTP _CmplRqRsltStorageClassClfn
[0..1] R_CmplRqRsltStorageClassNoteTP _CmplRqRsltStorageClassNote

Annotations (10)

NameValueLevelField
EndUserText.label Storage Class Assessment view
AccessControl.authorizationCheck #MANDATORY view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey CmplRqRsltUUID view
ObjectModel.sapObjectNodeType.name StorageClassAssessment view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltUUID CmplRqRsltUUID SDS Assessment
CmplRqVersUUID CmplRqVersUUID NodeID
ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
ComplianceRequirement ComplianceRequirement Compliance Requirement
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
CmplRqRsltProcessingStatus CmplRqRsltProcessingStatus Processing Status
CmplRqRsltProcessor Processor User Name
ReleasedByUser ReleasedByUser Released By
ValidityStartDateTime ValidityStartDateTime Valid From Timestamp
ValidityEndDateTime ValidityEndDateTime Valid To Timestamp
CmplRqRsltReldCmplncSts CmplRqRsltReldCmplncSts Released Compliance Status
CmplRqRsltCalculatedStatus CmplRqRsltCalculatedStatus Calculated Compliance Status
CmplRqRsltManualStatus CmplRqRsltManualStatus Transport Permission
CmplRqPattern _CmplRqVers CmplRqPattern Compliance Pattern
MaterialIsSold MaterialIsSold Is Sold
MaterialIsTransported MaterialIsTransported Is Transported
MaterialIsSourced MaterialIsSourced Is Purchased
MaterialIsProduced MaterialIsProduced Is Produced
_CmplRqRsltStorageClassClfn _CmplRqRsltStorageClassClfn
_CmplRqRsltStorageClassNote _CmplRqRsltStorageClassNote
_ChmlCmplncInfo _ChmlCmplncInfo
_CmplRqVers _CmplRqVers

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 R_CmplRqRsltStorageClassTP.
-- 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 R_CmplRqRsltStorageClassTP AS
SELECT
  CmplRqRsltUUID,
  CmplRqVersUUID,
  ChmlCmplncInfoUUID,
  ComplianceRequirement,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  CmplRqRsltProcessingStatus,
  Processor AS CmplRqRsltProcessor,
  ReleasedByUser,
  ValidityStartDateTime,
  ValidityEndDateTime,
  CmplRqRsltReldCmplncSts,
  CmplRqRsltCalculatedStatus,
  CmplRqRsltManualStatus,
  _CmplRqVers.CmplRqPattern AS CmplRqPattern,
  MaterialIsSold,
  MaterialIsTransported,
  MaterialIsSourced,
  MaterialIsProduced
FROM I_CmplRqRslt
LEFT OUTER JOIN R_CmplRqRsltStorageClassClfnTP AS _CmplRqRsltStorageClassClfn ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_CmplRqRsltStorageClassNoteTP AS _CmplRqRsltStorageClassNote ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More