I_FreightOrderStageTP

DDL: I_FREIGHTORDERSTAGETP Type: view_entity TRANSACTIONAL

Freight Order Stage - TP

I_FreightOrderStageTP is a Transactional CDS View that provides data about "Freight Order Stage - TP" in SAP S/4HANA. It reads from 1 data source (R_TransportationOrderStageTP) and exposes 19 fields with key field TransportationOrderStageUUID.

Data Sources (1)

SourceAliasJoin Type
R_TransportationOrderStageTP R_TransportationOrderStageTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Freight Order Stage - TP view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey TransportationOrderStageUUID view
ObjectModel.sapObjectNodeType.name FreightOrderStage view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderStageUUID TransportationOrderStageUUID
TransportationOrderUUID TransportationOrderUUID
TransportationOrderStage TransportationOrderStage
TranspOrdStageType TranspOrdStageType
TranspOrdStageCategory TranspOrdStageCategory
TransportationMode TransportationMode
TransportationModeCategory TransportationModeCategory
TranspOrdStgeInvcgCarrLvl TranspOrdStgeInvcgCarrLvl
CarrierUUID CarrierUUID
Carrier Carrier
TranspOrdStageSCACCode TranspOrdStageSCACCode
TranspOrdStgeInvcgCarrUUID TranspOrdStgeInvcgCarrUUID
TranspOrdStageInvoicingCarrier TranspOrdStageInvoicingCarrier
TranspOrdStgeInvcgSCACCode TranspOrdStgeInvcgSCACCode
TranspOrdStageDistance TranspOrdStageDistance
TranspOrdStageDistanceUnit TranspOrdStageDistanceUnit
TranspOrdStageNetDuration TranspOrdStageNetDuration
TranspOrdStageSrceStopUUID TranspOrdStageSrceStopUUID
TranspOrdStageDestStopUUID TranspOrdStageDestStopUUID
@EndUserText.label: 'Freight Order Stage - TP'
@VDM: {
  lifecycle.contract.type: #PUBLIC_LOCAL_API,
  viewType: #TRANSACTIONAL
}
@ObjectModel: {
   supportedCapabilities: [#TRANSACTIONAL_PROVIDER],
   usageType: {
     sizeCategory:   #L,
     serviceQuality: #C,
     dataClass:      #TRANSACTIONAL
   },
   semanticKey: ['TransportationOrderStage'],
   representativeKey: 'TransportationOrderStageUUID',
   sapObjectNodeType.name: 'FreightOrderStage'
}
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #MANDATORY

define view entity I_FreightOrderStageTP
  as projection on R_TransportationOrderStageTP as FreightOrderStage
{
      // Identification

  key TransportationOrderStageUUID,
      TransportationOrderUUID,
      TransportationOrderStage,

      // Key Characteristics

      TranspOrdStageType,
      TranspOrdStageCategory,
      TransportationMode,
      TransportationModeCategory,

      // Parties

      TranspOrdStgeInvcgCarrLvl,

      CarrierUUID,
      Carrier,
      TranspOrdStageSCACCode,

      TranspOrdStgeInvcgCarrUUID,
      TranspOrdStageInvoicingCarrier,
      TranspOrdStgeInvcgSCACCode,

      // Distance and Duration

      @Semantics.quantity.unitOfMeasure: 'TranspOrdStageDistanceUnit'
      TranspOrdStageDistance,
      TranspOrdStageDistanceUnit,
      TranspOrdStageNetDuration,

      TranspOrdStageSrceStopUUID,
      TranspOrdStageDestStopUUID,

      FreightOrderStage._TranspOrderStop             as _FreightOrderStop            : redirected to parent I_FreightOrderStopTP,
      FreightOrderStage._TransportationOrder         as _FreightOrder                : redirected to I_FreightOrderTP,
      FreightOrderStage._TrOrdStgeBPAddrDfltRprstn   as _FrtOrdStageBPAddrDfltRprstn : redirected to composition child I_FrtOrdStgeBPAddrDfltRprstnTP,
      FreightOrderStage._ExectgCarrierAddrDfltRprstn as _ExectgCarrierAddrDfltRprstn : redirected to I_FrtOrdStgeBPAddrDfltRprstnTP,
      FreightOrderStage._InvcgCarrierAddrDfltRprstn  as _InvcgCarrierAddrDfltRprstn  : redirected to I_FrtOrdStgeBPAddrDfltRprstnTP
}
where
  FreightOrderStage.TransportationOrderCategory = 'TO'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_TRANSPORTATIONORDERSTAGETP"
],
"ASSOCIATED":
[
"I_FREIGHTORDERSTOPTP",
"I_FREIGHTORDERTP",
"I_FRTORDSTGEBPADDRDFLTRPRSTNTP",
"R_TRANSPORTATIONORDERSTOPTP",
"R_TRANSPORTATIONORDERTP",
"R_TRORDSTGEBPADDRDFLTRPRSTNTP"
],
"BASE":
[
"R_TRANSPORTATIONORDERSTAGETP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/