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.

2 data source(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

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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORDSTOPITMLOADREF",
"I_TRANSPORTATIONORDER",
"I_TRANSPORTATIONORDERITEM"
],
"ASSOCIATED":
[
"C_FREIGHTORDERSTOPASR"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More