R_CmplRqRsltSftyDataShtTP

DDL: R_CMPLRQRSLTSFTYDATASHTTP Type: view_entity TRANSACTIONAL

SDS Assessment - TP

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

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRslt I_CmplRqRslt from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_CmplRqRsltSftyDataShtCntryTP _SftyDtaShtAssmtCntry
[0..*] R_CmplRqRsltSftyDataShtDocTP _SftyDtaShtAssmtDoc

Annotations (10)

NameValueLevelField
EndUserText.label SDS Assessment - TP 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 SafetyDataSheetAssessment view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltUUID CmplRqRsltUUID
CmplRqVersUUID CmplRqVersUUID
ChmlCmplncInfoUUID ChmlCmplncInfoUUID
ChemicalComplianceInfo _ChmlCmplncInfo Specification
CmplRqVers _CmplRqVers CmplRqVers
ComplianceRequirement ComplianceRequirement
CmplRqRsltProcessingStatus CmplRqRsltProcessingStatus
CmplRqRsltProcessor Processor
ReleasedByUser ReleasedByUser
ValidityStartDateTime ValidityStartDateTime
ValidityEndDateTime ValidityEndDateTime
CmplRqRsltReldCmplncSts CmplRqRsltReldCmplncSts
CmplRqRsltCalculatedStatus CmplRqRsltCalculatedStatus
CmplRqRsltManualStatus CmplRqRsltManualStatus
MaterialIsSold MaterialIsSold
MaterialIsTransported MaterialIsTransported
MaterialIsSourced MaterialIsSourced
MaterialIsProduced MaterialIsProduced
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_SftyDtaShtAssmtCntry _SftyDtaShtAssmtCntry
_SftyDtaShtAssmtDoc _SftyDtaShtAssmtDoc 
@EndUserText.label: 'SDS Assessment - TP'
@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl:
{
  authorizationCheck: #MANDATORY
}

@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel:
{
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #XL,
    serviceQuality: #C
  },
  representativeKey: 'CmplRqRsltUUID',
  semanticKey: ['CmplRqRsltUUID' ],
  sapObjectNodeType.name: 'SafetyDataSheetAssessment'
}

define root view entity R_CmplRqRsltSftyDataShtTP
  as select from I_CmplRqRslt
  // to child compositions

  composition [0..*] of R_CmplRqRsltSftyDataShtCntryTP as _SftyDtaShtAssmtCntry
  composition [0..*] of R_CmplRqRsltSftyDataShtDocTP   as _SftyDtaShtAssmtDoc
{
      /****  Keys  ****/
  key CmplRqRsltUUID,
      CmplRqVersUUID,
      ChmlCmplncInfoUUID,
      
      /****  Semantic Keys  ****/
      _ChmlCmplncInfo.Specification as ChemicalComplianceInfo,
      _CmplRqVers.CmplRqVers,

      /****  Content  ****/
      ComplianceRequirement,
      CmplRqRsltProcessingStatus,

      Processor as CmplRqRsltProcessor,
      ReleasedByUser,
      ValidityStartDateTime,
      ValidityEndDateTime,

      CmplRqRsltReldCmplncSts, // Ask Thomas: Required ?

      CmplRqRsltCalculatedStatus,
      CmplRqRsltManualStatus,

      MaterialIsSold,
      MaterialIsTransported,
      MaterialIsSourced,
      MaterialIsProduced,

      /**** Admin Fields ****/
      @Semantics.user.createdBy: true
      CreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      CreationDateTime,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      @Semantics.systemDateTime.localInstanceLastChangedAt: true
      LastChangeDateTime,

      /**** Associations ****/
      _SftyDtaShtAssmtCntry,
      _SftyDtaShtAssmtDoc
}
where
  -- Filter only SDS related CRR
  _CmplRqVers.CmplRqPattern = 'CompliancePatternSDSManagement'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCINFO",
"I_CMPLRQRSLT",
"I_CMPLRQVERSENHANCED"
],
"ASSOCIATED":
[
"R_CMPLRQRSLTSFTYDATASHTCNTRYTP",
"R_CMPLRQRSLTSFTYDATASHTDOCTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More