A_FixedAssetTimeBasedValuation

DDL: A_FIXEDASSETTIMEBASEDVALUATION Type: view_entity CONSUMPTION Package: FINS_FAA_MD_RAP_API
40 Fields 1 Data Sources 2 OData Services

Fixed Asset Time-based Valuation

A_FixedAssetTimeBasedValuation 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 40 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, Ledger, AssetDepreciationArea. It is exposed through 2 OData services (API_FIXEDASSET, ASQL_F8749). Part of development package FINS_FAA_MD_RAP_API.

Data Sources (1)

SourceAliasJoin Type
R_FixedAssetTimeBasedValnTP R_FixedAssetTimeBasedValnTP projection

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Fixed Asset Time-based Valuation view
OData.entityType.name FixedAssetTimeBasedValuation_Type view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view

OData Services (2)

ServiceBindingVersionContractRelease
API_FIXEDASSET API_FIXEDASSET V4 C2 C1
ASQL_F8749 ASQL_F8749 C2 NOT_RELEASED

Fields (40)

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
PlannedUsefulLifeInYears PlannedUsefulLifeInYears Planned Use Life Yr.
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods
VariableDeprPercent VariableDeprPercent
AcqnProdnCostScrapPercent AcqnProdnCostScrapPercent
DeprCalcBaseValuePercent DeprCalcBaseValuePercent
ShiftOperationFactor ShiftOperationFactor
IsShutDown IsShutDown
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
FunctionalCurrency FunctionalCurrency Functional Currency
FixedAssetUsageObject FixedAssetUsageObject
AssetRevaluationIndex AssetRevaluationIndex
DepreciationAreaType DepreciationAreaType
_FixedAssetredirectedtoA_FixedAsset

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 A_FixedAssetTimeBasedValuation.
-- 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 A_FixedAssetTimeBasedValuation 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,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  FunctionalCurrency,
  FixedAssetUsageObject,
  AssetRevaluationIndex,
  DepreciationAreaType
FROM R_FixedAssetTimeBasedValnTP
;

Learn More