I_TEXTCOLLECTION

CDS View

Notes Collection

I_TEXTCOLLECTION is a CDS View in S/4HANA. Notes Collection. It contains 5 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_TranspOrderItemNoteFDP view_entity from CONSUMPTION Transp Ord Item Note Form Data Provider
C_TransportationOrderNoteFDP view_entity from CONSUMPTION Transp Order Note Form Data Provider
R_TranspOrdItemNoteTP view_entity from TRANSACTIONAL Transportation Order Item Note - TP
R_TransportationOrderNoteTP view_entity from TRANSACTIONAL Transportation Order Note - TP

Fields (5)

KeyField CDS FieldsUsed in Views
HostDocumentBusinessObjectUUID HostDocumentBusinessObjectUUID 2
HostDocumentBusObjNodeUUID HostDocumentBusObjNodeUUID 2
HostDocumentUUID TransportationOrderItemUUID,TransportationOrderUUID 4
TextCollectionSchema TextCollectionSchema 2
TextCollectionUUID TextCollectionUUID 2
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ITEXTCOLL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #NONE
@ObjectModel.representativeKey: 'TextCollectionUUID'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'Notes Collection'

define view I_TextCollection
  as select from /bobf/d_txcroot
  association [0..*] to I_TextCollectionType as _TextCollectionType on $projection.TextCollectionUUID = _TextCollectionType.TextCollectionUUID
{
  key db_key          as TextCollectionUUID,
      text_schema_id  as TextCollectionSchema,
      @Semantics.booleanIndicator: true
      text_exists_ind as DocumentHasText,
      host_bo_key     as HostDocumentBusinessObjectUUID,
      host_node_key   as HostDocumentBusObjNodeUUID,
      host_key        as HostDocumentUUID,

      _TextCollectionType
}