P_InternalOrderLongDescription

DDL: P_INTERNALORDERLONGDESCRIPTION Type: view_entity COMPOSITE Package: ODATA_INTERNAL_ORDERS_V2

Internal Order Long Description

P_InternalOrderLongDescription is a Composite CDS View that provides data about "Internal Order Long Description" in SAP S/4HANA. It reads from 1 data source (I_TextObject) and exposes 14 fields with key fields InternalOrder, TextObjectType, TextObjectCategory, Language. Part of development package ODATA_INTERNAL_ORDERS_V2.

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'