R_TransportationOrderNoteTP

DDL: R_TRANSPORTATIONORDERNOTETP Type: view_entity TRANSACTIONAL

Transportation Order Note - TP

R_TransportationOrderNoteTP is a Transactional CDS View that provides data about "Transportation Order Note - TP" in SAP S/4HANA. It reads from 1 data source (I_TextCollection) and exposes 14 fields with key field TextCollectionContentUUID.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_TextCollection TextCollectionRoot from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Transportation Order Note - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey TextCollectionContentUUID view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY TextCollectionContentUUID _TextCollectionContent TextCollectionContentUUID
TextCollectionTypeUUID _TextCollectionType TextCollectionTypeUUID
TextCollectionUUID I_TextCollection TextCollectionUUID
TextCollectionSchema I_TextCollection TextCollectionSchema
TextCollectionType _TextCollectionType TextCollectionType
TextCollectionTextCrtedByUser _TextCollectionType TextCollectionTextCrtedByUser
TextCollectionTextCrtedDteTime _TextCollectionType TextCollectionTextCrtedDteTime
TextCollectionTextChgdDateTime _TextCollectionType TextCollectionTextChgdDateTime
Language _TextCollectionType Language
TextCollectionContentText _TextCollectionContent TextCollectionContentText
HostDocumentBusinessObjectUUID I_TextCollection HostDocumentBusinessObjectUUID
HostDocumentBusObjNodeUUID I_TextCollection HostDocumentBusObjNodeUUID
TransportationOrderUUID I_TextCollection HostDocumentUUID
_TransportationOrder _TransportationOrder 
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Transportation Order Note - TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM: { lifecycle.contract.type: #SAP_INTERNAL_API,
        viewType: #TRANSACTIONAL }

@ObjectModel:{
        usageType:{
           serviceQuality: #C,
           sizeCategory: #L,
           dataClass: #TRANSACTIONAL
        },
        representativeKey: 'TextCollectionContentUUID'
}
define view entity R_TransportationOrderNoteTP
  as select from            I_TextCollection        as TextCollectionRoot
    left outer to many join I_TextCollectionType    as _TextCollectionType    on TextCollectionRoot.TextCollectionUUID = _TextCollectionType.TextCollectionUUID
    left outer to one join  I_TextCollectionContent as _TextCollectionContent on _TextCollectionType.TextCollectionTypeUUID = _TextCollectionContent.TextCollectionTypeUUID

  association to parent R_TransportationOrderTP as _TransportationOrder on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID

{
  key _TextCollectionContent.TextCollectionContentUUID   as TextCollectionContentUUID,
      _TextCollectionType.TextCollectionTypeUUID         as TextCollectionTypeUUID,
      TextCollectionRoot.TextCollectionUUID              as TextCollectionUUID,
      TextCollectionRoot.TextCollectionSchema            as TextCollectionSchema,
      _TextCollectionType.TextCollectionType             as TextCollectionType,
      @Semantics.user.createdBy: true
      _TextCollectionType.TextCollectionTextCrtedByUser  as TextCollectionTextCrtedByUser,
      @Semantics.systemDate.createdAt: true
      @Semantics.dateTime: true
      _TextCollectionType.TextCollectionTextCrtedDteTime as TextCollectionTextCrtedDteTime,
      @Semantics.systemDate.lastChangedAt: true
      @Semantics.dateTime: true
      _TextCollectionType.TextCollectionTextChgdDateTime as TextCollectionTextChgdDateTime,
      _TextCollectionType.Language                       as Language,
      _TextCollectionContent.TextCollectionContentText   as TextCollectionContentText,
      TextCollectionRoot.HostDocumentBusinessObjectUUID  as HostDocumentBusinessObjectUUID,
      TextCollectionRoot.HostDocumentBusObjNodeUUID      as HostDocumentBusObjNodeUUID,
      TextCollectionRoot.HostDocumentUUID                as TransportationOrderUUID,

      /* Associations */
      _TransportationOrder

}
where
      TextCollectionRoot.DocumentHasText                = 'X'
  and _TextCollectionType.TextCollectionTypeIsInternal  = ' '
  and TextCollectionRoot.HostDocumentBusinessObjectUUID = hextobin('80E0ED0A0C021DEE8CE07DB4266D17C4') //BO: TOR

  and TextCollectionRoot.HostDocumentBusObjNodeUUID     = hextobin('80E0ED0A0C021DDE8CE07DB5DFAD0818') //Node: Root

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TEXTCOLLECTION",
"I_TEXTCOLLECTIONCONTENT",
"I_TEXTCOLLECTIONTYPE"
],
"ASSOCIATED":
[
"R_TRANSPORTATIONORDERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More