I_MM_FixedAssetValueHelp

DDL: I_MM_FIXEDASSETVALUEHELP SQL: IMMFXDAST Type: view COMPOSITE Package: ODATA_MM_COMMONS_VH

Purchasing Fixed Asset Value Help

I_MM_FixedAssetValueHelp is a Composite CDS View that provides data about "Purchasing Fixed Asset Value Help" in SAP S/4HANA. It reads from 1 data source (I_FixedAssetValueHelp) and exposes 9 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset. Part of development package ODATA_MM_COMMONS_VH.

Data Sources (1)

SourceAliasJoin Type
I_FixedAssetValueHelp FixedAsset from

Annotations (16)

NameValueLevelField
VDM.viewType #COMPOSITE view
EndUserText.label Purchasing Fixed Asset Value Help view
AbapCatalog.sqlViewName IMMFXDAST view
AbapCatalog.compiler.compareFilter true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey FixedAsset view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Consumption.ranked true view
Metadata.allowExtensions true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FixedAssetValueHelp CompanyCode
KEY MasterFixedAsset I_FixedAssetValueHelp MasterFixedAsset
KEY FixedAsset I_FixedAssetValueHelp FixedAsset
FixedAssetDescription I_FixedAssetValueHelp FixedAssetDescription
AssetClass I_FixedAssetValueHelp AssetClass
AssetAuthorizationContext I_FixedAssetValueHelp AssetAuthorizationContext
AssetCapitalizationDate I_FixedAssetValueHelp AssetCapitalizationDate
_MasterFixedAsset _MasterFixedAsset
_CompanyCode _CompanyCode
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Purchasing Fixed Asset Value Help'
@AbapCatalog.sqlViewName: 'IMMFXDAST'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory:  #XXL
@ObjectModel.usageType.dataClass: #MASTER

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
  semanticKey: [ 'CompanyCode', 'MasterFixedAsset', 'FixedAsset' ],
  representativeKey: 'FixedAsset'
}
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true
@Consumption.ranked: true
@Metadata.allowExtensions: true //3224355


define view I_MM_FixedAssetValueHelp
  as select from I_FixedAssetValueHelp as FixedAsset

{
      //Need to check this

      @UI.hidden: true
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key FixedAsset.CompanyCode               as CompanyCode,

      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
      @Search: { defaultSearchElement: true, ranking: #HIGH }
  key FixedAsset.MasterFixedAsset          as MasterFixedAsset,

      @ObjectModel.text.element:  'FixedAssetDescription'
      @Search: { defaultSearchElement: true, ranking: #HIGH }
  key FixedAsset.FixedAsset                as FixedAsset,

      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      FixedAsset.FixedAssetDescription     as FixedAssetDescription,

      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      FixedAsset.AssetClass                as AssetClass,

      @Consumption.hidden: true
      FixedAsset.AssetAuthorizationContext as AssetAuthorizationContext,

      FixedAsset.AssetCapitalizationDate   as AssetCapitalizationDate,

      _MasterFixedAsset,

      _CompanyCode
}