R_FixedAssetTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_FixedAsset | FixedAsset | from |
Associations (11)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA