R_TransportationOrderTP
Transportation Order - TP
R_TransportationOrderTP is a Transactional CDS View that provides data about "Transportation Order - TP" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrder) and exposes 91 fields with key field TransportationOrderUUID. It has 13 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_TransportationOrder | I_TransportationOrder | from |
Associations (13)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | R_TrOrdMainBPAddrDfltRprstnTP | _CarrierAddrDfltRprstn | $projection.TransportationOrderUUID = _CarrierAddrDfltRprstn.TransportationOrderUUID and _CarrierAddrDfltRprstn.TranspOrdBizPartnerFunction = 'U3' |
| [0..1] | R_TrOrdMainBPAddrDfltRprstnTP | _ShipperAddrDfltRprstn | $projection.TransportationOrderUUID = _ShipperAddrDfltRprstn.TransportationOrderUUID and _ShipperAddrDfltRprstn.TranspOrdBizPartnerFunction = 'U6' |
| [0..1] | R_TrOrdMainBPAddrDfltRprstnTP | _ConsigneeAddrDfltRprstn | $projection.TransportationOrderUUID = _ConsigneeAddrDfltRprstn.TransportationOrderUUID and _ConsigneeAddrDfltRprstn.TranspOrdBizPartnerFunction = 'WE' |
| [0..1] | R_TrOrdMainBPAddrDfltRprstnTP | _ExectgCarrierAddrDfltRprstn | $projection.TransportationOrderUUID = _ExectgCarrierAddrDfltRprstn.TransportationOrderUUID and _ExectgCarrierAddrDfltRprstn.TranspOrdBizPartnerFunction = 'TJ' |
| [1] | E_TransportationOrder | _Extension | $projection.TransportationOrderUUID = _Extension.TransportationOrderUUID |
| [0..*] | R_TransportationOrderBPTP | _TransportationOrderBP | |
| [0..*] | R_TranspOrdDocRefTP | _TranspOrdDocumentReference | |
| [0..*] | R_TransportationOrderItemTP | _TransportationOrderItem | |
| [0..*] | R_TransportationOrderStopTP | _TransportationOrderStop | |
| [0..*] | R_TransportationOrderEventTP | _TransportationOrderEvent | |
| [0..3] | R_TrOrdMainBPAddrDfltRprstnTP | _TrOrdMainBPAddrDfltRprstn | |
| [0..*] | R_TransportationOrderNoteTP | _TransportationOrderNote | |
| [0..1] | R_TransportationOrderChargeTP | _TransportationOrderCharge | |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Transportation Order - TP | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.representativeKey | TransportationOrderUUID | view | |
| ObjectModel.sapObjectNodeType.name | TransportationOrder | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AbapCatalog.extensibility.extensible | true | view | |
| AbapCatalog.extensibility.elementSuffix | TOR | view | |
| AbapCatalog.extensibility.quota.maximumFields | 408 | view | |
| AbapCatalog.extensibility.quota.maximumBytes | 8160 | view |
Fields (91)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | TransportationOrderUUID | TransportationOrderUUID | ||
| TransportationOrder | TransportationOrder | |||
| TransportationOrderType | TransportationOrderType | |||
| TransportationOrderCategory | TransportationOrderCategory | |||
| TransportationShippingType | TranspOrdShippingType | |||
| MovementType | MovementType | |||
| TransportationMode | TransportationMode | |||
| TransportationModeCategory | TransportationModeCategory | |||
| CarrierUUID | CarrierUUID | |||
| Carrier | Carrier | |||
| CarrierAddressID | CarrierAddressID | |||
| StandardCarrierAlphaCode | StandardCarrierAlphaCode | |||
| TranspOrdExecutingCarrierUUID | TranspOrdExecutingCarrierUUID | |||
| TranspOrdExecutingCarrier | TranspOrdExecutingCarrier | |||
| ExecutingCarrierAddressID | ExecutingCarrierAddressID | |||
| ShipperUUID | ShipperUUID | |||
| Shipper | Shipper | |||
| ShipperAddressID | ShipperAddressID | |||
| ConsigneeUUID | ConsigneeUUID | |||
| Consignee | Consignee | |||
| ConsigneeAddressID | ConsigneeAddressID | |||
| TranspPurgOrg | PurchasingOrganization | |||
| TranspPurgOrgExtID | PurchasingOrgExternalID | |||
| TranspPurgGroup | PurchasingGroup | |||
| TranspPurgGroupExtID | PurchasingGroupExternalID | |||
| PurgOrgCompanyCode | PurgOrgCompanyCode | |||
| PlngAndExecOrganization | PlngAndExecOrganization | |||
| PlngAndExecGroup | PlngAndExecGroup | |||
| CarrierAccountNumber | TransOrdAcctNmbrWthExectgCarr | |||
| TranspMeansOfTransport | MeansOfTransport | |||
| TranspOrdPartnerReference | TranspOrdPartnerReference | |||
| MasterBillOfLading | MasterBillOfLading | |||
| TranspOrdResponsiblePerson | TranspOrdResponsiblePerson | |||
| TranspOrdHasMltplExectgPties | TranspOrdHasMltplExectgPties | |||
| TranspOrdInvoicingCarrierLevel | TranspOrdInvoicingCarrierLevel | |||
| TranspOrdLifeCycleStatus | TranspOrdLifeCycleStatus | |||
| TranspOrderSubcontrgSts | TranspOrderSubcontrgSts | |||
| TransportationOrderConfSts | TransportationOrderConfSts | |||
| TransportationOrderExecSts | TransportationOrderExecSts | |||
| TranspOrdGoodsMovementStatus | TranspOrdGoodsMovementStatus | |||
| TranspOrdWhseProcessingStatus | TranspOrdWhseProcessingStatus | |||
| TranspOrderDngrsGdsSts | TranspOrderDngrsGdsSts | |||
| TranspOrdPlanningBlock | TranspOrdPlanningBlock | |||
| TranspOrdExecutionIsBlocked | TranspOrdExecutionIsBlocked | |||
| TransportationOrderCrtnType | TransportationOrderCrtnType | |||
| CreatedByUser | CreatedByUser | |||
| CreationDateTime | CreationDateTime | |||
| LastChangedByUser | LastChangedByUser | |||
| ChangedDateTime | ChangedDateTime | |||
| _Carrier | _Carrier | |||
| _Consignee | _Consignee | |||
| _CreatedBy | _CreatedBy | |||
| _DestinationStop | _DestinationStop | |||
| _LastChangedBy | _LastChangedBy | |||
| _MeansOfTransport | _MeansOfTransport | |||
| _MovementType | _MovementType | |||
| _PlngAndExecGroup | _PlngAndExecGroup | |||
| _PlngAndExecOrganization | _PlngAndExecOrganization | |||
| _PurchasingCompanyCode | _PurchasingCompanyCode | |||
| _PurchasingGroup | _PurchasingGroup | |||
| _PurchasingOrganization | _PurchasingOrganization | |||
| _Shipper | _Shipper | |||
| _SourceStop | _SourceStop | |||
| _TranspOrdConfirmationStatus | _TranspOrdConfirmationStatus | |||
| _TranspOrdExecutionIsBlocked | _TranspOrdExecutionIsBlocked | |||
| _TranspOrdLifeCycleStatus | _TranspOrdLifeCycleStatus | |||
| _TranspOrdPlanningBlock | _TranspOrdPlanningBlock | |||
| _TranspOrdResponsiblePerson | _TranspOrdResponsiblePerson | |||
| _TranspOrdShippingType | _TranspOrdShippingType | |||
| _TranspOrdSubcontractingSts | _TranspOrdSubcontractingSts | |||
| _TransportationMode | _TransportationMode | |||
| _TransportationModeCategory | _TransportationModeCategory | |||
| _TransportationOrderBlock | _TransportationOrderBlock | |||
| _TransportationOrderCategory | _TransportationOrderCategory | |||
| _TransportationOrderExecSts | _TransportationOrderExecSts | |||
| _TransportationOrderStage | _TransportationOrderStage | |||
| _TransportationOrderType | _TransportationOrderType | |||
| _TranspSCACCode | _TranspSCACCode | |||
| _TranspOrdDngrsGdsStatus | _TranspOrdDngrsGdsStatus | |||
| _TransportationOrderBP | _TransportationOrderBP | |||
| _TranspOrdDocumentReference | _TranspOrdDocumentReference | |||
| _TransportationOrderItem | _TransportationOrderItem | |||
| _TransportationOrderStop | _TransportationOrderStop | |||
| _TransportationOrderEvent | _TransportationOrderEvent | |||
| _TrOrdMainBPAddrDfltRprstn | _TrOrdMainBPAddrDfltRprstn | |||
| _TransportationOrderNote | _TransportationOrderNote | |||
| _TransportationOrderCharge | _TransportationOrderCharge | |||
| _CarrierAddrDfltRprstn | _CarrierAddrDfltRprstn | |||
| _ShipperAddrDfltRprstn | _ShipperAddrDfltRprstn | |||
| _ConsigneeAddrDfltRprstn | _ConsigneeAddrDfltRprstn | |||
| _ExectgCarrierAddrDfltRprstn | _ExectgCarrierAddrDfltRprstn |
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@EndUserText.label: 'Transportation Order - TP'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
usageType: {
sizeCategory: #L,
serviceQuality: #C,
dataClass:#TRANSACTIONAL
},
semanticKey: ['TransportationOrder'],
representativeKey: 'TransportationOrderUUID',
sapObjectNodeType.name: 'TransportationOrder'
}
@AccessControl: { authorizationCheck: #MANDATORY,
privilegedAssociations: ['_TransportationOrderStage',
'_TranspOrdPlanningBlock',
'_TransportationOrderBlock',
'_SourceStop',
'_DestinationStop',
'_TranspOrdResponsiblePerson',
'_CreatedBy',
'_LastChangedBy']}
@AbapCatalog.extensibility: {
extensible: true,
dataSources: ['_Extension'],
elementSuffix: 'TOR',
quota: {
maximumFields: 408, //This is calculated with formula - 2* <Customer Percentage from SCFD_REGISTRY> * <max number of fields in SCFD_REGISTRY>
maximumBytes: 8160 //This is calculated with formula - 4* <Customer Percentage from SCFD_REGISTRY> * <number of chars as defined in SCFD_REGISTRY>
}
}
define root view entity R_TransportationOrderTP
as select from I_TransportationOrder
composition [0..*] of R_TransportationOrderBPTP as _TransportationOrderBP
composition [0..*] of R_TranspOrdDocRefTP as _TranspOrdDocumentReference
composition [0..*] of R_TransportationOrderItemTP as _TransportationOrderItem
composition [0..*] of R_TransportationOrderStopTP as _TransportationOrderStop
composition [0..*] of R_TransportationOrderEventTP as _TransportationOrderEvent
composition [0..3] of R_TrOrdMainBPAddrDfltRprstnTP as _TrOrdMainBPAddrDfltRprstn
composition [0..*] of R_TransportationOrderNoteTP as _TransportationOrderNote
// Charges specific composition
composition [0..1] of R_TransportationOrderChargeTP as _TransportationOrderCharge
association [0..1] to R_TrOrdMainBPAddrDfltRprstnTP as _CarrierAddrDfltRprstn on $projection.TransportationOrderUUID = _CarrierAddrDfltRprstn.TransportationOrderUUID
and _CarrierAddrDfltRprstn.TranspOrdBizPartnerFunction = 'U3'
association [0..1] to R_TrOrdMainBPAddrDfltRprstnTP as _ShipperAddrDfltRprstn on $projection.TransportationOrderUUID = _ShipperAddrDfltRprstn.TransportationOrderUUID
and _ShipperAddrDfltRprstn.TranspOrdBizPartnerFunction = 'U6'
association [0..1] to R_TrOrdMainBPAddrDfltRprstnTP as _ConsigneeAddrDfltRprstn on $projection.TransportationOrderUUID = _ConsigneeAddrDfltRprstn.TransportationOrderUUID
and _ConsigneeAddrDfltRprstn.TranspOrdBizPartnerFunction = 'WE'
association [0..1] to R_TrOrdMainBPAddrDfltRprstnTP as _ExectgCarrierAddrDfltRprstn on $projection.TransportationOrderUUID = _ExectgCarrierAddrDfltRprstn.TransportationOrderUUID
and _ExectgCarrierAddrDfltRprstn.TranspOrdBizPartnerFunction = 'TJ'
//Extension Association
association [1] to E_TransportationOrder as _Extension on $projection.TransportationOrderUUID = _Extension.TransportationOrderUUID
{
/* Attributes */
// Identification
key TransportationOrderUUID,
TransportationOrder,
// Key Characteristics
TransportationOrderType,
TransportationOrderCategory,
TranspOrdShippingType as TransportationShippingType,
MovementType,
TransportationMode,
TransportationModeCategory,
// Parties
CarrierUUID,
Carrier,
CarrierAddressID,
StandardCarrierAlphaCode,
TranspOrdExecutingCarrierUUID,
TranspOrdExecutingCarrier,
ExecutingCarrierAddressID,
ShipperUUID,
Shipper,
ShipperAddressID,
ConsigneeUUID,
Consignee,
ConsigneeAddressID,
PurchasingOrganization as TranspPurgOrg,
PurchasingOrgExternalID as TranspPurgOrgExtID,
PurchasingGroup as TranspPurgGroup,
PurchasingGroupExternalID as TranspPurgGroupExtID,
PurgOrgCompanyCode,
PlngAndExecOrganization,
PlngAndExecGroup,
TransOrdAcctNmbrWthExectgCarr as CarrierAccountNumber,
// Further Attributes
MeansOfTransport as TranspMeansOfTransport,
TranspOrdPartnerReference,
MasterBillOfLading,
TranspOrdResponsiblePerson,
TranspOrdHasMltplExectgPties,
TranspOrdInvoicingCarrierLevel,
// Status
TranspOrdLifeCycleStatus,
TranspOrderSubcontrgSts,
TransportationOrderConfSts,
TransportationOrderExecSts,
TranspOrdGoodsMovementStatus,
TranspOrdWhseProcessingStatus,
TranspOrderDngrsGdsSts,
TranspOrdPlanningBlock,
TranspOrdExecutionIsBlocked,
// Administrative Data
TransportationOrderCrtnType,
CreatedByUser,
CreationDateTime,
LastChangedByUser,
ChangedDateTime,
/* Associations */
_Carrier,
_Consignee,
_CreatedBy,
_DestinationStop,
_LastChangedBy,
_MeansOfTransport,
_MovementType,
_PlngAndExecGroup,
_PlngAndExecOrganization,
_PurchasingCompanyCode,
_PurchasingGroup,
_PurchasingOrganization,
_Shipper,
_SourceStop,
_TranspOrdConfirmationStatus,
_TranspOrdExecutionIsBlocked,
_TranspOrdLifeCycleStatus,
_TranspOrdPlanningBlock,
_TranspOrdResponsiblePerson,
_TranspOrdShippingType,
_TranspOrdSubcontractingSts,
_TransportationMode,
_TransportationModeCategory,
_TransportationOrderBlock,
_TransportationOrderCategory,
_TransportationOrderExecSts,
_TransportationOrderStage,
_TransportationOrderType,
_TranspSCACCode,
_TranspOrdDngrsGdsStatus,
/* Composition Associations */
_TransportationOrderBP,
_TranspOrdDocumentReference,
_TransportationOrderItem,
_TransportationOrderStop,
_TransportationOrderEvent,
_TrOrdMainBPAddrDfltRprstn,
_TransportationOrderNote,
//Charges specific compositions
_TransportationOrderCharge,
_CarrierAddrDfltRprstn,
_ShipperAddrDfltRprstn,
_ConsigneeAddrDfltRprstn,
_ExectgCarrierAddrDfltRprstn
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORTATIONORDER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_COMPANYCODE",
"I_MEANSOFTRANSPORT",
"I_TRANSPMOVEMENTTYPE",
"I_TRANSPORDCONFIRMATIONSTATUS",
"I_TRANSPORDDNGRSGDSSTATUS",
"I_TRANSPORDEXECUTIONISBLOCKED",
"I_TRANSPORDLIFECYCLESTATUS",
"I_TRANSPORDPLANNINGBLOCK",
"I_TRANSPORDSHIPPINGTYPE",
"I_TRANSPORDSUBCONTRACTINGSTS",
"I_TRANSPORGANIZATIONALUNIT",
"I_TRANSPORTATIONMODE",
"I_TRANSPORTATIONMODECATEGORY",
"I_TRANSPORTATIONORDERBLOCK",
"I_TRANSPORTATIONORDERCATEGORY",
"I_TRANSPORTATIONORDEREXECSTS",
"I_TRANSPORTATIONORDERSTAGE",
"I_TRANSPORTATIONORDERSTOP",
"I_TRANSPORTATIONORDERTYPE",
"I_TRANSPSCACCODE",
"I_USER",
"R_TRANSPORDDOCREFTP",
"R_TRANSPORTATIONORDERBPTP",
"R_TRANSPORTATIONORDERCHARGETP",
"R_TRANSPORTATIONORDEREVENTTP",
"R_TRANSPORTATIONORDERITEMTP",
"R_TRANSPORTATIONORDERNOTETP",
"R_TRANSPORTATIONORDERSTOPTP",
"R_TRORDMAINBPADDRDFLTRPRSTNTP"
],
"BASE":
[
"I_TRANSPORTATIONORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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