P_FrtOrdWthCalcError

DDL: P_FRTORDWTHCALCERROR SQL: PFOWTHCALCERROR Type: view COMPOSITE Package: CVIEW_TM_FO_CALC_ERROR

Private view for Freight Order with calculation error

P_FrtOrdWthCalcError is a Composite CDS View that provides data about "Private view for Freight Order with calculation error" 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. Part of development package CVIEW_TM_FO_CALC_ERROR.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
I_TransportationOrder I_TransportationOrder from

Associations (1)

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

Annotations (7)

NameValueLevelField
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 TransportationChargeUUID
Carrier Carrier
clientNULLasDaysToDepartureDate
TranspOrdResponsiblePerson TranspOrdResponsiblePerson
PlngAndExecGroup PlngAndExecGroup
clientNULLasTranspOrdArrivalDate
clientNULLasTranspOrdDepartureDate
NumberOfOrders
clientNULLasTranspOrdOrderDate
clientNULLasTranspOrdOrderTime
clientNULLasTranspOrdActualArrivalDate
clientNULLasTranspOrdActualDepartureDate
_DestinationStop _DestinationStop
_SourceStop _SourceStop
_PlngAndExecOrganization _PlngAndExecOrganization
_PlngAndExecGroup _PlngAndExecGroup 
@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_TransportationCharge as _TranspChargeObject on $projection.TransportationOrderUUID = _TranspChargeObject.TranspChargeHostDocumentUUID
{

  key TransportationOrderUUID,
      //Added for Authorization Inheritance

      TransportationOrder,
      TransportationOrderType,
      I_TransportationOrder._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,
      //ERP Org implementation

      case when TranspPurgOrg is not initial
           then TranspPurgOrg
           else ' ' end                                                                                                        as TranspPurgOrg,
      //End of implementation

      TranspOrdLifeCycleStatus,
      TranspOrdPlanningStatus,
      TransportationOrderExecSts,
      MeansOfTransport,
      _TranspChargeObject.TransportationChargeUUID                                                                             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