I_ServiceOrderTypeVH

DDL: I_SERVICEORDERTYPEVH Type: view BASIC

Service Order Type Value Help

I_ServiceOrderTypeVH is a Basic CDS View that provides data about "Service Order Type Value Help" in SAP S/4HANA. It reads from 3 data sources (crmc_it_assign, crmc_item_type, crmc_sales_item) and exposes 4 fields with key field ServiceDocumentType.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
crmc_it_assign _it_assign inner
crmc_item_type _item_type inner
crmc_sales_item _sales_item inner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ISERVORDTYPEVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ServiceDocumentType view
VDM.viewType #BASIC view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #CHECK view
ObjectModel.resultSet.sizeCategory #XS view
EndUserText.label Service Order Type Value Help view
Search.searchable true view
Consumption.ranked true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentType I_ServiceDocumentTypeStdVH ServiceDocumentType
ServiceObjectType I_ServiceDocumentTypeStdVH ServiceObjectType
_ServiceDocumentTypeText I_ServiceDocumentTypeStdVH _ServiceDocumentTypeText
_ServiceObjectTypeText I_ServiceDocumentTypeStdVH _ServiceObjectTypeText 

@AbapCatalog:{
sqlViewName: 'ISERVORDTYPEVH',
compiler.compareFilter: true,
preserveKey:true
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'ServiceDocumentType'
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #CUSTOMIZING }
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')}
@ObjectModel.resultSet.sizeCategory:#XS
@EndUserText.label: 'Service Order Type Value Help'
@Search.searchable:true
@Consumption.ranked:true

define view I_ServiceOrderTypeVH
  as select distinct from I_ServiceDocumentTypeStdVH
  inner join crmc_it_assign as _it_assign on I_ServiceDocumentTypeStdVH.ServiceDocumentType =  _it_assign.process_type
  inner join crmc_item_type as _item_type on  _it_assign.itm_type =  _item_type.itm_type
  inner join crmc_sales_item as _sales_item on _item_type.itm_type = _sales_item.itm_type    
{
      @Search.ranking: #HIGH
  key I_ServiceDocumentTypeStdVH.ServiceDocumentType,
      @Search.ranking: #LOW
      I_ServiceDocumentTypeStdVH.ServiceObjectType,
      
      @Search.ranking: #LOW
      I_ServiceDocumentTypeStdVH._ServiceDocumentTypeText,
      @Search.ranking: #LOW
      I_ServiceDocumentTypeStdVH._ServiceObjectTypeText
      
}

where I_ServiceDocumentTypeStdVH.ServiceObjectType = 'BUS2000116'
and (_sales_item.is_quotation = '0' or
     _sales_item.is_quotation = '3' ) 
      

      
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTTYPESTDVH",
"CRMC_ITEM_TYPE",
"CRMC_IT_ASSIGN",
"CRMC_SALES_ITEM"
],
"ASSOCIATED":
[
"I_BUSINESSOBJTYPETEXT",
"I_SERVICEDOCUMENTTYPETEXT"
],
"BASE":
[
"I_SERVICEDOCUMENTTYPESTDVH"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More