P_FrtOrdWthCalcError

DDL: P_FRTORDWTHCALCERROR SQL: PFOWTHCALCERROR Type: view COMPOSITE

P_FrtOrdWthCalcError is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_TransportationOrder) and exposes 30 fields with key field TransportationOrderUUID. It has 1 association to related views.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
I_TransportationOrder I_TransportationOrder from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_TranspChargeObject _TranspChargeObject $projection.TransportationOrderUUID = _TranspChargeObject.TranspChargeHostDocumentUUID

Annotations (8)

NameValueLevelField
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PFOWTHCALCERROR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderUUID TransportationOrderUUID
TransportationOrder TransportationOrder
TransportationOrderType TransportationOrderType
TransportationOrderTypeDesc
TransportationMode TransportationMode
TransportationModeDesc
TransportationOrderCategory TransportationOrderCategory
TranspOrdTrafficDirection TranspOrdTrafficDirection
PlngAndExecOrganization PlngAndExecOrganization
PurchasingGroup PurchasingGroup
TranspOrdLifeCycleStatus TranspOrdLifeCycleStatus
TranspOrdPlanningStatus TranspOrdPlanningStatus
TransportationOrderExecSts TransportationOrderExecSts
MeansOfTransport MeansOfTransport
TransportationChargesObjUUID _TranspChargeObject TransportationChargesObjUUID
Carrier Carrier
clientNULLasDaysToDepartureDate
TranspOrdResponsiblePerson TranspOrdResponsiblePerson
PlngAndExecGroup PlngAndExecGroup
clientNULLasTranspOrdArrivalDate
clientNULLasTranspOrdDepartureDate
NumberOfOrders
clientNULLasTranspOrdOrderDate
clientNULLasTranspOrdOrderTime
clientNULLasTranspOrdActualArrivalDate
clientNULLasTranspOrdActualDepartureDate
_DestinationStop _DestinationStop
_SourceStop _SourceStop
_PlngAndExecOrganization _PlngAndExecOrganization
_PlngAndExecGroup _PlngAndExecGroup 
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PFOWTHCALCERROR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                 personalData.blocking:#NOT_REQUIRED
                 }
@VDM:   { viewType: #COMPOSITE,
          private: true
        }

define view P_FrtOrdWthCalcError
  as select from I_TransportationOrder
  association [1..1] to I_TranspChargeObject as _TranspChargeObject on $projection.TransportationOrderUUID = _TranspChargeObject.TranspChargeHostDocumentUUID
{

  key TransportationOrderUUID,
      //Added for Authorization Inheritance

      TransportationOrder,
      TransportationOrderType,
      _TransportationOrderType._Text[1:Language = $session.system_language ].TransportationOrderTypeDesc      as TransportationOrderTypeDesc,
      TransportationMode,
      _TransportationMode._Text[1:Language = $session.system_language].TransportationModeDesc                 as TransportationModeDesc,
      TransportationOrderCategory,
      TranspOrdTrafficDirection,
      PlngAndExecOrganization,
      case when PurchasingOrganization is not initial
           then PurchasingOrganization
           else ' ' end                                                                                       as OrganizationalUnit,
      PurchasingGroup,
      TranspOrdLifeCycleStatus,
      TranspOrdPlanningStatus,
      TransportationOrderExecSts,
      MeansOfTransport,
      _TranspChargeObject.TransportationChargesObjUUID                                                        as TransportationChargesObjUUID,
      Carrier,
      dats_days_between( cast( $session.system_date as abap.dats),
                         tstmp_to_dats( _SourceStop.TranspOrdStopPlanTranspDteTme,
                                        abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                                        $session.client,
                                        'NULL' ))                                                             as DaysToDepartureDate,

      //Added for Authorization Inheritance

      TranspOrdResponsiblePerson,
      PlngAndExecGroup,
      @Consumption.filter.selectionType: #INTERVAL
      tstmp_to_dats(_DestinationStop.TranspOrdStopPlanTranspDteTme,
                     abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                     $session.client,
                     'NULL' )                                                                                 as TranspOrdArrivalDate,
      @Consumption.filter.selectionType: #INTERVAL
      tstmp_to_dats( _SourceStop.TranspOrdStopPlanTranspDteTme,
                     abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                     $session.client,
                     'NULL' )                                                                                 as TranspOrdDepartureDate,

      @DefaultAggregation:  #SUM
      cast(1 as abap.int4)                                                                                    as NumberOfOrders,
      tstmp_to_dats( TranspOrdOrderDateTime,
                     abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                     $session.client,
                     'NULL' )                                                                                 as TranspOrdOrderDate,
      tstmp_to_tims( TranspOrdOrderDateTime,
                     abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                     $session.client,
                     'NULL' )                                                                                 as TranspOrdOrderTime,

      //changes for actual arrival and actual departure date

      @Consumption.filter.selectionType: #INTERVAL
      tstmp_to_dats(_DestinationStop.TranspOrdStopPlanExecDteTme,
                     abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                     $session.client,
                     'NULL' )                                                                                 as TranspOrdActualArrivalDate,
      @Consumption.filter.selectionType: #INTERVAL
      tstmp_to_dats(_SourceStop.TranspOrdStopPlanExecDteTme,
                     abap_user_timezone(   $session.user,$session.client,'NULL' ) ,
                     $session.client,
                     'NULL' )                                                                                 as TranspOrdActualDepartureDate,
      //Associations

      _DestinationStop,
      _SourceStop,
      _PlngAndExecOrganization,
      _PlngAndExecGroup
}
where
  (
       TransportationOrderCategory                = 'TO' // Freight Orders

    or TransportationOrderCategory                = 'BO' // Freight Bookings

  )
  and  Carrier != ''
  and  _TranspChargeObject.TranspChargeCalcStatus = '03' // Freight documents only with calculation error

Learn More