R_MaintOrderOpProdnRsceToolTP
Maintenance Order Operation PRT TP
R_MaintOrderOpProdnRsceToolTP is a Transactional CDS View that provides data about "Maintenance Order Operation PRT TP" in SAP S/4HANA. It reads from 2 data sources (I_MaintOrderOpProdnRsceTool, I_ProdnRsceToolMasterData) and exposes 23 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, ProdnRsceToolItemNumber. It has 2 associations to related views. Part of development package IWO1.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_MaintOrderOpProdnRsceTool | MaintOrderOpProdnRsceTool | from |
| I_ProdnRsceToolMasterData | ProdnRsceToolMasterData | inner |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | R_MaintenanceOrderTP | _MaintenanceOrder | $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder |
| [0..*] | I_ProdnRsceToolCategoryText_2 | _ProdnRsceToolCategoryText | $projection.ProdnRsceToolCategory = _ProdnRsceToolCategoryText.ProdnRsceToolCategory |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Maintenance Order Operation PRT TP | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view |
Fields (23)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaintenanceOrder | I_MaintOrderOpProdnRsceTool | MaintenanceOrder | |
| KEY | MaintenanceOrderOperation | I_MaintOrderOpProdnRsceTool | MaintenanceOrderOperation | |
| KEY | MaintenanceOrderSubOperation | I_MaintOrderOpProdnRsceTool | MaintenanceOrderSubOperation | |
| KEY | ProdnRsceToolItemNumber | I_MaintOrderOpProdnRsceTool | ProdnRsceToolItemNumber | |
| OrderProdnRsceToolText | I_MaintOrderOpProdnRsceTool | OrderProdnRsceToolText | ||
| ProdnRsceToolCategory | I_MaintOrderOpProdnRsceTool | ProdnRsceToolCategory | ||
| ProductionResourceType | I_MaintOrderOpProdnRsceTool | ProductionResourceType | ||
| ProductionResourceInternalID | I_MaintOrderOpProdnRsceTool | ProductionResourceInternalID | ||
| Product | MaterialPRTByInternalKey | Material | ||
| MiscProductionResourceTool | MiscPRTByInternalKey | MiscProductionResourceTool | ||
| Plant | MaterialPRTByInternalKey | Plant | ||
| Equipment | EquipmentPRTByInternalKey | Equipment | ||
| DocumentInfoRecord | DocumentPRTByInternalKey | DocumentInfoRecord | ||
| DocumentType | DocumentPRTByInternalKey | DocumentType | ||
| DocumentPart | DocumentPRTByInternalKey | DocumentPart | ||
| DocumentVersion | DocumentPRTByInternalKey | DocumentVersion | ||
| MeasuringPoint | MsrgPointPRTByInternalKey | MeasuringPoint | ||
| ProdnRsceToolControlProfile | I_MaintOrderOpProdnRsceTool | ProdnRsceToolControlProfile | ||
| ProdnRsceToolStandardWorkQty | I_MaintOrderOpProdnRsceTool | ProdnRsceToolStandardWorkQty | ||
| ProdnRsceToolStdWorkQtyUnit | I_MaintOrderOpProdnRsceTool | ProdnRsceToolStdWorkQtyUnit | ||
| _ProdnRsceToolCategoryText | _ProdnRsceToolCategoryText | |||
| _MaintenanceOrder | _MaintenanceOrder | |||
| _MaintenanceOrderOperation | _MaintenanceOrderOperation |
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Order Operation PRT TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
define view entity R_MaintOrderOpProdnRsceToolTP
as select from I_MaintOrderOpProdnRsceTool as MaintOrderOpProdnRsceTool
inner join I_ProdnRsceToolMasterData as ProdnRsceToolMasterData on MaintOrderOpProdnRsceTool.ProductionResourceType = ProdnRsceToolMasterData.ProductionResourceType
and MaintOrderOpProdnRsceTool.ProductionResourceInternalID = ProdnRsceToolMasterData.ProductionResourceInternalID
left outer to one join I_MaterialPRTByInternalKey as MaterialPRTByInternalKey on ProdnRsceToolMasterData.ProductionResourceType = MaterialPRTByInternalKey.ProductionResourceType
and ProdnRsceToolMasterData.ProductionResourceInternalID = MaterialPRTByInternalKey.ProductionResourceInternalID
left outer to one join I_MiscPRTByInternalKey as MiscPRTByInternalKey on ProdnRsceToolMasterData.ProductionResourceType = MiscPRTByInternalKey.ProductionResourceType
and ProdnRsceToolMasterData.ProductionResourceInternalID = MiscPRTByInternalKey.ProductionResourceInternalID
left outer to one join I_EquipmentPRTByInternalKey as EquipmentPRTByInternalKey on ProdnRsceToolMasterData.ProductionResourceType = EquipmentPRTByInternalKey.ProductionResourceType
and ProdnRsceToolMasterData.ProductionResourceInternalID = EquipmentPRTByInternalKey.ProductionResourceInternalID
left outer to one join I_DocumentPRTByInternalKey as DocumentPRTByInternalKey on ProdnRsceToolMasterData.ProductionResourceType = DocumentPRTByInternalKey.ProductionResourceType
and ProdnRsceToolMasterData.ProductionResourceInternalID = DocumentPRTByInternalKey.ProductionResourceInternalID
left outer to one join I_MsrgPointPRTByInternalKey as MsrgPointPRTByInternalKey on ProdnRsceToolMasterData.ProductionResourceType = MsrgPointPRTByInternalKey.ProductionResourceType
and ProdnRsceToolMasterData.ProductionResourceInternalID = MsrgPointPRTByInternalKey.ProductionResourceInternalID
association to parent R_MaintenanceOrderOperationTP as _MaintenanceOrderOperation on (
$projection.MaintenanceOrder = _MaintenanceOrderOperation.MaintenanceOrder
and $projection.MaintenanceOrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation
and $projection.MaintenanceOrderSubOperation = _MaintenanceOrderOperation.MaintenanceOrderSubOperation
)
association [1..1] to R_MaintenanceOrderTP as _MaintenanceOrder on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
association [0..*] to I_ProdnRsceToolCategoryText_2 as _ProdnRsceToolCategoryText on $projection.ProdnRsceToolCategory = _ProdnRsceToolCategoryText.ProdnRsceToolCategory
{
key MaintOrderOpProdnRsceTool.MaintenanceOrder,
key MaintOrderOpProdnRsceTool.MaintenanceOrderOperation,
key MaintOrderOpProdnRsceTool.MaintenanceOrderSubOperation,
key MaintOrderOpProdnRsceTool.ProdnRsceToolItemNumber,
MaintOrderOpProdnRsceTool.OrderProdnRsceToolText,
MaintOrderOpProdnRsceTool.ProdnRsceToolCategory,
MaintOrderOpProdnRsceTool.ProductionResourceType,
MaintOrderOpProdnRsceTool.ProductionResourceInternalID,
MaterialPRTByInternalKey.Material as Product,
MiscPRTByInternalKey.MiscProductionResourceTool,
MaterialPRTByInternalKey.Plant,
EquipmentPRTByInternalKey.Equipment,
DocumentPRTByInternalKey.DocumentInfoRecord,
DocumentPRTByInternalKey.DocumentType,
DocumentPRTByInternalKey.DocumentPart,
DocumentPRTByInternalKey.DocumentVersion,
MsrgPointPRTByInternalKey.MeasuringPoint,
//
MaintOrderOpProdnRsceTool.ProdnRsceToolControlProfile,
@Semantics.quantity.unitOfMeasure: 'ProdnRsceToolStdWorkQtyUnit'
MaintOrderOpProdnRsceTool.ProdnRsceToolStandardWorkQty,
MaintOrderOpProdnRsceTool.ProdnRsceToolStdWorkQtyUnit,
_ProdnRsceToolCategoryText,
_MaintenanceOrder,
_MaintenanceOrderOperation
}
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