C_FixedAssetTP

DDL: C_FIXEDASSETTP Type: view_entity CONSUMPTION Package: FINS_FAA_MD_RAP_UI
90 Fields 1 Data Sources 1 OData Services

Fixed Asset Master Data

C_FixedAssetTP is a Consumption CDS View that provides data about "Fixed Asset Master Data" in SAP S/4HANA. It reads from 1 data source (R_FixedAssetTP) and exposes 90 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset. It is exposed through 1 OData service (UI_FIXEDASSET_MANAGE). Part of development package FINS_FAA_MD_RAP_UI.

Data Sources (1)

SourceAliasJoin Type
R_FixedAssetTP R_FixedAssetTP projection

Annotations (13)

NameValueLevelField
AccessControl.auditFilter #ENABLED view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Fixed Asset Master Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewCompositions true view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_FIXEDASSET_MANAGE UI_FIXEDASSET_MANAGE V4 C1 NOT_RELEASED

Fields (90)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
CompanyCodeName _CompanyCode CompanyCodeName Company Name
MasterFixedAssetFrmLegacySyst Fixed Asset
FixedAssetFrmLegacySyst Sub-number
AssetCompletenessStatus AssetCompletenessStatus
AssetCompletenessStatusName
AssetLifecycleStatus AssetLifecycleStatus
AssetLifecycleStatusName
AssetUnderConstructionStatus AssetUnderConstructionStatus
AssetUndrConstructionStsName
IsLegacyAsset IsLegacyAsset
AccountIsBlockedForPosting AccountIsBlockedForPosting Posting Block
AssetIsForPostCapitalization AssetIsForPostCapitalization
AssetClass AssetClass Asset Class
AssetClassName
AssetScreenLayout AssetScreenLayout
AssetAccountDetermination AssetAccountDetermination Account Determ.
AssetAccountDeterminationDesc
FixedAssetDescription FixedAssetDescription Description
AssetAdditionalDescription AssetAdditionalDescription
AssetSerialNumber AssetSerialNumber
FixedAssetOrderDate FixedAssetOrderDate
BaseUnit BaseUnit Unit of Measure
BaseUnitName
Supplier Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
AssetIsAcquiredUsed AssetIsAcquiredUsed
AssetCountryOfOrigin AssetCountryOfOrigin
CountryNamelocalized
AssetManufacturerName AssetManufacturerName Manufacturer
OriginalMasterFixedAsset OriginalMasterFixedAsset
OriginalFixedAsset OriginalFixedAsset
OriginalFixedAssetValueDate OriginalFixedAssetValueDate
OriginalAcquisitionFiscalYear OriginalAcquisitionFiscalYear
OriginalAcquisitionCurrency OriginalAcquisitionCurrency
OriginalAcquisitionAmount OriginalAcquisitionAmount
InHouseProdnPercent InHouseProdnPercent
AssetTypeName AssetTypeName
PartnerCompany PartnerCompany Trading Partner
PartnerCompanyName _PartnerCompany CompanyName Text
Inventory Inventory Ci Inventory
LastInventoryDate LastInventoryDate
InventoryNote InventoryNote
InventoryIsCounted InventoryIsCounted
LastReorganizationDate LastReorganizationDate
IsMainAsset IsMainAsset Leading Asset
LegacyMasterFixedAsset LegacyMasterFixedAsset
LegacyFixedAsset LegacyFixedAsset
LegacyFixedAssetCompanyCode LegacyFixedAssetCompanyCode
LegacyDataTransferDate LegacyDataTransferDate
LegacyDataTransferSequence LegacyDataTransferSequence
InvestmentProjectWBSElement InvestmentProjectWBSElement
InvmtProjWBSElementExternalID _InvestmentProjectWBSElement WBSElementExternalID WBS Element External ID
WBSDescription _InvestmentProjectWBSElement WBSDescription WBS Element Name
ProjectUUID _InvestmentProject ProjectUUID Project UUID
InvestmentOrder InvestmentOrder
InternalOrderDescription _InvestmentOrder InternalOrderDescription Description
ChangeDocObject ChangeDocObject Object Value
SAPObjectNodeType SAPObjectNodeType SONT Name
CreatedByUser CreatedByUser User Name
CreatedByUserDescription _UserCreatedBy UserDescription Full Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserDescription _UserChangedBy UserDescription Full Name
LastChangeDateTime LastChangeDateTime Timestamp
FixedAssetExternalID FixedAssetExternalID Asset Number
FxdAstIsTimeRstrcnTriggered FxdAstIsTimeRstrcnTriggered
AssetMultipleCreationStatus AssetMultipleCreationStatus
DepreciationErrorStatus DepreciationErrorStatus
virtualAssetTypeNameIsHdnabap_boolean
virtualInventoryNoteIsHdnabap_boolean
virtualInventoryIsHdnabap_boolean
virtualSupplierIsHdnabap_boolean
virtualPartnerCompanyIsHdnabap_boolean
virtualLegacyAssetIsHdnabap_boolean
_CompanyCode _CompanyCode
_AssetClass _AssetClass
_UnitOfMeasure _UnitOfMeasure
_PartnerCompany _PartnerCompany
_AssetAccountDetermination _AssetAccountDetermination
_Supplier _Supplier
_AssetCountryOfOrigin _AssetCountryOfOrigin
_AssetLifecycleStatus _AssetLifecycleStatus
_AssetCompletenessStatus _AssetCompletenessStatus
_AssetUnderConstructionStatus _AssetUnderConstructionStatus
_OriginalAcquisitionCurrency _OriginalAcquisitionCurrency
_UserCreatedBy _UserCreatedBy
_UserChangedBy _UserChangedBy

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_FixedAssetTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_FixedAssetTP AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast ( MasterFixedAsset as faa_md_asset_no_from_ldt preserving type) AS MasterFixedAssetFrmLegacySyst,
  cast (FixedAsset as faa_md_asset_subno_from_ldt preserving type ) AS FixedAssetFrmLegacySyst,
  AssetCompletenessStatus,
  _AssetCompletenessStatus._Text[1:Language = $session.system_language].AssetCompletenessStatusName AS AssetCompletenessStatusName,
  AssetLifecycleStatus,
  _AssetLifecycleStatus._Text[1:Language = $session.system_language].AssetLifecycleStatusName AS AssetLifecycleStatusName,
  AssetUnderConstructionStatus,
  _AssetUnderConstructionStatus._Text[1:Language = $session.system_language].AssetUndrConstructionStsName AS AssetUndrConstructionStsName,
  IsLegacyAsset,
  AccountIsBlockedForPosting,
  AssetIsForPostCapitalization,
  AssetClass,
  _AssetClass._Text[1:Language=$session.system_language].AssetClassName AS AssetClassName,
  AssetScreenLayout,
  AssetAccountDetermination,
  _AssetAccountDetermination._Text[1:Language=$session.system_language].AssetAccountDeterminationDesc AS AssetAccountDeterminationDesc,
  FixedAssetDescription,
  AssetAdditionalDescription,
  AssetSerialNumber,
  FixedAssetOrderDate,
  BaseUnit,
  _UnitOfMeasure._Text[1:Language=$session.system_language].UnitOfMeasureLongName AS BaseUnitName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  AssetIsAcquiredUsed,
  AssetCountryOfOrigin,
  _AssetCountryOfOrigin._Text.CountryName : localized AS CountryNamelocalized,
  AssetManufacturerName,
  OriginalMasterFixedAsset,
  OriginalFixedAsset,
  OriginalFixedAssetValueDate,
  OriginalAcquisitionFiscalYear,
  OriginalAcquisitionCurrency,
  OriginalAcquisitionAmount,
  InHouseProdnPercent,
  AssetTypeName,
  PartnerCompany,
  _PartnerCompany.CompanyName AS PartnerCompanyName,
  Inventory,
  LastInventoryDate,
  InventoryNote,
  InventoryIsCounted,
  LastReorganizationDate,
  IsMainAsset,
  LegacyMasterFixedAsset,
  LegacyFixedAsset,
  LegacyFixedAssetCompanyCode,
  LegacyDataTransferDate,
  LegacyDataTransferSequence,
  InvestmentProjectWBSElement,
  _InvestmentProjectWBSElement.WBSElementExternalID AS InvmtProjWBSElementExternalID,
  _InvestmentProjectWBSElement.WBSDescription AS WBSDescription,
  _InvestmentProject.ProjectUUID AS ProjectUUID,
  InvestmentOrder,
  _InvestmentOrder.InternalOrderDescription AS InternalOrderDescription,
  ChangeDocObject,
  SAPObjectNodeType,
  CreatedByUser,
  _UserCreatedBy.UserDescription AS CreatedByUserDescription,
  CreationDateTime,
  LastChangedByUser,
  _UserChangedBy.UserDescription AS LastChangedByUserDescription,
  LastChangeDateTime,
  FixedAssetExternalID,
  FxdAstIsTimeRstrcnTriggered,
  AssetMultipleCreationStatus,
  DepreciationErrorStatus,
  virtual AssetTypeNameIsHdn : abap_boolean AS virtualAssetTypeNameIsHdnabap_boolean,
  virtual InventoryNoteIsHdn : abap_boolean AS virtualInventoryNoteIsHdnabap_boolean,
  virtual InventoryIsHdn : abap_boolean AS virtualInventoryIsHdnabap_boolean,
  virtual SupplierIsHdn : abap_boolean AS virtualSupplierIsHdnabap_boolean,
  virtual PartnerCompanyIsHdn : abap_boolean AS virtualPartnerCompanyIsHdnabap_boolean,
  virtual LegacyAssetIsHdn : abap_boolean AS virtualLegacyAssetIsHdnabap_boolean
FROM R_FixedAssetTP
;

Learn More