P_CollabnApplFrtOrdExecStop

DDL: P_COLLABNAPPLFRTORDEXECSTOP Type: view_entity CONSUMPTION

Private View for FO Execution Stop

P_CollabnApplFrtOrdExecStop is a Consumption CDS View that provides data about "Private View for FO Execution Stop" in SAP S/4HANA. It reads from 2 data sources (P_CollabnApplCarrierUser, I_TransportationOrderStop) and exposes 14 fields with key field TransportationOrderStopUUID. It has 4 associations to related views.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
P_CollabnApplCarrierUser CollabnApplCarrierUser inner
I_TransportationOrderStop TransportationOrderStop from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_TranspOrdStopSqncPosition _TranspOrdStopSequencePosition $projection.TranspOrdStopSequencePosition = _TranspOrdStopSequencePosition.TranspOrdStopSequencePosition
[0..1] C_CollabnApplFrtOrdInExecution _CollabnApplFreightOrdForExec $projection.TransportationOrderUUID = _CollabnApplFreightOrdForExec.TransportationOrderUUID
[0..1] P_CollabnFrtOrdAssgdStopEvt _FrtOrdTypeAssgdStopEvents $projection.TransportationOrderType = _FrtOrdTypeAssgdStopEvents.TransportationOrderType and $projection.TranspOrdStopCategory = _FrtOrdTypeAssgdStopEvents.TranspOrdStopCategory
[0..1] I_CollabnApplFrtOrdStopCat _CollabnApplFrtOrdStopCat $projection.TranspOrdStopCategory = _CollabnApplFrtOrdStopCat.TranspOrdStopCategory

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Private View for FO Execution Stop view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderStopUUID I_TransportationOrderStop TransportationOrderStopUUID
TransportationOrderUUID I_TransportationOrderStop TransportationOrderUUID
TransportationOrderStop I_TransportationOrderStop TransportationOrderStop
TransportationOrderCategory
TransportationOrderType
TranspOrdStopCategoryDesc
TranspOrdStopCategory I_TransportationOrderStop TranspOrdStopCategory
TranspOrdStopSequencePosDesc
TranspOrdStopSequencePosition I_TransportationOrderStop TranspOrdStopSequencePosition
LocationId I_TransportationOrderStop LocationId
LocationDescription
TranspOrdStopAccptblStrtDteTme I_TransportationOrderStop TranspOrdStopAccptblStrtDteTme
TranspOrdStopAccptblEndDteTme I_TransportationOrderStop TranspOrdStopAccptblEndDteTme
_FrtOrdTypeAssgdStopEvents _FrtOrdTypeAssgdStopEvents 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@EndUserText.label: 'Private View for FO  Execution Stop'

define view entity P_CollabnApplFrtOrdExecStop
  as select from I_TransportationOrderStop as TransportationOrderStop
     inner join   P_CollabnApplCarrierUser  as CollabnApplCarrierUser on CollabnApplCarrierUser.UserID = $session.user

  association [0..1] to I_TranspOrdStopSqncPosition    as _TranspOrdStopSequencePosition on  $projection.TranspOrdStopSequencePosition = _TranspOrdStopSequencePosition.TranspOrdStopSequencePosition
  association [0..1] to C_CollabnApplFrtOrdInExecution as _CollabnApplFreightOrdForExec  on  $projection.TransportationOrderUUID = _CollabnApplFreightOrdForExec.TransportationOrderUUID
  association [0..1] to P_CollabnFrtOrdAssgdStopEvt    as _FrtOrdTypeAssgdStopEvents     on  $projection.TransportationOrderType = _FrtOrdTypeAssgdStopEvents.TransportationOrderType
                                                                                         and $projection.TranspOrdStopCategory   = _FrtOrdTypeAssgdStopEvents.TranspOrdStopCategory
  association [0..1] to I_CollabnApplFrtOrdStopCat     as _CollabnApplFrtOrdStopCat      on $projection.TranspOrdStopCategory = _CollabnApplFrtOrdStopCat.TranspOrdStopCategory
{

  key TransportationOrderStop.TransportationOrderStopUUID,
      TransportationOrderStop.TransportationOrderUUID,
      TransportationOrderStop.TransportationOrderStop,
      TransportationOrderStop._TransportationOrder.TransportationOrderCategory                                                as TransportationOrderCategory,
      TransportationOrderStop._TransportationOrder.TransportationOrderType                                                    as TransportationOrderType,
      @Semantics.text:true
      _CollabnApplFrtOrdStopCat._Text[1: Language = $session.system_language ].TranspOrdStopCategoryDesc                      as TranspOrdStopCategoryDesc,
      @ObjectModel.text.element: ['TranspOrdStopCategoryDesc']
      TransportationOrderStop.TranspOrdStopCategory,

      @Semantics.text:true
      _TranspOrdStopSequencePosition._Text[1: Language = $session.system_language ].TranspOrdStopSequencePosDesc              as TranspOrdStopSequencePosDesc,
      @ObjectModel.text.element: ['TranspOrdStopSequencePosDesc']
      TransportationOrderStop.TranspOrdStopSequencePosition,

      @ObjectModel.text.element: ['LocationDescription']
      TransportationOrderStop.LocationId,
      @Semantics.text:true
      TransportationOrderStop._Locationdescr.LocationDescription                                                              as LocationDescription,
      @Semantics.dateTime: true
      TransportationOrderStop.TranspOrdStopAccptblStrtDteTme,
      @Semantics.dateTime: true
      TransportationOrderStop.TranspOrdStopAccptblEndDteTme,

      @Semantics.dateTime: true
      ( case when TransportationOrderStop.TranspOrdStopReqStartDteTme is initial
             then TransportationOrderStop.TranspOrdStopPlanTranspDteTme
             else TransportationOrderStop.TranspOrdStopReqStartDteTme  end )                                                  as TranspOrdStopReqStartDteTme,
      @Semantics.dateTime: true
      ( case when TransportationOrderStop.TranspOrdStopReqEndDteTme is initial
             then TransportationOrderStop.TranspOrdStopPlanTranspDteTme
             else TransportationOrderStop.TranspOrdStopReqEndDteTme  end )                                                    as TranspOrdStopReqEndDteTme,

      _FrtOrdTypeAssgdStopEvents

}
where   (TransportationOrderStop.TranspOrdStopCategory = 'I' or TransportationOrderStop.TranspOrdStopCategory = 'O' )
    and CollabnApplCarrierUser.BusinessPartnerCompany = _CollabnApplFreightOrdForExec.Carrier
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_COLLABNAPPLFRTORDINEXECUTION",
"I_COLLABNAPPLFRTORDSTOPCAT",
"I_COLLABNAPPLFRTORDSTOPCATTEXT",
"I_TMLOCATIONDESCRIPTION",
"I_TRANSPORDSTOPSQNCPOSITION",
"I_TRANSPORDSTOPSQNCPOSITIONTXT",
"I_TRANSPORTATIONORDER",
"I_TRANSPORTATIONORDERSTOP",
"P_COLLABNAPPLCARRIERUSER"
],
"ASSOCIATED":
[
"P_COLLABNFRTORDASSGDSTOPEVT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More