A_FreightBookingItem

DDL: A_FREIGHTBOOKINGITEM Type: view_entity CONSUMPTION Package: ODATA_TM_FB_API

Freight Booking Item

A_FreightBookingItem is a Consumption CDS View that provides data about "Freight Booking Item" in SAP S/4HANA. It reads from 1 data source (R_TransportationOrderItemTP) and exposes 53 fields with key field TransportationOrderItemUUID. It is exposed through 1 OData service (API_FREIGHTBOOKING). Part of development package ODATA_TM_FB_API.

Data Sources (1)

SourceAliasJoin Type
R_TransportationOrderItemTP R_TransportationOrderItemTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Freight Booking Item 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 FreightBookingItem_Type view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_FREIGHTBOOKING API_FREIGHTBOOKING V4 C2 C1

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderItemUUID TransportationOrderItemUUID
TransportationOrderUUID TransportationOrderUUID
TranspOrdItem TranspOrdItem
TranspOrdItemType TranspOrdItemType
TranspOrdItemCategory TranspOrdItemCategory
TranspOrdItemParentItemUUID TranspOrdItemParentItemUUID
TranspOrdItemDesc TranspOrdItemDesc
IsMainCargoItem IsMainCargoItem
TranspOrdItemSorting TranspOrdItemSorting
SourceStopUUID SourceStopUUID
DestinationStopUUID DestinationStopUUID
ShipperUUID ShipperUUID
Shipper Shipper
ShipperAddressID ShipperAddressID
ConsigneeUUID ConsigneeUUID
Consignee Consignee
ConsigneeAddressID ConsigneeAddressID
FreightUnitUUID FreightUnitUUID
PredecessorTransportationOrder PredecessorTransportationOrder
TranspBaseDocument TranspBaseDocument
TranspBaseDocumentType TranspBaseDocumentType
TranspBaseDocumentItem TranspBaseDocumentItem
TranspBaseDocumentItemType TranspBaseDocumentItemType
TransportationEquipmentGroup TransportationEquipmentGroup
TransportationEquipmentType TransportationEquipmentType
TranspEquipmentIsShipperOwned TranspEquipmentIsShipperOwned
TranspEquipmentPlateNumber TranspEquipmentPlateNumber
TranspEquipRegistrationCountry TranspEquipRegistrationCountry
TranspEquipCapacityLength TranspEquipCapacityLength
TranspEquipCapacityWidth TranspEquipCapacityWidth
TranspEquipCapacityHeight TranspEquipCapacityHeight
TranspEquipCapacityUnit TranspEquipCapacityUnit
TranspEquipCapacityWeight TranspEquipCapacityWeight
TranspEquipCapacityWeightUnit TranspEquipCapacityWeightUnit
TranspEquipCapacityVolume TranspEquipCapacityVolume
TranspEquipCapacityVolumeUnit TranspEquipCapacityVolumeUnit
TranspOrdItemPackageID TranspOrdItemPackageID
ProductUUID ProductUUID
ProductID ProductID
MaterialFreightGroup MaterialFreightGroup
TransportationGroup TransportationGroup
TranspOrdItmMinTemp TranspOrdItmMinTemp
TranspOrdItmMaxTemp TranspOrdItmMaxTemp
TranspOrdItemTemperatureUnit TranspOrdItemTemperatureUnit
TranspOrdItemQuantity TranspOrdItemQuantity
TranspOrdItemQuantityUnit TranspOrdItemQuantityUnit
TranspOrdItemGrossWeight TranspOrdItemGrossWeight
TranspOrdItemGrossWeightUnit TranspOrdItemGrossWeightUnit
TranspOrdItemGrossVolume TranspOrdItemGrossVolume
TranspOrdItemGrossVolumeUnit TranspOrdItemGrossVolumeUnit
TranspOrdItemNetWeight TranspOrdItemNetWeight
TranspOrdItemNetWeightUnit TranspOrdItemNetWeightUnit
TranspOrdItemDngrsGdsSts TranspOrdItemDngrsGdsSts
@EndUserText.label: 'Freight Booking Item'
@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: 'FreightBookingItem_Type'
@Metadata.ignorePropagatedAnnotations: true

define view entity A_FreightBookingItem
  as projection on R_TransportationOrderItemTP as FreightBookingItem
{
      /* Attributes */
      // Identification

  key TransportationOrderItemUUID,
      TransportationOrderUUID,
      TranspOrdItem,
      @ObjectModel.sapObjectNodeTypeReference: 'TransportationOrderItemType'
      TranspOrdItemType,
      @ObjectModel.sapObjectNodeTypeReference: 'TranspOrderItemCategory'
      TranspOrdItemCategory,

      TranspOrdItemParentItemUUID,
      TranspOrdItemDesc,
      @Semantics.booleanIndicator
      IsMainCargoItem,
      //TransportationMode,  // Transportation Mode is currently not used in Freight Booking Items

      //TransportationModeCategory,

      //TranspMeansOfTransport,  // Means of Transport is currently not used in Freight Booking Items

      TranspOrdItemSorting,

      // Locations

      SourceStopUUID,
      DestinationStopUUID,

      // Parties

      ShipperUUID,
      Shipper,
      ShipperAddressID,
      ConsigneeUUID,
      Consignee,
      ConsigneeAddressID,

      // Document References

      FreightUnitUUID,
      PredecessorTransportationOrder,
      TranspBaseDocument,
      @ObjectModel.sapObjectNodeTypeReference: 'TranspBizTransacDocTypeCode'
      TranspBaseDocumentType,
      TranspBaseDocumentItem,
      @ObjectModel.sapObjectNodeTypeReference: 'TranspBizTransacDocItmTypeCode'
      TranspBaseDocumentItemType,

      // Equipment Attributes

      TransportationEquipmentGroup,
      TransportationEquipmentType,
      TranspEquipmentIsShipperOwned,
      TranspEquipmentPlateNumber,
      TranspEquipRegistrationCountry,
      @Semantics.quantity.unitOfMeasure: 'TranspEquipCapacityUnit'
      TranspEquipCapacityLength,
      @Semantics.quantity.unitOfMeasure: 'TranspEquipCapacityUnit'
      TranspEquipCapacityWidth,
      @Semantics.quantity.unitOfMeasure: 'TranspEquipCapacityUnit'
      TranspEquipCapacityHeight,
      @ObjectModel.sapObjectNodeTypeReference: 'UnitOfMeasure'
      TranspEquipCapacityUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspEquipCapacityWeightUnit'
      TranspEquipCapacityWeight,
      @ObjectModel.sapObjectNodeTypeReference: 'UnitOfMeasure'
      TranspEquipCapacityWeightUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspEquipCapacityVolumeUnit'
      TranspEquipCapacityVolume,
      @ObjectModel.sapObjectNodeTypeReference: 'UnitOfMeasure'
      TranspEquipCapacityVolumeUnit,

      // Package Attributes

      TranspOrdItemPackageID,

      // Product Attributes

      ProductUUID,
      ProductID,
      MaterialFreightGroup,
      TransportationGroup,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemTemperatureUnit'
      TranspOrdItmMinTemp,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemTemperatureUnit'
      TranspOrdItmMaxTemp,
      @ObjectModel.sapObjectNodeTypeReference: 'UnitOfMeasure'
      TranspOrdItemTemperatureUnit,

      // Quantities

      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemQuantityUnit'
      TranspOrdItemQuantity,
      @ObjectModel.sapObjectNodeTypeReference: 'UnitOfMeasure'
      TranspOrdItemQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemGrossWeightUnit'
      TranspOrdItemGrossWeight,
      @ObjectModel.sapObjectNodeTypeReference: 'UnitOfMeasure'
      TranspOrdItemGrossWeightUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemGrossVolumeUnit'
      TranspOrdItemGrossVolume,
      @ObjectModel.sapObjectNodeTypeReference: 'UnitOfMeasure'
      TranspOrdItemGrossVolumeUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemNetWeightUnit'
      TranspOrdItemNetWeight,
      TranspOrdItemNetWeightUnit,

      // Status

      @ObjectModel.sapObjectNodeTypeReference: 'TranspOrdDangerousGoodsStatus'
      TranspOrdItemDngrsGdsSts,

      /* Redirections */
      FreightBookingItem._TransportationOrder        as _FreightBooking                : redirected to parent A_FreightBooking,
      FreightBookingItem._TranspOrdItemDocRef        as _FreightBookingItemDocRef      : redirected to composition child A_FreightBookingItemDocRef,
      FreightBookingItem._TranspOrdItemSeal          as _FreightBookingItemSeal        : redirected to composition child A_FreightBookingItemSeal,
      FreightBookingItem._TranspOrdItemCommodityCode as _FrtBookingItemCommodityCode   : redirected to composition child A_FrtBookingItemCommodityCode,
      FreightBookingItem._TranspOrdItemSerialNumber  as _FrtBookingItemSerialNumber    : redirected to composition child A_FrtBookingItemSerialNumber,
      @Semantics.valueRange.maximum: '1'
      FreightBookingItem._TranspOrdItemBatch         as _FreightBookingItemBatch       : redirected to composition child A_FreightBookingItemBatch,
      FreightBookingItem._TrOrdItmMnBPAddrDfltRprstn as _FrtBkgItmMainBPAddrDfltRprstn : redirected to composition child A_FrtBkgItmMnBPAddrDfltRprstn,
      FreightBookingItem._ShipperAddrDfltRprstn      as _ShipperAddrDfltRprstn         : redirected to A_FrtBkgItmMnBPAddrDfltRprstn,
      FreightBookingItem._ConsigneeAddrDfltRprstn    as _ConsigneeAddrDfltRprstn       : redirected to A_FrtBkgItmMnBPAddrDfltRprstn
}
where
  FreightBookingItem.TransportationOrderCategory = 'BO'