R_WorkAssignmentDataSourceVH

DDL: R_WORKASSIGNMENTDATASOURCEVH Type: view_entity TRANSACTIONAL

Maintenance Source

R_WorkAssignmentDataSourceVH is a Transactional CDS View that provides data about "Maintenance Source" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field WorkAssignmentDataSource.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
dd07l FixedValue from

Annotations (13)

NameValueLevelField
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.resultSet.sizeCategory #XS view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maintenance Source view
ObjectModel.representativeKey WorkAssignmentDataSource view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentDataSource
ddtextasOriginalStatusText 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@ObjectModel.dataCategory:#VALUE_HELP
@ObjectModel : { resultSet.sizeCategory: #XS }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Maintenance Source'
@ObjectModel.representativeKey:'WorkAssignmentDataSource'
@Consumption.ranked:true
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Search.searchable: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #MASTER
}

define view entity R_WorkAssignmentDataSourceVH
  as select from           dd07l as FixedValue
    left outer to one join dd07t as ValueText on  FixedValue.domname    = ValueText.domname
                                              and FixedValue.domvalue_l = ValueText.domvalue_l
                                              and FixedValue.as4local   = ValueText.as4local
{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking:#HIGH
  key cast (FixedValue.domvalue_l as wfd_data_source ) as WorkAssignmentDataSource,
      @Semantics.text: true -- identifies the text field
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      ValueText.ddtext                                 as OriginalStatusText
}

where
      FixedValue.as4local  = 'A' --Active
  and FixedValue.domname   = 'BUM_WF_DATA_SOURCE'
  and ValueText.ddlanguage = $session.system_language
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L",
"DD07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More