@EndUserText.label: 'Freight Order'
@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: 'FreightOrder_Type'
@Metadata.ignorePropagatedAnnotations: true
define root view entity A_FreightOrder
provider contract transactional_query
as projection on R_TransportationOrderTP as FreightOrder
{
/* Attributes */
// Identification
key TransportationOrderUUID,
TransportationOrder,
// Key Characteristics
TransportationOrderType,
TransportationOrderCategory,
TransportationShippingType,
//MovementType, // MovementType is currently not used for Freight Orders
TransportationMode,
TransportationModeCategory,
// Parties
CarrierUUID,
Carrier,
StandardCarrierAlphaCode,
TranspOrdExecutingCarrierUUID,
TranspOrdExecutingCarrier,
ShipperUUID,
Shipper,
ShipperAddressID,
ConsigneeUUID,
Consignee,
ConsigneeAddressID,
TranspPurgOrg,
TranspPurgOrgExtID,
TranspPurgGroup,
TranspPurgGroupExtID,
PurgOrgCompanyCode,
//PlngAndExecOrganization, // Planning and Execution Organization and Group is currently not used in Freight Orders
//PlngAndExecGroup,
CarrierAccountNumber,
// Further Attributes
TranspMeansOfTransport,
TranspOrdPartnerReference,
//MasterBillOfLading, // Master Bill of Lading is currently not used in Freight Orders
TranspOrdResponsiblePerson,
TranspOrdHasMltplExectgPties,
TranspOrdInvoicingCarrierLevel,
// Status
TranspOrdLifeCycleStatus,
TranspOrderSubcontrgSts,
TransportationOrderConfSts,
TransportationOrderExecSts,
TranspOrdGoodsMovementStatus,
TranspOrdWhseProcessingStatus,
TranspOrderDngrsGdsSts,
//TranspOrdPlanningBlock, // Planning Block is currently not used in Freight Orders
@Semantics.booleanIndicator: true
TranspOrdExecutionIsBlocked,
// Administrative Data
TransportationOrderCrtnType,
CreatedByUser,
CreationDateTime,
LastChangedByUser,
ChangedDateTime,
/* Redirections */
FreightOrder._TransportationOrderBP as _FreightOrderBusinessPartner : redirected to composition child A_FreightOrderBusinessPartner,
FreightOrder._TranspOrdDocumentReference as _FreightOrderDocumentReference : redirected to composition child A_FreightOrderDocRef,
FreightOrder._TransportationOrderItem as _FreightOrderItem : redirected to composition child A_FreightOrderItem,
FreightOrder._TransportationOrderStop as _FreightOrderStop : redirected to composition child A_FreightOrderStop,
FreightOrder._TransportationOrderEvent as _FreightOrderEvent : redirected to composition child A_FreightOrderEvent,
FreightOrder._TransportationOrderCharge as _FreightOrderCharge : redirected to composition child A_FreightOrderCharge,
FreightOrder._TrOrdMainBPAddrDfltRprstn as _FrtOrdMainBPAddrDfltRprstn : redirected to composition child A_FrtOrdMainBPAddrDfltRprstn,
/* Association redirections */
FreightOrder._CarrierAddrDfltRprstn as _CarrierAddrDfltRprstn : redirected to A_FrtOrdMainBPAddrDfltRprstn,
FreightOrder._ShipperAddrDfltRprstn as _ShipperAddrDfltRprstn : redirected to A_FrtOrdMainBPAddrDfltRprstn,
FreightOrder._ConsigneeAddrDfltRprstn as _ConsigneeAddrDfltRprstn : redirected to A_FrtOrdMainBPAddrDfltRprstn,
FreightOrder._ExectgCarrierAddrDfltRprstn as _ExectgCarrierAddrDfltRprstn : redirected to A_FrtOrdMainBPAddrDfltRprstn
}
where
TransportationOrderCategory = 'TO'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_TRANSPORTATIONORDERTP"
],
"ASSOCIATED":
[
"A_FREIGHTORDERBUSINESSPARTNER",
"A_FREIGHTORDERCHARGE",
"A_FREIGHTORDERDOCREF",
"A_FREIGHTORDEREVENT",
"A_FREIGHTORDERITEM",
"A_FREIGHTORDERSTOP",
"A_FRTORDMAINBPADDRDFLTRPRSTN",
"R_TRANSPORDDOCREFTP",
"R_TRANSPORTATIONORDERBPTP",
"R_TRANSPORTATIONORDERCHARGETP",
"R_TRANSPORTATIONORDEREVENTTP",
"R_TRANSPORTATIONORDERITEMTP",
"R_TRANSPORTATIONORDERSTOPTP",
"R_TRORDMAINBPADDRDFLTRPRSTNTP"
],
"BASE":
[
"R_TRANSPORTATIONORDERTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/