A_FreightOrder

DDL: A_FREIGHTORDER Type: view_entity CONSUMPTION Package: ODATA_TM_FO_API

Freight Order

A_FreightOrder is a Consumption CDS View that provides data about "Freight Order" in SAP S/4HANA. It reads from 1 data source (R_TransportationOrderTP) and exposes 42 fields with key field TransportationOrderUUID. It is exposed through 1 OData service (API_FREIGHTORDER). Part of development package ODATA_TM_FO_API.

Data Sources (1)

SourceAliasJoin Type
R_TransportationOrderTP R_TransportationOrderTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Freight Order view
AccessControl.authorizationCheck #MANDATORY view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
OData.entityType.name FreightOrder_Type view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_FREIGHTORDER API_FREIGHTORDER V4 C2 C1

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'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]
@ObjectModel: {
    usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass: #TRANSACTIONAL
    }}
@VDM.viewType: #CONSUMPTION
@OData.entityType.name: 'FreightOrder_Type'
@Metadata.ignorePropagatedAnnotations: true

define root view entity A_FreightOrder
  provider contract transactional_query
  as projection on R_TransportationOrderTP as FreightOrder

{
      /* Attributes */
      // Identification

  key TransportationOrderUUID,
      TransportationOrder,

      // Key Characteristics

      @ObjectModel.sapObjectNodeTypeReference: 'TransportationOrderType'      
      TransportationOrderType,
      @ObjectModel.sapObjectNodeTypeReference: 'TransportationOrderCategory'      
      TransportationOrderCategory,
      @ObjectModel.sapObjectNodeTypeReference: 'TranspOrderShippingType'      
      TransportationShippingType,
      //MovementType,  // MovementType is currently not used for Freight Orders

      @ObjectModel.sapObjectNodeTypeReference: 'TransportationMode'      
      TransportationMode,
      @ObjectModel.sapObjectNodeTypeReference: 'TransportationModeCategory'      
      TransportationModeCategory,

      // Parties

      CarrierUUID,
      Carrier,
      @ObjectModel.sapObjectNodeTypeReference: 'StandardCarrierAlphaCode'      
      StandardCarrierAlphaCode,
      TranspOrdExecutingCarrierUUID,
      TranspOrdExecutingCarrier,
      ShipperUUID,
      Shipper,
      ShipperAddressID,
      ConsigneeUUID,
      Consignee,
      ConsigneeAddressID,

      TranspPurgOrg,
      TranspPurgOrgExtID,
      TranspPurgGroup,
      TranspPurgGroupExtID,
      PurgOrgCompanyCode,
      //PlngAndExecOrganization,  // Planning and Execution Organization and Group is currently not used in Freight Orders

      //PlngAndExecGroup,

      CarrierAccountNumber,

      // Further Attributes

      @ObjectModel.sapObjectNodeTypeReference: 'TransportationMeansOfTransport'      
      TranspMeansOfTransport,
      TranspOrdPartnerReference,
      //MasterBillOfLading,  // Master Bill of Lading is currently not used in Freight Orders

      TranspOrdResponsiblePerson,
      TranspOrdHasMltplExectgPties,
      @ObjectModel.sapObjectNodeTypeReference: 'TranspOrdInvoicingCarrierLevel'      
      TranspOrdInvoicingCarrierLevel,

      // Status

      @ObjectModel.sapObjectNodeTypeReference: 'TranspOrderLifecycleStatus'
      TranspOrdLifeCycleStatus,
      @ObjectModel.sapObjectNodeTypeReference: 'TranspOrdSubcontractingStatus'       
      TranspOrderSubcontrgSts,
      @ObjectModel.sapObjectNodeTypeReference: 'TranspOrderConfirmationStatus'       
      TransportationOrderConfSts,
      @ObjectModel.sapObjectNodeTypeReference: 'TranspOrderExecutionStatus'      
      TransportationOrderExecSts,
      @ObjectModel.sapObjectNodeTypeReference: 'TranspOrdGoodsMovementStatus'       
      TranspOrdGoodsMovementStatus,
      @ObjectModel.sapObjectNodeTypeReference: 'TranspOrdWhseProcessingStatus'      
      TranspOrdWhseProcessingStatus,
      @ObjectModel.sapObjectNodeTypeReference: 'TranspOrdDangerousGoodsStatus'      
      TranspOrderDngrsGdsSts,
      //TranspOrdPlanningBlock,  // Planning Block is currently not used in Freight Orders

      @Semantics.booleanIndicator: true
      TranspOrdExecutionIsBlocked,

      // Administrative Data

      @ObjectModel.sapObjectNodeTypeReference: 'TranspOrderCreationType'
      TransportationOrderCrtnType,
      CreatedByUser,
      CreationDateTime,
      LastChangedByUser,
      ChangedDateTime,

      /* Redirections */
      FreightOrder._TransportationOrderBP       as _FreightOrderBusinessPartner   : redirected to composition child A_FreightOrderBusinessPartner,
      FreightOrder._TranspOrdDocumentReference  as _FreightOrderDocumentReference : redirected to composition child A_FreightOrderDocRef,
      FreightOrder._TransportationOrderItem     as _FreightOrderItem              : redirected to composition child A_FreightOrderItem,
      FreightOrder._TransportationOrderStop     as _FreightOrderStop              : redirected to composition child A_FreightOrderStop,
      FreightOrder._TransportationOrderEvent    as _FreightOrderEvent             : redirected to composition child A_FreightOrderEvent,
      FreightOrder._TransportationOrderCharge   as _FreightOrderCharge            : redirected to composition child A_FreightOrderCharge,
      FreightOrder._TrOrdMainBPAddrDfltRprstn   as _FrtOrdMainBPAddrDfltRprstn    : redirected to composition child A_FrtOrdMainBPAddrDfltRprstn,

      /* Association redirections */
      FreightOrder._CarrierAddrDfltRprstn       as _CarrierAddrDfltRprstn         : redirected to A_FrtOrdMainBPAddrDfltRprstn,
      FreightOrder._ShipperAddrDfltRprstn       as _ShipperAddrDfltRprstn         : redirected to A_FrtOrdMainBPAddrDfltRprstn,
      FreightOrder._ConsigneeAddrDfltRprstn     as _ConsigneeAddrDfltRprstn       : redirected to A_FrtOrdMainBPAddrDfltRprstn,
      FreightOrder._ExectgCarrierAddrDfltRprstn as _ExectgCarrierAddrDfltRprstn   : redirected to A_FrtOrdMainBPAddrDfltRprstn
}
where
  TransportationOrderCategory = 'TO'