I_FreightOrderTP

DDL: I_FREIGHTORDERTP Type: view_entity TRANSACTIONAL Package: RAP_TM_FO_API

Freight Order - TP

I_FreightOrderTP is a Transactional CDS View that provides data about "Freight Order - TP" in SAP S/4HANA. It reads from 1 data source (R_TransportationOrderTP) and exposes 42 fields with key field TransportationOrderUUID. Part of development package RAP_TM_FO_API.

1 data source(s) 42 fields

Data Sources (1)

SourceAliasJoin Type
R_TransportationOrderTP R_TransportationOrderTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Freight Order - TP view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey TransportationOrderUUID view
ObjectModel.sapObjectNodeType.name FreightOrder view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderUUID TransportationOrderUUID
TransportationOrder TransportationOrder
TransportationOrderType TransportationOrderType
TransportationOrderCategory TransportationOrderCategory
TransportationShippingType TransportationShippingType
TransportationMode TransportationMode
TransportationModeCategory TransportationModeCategory
CarrierUUID CarrierUUID
Carrier Carrier
StandardCarrierAlphaCode StandardCarrierAlphaCode
TranspOrdExecutingCarrierUUID TranspOrdExecutingCarrierUUID
TranspOrdExecutingCarrier TranspOrdExecutingCarrier
ShipperUUID ShipperUUID
Shipper Shipper
ShipperAddressID ShipperAddressID
ConsigneeUUID ConsigneeUUID
Consignee Consignee
ConsigneeAddressID ConsigneeAddressID
TranspPurgOrg TranspPurgOrg
TranspPurgOrgExtID TranspPurgOrgExtID
TranspPurgGroup TranspPurgGroup
TranspPurgGroupExtID TranspPurgGroupExtID
PurgOrgCompanyCode PurgOrgCompanyCode
CarrierAccountNumber CarrierAccountNumber
TranspMeansOfTransport TranspMeansOfTransport
TranspOrdPartnerReference TranspOrdPartnerReference
TranspOrdResponsiblePerson TranspOrdResponsiblePerson
TranspOrdHasMltplExectgPties TranspOrdHasMltplExectgPties
TranspOrdInvoicingCarrierLevel TranspOrdInvoicingCarrierLevel
TranspOrdLifeCycleStatus TranspOrdLifeCycleStatus
TranspOrderSubcontrgSts TranspOrderSubcontrgSts
TransportationOrderConfSts TransportationOrderConfSts
TransportationOrderExecSts TransportationOrderExecSts
TranspOrdGoodsMovementStatus TranspOrdGoodsMovementStatus
TranspOrdWhseProcessingStatus TranspOrdWhseProcessingStatus
TranspOrderDngrsGdsSts TranspOrderDngrsGdsSts
TranspOrdExecutionIsBlocked TranspOrdExecutionIsBlocked
TransportationOrderCrtnType TransportationOrderCrtnType
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
ChangedDateTime ChangedDateTime 
@EndUserText.label: 'Freight Order - TP'
@VDM: {
  lifecycle.contract.type: #PUBLIC_LOCAL_API,
  viewType: #TRANSACTIONAL
}
@ObjectModel: {
   modelingPattern:       #TRANSACTIONAL_INTERFACE,
   supportedCapabilities: [#TRANSACTIONAL_PROVIDER],
   usageType: {
     sizeCategory:   #L,
     serviceQuality: #C,
     dataClass:      #TRANSACTIONAL
   },
   semanticKey: ['TransportationOrder'],
   representativeKey: 'TransportationOrderUUID',
   sapObjectNodeType.name: 'FreightOrder'
}
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #MANDATORY

define root view entity I_FreightOrderTP
  provider contract transactional_interface
  as projection on R_TransportationOrderTP as FreightOrder

{
      /* Attributes */
      // Identification

  key TransportationOrderUUID,
      TransportationOrder,

      // Key Characteristics

      TransportationOrderType,
      TransportationOrderCategory,
      TransportationShippingType,
      TransportationMode,
      TransportationModeCategory,

      // Parties

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

      TranspPurgOrg,
      TranspPurgOrgExtID,
      TranspPurgGroup,
      TranspPurgGroupExtID,
      PurgOrgCompanyCode,
      CarrierAccountNumber,

      // Further Attributes

      TranspMeansOfTransport,
      TranspOrdPartnerReference,
      TranspOrdResponsiblePerson,
      TranspOrdHasMltplExectgPties,
      TranspOrdInvoicingCarrierLevel,

      // Status

      TranspOrdLifeCycleStatus,
      TranspOrderSubcontrgSts,
      TransportationOrderConfSts,
      TransportationOrderExecSts,
      TranspOrdGoodsMovementStatus,
      TranspOrdWhseProcessingStatus,
      TranspOrderDngrsGdsSts,
      @Semantics.booleanIndicator: true
      TranspOrdExecutionIsBlocked,

      // Administrative Data

      TransportationOrderCrtnType,
      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      ChangedDateTime,

      /* Redirections */
      FreightOrder._TransportationOrderBP       as _FreightOrderBusinessPartner   : redirected to composition child I_FreightOrderBPTP,
      FreightOrder._TranspOrdDocumentReference  as _FreightOrderDocumentReference : redirected to composition child I_FreightOrderDocRefTP,
      FreightOrder._TransportationOrderItem     as _FreightOrderItem              : redirected to composition child I_FreightOrderItemTP,
      FreightOrder._TransportationOrderStop     as _FreightOrderStop              : redirected to composition child I_FreightOrderStopTP,
      FreightOrder._TransportationOrderEvent    as _FreightOrderEvent             : redirected to composition child I_FreightOrderEventTP,
      FreightOrder._TransportationOrderCharge   as _FreightOrderCharge            : redirected to composition child I_FreightOrderChargeTP,
      FreightOrder._TrOrdMainBPAddrDfltRprstn   as _FrtOrdMainBPAddrDfltRprstn    : redirected to composition child I_FrtOrdMainBPAddrDfltRprstnTP,

      /* Association redirections */
      FreightOrder._CarrierAddrDfltRprstn       as _CarrierAddrDfltRprstn         : redirected to I_FrtOrdMainBPAddrDfltRprstnTP,
      FreightOrder._ShipperAddrDfltRprstn       as _ShipperAddrDfltRprstn         : redirected to I_FrtOrdMainBPAddrDfltRprstnTP,
      FreightOrder._ConsigneeAddrDfltRprstn     as _ConsigneeAddrDfltRprstn       : redirected to I_FrtOrdMainBPAddrDfltRprstnTP,
      FreightOrder._ExectgCarrierAddrDfltRprstn as _ExectgCarrierAddrDfltRprstn   : redirected to I_FrtOrdMainBPAddrDfltRprstnTP

}
where
  TransportationOrderCategory = 'TO'

Learn More