R_DngrsGdsSftyDtaShtNoteTP

DDL: R_DNGRSGDSSFTYDTASHTNOTETP Type: view_entity TRANSACTIONAL

DG Basic Classfctn SDS Note - TP

R_DngrsGdsSftyDtaShtNoteTP is a Transactional CDS View that provides data about "DG Basic Classfctn SDS Note - TP" in SAP S/4HANA. It reads from 1 data source (I_CmplRqRsltSftyDtaShtNote) and exposes 11 fields with key field CmplRqRsltSftyDtaShtNoteUUID. It has 1 association to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRsltSftyDtaShtNote DngrsGdsSafetyDataSheetNote from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ProdCmplncPhrs _DngrsGdsSftyDtaShtNotePhrase $projection.DangerousGdsSftyDtaShtNoteUUID = _DngrsGdsSftyDtaShtNotePhrase.ProdCmplncPhrsUUID

Annotations (10)

NameValueLevelField
EndUserText.label DG Basic Classfctn SDS Note - TP view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name DngrsGdsSafetyDataSheetNote view
ObjectModel.representativeKey CmplRqRsltSftyDtaShtNoteUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltSftyDtaShtNoteUUID I_CmplRqRsltSftyDtaShtNote CmplRqRsltSftyDtaShtNoteUUID
CmplRqRsltUUID I_CmplRqRsltSftyDtaShtNote CmplRqRsltUUID
CreationDateTime I_CmplRqRsltSftyDtaShtNote CreationDateTime
CreatedByUser I_CmplRqRsltSftyDtaShtNote CreatedByUser
LastChangeDateTime I_CmplRqRsltSftyDtaShtNote LastChangeDateTime
LastChangedByUser I_CmplRqRsltSftyDtaShtNote LastChangedByUser
CmplRqRsltProcessingStatus _DngrsGoodsBasicClassification CmplRqRsltProcessingStatus
CmplRqVersIsLatest _DngrsGoodsBasicClassification CmplRqVersIsLatest
DangerousGdsSftyDtaShtNoteUUID DangerousGdsSftyDtaShtNoteUUID
_DngrsGdsSftyDtaShtNotePhrase _DngrsGdsSftyDtaShtNotePhrase
_DngrsGoodsBasicClassification _DngrsGoodsBasicClassification 
@EndUserText.label: 'DG Basic Classfctn SDS Note - TP'
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel:
{
  sapObjectNodeType.name: 'DngrsGdsSafetyDataSheetNote',  
  representativeKey:  'CmplRqRsltSftyDtaShtNoteUUID',
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #L, // <10.000.000

    serviceQuality: #C // <= 15 msec

  }
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view entity R_DngrsGdsSftyDtaShtNoteTP 
  as select from I_CmplRqRsltSftyDtaShtNote as DngrsGdsSafetyDataSheetNote
  association to parent R_DngrsGdsBasicClassfctnTP  as _DngrsGoodsBasicClassification on $projection.CmplRqRsltUUID = _DngrsGoodsBasicClassification.CmplRqRsltUUID
  association [0..1] to I_ProdCmplncPhrs as _DngrsGdsSftyDtaShtNotePhrase on $projection.DangerousGdsSftyDtaShtNoteUUID = _DngrsGdsSftyDtaShtNotePhrase.ProdCmplncPhrsUUID
{
  key DngrsGdsSafetyDataSheetNote.CmplRqRsltSftyDtaShtNoteUUID,
      DngrsGdsSafetyDataSheetNote.CmplRqRsltUUID,

      @Semantics.systemDateTime.createdAt: true
      DngrsGdsSafetyDataSheetNote.CreationDateTime,
      @Semantics.user.createdBy: true
      DngrsGdsSafetyDataSheetNote.CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      DngrsGdsSafetyDataSheetNote.LastChangeDateTime,
      @Semantics.user.lastChangedBy: true
      DngrsGdsSafetyDataSheetNote.LastChangedByUser,

      _DngrsGoodsBasicClassification.CmplRqRsltProcessingStatus,
      _DngrsGoodsBasicClassification.CmplRqVersIsLatest,

      DangerousGdsSftyDtaShtNoteUUID,
      /* Associations */
      _DngrsGdsSftyDtaShtNotePhrase,
      _DngrsGoodsBasicClassification
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQRSLTSFTYDTASHTNOTE",
"R_DNGRSGDSBASICCLASSFCTNTP"
],
"ASSOCIATED":
[
"I_PRODCMPLNCPHRS",
"R_DNGRSGDSBASICCLASSFCTNTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More