I_ServiceOrderStdVH

DDL: I_SERVICEORDERSTDVH SQL: ISERVORDVH Type: view BASIC Package: CRMS4_REPORT

Service Order Value Help

I_ServiceOrderStdVH is a Basic CDS View that provides data about "Service Order Value Help" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocument) and exposes 30 fields with key fields ServiceDocument, ServiceDocumentType. Part of development package CRMS4_REPORT.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocument I_ServiceDocument from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ISERVORDVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ServiceDocument view
VDM.viewType #BASIC view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Service Order Value Help view
Search.searchable true view
Consumption.ranked true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocument ServiceDocument
KEY ServiceDocumentType ServiceDocumentType
ServiceObjectType ServiceObjectType
ServiceDocumentDescription ServiceDocumentDescription
SoldToParty SoldToParty
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
Division Division
SalesOffice SalesOffice
SalesGroup SalesGroup
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
RespEmployeeBusinessPartnerId ResponsibleEmployee
RefInHouseRepairIsExisting RefInHouseRepairIsExisting
_ServiceDocumentType _ServiceDocumentType
_ServiceObjType _ServiceObjType
_SoldToParty _SoldToParty
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit _SalesGroupOrgUnit
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_SalesOrganization _SalesOrganization
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_DistributionChannel _DistributionChannel
_Division _Division
@AbapCatalog.sqlViewName: 'ISERVORDVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'ServiceDocument'
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #XL, dataClass: #TRANSACTIONAL }
@ObjectModel.supportedCapabilities: [#VALUE_HELP_PROVIDER]
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@EndUserText.label: 'Service Order Value Help'

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

define view I_ServiceOrderStdVH
  as select from I_ServiceDocument
{


      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key ServiceDocument,
      @Search: { ranking: #LOW,
      defaultSearchElement: true }
      @ObjectModel.foreignKey.association: '_ServiceDocumentType'
  key ServiceDocumentType,
      @ObjectModel.foreignKey.association: '_ServiceObjType'
      @Consumption.hidden: true
      ServiceObjectType,
      @Search: { defaultSearchElement: true, ranking: #LOW }
      ServiceDocumentDescription,

      //     @ObjectModel.foreignKey.association: '_RespEmployee'

      //     ResponsibleEmployee,

      @Search.ranking: #LOW
      @ObjectModel.foreignKey.association: '_SoldToParty'
      SoldToParty,
      @Search.ranking: #LOW
      @ObjectModel.foreignKey.association: '_SalesOrganization'
      SalesOrganization,
      @Search.ranking: #LOW
      @ObjectModel.foreignKey.association: '_DistributionChannel'
      DistributionChannel,
      @Search.ranking: #LOW
      @ObjectModel.foreignKey.association: '_Division'
      Division,
      @Search.ranking: #LOW
      @ObjectModel.foreignKey.association: '_SalesOffice'
      SalesOffice,
      @Search.ranking: #LOW
      @ObjectModel.foreignKey.association: '_SalesGroup'
      SalesGroup,
      @Search.ranking: #LOW
      @ObjectModel.foreignKey.association: '_SalesOrganizationOrgUnit_2'
      SalesOrganizationOrgUnitID,
      @Search.ranking: #LOW
      @ObjectModel.foreignKey.association: '_SalesOfficeOrgUnit_2'
      @UI.hidden: true
      SalesOfficeOrgUnitID,
      @Search.ranking: #LOW
      @ObjectModel.foreignKey.association: '_SalesGroupOrgUnit_2'
      @Consumption.hidden: true
      @UI.hidden: true
      SalesGroupOrgUnitID,
      @Search.ranking: #LOW
      ServiceOrganization,
      @Search.ranking: #LOW
      ResponsibleEmployee as RespEmployeeBusinessPartnerId,
      RefInHouseRepairIsExisting,
      _ServiceDocumentType,
      _ServiceObjType,
      //     _RespEmployee,

      _SoldToParty,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SalesOrganizationOrgUnit_2'
      _SalesOrganizationOrgUnit,
      _SalesOrganizationOrgUnit_2,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SalesOfficeOrgUnit_2'
      _SalesOfficeOrgUnit,
      _SalesOfficeOrgUnit_2,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_SalesGroupOrgUnit_2'
      _SalesGroupOrgUnit,
      _SalesGroupOrgUnit_2,
      _SalesOrganization,
      _SalesOffice,
      _SalesGroup,
      _DistributionChannel,
      _Division
}

where
      ServiceObjectType           = 'BUS2000116'

  and ServiceDocumentIsQuotation  = ' '
  and ServiceDocumentTemplateType = ' '