R_TransportationOrderItemTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_TransportationOrderItem_2 | TransportationOrderItem | from |
Associations (10)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA