P_InternalOrderLongDescription

DDL: P_INTERNALORDERLONGDESCRIPTION Type: view_entity COMPOSITE

P_InternalOrderLongDescription is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_TextObject) and exposes 14 fields with key fields InternalOrder, TextObjectType, TextObjectCategory, Language.

Data Sources (1)

SourceAliasJoin Type
I_TextObject I_TextObject from

Annotations (7)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #COMPOSITE view
VDM.private true view
VDM.lifecycle.contract.type #NONE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY InternalOrder
KEY TextObjectType TextObjectType
KEY TextObjectCategory TextObjectCategory
KEY Language Language
IntOrdLongDescIsAvailable
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
_TextObjectType _TextObjectType
_TextObjectCategory _TextObjectCategory
_Language _Language
@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory: #L,
    dataClass: #CUSTOMIZING
  }
}
@VDM: {
  viewType: #COMPOSITE,
  private: true,
  lifecycle.contract.type:#NONE
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity P_InternalOrderLongDescription
  as select from I_TextObject
{
  key cast(TextObjectKey as fins_int_aufnr )                     as InternalOrder,
  key TextObjectType,
  key TextObjectCategory,
  key Language,
      cast('X' as fco_io_longdesc_is_available preserving type ) as IntOrdLongDescIsAvailable,
      CreatedByUser,
      CreationDate,
      CreationTime,
      LastChangedByUser,
      LastChangeDate,
      LastChangeTime,

      _TextObjectType,
      _TextObjectCategory,
      _Language
}
where
      TextObjectType     = 'LTXT'
  and TextObjectCategory = 'AUFK'