R_TransportationOrderItemTP

DDL: R_TRANSPORTATIONORDERITEMTP Type: view_entity TRANSACTIONAL Package: RAP_TM_TOR

Transportation Order Item - TP

R_TransportationOrderItemTP is a Transactional CDS View that provides data about "Transportation Order Item - TP" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrderItem_2) and exposes 79 fields with key field TransportationOrderItemUUID. It has 10 associations to related views. Part of development package RAP_TM_TOR.

Data Sources (1)

SourceAliasJoin Type
I_TransportationOrderItem_2 TransportationOrderItem from

Associations (10)

CardinalityTargetAliasCondition
[0..1] R_TrOrdItmMnBPAddrDfltRprstnTP _ShipperAddrDfltRprstn $projection.TransportationOrderItemUUID = _ShipperAddrDfltRprstn.TransportationOrderItemUUID and _ShipperAddrDfltRprstn.TranspOrdBizPartnerFunction = 'U6'
[0..1] R_TrOrdItmMnBPAddrDfltRprstnTP _ConsigneeAddrDfltRprstn $projection.TransportationOrderItemUUID = _ConsigneeAddrDfltRprstn.TransportationOrderItemUUID and _ConsigneeAddrDfltRprstn.TranspOrdBizPartnerFunction = 'WE'
[1] E_TransportationOrderItem _Extension $projection.TransportationOrderItemUUID = _Extension.TransportationOrderItemUUID
[0..*] R_TranspOrdItemSealTP _TranspOrdItemSeal
[0..*] R_TranspOrdItemBatchTP _TranspOrdItemBatch
[0..*] R_TranspOrdItemDocRefTP _TranspOrdItemDocRef
[0..*] R_TranspOrdItemCommodityCodeTP _TranspOrdItemCommodityCode
[0..*] R_TrOrdItmMnBPAddrDfltRprstnTP _TrOrdItmMnBPAddrDfltRprstn
[0..*] R_TranspOrdItemNoteTP _TranspOrdItemNote
[0..*] R_TranspOrdItemSerialNumberTP _TranspOrdItemSerialNumber

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Transportation Order Item - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey TransportationOrderItemUUID view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix TOI view
AbapCatalog.extensibility.quota.maximumFields 408 view
AbapCatalog.extensibility.quota.maximumBytes 8160 view

Fields (79)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderItemUUID I_TransportationOrderItem_2 TransportationOrderItemUUID
TransportationOrderUUID I_TransportationOrderItem_2 TransportationOrderUUID
TranspOrdItem I_TransportationOrderItem_2 TranspOrdItem
TranspOrdItemType I_TransportationOrderItem_2 TranspOrdItemType
TranspOrdItemCategory I_TransportationOrderItem_2 TranspOrdItemCategory
TranspOrdItemParentItemUUID I_TransportationOrderItem_2 TranspOrdItemParentItemUUID
TranspOrdItemDesc I_TransportationOrderItem_2 TranspOrdItemDesc
IsMainCargoItem I_TransportationOrderItem_2 IsMainCargoItem
TranspOrdItemSorting I_TransportationOrderItem_2 TranspOrdItemSorting
SourceStopUUID I_TransportationOrderItem_2 SourceStopUUID
DestinationStopUUID I_TransportationOrderItem_2 DestinationStopUUID
ShipperUUID I_TransportationOrderItem_2 ShipperUUID
Shipper I_TransportationOrderItem_2 Shipper
ShipperAddressID I_TransportationOrderItem_2 ShipperAddressID
ConsigneeUUID I_TransportationOrderItem_2 ConsigneeUUID
Consignee I_TransportationOrderItem_2 Consignee
ConsigneeAddressID I_TransportationOrderItem_2 ConsigneeAddressID
FreightUnitUUID I_TransportationOrderItem_2 FreightUnitUUID
PredecessorTransportationOrder I_TransportationOrderItem_2 PredecessorTransportationOrder
TranspBaseDocument I_TransportationOrderItem_2 TranspBaseDocument
TranspBaseDocumentType I_TransportationOrderItem_2 TranspBaseDocumentType
TranspBaseDocumentItem I_TransportationOrderItem_2 TranspBaseDocumentItem
TranspBaseDocumentItemType I_TransportationOrderItem_2 TranspBaseDocumentItemType
TransportationEquipmentGroup I_TransportationOrderItem_2 TransportationEquipmentGroup
TransportationEquipmentType I_TransportationOrderItem_2 TransportationEquipmentType
TranspEquipmentIsShipperOwned I_TransportationOrderItem_2 TranspEquipmentIsShipperOwned
TranspEquipmentPlateNumber I_TransportationOrderItem_2 TranspEquipmentPlateNumber
TranspEquipRegistrationCountry I_TransportationOrderItem_2 TranspEquipRegistrationCountry
TranspEquipCapacityLength I_TransportationOrderItem_2 TranspEquipCapacityLength
TranspEquipCapacityWidth I_TransportationOrderItem_2 TranspEquipCapacityWidth
TranspEquipCapacityHeight I_TransportationOrderItem_2 TranspEquipCapacityHeight
TranspEquipCapacityUnit I_TransportationOrderItem_2 TranspEquipCapacityUnit
TranspEquipCapacityWeight I_TransportationOrderItem_2 TranspEquipCapacityWeight
TranspEquipCapacityWeightUnit I_TransportationOrderItem_2 TranspEquipCapacityWeightUnit
TranspEquipCapacityVolume I_TransportationOrderItem_2 TranspEquipCapacityVolume
TranspEquipCapacityVolumeUnit I_TransportationOrderItem_2 TranspEquipCapacityVolumeUnit
TranspOrdItemPackageID I_TransportationOrderItem_2 TranspOrdItemPackageID
ProductUUID I_TransportationOrderItem_2 ProductUUID
ProductID I_TransportationOrderItem_2 ProductID
MaterialFreightGroup I_TransportationOrderItem_2 MaterialFreightGroup
TransportationGroup I_TransportationOrderItem_2 TransportationGroup
TranspOrdItmMinTemp I_TransportationOrderItem_2 TranspOrdItmMinTemp
TranspOrdItmMaxTemp I_TransportationOrderItem_2 TranspOrdItmMaxTemp
TranspOrdItemTemperatureUnit I_TransportationOrderItem_2 TranspOrdItemTemperatureUnit
TranspOrdItemQuantity I_TransportationOrderItem_2 TranspOrdItemQuantity
TranspOrdItemQuantityUnit I_TransportationOrderItem_2 TranspOrdItemQuantityUnit
TranspOrdItemGrossWeight I_TransportationOrderItem_2 TranspOrdItemGrossWeight
TranspOrdItemGrossWeightUnit I_TransportationOrderItem_2 TranspOrdItemGrossWeightUnit
TranspOrdItemGrossVolume I_TransportationOrderItem_2 TranspOrdItemGrossVolume
TranspOrdItemGrossVolumeUnit I_TransportationOrderItem_2 TranspOrdItemGrossVolumeUnit
TranspOrdItemNetWeight I_TransportationOrderItem_2 TranspOrdItemNetWeight
TranspOrdItemNetWeightUnit I_TransportationOrderItem_2 TranspOrdItemNetWeightUnit
TranspOrdItemDngrsGdsSts I_TransportationOrderItem_2 TranspOrdItemDngrsGdsSts
TransportationOrderCategory _TransportationOrder TransportationOrderCategory
_BusTransDocTypeCode I_TransportationOrderItem_2 _BusTransDocTypeCode
_Consignee I_TransportationOrderItem_2 _Consignee
_DestinationStop I_TransportationOrderItem_2 _DestinationStop
_PrdcssrTransportationOrder I_TransportationOrderItem_2 _PrdcssrTransportationOrder
_Product I_TransportationOrderItem_2 _Product
_Shipper I_TransportationOrderItem_2 _Shipper
_SourceStop I_TransportationOrderItem_2 _SourceStop
_TranspOrdItemCategory I_TransportationOrderItem_2 _TranspOrdItemCategory
_TranspOrdItemGrossVolumeUnit I_TransportationOrderItem_2 _TranspOrdItemGrossVolumeUnit
_TranspOrdItemGrossWeightUnit I_TransportationOrderItem_2 _TranspOrdItemGrossWeightUnit
_TranspOrdItemNetWeightUnit I_TransportationOrderItem_2 _TranspOrdItemNetWeightUnit
_TranspOrdItemParentItem I_TransportationOrderItem_2 _TranspOrdItemParentItem
_TranspOrdItemQuantityUnit I_TransportationOrderItem_2 _TranspOrdItemQuantityUnit
_TranspOrdItemType I_TransportationOrderItem_2 _TranspOrdItemType
_TransportationGroup I_TransportationOrderItem_2 _TransportationGroup
_TransportationOrder _TransportationOrder
_TranspOrdItemSeal _TranspOrdItemSeal
_TranspOrdItemSerialNumber _TranspOrdItemSerialNumber
_TranspOrdItemBatch _TranspOrdItemBatch
_TranspOrdItemDocRef _TranspOrdItemDocRef
_TranspOrdItemCommodityCode _TranspOrdItemCommodityCode
_TrOrdItmMnBPAddrDfltRprstn _TrOrdItmMnBPAddrDfltRprstn
_ShipperAddrDfltRprstn _ShipperAddrDfltRprstn
_ConsigneeAddrDfltRprstn _ConsigneeAddrDfltRprstn
_TranspOrdItemNote _TranspOrdItemNote
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl: {
  authorizationCheck: #MANDATORY,
  privilegedAssociations: [
    '_TranspOrdItemParentItem',
    '_SourceStop',
    '_DestinationStop'
  ]
}
@EndUserText.label: 'Transportation Order Item - TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
    usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass:#TRANSACTIONAL
    },
    semanticKey: ['TranspOrdItem'],
    representativeKey: 'TransportationOrderItemUUID'
}

@AbapCatalog.extensibility: {
  extensible: true,
  dataSources: ['_Extension'],
  elementSuffix: 'TOI',
  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_TransportationOrderItemTP
  as select from I_TransportationOrderItem_2 as TransportationOrderItem

  composition [0..*] of R_TranspOrdItemSealTP          as _TranspOrdItemSeal
  composition [0..*] of R_TranspOrdItemBatchTP         as _TranspOrdItemBatch
  composition [0..*] of R_TranspOrdItemDocRefTP        as _TranspOrdItemDocRef
  composition [0..*] of R_TranspOrdItemCommodityCodeTP as _TranspOrdItemCommodityCode
  composition [0..*] of R_TrOrdItmMnBPAddrDfltRprstnTP as _TrOrdItmMnBPAddrDfltRprstn
  composition [0..*] of R_TranspOrdItemNoteTP          as _TranspOrdItemNote
  composition [0..*] of R_TranspOrdItemSerialNumberTP  as _TranspOrdItemSerialNumber

  association to parent R_TransportationOrderTP        as _TransportationOrder        on  $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
  association [0..1] to R_TrOrdItmMnBPAddrDfltRprstnTP as _ShipperAddrDfltRprstn      on  $projection.TransportationOrderItemUUID            = _ShipperAddrDfltRprstn.TransportationOrderItemUUID
                                                                                      and _ShipperAddrDfltRprstn.TranspOrdBizPartnerFunction = 'U6'
  association [0..1] to R_TrOrdItmMnBPAddrDfltRprstnTP as _ConsigneeAddrDfltRprstn    on  $projection.TransportationOrderItemUUID              = _ConsigneeAddrDfltRprstn.TransportationOrderItemUUID
                                                                                      and _ConsigneeAddrDfltRprstn.TranspOrdBizPartnerFunction = 'WE'
  //Extension Association

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

  key TransportationOrderItem.TransportationOrderItemUUID,
      TransportationOrderItem.TransportationOrderUUID,
      TransportationOrderItem.TranspOrdItem,
      TransportationOrderItem.TranspOrdItemType,
      TransportationOrderItem.TranspOrdItemCategory,

      TransportationOrderItem.TranspOrdItemParentItemUUID,
      TransportationOrderItem.TranspOrdItemDesc,
      @Semantics.booleanIndicator
      TransportationOrderItem.IsMainCargoItem,
      TransportationOrderItem.TranspOrdItemSorting,

      // Locations

      TransportationOrderItem.SourceStopUUID,
      TransportationOrderItem.DestinationStopUUID,

      // Parties

      TransportationOrderItem.ShipperUUID,
      TransportationOrderItem.Shipper,
      TransportationOrderItem.ShipperAddressID,
      TransportationOrderItem.ConsigneeUUID,
      TransportationOrderItem.Consignee,
      TransportationOrderItem.ConsigneeAddressID,

      // Document References

      TransportationOrderItem.FreightUnitUUID,
      TransportationOrderItem.PredecessorTransportationOrder,
      TransportationOrderItem.TranspBaseDocument,
      TransportationOrderItem.TranspBaseDocumentType,
      TransportationOrderItem.TranspBaseDocumentItem,
      TransportationOrderItem.TranspBaseDocumentItemType,

      // Equipment Attributes

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

      // Package Attributes

      TransportationOrderItem.TranspOrdItemPackageID,

      // Product Attributes

      TransportationOrderItem.ProductUUID,
      TransportationOrderItem.ProductID,
      TransportationOrderItem.MaterialFreightGroup,
      TransportationOrderItem.TransportationGroup,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemTemperatureUnit'
      TransportationOrderItem.TranspOrdItmMinTemp,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemTemperatureUnit'
      TransportationOrderItem.TranspOrdItmMaxTemp,
      TransportationOrderItem.TranspOrdItemTemperatureUnit,

      // Quantities

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

      // Status

      TransportationOrderItem.TranspOrdItemDngrsGdsSts,

      // (Technical/Hidden) Attributes

      _TransportationOrder.TransportationOrderCategory,

      /* Associations */
      TransportationOrderItem._BusTransDocTypeCode,
      TransportationOrderItem._Consignee,
      TransportationOrderItem._DestinationStop,
      TransportationOrderItem._PrdcssrTransportationOrder,
      TransportationOrderItem._Product,
      TransportationOrderItem._Shipper,
      TransportationOrderItem._SourceStop,
      TransportationOrderItem._TranspOrdItemCategory,
      TransportationOrderItem._TranspOrdItemGrossVolumeUnit,
      TransportationOrderItem._TranspOrdItemGrossWeightUnit,
      TransportationOrderItem._TranspOrdItemNetWeightUnit,
      TransportationOrderItem._TranspOrdItemParentItem,
      TransportationOrderItem._TranspOrdItemQuantityUnit,
      TransportationOrderItem._TranspOrdItemType,
      TransportationOrderItem._TransportationGroup,
      _TransportationOrder,
      _TranspOrdItemSeal,
      _TranspOrdItemSerialNumber,
      @Semantics.valueRange.maximum: '1'
      _TranspOrdItemBatch,
      _TranspOrdItemDocRef,
      _TranspOrdItemCommodityCode,
      _TrOrdItmMnBPAddrDfltRprstn,
      _ShipperAddrDfltRprstn,
      _ConsigneeAddrDfltRprstn,
      _TranspOrdItemNote
}