P_DeliveryDocumentItemText
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)
| Source | Alias | Join Type |
|---|---|---|
| I_DeliveryDocumentItem | _DeliveryDocumentItem | inner |
| R_TextObjectEmptyText_2 | _TextObjectEmptyText | from |
Annotations (3)
| Name | Value | Level | Field |
|---|---|---|---|
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view |
Fields (5)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA