A_FreightOrder
Freight Order
A_FreightOrder is a Consumption CDS View that provides data about "Freight Order" in SAP S/4HANA. It reads from 1 data source (R_TransportationOrderTP) and exposes 42 fields with key field TransportationOrderUUID. It is exposed through 1 OData service (API_FREIGHTORDER).
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_TransportationOrderTP | R_TransportationOrderTP | projection |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Freight Order | 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 | FreightOrder_Type | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
OData Services (1)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| API_FREIGHTORDER | API_FREIGHTORDER | V4 | C2 | C1 |
Fields (42)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | TransportationOrderUUID | TransportationOrderUUID | ||
| TransportationOrder | TransportationOrder | |||
| TransportationOrderType | TransportationOrderType | |||
| TransportationOrderCategory | TransportationOrderCategory | |||
| TransportationShippingType | TransportationShippingType | |||
| TransportationMode | TransportationMode | |||
| TransportationModeCategory | TransportationModeCategory | |||
| CarrierUUID | CarrierUUID | |||
| Carrier | Carrier | |||
| StandardCarrierAlphaCode | StandardCarrierAlphaCode | |||
| TranspOrdExecutingCarrierUUID | TranspOrdExecutingCarrierUUID | |||
| TranspOrdExecutingCarrier | TranspOrdExecutingCarrier | |||
| ShipperUUID | ShipperUUID | |||
| Shipper | Shipper | |||
| ShipperAddressID | ShipperAddressID | |||
| ConsigneeUUID | ConsigneeUUID | |||
| Consignee | Consignee | |||
| ConsigneeAddressID | ConsigneeAddressID | |||
| TranspPurgOrg | TranspPurgOrg | |||
| TranspPurgOrgExtID | TranspPurgOrgExtID | |||
| TranspPurgGroup | TranspPurgGroup | |||
| TranspPurgGroupExtID | TranspPurgGroupExtID | |||
| PurgOrgCompanyCode | PurgOrgCompanyCode | |||
| CarrierAccountNumber | CarrierAccountNumber | |||
| TranspMeansOfTransport | TranspMeansOfTransport | |||
| TranspOrdPartnerReference | TranspOrdPartnerReference | |||
| TranspOrdResponsiblePerson | TranspOrdResponsiblePerson | |||
| TranspOrdHasMltplExectgPties | TranspOrdHasMltplExectgPties | |||
| TranspOrdInvoicingCarrierLevel | TranspOrdInvoicingCarrierLevel | |||
| TranspOrdLifeCycleStatus | TranspOrdLifeCycleStatus | |||
| TranspOrderSubcontrgSts | TranspOrderSubcontrgSts | |||
| TransportationOrderConfSts | TransportationOrderConfSts | |||
| TransportationOrderExecSts | TransportationOrderExecSts | |||
| TranspOrdGoodsMovementStatus | TranspOrdGoodsMovementStatus | |||
| TranspOrdWhseProcessingStatus | TranspOrdWhseProcessingStatus | |||
| TranspOrderDngrsGdsSts | TranspOrderDngrsGdsSts | |||
| TranspOrdExecutionIsBlocked | TranspOrdExecutionIsBlocked | |||
| TransportationOrderCrtnType | TransportationOrderCrtnType | |||
| CreatedByUser | CreatedByUser | |||
| CreationDateTime | CreationDateTime | |||
| LastChangedByUser | LastChangedByUser | |||
| ChangedDateTime | ChangedDateTime |
@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'
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA