C_ServiceContractTemplateVH

DDL: C_SERVICECONTRACTTEMPLATEVH Type: view_entity CONSUMPTION

Service Contract Template

C_ServiceContractTemplateVH is a Consumption CDS View that provides data about "Service Contract Template" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentEnhcd) and exposes 14 fields with key field ServiceContractTemplate.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentEnhcd I_ServiceDocumentEnhcd from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ServiceContractTemplate view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Service Contract Template view
Search.searchable true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ServiceContractTemplate ServiceDocument Template ID
SrvcContrTmplDescription ServiceDocumentDescription Description
ServiceDocumentType ServiceDocumentType
ServiceObjectType ServiceObjectType
SalesOrganization SalesOrganization
SalesOffice SalesOffice
SalesGroup SalesGroup
DistributionChannel DistributionChannel
Division Division
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
RespEmployeeBusinessPartnerId ResponsibleEmployee
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@Metadata.ignorePropagatedAnnotations: true

@VDM.viewType: #CONSUMPTION

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

@EndUserText.label: 'Service Contract Template'

@Search.searchable: true

define view entity C_ServiceContractTemplateVH 
  as select from I_ServiceDocumentEnhcd 

{
  
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @EndUserText.label: 'Template ID'
  key ServiceDocument               as ServiceContractTemplate,
      
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @EndUserText.label: 'Description'
      ServiceDocumentDescription    as SrvcContrTmplDescription,
      
      @UI.hidden: true
      ServiceDocumentType,
      @UI.hidden: true
      ServiceObjectType,
      
      @UI.hidden: true
      SalesOrganization,
      @UI.hidden: true
      SalesOffice,
      @UI.hidden: true
      SalesGroup,
      @UI.hidden: true
      DistributionChannel,
      @UI.hidden: true
      Division,
      @UI.hidden: true
      SalesOrganizationOrgUnitID,
      @UI.hidden: true
      SalesOfficeOrgUnitID,
      @UI.hidden: true
      SalesGroupOrgUnitID,
      @UI.hidden: true
      ServiceOrganization,
      
      @UI.hidden: true
      ResponsibleEmployee as RespEmployeeBusinessPartnerId
}
where ServiceObjectType = 'BUS2000112'
and   ServiceDocumentTemplateType != ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTENHCD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/