C_FrtOrdStopLoadRefLogsExecDlv

DDL: C_FRTORDSTOPLOADREFLOGSEXECDLV Type: view_entity CONSUMPTION

Reference Stop to LE Delivery Item

C_FrtOrdStopLoadRefLogsExecDlv is a Consumption CDS View that provides data about "Reference Stop to LE Delivery Item" in SAP S/4HANA. It reads from 3 data sources (I_TranspOrdDocRef, I_TransportationOrderItem, I_TranspOrdStopItmLoadRef) and exposes 5 fields with key field TranspOrdStopItemLoadRefUUID. It is exposed through 1 OData service (UI_FREIGHTORDERSTOPASR).

3 data source(s) Exposed by 1 service(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
I_TranspOrdDocRef _DocRef inner
I_TransportationOrderItem _TopLevelItem inner
I_TranspOrdStopItmLoadRef StopItemLoadref from

Annotations (7)

NameValueLevelField
EndUserText.label Reference Stop to LE Delivery Item view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_FREIGHTORDERSTOPASR UI_FREIGHTORDERSTOPASR V4 C1 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TranspOrdStopItemLoadRefUUID I_TranspOrdStopItmLoadRef TranspOrdStopItemLoadRefUUID
TransportationOrderStopUUID I_TranspOrdStopItmLoadRef TransportationOrderStopUUID
TransportationOrderItemUUID I_TranspOrdStopItmLoadRef TransportationOrderItemUUID
TranspOrdLogsExecDeliveryID I_TranspOrdDocRef TranspOrdDocReferenceID
_Stop _Stop 
@EndUserText.label: 'Reference Stop to LE Delivery Item'
@ObjectModel:   {   usageType:          {serviceQuality: #C,
                                         sizeCategory:   #XL,
                                         dataClass:      #TRANSACTIONAL}}
@VDM:           {   viewType:           #CONSUMPTION,
                    usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]}
@AccessControl: {   authorizationCheck: #MANDATORY,
                    personalData.blocking:#('TRANSACTIONAL_DATA') }
@Metadata.allowExtensions: true
define view entity C_FrtOrdStopLoadRefLogsExecDlv
  as select from I_TranspOrdStopItmLoadRef as StopItemLoadref
    inner join   I_TransportationOrderItem  as _TopLevelItem on StopItemLoadref.TransportationOrderItemUUID = _TopLevelItem.TransportationOrderItemUUID
    inner join   I_TranspOrdDocRef          as _DocRef       on  _DocRef.TranspOrdOrigRefRootUUID    = _TopLevelItem.TranspOrdOrigRefRootUUID
                                                             and _DocRef.TransportationOrderUUID     = StopItemLoadref.TransportationOrderUUID
                                                             and (
                                                                _DocRef.TranspOrdDocReferenceType    = '58'
                                                                or _DocRef.TranspOrdDocReferenceType = '73'
                                                                or _DocRef.TranspOrdDocReferenceType = '700'
                                                              )
    association to parent C_FreightOrderStopASR as _Stop on  $projection.TransportationOrderStopUUID = _Stop.TransportationOrderStopUUID                                                              
                                                              
{
  key StopItemLoadref.TranspOrdStopItemLoadRefUUID,
      StopItemLoadref.TransportationOrderStopUUID,
      StopItemLoadref.TransportationOrderItemUUID,
      _DocRef.TranspOrdDocReferenceID as TranspOrdLogsExecDeliveryID,
      
      // to parent

      _Stop
}

Learn More