R_TRANSPORTATIONORDERSTAGETP

CDS View

Transportation Order Stage - TP

R_TRANSPORTATIONORDERSTAGETP is a CDS View in S/4HANA. Transportation Order Stage - TP. 6 CDS views read from this table.

Used by 6 CDS view(s)

CDS Views using this table (6)

ViewTypeJoinVDMDescription
A_FreightBookingStage view_entity projection CONSUMPTION Freight Booking Stage
A_FreightOrderStage view_entity projection CONSUMPTION Freight Order Stage
A_FreightUnitStage view_entity projection CONSUMPTION Freight Unit Stage
I_FreightBookingStageTP view_entity projection TRANSACTIONAL Freight Booking Stage - TP
I_FreightOrderStageTP view_entity projection TRANSACTIONAL Freight Order Stage - TP
I_FreightUnitStageTP view_entity projection TRANSACTIONAL Freight Unit Stage - TP 
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl: {
  authorizationCheck: #MANDATORY,
  privilegedAssociations: [
    '_TranspOrdStageSrceStop',
    '_TranspOrdStageDestStop'
  ]
}
@EndUserText.label: 'Transportation Order Stage - TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
    usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass:#TRANSACTIONAL
    },
    semanticKey: ['TransportationOrderStage'],
    representativeKey: 'TransportationOrderStageUUID'
}
@AbapCatalog.extensibility: {
  extensible: true,
  dataSources: ['_Extension'],
  elementSuffix: 'TSS',
  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 view entity R_TransportationOrderStageTP
  as select from I_TransportationOrderStage_2 as TransportationOrderStage

  composition [0..*] of R_TrOrdStgeBPAddrDfltRprstnTP as _TrOrdStgeBPAddrDfltRprstn
  
  association to parent R_TransportationOrderStopTP   as _TranspOrderStop             on  $projection.TranspOrdStageSrceStopUUID = _TranspOrderStop.TransportationOrderStopUUID
  association [1..1] to R_TransportationOrderTP       as _TransportationOrder         on  $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID

  association [0..1] to R_TrOrdStgeBPAddrDfltRprstnTP as _ExectgCarrierAddrDfltRprstn on  $projection.TransportationOrderStageUUID                 = _ExectgCarrierAddrDfltRprstn.TransportationOrderStageUUID
                                                                                      and _ExectgCarrierAddrDfltRprstn.TranspOrdBizPartnerFunction = 'TJ'
  association [0..1] to R_TrOrdStgeBPAddrDfltRprstnTP as _InvcgCarrierAddrDfltRprstn  on  $projection.TransportationOrderStageUUID                = _InvcgCarrierAddrDfltRprstn.TransportationOrderStageUUID
                                                                                      and _InvcgCarrierAddrDfltRprstn.TranspOrdBizPartnerFunction = 'U3'
  //Extension Association

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

  key TransportationOrderStage.TransportationOrderStageUUID,
      TransportationOrderStage.TransportationOrderUUID,
      TransportationOrderStage.TransportationOrderStage,

      // Key Characteristics

      TransportationOrderStage.TranspOrdStageType,
      TransportationOrderStage.TranspOrdStageCategory,
      TransportationOrderStage.TransportationMode,
      TransportationOrderStage.TransportationModeCategory,
      TransportationOrderStage.TransportationShippingType,
      TransportationOrderStage.TranspOrdStageVoyage,
      TransportationOrderStage.TranspOrdStageVessel,
      TransportationOrderStage.TranspOrdStageFlight,

      // Parties

      TransportationOrderStage.TranspOrdStgeInvcgCarrLvl,

      TransportationOrderStage.CarrierUUID,
      TransportationOrderStage.Carrier,
      TransportationOrderStage.TranspOrdStageSCACCode,

      TransportationOrderStage.TranspOrdStgeInvcgCarrUUID,
      TransportationOrderStage.TranspOrdStageInvoicingCarrier,
      TransportationOrderStage.TranspOrdStgeInvcgSCACCode,

      // Distance and Duration

      @Semantics.quantity.unitOfMeasure: 'TranspOrdStageDistanceUnit'
      TransportationOrderStage.TranspOrdStageDistance,
      TransportationOrderStage.TranspOrdStageDistanceUnit,
      TransportationOrderStage.TranspOrdStageNetDuration,

      TransportationOrderStage.TranspOrdStageSrceStopUUID,
      TransportationOrderStage.TranspOrdStageDestStopUUID,


      // (Technical/Hidden) Attributes

      _TransportationOrder.TransportationOrderCategory,

      /* Associations */
      TransportationOrderStage._Carrier,
      TransportationOrderStage._TranspOrdStageCategory,
      TransportationOrderStage._TranspOrdStageDestStop,
      TransportationOrderStage._TranspOrdStageSrceStop,
      TransportationOrderStage._TranspOrdStageType,
      TransportationOrderStage._TransportationMode,
      TransportationOrderStage._TransportationModeCategory,
      _TransportationOrder,
      _TrOrdStgeBPAddrDfltRprstn,
      _ExectgCarrierAddrDfltRprstn,
      _InvcgCarrierAddrDfltRprstn,
      _TranspOrderStop
}

Learn More