R_CustomerContactNote

DDL: R_CUSTOMERCONTACTNOTE Type: view COMPOSITE

Customer Contact Note

R_CustomerContactNote is a Composite CDS View that provides data about "Customer Contact Note" in SAP S/4HANA. It reads from 1 data source (I_CustomerContactAttribute) and exposes 8 fields with key fields CustomerContactUUID, ObjectKey. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerContactAttribute I_CustomerContactAttribute from

Associations (2)

CardinalityTargetAliasCondition
[0..1] Sgbt_Nte_Cds_Cont _NoteContent $projection.CustomerContactUUID = _NoteContent.objectid
[0..1] I_CustomerContactAttribute _CustomerContactAttribute $projection.CustomerContactUUID = _CustomerContactAttribute.CustomerContactUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName RCCTNOTE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Customer Contact Note view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.query.implementedBy ABAP:CL_COLL_CCT_NOTE_QUERY view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CustomerContactUUID CustomerContactUUID
KEY ObjectKey
DocumentTitle
CreatedByUser
CreatedByUserDescription
CreationDateTime
NoteText _NoteContent content
_CustomerContactAttribute _CustomerContactAttribute 
@AbapCatalog: { sqlViewName: 'RCCTNOTE',
                compiler: { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #CHECK }
@EndUserText: { label: 'Customer Contact Note' }
@VDM: { viewType: #COMPOSITE,
        lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType: { serviceQuality: #A,
                             sizeCategory: #M,
                             dataClass: #TRANSACTIONAL },
                query: { implementedBy: 'ABAP:CL_COLL_CCT_NOTE_QUERY' } }

define view R_CustomerContactNote
  as select from I_CustomerContactAttribute

  // VDM Associations

  // Notes

  association [0..1] to Sgbt_Nte_Cds_Cont          as _NoteContent              on $projection.CustomerContactUUID = _NoteContent.objectid

  // Customer Contact

  association [0..1] to I_CustomerContactAttribute as _CustomerContactAttribute on $projection.CustomerContactUUID = _CustomerContactAttribute.CustomerContactUUID

{

      // VDM Fields

  key CustomerContactUUID,
  key cast ( '' as tdobname )                    as ObjectKey,
      cast( '' as sdok_titel )                   as DocumentTitle,
      cast( '' as tdfuser )                      as CreatedByUser,
      cast( '' as vdm_createdbyuserdescription ) as CreatedByUserDescription,
      cast( 0 as udmo_create_time )              as CreationDateTime,
      _NoteContent.content                       as NoteText,

      // Exposed Associations

      @ObjectModel: { sort: { enabled: false },
                      filter: { enabled: false } }
      _CustomerContactAttribute

}

Learn More