C_FrtOrdStopLoadRefERPOrder

DDL: C_FRTORDSTOPLOADREFERPORDER Type: view_entity CONSUMPTION

Reference Stop to ERP Order Item

C_FrtOrdStopLoadRefERPOrder is a Consumption CDS View that provides data about "Reference Stop to ERP Order 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.

3 data source(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 ERP Order 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

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TranspOrdStopItemLoadRefUUID I_TranspOrdStopItmLoadRef TranspOrdStopItemLoadRefUUID
TransportationOrderStopUUID I_TranspOrdStopItmLoadRef TransportationOrderStopUUID
TransportationOrderItemUUID I_TranspOrdStopItmLoadRef TransportationOrderItemUUID
TranspOrdERPOrderDocumentID I_TranspOrdDocRef TranspOrdDocReferenceID
_Stop _Stop 
@EndUserText.label: 'Reference Stop to ERP Order 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_FrtOrdStopLoadRefERPOrder
  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    = '001'
                                                                or _DocRef.TranspOrdDocReferenceType = '114'
                                                                or _DocRef.TranspOrdDocReferenceType = 'RPO'
                                                              )
    association to parent C_FreightOrderStopASR as _Stop on  $projection.TransportationOrderStopUUID = _Stop.TransportationOrderStopUUID                                                               

{
  key StopItemLoadref.TranspOrdStopItemLoadRefUUID,
      StopItemLoadref.TransportationOrderStopUUID,
      StopItemLoadref.TransportationOrderItemUUID,
      _DocRef.TranspOrdDocReferenceID as TranspOrdERPOrderDocumentID,
      
      // to parent

      _Stop 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORDDOCREF",
"I_TRANSPORDSTOPITMLOADREF",
"I_TRANSPORTATIONORDERITEM"
],
"ASSOCIATED":
[
"C_FREIGHTORDERSTOPASR"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More