I_TranspOrdProcFlwBasicFacts

@EndUserText.label: 'Transportation Order: Proc. Flow Basic Facts'
@ObjectModel:   {representativeKey:  'TransportationOrderUUID',
                 usageType:          {serviceQuality: #C,
                                      sizeCategory:   #XXL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #COMPOSITE}

@AccessControl: {authorizationCheck: #CHECK,
                 personalData.blocking:#('TRANSACTIONAL_DATA')}
@Metadata.allowExtensions:  true

define view entity I_TranspOrdProcFlwBasicFacts
  as select from    I_TransportationOrder      as root

    inner join      I_TransportationOrderStop  as SourceStop      on  root.TransportationOrderUUID             = SourceStop.TransportationOrderUUID
                                                                  and SourceStop.TranspOrdStopSequencePosition = 'F' /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
    inner join      I_TransportationOrderStop  as DestinationStop on  root.TransportationOrderUUID                  = DestinationStop.TransportationOrderUUID
                                                                  and DestinationStop.TranspOrdStopSequencePosition = 'L' /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] } */

  association [0..1] to I_TransportationOrderBlock as _block on  root.TransportationOrderUUID     = _block.TransportationOrderUUID
                                                             and root.TransportationOrderUUID     = _block.TranspOrdBlockedNodeUUID
                                                             and _block.TranspOrdBlockIsOverruled = ''

//    left outer join I_TransportationOrderBlock as block           on  root.TransportationOrderUUID    = block.TransportationOrderUUID

//                                                                  and root.TransportationOrderUUID    = block.TranspOrdBlockedNodeUUID

//                                                                  and block.TranspOrdBlockIsOverruled = ''

{
  key root.TransportationOrderUUID,
      root.TransportationOrder,
      root.TransportationOrderCategory,
      root._TransportationOrderCategory._Text[1:Language = $session.system_language].TransportationOrderCatDesc,



      // Status Attributes

      root.TranspOrdLifeCycleStatus,
      root._TranspOrdLifeCycleStatus._Text[1:Language = $session.system_language].TranspOrdLifeCycleStatusDesc,
      root.TranspOrdPlanningStatus,
      root._TranspOrdPlanningStatus._Text[1:Language = $session.system_language].TranspOrdPlanningStatusDesc,
      root.TransportationOrderExecSts,
      root._TransportationOrderExecSts._Text[1:Language = $session.system_language].TransportationOrderExecStsDesc,

      // Dates from source stop - new global field names to be established?

      SourceStop.TranspOrdStopReqStartDteTme                                    as SourceStopReqdStartDteTme,
      SourceStop.TranspOrdStopReqEndDteTme                                      as SourceStopReqdEndDteTme,
      SourceStop.TranspOrdStopPlanTranspDteTme                                  as SourceStopPlndTranspDteTme,

      // Dates from the Target Stop - New Global Field Names to be established?

      DestinationStop.TranspOrdStopReqStartDteTme                               as DestStopReqdStartDteTme,
      DestinationStop.TranspOrdStopReqEndDteTme                                 as DestStopReqdEndDteTme,
      DestinationStop.TranspOrdStopPlanTranspDteTme                             as DestStopPlndTranspDteTme,

      // Blocking Attributes

      @ObjectModel.foreignKey.association: '_TranspOrdPlanningBlock'
      root.TranspOrdPlanningBlock,
      @ObjectModel.foreignKey.association: '_TranspOrdExecutionIsBlocked'
      root.TranspOrdExecutionIsBlocked,

      root._TranspOrdPlanningBlock._Text[1:Language = $session.system_language].TranspOrdPlanningBlockDesc,
      root._TranspOrdExecutionIsBlocked._Text[1:Language = $session.system_language].TranspOrdExecutionBlockDesc,

      _block.BlockCategory,
      _block._BlockCategory._Text[1:Language = $session.system_language].BlockCategoryDesc,
      _block.TranspOrdBlockedNodeUUID,

      case root.TranspOrdPlanningBlock
        when 'X' then 'X'
        when '' then
          case root.TranspOrdExecutionIsBlocked
            when 'X' then 'X'
            when '' then
              case root.InvoicingIsBlocked
                when 'X' then 'X'
              else
                ''
              end
          else
            ''
        end
      else
        ''
      end                                                                       as TransportationOrderIsBlocked,
      
      // Additional Attributes

      root.TransportationOrderType,
      root._PurchasingOrganization.OrganizationalUnitExternalID as PurchasingOrgExternalID,
      root._PurchasingGroup.OrganizationalUnitExternalID        as PurchasingGroupExternalID,
      root.TranspOrdResponsiblePerson,
      root.TransportationMode,      

      // Association

      root._TransportationOrderCategory,
      root._TranspOrdLifeCycleStatus,
      root._TranspOrdPlanningStatus,
      root._TransportationOrderExecSts,
      root._TranspOrdPlanningBlock,
      root._TranspOrdExecutionIsBlocked,
      root._TransportationOrderType,
      root._TransportationMode,
      _block._BlockCategory
      //_TransportationOrder


}