I_CMPLRQRSLTSFTYDTASHTNOTE

CDS View

Basic Classification Details SDS Note

I_CMPLRQRSLTSFTYDTASHTNOTE is a CDS View in S/4HANA. Basic Classification Details SDS Note. It contains 6 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 6 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CmplRqRsltSftyDtaShtNoteTP view from TRANSACTIONAL SDS Note - TP
R_DngrsGdsSftyDtaShtNoteTP view_entity from TRANSACTIONAL DG Basic Classfctn SDS Note - TP

Fields (6)

KeyField CDS FieldsUsed in Views
KEY CmplRqRsltSftyDtaShtNoteUUID CmplRqRsltSftyDtaShtNoteUUID 1
CmplRqRsltUUID CmplRqRsltUUID 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1 
@AbapCatalog.sqlViewName: 'ICRRBCSDSNOTE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Basic Classification Details SDS Note'
@ObjectModel.representativeKey: 'CmplRqRsltSftyDtaShtNoteUUID'
@VDM.viewType: #BASIC

// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE

// used for BOBF Master Data Object

@ObjectModel.usageType:{ serviceQuality: #C,        // < 15 msec

                            sizeCategory:   #M,        // < 100.000

                            dataClass:      #MIXED }

define view I_CmplRqRsltSftyDtaShtNote
  as select from ehdgmd_crr_snote
  association [1..1] to I_CmplRqRslt as _CmplRqRslt on $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID
{
  key cmplrqrsltsftydtashtnoteuuid                                         as CmplRqRsltSftyDtaShtNoteUUID,
      cmplrqrsltuuid                                                       as CmplRqRsltUUID,
      dangerousgdssftydtashtnoteuuid                                       as DangerousGdsSftyDtaShtNoteUUID,
      // Admin Fields

      @Semantics.systemDateTime.createdAt: true
      creationdatetime                                                     as CreationDateTime,
      @Semantics.user.createdBy: true
      cast( createdbyuser as vdm_createdbyuserid preserving type )         as CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      lastchangedatetime                                                   as LastChangeDateTime,
      @Semantics.user.lastChangedBy: true
      cast( lastchangedbyuser as vdm_lastchangedbyuserid preserving type ) as LastChangedByUser,

      // Associations

      _CmplRqRslt

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHDGMD_CRR_SNOTE"
],
"ASSOCIATED":
[
"I_CMPLRQRSLT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More