I_FreightBookingTP

DDL: I_FREIGHTBOOKINGTP Type: view_entity TRANSACTIONAL Package: RAP_TM_FB_API

Freight Booking - TP

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

Data Sources (1)

SourceAliasJoin Type
R_TransportationOrderTP R_TransportationOrderTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Freight Booking - 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 FreightBooking view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderUUID TransportationOrderUUID
TransportationOrder TransportationOrder
TransportationOrderType TransportationOrderType
TransportationOrderCategory TransportationOrderCategory
TransportationShippingType TransportationShippingType
MovementType MovementType
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
TranspOrdPartnerReference TranspOrdPartnerReference
MasterBillOfLading MasterBillOfLading
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 Booking - 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: 'FreightBooking'
}
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #MANDATORY

define root view entity I_FreightBookingTP
  provider contract transactional_interface
  as projection on R_TransportationOrderTP as FreightBooking
{
      /* Attributes */
      // Identification

  key TransportationOrderUUID,
      TransportationOrder,

      // Key Characteristics

      TransportationOrderType,
      TransportationOrderCategory,
      TransportationShippingType,
      MovementType,
      TransportationMode,
      TransportationModeCategory,

      // Parties

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

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

      // Further Characteristics

      TranspOrdPartnerReference,
      MasterBillOfLading,
      TranspOrdResponsiblePerson,
      TranspOrdHasMltplExectgPties,
      TranspOrdInvoicingCarrierLevel,

      // Status

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

      // Administrative Data

      TransportationOrderCrtnType,
      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      ChangedDateTime,

      /* Redirections */
      FreightBooking._TransportationOrderBP       as _FreightBookingBusinessPartner : redirected to composition child I_FreightBookingBPTP,
      FreightBooking._TranspOrdDocumentReference  as _FreightBookingDocRef          : redirected to composition child I_FreightBookingDocRefTP,
      FreightBooking._TransportationOrderItem     as _FreightBookingItem            : redirected to composition child I_FreightBookingItemTP,
      FreightBooking._TransportationOrderStop     as _FreightBookingStop            : redirected to composition child I_FreightBookingStopTP,
      FreightBooking._TransportationOrderEvent    as _FreightBookingEvent           : redirected to composition child I_FreightBookingEventTP,
      FreightBooking._TransportationOrderCharge   as _FreightBookingCharge          : redirected to composition child I_FreightBookingChargeTP,
      FreightBooking._TrOrdMainBPAddrDfltRprstn   as _FrtBkgMainBPAddrDfltRprstn    : redirected to composition child I_FrtBkgMainBPAddrDfltRprstnTP,

      /* Association redirections */
      FreightBooking._CarrierAddrDfltRprstn       as _CarrierAddrDfltRprstn         : redirected to I_FrtBkgMainBPAddrDfltRprstnTP,
      FreightBooking._ShipperAddrDfltRprstn       as _ShipperAddrDfltRprstn         : redirected to I_FrtBkgMainBPAddrDfltRprstnTP,
      FreightBooking._ConsigneeAddrDfltRprstn     as _ConsigneeAddrDfltRprstn       : redirected to I_FrtBkgMainBPAddrDfltRprstnTP,
      FreightBooking._ExectgCarrierAddrDfltRprstn as _ExectgCarrierAddrDfltRprstn   : redirected to I_FrtBkgMainBPAddrDfltRprstnTP
      
}
where
  TransportationOrderCategory = 'BO'