P_ReturnsReferenceDocument

DDL: P_RETURNSREFERENCEDOCUMENT Type: view_entity COMPOSITE

P_ReturnsReferenceDocument is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_BillingDocumentItemBasic, I_DeliveryDocument, I_DeliveryDocumentItem) and exposes 11 fields with key fields SDDocument, SalesDocumentItem, DeliveryDocument, DeliveryDocumentItem, SalesDocumentItem.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
I_BillingDocumentItemBasic BillingDocumentItem union_all
I_DeliveryDocument DeliveryDocument inner
I_DeliveryDocumentItem DeliveryDocumentItem from

Annotations (4)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SDDocument I_DeliveryDocumentItem ReferenceSDDocument
KEY SalesDocumentItem I_DeliveryDocumentItem ReferenceSDDocumentItem
KEY DeliveryDocument I_DeliveryDocumentItem DeliveryDocument
KEY DeliveryDocumentItem I_DeliveryDocumentItem DeliveryDocumentItem
SDDocumentCategory I_DeliveryDocumentItem ReferenceSDDocumentCategory
BillingDocumentasSDDocument
KEY SalesDocumentItem I_BillingDocumentItemBasic BillingDocumentItem
KEY DeliveryDocument I_BillingDocumentItemBasic ReferenceSDDocument
KEY DeliveryDocumentItem I_BillingDocumentItemBasic ReferenceSDDocumentItem
SDDocumentCategory I_BillingDocumentItemBasic SDDocumentCategory
ShippingPoint I_BillingDocumentItemBasic ShippingPoint 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

define view entity P_ReturnsReferenceDocument
  as select from I_DeliveryDocumentItem as DeliveryDocumentItem
  inner join I_DeliveryDocument as DeliveryDocument on DeliveryDocumentItem.DeliveryDocument = DeliveryDocument.DeliveryDocument
{
  key DeliveryDocumentItem.ReferenceSDDocument             as SDDocument,
  key DeliveryDocumentItem.ReferenceSDDocumentItem         as SalesDocumentItem,
  key DeliveryDocumentItem.DeliveryDocument                as DeliveryDocument,
  key DeliveryDocumentItem.DeliveryDocumentItem            as DeliveryDocumentItem,
      DeliveryDocumentItem.ReferenceSDDocumentCategory     as SDDocumentCategory,
      DeliveryDocument.ShippingPoint                       as ShippingPoint
}
where
     DeliveryDocumentItem.ReferenceSDDocumentCategory = 'C'
  or DeliveryDocumentItem.ReferenceSDDocumentCategory = 'I'

union all

select from I_BillingDocumentItemBasic as BillingDocumentItem
{
  key BillingDocumentItem.BillingDocument                          as SDDocument,
  key BillingDocumentItem.BillingDocumentItem                      as SalesDocumentItem,
  key BillingDocumentItem.ReferenceSDDocument                      as DeliveryDocument,
  key BillingDocumentItem.ReferenceSDDocumentItem                  as DeliveryDocumentItem,
      BillingDocumentItem.SDDocumentCategory                       as SDDocumentCategory,
      BillingDocumentItem.ShippingPoint                            as ShippingPoint
}
where
      BillingDocumentItem.SDDocumentCategory          = 'M'
  and BillingDocumentItem.ReferenceSDDocumentCategory = 'J'

Learn More