What is C_FixedAssetTimeBasedValnTP in SAP S/4HANA?

C_FixedAssetTimeBasedValnTP is a consumption CDS view in SAP S/4HANA. Fixed Asset Time Based Valuation It contains 53 fields.

Which tables does C_FixedAssetTimeBasedValnTP read from?

C_FixedAssetTimeBasedValnTP reads data from: R_FixedAssetTimeBasedValnTP.

What VDM layer is C_FixedAssetTimeBasedValnTP?

C_FixedAssetTimeBasedValnTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_FixedAssetTimeBasedValnTP

DDL: C_FIXEDASSETTIMEBASEDVALNTP SQL: CFASTTMBSDVALNTP Type: view_entity CONSUMPTION Package: FINS_FAA_MD_RAP_UI

53 Fields 1 Data Sources 1 OData Services

Fixed Asset Time Based Valuation

C_FixedAssetTimeBasedValnTP is a Consumption CDS View that provides data about "Fixed Asset Time Based Valuation" in SAP S/4HANA. It reads from 1 data source (R_FixedAssetTimeBasedValnTP) and exposes 53 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, Ledger, AssetDepreciationArea. It is exposed through 1 OData service (UI_FIXEDASSET_MANAGE). Part of development package FINS_FAA_MD_RAP_UI.

Data Sources (1)

Source	Alias	Join Type
R_FixedAssetTimeBasedValnTP	R_FixedAssetTimeBasedValnTP	projection

Annotations (8)

Name	Value	Level
AccessControl.auditFilter	#ENABLED	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Fixed Asset Time Based Valuation	view
VDM.viewType	#CONSUMPTION	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MASTER	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_FIXEDASSET_MANAGE	UI_FIXEDASSET_MANAGE	V4	C1	NOT_RELEASED

Fields (53)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	MasterFixedAsset		MasterFixedAsset	Fixed Asset
KEY	FixedAsset		FixedAsset	Sub-number
KEY	Ledger		Ledger	Ledger
KEY	AssetDepreciationArea		AssetDepreciationArea	Deprec. Area
KEY	ValidityEndDate		ValidityEndDate	ValidTo
	ValidityStartDate		ValidityStartDate	Validity Start Date
	DepreciationKey		DepreciationKey
	PlannedUsefulLifeInYears		PlannedUsefulLifeInYears	Planned Use Life Yr.
	PlannedUsefulLifeInPeriods		PlannedUsefulLifeInPeriods
	VariableDeprPercent		VariableDeprPercent
	AcqnProdnCostScrapPercent		AcqnProdnCostScrapPercent
	DeprCalcBaseValuePercent		DeprCalcBaseValuePercent
	ShiftOperationFactor		ShiftOperationFactor
	IsShutDown		IsShutDown
	FixedAssetUsageObject		FixedAssetUsageObject
	FixedAssetUsageObjectDesc	_FixedAssetUsageObject	FixedAssetUsageObjectDesc
	AssetRevaluationIndex		AssetRevaluationIndex
	AssetRevaluationIndexName	_FixedAssetRevaluationIndex	AssetRevaluationIndexName
	DepreciationAreaType		DepreciationAreaType
	ScrapAmountInCoCodeCrcy		ScrapAmountInCoCodeCrcy
	ScrapAmountInGlobCrcy		ScrapAmountInGlobCrcy
	ScrapAmountInFreeDefinedCrcy1		ScrapAmountInFreeDefinedCrcy1
	ScrapAmountInFreeDefinedCrcy2		ScrapAmountInFreeDefinedCrcy2
	ScrapAmountInFreeDefinedCrcy3		ScrapAmountInFreeDefinedCrcy3
	ScrapAmountInFreeDefinedCrcy4		ScrapAmountInFreeDefinedCrcy4
	ScrapAmountInFreeDefinedCrcy5		ScrapAmountInFreeDefinedCrcy5
	ScrapAmountInFreeDefinedCrcy6		ScrapAmountInFreeDefinedCrcy6
	ScrapAmountInFreeDefinedCrcy7		ScrapAmountInFreeDefinedCrcy7
	ScrapAmountInFreeDefinedCrcy8		ScrapAmountInFreeDefinedCrcy8
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
	FreeDefinedCurrency1		FreeDefinedCurrency1	Freely Defined Currency 1
	FreeDefinedCurrency2		FreeDefinedCurrency2	Freely Defined Currency 2
	FreeDefinedCurrency3		FreeDefinedCurrency3	Freely Defined Currency 3
	FreeDefinedCurrency4		FreeDefinedCurrency4	Freely Defined Currency 4
	FreeDefinedCurrency5		FreeDefinedCurrency5	Freely Defined Currency 5
	FreeDefinedCurrency6		FreeDefinedCurrency6	Freely Defined Currency 6
	FreeDefinedCurrency7		FreeDefinedCurrency7	Freely Defined Currency 7
	FreeDefinedCurrency8		FreeDefinedCurrency8	Freely Defined Currency 8
	CompanyCodeCurrencyRoleName
	GlobalCurrencyRoleName
	FreeDefinedCurrency1RoleName
	FreeDefinedCurrency2RoleName
	FreeDefinedCurrency3RoleName
	FreeDefinedCurrency4RoleName
	FreeDefinedCurrency5RoleName
	FreeDefinedCurrency6RoleName
	FreeDefinedCurrency7RoleName
	FreeDefinedCurrency8RoleName
	virtualChartOfDepreciationafapl
	virtualDepreciationKeyNamefis_afatxt
	_FixedAssetredirectedtoC_FixedAssetTP

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_FixedAssetTimeBasedValnTP.
-- 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.
-- SQL view name: CFASTTMBSDVALNTP

CREATE VIEW C_FixedAssetTimeBasedValnTP AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  Ledger,
  AssetDepreciationArea,
  ValidityEndDate,
  ValidityStartDate,
  DepreciationKey,
  PlannedUsefulLifeInYears,
  PlannedUsefulLifeInPeriods,
  VariableDeprPercent,
  AcqnProdnCostScrapPercent,
  DeprCalcBaseValuePercent,
  ShiftOperationFactor,
  IsShutDown,
  FixedAssetUsageObject,
  _FixedAssetUsageObject.FixedAssetUsageObjectDesc AS FixedAssetUsageObjectDesc,
  AssetRevaluationIndex,
  _FixedAssetRevaluationIndex.AssetRevaluationIndexName AS AssetRevaluationIndexName,
  DepreciationAreaType,
  ScrapAmountInCoCodeCrcy,
  ScrapAmountInGlobCrcy,
  ScrapAmountInFreeDefinedCrcy1,
  ScrapAmountInFreeDefinedCrcy2,
  ScrapAmountInFreeDefinedCrcy3,
  ScrapAmountInFreeDefinedCrcy4,
  ScrapAmountInFreeDefinedCrcy5,
  ScrapAmountInFreeDefinedCrcy6,
  ScrapAmountInFreeDefinedCrcy7,
  ScrapAmountInFreeDefinedCrcy8,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  _CurrencyRoles._CompanyCodeCurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS CompanyCodeCurrencyRoleName,
  _CurrencyRoles._GlobalCurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS GlobalCurrencyRoleName,
  _CurrencyRoles._FreeDfndCrcyRole1Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency1RoleName,
  _CurrencyRoles._FreeDfndCrcyRole2Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency2RoleName,
  _CurrencyRoles._FreeDfndCrcyRole3Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency3RoleName,
  _CurrencyRoles._FreeDfndCrcyRole4Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency4RoleName,
  _CurrencyRoles._FreeDfndCrcyRole5Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency5RoleName,
  _CurrencyRoles._FreeDfndCrcyRole6Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency6RoleName,
  _CurrencyRoles._FreeDfndCrcyRole7Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency7RoleName,
  _CurrencyRoles._FreeDfndCrcyRole8Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency8RoleName,
  virtual ChartOfDepreciation : afapl AS virtualChartOfDepreciationafapl,
  virtual DepreciationKeyName : fis_afatxt AS virtualDepreciationKeyNamefis_afatxt
FROM R_FixedAssetTimeBasedValnTP
;

Depth:

C_FixedAssetTimeBasedValnTP view_entity

R_FixedAssetTimeBasedValnTP view_entity