P_DELIVERYDOCUMENTITEMTEXT

CDS View

P_DELIVERYDOCUMENTITEMTEXT is a CDS View in S/4HANA. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
R_CustRetDelivItemTextTP view_entity from TRANSACTIONAL Customer Returns Delivery Item - Text TP
R_InbDelivItemTextTP view_entity from TRANSACTIONAL Inbound Delivery Item - Text TP
R_OutboundDeliveryItemTextTP view_entity from TRANSACTIONAL Outbound Delivery Item - Text TP 
@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":""
}
}*/

Learn More