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 2 Fiori applications: Create Work Permit Request, Manage Work Permits.
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 (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CWRKPMTORDERVH | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| 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 | |
| ObjectModel.representativeKey | MaintenanceOrder | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | 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 (2)
| App ID | App Name | Type | Description |
|---|---|---|---|
| F4691 | Create Work Permit Request | 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 app to create new Work Permit. |
| 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. |
Create Work Permit Request
Business Role: Maintenance Planner
The Create Work Permit Request app allows to create new work permit with reference to an existing maintenance order, a predesigned work permit template, or independently. It provides the abilities to perform the following operations: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
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 |
@AbapCatalog.sqlViewName: 'CWRKPMTORDERVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'MaintenanceOrder'
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Maintenance Orders in Work Permit'
define view 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'
@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'
)
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