I_CmplRqRsltSftyDtaShtNoteTP

DDL: I_CMPLRQRSLTSFTYDTASHTNOTETP Type: view TRANSACTIONAL

SDS Note - TP

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

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_CmplRqRsltSftyDtaShtNote I_CmplRqRsltSftyDtaShtNote from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CmplRqRsltDngrsGdsBscClfnTP _CmplRqRslt $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID

Annotations (20)

NameValueLevelField
EndUserText.label SDS Note - TP view
AbapCatalog.sqlViewName ICRRBCDSDSNTETP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence ehdgmw_crr_snote view
ObjectModel.writeActivePersistence ehdgmd_crr_snote view
ObjectModel.representativeKey CmplRqRsltSftyDtaShtNoteUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.entityChangeStateId LastChangeDateTime view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltSftyDtaShtNoteUUID CmplRqRsltSftyDtaShtNoteUUID
CmplRqRsltUUID CmplRqRsltUUID
DangerousGdsSftyDtaShtNoteUUID DangerousGdsSftyDtaShtNoteUUID
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
_CmplRqRslt _CmplRqRslt 
@EndUserText.label: 'SDS Note - TP'
@AbapCatalog:
{
  sqlViewName: 'ICRRBCDSDSNTETP',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl:
{
  authorizationCheck: #MANDATORY
}

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{
  modelCategory: #BUSINESS_OBJECT,
  transactionalProcessingEnabled: true,
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true,
  writeDraftPersistence: 'ehdgmw_crr_snote',
  writeActivePersistence: 'ehdgmd_crr_snote',
  representativeKey: 'CmplRqRsltSftyDtaShtNoteUUID',
  semanticKey:  [ 'CmplRqRsltSftyDtaShtNoteUUID' ],
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #M, //< 100.000

    serviceQuality: #C // <= 15 msec

  },
  entityChangeStateId: 'LastChangeDateTime'
}

define view I_CmplRqRsltSftyDtaShtNoteTP
  as select from I_CmplRqRsltSftyDtaShtNote
  association [1..1] to I_CmplRqRsltDngrsGdsBscClfnTP as _CmplRqRslt on $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID
{
      @ObjectModel.mandatory: true     
  key CmplRqRsltSftyDtaShtNoteUUID,
      @ObjectModel.mandatory: true
      CmplRqRsltUUID,
      @ObjectModel.mandatory: true      
      DangerousGdsSftyDtaShtNoteUUID,

      // Admin Fields

      @ObjectModel.mandatory: true
      CreationDateTime,
      @ObjectModel.mandatory: true
      CreatedByUser,
      @ObjectModel.mandatory: true
      LastChangeDateTime,
      @ObjectModel.mandatory: true
      LastChangedByUser,

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _CmplRqRslt
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQRSLTSFTYDTASHTNOTE"
],
"ASSOCIATED":
[
"I_CMPLRQRSLTDNGRSGDSBSCCLFNTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More