I_ServiceQuotationStdVH

DDL: I_SERVICEQUOTATIONSTDVH Type: view COMPOSITE

Service Quotation

I_ServiceQuotationStdVH is a Composite CDS View that provides data about "Service Quotation" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentEnhcd) and exposes 16 fields with key field ServiceQuotation.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentEnhcd I_ServiceDocumentEnhcd from

Annotations (15)

NameValueLevelField
EndUserText.label Service Quotation view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey ServiceQuotation view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISRVCQTANSTDVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ServiceQuotation
ServiceQuotationDescription
ServiceObjectType ServiceObjectType
ServiceDocumentType ServiceDocumentType
ServiceDocumentStatus ServiceDocumentStatus
SalesOrganization SalesOrganization
SalesOffice SalesOffice
SalesGroup SalesGroup
DistributionChannel DistributionChannel
Division Division
ResponsibleEmployee ResponsibleEmployee
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
RefInHouseRepairIsExisting RefInHouseRepairIsExisting 
@EndUserText.label: 'Service Quotation'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
  representativeKey: 'ServiceQuotation',
  dataCategory: #VALUE_HELP,
  usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
}
@Search: {
  searchable: true
}
@Metadata: {
  ignorePropagatedAnnotations: true
}
@ClientHandling: {
  algorithm: #SESSION_VARIABLE
}
@AbapCatalog: {
  sqlViewName: 'ISRVCQTANSTDVH',
  compiler.compareFilter: true,
  preserveKey: true
}

define view I_ServiceQuotationStdVH
  as select from I_ServiceDocumentEnhcd
{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.7
      @Search.ranking: #HIGH
  key cast(ServiceDocument as crms4_qtan_id_vh_lbl preserving type)              as ServiceQuotation,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold:0.7
      @Search.ranking : #HIGH
      @Semantics.text: true
      cast(ServiceDocumentDescription as crms4_qtan_description preserving type) as ServiceQuotationDescription,

      // The following fields are required for authorization checks

      @Consumption.hidden: true
      ServiceObjectType,
      @Consumption.hidden: true
      ServiceDocumentType,
      @Consumption.hidden: true
      ServiceDocumentStatus, 
      @Consumption.hidden: true
      SalesOrganization,
      @Consumption.hidden: true
      SalesOffice,
      @Consumption.hidden: true
      SalesGroup,
      @Consumption.hidden: true
      DistributionChannel,
      @Consumption.hidden: true
      Division,
      @Consumption.hidden: true
      ResponsibleEmployee,
      @Consumption.hidden: true
      SalesOrganizationOrgUnitID,
      @Consumption.hidden: true
      SalesOfficeOrgUnitID,
      @Consumption.hidden: true
      SalesGroupOrgUnitID,
      @Consumption.hidden: true
      ServiceOrganization,
      @Consumption.hidden: true
      RefInHouseRepairIsExisting    
}
where
      ServiceObjectType          = 'BUS2000116'
  and ServiceDocumentIsQuotation = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTENHCD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More