I_FixedAssetFromLegacySystemVH

DDL: I_FIXEDASSETFROMLEGACYSYSTEMVH SQL: IFILGFXDAST_VH Type: view COMPOSITE Package: FINS_FAA_MD_BOPF

Legacy Asset Value Help

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

Data Sources (1)

SourceAliasJoin Type
I_FixedAsset I_FixedAsset from

Annotations (15)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
FixedAssetDescription FixedAssetDescription
IsMainAsset IsMainAsset
AssetClass AssetClass
AssetAuthorizationContext AssetAuthorizationContext
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset
@AbapCatalog.sqlViewName: 'IFILGFXDAST_VH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #COMPOSITE

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'FixedAsset'

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER


@ClientHandling.algorithm: #SESSION_VARIABLE

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

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Legacy Asset Value Help'
define view I_FixedAssetFromLegacySystemVH

  as select from I_FixedAsset
{

      @ObjectModel.foreignKey.association: '_CompanyCode'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 1.0
      @Search.ranking: #LOW
  key CompanyCode,
      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key MasterFixedAsset,
      @ObjectModel.text.element: ['FixedAssetDescription']
  key FixedAsset,


      @Semantics.text:true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      FixedAssetDescription,
      
      @UI.hidden:true
      IsMainAsset,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 1.0
      @Search.ranking: #LOW
      AssetClass,
      @Consumption.hidden: true
      AssetAuthorizationContext, //Needed for DCL


      @Consumption.hidden: true
      _CompanyCode,
      @Consumption.hidden: true
      _MasterFixedAsset

}
where 
      LegacyDataTransferDate is not null 
  and LegacyDataTransferDate <> '00000000'