C_FrtOrdStopLoadRefFreightUnit

DDL: C_FRTORDSTOPLOADREFFREIGHTUNIT Type: view_entity CONSUMPTION

Reference Stop to Freight Unit

C_FrtOrdStopLoadRefFreightUnit is a Consumption CDS View that provides data about "Reference Stop to Freight Unit" in SAP S/4HANA. It reads from 2 data sources (I_TransportationOrder, I_TransportationOrderItem) and exposes 6 fields with key field FreightUnit. It is exposed through 1 OData service (UI_FREIGHTORDERSTOPASR).

2 data source(s) Exposed by 1 service(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_TransportationOrder _FreightUnit inner
I_TransportationOrderItem _TopLevelItem inner

Annotations (7)

NameValueLevelField
EndUserText.label Reference Stop to Freight Unit 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 (6)

KeyFieldSource TableSource FieldDescription
KEY FreightUnit I_TransportationOrder TransportationOrder
TransportationOrderStopUUID StopItemLoadref TransportationOrderStopUUID
TransportationOrderUUID StopItemLoadref TransportationOrderUUID
TransportationOrderItemUUID StopItemLoadref TransportationOrderItemUUID
TranspOrdPlannedGdsMvtDteTme I_TransportationOrder TranspOrdPlannedGdsMvtDteTme
_Stop _Stop 
@EndUserText.label: 'Reference Stop to Freight Unit'
@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_FrtOrdStopLoadRefFreightUnit 
  as select distinct from I_TranspOrdStopItmLoadRef as StopItemLoadref
    inner join   I_TransportationOrderItem  as _TopLevelItem on StopItemLoadref.TransportationOrderItemUUID = _TopLevelItem.TransportationOrderItemUUID
    inner join   I_TransportationOrder      as _FreightUnit  on _FreightUnit.TransportationOrderUUID = _TopLevelItem.FreightUnitUUID
    association to parent C_FreightOrderStopASR as _Stop on  $projection.TransportationOrderStopUUID = _Stop.TransportationOrderStopUUID

{
  key  _FreightUnit.TransportationOrder as FreightUnit,
       StopItemLoadref.TransportationOrderStopUUID,
       StopItemLoadref.TransportationOrderUUID,
       StopItemLoadref.TransportationOrderItemUUID,
       _FreightUnit.TranspOrdPlannedGdsMvtDteTme,
       // to parent

       _Stop
}

Learn More