R_TransportationOrderTP

DDL: R_TRANSPORTATIONORDERTP Type: view_entity TRANSACTIONAL

Transportation Order - TP

R_TransportationOrderTP is a Transactional CDS View that provides data about "Transportation Order - TP" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrder) and exposes 91 fields with key field TransportationOrderUUID. It has 13 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TransportationOrder I_TransportationOrder from

Associations (13)

CardinalityTargetAliasCondition
[0..1] R_TrOrdMainBPAddrDfltRprstnTP _CarrierAddrDfltRprstn $projection.TransportationOrderUUID = _CarrierAddrDfltRprstn.TransportationOrderUUID and _CarrierAddrDfltRprstn.TranspOrdBizPartnerFunction = 'U3'
[0..1] R_TrOrdMainBPAddrDfltRprstnTP _ShipperAddrDfltRprstn $projection.TransportationOrderUUID = _ShipperAddrDfltRprstn.TransportationOrderUUID and _ShipperAddrDfltRprstn.TranspOrdBizPartnerFunction = 'U6'
[0..1] R_TrOrdMainBPAddrDfltRprstnTP _ConsigneeAddrDfltRprstn $projection.TransportationOrderUUID = _ConsigneeAddrDfltRprstn.TransportationOrderUUID and _ConsigneeAddrDfltRprstn.TranspOrdBizPartnerFunction = 'WE'
[0..1] R_TrOrdMainBPAddrDfltRprstnTP _ExectgCarrierAddrDfltRprstn $projection.TransportationOrderUUID = _ExectgCarrierAddrDfltRprstn.TransportationOrderUUID and _ExectgCarrierAddrDfltRprstn.TranspOrdBizPartnerFunction = 'TJ'
[1] E_TransportationOrder _Extension $projection.TransportationOrderUUID = _Extension.TransportationOrderUUID
[0..*] R_TransportationOrderBPTP _TransportationOrderBP
[0..*] R_TranspOrdDocRefTP _TranspOrdDocumentReference
[0..*] R_TransportationOrderItemTP _TransportationOrderItem
[0..*] R_TransportationOrderStopTP _TransportationOrderStop
[0..*] R_TransportationOrderEventTP _TransportationOrderEvent
[0..3] R_TrOrdMainBPAddrDfltRprstnTP _TrOrdMainBPAddrDfltRprstn
[0..*] R_TransportationOrderNoteTP _TransportationOrderNote
[0..1] R_TransportationOrderChargeTP _TransportationOrderCharge

Annotations (13)

NameValueLevelField
EndUserText.label Transportation Order - TP 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 TransportationOrderUUID view
ObjectModel.sapObjectNodeType.name TransportationOrder view
AccessControl.authorizationCheck #MANDATORY view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix TOR view
AbapCatalog.extensibility.quota.maximumFields 408 view
AbapCatalog.extensibility.quota.maximumBytes 8160 view

Fields (91)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderUUID TransportationOrderUUID
TransportationOrder TransportationOrder
TransportationOrderType TransportationOrderType
TransportationOrderCategory TransportationOrderCategory
TransportationShippingType TranspOrdShippingType
MovementType MovementType
TransportationMode TransportationMode
TransportationModeCategory TransportationModeCategory
CarrierUUID CarrierUUID
Carrier Carrier
CarrierAddressID CarrierAddressID
StandardCarrierAlphaCode StandardCarrierAlphaCode
TranspOrdExecutingCarrierUUID TranspOrdExecutingCarrierUUID
TranspOrdExecutingCarrier TranspOrdExecutingCarrier
ExecutingCarrierAddressID ExecutingCarrierAddressID
ShipperUUID ShipperUUID
Shipper Shipper
ShipperAddressID ShipperAddressID
ConsigneeUUID ConsigneeUUID
Consignee Consignee
ConsigneeAddressID ConsigneeAddressID
TranspPurgOrg PurchasingOrganization
TranspPurgOrgExtID PurchasingOrgExternalID
TranspPurgGroup PurchasingGroup
TranspPurgGroupExtID PurchasingGroupExternalID
PurgOrgCompanyCode PurgOrgCompanyCode
PlngAndExecOrganization PlngAndExecOrganization
PlngAndExecGroup PlngAndExecGroup
CarrierAccountNumber TransOrdAcctNmbrWthExectgCarr
TranspMeansOfTransport MeansOfTransport
TranspOrdPartnerReference TranspOrdPartnerReference
MasterBillOfLading MasterBillOfLading
TranspOrdResponsiblePerson TranspOrdResponsiblePerson
TranspOrdHasMltplExectgPties TranspOrdHasMltplExectgPties
TranspOrdInvoicingCarrierLevel TranspOrdInvoicingCarrierLevel
TranspOrdLifeCycleStatus TranspOrdLifeCycleStatus
TranspOrderSubcontrgSts TranspOrderSubcontrgSts
TransportationOrderConfSts TransportationOrderConfSts
TransportationOrderExecSts TransportationOrderExecSts
TranspOrdGoodsMovementStatus TranspOrdGoodsMovementStatus
TranspOrdWhseProcessingStatus TranspOrdWhseProcessingStatus
TranspOrderDngrsGdsSts TranspOrderDngrsGdsSts
TranspOrdPlanningBlock TranspOrdPlanningBlock
TranspOrdExecutionIsBlocked TranspOrdExecutionIsBlocked
TransportationOrderCrtnType TransportationOrderCrtnType
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
ChangedDateTime ChangedDateTime
_Carrier _Carrier
_Consignee _Consignee
_CreatedBy _CreatedBy
_DestinationStop _DestinationStop
_LastChangedBy _LastChangedBy
_MeansOfTransport _MeansOfTransport
_MovementType _MovementType
_PlngAndExecGroup _PlngAndExecGroup
_PlngAndExecOrganization _PlngAndExecOrganization
_PurchasingCompanyCode _PurchasingCompanyCode
_PurchasingGroup _PurchasingGroup
_PurchasingOrganization _PurchasingOrganization
_Shipper _Shipper
_SourceStop _SourceStop
_TranspOrdConfirmationStatus _TranspOrdConfirmationStatus
_TranspOrdExecutionIsBlocked _TranspOrdExecutionIsBlocked
_TranspOrdLifeCycleStatus _TranspOrdLifeCycleStatus
_TranspOrdPlanningBlock _TranspOrdPlanningBlock
_TranspOrdResponsiblePerson _TranspOrdResponsiblePerson
_TranspOrdShippingType _TranspOrdShippingType
_TranspOrdSubcontractingSts _TranspOrdSubcontractingSts
_TransportationMode _TransportationMode
_TransportationModeCategory _TransportationModeCategory
_TransportationOrderBlock _TransportationOrderBlock
_TransportationOrderCategory _TransportationOrderCategory
_TransportationOrderExecSts _TransportationOrderExecSts
_TransportationOrderStage _TransportationOrderStage
_TransportationOrderType _TransportationOrderType
_TranspSCACCode _TranspSCACCode
_TranspOrdDngrsGdsStatus _TranspOrdDngrsGdsStatus
_TransportationOrderBP _TransportationOrderBP
_TranspOrdDocumentReference _TranspOrdDocumentReference
_TransportationOrderItem _TransportationOrderItem
_TransportationOrderStop _TransportationOrderStop
_TransportationOrderEvent _TransportationOrderEvent
_TrOrdMainBPAddrDfltRprstn _TrOrdMainBPAddrDfltRprstn
_TransportationOrderNote _TransportationOrderNote
_TransportationOrderCharge _TransportationOrderCharge
_CarrierAddrDfltRprstn _CarrierAddrDfltRprstn
_ShipperAddrDfltRprstn _ShipperAddrDfltRprstn
_ConsigneeAddrDfltRprstn _ConsigneeAddrDfltRprstn
_ExectgCarrierAddrDfltRprstn _ExectgCarrierAddrDfltRprstn
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@EndUserText.label: 'Transportation Order - TP'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
    usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass:#TRANSACTIONAL
    },
    semanticKey: ['TransportationOrder'],
    representativeKey: 'TransportationOrderUUID',
    sapObjectNodeType.name: 'TransportationOrder'
}
@AccessControl: { authorizationCheck: #MANDATORY,
                  privilegedAssociations: ['_TransportationOrderStage',
                                           '_TranspOrdPlanningBlock',
                                           '_TransportationOrderBlock',
                                           '_SourceStop',
                                           '_DestinationStop',
                                           '_TranspOrdResponsiblePerson',
                                           '_CreatedBy',
                                           '_LastChangedBy']}
@AbapCatalog.extensibility: {
  extensible: true,
  dataSources: ['_Extension'],
  elementSuffix: 'TOR',
  quota: {
    maximumFields: 408, //This is calculated with formula - 2* <Customer Percentage from SCFD_REGISTRY> * <max number of fields in SCFD_REGISTRY>

    maximumBytes: 8160  //This is calculated with formula - 4* <Customer Percentage from SCFD_REGISTRY> * <number of chars as defined in SCFD_REGISTRY>

  }
 }

define root view entity R_TransportationOrderTP
  as select from I_TransportationOrder
  composition [0..*] of R_TransportationOrderBPTP     as _TransportationOrderBP
  composition [0..*] of R_TranspOrdDocRefTP           as _TranspOrdDocumentReference
  composition [0..*] of R_TransportationOrderItemTP   as _TransportationOrderItem
  composition [0..*] of R_TransportationOrderStopTP   as _TransportationOrderStop
  composition [0..*] of R_TransportationOrderEventTP  as _TransportationOrderEvent
  composition [0..3] of R_TrOrdMainBPAddrDfltRprstnTP as _TrOrdMainBPAddrDfltRprstn
  composition [0..*] of R_TransportationOrderNoteTP   as _TransportationOrderNote
  // Charges specific composition

  composition [0..1] of R_TransportationOrderChargeTP as _TransportationOrderCharge

  association [0..1] to R_TrOrdMainBPAddrDfltRprstnTP as _CarrierAddrDfltRprstn       on  $projection.TransportationOrderUUID                     = _CarrierAddrDfltRprstn.TransportationOrderUUID
                                                                                     and _CarrierAddrDfltRprstn.TranspOrdBizPartnerFunction       = 'U3'
  association [0..1] to R_TrOrdMainBPAddrDfltRprstnTP as _ShipperAddrDfltRprstn       on  $projection.TransportationOrderUUID                     = _ShipperAddrDfltRprstn.TransportationOrderUUID
                                                                                     and _ShipperAddrDfltRprstn.TranspOrdBizPartnerFunction       = 'U6'
  association [0..1] to R_TrOrdMainBPAddrDfltRprstnTP as _ConsigneeAddrDfltRprstn     on  $projection.TransportationOrderUUID                     = _ConsigneeAddrDfltRprstn.TransportationOrderUUID
                                                                                     and _ConsigneeAddrDfltRprstn.TranspOrdBizPartnerFunction     = 'WE'
  association [0..1] to R_TrOrdMainBPAddrDfltRprstnTP as _ExectgCarrierAddrDfltRprstn on  $projection.TransportationOrderUUID                     = _ExectgCarrierAddrDfltRprstn.TransportationOrderUUID
                                                                                     and _ExectgCarrierAddrDfltRprstn.TranspOrdBizPartnerFunction = 'TJ'                                                                                  
  //Extension Association

  association [1]    to E_TransportationOrder            as _Extension            on  $projection.TransportationOrderUUID = _Extension.TransportationOrderUUID
{
      /* Attributes */
      // Identification

  key TransportationOrderUUID,
      TransportationOrder,

      // Key Characteristics

      TransportationOrderType,
      TransportationOrderCategory,
      TranspOrdShippingType         as TransportationShippingType,
      MovementType,
      TransportationMode,
      TransportationModeCategory,

      // Parties

      CarrierUUID,
      Carrier,
      CarrierAddressID,
      StandardCarrierAlphaCode,
      TranspOrdExecutingCarrierUUID,
      TranspOrdExecutingCarrier,
      ExecutingCarrierAddressID,
      ShipperUUID,
      Shipper,
      ShipperAddressID,
      ConsigneeUUID,
      Consignee,
      ConsigneeAddressID,

      PurchasingOrganization        as TranspPurgOrg,
      PurchasingOrgExternalID       as TranspPurgOrgExtID,
      PurchasingGroup               as TranspPurgGroup,
      PurchasingGroupExternalID     as TranspPurgGroupExtID,
      PurgOrgCompanyCode,
      PlngAndExecOrganization,
      PlngAndExecGroup,
      TransOrdAcctNmbrWthExectgCarr as CarrierAccountNumber,

      // Further Attributes

      MeansOfTransport              as TranspMeansOfTransport,
      TranspOrdPartnerReference,
      MasterBillOfLading,
      TranspOrdResponsiblePerson,
      TranspOrdHasMltplExectgPties,
      TranspOrdInvoicingCarrierLevel,

      // Status

      TranspOrdLifeCycleStatus,
      TranspOrderSubcontrgSts,
      TransportationOrderConfSts,
      TransportationOrderExecSts,
      TranspOrdGoodsMovementStatus,
      TranspOrdWhseProcessingStatus,
      TranspOrderDngrsGdsSts,
      TranspOrdPlanningBlock,
      TranspOrdExecutionIsBlocked,

      // Administrative Data

      TransportationOrderCrtnType,
      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      ChangedDateTime,


      /* Associations */
      _Carrier,
      _Consignee,
      _CreatedBy,
      _DestinationStop,
      _LastChangedBy,
      _MeansOfTransport,
      _MovementType,
      _PlngAndExecGroup,
      _PlngAndExecOrganization,
      _PurchasingCompanyCode,
      _PurchasingGroup,
      _PurchasingOrganization,
      _Shipper,
      _SourceStop,
      _TranspOrdConfirmationStatus,
      _TranspOrdExecutionIsBlocked,
      _TranspOrdLifeCycleStatus,
      _TranspOrdPlanningBlock,
      _TranspOrdResponsiblePerson,
      _TranspOrdShippingType,
      _TranspOrdSubcontractingSts,
      _TransportationMode,
      _TransportationModeCategory,
      _TransportationOrderBlock,
      _TransportationOrderCategory,
      _TransportationOrderExecSts,
      _TransportationOrderStage,
      _TransportationOrderType,
      _TranspSCACCode,
      _TranspOrdDngrsGdsStatus,

      /* Composition Associations */
      _TransportationOrderBP,
      _TranspOrdDocumentReference,
      _TransportationOrderItem,
      _TransportationOrderStop,
      _TransportationOrderEvent,
      _TrOrdMainBPAddrDfltRprstn,
      _TransportationOrderNote,
      //Charges specific compositions

      _TransportationOrderCharge,

      _CarrierAddrDfltRprstn,
      _ShipperAddrDfltRprstn,
      _ConsigneeAddrDfltRprstn,
      _ExectgCarrierAddrDfltRprstn

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORTATIONORDER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_COMPANYCODE",
"I_MEANSOFTRANSPORT",
"I_TRANSPMOVEMENTTYPE",
"I_TRANSPORDCONFIRMATIONSTATUS",
"I_TRANSPORDDNGRSGDSSTATUS",
"I_TRANSPORDEXECUTIONISBLOCKED",
"I_TRANSPORDLIFECYCLESTATUS",
"I_TRANSPORDPLANNINGBLOCK",
"I_TRANSPORDSHIPPINGTYPE",
"I_TRANSPORDSUBCONTRACTINGSTS",
"I_TRANSPORGANIZATIONALUNIT",
"I_TRANSPORTATIONMODE",
"I_TRANSPORTATIONMODECATEGORY",
"I_TRANSPORTATIONORDERBLOCK",
"I_TRANSPORTATIONORDERCATEGORY",
"I_TRANSPORTATIONORDEREXECSTS",
"I_TRANSPORTATIONORDERSTAGE",
"I_TRANSPORTATIONORDERSTOP",
"I_TRANSPORTATIONORDERTYPE",
"I_TRANSPSCACCODE",
"I_USER",
"R_TRANSPORDDOCREFTP",
"R_TRANSPORTATIONORDERBPTP",
"R_TRANSPORTATIONORDERCHARGETP",
"R_TRANSPORTATIONORDEREVENTTP",
"R_TRANSPORTATIONORDERITEMTP",
"R_TRANSPORTATIONORDERNOTETP",
"R_TRANSPORTATIONORDERSTOPTP",
"R_TRORDMAINBPADDRDFLTRPRSTNTP"
],
"BASE":
[
"I_TRANSPORTATIONORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/