P_DeliveryDocumentItemText

DDL: P_DELIVERYDOCUMENTITEMTEXT Type: view_entity COMPOSITE Package: VDM_LE_SHP_COMMON

Delivery Document Item Text

P_DeliveryDocumentItemText is a Composite CDS View that provides data about "Delivery Document Item Text" in SAP S/4HANA. It reads from 2 data sources (I_DeliveryDocumentItem, R_TextObjectEmptyText_2) and exposes 5 fields with key fields DeliveryDocument, DeliveryDocumentItem, Language, LongTextID. Part of development package VDM_LE_SHP_COMMON.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_DeliveryDocumentItem _DeliveryDocumentItem inner
R_TextObjectEmptyText_2 _TextObjectEmptyText from

Annotations (3)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument I_DeliveryDocumentItem DeliveryDocument
KEY DeliveryDocumentItem I_DeliveryDocumentItem DeliveryDocumentItem
KEY Language R_TextObjectEmptyText_2 Language
KEY LongTextID R_TextObjectEmptyText_2 TextObjectType
LongText R_TextObjectEmptyText_2 PlainLongText 
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view entity P_DeliveryDocumentItemText
  as select from R_TextObjectEmptyText_2 as _TextObjectEmptyText
    inner join   I_DeliveryDocumentItem as _DeliveryDocumentItem 
      on _TextObjectEmptyText.TextObjectKey = concat( _DeliveryDocumentItem.DeliveryDocument, _DeliveryDocumentItem.DeliveryDocumentItem )
{
  key _DeliveryDocumentItem.DeliveryDocument,
  key _DeliveryDocumentItem.DeliveryDocumentItem,
  key _TextObjectEmptyText.Language,
  key _TextObjectEmptyText.TextObjectType as LongTextID,

      _TextObjectEmptyText.PlainLongText  as LongText
}
where
       _TextObjectEmptyText.TextObjectCategory = 'VBBP'

Learn More