I_COLLSACCOUNTSTICKYNOTE

CDS View

Sticky Note

I_COLLSACCOUNTSTICKYNOTE is a CDS View in S/4HANA. Sticky Note. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CollsAccountStickyNote view_entity projection CONSUMPTION Sticky Note 
@AbapCatalog: { sqlViewName: 'ICLLSACSTNT',
                compiler: { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #CHECK,
                  personalData:       { blocking: #BLOCKED_DATA_EXCLUDED } }
@EndUserText: { label: 'Sticky Note' }
@VDM: { viewType: #COMPOSITE,
        lifecycle: { contract: { type: #PUBLIC_LOCAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType: { serviceQuality: #C,
                             sizeCategory: #L,
                             dataClass: #TRANSACTIONAL },
                semanticKey: [ 'Customer', 'CollectionSegment' ],
                representativeKey: 'Customer' }
@Consumption: { dbHints: [ 'USE_HEX_PLAN' ] }

define root view I_CollsAccountStickyNote
  as select from P_CollsAccountStickyNote

  // VDM Associations

  // Customer

  association [0..1] to I_Customer          as _Customer          on $projection.Customer = _Customer.Customer

  // Collection Segment

  association [0..1] to I_CollectionSegment as _CollectionSegment on $projection.CollectionSegment = _CollectionSegment.CollectionSegment

{

      // VDM Fields

      @ObjectModel: { foreignKey: { association: '_Customer' } }
  key Customer,

      @ObjectModel: { foreignKey: { association: '_CollectionSegment' } }
  key CollectionSegment,
      ObjectKey,
      _NoteContent.content as NoteText,
      _NoteContent.noteid as NoteID,

      _NoteContent,
      _Customer,
      _CollectionSegment

}

Learn More