I_FixedAssetUsageObjectPeriod

DDL: I_FIXEDASSETUSAGEOBJECTPERIOD SQL: IFIXASSETUOPERD Type: view BASIC
9 Fields 1 Data Sources 2 Associations

Period Units of Fixed Asset Usage Object

I_FixedAssetUsageObjectPeriod (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_FixedAssetUsageObjectPeriod is a Basic CDS View that provides data about "Period Units of Fixed Asset Usage Object" in SAP S/4HANA. It reads from 1 data source (faat_uo_period) and exposes 9 fields with key fields CompanyCode, FixedAssetUsageObject, ValidityEndDate. It has 2 associations to related views.

SAP Help Documentation

CategoryFixed Asset Usage Object
Purpose
In Asset Accounting, you use usage objects if you use the units-of-production method of depreciation. This CDS view retrieves the records for period units of fixed asset usage objects. This CDS view provides the data to answer the following business question: What is the number of units per period for my fixed asset usage objects? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations The following business catalog needs to be assigned to a user to be able to use this CDS view: Asset Accounting - Usage Object for UoP Depreciation ( SAP_FIN_BC_AA_MDAT_USE_OBJ_PC )

Structure
Fields Used for Filtering The main filter is as follows: CompanyCode : This filter is used to identify the number of units per period for fixed asset usage objects within a specific company code. Further Important Fields Important fields in this view include the following: Field Name Description CompanyCode Company code FixedAssetUsageObject Fixed asset usage object number ValidityEndDate Valid-to date for the period PeriodPlannedQtyInProdnUnit Planned number of units per period BaseUnit Base unit of measure

More Information
For more information about usage objects, see the application help (product assistance) for Asset Accounting under Maintain Number of Units for UoP Depreciation . For general information about analytics, see Analytics .

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-AA
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
faat_uo_period _UsageObjectPeriod from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_FixedAssetUsageObject _UsageObject $projection.CompanyCode = _UsageObject.CompanyCode and $projection.FixedAssetUsageObject = _UsageObject.FixedAssetUsageObject
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IFIXASSETUOPERD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
EndUserText.label Period Units of Fixed Asset Usage Object view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode comp_code Procuring Comp. Cde
KEY FixedAssetUsageObject usage_object Usage Object
KEY ValidityEndDate valid_to_date Date Validity Ends
ValidityStartDate valid_from_date Date for Beginning of Validity
PeriodPlannedQtyInProdnUnit period_units Planned Number of Units in the Period
BaseUnit _UsageObject BaseUnit Base Unit of Measure
_CompanyCode _CompanyCode
_UnitOfMeasure _UsageObject _UnitOfMeasure
_UsageObject _UsageObject

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 I_FixedAssetUsageObjectPeriod.
-- 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: IFIXASSETUOPERD

CREATE VIEW I_FixedAssetUsageObjectPeriod AS
SELECT
  comp_code AS CompanyCode,
  usage_object AS FixedAssetUsageObject,
  valid_to_date AS ValidityEndDate,
  valid_from_date AS ValidityStartDate,
  period_units AS PeriodPlannedQtyInProdnUnit,
  _UsageObject.BaseUnit AS BaseUnit,
  _UsageObject._UnitOfMeasure AS _UnitOfMeasure
FROM faat_uo_period AS _UsageObjectPeriod
LEFT OUTER JOIN I_FixedAssetUsageObject AS _UsageObject ON CompanyCode = _UsageObject.CompanyCode AND FixedAssetUsageObject = _UsageObject.FixedAssetUsageObject  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More