I_FrtOrderItem

DDL: I_FRTORDERITEM SQL: ITORFOITM Type: view COMPOSITE
29 Fields 1 Data Sources

Freight Order: Items

I_FrtOrderItem is a Composite CDS View that provides data about "Freight Order: Items" in SAP S/4HANA. It reads from 1 data source (I_TranspOrdItemCargo) and exposes 29 fields with key field TransportationOrderItemUUID.

Data Sources (1)

SourceAliasJoin Type
I_TranspOrdItemCargo item from

Annotations (12)

NameValueLevelField
EndUserText.label Freight Order: Items view
ObjectModel.representativeKey TransportationOrderItemUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ITORFOITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderItemUUID TransportationOrderItemUUID
TransportationOrderUUID TransportationOrderUUID
TranspOrdItemParentItemUUID TranspOrdItemParentItemUUID
TranspOrdItem TranspOrdItem
TranspOrdItemType TranspOrdItemType
IsMainCargoItem IsMainCargoItem
TranspOrdItemGrossWeight TranspOrdItemGrossWeight
TranspOrdItemGrossWeightUnit TranspOrdItemGrossWeightUnit
TranspOrdItemGrossVolume TranspOrdItemGrossVolume
TranspOrdItemGrossVolumeUnit TranspOrdItemGrossVolumeUnit
TranspOrdItemQuantity TranspOrdItemQuantity
TranspOrdItemQuantityUnit TranspOrdItemQuantityUnit
TranspOrdItemWidth TranspOrdItemWidth
TranspOrdItemHeight TranspOrdItemHeight
TranspOrdItemLength TranspOrdItemLength
TranspOrdItemLengthUnit TranspOrdItemLengthUnit
MaterialFreightGroup MaterialFreightGroup Mat.Freight Grp
MaterialFreightGroupName MaterialFreightGroupName
TransportationGroup TransportationGroup Trans. Group
TransportationGroupName TransportationGroupName
ProductID ProductID Product ID
ProductName ProductName Description
TranspOrdItemGoodsValue TranspOrdItemGoodsValue
TranspOrdItemGoodsValueCrcy TranspOrdItemGoodsValueCrcy
TranspOrdDocReferenceType TranspOrdDocReferenceType
FreightUnit
TranspOrdItemDngrsGdsSts TranspOrdItemDngrsGdsSts
_GoodsValCurrency I_TranspOrdItemCargo _GoodsValCurrency
_TranspOrdItemDngrsGdsStatus I_TranspOrdItemCargo _TranspOrdItemDngrsGdsStatus

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_FrtOrderItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ITORFOITM

CREATE VIEW I_FrtOrderItem AS
SELECT
  TransportationOrderItemUUID,
  TransportationOrderUUID,
  TranspOrdItemParentItemUUID,
  TranspOrdItem,
  TranspOrdItemType,
  IsMainCargoItem,
  TranspOrdItemGrossWeight,
  TranspOrdItemGrossWeightUnit,
  TranspOrdItemGrossVolume,
  TranspOrdItemGrossVolumeUnit,
  TranspOrdItemQuantity,
  TranspOrdItemQuantityUnit,
  TranspOrdItemWidth,
  TranspOrdItemHeight,
  TranspOrdItemLength,
  TranspOrdItemLengthUnit,
  MaterialFreightGroup,
  MaterialFreightGroupName,
  TransportationGroup,
  TransportationGroupName,
  ProductID,
  ProductName,
  TranspOrdItemGoodsValue,
  TranspOrdItemGoodsValueCrcy,
  TranspOrdDocReferenceType,
  item._PrdcssrTransportationOrder.TransportationOrder AS FreightUnit,
  TranspOrdItemDngrsGdsSts,
  item._GoodsValCurrency AS _GoodsValCurrency,
  item._TranspOrdItemDngrsGdsStatus AS _TranspOrdItemDngrsGdsStatus
FROM I_TranspOrdItemCargo AS item
;

Learn More