C_WorkPermitOrderValueHelp
Maintenance Orders in Work Permit
C_WorkPermitOrderValueHelp is a Consumption CDS View that provides data about "Maintenance Orders in Work Permit" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrder) and exposes 20 fields with key field MaintenanceOrder. It has 2 associations to related views. It is exposed through 1 OData service (UI_WORKPERMIT). It is used in 1 Fiori application: Manage Work Permits. Part of development package VDM_EAM_WCM_PERMIT_TO_WORK.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MaintenanceOrder | _MaintenanceOrder | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_OrderTypeText | _OrderTypeText | $projection.MaintenanceOrderType = _OrderTypeText.OrderType and _OrderTypeText.Language = $session.system_language |
| [1..1] | I_Plant | _Plant | $projection.MaintenancePlanningPlant = _Plant.Plant |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Search.searchable | true | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.dataCategory | #VALUE_HELP | view | |
| Analytics.technicalName | CWRKPMTORDERVH | view | |
| ObjectModel.representativeKey | MaintenanceOrder | view | |
| EndUserText.label | Maintenance Orders in Work Permit | view |
OData Services (1)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| UI_WORKPERMIT | UI_WORKPERMIT | V2 | C1 | NOT_RELEASED |
Fiori Apps (1)
| App ID | App Name | Type | Description |
|---|---|---|---|
| F6579 | Manage Work Permits | Transactional | Work Permit is initiated during the planning of a maintenance activity and typically created from a predesigned template, together with the work order associated with the maintenance task. You can use this to search and maintain Work Permits. |
Manage Work Permits
Business Role: Maintenance Planner
The Manage Work Permits app allows you to create, manage, and monitor work permits and gain valuable insights about the progress of your maintenance operations. Using the app, new work permits can be created with reference to an existing maintenance order, a predesigned work permit template, or independently. It provides the following capabilities:Allows to create and process new work permit using the optimized work permit management solutionProvides the ability to assign multiple functional locations, equipment, maintenance orders, partners, and attachments to enhance work permit with details related to the work activityAllows the configuration of the nature of work, personal protective equipment, and safety precautions to enhance work permit with safety protocols.Offers easy data validation and a simplified approval process that adheres to a four-eyes principleSupports the printing of work permit in the output form maintained by the userProvides the ability to extend the validity even after the creation of work permitSupports all operations relevant to work permit management such as approval, print, issue, return, close, deactivate, cancel, and mark for deletion.Provides the ability to view the records of data transfers using application logs
Fields (20)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaintenanceOrder | I_MaintenanceOrder | MaintenanceOrder | |
| MaintenanceOrderDesc | I_MaintenanceOrder | MaintenanceOrderDesc | Maintenance Order Description | |
| MaintenancePlanningPlant | I_MaintenanceOrder | MaintenancePlanningPlant | ||
| PlantName | _Plant | PlantName | ||
| MaintenanceOrderType | I_MaintenanceOrder | MaintenanceOrderType | ||
| OrderTypeName | _OrderTypeText | OrderTypeName | ||
| MaintenanceOrderCategory | I_MaintenanceOrder | MaintenanceOrderCategory | ||
| MainWorkCenter | I_MaintenanceOrder | MainWorkCenter | ||
| WorkCenterTypeCode | I_MaintenanceOrder | WorkCenterTypeCode | ||
| WorkCenterInternalID | I_MaintenanceOrder | WorkCenterInternalID | ||
| MaintenanceOrderInternalID | I_MaintenanceOrder | MaintenanceOrderInternalID | ||
| MaintenancePlannerGroup | I_MaintenanceOrder | MaintenancePlannerGroup | ||
| CompanyCode | I_MaintenanceOrder | CompanyCode | ||
| MaintenanceProcessingPhase | I_MaintenanceOrder | MaintenanceProcessingPhase | ||
| _MaintenancePlanPlant | I_MaintenanceOrder | _MaintenancePlanPlant | ||
| _MaintenanceOrderType | I_MaintenanceOrder | _MaintenanceOrderType | ||
| _MaintenanceOrderCategory | I_MaintenanceOrder | _MaintenanceOrderCategory | ||
| _CompanyCode | _CompanyCode | |||
| _Plant | _Plant | |||
| _OrderTypeText | _OrderTypeText |
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@ObjectModel.dataCategory: #VALUE_HELP
@Analytics.technicalName: 'CWRKPMTORDERVH'
@ObjectModel.representativeKey: 'MaintenanceOrder'
@EndUserText.label: 'Maintenance Orders in Work Permit'
define view entity C_WorkPermitOrderValueHelp
as select from I_MaintenanceOrder as _MaintenanceOrder
association [1..1] to I_OrderTypeText as _OrderTypeText on $projection.MaintenanceOrderType = _OrderTypeText.OrderType
and _OrderTypeText.Language = $session.system_language
association [1..1] to I_Plant as _Plant on $projection.MaintenancePlanningPlant = _Plant.Plant
{
@Search.defaultSearchElement: true
@Search.ranking: #HIGH
@Search.fuzzinessThreshold: 0.9
@ObjectModel.text.element: [ 'MaintenanceOrderDesc' ]
@UI.lineItem: [{ position: 10, label: 'Order' }]
key _MaintenanceOrder.MaintenanceOrder,
@EndUserText.label: 'Maintenance Order Description'
@Search.defaultSearchElement: true
@Search.ranking: #MEDIUM
@Search.fuzzinessThreshold: 0.8
// @Semantics.text: true
@UI.lineItem: [{ position: 20, label: 'Maintenance Order Description' }]
_MaintenanceOrder.MaintenanceOrderDesc,
@Search.defaultSearchElement: true
@Search.ranking: #MEDIUM
@Search.fuzzinessThreshold: 0.9
@Consumption.filter.hidden: true
@ObjectModel.text.element: ['PlantName']
// @ObjectModel.text.association: '_Plant'
@ObjectModel.text.association:null
@UI.lineItem: [{ position: 30, label: 'Plant' }]
_MaintenanceOrder.MaintenancePlanningPlant,
@Semantics.text: true
@Consumption.filter.hidden: true
@Search: {defaultSearchElement: true, ranking: #MEDIUM}
@UI.lineItem: [{ position: 40, label: 'Plant Name' }]
_Plant.PlantName,
@Search.defaultSearchElement: true
@Search.ranking: #MEDIUM
@Search.fuzzinessThreshold: 0.9
@ObjectModel.text.element: ['OrderTypeName']
@ObjectModel.text.association: '_OrderTypeText'
@UI.lineItem: [{ position: 50, label: 'Order Type' }]
_MaintenanceOrder.MaintenanceOrderType,
@Search.defaultSearchElement: true
@Search.ranking: #MEDIUM
@Search.fuzzinessThreshold: 0.9
_OrderTypeText.OrderTypeName,
@UI.hidden: true
// @ObjectModel.foreignKey.association: '_MaintenanceOrderCategory'
_MaintenanceOrder.MaintenanceOrderCategory,
// @UI.hidden: true
_MaintenanceOrder.MainWorkCenter,
@UI.hidden: true
_MaintenanceOrder.WorkCenterTypeCode,
@UI.hidden: true
_MaintenanceOrder.WorkCenterInternalID,
@UI.hidden: true
_MaintenanceOrder.MaintenanceOrderInternalID,
@UI.hidden: true
_MaintenanceOrder.MaintenancePlannerGroup,
@UI.hidden: true
_MaintenanceOrder.CompanyCode,
@UI.hidden: true
_MaintenanceOrder.MaintenanceProcessingPhase,
_MaintenanceOrder._MaintenancePlanPlant,
_MaintenanceOrder._MaintenanceOrderType,
_MaintenanceOrder._MaintenanceOrderCategory,
_CompanyCode,
_Plant,
_OrderTypeText
}
where
(
MaintenanceProcessingPhase = '0'
or MaintenanceProcessingPhase = '2'
)
and ( _MaintenanceOrder.MaintenanceOrderType <> 'YBA1'
and _MaintenanceOrder.MaintenanceOrderType <> 'YBA2'
and _MaintenanceOrder.MaintenanceOrderType <> 'YBA3' )
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