R_TransportationOrderStopTP

DDL: R_TRANSPORTATIONORDERSTOPTP Type: view_entity TRANSACTIONAL

Transportation Order Stop - TP

R_TransportationOrderStopTP is a Transactional CDS View that provides data about "Transportation Order Stop - TP" in SAP S/4HANA. It reads from 2 data sources (I_TransportationOrder, I_TransportationOrderStop) and exposes 41 fields with key field TransportationOrderStopUUID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_TransportationOrder TransportationOrder inner
I_TransportationOrderStop TransportationOrderStop from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_TransportationOrderStageTP _TranspOrderStage
[0..1] R_TrOrdStopLocAddrDfltRprstnTP _TrOrdStopLocAddrDfltRprstn

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Transportation Order Stop - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey TransportationOrderStopUUID view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderStopUUID I_TransportationOrderStop TransportationOrderStopUUID
TransportationOrderUUID I_TransportationOrderStop TransportationOrderUUID
TransportationOrderStop I_TransportationOrderStop TransportationOrderStop
TranspOrdStopStopParentUUID I_TransportationOrderStop TranspOrdStopStopParentUUID
TranspOrdStopCategory I_TransportationOrderStop TranspOrdStopCategory
TranspOrdStopRole I_TransportationOrderStop TranspOrdStopRole
LocationAdditionalUUID I_TransportationOrderStop LocationAdditionalUUID
LocationId I_TransportationOrderStop LocationId
LocationUNCode I_TransportationOrderStop TranspOrdStopLocUNCode
LocationIATACode I_TransportationOrderStop TranspOrdStopLocIATACode
TranspOrdStopAccptblStrtDteTme I_TransportationOrderStop TranspOrdStopAccptblStrtDteTme
TranspOrdStopReqStartDteTme I_TransportationOrderStop TranspOrdStopReqStartDteTme
TranspOrdStopReqEndDteTme I_TransportationOrderStop TranspOrdStopReqEndDteTme
TranspOrdStopAccptblEndDteTme I_TransportationOrderStop TranspOrdStopAccptblEndDteTme
TranspOrdStopPlanTranspDteTme I_TransportationOrderStop TranspOrdStopPlanTranspDteTme
TranspOrdStopDteTme I_TransportationOrderStop TranspOrdStopDteTme
TranspOrdStopApptStrtDteTme I_TransportationOrderStop TranspOrdStopApptStrtDteTme
TranspOrdStopApptEndDteTme I_TransportationOrderStop TranspOrdStopApptEndDteTme
TranspStopCarrConfStrtDteTme I_TransportationOrderStop TranspStopCarrConfStrtDteTme
TranspStopCarrConfEndDteTme I_TransportationOrderStop TranspStopCarrConfEndDteTme
TranspOrdStopDocCutOffDateTime I_TransportationOrderStop TranspOrdStopDocCutOffDateTime
TranspOrdStopCrgoCutOffDteTme I_TransportationOrderStop TranspOrdStopCrgoCutOffDteTme
TranspOrdStopVGMCutOffDateTime I_TransportationOrderStop TranspOrdStopVGMCutOffDateTime
TranspOrdStopSequencePosition I_TransportationOrderStop TranspOrdStopSequencePosition
TranspOrdCapacityStopUUID I_TransportationOrderStop TranspOrdCapacityStopUUID
TranspOrdStopCapacityItemUUID I_TransportationOrderStop TranspOrdStopCapacityItemUUID
TranspOrdStopHndlgExecStatus I_TransportationOrderStop TranspOrdStopHndlgExecStatus
TranspOrdStopExecIsBlocked I_TransportationOrderStop TranspOrdStopExecIsBlocked
TransportationOrderCategory I_TransportationOrder TransportationOrderCategory
_CapacityStop I_TransportationOrderStop _CapacityStop
_LocationAdditional I_TransportationOrderStop _LocationAdditional
_LocationDescription I_TransportationOrderStop _LocationDescription
_TranspHndlgExecStatus I_TransportationOrderStop _TranspHndlgExecStatus
_TranspOrdExecTranspActyArr I_TransportationOrderStop _TranspOrdExecTranspActyArr
_TranspOrdExecTranspActyDep I_TransportationOrderStop _TranspOrdExecTranspActyDep
_TranspOrdExecution I_TransportationOrderStop _TranspOrdExecution
_TranspOrdStopCategory I_TransportationOrderStop _TranspOrdStopCategory
_TranspOrdStopRole I_TransportationOrderStop _TranspOrdStopRole
_TransportationOrder _TransportationOrder
_TranspOrderStage _TranspOrderStage
_TrOrdStopLocAddrDfltRprstn _TrOrdStopLocAddrDfltRprstn
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl: {
  authorizationCheck: #MANDATORY,
  privilegedAssociations: [
    '_TranspOrdExecTranspActyDep',
    '_TranspOrdExecTranspActyArr',
    '_CapacityStop',
    '_TranspOrdExecution'
  ]
}
@EndUserText.label: 'Transportation Order Stop - TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
    usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass:#TRANSACTIONAL
    },
    semanticKey: ['TransportationOrderStop'],
    representativeKey: 'TransportationOrderStopUUID'
}

define view entity R_TransportationOrderStopTP
  as select from I_TransportationOrderStop as TransportationOrderStop
  /* We must join I_TransportationOrder to make I_TransportationOrder.TransportationOrderCategory available in the
   * projection views to filter by TransportationOrderCategory
   */
    inner join   I_TransportationOrder     as TransportationOrder on TransportationOrder.TransportationOrderUUID = TransportationOrderStop.TransportationOrderUUID
  association to parent R_TransportationOrderTP        as _TransportationOrder on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
  composition [0..*] of R_TransportationOrderStageTP   as _TranspOrderStage
  composition [0..1] of R_TrOrdStopLocAddrDfltRprstnTP as _TrOrdStopLocAddrDfltRprstn
{
      /* Attributes */

      // Identification

  key TransportationOrderStop.TransportationOrderStopUUID,
      TransportationOrderStop.TransportationOrderUUID,
      TransportationOrderStop.TransportationOrderStop,
      TransportationOrderStop.TranspOrdStopStopParentUUID, // Stop Hierarchies are currently not supported in S/4HANA Cloud


      // Key Characteristics

      TransportationOrderStop.TranspOrdStopCategory,
      TransportationOrderStop.TranspOrdStopRole,

      // Location

      TransportationOrderStop.LocationAdditionalUUID, // This is the RAW16 UUID of the Location; LocationUUID is the CHAR22 GUID

      TransportationOrderStop.LocationId,
      TransportationOrderStop.TranspOrdStopLocUNCode   as LocationUNCode,
      TransportationOrderStop.TranspOrdStopLocIATACode as LocationIATACode,

      // Dates and Times

      TransportationOrderStop.TranspOrdStopAccptblStrtDteTme,
      TransportationOrderStop.TranspOrdStopReqStartDteTme,
      TransportationOrderStop.TranspOrdStopReqEndDteTme,
      TransportationOrderStop.TranspOrdStopAccptblEndDteTme,

      TransportationOrderStop.TranspOrdStopPlanTranspDteTme,
      TransportationOrderStop.TranspOrdStopDteTme,

      TransportationOrderStop.TranspOrdStopApptStrtDteTme,
      TransportationOrderStop.TranspOrdStopApptEndDteTme,

      TransportationOrderStop.TranspStopCarrConfStrtDteTme,
      TransportationOrderStop.TranspStopCarrConfEndDteTme,

      TransportationOrderStop.TranspOrdStopDocCutOffDateTime,
      TransportationOrderStop.TranspOrdStopCrgoCutOffDteTme,
      TransportationOrderStop.TranspOrdStopVGMCutOffDateTime,

      // Further Attributes

      TransportationOrderStop.TranspOrdStopSequencePosition,

      // References to Capacity Documents

      TransportationOrderStop.TranspOrdCapacityStopUUID,
      TransportationOrderStop.TranspOrdStopCapacityItemUUID,

      // Status

      TransportationOrderStop.TranspOrdStopHndlgExecStatus,
      @Semantics.booleanIndicator
      TransportationOrderStop.TranspOrdStopExecIsBlocked,

      // (Technical/Hidden) Attributes

      TransportationOrder.TransportationOrderCategory,

      /* Associations */
      TransportationOrderStop._CapacityStop,
      TransportationOrderStop._LocationAdditional,
      TransportationOrderStop._LocationDescription,
      TransportationOrderStop._TranspHndlgExecStatus,
      TransportationOrderStop._TranspOrdExecTranspActyArr,
      TransportationOrderStop._TranspOrdExecTranspActyDep,
      TransportationOrderStop._TranspOrdExecution,
      TransportationOrderStop._TranspOrdStopCategory,
      TransportationOrderStop._TranspOrdStopRole,
      _TransportationOrder,
      _TranspOrderStage,
      _TrOrdStopLocAddrDfltRprstn
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORTATIONORDER",
"I_TRANSPORTATIONORDERSTOP"
],
"ASSOCIATED":
[
"I_LOCATIONBASIC",
"I_TMLOCATIONDESCRIPTION",
"I_TRANSPHNDLGEXECSTATUS",
"I_TRANSPORDEXECTRANSPACTY",
"I_TRANSPORDEXECUTION",
"I_TRANSPORDSTOPCATEGORY",
"I_TRANSPORDSTOPROLE",
"I_TRANSPORTATIONORDERSTOP",
"R_TRANSPORTATIONORDERSTAGETP",
"R_TRANSPORTATIONORDERTP",
"R_TRORDSTOPLOCADDRDFLTRPRSTNTP"
],
"BASE":
[
"I_TRANSPORTATIONORDERSTOP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/