I_FixedAssetUsageObjWhereUsd

DDL: I_FIXEDASSETUSAGEOBJWHEREUSD SQL: IFIXASSETUOWUL Type: view COMPOSITE

Where used of Fixed Asset Usage Object

I_FixedAssetUsageObjWhereUsd is a Composite CDS View that provides data about "Where used of Fixed Asset Usage Object" in SAP S/4HANA. It reads from 1 data source (I_AssetTimeBasedValuation) and exposes 11 fields with key fields CompanyCode, FixedAssetUsageObject, MasterFixedAsset, FixedAsset. It has 4 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_AssetTimeBasedValuation AssetTimeBasedValuationTP inner

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_FixedAssetUsageObject _UsageObject $projection.CompanyCode = _UsageObject.CompanyCode and $projection.FixedAssetUsageObject = _UsageObject.FixedAssetUsageObject
[0..1] I_MasterFixedAsset _MasterFixedAsset $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset and $projection.CompanyCode = _MasterFixedAsset.CompanyCode
[1..1] I_FixedAsset _FixedAsset $projection.CompanyCode = _FixedAsset.CompanyCode and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset
[0..1] I_AssetClass _AssetClass $projection.assetclass = _AssetClass.AssetClass

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFIXASSETUOWUL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label Where used of Fixed Asset Usage Object view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode UsageObject CompanyCode
KEY FixedAssetUsageObject UsageObject FixedAssetUsageObject
KEY MasterFixedAsset I_AssetTimeBasedValuation MasterFixedAsset
KEY FixedAsset I_AssetTimeBasedValuation FixedAsset
FixedAssetDescription
AssetClass
_UsageObject _UsageObject
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_AssetClass _AssetClass 
@AbapCatalog.sqlViewName: 'IFIXASSETUOWUL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Where used of Fixed Asset Usage Object'
@ObjectModel.usageType: {
        serviceQuality: #C,
        sizeCategory: #XL,
        dataClass: #MASTER
}


define view I_FixedAssetUsageObjWhereUsd
  as select distinct from I_FixedAssetUsageObject   as UsageObject
    inner join            I_AssetTimeBasedValuation as AssetTimeBasedValuationTP on  AssetTimeBasedValuationTP.CompanyCode           = UsageObject.CompanyCode
                                                                                 and AssetTimeBasedValuationTP.FixedAssetUsageObject = UsageObject.FixedAssetUsageObject

  association [1..1] to I_FixedAssetUsageObject as _UsageObject      on  $projection.CompanyCode           = _UsageObject.CompanyCode
                                                                     and $projection.FixedAssetUsageObject = _UsageObject.FixedAssetUsageObject

  association [0..1] to I_MasterFixedAsset      as _MasterFixedAsset on  $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
                                                                     and $projection.CompanyCode      = _MasterFixedAsset.CompanyCode
  
  association [1..1] to I_FixedAsset            as _FixedAsset       on  $projection.CompanyCode      = _FixedAsset.CompanyCode
                                                                     and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
                                                                     and $projection.FixedAsset       = _FixedAsset.FixedAsset
  
  association [0..1] to I_AssetClass            as _AssetClass       on  $projection.assetclass = _AssetClass.AssetClass

{

          @ObjectModel.foreignKey.association: '_CompanyCode'
  key     UsageObject.CompanyCode           as CompanyCode,

          @ObjectModel.foreignKey.association: '_UsageObject'
  key     UsageObject.FixedAssetUsageObject as FixedAssetUsageObject,

          @ObjectModel.foreignKey.association: '_MasterFixedAsset'
  key     AssetTimeBasedValuationTP.MasterFixedAsset,

          @ObjectModel.foreignKey.association: '_FixedAsset'         
  key     AssetTimeBasedValuationTP.FixedAsset,

          @Semantics.text: true
          AssetTimeBasedValuationTP._FixedAsset.FixedAssetDescription,

          @ObjectModel.foreignKey.association: '_AssetClass'
          AssetTimeBasedValuationTP._FixedAsset.AssetClass,

          @ObjectModel.association.type: [#TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT]
          _UsageObject,
          
          _CompanyCode,
          _MasterFixedAsset,
          _FixedAsset,
          _AssetClass

}

// TODO: dirty data in ER9. To be removed after no issues with Number range

where
  UsageObject.FixedAssetUsageObject is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ASSETTIMEBASEDVALUATION",
"I_FIXEDASSET",
"I_FIXEDASSETUSAGEOBJECT"
],
"ASSOCIATED":
[
"I_ASSETCLASS",
"I_COMPANYCODE",
"I_FIXEDASSET",
"I_FIXEDASSETUSAGEOBJECT",
"I_MASTERFIXEDASSET"
],
"BASE":
[
"I_FIXEDASSETUSAGEOBJECT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More