What is C_GlobAssetTimeBasedValnTP in SAP S/4HANA?

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

Which tables does C_GlobAssetTimeBasedValnTP read from?

C_GlobAssetTimeBasedValnTP reads data from: I_GlobAssetTimeBasedValnTP.

What VDM layer is C_GlobAssetTimeBasedValnTP?

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

C_GlobAssetTimeBasedValnTP

DDL: C_GLOBASSETTIMEBASEDVALNTP SQL: CGASTTMBSDVALNTP Type: view CONSUMPTION Package: GLO_FIN_FAA_GEN

53 Fields 1 Data Sources 3 Associations

CSMD Time Based Valuation of Asset

C_GlobAssetTimeBasedValnTP is a Consumption CDS View that provides data about "CSMD Time Based Valuation of Asset" in SAP S/4HANA. It reads from 1 data source (I_GlobAssetTimeBasedValnTP) and exposes 53 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, ValidityEndDate, Ledger. It has 3 associations to related views. Part of development package GLO_FIN_FAA_GEN.

Data Sources (1)

Source	Alias	Join Type
I_GlobAssetTimeBasedValnTP	_GlobAssetTimeBasedValnTP	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	C_AssetTP	_AssetTP	`$projection.CompanyCode = _AssetTP.CompanyCode and $projection.MasterFixedAsset = _AssetTP.MasterFixedAsset and $projection.FixedAsset = _AssetTP.FixedAsset`
[1..1]	C_AssetValuationTP	_AssetValuationTP	`$projection.CompanyCode = _AssetValuationTP.CompanyCode and $projection.MasterFixedAsset = _AssetValuationTP.MasterFixedAsset and $projection.FixedAsset = _AssetValuationTP.FixedAsset and $projection.Ledger = _AssetValuationTP.Ledger and $projection.AssetDepreciationArea = _AssetValuationTP.AssetDepreciationArea`
[0..1]	I_LedgerCompanyCodeCrcyRoles	_CurrencyRoles	`$projection.CompanyCode = _CurrencyRoles.CompanyCode and $projection.Ledger = _CurrencyRoles.Ledger`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	CGASTTMBSDVALNTP	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	CSMD Time Based Valuation of Asset	view
VDM.viewType	#CONSUMPTION	view
Search.searchable	false	view
Metadata.allowExtensions	true	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MASTER	view

Fields (53)

Key	Field	Source Field	Description
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	MasterFixedAsset	MasterFixedAsset	Fixed Asset
KEY	FixedAsset	FixedAsset	Sub-number
KEY	ValidityEndDate	ValidityEndDate	ValidTo
KEY	Ledger	Ledger	Ledger
KEY	AssetDepreciationArea	AssetDepreciationArea	Deprec. Area
	ValidityEndDateForEdit	ValidityEndDateForEdit	Valid To
	ValidityStartDate	ValidityStartDate	Validity Start Date
	JP_ImpairmentPostingDate	JP_ImpairmentPostingDate
	JP_ImpAcqnProdCostAmtInCCCrcy	JP_ImpAcqnProdCostAmtInCCCrcy
	JP_ImpAcqnProdCostAmtInGCrcy	JP_ImpAcqnProdCostAmtInGCrcy
	JP_ImpAcqnProdCostAmtInFDCrcy1	JP_ImpAcqnProdCostAmtInFDCrcy1
	JP_ImpAcqnProdCostAmtInFDCrcy2	JP_ImpAcqnProdCostAmtInFDCrcy2
	JP_ImpAcqnProdCostAmtInFDCrcy3	JP_ImpAcqnProdCostAmtInFDCrcy3
	JP_ImpAcqnProdCostAmtInFDCrcy4	JP_ImpAcqnProdCostAmtInFDCrcy4
	JP_ImpAcqnProdCostAmtInFDCrcy5	JP_ImpAcqnProdCostAmtInFDCrcy5
	JP_ImpAcqnProdCostAmtInFDCrcy6	JP_ImpAcqnProdCostAmtInFDCrcy6
	JP_ImpAcqnProdCostAmtInFDCrcy7	JP_ImpAcqnProdCostAmtInFDCrcy7
	JP_ImpAcqnProdCostAmtInFDCrcy8	JP_ImpAcqnProdCostAmtInFDCrcy8
	JP_AftImprmtBookAmtInCCCrcy	JP_AftImprmtBookAmtInCCCrcy
	JP_AftImprmtBookAmtInGlobCrcy	JP_AftImprmtBookAmtInGlobCrcy
	JP_AftImprmtBookAmtInFDCrcy1	JP_AftImprmtBookAmtInFDCrcy1
	JP_AftImprmtBookAmtInFDCrcy2	JP_AftImprmtBookAmtInFDCrcy2
	JP_AftImprmtBookAmtInFDCrcy3	JP_AftImprmtBookAmtInFDCrcy3
	JP_AftImprmtBookAmtInFDCrcy4	JP_AftImprmtBookAmtInFDCrcy4
	JP_AftImprmtBookAmtInFDCrcy5	JP_AftImprmtBookAmtInFDCrcy5
	JP_AftImprmtBookAmtInFDCrcy6	JP_AftImprmtBookAmtInFDCrcy6
	JP_AftImprmtBookAmtInFDCrcy7	JP_AftImprmtBookAmtInFDCrcy7
	JP_AftImprmtBookAmtInFDCrcy8	JP_AftImprmtBookAmtInFDCrcy8
	CompanyCodeCurrency
	CompanyCodeCurrencyRoleName
	GlobalCurrency
	GlobalCurrencyRoleName
	FreeDefinedCurrency1
	FreeDefinedCurrency1RoleName
	FreeDefinedCurrency2
	FreeDefinedCurrency2RoleName
	FreeDefinedCurrency3
	FreeDefinedCurrency3RoleName
	FreeDefinedCurrency4
	FreeDefinedCurrency4RoleName
	FreeDefinedCurrency5
	FreeDefinedCurrency5RoleName
	FreeDefinedCurrency6
	FreeDefinedCurrency6RoleName
	FreeDefinedCurrency7
	FreeDefinedCurrency7RoleName
	FreeDefinedCurrency8
	FreeDefinedCurrency8RoleName
	SK_CapitalImprovementYear	SK_CapitalImprovementYear
	_AssetTP	_AssetTP
	_AssetValuationTP	_AssetValuationTP
	_CurrencyRoles	_CurrencyRoles

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_GlobAssetTimeBasedValnTP.
-- 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: CGASTTMBSDVALNTP

CREATE VIEW C_GlobAssetTimeBasedValnTP AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  ValidityEndDate,
  Ledger,
  AssetDepreciationArea,
  ValidityEndDateForEdit,
  ValidityStartDate,
  JP_ImpairmentPostingDate,
  JP_ImpAcqnProdCostAmtInCCCrcy,
  JP_ImpAcqnProdCostAmtInGCrcy,
  JP_ImpAcqnProdCostAmtInFDCrcy1,
  JP_ImpAcqnProdCostAmtInFDCrcy2,
  JP_ImpAcqnProdCostAmtInFDCrcy3,
  JP_ImpAcqnProdCostAmtInFDCrcy4,
  JP_ImpAcqnProdCostAmtInFDCrcy5,
  JP_ImpAcqnProdCostAmtInFDCrcy6,
  JP_ImpAcqnProdCostAmtInFDCrcy7,
  JP_ImpAcqnProdCostAmtInFDCrcy8,
  JP_AftImprmtBookAmtInCCCrcy,
  JP_AftImprmtBookAmtInGlobCrcy,
  JP_AftImprmtBookAmtInFDCrcy1,
  JP_AftImprmtBookAmtInFDCrcy2,
  JP_AftImprmtBookAmtInFDCrcy3,
  JP_AftImprmtBookAmtInFDCrcy4,
  JP_AftImprmtBookAmtInFDCrcy5,
  JP_AftImprmtBookAmtInFDCrcy6,
  JP_AftImprmtBookAmtInFDCrcy7,
  JP_AftImprmtBookAmtInFDCrcy8,
  _CurrencyRoles._CoCodeCurrencyRoleCurrency.Currency AS CompanyCodeCurrency,
  _CurrencyRoles._CoCodeCurrencyRoleCurrency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS CompanyCodeCurrencyRoleName,
  _CurrencyRoles._GlobalCurrencyRoleCurrency.Currency AS GlobalCurrency,
  _CurrencyRoles._GlobalCurrencyRoleCurrency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS GlobalCurrencyRoleName,
  _CurrencyRoles._FreeDfndCrcyRole1Currency.Currency AS FreeDefinedCurrency1,
  _CurrencyRoles._FreeDfndCrcyRole1Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency1RoleName,
  _CurrencyRoles._FreeDfndCrcyRole2Currency.Currency AS FreeDefinedCurrency2,
  _CurrencyRoles._FreeDfndCrcyRole2Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency2RoleName,
  _CurrencyRoles._FreeDfndCrcyRole3Currency.Currency AS FreeDefinedCurrency3,
  _CurrencyRoles._FreeDfndCrcyRole3Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency3RoleName,
  _CurrencyRoles._FreeDfndCrcyRole4Currency.Currency AS FreeDefinedCurrency4,
  _CurrencyRoles._FreeDfndCrcyRole4Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency4RoleName,
  _CurrencyRoles._FreeDfndCrcyRole5Currency.Currency AS FreeDefinedCurrency5,
  _CurrencyRoles._FreeDfndCrcyRole5Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency5RoleName,
  _CurrencyRoles._FreeDfndCrcyRole6Currency.Currency AS FreeDefinedCurrency6,
  _CurrencyRoles._FreeDfndCrcyRole6Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency6RoleName,
  _CurrencyRoles._FreeDfndCrcyRole7Currency.Currency AS FreeDefinedCurrency7,
  _CurrencyRoles._FreeDfndCrcyRole7Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency7RoleName,
  _CurrencyRoles._FreeDfndCrcyRole8Currency.Currency AS FreeDefinedCurrency8,
  _CurrencyRoles._FreeDfndCrcyRole8Currency._CurrencyRole._Text[1:Language=$session.system_language].CurrencyRoleName AS FreeDefinedCurrency8RoleName,
  SK_CapitalImprovementYear
FROM I_GlobAssetTimeBasedValnTP AS _GlobAssetTimeBasedValnTP
LEFT OUTER JOIN C_AssetTP AS _AssetTP ON CompanyCode = _AssetTP.CompanyCode AND MasterFixedAsset = _AssetTP.MasterFixedAsset AND FixedAsset = _AssetTP.FixedAsset  -- association [1..1]
LEFT OUTER JOIN C_AssetValuationTP AS _AssetValuationTP ON CompanyCode = _AssetValuationTP.CompanyCode AND MasterFixedAsset = _AssetValuationTP.MasterFixedAsset AND FixedAsset = _AssetValuationTP.FixedAsset AND Ledger = _AssetValuationTP.Ledger AND AssetDepreciationArea = _AssetValuationTP.AssetDepreciationArea  -- association [1..1]
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoles AS _CurrencyRoles ON CompanyCode = _CurrencyRoles.CompanyCode AND Ledger = _CurrencyRoles.Ledger  -- association [0..1]
;

Depth:

C_GlobAssetTimeBasedValnTP view

I_GlobAssetTimeBasedValnTP view