FAA_PFixedAssetValueHelp

DDL: FAA_PFIXEDASSETVALUEHELP Type: view

FAA_PFixedAssetValueHelp is a CDS View in SAP S/4HANA. It reads from 2 data sources (I_FixedAsset, I_FixedAssetAssgmt) and exposes 12 fields with key fields bukrs, anln1, anln2, bdatu.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_FixedAsset I_FixedAsset from
I_FixedAssetAssgmt I_FixedAssetAssgmt left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FAADVPFXAVH view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY bukrs I_FixedAsset CompanyCode
KEY anln1 I_FixedAsset MasterFixedAsset
KEY anln2 I_FixedAsset FixedAsset
KEY bdatu I_FixedAssetAssgmt ValidityEndDate
adatu I_FixedAssetAssgmt ValidityStartDate
anlkl AssetClass
mcoa1 FixedAssetDescription
kostl I_FixedAssetAssgmt CostCenter
werks I_FixedAssetAssgmt Plant
prctr I_FixedAssetAssgmt ProfitCenter
gsber I_FixedAssetAssgmt BusinessArea
AssetAuthorizationContext I_FixedAsset AssetAuthorizationContext 
@AbapCatalog: {sqlViewName: 'FAADVPFXAVH', preserveKey: true}
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {
     serviceQuality: #C,
     sizeCategory: #XXL,
     dataClass: #MASTER
}
@ObjectModel.dataCategory: #VALUE_HELP
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true

define view FAA_PFixedAssetValueHelp

  as select from    I_FixedAsset
    left outer join I_FixedAssetAssgmt on  I_FixedAsset.CompanyCode      = I_FixedAssetAssgmt.CompanyCode
                                       and I_FixedAsset.MasterFixedAsset = I_FixedAssetAssgmt.MasterFixedAsset
                                       and I_FixedAsset.FixedAsset       = I_FixedAssetAssgmt.FixedAsset
{
  key I_FixedAsset.CompanyCode             as bukrs,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key I_FixedAsset.MasterFixedAsset        as anln1,
  key I_FixedAsset.FixedAsset              as anln2,
  key I_FixedAssetAssgmt.ValidityEndDate   as bdatu,

      I_FixedAssetAssgmt.ValidityStartDate as adatu,

      AssetClass                           as anlkl,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      FixedAssetDescription                as mcoa1,
      I_FixedAssetAssgmt.CostCenter        as kostl,
      I_FixedAssetAssgmt.Plant             as werks,
      I_FixedAssetAssgmt.ProfitCenter      as prctr,
      I_FixedAssetAssgmt.BusinessArea      as gsber,
      
      @Consumption.hidden: true
      I_FixedAsset.AssetAuthorizationContext //Needed for DCL          

}

Learn More