C_CollabnApplTranspOrderItem

DDL: C_COLLABNAPPLTRANSPORDERITEM SQL: CCOLLABNAPPLITEM Type: view CONSUMPTION

Transportation Order Item

C_CollabnApplTranspOrderItem is a Consumption CDS View that provides data about "Transportation Order Item" in SAP S/4HANA. It reads from 2 data sources (P_CollabnApplCarrierUser, I_TransportationOrderItem) and exposes 20 fields with key field TransportationOrderItemUUID. It has 1 association to related views.

2 data source(s) 20 fields

Data Sources (2)

SourceAliasJoin Type
P_CollabnApplCarrierUser CollabnApplCarrierUser inner
I_TransportationOrderItem TransportationOrderItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_CollabnApplTranspOrderStop _CollabnApplTranspOrderStop $projection.SourceStopUUID = _CollabnApplTranspOrderStop.TransportationOrderStopUUID

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CCOLLABNAPPLITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey TransportationOrderItemUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Transportation Order Item view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderItemUUID I_TransportationOrderItem TransportationOrderItemUUID
SourceStopUUID I_TransportationOrderItem SourceStopUUID
DestinationStopUUID I_TransportationOrderItem DestinationStopUUID
TranspOrdItem I_TransportationOrderItem TranspOrdItem
TranspOrdItemDesc I_TransportationOrderItem TranspOrdItemDesc
TranspOrdItemType I_TransportationOrderItem TranspOrdItemType
TranspOrdItemTypeDesc
TranspOrdItemGrossWeightUnit I_TransportationOrderItem TranspOrdItemGrossWeightUnit
TranspOrdItemGrossWeight
TranspOrdItemGrossVolumeUnit I_TransportationOrderItem TranspOrdItemGrossVolumeUnit
TranspOrdItemGrossVolume
TranspOrdItemQuantityUnit I_TransportationOrderItem TranspOrdItemQuantityUnit
TranspOrdItemQuantity
TranspOrdItemLengthUnit I_TransportationOrderItem TranspOrdItemLengthUnit
TranspOrdItemLength I_TransportationOrderItem TranspOrdItemLength
TranspOrdItemWidth I_TransportationOrderItem TranspOrdItemWidth
TranspOrdItemHeight I_TransportationOrderItem TranspOrdItemHeight
TranspOrdItemDngrsGdsSts I_TransportationOrderItem TranspOrdItemDngrsGdsSts
TranspOrdItemDngrsGdsStsDesc
_CollabnApplTranspOrderStop _CollabnApplTranspOrderStop 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CCOLLABNAPPLITEM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@VDM.viewType: #CONSUMPTION

@ObjectModel.representativeKey: 'TransportationOrderItemUUID'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Transportation Order Item'
define view C_CollabnApplTranspOrderItem
  as select from I_TransportationOrderItem as TransportationOrderItem
    inner join   P_CollabnApplCarrierUser  as CollabnApplCarrierUser on CollabnApplCarrierUser.UserID = $session.user
  association [1..1] to C_CollabnApplTranspOrderStop as _CollabnApplTranspOrderStop on $projection.SourceStopUUID = _CollabnApplTranspOrderStop.TransportationOrderStopUUID
{
  key TransportationOrderItem.TransportationOrderItemUUID,
      TransportationOrderItem.SourceStopUUID,
      TransportationOrderItem.DestinationStopUUID,
      @ObjectModel.text.element: ['TranspOrdItemDesc']
      TransportationOrderItem.TranspOrdItem,
      @Semantics.text: true
      TransportationOrderItem.TranspOrdItemDesc,

      @ObjectModel.text.element: ['TranspOrdItemTypeDesc']
      TransportationOrderItem.TranspOrdItemType,
      @Semantics.text: true
      TransportationOrderItem._TranspOrdItemType._Text[1: Language = $session.system_language ].TranspOrdItemTypeDesc,

      @Semantics.unitOfMeasure: true
      TransportationOrderItem.TranspOrdItemGrossWeightUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemGrossWeightUnit'
      cast( TransportationOrderItem.TranspOrdItemGrossWeight as /scmtms/vdm_itm_grswt_val)                                            as TranspOrdItemGrossWeight,

      @Semantics.unitOfMeasure: true
      TransportationOrderItem.TranspOrdItemGrossVolumeUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemGrossVolumeUnit'
      cast(TransportationOrderItem.TranspOrdItemGrossVolume as /scmtms/vdm_itm_grsvol_val)                                            as TranspOrdItemGrossVolume,

      @Semantics.unitOfMeasure: true
      TransportationOrderItem.TranspOrdItemQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemQuantityUnit'
      cast(TransportationOrderItem.TranspOrdItemQuantity as /scmtms/vdm_itm_qty )                                                     as TranspOrdItemQuantity,

      @Semantics.unitOfMeasure: true
      TransportationOrderItem.TranspOrdItemLengthUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemLengthUnit'
      TransportationOrderItem.TranspOrdItemLength,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemLengthUnit'
      TransportationOrderItem.TranspOrdItemWidth,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdItemLengthUnit'
      TransportationOrderItem.TranspOrdItemHeight,
      @ObjectModel.text.element: ['TranspOrdItemDngrsGdsStsDesc']
      TransportationOrderItem.TranspOrdItemDngrsGdsSts,
      @Semantics.text: true
      TransportationOrderItem._TranspOrdItemDngrsGdsStatus._Text[1: Language = $session.system_language].TranspOrdItemDngrsGdsStsDesc as TranspOrdItemDngrsGdsStsDesc,

      //      @ObjectModel.text.element: ['ProductName']

      //      TransportationOrderItem.ProductID,

      //      @Semantics.text: true

      //      TransportationOrderItem.ProductName


      _CollabnApplTranspOrderStop

}
where
      TransportationOrderItem.IsMainCargoItem       = 'X'
  and CollabnApplCarrierUser.BusinessPartnerCompany = _CollabnApplTranspOrderStop.Carrier
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_COLLABNAPPLTRANSPORDERSTOP",
"I_TRANSPORDITEMDNGRSGDSSTATUS",
"I_TRANSPORDITEMDNGRSGDSSTSTEXT",
"I_TRANSPORDITEMTYPE",
"I_TRANSPORDITEMTYPETEXT",
"I_TRANSPORTATIONORDERITEM",
"P_COLLABNAPPLCARRIERUSER"
],
"ASSOCIATED":
[
"C_COLLABNAPPLTRANSPORDERSTOP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More