I_FixedAssetValueHelp

DDL: I_FIXEDASSETVALUEHELP Type: view COMPOSITE

Fixed Asset Value Help

I_FixedAssetValueHelp is a Composite CDS View that provides data about "Fixed Asset Value Help" in SAP S/4HANA. It reads from 1 data source (P_FixedAssetVH) and exposes 9 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset. It has 2 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
P_FixedAssetVH P_FixedAssetVH from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_MasterFixedAsset _MasterFixedAsset $projection.CompanyCode = _MasterFixedAsset.CompanyCode and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFIXASSETVH view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey FixedAsset 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
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Fixed Asset Value Help view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
FixedAssetDescription FixedAssetDescription
AssetClass AssetClass
AssetCapitalizationDate
AssetAuthorizationContext AssetAuthorizationContext
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset 
@AbapCatalog: {sqlViewName: 'IFIXASSETVH', preserveKey: true}
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@ObjectModel: { representativeKey: 'FixedAsset',
                dataCategory: #VALUE_HELP,
                usageType.serviceQuality: #C,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MASTER }
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Fixed Asset Value Help'

define view I_FixedAssetValueHelp
  as select from P_FixedAssetVH

  association [0..1] to I_CompanyCode      as _CompanyCode      on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_MasterFixedAsset as _MasterFixedAsset on  $projection.CompanyCode      = _MasterFixedAsset.CompanyCode
                                                                and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  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: #HIGH
      FixedAssetDescription,

      AssetClass,
      cast(AssetCapitalizationDate as aktivd preserving type) as AssetCapitalizationDate,
      @Consumption.hidden: true
      AssetAuthorizationContext, //Needed for DCL


      _CompanyCode,
      _MasterFixedAsset
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FIXEDASSETVH"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_MASTERFIXEDASSET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More