C_FrtOrdStopLoadRefCsgnmt

DDL: C_FRTORDSTOPLOADREFCSGNMT Type: view_entity CONSUMPTION

Reference Stop to Consignment Order Item

C_FrtOrdStopLoadRefCsgnmt is a Consumption CDS View that provides data about "Reference Stop to Consignment Order Item" in SAP S/4HANA. It reads from 4 data sources (I_TransportationOrder, I_TransportationOrderItem, I_TransportationOrderItem, I_TranspOrdStopItmLoadRef) and exposes 7 fields with key field TranspOrdStopItemLoadRefUUID.

4 data source(s) 7 fields

Data Sources (4)

SourceAliasJoin Type
I_TransportationOrder _ConsignmentOrder inner
I_TransportationOrderItem _ShipmentItem inner
I_TransportationOrderItem _TopLevelItem inner
I_TranspOrdStopItmLoadRef StopItemLoadref from

Annotations (7)

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

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY TranspOrdStopItemLoadRefUUID I_TranspOrdStopItmLoadRef TranspOrdStopItemLoadRefUUID
TransportationOrderStopUUID I_TranspOrdStopItmLoadRef TransportationOrderStopUUID
TransportationOrderUUID I_TranspOrdStopItmLoadRef TransportationOrderUUID
TransportationOrderItemUUID I_TranspOrdStopItmLoadRef TransportationOrderItemUUID
TranspOrdInternalCsgnmtOrdID I_TransportationOrder TransportationOrder
TranspOrdExternalCsgnmtOrdID I_TransportationOrder TranspOrdPartnerReference
_FreightOrderStop _FreightOrderStop 
@EndUserText.label: 'Reference Stop to Consignment Order Item'
@ObjectModel:   {   usageType:          {serviceQuality: #D,
                                         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_FrtOrdStopLoadRefCsgnmt
  as select from    I_TranspOrdStopItmLoadRef as StopItemLoadref 
    inner join I_TransportationOrderItem  as _TopLevelItem     on StopItemLoadref.TransportationOrderItemUUID = _TopLevelItem.TransportationOrderItemUUID
    inner join I_TransportationOrderItem  as _ShipmentItem     on _TopLevelItem.TranspOrdShptItemRefUUID = _ShipmentItem.TransportationOrderItemUUID
    inner join I_TransportationOrder      as _ConsignmentOrder on _ShipmentItem.PredecessorTransportationOrder = _ConsignmentOrder.TransportationOrderUUID

    association to parent C_FreightOrderStopASR as _FreightOrderStop on $projection.TransportationOrderStopUUID = _FreightOrderStop.TransportationOrderStopUUID

{
  key StopItemLoadref.TranspOrdStopItemLoadRefUUID,
      StopItemLoadref.TransportationOrderStopUUID,
      StopItemLoadref.TransportationOrderUUID,
      StopItemLoadref.TransportationOrderItemUUID,
      _ConsignmentOrder.TransportationOrder       as TranspOrdInternalCsgnmtOrdID,
      _ConsignmentOrder.TranspOrdPartnerReference as TranspOrdExternalCsgnmtOrdID,
           
      // Association to parent

      _FreightOrderStop
}

where
  _ConsignmentOrder.TransportationOrderCategory = 'TU' and _ConsignmentOrder.TransportationUnitCategory = 'O' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORDSTOPITMLOADREF",
"I_TRANSPORTATIONORDER",
"I_TRANSPORTATIONORDERITEM"
],
"ASSOCIATED":
[
"C_FREIGHTORDERSTOPASR"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More