A_FreightOrderStage

DDL: A_FREIGHTORDERSTAGE Type: view_entity CONSUMPTION

Freight Order Stage

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

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
R_TransportationOrderStageTP R_TransportationOrderStageTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Freight Order Stage view
AccessControl.authorizationCheck #MANDATORY view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
OData.entityType.name FreightOrderStage_Type view
Metadata.ignorePropagatedAnnotations true 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'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]
@ObjectModel: {
    usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass: #TRANSACTIONAL
    }}
@VDM.viewType: #CONSUMPTION
@OData.entityType.name: 'FreightOrderStage_Type'
@Metadata.ignorePropagatedAnnotations: true

define view entity A_FreightOrderStage
  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 A_FreightOrderStop,
      FreightOrderStage._TransportationOrder         as _FreightOrder                : redirected to A_FreightOrder,
      FreightOrderStage._TrOrdStgeBPAddrDfltRprstn   as _FrtOrdStageBPAddrDfltRprstn : redirected to composition child A_FrtOrdStgeBPAddrDfltRprstn,
      FreightOrderStage._ExectgCarrierAddrDfltRprstn as _ExectgCarrierAddrDfltRprstn : redirected to A_FrtOrdStgeBPAddrDfltRprstn,
      FreightOrderStage._InvcgCarrierAddrDfltRprstn  as _InvcgCarrierAddrDfltRprstn  : redirected to A_FrtOrdStgeBPAddrDfltRprstn

}
where
  FreightOrderStage.TransportationOrderCategory = 'TO'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_TRANSPORTATIONORDERSTAGETP"
],
"ASSOCIATED":
[
"A_FREIGHTORDER",
"A_FREIGHTORDERSTOP",
"A_FRTORDSTGEBPADDRDFLTRPRSTN",
"R_TRANSPORTATIONORDERSTOPTP",
"R_TRANSPORTATIONORDERTP",
"R_TRORDSTGEBPADDRDFLTRPRSTNTP"
],
"BASE":
[
"R_TRANSPORTATIONORDERSTAGETP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More