R_TransportationOrderStopTP
Transportation Order Stop - TP
R_TransportationOrderStopTP is a Transactional CDS View that provides data about "Transportation Order Stop - TP" in SAP S/4HANA. It reads from 2 data sources (I_TransportationOrder, I_TransportationOrderStop) and exposes 41 fields with key field TransportationOrderStopUUID. It has 2 associations to related views.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_TransportationOrder | TransportationOrder | inner |
| I_TransportationOrderStop | TransportationOrderStop | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | R_TransportationOrderStageTP | _TranspOrderStage | |
| [0..1] | R_TrOrdStopLocAddrDfltRprstnTP | _TrOrdStopLocAddrDfltRprstn | |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Transportation Order Stop - TP | view | |
| Metadata.ignorePropagatedAnnotations | true | 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 | TransportationOrderStopUUID | view |
Fields (41)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | TransportationOrderStopUUID | I_TransportationOrderStop | TransportationOrderStopUUID | |
| TransportationOrderUUID | I_TransportationOrderStop | TransportationOrderUUID | ||
| TransportationOrderStop | I_TransportationOrderStop | TransportationOrderStop | ||
| TranspOrdStopStopParentUUID | I_TransportationOrderStop | TranspOrdStopStopParentUUID | ||
| TranspOrdStopCategory | I_TransportationOrderStop | TranspOrdStopCategory | ||
| TranspOrdStopRole | I_TransportationOrderStop | TranspOrdStopRole | ||
| LocationAdditionalUUID | I_TransportationOrderStop | LocationAdditionalUUID | ||
| LocationId | I_TransportationOrderStop | LocationId | ||
| LocationUNCode | I_TransportationOrderStop | TranspOrdStopLocUNCode | ||
| LocationIATACode | I_TransportationOrderStop | TranspOrdStopLocIATACode | ||
| TranspOrdStopAccptblStrtDteTme | I_TransportationOrderStop | TranspOrdStopAccptblStrtDteTme | ||
| TranspOrdStopReqStartDteTme | I_TransportationOrderStop | TranspOrdStopReqStartDteTme | ||
| TranspOrdStopReqEndDteTme | I_TransportationOrderStop | TranspOrdStopReqEndDteTme | ||
| TranspOrdStopAccptblEndDteTme | I_TransportationOrderStop | TranspOrdStopAccptblEndDteTme | ||
| TranspOrdStopPlanTranspDteTme | I_TransportationOrderStop | TranspOrdStopPlanTranspDteTme | ||
| TranspOrdStopDteTme | I_TransportationOrderStop | TranspOrdStopDteTme | ||
| TranspOrdStopApptStrtDteTme | I_TransportationOrderStop | TranspOrdStopApptStrtDteTme | ||
| TranspOrdStopApptEndDteTme | I_TransportationOrderStop | TranspOrdStopApptEndDteTme | ||
| TranspStopCarrConfStrtDteTme | I_TransportationOrderStop | TranspStopCarrConfStrtDteTme | ||
| TranspStopCarrConfEndDteTme | I_TransportationOrderStop | TranspStopCarrConfEndDteTme | ||
| TranspOrdStopDocCutOffDateTime | I_TransportationOrderStop | TranspOrdStopDocCutOffDateTime | ||
| TranspOrdStopCrgoCutOffDteTme | I_TransportationOrderStop | TranspOrdStopCrgoCutOffDteTme | ||
| TranspOrdStopVGMCutOffDateTime | I_TransportationOrderStop | TranspOrdStopVGMCutOffDateTime | ||
| TranspOrdStopSequencePosition | I_TransportationOrderStop | TranspOrdStopSequencePosition | ||
| TranspOrdCapacityStopUUID | I_TransportationOrderStop | TranspOrdCapacityStopUUID | ||
| TranspOrdStopCapacityItemUUID | I_TransportationOrderStop | TranspOrdStopCapacityItemUUID | ||
| TranspOrdStopHndlgExecStatus | I_TransportationOrderStop | TranspOrdStopHndlgExecStatus | ||
| TranspOrdStopExecIsBlocked | I_TransportationOrderStop | TranspOrdStopExecIsBlocked | ||
| TransportationOrderCategory | I_TransportationOrder | TransportationOrderCategory | ||
| _CapacityStop | I_TransportationOrderStop | _CapacityStop | ||
| _LocationAdditional | I_TransportationOrderStop | _LocationAdditional | ||
| _LocationDescription | I_TransportationOrderStop | _LocationDescription | ||
| _TranspHndlgExecStatus | I_TransportationOrderStop | _TranspHndlgExecStatus | ||
| _TranspOrdExecTranspActyArr | I_TransportationOrderStop | _TranspOrdExecTranspActyArr | ||
| _TranspOrdExecTranspActyDep | I_TransportationOrderStop | _TranspOrdExecTranspActyDep | ||
| _TranspOrdExecution | I_TransportationOrderStop | _TranspOrdExecution | ||
| _TranspOrdStopCategory | I_TransportationOrderStop | _TranspOrdStopCategory | ||
| _TranspOrdStopRole | I_TransportationOrderStop | _TranspOrdStopRole | ||
| _TransportationOrder | _TransportationOrder | |||
| _TranspOrderStage | _TranspOrderStage | |||
| _TrOrdStopLocAddrDfltRprstn | _TrOrdStopLocAddrDfltRprstn |
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl: {
authorizationCheck: #MANDATORY,
privilegedAssociations: [
'_TranspOrdExecTranspActyDep',
'_TranspOrdExecTranspActyArr',
'_CapacityStop',
'_TranspOrdExecution'
]
}
@EndUserText.label: 'Transportation Order Stop - TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
usageType: {
sizeCategory: #L,
serviceQuality: #C,
dataClass:#TRANSACTIONAL
},
semanticKey: ['TransportationOrderStop'],
representativeKey: 'TransportationOrderStopUUID'
}
define view entity R_TransportationOrderStopTP
as select from I_TransportationOrderStop as TransportationOrderStop
/* We must join I_TransportationOrder to make I_TransportationOrder.TransportationOrderCategory available in the
* projection views to filter by TransportationOrderCategory
*/
inner join I_TransportationOrder as TransportationOrder on TransportationOrder.TransportationOrderUUID = TransportationOrderStop.TransportationOrderUUID
association to parent R_TransportationOrderTP as _TransportationOrder on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
composition [0..*] of R_TransportationOrderStageTP as _TranspOrderStage
composition [0..1] of R_TrOrdStopLocAddrDfltRprstnTP as _TrOrdStopLocAddrDfltRprstn
{
/* Attributes */
// Identification
key TransportationOrderStop.TransportationOrderStopUUID,
TransportationOrderStop.TransportationOrderUUID,
TransportationOrderStop.TransportationOrderStop,
TransportationOrderStop.TranspOrdStopStopParentUUID, // Stop Hierarchies are currently not supported in S/4HANA Cloud
// Key Characteristics
TransportationOrderStop.TranspOrdStopCategory,
TransportationOrderStop.TranspOrdStopRole,
// Location
TransportationOrderStop.LocationAdditionalUUID, // This is the RAW16 UUID of the Location; LocationUUID is the CHAR22 GUID
TransportationOrderStop.LocationId,
TransportationOrderStop.TranspOrdStopLocUNCode as LocationUNCode,
TransportationOrderStop.TranspOrdStopLocIATACode as LocationIATACode,
// Dates and Times
TransportationOrderStop.TranspOrdStopAccptblStrtDteTme,
TransportationOrderStop.TranspOrdStopReqStartDteTme,
TransportationOrderStop.TranspOrdStopReqEndDteTme,
TransportationOrderStop.TranspOrdStopAccptblEndDteTme,
TransportationOrderStop.TranspOrdStopPlanTranspDteTme,
TransportationOrderStop.TranspOrdStopDteTme,
TransportationOrderStop.TranspOrdStopApptStrtDteTme,
TransportationOrderStop.TranspOrdStopApptEndDteTme,
TransportationOrderStop.TranspStopCarrConfStrtDteTme,
TransportationOrderStop.TranspStopCarrConfEndDteTme,
TransportationOrderStop.TranspOrdStopDocCutOffDateTime,
TransportationOrderStop.TranspOrdStopCrgoCutOffDteTme,
TransportationOrderStop.TranspOrdStopVGMCutOffDateTime,
// Further Attributes
TransportationOrderStop.TranspOrdStopSequencePosition,
// References to Capacity Documents
TransportationOrderStop.TranspOrdCapacityStopUUID,
TransportationOrderStop.TranspOrdStopCapacityItemUUID,
// Status
TransportationOrderStop.TranspOrdStopHndlgExecStatus,
@Semantics.booleanIndicator
TransportationOrderStop.TranspOrdStopExecIsBlocked,
// (Technical/Hidden) Attributes
TransportationOrder.TransportationOrderCategory,
/* Associations */
TransportationOrderStop._CapacityStop,
TransportationOrderStop._LocationAdditional,
TransportationOrderStop._LocationDescription,
TransportationOrderStop._TranspHndlgExecStatus,
TransportationOrderStop._TranspOrdExecTranspActyArr,
TransportationOrderStop._TranspOrdExecTranspActyDep,
TransportationOrderStop._TranspOrdExecution,
TransportationOrderStop._TranspOrdStopCategory,
TransportationOrderStop._TranspOrdStopRole,
_TransportationOrder,
_TranspOrderStage,
_TrOrdStopLocAddrDfltRprstn
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORTATIONORDER",
"I_TRANSPORTATIONORDERSTOP"
],
"ASSOCIATED":
[
"I_LOCATIONBASIC",
"I_TMLOCATIONDESCRIPTION",
"I_TRANSPHNDLGEXECSTATUS",
"I_TRANSPORDEXECTRANSPACTY",
"I_TRANSPORDEXECUTION",
"I_TRANSPORDSTOPCATEGORY",
"I_TRANSPORDSTOPROLE",
"I_TRANSPORTATIONORDERSTOP",
"R_TRANSPORTATIONORDERSTAGETP",
"R_TRANSPORTATIONORDERTP",
"R_TRORDSTOPLOCADDRDFLTRPRSTNTP"
],
"BASE":
[
"I_TRANSPORTATIONORDERSTOP"
],
"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