@AbapCatalog: {sqlViewName: 'IFIASSETCL', preserveKey: true}
@Analytics: { dataCategory: #DIMENSION }
@EndUserText.label: 'Asset Class'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { sapObjectNodeType.name: 'FixedAssetClass',
representativeKey: 'AssetClass',
usageType.serviceQuality: #A,
usageType.sizeCategory: #S,
usageType.dataClass: #CUSTOMIZING,
modelingPattern: #ANALYTICAL_DIMENSION,
supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE]
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata: {ignorePropagatedAnnotations: true, allowExtensions:true}
define view I_AssetClass
as select from faac_acls0
association [0..*] to I_AssetClassText as _Text on $projection.AssetClass = _Text.AssetClass
association [0..1] to I_AssetAcctDetermination as _AssetAcctDetermination on $projection.AssetAccountDetermination = _AssetAcctDetermination.AssetAccountDetermination
association [0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association [0..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association [0..1] to I_Country as _Country on $projection.AssetCountryOfOrigin = _Country.Country
association [0..1] to I_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier
association [0..1] to I_FixedAssetFinDataCmpltns as _FixedAssetFinDataCmpltns on $projection.FixedAssetFinDataCmpltns = _FixedAssetFinDataCmpltns.FixedAssetFinDataCmpltns
association [0..1] to I_FixedAssetPropertyType as _FixedAssetPropertyType on $projection.FixedAssetPropertyType = _FixedAssetPropertyType.FixedAssetPropertyType
association [0..1] to I_PropertyClass as _PropertyClass on $projection.PropertyClass = _PropertyClass.PropertyClass
association [0..1] to I_Group1AssetEvaluationKey as _Group1AssetEvaluationKey on $projection.Group1AssetEvaluationKey = _Group1AssetEvaluationKey.Group1AssetEvaluationKey
association [0..1] to I_Group2AssetEvaluationKey as _Group2AssetEvaluationKey on $projection.Group2AssetEvaluationKey = _Group2AssetEvaluationKey.Group2AssetEvaluationKey
association [0..1] to I_Group3AssetEvaluationKey as _Group3AssetEvaluationKey on $projection.Group3AssetEvaluationKey = _Group3AssetEvaluationKey.Group3AssetEvaluationKey
association [0..1] to I_Group4AssetEvaluationKey as _Group4AssetEvaluationKey on $projection.Group4AssetEvaluationKey = _Group4AssetEvaluationKey.Group4AssetEvaluationKey
association [0..1] to I_InvestmentReason as _InvestmentReason on $projection.InvestmentReason = _InvestmentReason.InvestmentReason
{
@ObjectModel.text.association: '_Text'
key asset_class as AssetClass,
@ObjectModel.foreignKey.association: '_AssetAcctDetermination'
gl_account_det as AssetAccountDetermination,
@VDM.lifecycle.status: #DEPRECATED
@ObjectModel.foreignKey.association: '_BusinessArea'
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_BusinessAreaStdVH', element: 'BusinessArea' } } ]
cast('' as gsber) as BusinessArea,
@VDM.lifecycle.status: #DEPRECATED
@ObjectModel.foreignKey.association: '_Plant'
cast('' as werks_d) as Plant,
@VDM.lifecycle.status: #DEPRECATED
cast('' as kostl) as CostCenter,
@VDM.lifecycle.status: #DEPRECATED
@ObjectModel.foreignKey.association: '_FixedAssetFinDataCmpltns'
cast('' as aneqs) as FixedAssetFinDataCmpltns,
@VDM.lifecycle.status: #DEPRECATED
@ObjectModel.foreignKey.association: '_Country'
cast('' as am_land1) as AssetCountryOfOrigin,
@VDM.lifecycle.status: #DEPRECATED
@ObjectModel.foreignKey.association: '_Supplier'
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_Supplier_VH', element: 'Supplier' } } ]
cast('' as am_lifnr) as Supplier,
@VDM.lifecycle.status: #DEPRECATED
cast('' as anlue) as FixedAssetGroup,
@VDM.lifecycle.status: #DEPRECATED
@ObjectModel.foreignKey.association: '_FixedAssetPropertyType'
cast('' as eigkz) as FixedAssetPropertyType,
@VDM.lifecycle.status: #DEPRECATED
@ObjectModel.foreignKey.association: '_PropertyClass'
cast('' as vmgli) as PropertyClass,
@VDM.lifecycle.status: #DEPRECATED
cast('' as invsl) as InvestmentSupportMeasure,
@VDM.lifecycle.status: #DEPRECATED
@ObjectModel.foreignKey.association: '_Group1AssetEvaluationKey'
cast('' as ord41) as Group1AssetEvaluationKey,
@VDM.lifecycle.status: #DEPRECATED
@ObjectModel.foreignKey.association: '_Group2AssetEvaluationKey'
cast('' as ord42) as Group2AssetEvaluationKey,
@VDM.lifecycle.status: #DEPRECATED
@ObjectModel.foreignKey.association: '_Group3AssetEvaluationKey'
cast('' as ord43) as Group3AssetEvaluationKey,
@VDM.lifecycle.status: #DEPRECATED
@ObjectModel.foreignKey.association: '_Group4AssetEvaluationKey'
cast('' as ord44) as Group4AssetEvaluationKey,
@VDM.lifecycle.status: #DEPRECATED
@ObjectModel.foreignKey.association: '_InvestmentReason'
cast('' as izwek) as InvestmentReason,
@Consumption.hidden: true
@VDM.lifecycle.status: #DEPRECATED
cast('NEW' as faa_authcntxt) as AssetAuthorizationContext, //Needed for DCL
//* Asscociations *//
_Text,
_AssetAcctDetermination,
@VDM.lifecycle.status: #DEPRECATED
_BusinessArea,
@VDM.lifecycle.status: #DEPRECATED
_Plant,
@VDM.lifecycle.status: #DEPRECATED
_Country,
@VDM.lifecycle.status: #DEPRECATED
_Supplier,
@VDM.lifecycle.status: #DEPRECATED
_FixedAssetFinDataCmpltns,
@VDM.lifecycle.status: #DEPRECATED
_FixedAssetPropertyType,
@VDM.lifecycle.status: #DEPRECATED
_PropertyClass,
@VDM.lifecycle.status: #DEPRECATED
_Group1AssetEvaluationKey,
@VDM.lifecycle.status: #DEPRECATED
_Group2AssetEvaluationKey,
@VDM.lifecycle.status: #DEPRECATED
_Group3AssetEvaluationKey,
@VDM.lifecycle.status: #DEPRECATED
_Group4AssetEvaluationKey,
@VDM.lifecycle.status: #DEPRECATED
_InvestmentReason
}