I_TranspOrdRootDelivDocRef

DDL: I_TRANSPORDROOTDELIVDOCREF Type: view COMPOSITE

Transportation Order: Root Delivery Document Reference

I_TranspOrdRootDelivDocRef is a Composite CDS View that provides data about "Transportation Order: Root Delivery Document Reference" in SAP S/4HANA. It reads from 2 data sources (P_TranspOrdItmDelivDocRef, I_TransportationOrder) and exposes 8 fields with key field TransportationOrderUUID.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
P_TranspOrdItmDelivDocRef item inner
I_TransportationOrder root inner

Annotations (12)

NameValueLevelField
EndUserText.label Transportation Order: Root Delivery Document Reference view
ObjectModel.representativeKey TransportationOrderUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ITORRTDLVDCRF view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderUUID I_TransportationOrder TransportationOrderUUID
TransportationOrder I_TransportationOrder TransportationOrder
TransportationOrderCategory I_TransportationOrder TransportationOrderCategory
TranspOrdPartnerReference I_TransportationOrder TranspOrdPartnerReference
MasterBillOfLading I_TransportationOrder MasterBillOfLading
TranspOrdDocReferenceType docRef TranspOrdDocReferenceType
TranspOrdDocReferenceID docRef TranspOrdDocReferenceID
TranspOrdItmWhseNmbr P_TranspOrdItmDelivDocRef TranspOrdItmWhseNmbr 
@EndUserText.label: 'Transportation Order: Root Delivery Document Reference'
@ObjectModel:   {representativeKey:  'TransportationOrderUUID',
                 usageType:          {serviceQuality: #C,
                                      sizeCategory:   #XXL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #COMPOSITE}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'ITORRTDLVDCRF',
                 buffering:          {status: #NOT_ALLOWED},
                 preserveKey: true }
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                 personalData.blocking:#('TRANSACTIONAL_DATA')}
@ClientHandling.algorithm:           #SESSION_VARIABLE

define view I_TranspOrdRootDelivDocRef
  as select distinct from I_TranspOrdDocRef         as docRef
    inner join            I_TransportationOrder     as root on root.TransportationOrderUUID = docRef.TransportationOrderUUID
    inner join            P_TranspOrdItmDelivDocRef as item on  item.TransportationOrderUUID = docRef.TransportationOrderUUID
                                                            and item.TranspOrdDocReferenceID = docRef.TranspOrdDocReferenceID
{
  key root.TransportationOrderUUID     as TransportationOrderUUID,
      root.TransportationOrder         as TransportationOrder,
      root.TransportationOrderCategory as TransportationOrderCategory,
      root.TranspOrdPartnerReference   as TranspOrdPartnerReference,
      root.MasterBillOfLading          as MasterBillOfLading,
      docRef.TranspOrdDocReferenceType as TranspOrdDocReferenceType,
      docRef.TranspOrdDocReferenceID   as TranspOrdDocReferenceID,
      item.TranspOrdItmWhseNmbr        as TranspOrdItmWhseNmbr
}
where
  (
       root.TransportationOrderCategory = 'TO'
    or root.TransportationOrderCategory = 'BO'
    or root.TransportationOrderCategory = 'TU'
  )
  and(
       docRef.TranspOrdDocReferenceType = '58'
    or docRef.TranspOrdDocReferenceType = '73'
    or docRef.TranspOrdDocReferenceType = '496'
    or docRef.TranspOrdDocReferenceType = '3004'
  )

Learn More