P_DeliveryDocumentItemText

DDL: P_DELIVERYDOCUMENTITEMTEXT Type: view_entity COMPOSITE

P_DeliveryDocumentItemText is a Composite CDS View 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.

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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENTITEM",
"R_TEXTOBJECTEMPTYTEXT_2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/