C_FrtOrdExecutionEvent

DDL: C_FRTORDEXECUTIONEVENT SQL: CTORFOEXECEEVT Type: view CONSUMPTION

Freight Order Execution Event

C_FrtOrdExecutionEvent is a Consumption CDS View that provides data about "Freight Order Execution Event" in SAP S/4HANA. It reads from 1 data source (I_TranspOrdExecution) and exposes 12 fields with key field TransportationOrderEventUUID.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_TranspOrdExecution I_TranspOrdExecution from

Annotations (14)

NameValueLevelField
EndUserText.label Freight Order Execution Event view
ObjectModel.representativeKey TransportationOrderEventUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CTORFOEXECEEVT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.status #DEPRECATED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderEventUUID TransportationOrderEventUUID
TransportationOrderUUID TransportationOrderUUID
TranspOrdExecution TranspOrdExecution
TranspOrdEventCode TranspOrdEventCode
TranspOrdEventCodeDesc
CreatedByUser CreatedByUser
TranspOrdEvtActualDateTime TranspOrdEvtActualDateTime
LocationUUID LocationUUID
LocationAdditionalUUID LocationAdditionalUUID
LocationDescription
_CreatedByUser _CreatedByUser
_TranspOrdEventCode _TranspOrdEventCode 
@EndUserText.label: 'Freight Order Execution Event'
@ObjectModel:   {representativeKey:  'TransportationOrderEventUUID',
                 usageType:          {serviceQuality: #C,
                                      sizeCategory:   #XXL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #CONSUMPTION}
@AbapCatalog.sqlViewName:           'CTORFOEXECEEVT'
@AbapCatalog:   {compiler:           {compareFilter: true},
                 buffering:          {status: #NOT_ALLOWED},
                 preserveKey: true
                }
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                 personalData.blocking:#('TRANSACTIONAL_DATA')}
@Metadata.allowExtensions:  true
@ClientHandling.algorithm:  #SESSION_VARIABLE

@VDM.lifecycle.status: #DEPRECATED
/* Fiori Object page was removed; This this CDS view is not required anymore and no successor created */

define view C_FrtOrdExecutionEvent
  as select from I_TranspOrdExecution

  //  association to parent C_FrtOrdExecution as _FrtOrdExecution on $projection.TransportationOrderUUID = _FrtOrdExecution.TransportationOrderUUID


{
  key TransportationOrderEventUUID                                                            as TransportationOrderEventUUID,
      TransportationOrderUUID                                                                 as TransportationOrderUUID,
      TranspOrdExecution                                                                      as TranspOrdExecution,
      @ObjectModel.text.element: ['TranspOrdEventCodeDesc']
      TranspOrdEventCode                                                                      as TranspOrdEventCode,
      @Semantics.text: true
      _TranspOrdEventCode._Text[1:Language = $session.system_language].TranspOrdEventCodeDesc as TranspOrdEventCodeDesc,

      CreatedByUser                                                                           as CreatedByUser,
      TranspOrdEvtActualDateTime                                                              as TranspOrdEvtActualDateTime,
      LocationUUID                                                                            as LocationUUID,
      LocationAdditionalUUID                                                                  as LocationAdditionalUUID,

      @Semantics.text: true
      _TransportationOrderStop._Locationdescr.AddressObjectDescription                        as LocationDescription,

      /* Associations */
      @Consumption.filter.hidden: true
      _CreatedByUser,
      //_LocationAdtl,

      @Consumption.filter.hidden: true
      _TranspOrdEventCode
      //@Consumption.filter.hidden: true

      //_TransportationOrder, --> issue with ATC, only temporary and to be solved in Basic View!

      //      @Consumption.filter.hidden: true

      //      _FrtOrdExecution


}
where
      TranspOrdEventIsRecalled =  ''
  and TranspOrdExecution       <> ''
  and TranspOrdEventStatus     <> 'I'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TMLOCATIONDESCRIPTION",
"I_TRANSPORDEVENTCODE",
"I_TRANSPORDEVENTCODETEXT",
"I_TRANSPORDEXECUTION",
"I_TRANSPORTATIONORDERSTOP"
],
"ASSOCIATED":
[
"I_TRANSPORDEVENTCODE",
"I_USER"
],
"BASE":
[
"I_TRANSPORDEXECUTION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More