R_FixedAssetTP

DDL: R_FIXEDASSETTP Type: view_entity TRANSACTIONAL Package: FINS_FAA_MD_RAP_BO

Fixed Asset

R_FixedAssetTP is a Transactional CDS View that provides data about "Fixed Asset" in SAP S/4HANA. It reads from 1 data source (I_FixedAsset) and exposes 115 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset. It has 11 associations to related views. Part of development package FINS_FAA_MD_RAP_BO.

Data Sources (1)

SourceAliasJoin Type
I_FixedAsset FixedAsset from

Associations (11)

CardinalityTargetAliasCondition
[1..1] E_FixedAsset _Extension $projection.CompanyCode = _Extension.CompanyCode and $projection.MasterFixedAsset = _Extension.MasterFixedAsset and $projection.FixedAsset = _Extension.FixedAsset
[0..1] I_PPM_ProjectTask _InvestmentProject $projection.InvestmentProjectWBSElement = _InvestmentProject.WBSElementInternalID and _InvestmentProject.WBSElementInternalID is not initial
[0..1] I_WBSElementBasicData _InvestmentProjectWBSElement $projection.InvestmentProjectWBSElement = _InvestmentProjectWBSElement.WBSElementInternalID
[0..*] I_ChangeDocument_2 _ChangeDocument _ChangeDocument.ChangeDocObjectClass = 'FAA_MD' and _ChangeDocument.ChangeDocObject = $projection.ChangeDocObject
[0..1] I_UserContactCard _UserCreatedBy $projection.CreatedByUser = _UserCreatedBy.ContactCardID
[0..1] I_UserContactCard _UserChangedBy $projection.LastChangedByUser = _UserChangedBy.ContactCardID
[0..*] I_HDMRelationTP _HDMRelation $projection.ChangeDocObject = _HDMRelation.LinkedSAPObjectKey and $projection.SAPObjectNodeType = _HDMRelation.SAPObjectNodeType
[1..*] R_FixedAssetAssignmentTP _FixedAssetAssgmt
[0..*] R_FixedAssetLedgerTP _FixedAssetLedger
[0..*] R_FixedAssetValuationTP _FixedAssetValuation
[0..*] R_FixedAssetMultipleCreationTP _FixedAssetMultipleCreation

Annotations (14)

NameValueLevelField
EndUserText.label Fixed Asset view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.lifecycle.enqueue.expiryBehavior #RELATIVE_TO_ENQUEUE_START view
ObjectModel.lifecycle.enqueue.expiryInterval PT15M view
ObjectModel.sapObjectNodeType.name FixedAsset view
ObjectModel.uniqueIdField ChangeDocObject view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewCompositions true view

Fields (115)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
SAPObjectNodeType
FixedAssetExternalID FixedAssetExternalID
AssetCompletenessStatus AssetCompletenessStatus
AssetLifecycleStatus AssetLifecycleStatus
AssetUnderConstructionStatus AssetUnderConstructionStatus
IsMainAsset IsMainAsset
HasHistory HasHistory
AccountIsBlockedForPosting AccountIsBlockedForPosting
AssetIsForPostCapitalization AssetIsForPostCapitalization
AssetCreationValidityDate AssetCreationValidityDate
AssetClass AssetClass
AssetScreenLayout AssetScreenLayout
AssetAccountDetermination AssetAccountDetermination
FixedAssetDescription FixedAssetDescription
AssetAdditionalDescription AssetAdditionalDescription
AssetSerialNumber AssetSerialNumber
FixedAssetOrderDate FixedAssetOrderDate
BaseUnit BaseUnit
Supplier Supplier
AssetIsAcquiredUsed AssetIsAcquiredUsed
AssetCountryOfOrigin AssetCountryOfOrigin
AssetManufacturerName AssetManufacturerName
OriginalMasterFixedAsset OriginalMasterFixedAsset
OriginalFixedAsset OriginalFixedAsset
OriginalFixedAssetValueDate OriginalFixedAssetValueDate
OriginalAcquisitionFiscalYear OriginalAcquisitionFiscalYear
OriginalAcquisitionCurrency OriginalAcquisitionCurrency
OriginalAcquisitionAmount OriginalAcquisitionAmount
InHouseProdnPercent InHouseProdnPercent
AssetTypeName AssetTypeName
PartnerCompany PartnerCompany
Inventory Inventory
LastInventoryDate LastInventoryDate
InventoryNote InventoryNote
InventoryIsCounted InventoryIsCounted
InvestmentReason InvestmentReason
EnvrnmtlInvestmentReason EnvrnmtlInvestmentReason
FixedAssetGroup FixedAssetGroup
LocalTaxOffice LocalTaxOffice
NoticeOfAssessmentTaxID NoticeOfAssessmentTaxID
LastAssessmentNoticeDate LastAssessmentNoticeDate
Municipality Municipality
LandRegisterDate LandRegisterDate
LandRegisterEntrySequence LandRegisterEntrySequence
LandRegisterEntryDate LandRegisterEntryDate
LandRegisterVolume LandRegisterVolume
LandRegisterPage LandRegisterPage
LandRegisterMap LandRegisterMap
LandPlot LandPlot
ConveyanceDate ConveyanceDate
AreaSize AreaSize
AreaSizeUnit AreaSizeUnit
AssetIsRealEstate AssetIsRealEstate
LeaseSupplier LeaseSupplier
LeaseAgreement LeaseAgreement
LeaseAgreementDate LeaseAgreementDate
LeaseTermEndDate LeaseTermEndDate
LeaseTermStartDate LeaseTermStartDate
LeaseDurationInFiscalYears LeaseDurationInFiscalYears
LeaseDurationInFiscalPeriods LeaseDurationInFiscalPeriods
LeaseType LeaseType
LeasedAssetNote LeasedAssetNote
PropertyClass PropertyClass
FixedAssetPropertyType FixedAssetPropertyType
LastReorganizationDate LastReorganizationDate
LegacyMasterFixedAsset LegacyMasterFixedAsset
LegacyFixedAsset LegacyFixedAsset
LegacyFixedAssetCompanyCode LegacyFixedAssetCompanyCode
LegacyDataTransferDate LegacyDataTransferDate
LegacyDataTransferSequence LegacyDataTransferSequence
ObjectInternalID ObjectInternalID
InvestmentProjectWBSElement InvestmentProjectWBSElement_2
InvestmentOrder InvestmentOrder
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
LastChangeDateTime LastChangeDateTime
FixedAssetCallerCode
IsChanged
FxdAstIsRecalculateTriggered
FxdAstIsTimeRstrcnTriggered
AssetMultipleCreationStatus
DepreciationErrorStatus
_FixedAssetAssgmt _FixedAssetAssgmt
_FixedAssetLedger _FixedAssetLedger
_FixedAssetValuation _FixedAssetValuation
_FixedAssetMultipleCreation _FixedAssetMultipleCreation
_InvestmentProject _InvestmentProject
_InvestmentProjectWBSElement _InvestmentProjectWBSElement
_CompanyCode _CompanyCode
_MasterFixedAsset _MasterFixedAsset
_AssetClass _AssetClass
_UnitOfMeasure _UnitOfMeasure
_PartnerCompany _PartnerCompany
_AssetAccountDetermination _AssetAccountDetermination
_Supplier _Supplier
_AssetCountryOfOrigin _AssetCountryOfOrigin
_InvestmentReason _InvestmentReason
_EnvrnmtlInvestmentReason _EnvrnmtlInvestmentReason
_FixedAssetPropertyType _FixedAssetPropertyType
_FixedAssetGroup _FixedAssetGroup
_InvestmentOrder _InvestmentOrder
_AssetLifecycleStatus _AssetLifecycleStatus
_AssetCompletenessStatus _AssetCompletenessStatus
_AssetUnderConstructionStatus _AssetUnderConstructionStatus
_OriginalAcquisitionCurrency _OriginalAcquisitionCurrency
_ChangeDocument _ChangeDocument
_UserCreatedBy _UserCreatedBy
_UserChangedBy _UserChangedBy
_HDMRelation _HDMRelation
@EndUserText.label: 'Fixed Asset'
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.privilegedAssociations: [ '_ChangeDocument', '_UserCreatedBy', '_UserChangedBy', '_HDMRelation' ]
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  semanticKey : ['CompanyCode', 'MasterFixedAsset', 'FixedAsset'],
  usageType: {
        serviceQuality: #B,
        sizeCategory: #XXL,
        dataClass: #MASTER
    },
  lifecycle.enqueue.expiryBehavior: #RELATIVE_TO_ENQUEUE_START,
  lifecycle.enqueue.expiryInterval: 'PT15M'
 }
@ObjectModel.sapObjectNodeType.name: 'FixedAsset'
@ObjectModel.uniqueIdField: 'ChangeDocObject'
@AbapCatalog.extensibility: {
  extensible: true,
  allowNewCompositions: true
}

@Consumption.dbHints: [ '&PREFER_JOIN_WITH_FDA 0&', 'USE_HEX_PLAN' ]

define root view entity R_FixedAssetTP
  as select from I_FixedAsset as FixedAsset

  composition [1..*] of R_FixedAssetAssignmentTP       as _FixedAssetAssgmt

  composition [0..*] of R_FixedAssetLedgerTP           as _FixedAssetLedger

  composition [0..*] of R_FixedAssetValuationTP        as _FixedAssetValuation

  composition [0..*] of R_FixedAssetMultipleCreationTP as _FixedAssetMultipleCreation

  association [1..1] to E_FixedAsset                   as _Extension                   on  $projection.CompanyCode      = _Extension.CompanyCode
                                                                                       and $projection.MasterFixedAsset = _Extension.MasterFixedAsset
                                                                                       and $projection.FixedAsset       = _Extension.FixedAsset
  association [0..1] to I_PPM_ProjectTask              as _InvestmentProject           on  $projection.InvestmentProjectWBSElement = _InvestmentProject.WBSElementInternalID
                                                                                       and _InvestmentProject.WBSElementInternalID is not initial
  association [0..1] to I_WBSElementBasicData          as _InvestmentProjectWBSElement on  $projection.InvestmentProjectWBSElement = _InvestmentProjectWBSElement.WBSElementInternalID
  association [0..*] to I_ChangeDocument_2             as _ChangeDocument              on  _ChangeDocument.ChangeDocObjectClass = 'FAA_MD'
                                                                                       and _ChangeDocument.ChangeDocObject      = $projection.ChangeDocObject
  association [0..1] to I_UserContactCard              as _UserCreatedBy               on  $projection.CreatedByUser = _UserCreatedBy.ContactCardID
  association [0..1] to I_UserContactCard              as _UserChangedBy               on  $projection.LastChangedByUser = _UserChangedBy.ContactCardID
  association [0..*] to I_HDMRelationTP                as _HDMRelation                 on  $projection.ChangeDocObject   = _HDMRelation.LinkedSAPObjectKey
                                                                                       and $projection.SAPObjectNodeType = _HDMRelation.SAPObjectNodeType

  //Current TDD

  //  association [1..1] to R_FixedAssetAssignmentTP       as _CurrentTDD                  on  $projection.CompanyCode       = _CurrentTDD.CompanyCode

  //                                                                                       and $projection.MasterFixedAsset  = _CurrentTDD.MasterFixedAsset

  //                                                                                       and $projection.FixedAsset        = _CurrentTDD.FixedAsset

  //                                                                                       and _CurrentTDD.ValidityStartDate <= $session.system_date

  //                                                                                       and _CurrentTDD.ValidityEndDate   >= $session.system_date


{
  key   CompanyCode,

  key   MasterFixedAsset,

  key   FixedAsset,

        case when length( CompanyCode ) =  4 then cast( concat( concat( CompanyCode, MasterFixedAsset ), FixedAsset ) as cdobjectv )
             else cast( concat( concat_with_space( CompanyCode, MasterFixedAsset, 1 ), FixedAsset ) as cdobjectv )
        end                                                                     as ChangeDocObject,

        cast('FixedAsset' as abap.char( 30 ))                                   as SAPObjectNodeType,

        FixedAssetExternalID,

        AssetCompletenessStatus,

        AssetLifecycleStatus,

        AssetUnderConstructionStatus,

        IsMainAsset,

        HasHistory,

        AccountIsBlockedForPosting,

        cast(
            (case
              when LegacyDataTransferDate is not null and LegacyDataTransferDate <> '00000000' then 'X'
              else cast ( '' as abap.char(1))
             end
            ) as faa_md_xlegacyasset )                                          as IsLegacyAsset,

        AssetIsForPostCapitalization,

        AssetCreationValidityDate,

        AssetClass,

        AssetScreenLayout,

        AssetAccountDetermination,

        //General

        FixedAssetDescription,

        AssetAdditionalDescription,

        AssetSerialNumber,

        FixedAssetOrderDate,

        BaseUnit,

        //Origin

        Supplier,

        AssetIsAcquiredUsed,

        AssetCountryOfOrigin,

        AssetManufacturerName,

        OriginalMasterFixedAsset,

        OriginalFixedAsset,

        OriginalFixedAssetValueDate,

        OriginalAcquisitionFiscalYear,

        OriginalAcquisitionCurrency,
        @Semantics.amount.currencyCode: 'OriginalAcquisitionCurrency'
        OriginalAcquisitionAmount,

        InHouseProdnPercent,

        AssetTypeName,

        PartnerCompany,

        //Inventory

        Inventory,

        LastInventoryDate,

        InventoryNote,

        InventoryIsCounted,

        //Allocation

        InvestmentReason,

        EnvrnmtlInvestmentReason,

        FixedAssetGroup,

        //RealEstate

        LocalTaxOffice,

        NoticeOfAssessmentTaxID,

        LastAssessmentNoticeDate,

        Municipality,

        LandRegisterDate,

        LandRegisterEntrySequence,

        LandRegisterEntryDate,

        LandRegisterVolume,

        LandRegisterPage,

        LandRegisterMap,

        LandPlot,

        ConveyanceDate,

        @Semantics.quantity.unitOfMeasure: 'AreaSizeUnit'
        AreaSize,

        AreaSizeUnit,

        AssetIsRealEstate,

        //Leasing

        LeaseSupplier,

        LeaseAgreement,

        LeaseAgreementDate,

        LeaseTermEndDate,

        LeaseTermStartDate,

        LeaseDurationInFiscalYears,

        LeaseDurationInFiscalPeriods,

        LeaseType,

        LeasedAssetNote,

        //Property

        PropertyClass,

        FixedAssetPropertyType,

        //Org Change

        LastReorganizationDate,

        //Legacy Information


        LegacyMasterFixedAsset,

        LegacyFixedAsset,

        LegacyFixedAssetCompanyCode,

        LegacyDataTransferDate,

        LegacyDataTransferSequence,


        //AUC

        @Consumption.hidden: true
        ObjectInternalID, //For AuC ANLI


        //Origianl InvestmentProjectWBSElement is with conversion and deprecated in I View

        InvestmentProjectWBSElement_2                                           as InvestmentProjectWBSElement,

        InvestmentOrder, //Not supported yet


        //Admin

        @Semantics.user.createdBy: true
        CreatedByUser,

        CreationDate,
        @Semantics.systemDateTime.createdAt: true
        CreationDateTime,
        @Semantics.user.lastChangedBy: true
        LastChangedByUser,

        LastChangeDate,
        @Semantics.systemDateTime.localInstanceLastChangedAt: true
        @Semantics.systemDateTime.lastChangedAt: true
        LastChangeDateTime,

        //Technical

        @Consumption.hidden: true //Added from CE2108 for technical usage

        cast (cast('' as abap.char(2)) as faa_md_caller_code preserving type  ) as FixedAssetCallerCode,
        @Consumption.hidden: true
        cast( '' as abap_boolean preserving type )                              as IsChanged,
        @Consumption.hidden: true
        cast( '' as abap_boolean preserving type )                              as FxdAstIsRecalculateTriggered,

        cast( '' as abap_boolean preserving type )                              as FxdAstIsTimeRstrcnTriggered,

        cast( '' as faa_md_multi_creation_status preserving type )              as AssetMultipleCreationStatus,

        //Filter only, DO NOT use for other purpose

        cast('' as xafar)                                                       as DepreciationErrorStatus,


        _FixedAssetAssgmt,

        _FixedAssetLedger,

        _FixedAssetValuation,

        _FixedAssetMultipleCreation,

        _InvestmentProject,

        _InvestmentProjectWBSElement,

        _CompanyCode,
        _MasterFixedAsset,
        _AssetClass,
        _UnitOfMeasure,
        _PartnerCompany,
        _AssetAccountDetermination,
        _Supplier,
        _AssetCountryOfOrigin,
        _InvestmentReason,
        _EnvrnmtlInvestmentReason,
        _FixedAssetPropertyType,
        _FixedAssetGroup,
        _InvestmentOrder,
        _AssetLifecycleStatus,
        _AssetCompletenessStatus,
        _AssetUnderConstructionStatus,
        _OriginalAcquisitionCurrency,
        _ChangeDocument,
        _UserCreatedBy,
        _UserChangedBy,
        _HDMRelation
        //        ,_CurrentTDD

}