I_PurchasingLongText

DDL: I_PURCHASINGLONGTEXT SQL: IPURLONGTXT Type: view BASIC Package: APPL_MM_COMP_NOTES

Purchasing Long Text

I_PurchasingLongText is a Basic CDS View that provides data about "Purchasing Long Text" in SAP S/4HANA. It reads from 1 data source (stxh) and exposes 8 fields with key fields TextObjectCategory, TextObjectKey, TextObjectType, Language. It has 1 association to related views. Part of development package APPL_MM_COMP_NOTES.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
stxh stxh from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_TextObjectPlainLongText _LongText $projection.TextObjectCategory = _LongText.TextObjectCategory and $projection.TextObjectKey = _LongText.TextObjectKey and $projection.TextObjectType = _LongText.TextObjectType and $projection.Language = _LongText.Language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPURLONGTXT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchasing Long Text view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #A view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY TextObjectCategory tdobject
KEY TextObjectKey tdname
KEY TextObjectType tdid
KEY Language tdspras
PlainLongText _LongText PlainLongText
FixedIndicator
DisplayModeOfTextTypeInPurg
TextIsAdoptedFromReference 
@AbapCatalog.sqlViewName: 'IPURLONGTXT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Purchasing Long Text'
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #A

define view I_PurchasingLongText
  as select from stxh
  association [1..1] to I_TextObjectPlainLongText as _LongText on  $projection.TextObjectCategory       = _LongText.TextObjectCategory
                                                               and $projection.TextObjectKey            = _LongText.TextObjectKey
                                                               and $projection.TextObjectType           = _LongText.TextObjectType
                                                               and $projection.Language                 = _LongText.Language
{

  key  tdobject                           as TextObjectCategory,
  key  tdname                             as TextObjectKey,
  key  tdid                               as TextObjectType,
  key  tdspras                            as Language,

       _LongText.PlainLongText            as PlainLongText,

       cast('' as fixie)                  as FixedIndicator,

       cast('' as mmpur_text_displaymode) as DisplayModeOfTextTypeInPurg,

       cast('' as mmpur_t_text_isadopted) as TextIsAdoptedFromReference
}

Learn More