I_FixedAssetUsageObjectTotal

DDL: I_FIXEDASSETUSAGEOBJECTTOTAL SQL: IFIXASSETUOTOTAL Type: view BASIC Package: FINS_FAA_UO_VDM

Total Units of Fixed Asset Usage Object

I_FixedAssetUsageObjectTotal (Basic)

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

Accounting and Financial Close

I_FixedAssetUsageObjectTotal is a Basic CDS View that provides data about "Total Units of Fixed Asset Usage Object" in SAP S/4HANA. It reads from 1 data source (faat_uo_total) and exposes 10 fields with key fields CompanyCode, FixedAssetUsageObject, FixedAssetUsageObjectDeprArea, ValidityEndDate. It has 2 associations to related views. Part of development package FINS_FAA_UO_VDM.

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 total units of fixed asset usage objects. This CDS view provides the data to answer the following business question: What is the total number of units 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 total number of units 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 FixedAssetUsageObjectDeprArea Depreciation area ValidityEndDate Valid-to date for the period CapacityInProductionUnit Total number of units expected as of this 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

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-AA-2CL
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>In Asset Accounting, you use usage objects if you use the units-of-production method of depreciation. This CDS view retrieves the records for total units of fixed asset usage objects.</p> This CDS view provides the data to answer the following business question:<ul> <li> <p>What is the total number of units for my fixed asset usage objects?</p> </li> </ul> <p>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.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
faat_uo_total UsageObjectTotal 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 (11)

NameValueLevelField
AbapCatalog.sqlViewName IFIXASSETUOTOTAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Total Units of Fixed Asset Usage Object view
VDM.viewType #BASIC 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 (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode comp_code Procuring Comp. Cde
KEY FixedAssetUsageObject usage_object Usage Object
KEY FixedAssetUsageObjectDeprArea depr_area Depreciation Area (incl. Generic Entry)
KEY ValidityEndDate valid_to_date Date Validity Ends
ValidityStartDate valid_from_date Date for Beginning of Validity
CapacityInProductionUnit total_units Total Units Expected as of This 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_FixedAssetUsageObjectTotal.
-- 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: IFIXASSETUOTOTAL

CREATE VIEW I_FixedAssetUsageObjectTotal AS
SELECT
  comp_code AS CompanyCode,
  usage_object AS FixedAssetUsageObject,
  depr_area AS FixedAssetUsageObjectDeprArea,
  valid_to_date AS ValidityEndDate,
  valid_from_date AS ValidityStartDate,
  total_units AS CapacityInProductionUnit,
  _UsageObject.BaseUnit AS BaseUnit,
  _UsageObject._UnitOfMeasure AS _UnitOfMeasure
FROM faat_uo_total AS UsageObjectTotal
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]
;