I_ServiceOrderTemplateStdVH

DDL: I_SERVICEORDERTEMPLATESTDVH SQL: ISRVCORDTMPLVH Type: view COMPOSITE

Service Order Template Value Help

I_ServiceOrderTemplateStdVH is a Composite CDS View that provides data about "Service Order Template Value Help" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocument) and exposes 16 fields with key fields ServiceDocumentType, ServiceDocument.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocument I_ServiceDocument from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ISRVCORDTMPLVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ServiceDocument view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Service Order Template Value Help view
Search.searchable true view
Consumption.ranked true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentType ServiceDocumentType
KEY ServiceDocument ServiceDocument ID
ServiceObjectType ServiceObjectType
ServiceDocumentDescription ServiceDocumentDescription Description
SrvcDocTemplateSearchTermText SrvcDocTemplateSearchTermText
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
Division Division
SalesOffice SalesOffice
SalesGroup SalesGroup
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
ResponsibleEmployee ResponsibleEmployee
_ServiceDocumentType _ServiceDocumentType 
@AbapCatalog.sqlViewName: 'ISRVCORDTMPLVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@Metadata: {
    ignorePropagatedAnnotations: true
}

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE

@ObjectModel: {
   dataCategory: #VALUE_HELP,
   representativeKey: 'ServiceDocument',
   semanticKey:  [ 'ServiceDocument' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #L
   },
   supportedCapabilities: [ #VALUE_HELP_PROVIDER ]
}

@EndUserText.label: 'Service Order Template Value Help'

@Search: {
  searchable: true
}
@Consumption.ranked:true

define view I_ServiceOrderTemplateStdVH
  as select from I_ServiceDocument
{
      @Search:{ ranking: #HIGH,
      defaultSearchElement: true}
      @ObjectModel.foreignKey.association: '_ServiceDocumentType'
  key ServiceDocumentType,

      @EndUserText.label: 'ID'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key ServiceDocument,
      @Search:{ ranking: #LOW}
      @Consumption.hidden:true
      ServiceObjectType,
      @Search: { ranking: #LOW }
      @EndUserText.label: 'Description'
      ServiceDocumentDescription,
      @Search:{ranking: #LOW }
      @Consumption.hidden:true
      SrvcDocTemplateSearchTermText,
      @Search.ranking: #LOW
      @Consumption.hidden:true
      SalesOrganization,
      @Search.ranking: #LOW
      @Consumption.hidden:true
      DistributionChannel,
      @Search.ranking: #LOW
      @Consumption.hidden:true
      Division,
      @Search.ranking: #LOW
      @Consumption.hidden:true
      SalesOffice,
      @Search.ranking: #LOW
      @Consumption.hidden:true
      SalesGroup,
      @Search.ranking: #LOW
      @Consumption.hidden:true
      SalesOrganizationOrgUnitID,
      @Search.ranking: #LOW
      @Consumption.hidden:true
      SalesOfficeOrgUnitID,
      @Search.ranking: #LOW
      @Consumption.hidden:true
      SalesGroupOrgUnitID,
      @Search.ranking: #LOW
      @Consumption.hidden:true
      ServiceOrganization,
      @Search.ranking: #LOW
      @Consumption.hidden:true
      ResponsibleEmployee,

      @Consumption.hidden:true
      _ServiceDocumentType
}
where
      ServiceObjectType           =  'BUS2000116'
  and ServiceDocumentTemplateType <> ' '
  and ServiceDocumentIsQuotation  =  ' '
  and RefInHouseRepairIsExisting  =  ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENT"
],
"ASSOCIATED":
[
"I_SERVICEDOCUMENTTYPE"
],
"BASE":
[
"I_SERVICEDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More