Which tables does C_WorkPermitOrderValueHelp use?

C_WorkPermitOrderValueHelp reads from 1 data source(s): I_MaintenanceOrder.

How many fields does C_WorkPermitOrderValueHelp have?

C_WorkPermitOrderValueHelp has 20 fields. Key fields: MaintenanceOrder.

C_WorkPermitOrderValueHelp

DDL: C_WORKPERMITORDERVALUEHELP SQL: CWRKPMTORDERVH Type: view CONSUMPTION

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.

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
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

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'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDER",
"I_ORDERTYPETEXT",
"I_PLANT"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_MAINTENANCEPLANPLANT",
"I_ORDERCATEGORY",
"I_ORDERTYPE",
"I_ORDERTYPETEXT",
"I_PLANT"
],
"BASE":
[
"I_MAINTENANCEORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_WorkPermitOrderValueHelp view

I_MaintenanceOrder view