R_FIXEDASSETUSAGEOBJECTTP

CDS View

Fixed Asset Usage Object

R_FIXEDASSETUSAGEOBJECTTP is a CDS View in S/4HANA. Fixed Asset Usage Object. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_FixedAssetUsageObject view_entity projection CONSUMPTION Fixed Asset Usage Object
C_FixedAssetUsageObjectTP view_entity projection CONSUMPTION Fixed Asset Usage Object
I_FixedAssetUsageObjectTP view_entity projection TRANSACTIONAL Fixed Asset Usage Object - TP 
//@AbapCatalog.sqlViewName: 'RFIXASSETUO'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

//@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'Fixed Asset Usage Object'

@ObjectModel.sapObjectNodeType.name: 'FixedAssetUsageObject'
@ObjectModel.representativeKey: 'FixedAssetUsageObject'
@ObjectModel.usageType: {
        serviceQuality: #A,
        sizeCategory: #XL,
        dataClass: #MASTER
}


define root view entity R_FixedAssetUsageObjectTP

  as select from I_FixedAssetUsageObject
  composition [0..*] of R_FixedAssetUsageObjectPerdTP as _UsageObjectPeriod
  composition [0..*] of R_FixedAssetUsageObjectTotTP  as _UsageObjectTotal
  //  composition [0..*] of R_FixedAssetUsageObjWhereUsdTP as _UsageObjectWhereUsed


{

  key    CompanyCode,


  key    FixedAssetUsageObject,

         concat( rpad( CompanyCode, 4, ' ' ), FixedAssetUsageObject )                                      as ChangeDocTableKey,

         FixedAssetUsageObjectDesc,

         BaseUnit,

         FixedAssetUsageObjLfcycSts,


         cast (case
              when FixedAssetUsageObjLfcycSts = '1' then 'X'
              else cast ( '' as abap.char(1) )
          end
         as faa_uo_is_active preserving type )                                                          as IsActive,

         CreationDateTime,

         CreatedByUser,

         LastChangeDateTime,
         
//         DraftLastChangedDateTime,

          
         LastChangedByUser,

         _CompanyCode,

         _UnitOfMeasure,

         _UsageObjectLifecycleStatus,

         _UsageObjectPeriod,

         _UsageObjectTotal

}

Learn More