R_FixedAssetTimeBasedValnTP

DDL: R_FIXEDASSETTIMEBASEDVALNTP Type: view_entity TRANSACTIONAL Package: FINS_FAA_MD_RAP_BO
44 Fields 1 Data Sources 2 Associations

Fixed Asset Time-based Valuation

R_FixedAssetTimeBasedValnTP is a Transactional CDS View that provides data about "Fixed Asset Time-based Valuation" in SAP S/4HANA. It reads from 1 data source (I_AssetTimeBasedValuation) and exposes 44 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, Ledger, AssetDepreciationArea. It has 2 associations to related views. Part of development package FINS_FAA_MD_RAP_BO.

Data Sources (1)

SourceAliasJoin Type
I_AssetTimeBasedValuation I_AssetTimeBasedValuation from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_FixedAssetTP _FixedAsset $projection.CompanyCode = _FixedAsset.CompanyCode and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset
[1..1] I_LedgerCompanyCodeCrcyRoles _CurrencyRoles $projection.CompanyCode = _CurrencyRoles.CompanyCode and $projection.Ledger = _CurrencyRoles.Ledger

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Fixed Asset Time-based Valuation view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (44)

KeyFieldSource TableSource FieldDescription
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 Dep. key
PlannedUsefulLifeInYears PlannedUsefulLifeInYears Planned Use Life Yr.
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods Periods
VariableDeprPercent VariableDeprPercent Var.dep.portion
AcqnProdnCostScrapPercent AcqnProdnCostScrapPercent Scrap Value %
DeprCalcBaseValuePercent DeprCalcBaseValuePercent Percentage
ShiftOperationFactor ShiftOperationFactor Shift Factor
IsShutDown IsShutDown Shutdown
ScrapAmountInCoCodeCrcy ScrapAmountInCoCodeCrcy Value in CompCd Crcy
ScrapAmountInGlobCrcy ScrapAmountInGlobCrcy Value in Gl. Crcy
ScrapAmountInFreeDefinedCrcy1 ScrapAmountInFreeDefinedCrcy1 Value in Currency 1
ScrapAmountInFreeDefinedCrcy2 ScrapAmountInFreeDefinedCrcy2 Value in Currency 2
ScrapAmountInFreeDefinedCrcy3 ScrapAmountInFreeDefinedCrcy3 Value in Currency 3
ScrapAmountInFreeDefinedCrcy4 ScrapAmountInFreeDefinedCrcy4 Value in Currency 4
ScrapAmountInFreeDefinedCrcy5 ScrapAmountInFreeDefinedCrcy5 Value in Currency 5
ScrapAmountInFreeDefinedCrcy6 ScrapAmountInFreeDefinedCrcy6 Value in Currency 6
ScrapAmountInFreeDefinedCrcy7 ScrapAmountInFreeDefinedCrcy7 Value in Currency 7
ScrapAmountInFreeDefinedCrcy8 ScrapAmountInFreeDefinedCrcy8 Value in Currency 8
CompanyCodeCurrency
GlobalCurrency
FreeDefinedCurrency1
FreeDefinedCurrency2
FreeDefinedCurrency3
FreeDefinedCurrency4
FreeDefinedCurrency5
FreeDefinedCurrency6
FreeDefinedCurrency7
FreeDefinedCurrency8
FunctionalCurrency
FixedAssetUsageObject FixedAssetUsageObject Usage Object
AssetRevaluationIndex AssetRevaluationIndex
DepreciationAreaType DepreciationAreaType Calc. View Type
_FixedAsset _FixedAsset
_FixedAssetValuation _FixedAssetValuation
_FixedAssetUsageObject _FixedAssetUsageObject
_FixedAssetRevaluationIndex _FixedAssetRevaluationIndex
_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 R_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.

CREATE VIEW R_FixedAssetTimeBasedValnTP AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  Ledger,
  AssetDepreciationArea,
  ValidityEndDate,
  ValidityStartDate,
  DepreciationKey,
  PlannedUsefulLifeInYears,
  PlannedUsefulLifeInPeriods,
  VariableDeprPercent,
  AcqnProdnCostScrapPercent,
  DeprCalcBaseValuePercent,
  ShiftOperationFactor,
  IsShutDown,
  ScrapAmountInCoCodeCrcy,
  ScrapAmountInGlobCrcy,
  ScrapAmountInFreeDefinedCrcy1,
  ScrapAmountInFreeDefinedCrcy2,
  ScrapAmountInFreeDefinedCrcy3,
  ScrapAmountInFreeDefinedCrcy4,
  ScrapAmountInFreeDefinedCrcy5,
  ScrapAmountInFreeDefinedCrcy6,
  ScrapAmountInFreeDefinedCrcy7,
  ScrapAmountInFreeDefinedCrcy8,
  _CurrencyRoles._CoCodeCurrencyRoleCurrency.Currency AS CompanyCodeCurrency,
  _CurrencyRoles._GlobalCurrencyRoleCurrency.Currency AS GlobalCurrency,
  _CurrencyRoles._FreeDfndCrcyRole1Currency.Currency AS FreeDefinedCurrency1,
  _CurrencyRoles._FreeDfndCrcyRole2Currency.Currency AS FreeDefinedCurrency2,
  _CurrencyRoles._FreeDfndCrcyRole3Currency.Currency AS FreeDefinedCurrency3,
  _CurrencyRoles._FreeDfndCrcyRole4Currency.Currency AS FreeDefinedCurrency4,
  _CurrencyRoles._FreeDfndCrcyRole5Currency.Currency AS FreeDefinedCurrency5,
  _CurrencyRoles._FreeDfndCrcyRole6Currency.Currency AS FreeDefinedCurrency6,
  _CurrencyRoles._FreeDfndCrcyRole7Currency.Currency AS FreeDefinedCurrency7,
  _CurrencyRoles._FreeDfndCrcyRole8Currency.Currency AS FreeDefinedCurrency8,
  _CurrencyRoles._FunctionalCrcyRoleCurrency.Currency AS FunctionalCurrency,
  FixedAssetUsageObject,
  AssetRevaluationIndex,
  DepreciationAreaType
FROM I_AssetTimeBasedValuation
LEFT OUTER JOIN R_FixedAssetTP AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [1..1]
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoles AS _CurrencyRoles ON CompanyCode = _CurrencyRoles.CompanyCode AND Ledger = _CurrencyRoles.Ledger  -- association [1..1]
;

Learn More