C_WorkPermitOrderOperationVH
Work Permit Order Operations
C_WorkPermitOrderOperationVH is a Consumption CDS View that provides data about "Work Permit Order Operations" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderOperation) and exposes 11 fields with key fields MaintenanceOrder, MaintenanceOrderOperation.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MaintenanceOrderOperation | _MaintenanceOrderOperation | from |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CWRKPMTORDEROPVH | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Work Permit Order Operations | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.dataClass | #META | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.dataCategory | #VALUE_HELP | view | |
| ObjectModel.representativeKey | MaintenanceOrder | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Search.searchable | true | view |
Fields (11)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaintenanceOrder | I_MaintenanceOrderOperation | MaintenanceOrder | |
| KEY | MaintenanceOrderOperation | |||
| OperationDescription | I_MaintenanceOrderOperation | OperationDescription | ||
| MaintOrderOperationCounter | I_MaintenanceOrderOperation | MaintOrderOperationCounter | ||
| MaintOrderRoutingNumber | I_MaintenanceOrderOperation | MaintOrderRoutingNumber | ||
| Plant | I_MaintenanceOrderOperation | Plant | ||
| PlantName | ||||
| WorkCenter | ||||
| WorkCenterText | ||||
| MaintOrderOperationInternalID | I_MaintenanceOrderOperation | MaintOrderOperationInternalID | ||
| _MaintenanceOrder | _MaintenanceOrder |
@AbapCatalog.sqlViewName: 'CWRKPMTORDEROPVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Work Permit Order Operations'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #S, dataClass: #META}
@VDM.viewType: #CONSUMPTION
@ObjectModel.dataCategory:#VALUE_HELP
@ObjectModel.representativeKey: 'MaintenanceOrder'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
define view C_WorkPermitOrderOperationVH
as select from I_MaintenanceOrderOperation as _MaintenanceOrderOperation
{
@ObjectModel.foreignKey.association: '_MaintenanceOrder'
key _MaintenanceOrderOperation.MaintenanceOrder,
@UI.lineItem: [{ position: 10, label: 'Operation Number' }]
@EndUserText:{ label: 'Operation Number', quickInfo: 'Operation Number'}
@Search.defaultSearchElement: true
@Search.ranking: #HIGH
@Consumption.filter.hidden:true
@Search.fuzzinessThreshold: 0.8
key cast ( _MaintenanceOrderOperation.MaintenanceOrderOperation as vdm_vornr preserving type) as MaintenanceOrderOperation,
_MaintenanceOrderOperation.OperationDescription as OperationDescription,
_MaintenanceOrderOperation.MaintOrderOperationCounter as MaintOrderOperationCounter,
_MaintenanceOrderOperation.MaintOrderRoutingNumber,
@ObjectModel.text.element: ['PlantName']
@UI.lineItem: [{ position: 60, label: 'Plant Name' }]
@UI: {
textArrangement: #TEXT_ONLY
}
_MaintenanceOrderOperation.Plant as Plant,
_MaintenanceOrderOperation._Plant.PlantName as PlantName,
@EndUserText:{ label: 'Work Center', quickInfo: 'Work Center'}
@UI.lineItem: [{ position: 50, label: 'Work Center' }]
@UI: {
textArrangement: #TEXT_ONLY
}
@ObjectModel.text.element: ['WorkCenterText']
_MaintenanceOrderOperation._WorkCenter.WorkCenter as WorkCenter,
_MaintenanceOrderOperation._WorkCenter._Text[1:Language = $session.system_language].WorkCenterText as WorkCenterText,
_MaintenanceOrderOperation.MaintOrderOperationInternalID,
@EndUserText.label: 'System Status'
@ObjectModel: {
virtualElement: true,
virtualElementCalculatedBy: 'ABAP:CL_EAM_ORDOP_STS_EXIT'
}
@Semantics.text: true
@UI.lineItem: [{ position: 70, label: 'System Status' }]
@Search.defaultSearchElement: true
cast ('' as vdm_j_system_status_concat_t) as ConcatenatedActiveSystStsName,
_MaintenanceOrder
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDEROPERATION",
"I_PLANT",
"I_WORKCENTER",
"I_WORKCENTERTEXT"
],
"ASSOCIATED":
[
"I_MAINTENANCEORDER"
],
"BASE":
[
"I_MAINTENANCEORDEROPERATION"
],
"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